The step-by-step export from Garage Hive
Moving from Garage Hive is a one-off job, so it is worth getting right. Settings → Data Import takes you through it one list at a time, and checks each file as soon as you drop it in, so a missing column is found in seconds, not after the import.
How it works
- Start. The first page shows the lists you will export (about eleven), which are Required, Recommended or Optional, and the one way to open each list in Garage Hive: the Search button (the magnifier, top right), which opens Tell Me. Click Start with Customers.
- One page per list. Each page says what the list gives you in MechIQ, then the steps:
- search for the list and click the result with exactly that name (the page names the look-alikes not to click);
- check the columns shown are on the list, and add any that is missing;
- refresh the page (F5) — do not skip this. Garage Hive's Open in Excel exports the list as it was before you added a column;
- clear any filter, so every row comes out;
- Open in Excel and save the file.
- Drop the file on the page. MechIQ reads it and answers at once:
- Accepted: for example Customers — 3,928 rows. Account references on all of them. Address, City and Post Code present.
- A problem, with the fix beside it: No External System No. column. If you added this column in Garage Hive, check you refreshed (F5) before Open in Excel. Drop the corrected file to replace it, or Use this file anyway.
- A different file: lines.xlsx looks like Posted Sales Invoice Lines, not Posted Sales Invoices. Click Put it on the Posted Sales Invoice Lines step: nothing is lost.
- A list MechIQ does not import yet (credit memos, return jobsheets) is named and left out.
- A date filter looks to be on when the earliest date in the file is recent.
- Next opens once the file is accepted, or you skip it.
- Review and import. The last page lists every file being imported, every file not being imported with what that means, and checks across your files (for example invoice lines whose job is not in the Posted Jobsheets file). Then the usual preview: what will be created, the account-reference warnings and Import all.
Skipping a file
Every file can be skipped, Required ones too. Skip this file first tells you exactly what will not come across, for example:
- No Customer Ledger Entries: credit your customers hold on account does not come across …
- No Vendors: your parts show supplier codes (EURO, FIN001 …), not names …
A file other files need takes them with it: skipping Posted Jobsheets skips Posted Sales Invoice Lines too (the lines belong to the jobs). Each warning also says whether the file can be imported later on its own. Import it after all takes a skip back at any time. After the import, the summary and Previous imports list what was not imported.
Stop and carry on later
Exporting eleven lists takes a while. Everything you drop in is kept with your garage, so you can close the page. Next time, Resume your import shows how far you got: Carry on goes to the first list not done yet; Start again deletes the files you added (nothing was imported). An import left unfinished is deleted 30 days after its last change.
Already have every file?
Click I already have all my files on the first page to drop them all in at once: the upload-everything import. The full printable guide, with every column, is Importing from Garage Hive.