what should i fill in each blank of smart service in process model, or in interface smart service code?
Discussion posts and replies are publicly visible
This is part of the Excel Tools plugin (https://community.appian.com/b/appmarket/posts/excel-tools#) and a readme PDF is available in the download. As of version 2.2.16 the readme provides the following info on the inputs to the smart service.
what is delimiter?
CSV stands for Comma Separated Values as traditionally the delimiter is a comma. It doesn't *have* to be though. So it's the character (Or characters? Never tried with more than one character) that separates your values in the CSV.
I am still idiotic fill in what value in each of corresponding field, though it gives explaination but quite equivocal.
Don't include quotation marks (eg. "), they are just there to be specific in what the value is.
CSV Doc: The CSV document to be saved to the database
Data Source Name: "jdbc/<Database Name>" (Mine is "jdbc/Appian")
Delimiter: "," (If your CSV is comma separated)
File Has Header: True (mine has headers so it's true)
Table Name: The name of the table in the database where the data from the CSV needs to go
can you read for me which one i fill is incorrect?
i doubt csv doc and table should be type of constant right?
error report index:1 size:1
No, they can definitely be in constants but make sure the data type is correct (eg. Table Name is of type Text and CSV is of type Document). In fact, your table name should probably be in a constant. The CSV document is unlikely to be in a constant but would be fine for testing.
I just figure out my document type is excel, so i switch function to import excel into database, however it report index:1,size:1 as error.
Do you have a screenshot?
I would recommend starting with just getting a single line in your CSV to upload to minimise issues as it appears the errors given don't give a lot to go on. Let me know how you go.
my document type is excel,may i know what to fill in the sheetnumber parameter?
Not sure if the sheet number starts with 0 or 1. Do you only have one sheet? If sheet number 1 isn't working just try 0.
seems it got some changes. But do you get an idea for this, seems i miss something
What's your table name and data source name?
the table name is the constant of datastore entity sub belonging table, data source i just like yours jdbc/appian,because i use appian database.
Table name is text not datastore entity. Literally use the text name of the table (eg. "APN_TableName")
ajhick said: "APN_TableName"
table name should be appian database table name or the datatype name?