Importing tickets - How did they make the CSV file in example?
I tried out and have working (for the most part) the example for importing tickets from another system given at:
The issue I am having is with the CSV file example given in the example above:
In the example CSV file they give a comment example:
This is line 1
This is line 2 (notice how there is still only ONE row in the CSV)
This is a list separated by commas: 1,2,3,4
They are correct that in the CSV file it does look all like one row. The question is how do they get the text that can have multiple paragraphs in the old system to come in with their line breaks and how do I deal with quoted text like a users sending me an error they see - (Hey IT, my error is "Error 123: See IT and get this fixed")
I am going to use MS Access to export data from a SQL Lite db into the CSV file.
Community Chosen Answer
I don't know if this will help with your problem, but here is this: (THE FAQ is outdated as the comment field, the way it is written, doesn't transfer over at all.)
Basically I just placed everything 'quoted' in the COMMENT_LOC data cell, and using excel to build the csv file. the formatting within the data call can be however you like it to be.
on monday I will upload an example of our import CSV in 'final form'