Hi.
Thanks for the update.
Glad you got the plugins going.
Getting the images imported next is going to be much more involved.
What I have for you on that is a basic outline of the steps involved. There will likely be changes required and there will be some trial and error.
I imagine the process will take several hours or more depending on the complexity.
Keep in mind that in the forum here, we will be focused on discussion how to do this work.
If you want to move our conversation over to consulting, we can get much more indepth and even do the work ourselves.
Here are the basic outline for now:
1. Using the CSV export plugin, create another export of the first database. At the same time, create a CSV for the upload table of this database.
Note: there isn't a link to the upload section in your interface so you'll need to manually go there via: http://yoursite.com/cmsb/admin.php?menu=uploads
2. Of the two exports you just created, open the one that isn't for the uploads and look for the "num" column. What you need to do here is add "100" in front of each value.
For example, if your nums are:
3
5
6
7
10
122
After you add "100", you'll have:
1003
1005
1006
1007
10010
100122
3. Now open the upload table CSV and add the same "100" to the "num" and "recordNum" column.
4. Still in the upload table CSV, change the value in "tableName" for every record to the name of the table you created in your new installation (the one that you previously just imported everything into).
5. Repeat the first 4 steps for every database you want to import.
6. You can re-import each of the main CSV's (the ones that aren't for your upload tables) into your new CMS Builder again.
7. Create a new text file called "masterUploadsCSV.csv"
8. Open the first upload CSV you created and copy everything into the new "masterUploadsCSV.csv"
9. Open the second upload CSV and copy everything but the very first line. Paste that all into "masterUploadsCSV.csv" at the bottom.
10. Repeat steps 8 and 9 for each of the upload table CSV.
11. When you have completed "masterUploadsCSV.csv" import that into your new CMS Builder.
12. Download all the upload files from your various installations and upload them all to the new CMS Builder.
13. Note: if your sites have any uploads with the same file name, there is going to be an overwriting issue and one of the files will need replaced.
And there we go. Like I said, there will be some trial and error and we can move into consulting if you like.
Let me know any questions or feedback.
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/