Sign in Talk to us Free trial
Free trial

Design and software studio
Colour

Fixing import problems

Read each message the import check gives, fix the row or the column choice, and import the rest.

For
OwnerAdministrator
Hosting
Any hosting
Devices
Web browser
Business
All businesses

Checked against Pop Dispatch 0.1.0

The check step lists every problem with the row number from your spreadsheet. A row with a problem is left out, and every other row is imported. Fix the row in your spreadsheet, save the file and check it again. You can also import what is fine now and import the fixed rows later as a second file.

Before you start #

Row numbers are the spreadsheet's own. The header is row 1 unless the file has title lines above it, and blank rows keep their numbers.

Steps #

  1. On the check step, read Problems. A line reads "Row 6: ..." followed by what to do.
  2. Open the file and go to that row.
  3. Fix the cell, or if the same problem repeats on many rows, go back to the columns step and choose a different column.
  4. Save the file, choose it again and select Check the file.
  5. When the list is clear or holds only rows you are happy to leave out, select Import.

Messages about a row #

MessageWhat to do
The VIN "..." has 16 characters; a VIN has 17.Correct the VIN. A VIN has 17 characters.
The VIN "..." has the character "O"...A VIN has no I, O or Q. These are usually a 1 or a 0.
The VIN ... does not pass the check-digit test.A warning only. The VIN is kept as typed. Look at the vehicle to confirm it.
Date in: "..." is not a date.Use a form such as 2024-03-15, 3/15/2024 or 15-Mar-2024. If every date is read the wrong way round, change Dates like 3/4/2024 mean on the columns step.
Total: "..." is not an amount.Use a number such as 125.50 or $125.50. Remove words from the cell.
... has more than two decimal places.Round the amount to cents.
Name is required but this row has none.Fill the cell, or choose another column for that field.
"..." is not an email address.Correct the email or clear the cell.
The year "..." is not a year such as 2019.Use four digits.
This row needs a name, a first and last name, or a company.A customer row needs at least one of them.
Give at least a VIN, a plate or a make for this vehicle.Add one of the three.
Which customer is this for? ...Fill the customer number, phone, email or name column for that row.
No customer on file matches this customer number, phone or email, and there is no name to add one.Import the customers first, or add the customer's name to the row.
No customer named "..." is on file.Import the customers first, or tick Add a customer when a row names one that has no record yet.
More than one customer is named "...".Add the phone number or email so the right customer is found.
No account named "..." is on file.Import accounts before tow rates.
This row has no rate amounts.Fill in at least the hook-up fee or the per-mile rate.
The invoice number is longer than 20 characters...An invoice number holds 20 characters at most. Shorten it.
Describe the vehicle: give a description, a plate or a VIN.A yard row needs one of the three.

Rows that are left alone #

These rows need no fixing. Each is counted under left alone.

  • Already on file as ...: the record exists. Choose Fill in only the blank details from the file on the columns step if you want blank fields filled.
  • Nothing is owed on this invoice, so it was left out.
  • An invoice with this number is already on file.
  • This vehicle has already left the yard, so it was not added to the lot.
  • A vehicle with this VIN or plate is already in the yard.
  • A rate line for this account and truck type is already on file; it was not changed.

Messages about the file #

MessageWhat to do
That is an older Excel file (.xls).Open it in Excel and save it as Excel Workbook (.xlsx) or CSV.
That Excel file could not be opened.The file may be damaged or protected with a password. Save it again from Excel, or save it as CSV.
The file is larger than 5 MB. or more than 20000 rowsSplit it into several files, for example one per year.
A quoted value was never closed.A quote mark has no partner. Look near the last rows.
The file has a header row but no data rows below it.The rows are missing. Export again.
Choose which column holds: ...On the columns step, pick a column for each required field.

If you want to take an import back #

Select Undo this import on the done page, or in Recent imports on the Import data page. It works for 7 days.

  • An import can be undone for 7 days. That time has passed. The import stays. Delete or change records one by one.
  • Some of the records this import made are now in use means a customer has a job, or an invoice has a payment. Nothing was changed. Remove or settle those first, or keep the import.
Technical details
  • The first problem list shows up to 200 lines. The count of any more is shown under it.
  • A row that is blank in every column you chose is left alone with the note "Nothing in the columns you chose."
  • The audit log keeps an entry for each import and each undo.