This is a tutorial to import a csv file of BANS Pages through MySQL.
I have included an excel spreadsheet to assist in creating the csv for import.
Insert the content for your pages into this excel file.
!! Make sure the ‘id’ numbers are unique I find the last id used in the table and I use that as a go by. !!
When you are done, save the file and then do a saveas and change the filetype to ‘CSV (Comma delimited) (*.csv)’
Close out the file.
Go to your BANS db through phpMyAdmin and click on the ‘pages’ table and then click the ‘Import’ tab at the top.
Browse to your .csv file
In the Partial Import box I say skip 1 line (the labels on row 1 in the csv)
In ‘Fields terminated by’ change the semicolon ( ; ) to a comma ( , )
Click Go
For the Store Pages you have to do an extra step.
!! Below is only needed for the Store Pages !!
You have to manually input the values in the Column names:
title,keywords,description,content,id,cat_id,cat_name,file_name,parent_id,page_order,query,local,miles,zip,minbid,maxbid,minprice,maxprice,bin,display,productdisplay,ppPage,contentbelow,left_ads,right_ads,top_ads,bottom_ads,displaynext,displaysort
Get the zip file with a readme and the excel spreadsheets here
