Exporting Data from M310 / M310S
There are two files available for export on the scanner, customer.csv and IDScanner.csv. Both files are in Comma Separated Value (CSV) format and can be viewed with a spreadsheet application like MS Excel. The customer.csv file represents a single instance of each customer or card that has been scanned into the database. The IDScanner.csv file represents an every scan, or each visit that a customer has made.
The export process is the same for both files; there are 2 buttons on the Database form used to export either file. This document will describe exporting only the customer.csv file.
Things you will need:
- A PC with a USB port, running Windows XP / Vista / 7 / 8
- A USB cable
The IDVisor M310
Note: In order to sync the IDVisor M310 on a Windows XP system, then Active Sync software will need to be downloaded and installed for XP. For Windows Vista you will need to download and install Windows Mobile Device Center. For Windows 7 / 8 users the software client is all ready installed in the operating system.
Follow the screen shots below to export the customer.csv.
From the M310 / M310S, go to the Home screen click Setup to go to the Setup Menu.
From the Setup Menu click on the Database button to display the Database Maintenance screen. On the Database Maintenance screen tap the ‘Go’ button next to the label: Export customer file.
After tapping the ‘Go’ button the file will be created, click ‘ok’ on the Export Complete message and the Connect to PC screen will display.
From this point you will need the USB to PC cable supplied with the IDVisorTouch and you will need a Windows PC with a USB port.
Connect the USB cable to the PC, if the PC has ActiveSync or Mobile Device center, follow the prompts that occur.
On XP computers, you will have to configure the ActiveSync client to either connect the device as a guest or as a device partner. You can set the device up as a guest and then you can access the data on the device by either exploring through the client (ActiveSync) or through Windows Explorer. In Windows explorer select the mobile device icon to connect to the device and then go to the “\Storage Card\Exported Data” directory to grab the exported data from the device.
In Windows Explorer: Select the “Mobile Device” icon in the “My Computer” section
For more info on how to setup ActiveSync go to post “How to connect the IDVisor M310 / M310S to a computer.”
Once selected then you will see the device in the window. Then select “Storage Card” and then “Exported data”.
On Windows Vista / Windows 7 / Windows 8, an auto play window will display, in either case, use the Windows Explorer to display the new drive called: dopod / Storage Card.
Navigate to the Export Data folder, and you will find the file that you exported,
Either customer.csv file or IDScanner.csv file, depending on which ‘Go’ button you tapped.
This screen shot shows the Customer.csv file that has been exported from the database.
You can drag the file from the Storage Card/Export Data folder to your PC or you can use the traditional Copy and Paste features of Windows Explorer. Once the file has been copied, click on the close button and disconnect the USB cable. Then click Exit on the Database Maintenance screen, and click Home on the Setup Menu to return the scanner to the Home screen.
The same process can be replicated for the IDScanner.csv file.
Click on the link below to download the document: