Import CSV to Database Plugin

Hello, 

I am trying to import users from CSV (one time thing) to a CDT in Database and would like to use 'Create User Smart Service' to create users in Appian. I created a process model with a process variable of document which I uploaded to documents folder on existing knowledge center (as a test case) and using 'Imprt CSV to Database' from Excel plugin tools. However, I do see an error with my process model on the items referenced. 

Below is what I have used: 

1. Datasource name : ="jdbc/AppianDS"

2. Delimiter: =","

3. Table Name:  ="BPM_USERS_EXPORT_TBL" (value of CDT and the table name in DB)

I did not configure any outputs as I would like to loop through CDT records later in the model if atleast a record exists.  I can see my document being referenced but not sure how to debug the issue with other referenced items. I tried using a constant that references my CDT instead and it did not error out but I don't see records in the database.

Any suggestions on how to use the plugin correctly?

 

Thanks

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data