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