NCR Counterpoint Data Export Instructions
How to Export your information from NCR Counterpoint
The following steps should be followed in order to export the maximum amount of information available from NCR Counterpoint to Pinogy POS. There are three sections. The Basic Export section covers all information available to be imported outside of historical sales. The Sale Data Export covers the sales history from NCR Counterpoint. The last section covers submitting the exported data to Pinogy. Basic data is covered if you selected the basic data import option. Sales data is imported if you selected the Sales Data import option on your quote.
Basic Export
Open Counterpoint and click on “Customers” (1).
Click on “Report” in the left menu (1).
Click on “Customers Report” (1).
Change the Report to “Customer List (Full)” (2). After changing the Report, click on “Preview” (2). It’s recommended that you do not add any filters to the report.
Now we need to Export the resulting file. Do this by either clicking on the export icon (3rd icon in the top menu) or right mouse button next to Preview (1), and then choosing “Export” (2).
Click on the first dropdown (1), choose “MS Excel 97-2000” (2), then “OK” (3).
Click on “OK” (1) in the Excel Format Options popup.
Choose a location, and then click on “Save” (1). We recommend leaving the File name as recommended and making a folder for all exports.
Inventory
Items
Click on Table Icon
RMB in the table (1), then select “Column designer” (2)
Select “Add all” (1), then “OK” (2)
Save the results as an Excel Spreadsheet OK
At first
Sales Data Export
Select the “Point of Sale” (1) option from the left menu.
Click on “History” (1), and then “Ticket History” (2)
Check the “Show payment detail” option in the pop up window
Optionally, click on Ticket History (1), and filter the sales data to a specific posting date range (2).
RMB at the top (1), then choose “Export” (2)
From the first dropdown, select “MS Excel 97-2000” (1), then “OK” (2)
Choose “OK” (1) from the resulting pop up window.
“Save” (1) the file to the previously selected location
Submitting the exports to Pinogy
Now that you have finished exporting everything, you need to get all of these files to us so we can import them for you. These files can be zipped up and emailed to us at import@pinogy.com. Because of the size of these files, you might need to split the files up into multiple emails. If you have any issues, please call us at 877-360-7381 for assistance. We can connect to your computer with TeamViewer to assist with the export and pull the files across from you if necessary. After that, we will load each of the files for you and let you know as soon as everything is ready. Depending on how much data you want to be loaded, this could take anywhere from 15 minutes to a couple of hours.