Search found 24 matches

by roxy99
Wed Jan 14, 2009 12:31 pm
Forum: Dale Harris Educational Software
Topic: POS file formats
Replies: 15
Views: 55835

Re: POS file formats

That's odd. The syntax error is highlighting the single quote. Try replacing all single quotes with "
Also, try escaping the - symbol like this "\-"

Last resort, try python 2.6 which is the version I used.
by roxy99
Fri Jan 02, 2009 9:15 pm
Forum: Dale Harris Educational Software
Topic: POS file formats
Replies: 15
Views: 55835

Re: POS file formats

That's correct. Its updated above. Let me know if its useful.
by roxy99
Sun Dec 28, 2008 4:00 pm
Forum: Dale Harris Educational Software
Topic: Free POS and sales journal integration with Excel
Replies: 4
Views: 5372

Re: Free POS and sales journal integration with Excel

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.
by roxy99
Sun Dec 28, 2008 3:59 pm
Forum: Dale Harris Educational Software
Topic: POS file formats
Replies: 15
Views: 55835

Re: POS file formats

I've solved my problem. Updated Python code above.
Basically, I was inserting 'spaces' where I should have inserted binary 00 at the end of every record.
by roxy99
Sun Dec 28, 2008 12:28 pm
Forum: Dale Harris Educational Software
Topic: Free POS and sales journal integration with Excel
Replies: 4
Views: 5372

Re: Free POS and sales journal integration with Excel

Happy Holidays Everyone! I've been able to import successfully customer data using Python (see http://www.dhpos.com/discuss/phpbb3/viewtopic.php?f=1&t=1071) However, I am stuck with a bug. See the attached image http://www.hydranterouge.com/poscust.jpg Notice that sales history has bogus numbers. Th...
by roxy99
Sun Dec 28, 2008 12:20 pm
Forum: Dale Harris Educational Software
Topic: POS file formats
Replies: 15
Views: 55835

Re: POS file formats

I have successfully programmed in Python a utility import program to retreive customer information from a text csv file. For those willing to download the Pyhton interpreter this may be useful. import re import binascii custcst='c:/pos/test.cst' #replace c:/pos/test.cst with actual .cst file custcsv...
by roxy99
Tue Dec 23, 2008 4:36 pm
Forum: Dale Harris Educational Software
Topic: POS file formats
Replies: 15
Views: 55835

Re:

The below code will export the Barcode, Description and Inventory of your store for easy export into other software. I'm currently working on an PHP/mySQL import program. DIM TB$(13) FL$ = "C:\POS\POSFILENAME": COLOR 15, 1: CLS OPEN FL$ + ".POS" FOR RANDOM AS 1 LEN = 80 OPEN FL$ + ".CSV" FOR OUTPUT...
by roxy99
Tue Dec 23, 2008 4:32 pm
Forum: Dale Harris Educational Software
Topic: Free POS and sales journal integration with Excel
Replies: 4
Views: 5372

Re: Free POS and sales journal integration with Excel

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. ...
by roxy99
Mon Dec 22, 2008 7:43 pm
Forum: Dale Harris Educational Software
Topic: Free POS and sales journal integration with Excel
Replies: 4
Views: 5372

Free POS and sales journal integration with Excel

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...