Re: Re: trouble with "tracker" import of .csv file
Thanks for the reply. I've been trying to export the data with OO Calc, being very careful with separators, I've also tried bringing in the data to Notepad++. Here is an example.
itemId,status,created,lastModif,category — 1,lastname — 2,firstname — 3,expire — 15,nickname — 4,street1 — 5,street2 — 6,city — 7,prov — 8,country — 9,postal — 10,phone — 11,email — 12,55+ — 13,join — 14,image — 16,url — 39,group — 18,notes — 19,cardsent — 41,enteredby — 17
186,o,1315859491,1315859491,member,Hxxxt,Bxxxa,1346371200,barbh,13,1550 xxxxxx Rd.,Victoria,BC,Canada,V8N 1C6,250-555-6842,bx...@ya...,yes,1246320000,,,,,1314489600,sa
187,o,1315859491,1315859491,member,Cxxxxxn,Stefan,1343692800,stxxxc,48,1550 xxxx Rd.,Victoria,BC,Canada,V8N 1C6,250-555-8777,sx...@sh...,yes,1341100800,,,,,-2147483648,cg
Above is an example of the headers, exported by trackers, and a couple of records modified to protect privacy. There should be 142 records/items in total. This file was opened and saved in Notepad++.
itemId, status, created, lastModif colums are in the original export, but I'm guessing they should not be in the import because they are not a part of the tracker item table?
Also, what about those dashes and numbers in the headers? Do they belong in the import?
Also, some new data is not in linux time format, but in yyy-mm-dd format. Might this be screwing up everything?
Thanks for your help.