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
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.