Quote:
The database is a collection of txt files A-Z inside of directories named after each category.
This may make importing a bit difficulter. Luckily the Category information is also stored near the link information, so this can be solved by getting category information from here and not from directory structure. But you will have to import databases in each category one by one.
Quote:
Each field is separated by the pipe symbol with a return at the end of each entry. This is what I would need to import.
ID Date Ignore SubmittersName SubmittersAddy URL Title Description Category Ignore SiteType Ignore Ignore
I have a commercial plugin, named "Admin Multi-Add", which can import data from text delimited databases, which has different number of fields in each record, and you can assign any field to any data. It's a 1 by 1 record import.
Check it here:
[ NEW PLUGIN ] Admin Multi-Add plugin I could improve that script to make possible to import database in 1 category in 1 step. So you could go into each category and import the database from it.
If have too much categories, and you want to avoid importing for each category one by one, then this task would need a custom script.
Another solution would be to create artificial links.def files for your database format, then you can import records one by one for each category using standard LinksSQL importer. It wouldn't be a fast import, but could work.
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...