Import CSV to Database - Column Name

Hi vishalk263 ,

Column name parameter is not required if you want to get all the columns please leave it blank only.

Thanks,
Sandeep

Hi Sandeep - I am writing into DB using CSV file not reading. Column name parameter is mandatory when you have given File does not have header.

Hi Vishal, Even I am talking about same. I have already used (V3) and it is working perfectly.

Thanks,
Sandeep

 

It throws error if Column Names are not present 

Hi Vishal, please pass column names as text(comma separated) and not as array i.e "COL1, COL2". No need of curly braces.

I had tried that option as well but it gives java.lang.ArrayIndexOutOfBoundsException. I am using V4 of the smart service.

Hi Vishal, it could be a plugin issue. I investigated for ArrayIndexOutOfBounds:0 and found that- 

1. If encrypted columns input is passed as null, within the code this is initialized by true/false based on the count of columns we provide in excel indicating if a column is encrypted or not. 

2. When we set header false the variable is not initialized to correct length and while inserting to DB(insert function of Database Utils) it directly uses the index value of null variable which results in error.

for (int i = 0; i < values_.length; i++) {
			if(columnEncryptedFlags_[i]) {
				values_[i]=es.decrypt(new TypedValue((long) AppianType.ENCRYPTED_TEXT, values_[i])); 
			}
			...}

3. It is initialized properly when header is set to true.

 

I believe updating this should fix this error. You can raise a request with Appian to update plugin if you choose to use it further.

 

Thanks,

Chitra

 

Hi Vishal,

Am facing similar kind of issue(java.lang.ArrayIndexOutOfBoundsException) with the smart service "Import CSV to Database v4" while importing csv but with attribute "file has header" set to "true". Weird part is same csv file works with "Import Database Data from CSV" smart service but this is deprecated.

Could you please suggest if you have faced similar using this V4 smart service.

Regards,
Sandhya