• Replies 3 replies
  • Subscribers 12 subscribers
  • Views 4879 views
  • Users 0 members are here
Options
Related

Batch Loader Utility: Automatically add extra characters if a cell contains double quotation mark

Jacky Phan
Offline

I'm using Batch Loader to import data into ARAS from a csv file. I notice that if a cell contains a double quotation mark ", the tool will automatically add some extra " to the content. It is an annoying behavior.

Example: A cell content in the CSV file is: This is test" field .

=> What is display in Batch Loader: "This is test"" field."

Does anyone know how to fix the problem? Thanks in advance.

Parents
  • Offline

    Jacky Phan,

    I'm having a bit of trouble replicating your issue. The batchloader combines the data row with the AML template, so you should be able to see the AML that's going to be run by clicking on a row. Do you see your extra quotation marks there? They may well be escaped in some fashion, since double quotes are reserved characters in XML. Look for " where you might expect a double quote.

    I know that some spreadsheet editors have an annoying habit of adding quotes around cells which contain a string. I use Open Office Calc a lot, and I have to manually uncheck the checkbox to add the surrounding quote every time I save a file for batch loading. If you open the file with Notepad or some equivalent do you still see the extra quotes?

    If you're not seeing the extra quotes in your file, but do see them in the loaded data in Innovator, let me know what they look like in the Template preview.

    Skyler C.

Reply
  • Offline

    Jacky Phan,

    I'm having a bit of trouble replicating your issue. The batchloader combines the data row with the AML template, so you should be able to see the AML that's going to be run by clicking on a row. Do you see your extra quotation marks there? They may well be escaped in some fashion, since double quotes are reserved characters in XML. Look for " where you might expect a double quote.

    I know that some spreadsheet editors have an annoying habit of adding quotes around cells which contain a string. I use Open Office Calc a lot, and I have to manually uncheck the checkbox to add the surrounding quote every time I save a file for batch loading. If you open the file with Notepad or some equivalent do you still see the extra quotes?

    If you're not seeing the extra quotes in your file, but do see them in the loaded data in Innovator, let me know what they look like in the Template preview.

    Skyler C.

Children