SQL Imports
SQL Imports
By Paul
0/5 based on 0 votes. The median rating is 0.
By Paul
There are several ways to do SQL imports:
1) Adapt one of the existing importers: http://scripts.webmastersite.net/wsnlinks/resourc...
2) Transform all the fields of the old table via phpmyadmin to use the WSN names, remove extranous fields, export with complete inserts, then import to the WSN table and set needed data like validated=1, then regenerate counters.
3) Use phpmyadmin to export your images data as a CSV, then use the flat file importer to import the CSV to WSN Gallery (note this will import only the images).
If you aren't comfortable with phpmyadmin and aren't comfortable editing a PHP file then you may prefer to purchase the import as a custom project in the services section -- most shouldn't take more than an hour.
Print
E-Mail
Report1) Adapt one of the existing importers: http://scripts.webmastersite.net/wsnlinks/resourc...
2) Transform all the fields of the old table via phpmyadmin to use the WSN names, remove extranous fields, export with complete inserts, then import to the WSN table and set needed data like validated=1, then regenerate counters.
3) Use phpmyadmin to export your images data as a CSV, then use the flat file importer to import the CSV to WSN Gallery (note this will import only the images).
If you aren't comfortable with phpmyadmin and aren't comfortable editing a PHP file then you may prefer to purchase the import as a custom project in the services section -- most shouldn't take more than an hour.
Rating:
0/5 based on 0 votes. The median rating is 0.
Submitted: 01/22/07 (Edited 07/08/08)
Description: Importing data from another MySQL script.
Views:
558 views. Averaging 1 per day.
In the most recent 30 day period, there've been 5 views.