[pmwiki-users] Importing data (sqlite cookbook)
5ko at 5ko.fr
Thu Jun 19 08:55:43 CDT 2014
> I'm testing sqlite cookook on localhost.
> Let's say I want to import data in the sqlite db.
> Let's say I would like a direct import in the database using some sqlite tool
> and a basic csv file for data.
> What are the mandatory fields ?
> What value is /pages : page_id/ expecting ?
This is an incrementing number, different for every page added, the system
should assign one automatically.
> What about the targets ?
These are link targets, look into the content of any file in your wiki.d
directory, the same fields in that file are fields in the database.
> Is there a way to ask pmwiki to do some work, cleaning and fixing the lacking
> fields after the basic import has been done (for the csum, bytes, targets,
> etc.) ?
See/test/adapt the code in this page:
See also the changes I made today into the Cookbook:SQLite page concerning
the drawbacks when using this recipe.
More information about the pmwiki-users