Advertisement:

Author Topic: converting content items to SMF posts  (Read 14092 times)

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
converting content items to SMF posts
« on: July 28, 2009, 10:30:16 AM »
Heya,

I asked previously about converting SMF posts to Joomla/Mambo content items, but now am wondering if anyone has done the opposite i.e. convert content items to SMF posts. Is there a script available somewhere?

Thanks

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: converting content items to SMF posts
« Reply #1 on: July 31, 2009, 04:46:31 PM »
I'm not familiar with Mambo however if there is a function that can be used to easily grab each item, then it is very easy to use SMF's functions to insert them as posts.

I believe Mambo may store items in the database with full html (rather than bbcode or similar like SMF)? If this is the case they can probably be pulled directly from the mambo database by any conversion script?
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #2 on: July 31, 2009, 05:09:18 PM »
I'm not familiar with Mambo however if there is a function that can be used to easily grab each item, then it is very easy to use SMF's functions to insert them as posts.

Hmm that is a good idea. Which of these functions should I be looking at to insert them as posts? Perhaps post2? assuming I figure out how to grab it from Mambo in the first place of course...


Quote
I believe Mambo may store items in the database with full html (rather than bbcode or similar like SMF)? If this is the case they can probably be pulled directly from the mambo database by any conversion script?
You are correct, the body of the content is stored in two columns (introtext and fulltext) with full HTML tags. Is it okay to keep the text as HTML or should they be converted to bbcode inside smf_messages?

btw, As far as I know, the number of views on a topic resides inside smf_topics. What do you think is the best way to convert this?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: converting content items to SMF posts
« Reply #3 on: August 01, 2009, 07:56:24 PM »
I converted my mambo articles into SMF articles (VBgamer's mod)

however, I did it manually, directly in mySQL
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #4 on: August 02, 2009, 11:05:42 PM »
I converted my mambo articles into SMF articles (VBgamer's mod)

however, I did it manually, directly in mySQL

You don't happen to have reference to the used mySQL statements do you? I don't use SMF articles but they still might be useful...

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: converting content items to SMF posts
« Reply #5 on: August 03, 2009, 07:33:10 AM »
I will see if I can track it down.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #6 on: August 03, 2009, 08:26:25 AM »
Thanks man, that would be most appreciated.

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #7 on: August 09, 2009, 05:40:39 AM »
Kindred, any luck?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: converting content items to SMF posts
« Reply #8 on: August 09, 2009, 11:21:01 AM »
Hey Kai,


I started to put together a post for you, but then work got crazy because I am on vacation this week.   I'll finish it up when I get back next week (posting from a netbook right now, so no real access to my programming tools)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #9 on: August 09, 2009, 09:58:49 PM »
Ah thanks for that, looking forward to your post :)

I know what you mean about the netbook, had to use one the entire summer and it's not very suitable for work...

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #10 on: August 22, 2009, 01:12:27 AM »
A very gentle bump, in case you are back from vacay O:) ;D

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #11 on: December 07, 2009, 03:00:11 AM »
Hi Kindred,

any luck finding those SQL statements?

Many thanks

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,639
  • Gender: Male
    • Kindred-999 on GitHub
Re: converting content items to SMF posts
« Reply #12 on: January 23, 2010, 11:29:50 PM »
Kai,

I am EXTREMELY sorry for not getting back to you on this.
I had an attack of "life" and then recently there has been stuff going on within SMF which is taking all of my free time.   I really will assemble these SQL statements one day, real soon now (tm)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline kai920

  • Sr. Member
  • ****
  • Posts: 855
  • Gender: Male
  • its != it's
Re: converting content items to SMF posts
« Reply #13 on: January 25, 2010, 01:15:24 AM »
hey Kindred,

No worries, I actually sought out the help of Arantor in the SMF Coding board and wrote my own little script using insertPost() to convert most of the content over. I learned quite a bit doing it, and I *think* everything went according to plan :)