Support

Legacy LunchBox to LunchBox2
Graduated Students Transfer

Note:  A backup of the student file is automatically performed before any changes are made. The backup filename is created from the system time. (ie. FJ + hhmmss +.DBF) so a backup created at noon would be named FJ120000.DBF and FJ120000.CDX and FJ120000.FPT If you have problems with the student file after the import rename those 3 files back to STUDENT.DBF ; STUDENT.CDX ; STUDENT.FPT or restore the backup you did.

1.  This must be run in the LunchBox folder. (I would suggest modifying the Memory properties of the EXE to match those of the LunchBox EXE.)

2. To move graduates from a LunchBox² site to a Legacy LunchBox site...

At the LB2 Site

3.  Go to Communications >> Participant ExportSettings

4.  Copy the "LunchBox POS Graduate Export (version 2.0)" to a new Export Job (something like 'Export Graduates to Legacy (Fox2Jav2)')

5.  Modify the export to use a COMMA instead of a TILDA ( ~ ) as the delimiter

6.  Change the first column of the export from ParticipantID to POSID

7.  Modify the export filename to GRADEMPT.TXT

8.  Perform End Of Year Maintenance to populate the GRADS table in the SQL database

9.  Perform the new export you just created

10.  Move the new GRADEMPT.TXT file to the LunchBox folder at the Legacy site

At the Legacy Site

11.  Run FOX2JAV2.EXE

12.  Select "Import Students Into LunchBox"

Follow On-Screen Instructions

13. Select "APPEND to existing Student File"

14.  To move graduates from a Legacy site to a LB2 site...

At the Legacy Site

15.  Perform legacy End of Year procedures to Graduate Students to populate the Grads table in Legacy LunchBox

16.  Run FOX2JAV2.EXE

17.  Select "Export Students From LunchBox"

18.  Select "Graduate File Only"

19.  Select export location: LunchBox Folder or Floppy Diskette

20.  This creates GRADEXPT.TXT

21.  Move GRADEXPT.TXT to the location specified in the POSBO import "LunchBox POS Graduate Export (Version 2.0)"

22.  Change the filename to the filename specified in the POSBO import "LunchBox POS Graduate Export (Version 2.0)"

23. Perform the POSBO import "LunchBox POS Graduate Export (Version 2.0)"

24. Complete student files can be exported from or imported into Legacy LunchBox as well.

25.  Exporting files from Legacy LunchBox using Fox2Jav2 does NOT remove any student data from the Legacy LunchBox student file.