DHES

This program is great but I'm in need of some integration with Excel. I know that I can enable journaling so that a txt file is created with a copy of every sale receipt. I would like to be able to generate this in a csv format with deliniated fields with commas so that Excel can import the data.

Is there any way to do this? If not, I can program a utility script that can create the csv file but I don't want to re-invent the wheel.

Craig,

What information are you trying to get from the journal? If all you want is what you sold that day then you can use the auto reports feature to do a report E, F, or G and then save the report as a data file. This will save the report as a comma delimited file. However this will require that you reset the merchandise data everytime you close the register for the day. You can then read the file into Excel.

However if you want more data from the journal then you will have to write your own program to parse the journal file into a comma delimited format.

Dale

Actually as I mentioned in my email I'll need each sales transaction including any customer information to be exported to a csv file. So those reports wont work for me. Dale wrote a utility scipt in QBasic to extract the inventory table and someone else wrote a script to write that into a csv file. Can the same be donee witht eh sales file? I was planning to use the journalling text file and parse that using the Python language. However, if someone is comfortable with QBasic, it would be more in the spirit of the Dale Harris project to use QBasic. Unfortunately its greek to me and so is the DOS scripting language.

Happy Holidays Everyone!

I've been able to import successfully customer data using Python (see http://www.dhpos.com/discuss/phpbb3/vie ... f=1&t=1071)

However, I am stuck with a bug. See the attached image
Notice that sales history has bogus numbers. These customers were just imported and all the history data should be zero.

Notice the large numbers in Last Sale amount, Total Refund amount etc. All these values should be Zero.

Obviously there is another file somewhere that needs to be edited.

Dale, I think I need your help to tell me what else needs to be changed.

I've solved my problem. Updated Python code in thread linked above.
Basically, I was inserting 'spaces' where I should have inserted binary 00 at the end of every record.