I had to do this manually, but it wasn't difficult. I've got very little SQL experience and I figured it out. You could probably write a script for it if you knew what you were doing. I exported the xopos_xgal_* tables to my hard drive. I opened it up and did a search and replace on all instances of
xoops_xcgal_ and changed it to
cpg133_I dropped all the tables I already had data for (on the exported file on my hard drive) in the new database I'd created. Had to make some manual edits here:
Under
--
-- Dumping data for table `cpg133_albums`
--
a value of
, ''
has to be added for each album (it's en empty keyword field).
Import data!
--
-- Dumping data for table `cpg133_categories`
--
needs an extra '0' before the YES/NO option at the end.
eg:
4, 0, 0, 0, 0, 'NO');
becomes
4, 0, 0, 0, 0, 0, 'NO');
Import data!
I believe
--
-- Dumping data for table `cpg133_pictures`
--
was ok so just import that data as-is.
That's the bulk of it. Just copy/move all folders under xgal/albums to your rootcpg/albums folder. If you have added usergroups and other things you'll have to sort that out. I hadn't. Importing the votes was the only thing I didn't really bother with because it looked like more trouble than it was worth.
Basically, if you just want to switch from Xoops xGall to CPG1.3, keeping only categories, albums and pictures, the above should work for you.
My explanation is not as clear as I would like so I will see if I can clarify, if necessary. PM me if you have any questions and hopefully I can help.
If you want to see the finished result, go here:
www.carminegiovinazzo.net/galleryI have't edited or tweaked it yet (at the time of writing this) so that's just a straight conversion using the above instructions.