Getting error when trying to load a file

Options
praba71
praba71 Member, ALL USERS Posts: 5 Frequent Contributor
in Extensibility

Hi

I am trying to load a data file into my module, using the navigation Action<Import Data Source but getting 

'Unmatched Delimiter character '. Please see the screenshot of the error and the datafile. We want to keep double quote (") as the text delimiter for our data import. 

can you throw some light on what is the issue here?

 

Thanks

Prabakaran

 

Tagged:

Comments

  • praba71
    praba71 Member, ALL USERS Posts: 5 Frequent Contributor

    Hi @JaredDolich thanks for the response.

    Just to make it clear, I am using .csv file for the data import, hence I use comma as the column separator.

    I do have single quote in the value of one of the text column, hence using double quote as the text delimiter.

     

    Thanks

    Regards

    Prabakaran

     

  • praba71
    praba71 Member, ALL USERS Posts: 5 Frequent Contributor

    Hi @JaredDolich 

    Please see the data from my file below. The third column ' Description' has double quotes in it, but to distinguish them we add \ before the double quote. If that will not solve the issue, then any suggestion on how to workaround this?

     

    Sequence,Item,Description,Org, Transaction Type,Source,Date,Transaction Quantity,Current Month,Current Quarter,Current Year,Report Timestamp
    1,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",GQ1,Account alias issue,DC-CONSUMPTION,09/20/2020,1,Feb 21,Q1 FY21,FY21,02/22/2021 23:54
    2,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",NEX,WIP Issue,318565,01/13/2021,8,Feb 21,Q1 FY21,FY21,02/22/2021 23:54
    3,HDD0340,"WD 600GB SAS, 10K, 2.5\" (WD6002BKTG)",GQ1,Account alias issue,DC-CONSUMPTION,12/06/2020,1,Feb 21,Q1 FY21,FY21,02/22/2021 23:54

     

    Thanks 

    Regards

    Prabakaran

Categories