|Data Export - Not Available in BCSS Intro||Home Previous Top Next|
Please note: MSWorks does not import data in correct format. Please use MSOffice or use free Open Office or free Google Docs online.
Exporting Data from BCSS
Data may be exported from BCSS for different purposes:
In BCSS under Utilities select export options under 'Export to Excel' to export a limited amount of information (mostly 'contact information' like name, address, phone).
In BCSS under Utilities select export options under 'Import/Export to Self' to export an extensive amount of information.
Please also refer to Data Import for importing BCSS Records from 'blank' spreadsheet templates (available from support).
Tip: When importing into BCSS for the first time, only import 1-5 records to test your procedure.
1. Export information to be used in other programs
Select which data to export under Main Menu, Utilities. The options are:
In the 'Save As' window, the file name will be auto-entered in the 'File name' field. Change the name if desired. It is helpful to include a date (using hyphens, not slashes). Leave 'Save as type' as shown:
At the top of the open screen, for 'Save in' select the Desktop:
Click Save. The exported file will be saved on the Desktop with the name specified.
Find the file on the Desktop. It may look something like:
Double click on the file. Your PC should have a program that will open it. (If not, Google Docs is free to use online http://www.google.com/google-d-s/intl/en/tour1.html) or download the free OpenOffice from http://www.openoffice.org
The CSV files will contain the following information:
Please refer to the documentation of other programs (word processors like MSWord, databases like MSAccess) to learn how to use the data.
2. Use spreadsheets to update current BCSS records and/or to add new ones.
Before information in the BCSS database can be edited in a spreadsheet, the data must first of course be exported from BCSS into a spreadsheet. This is done separately for consignors, inventory, (and buyers in BCSS Diamond and Virtual). When changes are made on the spreadsheet (and/or new records are added) BCSS will know which records in the spreadsheets are preexisting (from Internal IDs) and which are new (without Internal IDs). New records will be created in BCSS for new records in the spreadsheets.
Export BCSS Data to Spreadsheets
Note that each record has been assigned an Internal ID. This must not be changed! When data is imported back into BCSS, the program will use the Internal ID to associate inventory with consignors.
Any field left blank will be filed by BCSS with the default value for that field. For example, the default value for Original Price (in inventory.csv) is zero. Leaving Original Price blank will cause BCSS to enter 0 as the value for that item when the item is imported into BCSS.)
IF new records were added during import, the .csv file cannot be used again to edit and/or add more BCSS records because those new records will not have assigned Internal IDs. If the spreadsheet is imported a 2nd time with new records having no Internal ID assigned, duplicate records will be created for the new records having no Internal IDs.
Before using the spreadsheet for another import, first export all records again from BCSS to make new Internal IDs available. If there are no new records in the .csv import spreadsheet, it is not necessary to export all records before using the .csv spreadsheet to amend BCSS records, however, changes made in BCSS after the import will of course not be in the import spreadsheet.
To eliminate duplicate records:
For free email support, send us an email. For fee-based phone and remote-PC support please contact Joy Archer, enJoy Consigning Services, 972-898-7921, email or Russ Cox, Cox Technology Associates, 203-421-6471, email