Re: WinPakPE - Card Import Utility Guide
Posted: Thu Dec 09, 2010 2:02 pm
I had problems do to unsee character at the end of the csv file that I was trying to import.
also I delete the status and just used the default ACTIVE
The excel file was not working so I used csv file
also when I view the csv file in notepad I noticed ,,,,,, on some of the lines which was a problem, delete ,,,,, to fix
It was a pain, took about a hour to find and fix the problems.
save the exported file as a CSV, highlight the whole file as if you were going to copy it (Ctrl A) look the file over for unwanted characters (spaces or CR or line feeds).
- Do a (Ctrl A) and notice the . is 4 lines down, there is no need for a access level it with use the default you assign.
leo,gerst,12345,main doors
jim,jones,12346,master,,,,
Tim,Smith,12347
.
also I delete the status and just used the default ACTIVE
The excel file was not working so I used csv file
also when I view the csv file in notepad I noticed ,,,,,, on some of the lines which was a problem, delete ,,,,, to fix
It was a pain, took about a hour to find and fix the problems.
save the exported file as a CSV, highlight the whole file as if you were going to copy it (Ctrl A) look the file over for unwanted characters (spaces or CR or line feeds).
- Do a (Ctrl A) and notice the . is 4 lines down, there is no need for a access level it with use the default you assign.
leo,gerst,12345,main doors
jim,jones,12346,master,,,,
Tim,Smith,12347
.