Good afternoon!
I'm creating an app in 'My Community Edition Site', Appian Version:22.2. I'm using the plug-in Excel Tools, Import CSV to Database v6.
When creating the process, everything is working but the data is not being updated to the database, CDT or record list.
I'm going to attach all the evidences for you to understand and find the problem with me because I don't know what else to do, I've tried many different things, some told me to review the data types or the table name The CSV has 3 rows, the header and 2 similar to the picture. If I insert the data in the Could ddbb manually it works perfectly, but it would be better if the process works and I won't need to do 30 inserts.
Thanks in advance! Rony-Michelle ;)
Discussion posts and replies are publicly visible
Here's two things you can try - 1. I think the table name needs to be a reference to your table, what you have passed is the CDT type.2. If it still doesn't work check the tomcat-stdOut.log which will give you more info on what the error actually is so you'll have an idea of what's gone wrong.
What would be a reference to my table?
I have a friend working with an old version of the same plugin and uses that CDT expression in the table name and it works :(
I think that's not the problem because it shows the columns of my table
Use the concrete name of the table for this field. This smart service directly talks to the database and has nothing to do with CDTs, data stores or Records
I don't know how to write the expression