Skip to main content
S
sahilb8348
October 25, 2022
Question

Need to Import CSV file with header and footer by using Import CSV to Database V6

  • October 25, 2022
  • 3 replies
  • 0 views

Hello All,

My requirement is client is sending an csv file to Appian which we need to insert in Appian table.

I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer.

Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that.

But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself.

Thanks in advance

Regards

Sahil Batra

3 replies

U
ujjwalr0002
October 26, 2022

Hi, I don't think we have any function or smart service for that.

1. we have one parameter which we pass for a header which actually means the column names and we have an option for that in Appian. 

2. We can use readexcelsheetpaging function which is part of plugin we can avoid the indexes where we have headers and footers.

S
sahilb8348Author
October 26, 2022

Hello [mention:bbe5213a4e634cbcb35783f77d2a74b4:e9ed411860ed4f2ba0265705b8793d05]

Thanks for your reply.

1.The Input Parameter you are talking about is for the column Name. In File I am getting column name that I have to read from file only. 

2. readexcelsheetpaging :- This function will work for excel not CSV. I have to read the CSV File

U
ujjwalr0002
October 26, 2022

I think the only way is to change the CSV format

Terms & ConditionsAccessibility statement