Latest Register Log In

+ Advanced Search

Loading Presupplied Data Sets

Loading Presupplied Data Sets
By
12/04/16 (Edited 12/04/16)

When installing any WSN script, the "Pre-Load Data" section in the installer gives you the option to give your site the head start of using one of the provided data sets. These data sets provide commonly-desired category structures, or in some cases even listing data. The datasets currently available as of this writing (note some of these options may not show for some of the scripts where they're not really relevent):

Business categories: categories and subcategories for types of businesses, ideal for starting a business directory
Business categories by state/province: same as above but with the top level categories being USA states and Canadian provinces, with the business categories nested below that
USA cities by county by state: all USA cities and towns with more than a few thousand people, organized into county subcategories and state top level categories
USA counties by state: all USA counties as subcategories organized by state top level categories
USA states: the 50 USA states as top level categories
Counties of single state: you'll be prompted to select a USA state, and the counties of that state will be the top level categories
Cities by county of single state: you'll be prompted to select a USA state, and the state's counties will be top level categories while the state's towns will be subcategories.
PAD categories: the official software categories from the PAD shareware format
PAD listings (60K): tens of thousands of software listings organized by category
PAD listings (16K): a more carefully cultivated set of software listings organized by category
Web scripts categories: categories appropriate for a directory of web scripts

It's best if you make the correct selection during installation, but sometimes you may want to change your data set after you've already installed. This is possible. First, you must delete your current site data (categories, listings and associated info) and be sure that you really want to do that. Go to Admin Panel -> Miscellaneous -> Advanced Options and place the following in the "Run SQL" box:

TRUNCATE TABLE {PREFIX}categories;
TRUNCATE TABLE {PREFIX}links;
TRUNCATE TABLE {PREFIX}comments;
TRUNCATE TABLE {PREFIX}ratings;

Run that. Now your next step is to load one of the pre-loadable data sets. You'll do this by visiting a special URL in your web browser while logged in as an administrator. The URL varies slightly depending on which data you want to load:

Business categories: youradminpanelurl/loaddata.php?filled=1&datasource[0]=businesscategories&dataindex=0
Business categories by state/province: youradminpanelurl/loaddata.php?filled=1&datasource[0]=businesscategoriesbystate&dataindex=0
USA cities by county by state: youradminpanelurl/loaddata.php?filled=1&datasource[0]=cities&dataindex=0
USA counties by state: youradminpanelurl/loaddata.php?filled=1&datasource[0]=counties&dataindex=0
USA states: youradminpanelurl/loaddata.php?filled=1&datasource[0]=states&dataindex=0
Counties of single state:
youradminpanelurl/loaddata.php?filled=1&datasource[0]=statecounties&dataindex=0&state=California
Cities by county of single state:
youradminpanelurl/loaddata.php?filled=1&datasource[0]=statecities&dataindex=0&state=California
PAD categories: youradminpanelurl/loaddata.php?filled=1&datasource[0]=pad&dataindex=0
PAD listings (60K): youradminpanelurl/loaddata.php?filled=1&datasource[0]=padlistings&dataindex=0
PAD listings (16K): youradminpanelurl/loaddata.php?filled=1&datasource[0]=padlistingsalt&dataindex=0
Web scripts categories: youradminpanelurl/loaddata.php?filled=1&datasource[0]=scriptdirectory&dataindex=0

For the single state ones, be sure to change California to your desired state at the end of the URL.





Rating
Views 245 views. Averaging 0 views per day.