Navigator are experienced in Data Migration from many systems and have notes, made by customers who have migrated from various systems on how to extract data from various systems.

Gemini is one such system. Notes on how to extract data from Gemin are below. These should be verified to be up to date and DMS provide no warranties onto accuracy on current versions of the system as they may change from time to time.

‍Parts

Stock list

Reports > Parts  Reports > Stock Report > partsstock.csv

Reports > Parts Reports > Retail Pricelist (only qty above zero)> parts.txt (save as text file)

Download partshist.qry (used below) 

Reports > Misc Reports > Data Export > Open Query > partshisrt.qry > Build Query > export as text file (csv) > as partshist.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote (") :-

‍

Customers

Download customer.qry (used below)

Reports > Misc Reports > Data Export > Open Query > customer.qry > Build Query > export as text file (csv formatted) > as customer.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote

‍

Download customer2.qry (used below)

Reports > Misc Reports > Data Export > Open Query > customer2.qry > Build Query > export as text file (csv formatted) > as customer2.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote

Download vehicle.qry (used below)

Reports > Misc Reports > Data Export > Open Query > vehicle.qry > Build Query > export as text file (csv formatted) > as vehicle.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote

Download vehicle2.qry (used below)

Reports > Misc Reports > Data Export > Open Query > vehicle2.qry > Build Query > export as text file (csv formatted) > as vehicle2.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote

Service history

Download servhist.qry (used below)

Reports > Misc Reports > Data Export > Open Query > servhist.qry > Build Query > export as text file (csv formatted) > as servhist.csv

NOTE: when exporting as a text file, there is an option for setting a delimiter, set to a comma and also the character to surround text fields which should be set to s double-quote

‍

‍

Accounts Data

‍

Gemini uses Sage 50 to store it's accounting data, please refer to the Sage Line 50 document for information

‍

‍

‍