Loading...
 
Features / Usability

Features / Usability


Re: Re: trouble with "tracker" import of .csv file

posts: 1563 Germany

Hi Cody,

maybe it is not much of a help, but I just want to mention, that I had problems in importing .CSV files into Tiki when they have been edited with an Office software.

As far as I understand, "higher" software like Office suites save more infoirmation than it would be appropriate for "clean" textbased .CSV files made in an real texteditor.

In my experience it is no problem to export or create then edit, save and import to Tiki, if you do that with editors like "Notepad" (Windows), "gedit" (Linux), "Vim", etc..

Maybe it is just a problem of the charset or other details which you maybe would not see in the editor.
You might try to open your Office created .CSV file in a plain editor first (as basic software as possible, so maybe just the Windows "Editor", save it and then try another import.

Another hint to track down the cause would be to try the export of an existing tracker or menu, etc as .CSV, then open it NOT in Office, but with one of the above plain texteditors, do some simple edit on it, maybe just delete some items or change some content.

Important:
existing tracker item Id numbers must all be changed to "0", if you want to import to a new tracker or import as new items adding to the existinbg ones.

Now save the .CSV with the editor and try to import it back to Tiki.
If that works, you know that mostlikely the problem is related to Office.

Please reply back, if that was any help.

Cheers,
Torsten

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting