Loading...
 
Skip to main content

Features / Usability


importing csv

Hi Everyone...
I'm having an impossible time importing a csv file through the tracker import interface for ver 8.3. The fields already exist in the tracker.

The table tiki_trackers is updated, the table tiki_tracker_items is updated with the exact number of rows in the myfile.csv (good) and the admin says complete 121 records (good). PROBLEM: However the tiki_tracker_items_fields is bare, empty, nada, without data.

The first two lines of my csv look something like this: (created with comma separated, text deliminated OO Calc)

"itemId","category","lastname","firstname","expire","nickname","street1","street2","city","prov","country","postal","phone","email","join","image","url","group","notes","enteredby "

186,"member","Hxdg","Bxdfg",1346371200,"bxdfg",13,"1dgf0 Adfg Rd.","Vxxdfg","BC","Canada","V8N xx6","250-xxxxxxxx","xx...@ya...",1246320000,,,,,"sa"


The double quotes are only around the text, not unix time values, nor the id, nor empty values. Is the above correct? If so, what could be the cause of this import not working for me? Something on the server? Is there a fix? A workaround?

I await to hear advice and comment. Thanks.