I have install the following plugin:
Excel Tools (v2.2.6) [com.appiancorp.ps.exceltools] plugin
as you can see it is suppose to have the following smart services: Parse Excel Spreadsheet to CDT
but when I got to a process model it does not seem to be there. Is there anything else wrong I am doing?
Discussion posts and replies are publicly visible
I can second that I don't see it grouped with the other smart excel services - But it is revealed when you search for parse; from there you can drag it on the canvas.Now, get back to work! :-)
good guess, but I have try it and is not there
It wasn't a guess - that actually works for me.
I'm sorry you're not seeing the same thing.
I believe I tested against the same version of the plugin, on 19.4.
Not being able to reproduce your issue makes it harder for me to help. Was it ever there? did you just deploy this plugin?
No problem! Appreciate your help, I am not sure if it was there before I just want to read a file and converted to a CDT. It can be any kind of file.Do you think the plugin needs to be reinstalled?
I'm tempted to say give it a try - which is what I would do if I were managing a local/on-prem install.
I hesitate to give this advice because it the impact it could have on your system for the duration while it's missing.
generic systematic file readers can be a trouble spot.
in this area, best to encourage as much structure and predictability in your files, and perhaps design different ingestion configurations per file type.
The node is hard to find on purpose - it is under the Deprecated category. The smart service can cause high load on the engines and is not recommended to use. Please use CSV to DB node instead and then read the data you need into your process.
What is the recommended approach for the case of UPDATE existing database rows from an excel document? I see that "Import Excel to Database" Appian Smart Service appears to only support INSERT of new rows.
The recommended pattern I would recommend for any file ingestion is to stage the data first, then process it. A sample implementation could consist of a staging table that is wiped before every load, then a stored procedure is called to process the data based on existing data and necessary logic.
© 2023 Appian. All rights reserved.