Export SQL to Excel Smart Service for multiple sheets

marcoc918

A Score Level 1

over 8 years ago

Hi,

we need to extract data from our db from 2 different tables and inserting them in 2 different sheets of an excel template.

I have created the excel template with the 2 sheets, and I have created a simple process model with 2 Export SQL to Excel Smart Service:

1. The first one extract the data from the first table, fill the first sheets of the excel template, save the document on the Temporary Documents folder and within the Process Model on the pv!output_document

2.The second one should use this output_document as template, extract the data from the DB and fill the Excel. To do so I have set as:

Document_to_overwrite: pv!output_document

Excel_base_template: pv!output_document because it is necessary to use the generated excel of the first step as new template

but something goes wrong and the Alert is this:

There is a problem with task “Copy of Export SQL to Excel” in the process ...

Discussion posts and replies are publicly visible

0 marcoc918
A Score Level 1
over 8 years ago

...“provaExcel”. The following error was raised by the Export to Excel function: /opt/appian/_admin/accdocs2/8/10023067.xlsx (No such file or directory)

any suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sally Mason
Appian Employee
over 8 years ago

Are you able to find the document in <APPIAN_HOME>/appian/_admin/accdocs2/8/10023067.xlsx ? Is that file actually the template file? If it is the template, you need to generate a new file based on the template and not overwrite the existing file. There is also a readme file attached to the Excel Tools shared component page (forum.appian.com/.../summary ):
"Document_to_overwrite If a document generated should overwrite another existing document, use this.
Useful if you are invoking this to write to different sheets of an excel document.
Excel_base_template The excel template on which the output will be written to.. "
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 marcoc918
A Score Level 1
over 8 years ago

No i cannot find this document, but i cannot understand why.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sally Mason
Appian Employee
over 8 years ago

I would suggest installing the sample app "DataSubsetDownload Example (16.2).zip" available (if not already installed) from the plugins page and seeing if you are able to configure the test process to run?

Unfortunately, if the base template is not found or set (Excel_Base_Template), the process cannot complete. If the above fails, try uninstalling then reinstalling the plugin?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel