Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Hi,
Is there any way to avoid the duplicate ingestion of csv data into database. Suppose second file contains the duplicate data compared to the first one, is there any way to ensure that the duplicate data do not append.
Regards,
Dushyant
you'd better set your "row number" columns in database auto_increment and then when it runs smart service it will automatically insert incremented values for each row in your table
Hi
Is there a way when usiing the import CSV to Database smart service and want to include a "row number" in the target database in order to show which row of the csv the data was imported from?
The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs
Or
Is it better to just update the target database row number field after the import is completed ?
Regards
Hello, is it possible to fix the not happy flow ? (error handling in case of malformed excel workbook)
Hello, when we have a malformed excel workbook ( worng columns), the error handling doesn't work as expected. Is it possible to fix the not happy flow behaviour ?
Hi, Did you ever find a solution to this? Facing the same issue.
Does the Import CSV to Database smart service will ignore the empty column name present in the csv file ??
Example: columns specified :A,B,C,D,E
columns present in file: A,B, ,C, ,D,E
nareshs7984 ,To further address the described bug, we suggest utilizing the Feedback feature to report this issue directly to the AppMarket team. Thanks.
Mike Cichy Peter Lewis Appian AppMarket April Schuppel who should we contact regarding the above mentioned plugin issue. Not sure who is the owner of this plugin from Appian side. What I see here no one is responding from Appian side for community member issue questions since last 10 months. Is any one from Appian is supporting this plugin?
Our project is impacted with the above mentioned. It would be great if some one review and fix this issue