- This topic has 0 replies, 1 voice, and was last updated 19 years, 2 months ago by
.
-
Posts
-
Journal to Text Conversion Utility
JOU2TXT.EXE for Version 5Last edited: December 15, 2003 08:09 AM
Jou2Txt reads JOU files and creates a comma delimited file consistent with the Microsoft standard, and readable by all major programs. It can easily be integrated into an automated routine to allow for export of our data to a third party program.
Copy JOU2TXT.EXE into the TOOLS directory.
SyntaxJOU2TXT /DATE=date {/TYPE=type} {/MAKE=file} {/HEADER} {/FIXLEN} {/FIXLENHELP}
date=YYMMDD format for day to print report for, or
‘TODAY’ for todays date or
‘YESTERDAY’ for yesterdays date. Example: ‘/Date=TODAY’file=Filename to create (Default is date.TXT)
type=Number representing the conversion method to use:
0 – {Default} Straight Journal Conversion (See Journal.DOC)
1 – Single PLU per Record
2 – Single Check per Record (Narrow format)
3 – Single Check per Record (Medium format)
4 – Single Check per Record (Wide format)/HEADER adds a line of comma delimited labels at the beginning of the file.
/FIXLEN creates fixed length instead of comma delimited output.
/FIXLENHELP gives help screen showing fixed length format.
OperationJOU2TXT must be run from the application directory. The /DATE= command line switch is required. All other switches are optional. The created file will appear in the REPORTS subdirectory. To see what the output looks like for any particular type, run JOU2TXT with the /HEADER option and then view the created file. Recommended types are type 4 which gives all totals posted to the journal for each check, and type 1 which gives all PLU information for each check. Together, these two types export all information contained in the journal.
- You must be logged in to reply to this topic.