Transfer Yahoo Group messages to Conversr
Posted
#1239
(In Topic #268)

Standard member

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

Site director

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.
Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon
- If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
- If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
- If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
- If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Posted

Standard member

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

Site director

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.
Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon
- If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
- If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
- If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
- If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
1 guest and 0 members have just viewed this.