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.
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 (") :-
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
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
Gemini uses Sage 50 to store it's accounting data, please refer to the Sage Line 50 document for information
The people behind DMS Navigator are motor trade veterans. We have decades of industry experience, both in running dealerships and delivering excellent software. Our Navigator system is designed to meet the challenges we all face. No wonder we’ve helped so many businesses grow.
