Importing Bulk FAQ from CSV

[sungkhum]

Hello,
I am following the instructions at: http://www.phpmyfaq.de/docs/dokumentation.1.5.en.php#3e
on Migration and have successfully imported questions and answers into the system (I had to change what I was importing: id lang solution_id revision_id active sticky keywords thema content author email comment datum links_state links_check_date date_start date_end).
However, one problem exists - after importing, none of the terms appears on the front-end and in the backend when I go do Edit FAQs the terms I imported are there but with errors: phpMyFAQ notice [8]: Undefined index: in record.show.php on line 230

Once I edit each entry (changing nothing) and save, the entry is shown on the frontend and everything is fine.
The problem is I want to import over 30,000 entries - and going through and edited each one and saving it manually is just not an option.

How can I fix this issue in the database import? Is there a way to re-build the index automatically so that the errors are taken care of?

Thanks so much for your time,
Nathan

[sungkhum]

Just as soon as I posted this I found the solution.

These tables need to be updated with correct information regarding each entry:
faqcategoryrelations
faqdata_group
faqdata_user

Just create a table in openoffice or something with the correct data and import it to these tables and all should work fine.

Thanks,
Nathan

[Thorsten]

Hi,

the documentation on http://www.phpmyfaq.de/docs/dokumentation.1.5.en.php#3e is outdated, but you figured out the correct way.

bye
Thorsten