Import data from XML to fud, HOW?? [message #18712] |
Thu, 03 June 2004 23:38 |
rafath
Messages: 14 Registered: June 2004
Karma: 0
|
Junior Member |
|
|
Hello
Unfortunatelly I have xml dump of data from BBphorum. I want put this into Fudforum, but I dont know how exactly. I have only messages from bbphorum, its look like:
Quote: |
<RECORD>
<post_id>65281</post_id>
<parent_id>62921</parent_id>
<topic_id>6569</topic_id>
<forum_id>23</forum_id>
<poster_id>2599</poster_id>
<post_title>Re: Forum ...</post_title>
<post_text><![CDATA[V2l0YW0gd3N6eXN0a2ljaCBhIHN6Y3plZ/NsbmllIHR5Y2gsIGt083J5Y2gganW/IHpuYW0gYmxpv2VqIHogaW5uZWdvIGZvcnVtIGN6eWxpOiBLYXRrYSwgQWRhbVcsIEphbmtlcywgVmFsZW8uDTxicj5KZXN0ZW0gbm93eSBuYSB0eW0gZm9ydW0gaSBtYW0gbmFkemllauosIL9lIGLqZHppZSBuYXMgZHW/byBkdb9vIHdp6mNlai4NPGJyPlBvemRyYXdpYW0uDTxicj5vcmlvbg==]]></post_text>
<post_time>20021223T13:17:24000</post_time>
<poster_ip>217.98.33.28</poster_ip>
</RECORD>
|
I know how I should build insert (which table fud26_msg or fud26_thread?), but dont know how (and where) should I put the body message and recognize that this message is from user id=65281.
Any ideas?
sorry 4 my english.
|
|
|
|
|
|
|
Re: Import data from XML to fud, HOW?? [message #18730 is a reply to message #18729] |
Fri, 04 June 2004 15:02 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
$forum_opt & $message_threshold leave both as 0
$autoapprove=true is ok.
$perm is the permission bitmask of the user making the post.
FUDforum Core Developer
|
|
|
|
Re: Import data from XML to fud, HOW?? [message #18733 is a reply to message #18732] |
Fri, 04 June 2004 15:20 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Can't be done easily. You need to prewrite the bodies to the file then store the length & offset and add that to the queries.
FUDforum Core Developer
|
|
|