Now we will look at editing the Dataset properties. Double click the icon to the right of the Dataset Name "STOCK_PRICES". This brings up the Dataset Options box on the General Tab.
The first item here is the Dataset Name. You can edit the Dataset name here.
The second item is the Dataset Description. You can edit this here.
The third item is the Times the Dataset Appears in the Datapage. Here you see the number 10 since the Dataset we selected is found 10 times in the browser pane. The recalculate button allows you to recalculate this count. Using this it will give you the same drop down box we had in the left pane of the Template Row/Dataset wizard, Specify the Number of Rows step. If you make changes here it will change the number of Rows/Records by the Dataset. This is for users with some experience with the product to correct mistakes in the Row/Record count.
The fourth item is the Initialization string. You will note that this is grayed out and there is an Edit (Advanced) option. By selecting this option, you can make changes to the HTML selected for the Template Row/Dataset Initialization/Start tag. If you are not getting the correct number of Rows/Records when you auto calculate the Row/Record number this can provide a way to manually set the Template Row/Dataset Initialization/Start tag. This is meant for advanced user that can look at the HTML on the page, verify patterns, and select an appropriate Template Row/Dataset Initialization/Start tag manually. If you are using this feature, do not hit the Recalculate button above. This will cause WSP+ to pick a Template Row/Dataset Initialization/Start tag that it thinks as unique before it calculates, possibly changing what you have just taken the time to manually create.
Next Click the Database tab.
The Database tab let’s you change the Destination Datastore via the radio buttons. This has the same options and functions that we described earlier in the Dataset Configuration Wizard. We are currently sending our data to an Excel file called STOCK_PRICES.xls located in C:\Program Files\Web Scraper Plus+\Yahoo Finance.
If we wanted to change the file folder location of this file or its name, we could do it in the Destination Excel File path box. If we wanted to change the destination to a database, we would select one of the other radio buttons.
This tab also allows you to change the Dest. Table Name which will change the table name in your database or in this case your sheet name in the Excel spreadsheet STOCK_PRICES.
You should also note the Automatically Calculate Column Size check box. We have referred to this during the Dataset Configuration Wizard where we decided initially whether to check or uncheck this box and in the Field Configuration Wizard where we saw column size defaulted to 255 characters and grayed out because of this selection. You can uncheck this to give you the flexibility to set a column size for each data Field.
We will leave all of this information as is.
Next click the Metadata tab.
Now we see the Metadata selection box. You can make changes to your Metadata selections here.
If you add or delete Metadata items here after you have run a Package or used the Save to Datastore option from the Datapage you will have created a Table in your database or an Excel sheet. The table or spreadsheet will then have columns as defined by your Fields and Metadata selections. Once you have set up this table or spreadsheet structure and then made changes, WSP+ will try to write information to this table or spreadsheet it will look for the new columns and find they don’t exist and /or find that there is no Field or Metadata for Columns you deleted. You must rename or delete the old spreadsheet or change the spreadsheet/table name so that WSP+ can build a new a spreadsheet/table with the new column structure.
We are going to leave the Metadata as is.
Click "OK".