DATA TRANSLATION OF EXISTING SYSTEM DATA TO NEW SYSTEMS

The Dar System

The various Symphony .wrk spreadsheets were assembled from various hard and floppy discs, and were then brought into Lotus 123 spreadsheets (type .wk3) and manually internally moved around to a column type spreadsheet.

These many (approx 70) Lotus spreadsheets were then merged together into one large Lotus spreadsheet (using Lotus).

The export to Dbase3+ facility in Lotus Translate was then used.

Dbase3+ was then used to clean up the output from the Translate Utility (which never quite works correctly).

Note that the yardage and/or number sold information was never brought over, because it was difficult to locate in the spreadsheets, and because Dar bulks yardage over 7 day and 30 day periods. The yardage as used in the previous Symphony system can always be accessed from the weekly and monthly printed reports file if required.