JubaConv Utility for TOUCHNET

Last edited: December 15, 2003 08:09 AM

This is a conversion utility written for Juba. It will read TOUCHNET’s sales journal (.JOU) and time journal (.TIM) files and convert them to a format requested by Juba.

It will create three types of files. They are as follows:

Name: LIYYMMDD.CSV (where YYMMDD is the date selected to convert)
Purpose: Line item detail of each check.
Location: Application directory.
Type: ASCII comma delimited.
Size: Variable dependent on number of records
Record format:

        Product ID INTEGER
        CheckNo. INTEGER
        Product Sales Count INTEGER
        Unit Price EACH
        Sales Dollar NUMBER
        Store Number INTEGER
        Date DATE

Name: CHYYMMDD.CSV (where YYMMDD is the date selected to convert)
Purpose: Detail of each check.
Location: Application directory.
Type: ASCII comma delimited.
Size: Variable dependent on number of records
Record format:

    CheckNo. INTEGER
    Employee ID INTEGER
    Date DATE and TIME
    Store Number INTEGER
    Tran Type TEXT (Paid or Void to be enhanced w/v5)
    Total Product Sales NUMBER
    Sales Tax NUMBER
    Check Total NUMBER
    Amount Tendered NUMBER

Name: LRYYMMDD.CSV (where YYMMDD is the date selected to convert)
Purpose: Detail of each time transaction.
Location: Application directory.
Type: ASCII comma delimited.
Size: Variable dependent on number of records
Record format:

    Employee ID INTEGER
    Regular hours NUMBER
    OT Hours NUMBER
    Job Class TEXT
    Labor rate per hour NUMBER
    Start Time DATE and TIME
    End Time DATE and TIME
    Store Number INTEGER

INSTALLATION INSTRUCTIONS

There are two files needed to run the program:

  1. JubaConv.EXE
  2. JubaConv.RES

All conversion files will be created in the directory where the program is run from, so you might want to make a specific directory to store these files. Place the two needed files in the directory of choice.
RUNNING THE PROGRAM

The program can be executed with a command line switch or the user can interact with the GUI.

SYNTAX: JUBACONV {/DATE=DATE} {/?}

* /DATE=YYMMDD format for day to convert files for, or ‘TODAY’ for today’s date or ‘YESTERDAY’ for yesterday’s date. Example: /DATE=TODAY

* /? Displays help info.

NOTE: When no command line switch is present JubaConv will present the user with a menu for selecting a date to convert.

To define paths for individual stores, run the program with no command line switch. Select the Options button. You will be presented with a list box containing the defined stores. You can add, edit or delete items from the list. The syntax for the paths is: {directory} Example: juba1 The syntax for the store number is number up to 4 digits. Example: 1234

To convert a dates TOUCHNET native files, select a date from the list, then select the Convert button. This will create the 3 files named above in the directory JubaConv is running from.
Revisions

03/01/95 Version 1.01

  1. Forced the DATA directory to be used for the path to Employee.DAT file. Forced the REPORTS directory to be used for the path to the sales and timekeeping journal files.

03/27/96 Version 1.02

  1. Fixed bug relating to last record in Check File. The time and date were switched, I had forgotten to make the necessary changes. Allowed for 10 more characters in Store Path definitions. Updated the Help file. Addressed requests by Lance Corbin.

            * Use 0 if no PIN found in Line Item File.
            * Allow for drive and path, look there for all necessary files, do not look in the DATA directory or REPORTS directory.

04/16/96 Version 1.03

  1. Fixed bug relating to reporting discount PLUs in Line Item detail file. (PLUs rung up at a negative amount.) Previously JubaConv would decr the quantity sold and only use the last one found on the check. Now will report each Discount PLU encountered separately.
  2. Fixed bug related to defining stores path. Would not store the last 10 characters of the path typed in on the Edit Store dialog.
  3. Updated the Help file.

01/06/97 Version 1.04

Requests

  1. Tim Mate for Lance reports negative hours being reported in CSV file when employees work past 12:00 am. Actually the hours are fine, but his Sequel Server database program does not know how to handle the date when the time out is less than the time in. I will address this by changing the time out date to the next day if the time out is less than the time in.
  2. Tim Mate wants the store number in the Labor CSV. Add it at the end of the file.

Additions/Completions

  1. Changed the way the Labor CSV file reports the date for the time out. It will now report the day after the time in if the time out is less than the time in.
  2. Added new field to the Labor CSV file. Store number has been added.
  3. Compiled with new libs.