Convert the .REC file to a .CSV file.

Make comments, ask questions, or just complain about the software on this site. Or comment on any educational software.
Please note that by clicking on links that may appear in these posts that you may be leaving the Dale Harris Educational Software website and that the content of those sites is the sole resposibility of the authors of those sites.

Moderators:daleadmin, Dale Harris, Alan, Andrew

Post Reply
User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm
Convert the .REC file to a .CSV file.

Post by daleadmin » Thu Jan 27, 2011 4:51 pm

Here is a program file that will take your file of past transactions and rewrite it to a .CSV data file that can then be loaded into any spread sheet software. What to do with it once you get it there is up to you. This will convert all transactions including open, close, and no sales.

Here is a CLOSE transaction as it looks after being loaded into Excel

Code: Select all

BEGIN CLOSE TRANSACTION #   872  1/27/2011  13:43	
      TX1A   8.750%                          0.38
      TX2A   2.000%                          0.12
      TOTAL TAX A                             0.5
      TX1B   2.500%                          0.11
      TX2B   1.250%				   0.08
      TOTAL TAX B                            0.19
      UNIT TAX                                0.5
      TOTAL TAX                              1.19
      CASH SALE:              2             10.27
      CHECK SALE:             0                 0
      CREDIT SALE:            0                 0
      DEBIT SALE:             0                 0
      GIFT CARD SALE:         0                 0
      SALE:                   0                 0
      CASH RETURN:            0                 0
      CHECK RETURN:           0                 0
      CREDIT RETURN:          0                 0
      DEBIT RETURN:           0                 0
      GIFT CARD RETURN:       0                 0
      RTRN:                   0                 0
      NET SALES:              0             10.27
      TOTAL TAX:              0              1.19
      GROSS SALES:            0             11.46
      TIPS:                   0                 0
      CASH BACK:              0                 0
      SUB REG CASH:           0             11.46
      CASH DROPS/PULLS:       0                 0
      + CASH FUND:            0               125
      CASH IN REG:            0            136.46
      CHECKS IN REG:          0                 0
      CREDIT IN REG:          0                 0
      DEBIT IN REG:           0                 0
      /REG:                   0                 0
      TOTAL PAYOUTS:          0                 0
      TOTAL DISCOUNTS:        0                 0
      TOTAL REDUCTIONS:       0                 0
      TOTAL COUPONS:          0                 0
      TOTAL VOIDS:            0                 0
      TOTAL GIFT CARDS:       0                 0
      SALES TRANSACTIONS:     2		
      RETURN TRANSACTIONS:    0		
      PAYOUT TRANSACTIONS:    0		
      NO SALE TRANSACTIONS:   0		
      GIFT CARD TRANSACTIONS: 0		
      TRANSACTION TOTAL :     2		
Here is a SALE transaction as it looks after being loaded into Excel

Code: Select all

BEGIN	      SALE TRANSACTION #	871	1/27/2011	13:43	
              1. DALE				
STOCK NUMBER  DESCRIPTION              TAX RATE   PIECES   UNIT PRICE   PRICE
       60004  COLOR KEY TWO SIDED	          2        1         2.99    2.99
       60008  RUBBER GRIP DOMESTIC KEY        1        1         4.29    4.29
                                              2		
              SUB TOTAL                                                  7.28
              TAX1A at 8.75%                                     0.38	
              TAX2A at 2%                                        0.06	
              TAX1B at 2.5%                                      0.11	
              TAX2B at 1.25%                                     0.04	
              SALES TAX                                                  0.44
              PROVINCIAL                                                 0.15
              UNIT TAX                                                    0.5
              TOTAL                                                      8.37
              CASH TENDERED                                              8.37
The current program file will only take the last 10 transactions from the .REC file and dump them to a .CSV file. The purpose of this is to see what sample transactions will look like. You can load the .CSV file into Excel and see what you get. Now is the time to complain.

I am also looking for input on how folks want to choose which files to convert starting from the last recorded transaction.

1. All transactions in the file?
2. Only today's transactions?
3. Enter a transaction number and go back to that?
4. Enter a date and go back to that?
5. Enter a date and only convert that date.
6. Enter a transaction number and only convert that transaction?
7. Mutiple options from above?

Would you want to be able to launch this program from the POS.EXE program using the [F4] option?

I am on vacation for the next 3 days so if I hear back from you I can work on the program then to finish it.

Here is the download link http://www.dhpos.com/R2C.EXE You will have to download it to the same folder that holds you other DHPOS program files and run it from there.

Dale

User avatar
peewee3ie
Forum Regular
Posts:225
Joined:Tue Jan 27, 2004 7:46 am
Location:Ireland
Contact:

Re: Convert the .REC file to a .CSV file.

Post by peewee3ie » Fri Jan 28, 2011 8:35 pm

Hi Dale,

I would use and have just show this to a friend who use your software every day.

It would be options 1, 2, 5, 6 for both of us.

Also is there any word on customer accounts.
Tony McGuire
Ireland Support

cpb14
Forum Regular
Posts:56
Joined:Fri Oct 22, 2010 10:44 pm

