Search found 5 matches

by rborsheim
Mon Jan 31, 2011 5:10 am
Forum: [3.0.x] Convertors
Topic: Generic message import
Replies: 46
Views: 68518

Re: Generic message import

In XMLSpy all I used was the XML menu's "Check Well formedness" and "Validate XML". To use "Validate XML", you have to assign the schema, which is in the download. The rest of my corrections I did via "search and replace". I exported as CSV and imported into Microsoft Access and searched and replace...
by rborsheim
Sun Jan 30, 2011 7:42 pm
Forum: [3.0.x] Convertors
Topic: Generic message import
Replies: 46
Views: 68518

Re: Generic message import

No, I didn't have any real problems. Of the 25k I imported only 1 topic failed. Because the import told me how many it successfully imported, I could continue importing the remainder of the messages. But, I have to admit that I did do a lot of clean up of the database using XMLSpy and some other pro...
by rborsheim
Sat Jan 29, 2011 2:44 pm
Forum: [3.0.x] Convertors
Topic: Generic message import
Replies: 46
Views: 68518

Re: Generic message import

The problem I had with images was my own fault. I didn't check the right options on import. I fixed it with this SQL query:

Code: Select all

UPDATE Phpbb_posts
SET enable_bbcode=1, enable_smilies=1
To actually get the images to show up, I had to run the Reparse BBCode function of the Support Toolkit.
by rborsheim
Sat Jan 29, 2011 8:06 am
Forum: [3.0.x] Convertors
Topic: Generic message import
Replies: 46
Views: 68518

Re: Generic message import

I just successfully converted around 25,000 messages with this. Thank you very much! I have a few tips, and a question. First the tips. Some of this is obvious, but I'll say it anyhow: o) Get the free demo on the program "Altova XMLSpy". It will fix problems like invalid characters in your import fi...
by rborsheim
Fri Jan 28, 2011 10:13 am
Forum: [3.0.x] Convertors
Topic: Generic message import
Replies: 46
Views: 68518

Re: Generic message import

Here's a working sample: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <forum-message-list date-format="%Y-%m-%d %H:%M:%S"> <topic forum-name="General Off Topic Discussion" title="hi everybody this is a test"> <message posted="2003-10-01 1:14:45" by="admin" ip="123.213.123.75">Here is my v...

Go to advanced search