Migrating JComments from LyftenBloggie into JComents standard Joomla articles

[danss2]

Hi all :-)
I'm thinking to abandon use of LyftenBloggie and instead just use standard Joomla articles system and possibly with K2.
I realize, that I'll have to move (ie - copy all my content from LyftenBloggie articles into Joomla articles) manually.  But is there an easy way to migrate all the comments from LyftenBloggie into Joomla newly created articles?

PS: I am already using standard Joomla articles along with LyftenBloggie with JComments both (just different sections).  And I'm just thinking, maybe, to create a separate section just for those articles, that I'm gonna move from LyftenBloggie.

[danss2]

Anyone? 

[smart]

Hm... It is very hard to me to explain something on English, because it isn't native for me. But I will try.

NOTE: I am strongly recommed to create database backup before any expirements!

The most easies way to convert your data with saving all comments is using SQL. I do not use LyftenBloggie and I do not know it's database structure but I think it could be converted to jos_content via some SQL query.

Regarding comments... They are stored in jos_jcomments table. The comments posted in LyftenBloggie will have 'com_lyftenbloggie' in 'object_group' field of jos_jcomments. And in 'object_id' field the LyftenBloggie article's ID is stored. When you move articles from LB to com_content, they will got new IDs...

So to move comments from LB to content you have to change 'object_group' to 'com_content' and 'object_id' to new values. How you can get new values of IDs? The simplest way is remember last ID from jos_content (for example it 100 - so jos_content does not have any article with ID greated than 100). In this case you can edit your SQL-query and set new ID as old + 100.

In my mind you should use something like this (note, I do not sure about jos_bloggies_entries fields):

Code:

insert into jos_content(id, title, introtext, fulltext)
select id+100, title, introtext, fulltext
from jos_bloggies_entries

So if your LB entries had IDs like 1, 2, 3 and etc, in jos_content they became 101, 102, 103...

And after you convert entries, you could convert comments with query:

Code: (sql)

update jos_jcomments
set object_id = object_id + 100, object_group = 'com_content'
where object_group = 'com_lyftenbloggie'

I hope this help you...

[danss2]

This, actually, helps a lot!  
Question: since I'm moving/copying my content from LB into standard Joomla content, new articles will have their own IDs. Can I just use them, instead of "creating" new ones?
PS: and I just found it out by trying it  And it worked!
What I did was (just in case someone else would have this question): change object_id to a new article ID, object_group - to com_content and some had source - varchar(255) set to lyftenbloggie, so I cleared it (as I checked in other strings, that were already com_content's and that field is clear there)

[smart]

[danss2]

Thank you! You rock! :-)

[bla]

Hi all :-)
I'm thinking to abandon use of LyftenBloggie and instead just use standard Joomla articles system and possibly with K2.
I realize, that I'll have to move (ie - copy all my content from LyftenBloggie articles into Joomla articles) manually.  But is there an easy way to migrate all the comments from LyftenBloggie into Joomla newly created articles?

PS: I am already using standard Joomla articles along with LyftenBloggie with JComments both (just different sections).  And I'm just thinking, maybe, to create a separate section just for those articles, that I'm gonna move from LyftenBloggie.

Hi,
I would love to hear why you have decided to do that? What's your feedback on Lyftenbloggie?

Thanks,
BLA

[danss2]

Pluses:
Lyften is an ok component and did what it's made for very good.
It is a free complete blogging extension.
Minuses:
No updates since years ago.  Seams to be abandoned.
Support is very limited and consists of only users, that somehow found a way to do one or the other things...
Limited support of plugins (like auto-twitter plugin, for example, is not supported at all)

On my own side: I had content in both - native Joomla and Lyften, so I decided to consolidate all into one component, and K2 is one of the best outthere, that support blogging and then some :-)  In fact, come to think of it - I wish I did that in the beginning and not wasted my time with Lyften and native content...

Hope this helps, or answers your question :-)