Re: Convert the .REC file to a .CSV file.

Post by cpb14 » Fri Jan 28, 2011 10:43 pm

Hi Dale

i would like
1. All transactions in the file
2. Only today's transactions
5. Enter a date and only convert that date.
6. Enter a transaction number and only convert that transaction

Thanks
CB

victory
Occasional Poster
Posts:12
Joined:Sun Feb 07, 2010 2:52 pm
Location:Kingston, Jamaica

Re: Convert the .REC file to a .CSV file.

Post by victory » Sat Jan 29, 2011 12:39 pm

Hello Dale

I would like suggest the following:

1. All transactions in the file
2. Date Range
- 1st and 2nd date fields have today's date (Today's Transactions)
- 1st date field has the starting date and the 2nd has the ending date
3. Transaction Number
- 1st and 2nd transaction number fields have the same number (Single Transaction)
- 1st transaction number field has the starting transaction number and the 2nd has the ending number

Thanks.

Victory

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: Convert the .REC file to a .CSV file.

Post by daleadmin » Sat Jan 29, 2011 4:22 pm

I seem to have possibly finished this.....
==============================================================================
Data File Creator

This program will read transactions from the file of past transactions (the ones you can access from the '5. Voids' feature of the main Cash Register program – the .REC file) and will write them to a .CSV data file that you can then load into any spreadsheet.

Only those transactions that are still in the file (if you are saving a file) will be written. So if you are only storing 100 transactions then this program can only write the last 100 transactions to the file.

ALL transactions will be written in the range you choose, including OPEN, CLOSE, and NO SALE. Most all information in each transaction will be written.

Why would you want to do this? Well loading it into a spreadsheet program is not really that useful. However it will give you access to the data if you wish to write your own software to handle the data for whatever nefarious purpose you have in mind. This will require that you can write software or know someone that can. Some labels will be included in the file to help you parse the information.

You can write all transactions currently in the file, or you can choose to write only part of the file using the following options…

1. You can write only from the last transaction rung up to a previous date.
2. You can write only from the last transaction rung up to a particular transaction number.
3. You can write only those transactions that occurred on a specific date.
4. You can write only a specific transaction.

View screen http://www.dhpos.com/rec2csv.jpg

Just remember that you cannot write transactions that are no longer in the file. If you are saving only 100 transactions, and the last transaction rung up was 5000, then transaction 4898 is not in the .REC file and cannot be written to the .CSV file.

Text data may not contain quote marks (“). Before being written to the file all quotes will be changed to an apostrophe. Text data may contain commas.

This program is [F4] compliant. This means that if you know how you can program the main POS program to launch this program from the main menu of the POS program by pressing [F4]. Then when this program is finished you will be returned to the main menu of the POS program.

So I need some beta testing on this thing. The download link is http://www.dhpos.com/rec2csv.exe The version number is 7.04hx5

Dale

cpb14
Forum Regular
Posts:56
Joined:Fri Oct 22, 2010 10:44 pm

Re: Convert the .REC file to a .CSV file.

Post by cpb14 » Sat Jan 29, 2011 6:01 pm

ok Dale i began Testing so far so good i will report in Chat and hear in the Forum

Thanks
CB

cpb14
Forum Regular
Posts:56
Joined:Fri Oct 22, 2010 10:44 pm

Re: Convert the .REC file to a .CSV file.

Post by cpb14 » Sat Jan 29, 2011 6:10 pm

Dale Everything looks Fine
Thanks CB

Will Continue to TEst

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: BUG: Convert the .REC file to a .CSV file.

Post by brucef2112 » Wed Jun 22, 2011 7:21 pm

Hey Dale,
I was using REC2CSV.EXE version 7.1b and notice a crazy tax amount where no tax should have been.
This was a transaction selling a gift card.. Here is how it came out of the POS into the CSV file.
Some how there is 538,976,288 showing as a unit tax.

Code: Select all

STOCK NUMBER	DESCRIPTION                 TAX RATE PIECES	UNIT PRICE	PRICE
       0	GIFT CARD***********3456  		  0		    1	   111100	111100
			1		
	SUB TOTAL				111100
	TOTAL TAX				0
	UNIT TAX				538976288
	TOTAL				        111100
	CASH TENDERED				11
	CREDIT TENDERED				111089
	TOTAL TENDERED				111100
What is that? Personaly I've never had my unit taxed. :oops:

where did the 538976288 come from? It doesn't show in the POS or the F5 void. only in the REC2CSV export.
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: Convert the .REC file to a .CSV file.

Post by daleadmin » Thu Jun 23, 2011 9:40 pm

Bruce,

I have fixed this. However the problem was caused when the gift card was sold so the new version will still display the error on old transactions. Only gift card transactions rung up with the new version 7.1c will not longer display the error.

I have uploaded a complete version 7.1c and all the program files are labeled version 7.1c

http://keyhut.com/pos3.htm

Dale

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: Convert the .REC file to a .CSV file.

Post by brucef2112 » Sat Jun 25, 2011 3:53 pm

thx dale...
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

Post Reply

Who is online

Users browsing this forum: No registered users and 52 guests