Forum Replies Created
-
In reply to: Importing data via sql
Someone has any idea?
Thanks and kind regards, Dirk
In reply to: Importing data via sqlHi Stephen Edgar,
I’m sorry for my late response. I still tried a little bit and enriched the data. Please find my importer here: https://gist.github.com/anonymous/9ad8e7c3dc4eecb34348d65da2da61a3
I commented the values that are not available within the data. For the user passwords and salts I used some dummy values, since the users were not registered, but only guests.
In the first lines of the reader I added the db table structure and below each table some comments, which are perhaps necessary to know.
I appreciate your efforts and say “thank you” in advance!
Kind regards, Dirk
In reply to: Importing data via sqlHi,
I managed to parse the data from a exported xml file of a custom forum that doesn’t exist anymore. The data is now stored in the following database structure:
table “authors”
– column “id”
– column “name”table “posts”
– column “id”
– column “parent_id”
– column “author_id”
– column “title”
– column “post”
– column “date”The former forum had a tree structure, so each entry in “posts” only knows its parent post and the forum topics have a “parent_id” 0.
I tried to adapt the example.php importer but I don’t get it. Is it possible to import so structured data? Could you please help me to adapt the importer? If it helps, I can post my “custom” importer, but I think it’s wrong at all.
Thanks and kind regards,
Dirk
In reply to: Importing data via sqlIs there a git repository or something like this where I can checkout your importer? I have no local wordpress installation and only want to see the source code.
In general I (guess I) understood what needs to be inserted into the database comparing the pre- and post-topic-creation-dump, except the serialized array values for key “_bbp_akismet_as_submitted” in postmeta table. Are all the keys and information necessary? I don’t understand why the HOME key is needed related to an anonymous user or how I get the unique id for REDIRECT_REDIRECT_UNIQUE_ID,…
With “are they necessary” I mean, for automatically / imported entries.Thanks and kind regards,
Dirk
In reply to: Importing data via sqlGood morning Robin,
thanks a lot! That reply was a big help.
Kind regards,
Dirk