Loading...
 
Skip to main content

Features / Usability


Batch upload CSV format??

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.

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...

  1. Import the new wiki pages into the database table tiki_pages.
  2. 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