1
brash
Merging Sites
  • 2004/12/2 21:52

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


Hi All,

Just wondered if anyone had come up with a precedure for merging the XOOPS core data of two or more sites into a single site? I imagine the biggest hurdles would be with merging users and comments.

2
christian
Re: Merging Sites
  • 2004/12/2 22:14

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


On XOOPS france (frxoops.org, xoops-themes, xoops-modules, xoops-doc) we have merged users, forums (partially), news, links, downloads.

3
brash
Re: Merging Sites
  • 2004/12/2 22:43

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


Really? How did you get around the issue of conflicting data? Things like user ID, username and e-mail address all need to be unique.

4
christian
Re: Merging Sites
  • 2004/12/2 22:53

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


For the users' fusion we have make also :

Merge all users in the same table (temp) with origine site field

1)Select all users not in frxoops
2)For each each user
verify pseudo exist on frxoops
if true, verify if the same email
if true it's the same user
else false create new user with pseudo and suffix _W (pseudo_W)
else
create new user on frxoops

3) for each user find or create on frxoops, update old enregistrement(origine site field) with the new uid for migration : news, etc...

It's not easy to write in english for me, sorry for error

5
brash
Re: Merging Sites
  • 2004/12/3 0:03

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


Very cool, I might be saved yet . What other things did you have to do for the XOOPS core data to merge the sites?

6
christian
Re: Merging Sites
  • 2004/12/3 0:29

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


The other actions was migration forum XOOPS ipb ->newbbex (clone newbb by Hervet) for archives

The news are transfered with a correspondance array :
site | old_topicid | new_topicid|
XM | 1 | 4 |
XT | 1 | 3 |

For the users and stories, we used a function what find the newuid :

table temps users
site|uid |new_uid|......
XT |2034|13325 |
XT |2035|425 | user exist on frxoops before

The comments are not transfered, it's too hard but not impossible.

For this actions, we used :
- Microsoft Access with local MySQL odbc connection and vba program.
- ultra-edit
- last version mysqlfront with tunelling on hosting database (50Mo)

Login

Who's Online

271 user(s) are online (222 user(s) are browsing Support Forums)


Members: 0


Guests: 271


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