I am trying to user the Parse Excel Spreadsheet to CDT plugin. I am using a Use

lesliem over 9 years ago

I am trying to user the Parse Excel Spreadsheet to CDT plugin. I am using a User Input screen to select the file to import but when I use that document in the plugin I get an error:
Can't open the specified file: 'C:\\Users\\BPD_AP~1\\AppData\\Local\\Temp\\poifiles\\poi-ooxml-762810725.tmp'

Does Appian use this folder temporarily for holding the file. When I upload the file I have a folder the file is saved to within Appian and the file is there. But it doesn't appear the plugin is using the file and location. Any help would be appreciated....

Discussion posts and replies are publicly visible

0 Alok Mohare
Appian Employee
over 9 years ago

Hi Leslie,

The Smart Service currently supports only *.xlsx files.

If you use the *.xls file or any other Excel format, the Smart Service will throw the Error that you have been experiencing. In order to make this work, you need to create a new Excel file with the data from the previous one and save it as a *.xlsx file. Upload this Excel file to the System Knowledge Center and then re-map your process to use this new *.xlsx file.

Let me know if this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lesliem over 9 years ago

Thank you so much for your help, that was the problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lesliem over 9 years ago

I am so close. That error is fixed with the new file format. But now the plugin won't import anything and there is no error. I have the column headers the exact same as the field names including case sensitivity.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alok Mohare
Appian Employee
over 9 years ago

Hi Lesli,

I would recommend checking your app-server log for more details as to why nothing was populated in the CDT fields. There will typically be a stack trace with a "Caused by" clause that describes the root cause of the Error.

Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lesliem over 9 years ago

Thanks Alok, I have checked the app-server log and when I run the process it is getting a NullPointerException. Although it's telling me there is an error. Doesn't really tell me what's wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel