Current time: 04-18-2014, 03:57 PM Hello There, Guest! (LoginRegister)


Jump to the post that solved this thread.
Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Merging threads from a spreadsheet
05-21-2011, 11:53 AM
Post: #21
Not Solved RE: Merging threads from a spreadsheet
thank you very much!
Find all posts by this user
Quote this message in a reply
05-29-2011, 03:11 PM
Post: #22
Not Solved RE: Merging threads from a spreadsheet
I managed to fix the incorrect replies problem.
I had tried:
UPDATE `mybb_threads` SET `replies`="0" WHERE `replies`="1"
that worked but then after I did a recount it screwed up again. I hadn't formatted the `firstpost` values correctly, fixed that and it was all good

Still haven't fixed the formatting of the imported posts themselves . . . going through 3500 of them manually . . . open edit save, open edit save, open edit save . . . should only take a few days :-)

cheers for the help getting it this far!
Find all posts by this user
Quote this message in a reply
05-29-2011, 05:04 PM
Post: #23
Not Solved RE: Merging threads from a spreadsheet
Yeah, sorry I can't help further... except to give some advice.

You could run a simple script to use ereg_replace() on all the posts and this replace the Office newline character with a proper newline.

CodeWeavers - CrossOver: Windows Compatibility on Macintosh and Linux
[Image: Advocate_125.png]
Doesn't like unsolicited PMs
Find all posts by this user
Quote this message in a reply
05-29-2011, 06:27 PM
Post: #24
Not Solved RE: Merging threads from a spreadsheet
Hmmm, that might be a bit beyond me, my php isn't that great (yet!) and with the different newlines . . . but I'll look into it

Thanks again for your help.
Find all posts by this user
Quote this message in a reply
Jump to the post that solved this thread.
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication