Data migration reference
Migrating from Gemini
Use the extraction routes below to prepare the agreed data for Navigator. Menu paths and filenames are retained from the existing guidance.
← Back to data migrationImportant export setting
For text exports, use a comma delimiter and surround text fields with double quotation marks. Check these instructions against the current Gemini version before use.
Parts
Parts stock and history
Reports > Parts Reports > Stock Report → save as partsstock.csv
Reports > Parts Reports > Retail Pricelist → only quantity above zero → save as parts.txt
Reports > Misc Reports > Data Export → Open Query → use partshist.qry → Build Query → export as partshist.csv
Customers
Customer and vehicle data
Run customer.qry and export as customer.csv
Run customer2.qry and export as customer2.csv
Run vehicle.qry and export as vehicle.csv
Run vehicle2.qry and export as vehicle2.csv
Service
Service history
Reports > Misc Reports > Data Export → Open Query → use servhist.qry → Build Query → export as servhist.csv
Accounts
Accounts data
Gemini uses Sage 50 for accounting data. Use the dedicated Sage Line 50 migration guidance for the accounts extraction.
View Sage Line 50 guidance →