Bulk load to faqdata

[LNelson]

Hi, I'm moving FAQ data from several other sources to phpMyFAQ (thanks for a great tool). I'm competent to build the necessary SQL insert statements but am not quite sure what tables need new rows in the database. My first try at simply inserting rows into faqdata wasn't successful until I subsequently edited the questions. A faqdata_revisions row was created by the program and my questions then became available in my new FAQ.

In short: What tables/relationships must be maintained for a successful bulk load?

Thanks again.

Larry

[LNelson]

OK, maybe I just found the solution. This appears to give a road map:

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

I'll proceed with Nathan's table list. Are there any other tables?

Larry

[Thorsten]

Hi Larry,

I see I have to add more developer informations on the homepage.

Here's the info you'll need, a description of all FAQ related tables (phpMyFAQ 2.7):

For categories:

- faqcategories -> Table with categories: ID, Language, Parent ID, Name, Description and User ID of the Category admin
- faqcategory_group -> relation between category ID and group ID for permissions, default group ID is -1 with access for everyone, every category ID needs at least one entry in this table!
- faqcategory_user -> relation between category ID and user ID for permissions, default user ID is -1 with access for everyone, every category ID needs at least one entry in this table!
- faqcategoryrelations -> relation between categories and records with category ID, category language, FAQ ID and FAQ language, every category and FAQ ID needs at least one entry in this table!

For FAQs:

- faqdata -> Table with FAQs: ID, Language, solution ID, revision ID, active, sticky, keywords, "thema" for the question, "content" for the answer, and so on
- faqdata.id Primary ID
- faqdata.lang Language, e.g. "en"
- faqdata.solution_id Solution ID, an unique ID for every FAQ entry, starting with 1000
- faqdata.revision_id Revision ID, integer value, default is 0
- faqdata.active FAQ active/inactive, values are "yes" or "no"
- faqdata.sticky sticky/non-sticky, integer value, default is 0 for non-sticky FAQs
- faqdata.date_start should be 00000000000000, faqdata.date_end should be 99991231235959
- faqdata_group -> relation between FAQ ID and group ID for permissions, default group ID is -1 with access for everyone, every FAQ ID needs at least one entry in this table!
- faqdata_user -> relation between FAQ ID and user ID for permissions, default user ID is -1 with access for everyone, every FAQ ID needs at least one entry in this table!

I think this is everything you need for the FAQ data

Cheers
Thorsten