• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 6 subscribers
  • Views 8708 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Import CSV to Database - Column Name

vishalk263

 I am trying to consume CSV file without headers using Import CSV to DB smart service (V2.2).  I have set File Has Header flag as false and giving column Name in this format ={"COL1","COL2"}. Column names are exactly same in DB . 

I get error when I try to upload the CSV file . Unknown Column 'COL1;COL2" in 'field List'.

I think issue is with the format in which I am giving column name . 

Please suggest ! 

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 2
    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
Reply
  • 0
    A Score Level 2
    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
Children
No Data

© 2024 Appian. All rights reserved.