1
JoDee
Is there a way to Transfer Articles to Soapbox
  • 2004/6/13 23:18

  • JoDee

  • Just popping in

  • Posts: 26

  • Since: 2004/5/9 2


Does anyone know if there is an easy way to transfer your artices to soapbox besides cut and paste as I like the layout of soapbox better but I have about 100+ articles to transfer

2
tjnemez
Re: Transfering Articles to Soapbox
  • 2004/6/13 23:26

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


do you have a backup copy of your old article module db tables?

3
JoDee
Re: Transfering Articles to Soapbox
  • 2004/6/13 23:27

  • JoDee

  • Just popping in

  • Posts: 26

  • Since: 2004/5/9 2


yes its on my site and I can phymyadmin it

4
tjnemez
Re: Transfering Articles to Soapbox
  • 2004/6/13 23:55

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


it likely can be done from a backup, but due to my inexperience i think i probably should not advise you on the procedure, hopefully someone else will weigh in on this one.

5
JoDee
Re: Transfering Articles to Soapbox
  • 2004/6/14 12:32

  • JoDee

  • Just popping in

  • Posts: 26

  • Since: 2004/5/9 2


Please do advise me I can check it on my pc in xsas

6
tjnemez
Re: Transfering Articles to Soapbox
  • 2004/6/14 14:27

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


hey jodee,

i would like to see the article table in question, the one that contains the data you want to transfer to soapbox.

edit: just enough lines to see the insert instruction and a few of the inserts.

7
JoDee
Re: Transfering Articles to Soapbox
  • 2004/6/14 17:39

  • JoDee

  • Just popping in

  • Posts: 26

  • Since: 2004/5/9 2


I hope this is what you mean
Database jodee_xoop - Table xoops_articles_cat running on
or if you want I can give you access to my site temp


Field Type Function Null Value
id int(10) ASCII CHAR MD5 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
cat_parent_id int(10) ASCII CHAR MD5 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
cat_name varchar(50) ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY
cat_description text ASCII CHAR SOUNDEX LCASE UCASE PASSWORD MD5 ENCRYPT LAST_INSERT_ID USER CONCAT -------- NOW RAND COUNT AVG SUM CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP WEEKDAY
cat_weight int(10) ASCII CHAR MD5 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT
cat_showme int(5) ASCII CHAR MD5 ENCRYPT RAND LAST_INSERT_ID COUNT AVG SUM -------- SOUNDEX LCASE UCASE NOW PASSWORD CURDATE CURTIME FROM_DAYS FROM_UNIXTIME PERIOD_ADD PERIOD_DIFF TO_DAYS UNIX_TIMESTAMP USER WEEKDAY CONCAT



8
tjnemez
Re: Transfering Articles to Soapbox
  • 2004/6/14 17:45

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


okay thats the table structure, but what about the articles? are they text? if i could just see the first insert- about 20 lines.

9
tjnemez
Re: Transfering Articles to Soapbox
  • 2004/6/14 17:51

  • tjnemez

  • Home away from home

  • Posts: 1594

  • Since: 2003/9/21


i am trying to think this think through and one issue is that the table structure is different so i am not sure if this can be done.

10
JoDee
Re: Transfering Articles to Soapbox
  • 2004/6/22 23:37

  • JoDee

  • Just popping in

  • Posts: 26

  • Since: 2004/5/9 2


Articles are text with some links in them

Login

Who's Online

230 user(s) are online (129 user(s) are browsing Support Forums)


Members: 0


Guests: 230


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits