plainblack.com
Username Password
search
Bookmark and Share

USS import script

I'm migrating some sites to WebGUI and for some sites I have big lists that need to bee exported to the User Submission System. Plain SQL imports are not a very safe option because of the sensitivity of the "page" table. Using API's and routine's is much safer and easier.

I attached a tgz file with an example import file and the perl script that can read that file. The script is NOT userfriendly and MUST be edited before use!!! Especially the "my $parentPageId='_95eBGk5Zqd5prALMnKZLg';" needs to be changed to your situation. This is the ID you see when you edit the page under which you want the submissions added.

If I get some requests and replies on this I might change the script to something more usefull for importing any data into the USS. For now I'm the only user and this is fine for me :)

Not to forget: Make a backup BEFORE using the script!!! It can and probably WILL damage your database if you just run it. (mysqldump or phpmyadmin is very good for this)

MAG,

Milo

System RequirementsPlease be advised: this contribution was tested with something older than WebGUI 7.5. When this contribution was uploaded there was no field for the author to fill out regarding it's requirements.
Comments
DownloadUSS_import.tgz USS_import.tgz
LinksNo Support Offered
Statistics Downloads: 368
Views: 6146
Rating: 0
Updated: 8/12/2005
Keywords Assets utility
NavigationBack to the Bazaar
© 2018 Plain Black Corporation | All Rights Reserved