Transfer Yahoo Group messages to Conversr
Posted
#1281
(In Topic #315)
Its only the messages ( ie no attachments, photo's etc), and it would'nt matter if the username from yahoo doesn't match the Compo.sr user
Many Thanks
Chris
Posted
Doing it through a 3rd party app would likely be best, unless you have a programmer at hand to write a direct importer. phpBB makes a lot of sense.
Posted
I have now downloaded the messages from Yahoo, but i need a little advice on importing the yahoo messages into the compo.sr database.
it is all reasonably obvious except for 2 columns in table "cms_f_posts".
a) Column : p_post__text_parsed. . How do you get from the displayed text in column "p_post" to the return unserialize("a:5:{i:0;a:1 .....
if the message data i have from Yahoo contains HTML, can Conversr handle this content in the post body
b) Column : p_time. How do i convert from datetime of say "25 Dec 2016 10:15:00" to your p_time
Any input you could give would be appreciated.
Thanks
Posted
The *__text_parsed field can be set to '' (blank). Composr will parse the Comcode into that field for you at run-time, it's essentially a cache field.
Comcode has the 'html' tag, so just wrap your p_post with [html]...[/html].
The PHP strtotime function can intelligently convert human date strings to unix timestamps.
1 guest and 0 members have recently viewed this.
