?
Solved

How to export from a POS application with .gnt files

Posted on 2011-10-24
6
Medium Priority
?
634 Views
Last Modified: 2012-05-12
I have a client that is using Counterpoint POS 7.5. They will need to export all the databases to EXCEL format so that can be imported into Quickbooks POS.

I have no experience with this type of file format. Can I just open the database file using EXCEL or do I have to convert them first?
0
Comment
Question by:RSchierer
  • 3
  • 3
6 Comments
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37020276
The easiest way to do it is to create .csv (comma separated) or .txt (tab separated).
Just output it into a text file something like this
PartNumber, PartName, Quantity
2342343, Wheel, 34
341343, Rod, 65

And save it as a .csv file.
Or replace all the commas with tab characters and save it as a .txt. Excel can open either type of file easily.
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 37020296
Counterpoint has a data export utility. It claims it supports Excel. So it should be even easier than my first post implies. Just export it to .xls format or .csv if .xls isn't in the list.
0
 

Author Comment

by:RSchierer
ID: 37020864
@Tommy do you happen to know how I can access the export utility? I have access to the program remotely and would like to test it on some files I have backed up.

If not how do I create the .csv file?
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 37

Accepted Solution

by:
TommySzalapski earned 2000 total points
ID: 37020942
Go to System/Utilities/Database Export
It looks like it defaults to csv format, so just choose the tables to export and the location for the file.

The manual here http://www.accelerando.net/downloads/cp-configuration.pdf has all that and more (what I have referred to is on page 310 on the pdf).
0
 

Author Comment

by:RSchierer
ID: 37021004
Thanks for the info! BTW the link to the manual doesn't work.
0
 

Author Comment

by:RSchierer
ID: 37021015
I take it back, the link works! I wish I could give you another 500 points just this!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question