To import data in the database, you shall create one file per table, correctly respecting the
table field order. To find more info on the tables structure, you can have a look at the
hitweb.sql file in the sql/ directory.
The following is the file which enables you to import data.
http://hitweb.free.fr/hitweb/sql/csv2hitweb.php
This file needs to parameters : the name of the CVS file, which must be in the /sql directory, and the name
of the table corresponding the information you want to import.
http://hitweb.free.fr/hitweb/sql/csv2hitweb.php?file=categories.csv&table=CATEGORIES
The result is immediate and the program returns information the following way :
DEBUG : Query = INSERT INTO CATEGORIES VALUES('1','Art','0 ')
DEBUG : Query = INSERT INTO CATEGORIES VALUES('2','Auto/Moto','0 ')
DEBUG : Query = INSERT INTO CATEGORIES VALUES('','Beauté/Forme','0 ')
I quickly set up this script wich enables to import a Netscape bookmark file in the database.
This scritp can be found in the sql/ directory of the application : bk2hitweb.php.
First of all, the bookmarks.html file shall be put on the sql/ directory on the server where
hitweb is installed. Then you only need to call the bk2hitweb.php script.
http://hitweb.free.fr/hitweb/sql/bk2hitweb.php
BEWARE !!! this script is not finished, so you must absolutely not reload the page once the import
is done, otherwise you will find yourself having imported twice your
bookmark. This is in the TO DO list.