Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
I'm building a small PoC where i need to write to an Excel spreadsheet. i need to save my data in certain cells positions.Everything i'm finding points me to use the Export dataStore to Excel Smart service and to specify those cells positions in the node input using the twocustom cell position / custom cell values.My problem is i don't have a CDT to load from, this is a purely sync records PoC. do I really have to build a CDT structure to get this to work ?
Discussion posts and replies are publicly visible
From what I saw, it seems like the Export DSE to Excel Smart Service is the recommended approach at this time - the alternative being the Export SQL to Excel Plug-in. It shouldn't be too difficult to build out the CDT if you already have the record type though. You can select "Create from database table or view" when creating the CDT and just reference the table associated with the Record Type. You can create the DSE at the same time.
When you say you are using purely synced records - are you talking about pulling data from an external system like Salesforce, or synced records from an internal database?