Batch upload CSV format?? Posted by faredge 09 Sep 2003 05:12 UTC Hi I would like to use the Batch upload (CSV file) feature of adding new users to my TikiWiki however there is no documentation on the format of the CSV file. What is the format of the fields for this file please? Thank you.
Posted by MinutiaeMan 14 Nov 2003 21:36 UTC I wanted to know this very same question. I have been working on a personal "Star Trek" database for ten years now, and I'm looking to import it into a new TikiWiki database I'm starting with a friend. I can easily export formatted Filemaker Pro content into CSV files, but it's the importing that's got me stumped! After creating a bunch of pages just through the structure, I took a look in the phpMyAdmin pages. The table tiki_pages is the one that contains the actual text information for each wiki page. However, there's also a table called tiki_links that stores (I assume) the links between each of the pages. (That's the stuff you put in double-parentheses.) And so even if you pre-format your wiki text, it's not going to automatically link to your other sites — I don't think. I'm not as certain about that part of the process. (And I'm not gonna be the guinea pig, either.) Oh hey, wait! I just thought of an awesome way to do this! This depends on how your database structure is organized, but... Import the new wiki pages into the database table tiki_pages. Create a structure! Creating the structure will link between the various records for you. How simple is that? 😀 Anyway, back to the original question. The list of fields for tiki_pages is: hits data description lastModif comment version user ip flag points votes cache cache_timestamp pageRank creator Hope this helps! Dan