Hello,
I am preparing an excel file for the Ticket Import Utility, and the first 5 columns in the spreadsheet are to be left blank as we don't have any data to input in them. According to the documentation, they have to be present even though there isn't any data for them. I am running into the issue that when the file is saved it deletes those first blank 5 columns. There is no header so it just thinks its blank data. The rest of the blank columns in the spreadsheet are fine, its just the ones at the beginning before the data in the columns begins.
Has anyone ran into this before and might you have a solution to keep the blank columns?
Thanks!
You need to enter a space into the Excel cell of the first column. Generally that's all I've needed to do though now and then it gets picky and you have to enter a space into all of them until you get to a row with data.
Hi Amy,
Save the excel file with a place hoder such as $ in all those columns, then it will save those columns into the text file. Then do a Find Replace and replace the $ with a space as a place holder.Caryl
Try this: when you save the export file, include the column headers. Then before you upload the file, edit it in Notepad (or Notepad++, a very handy free utility you can download, and which is much more versatile) and remove the header line. That should preserve those columns.
Alternatively, do a variation on that theme and put some dummy data in the first row of data for those five columns, save the file, edit it and remove the dummy data. Again, that should preserve the existence of the columns.