Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome, Guest. Please login or register.
Did you miss your activation email?

May 31, 2020, 08:10:15 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 190050
  • Total Topics: 20835
  • Online Today: 105
  • Online Ever: 917
  • (January 21, 2020, 09:02:26 AM)
Users Online
Users: 1
Guests: 73
Total: 74

Author Topic: Export / Import articles  (Read 3591 times)

0 Members and 1 Guest are viewing this topic.

Offline boillzz

  • Jr. Member
  • **
  • Posts: 7
Export / Import articles
« on: September 01, 2010, 04:58:20 AM »
Hello ,

We currently run a SMF + joomla site . We have more than 300 news and articles  stored on the joomla .

We are in the process to upgrade the site and use tiny portal + smf instead of joomla.

My question is : does an importer tool exist to help us create automaticly the articles in tiny portal ? If not, i will script something but  maybe you have advices ( name of the sql tables , and fields required )

Thank you for your help  O0

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Export / Import articles
« Reply #1 on: September 01, 2010, 12:11:00 PM »
Unfortunately no converter available, but it certainly has been thought about. Bloc will have to have to answer on the details of the DB tables and stuff that is used, but for the most part all the article data is stored in tp_articles and tp_variables from what I can see. When an article is created a new row is inserted into each of those tables.

Offline ed_m2

  • Full Member
  • ***
  • Posts: 231
Re: Export / Import articles
« Reply #2 on: September 02, 2010, 02:16:37 AM »
i made a start at doing this..... but it was rather painful !

especially if you want to parse the images back in from the image list in mambo/joomla.. etc etc

Offline boillzz

  • Jr. Member
  • **
  • Posts: 7
Re: Export / Import articles
« Reply #3 on: September 02, 2010, 03:30:57 AM »
Thanks for your answers . Well we never user image or joomla tags in our articles so it isn't a problem .

I think i just have to take care of create the categories ( tp_variables ) , and then insert the articles, and specify the good format ( html or bbcode ) ( in tp_articles ). If no other tables are involved , i think it's rather simple . There is this "tp_event" table , i don't know if i need to use it .

  I 'll put my "code" here, when i'll have something working.

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Export / Import articles
« Reply #4 on: September 02, 2010, 07:39:30 AM »
I'll point Bloc to this topic so he can give you any advice he thinks necessary.

Offline bloc

  • Founder
  • *
  • Posts: 5217
    • Bloc
Re: Export / Import articles
« Reply #5 on: September 02, 2010, 11:11:07 AM »
The tp_event isn't necessary to use, its just a log table of added articles, to be used in a future feature.

The categories should be easy, and yes, articles exists only in the tp_articles table.

I haven't looked at Joomla, but I could check to see if a converter could be made - unless you already have something good working. In any case it might be beneficial for all if I do make one though, but again, have to take a look at it first.