An import that stops leaves the study unchanged. The Import a file dialog says in one sentence, beside its main button, what is still missing. Validation messages lists the messages.
The file writes decimals differently from the study#
What you see. Importing into a study stops with The file writes decimals with a comma; this study uses a decimal point. Change the number format in Set up first., or the reverse.
Why. The study's Numeric convention doesn't match the file. 1,234 is 1234 with a decimal point but 1.234 with a decimal comma. A new study made from a file takes the file's convention. See How values are read.
Recover.
- On Set up, open Calculation settings, set Numeric convention to match the file and choose Save changes. In Change the number format?, choose Change number format.
- Import the file again.
Numbers were read as the wrong values#
What you see. Values are a thousand times too large or too small, or rows are flagged as written in the other decimal convention.
Recover.
- Set Numeric convention as above.
- In Data, check that the flagged rows are clear and a few values read correctly.
- Choose Calculate results again.
The new calculation names rows that may have been misread. Check them against the original file. Changing the convention keeps your corrections and exclusions. Replacing the rows from the file would drop them. If only a few values are wrong, edit those rows instead.
The columns do not line up#
What you see. First rows as they will be imported shows values in the wrong columns, the whole line in one column, or a message such as The header has 4 columns, but line 7 has values beyond them.
Why. A value contains the separator without quotes, for example 1,234.5 in a comma-separated file.
Recover. Re-export the file with quoted values or another separator. Semicolon or tab suit decimal-comma laboratories. Then choose the file again.
A column was read as the wrong thing#
What you see. Under Adjust columns, a column is marked choose or check, or its use is wrong, for example a sample number read as a result.
Recover. Open Adjust columns and pick the right use from the column's list, or Not used. The summary, the studies the file can feed and the first rows update at once. To reuse the choices for the next file from the same export, choose Save these column choices for next time. See importing a file.
The study I want is not ready#
What you see. Under This file can feed, the study has no ready mark and a line such as Answer the question above or a missing column.
Recover. Answer the open question, or give the missing column its use under Adjust columns. If the file lacks the column, add it, for example Day, Run and Replicate for multi-day precision. See the column reference and Templates and downloads.
A file with several analytes or units#
What you see. Split this import lists groups with a different analyte, matrix, instrument or unit.
Why. One study holds one analyte, matrix, instrument and unit.
Recover.
- If groups differ only in spelling, such as
mg/dLandmg/dl, choose Cancel, fix the file and import again. - Otherwise tick Create a study for each group and choose Import the chosen groups. New studies get their rows and this study's design. Set their acceptance limits on Set up in each.
- Groups you leave unticked are not imported.
An empty study can take another group with Use this study. Its analyte-specific settings and limits are then cleared. See Files that mix analytes, matrices, instruments or units.
The import stops at repeated rows#
What you see. The dialog lists rows already in this study, or says This file is already imported into this study.
Why. Incoming rows match saved rows on identifiers, design fields and original values, or the same file was imported before. Most often this is an accidental second import.
Recover.
- Accidental: choose Cancel. If the file also has new rows, remove the repeated ones and import again.
- Genuine identical repeat measurements: choose Import an intentional repeat.
The import is blocked by ambiguous matches#
What you see. The dialog lists rows that match more than one row in this study, and offers no import button.
Why. In method or lot comparison, an incoming specimen ID, with its lot in lot comparison, matches more than one saved row. Other study types accept more readings for an existing material or pool ID.
Recover.
- Wrong IDs: correct them in the file or the saved rows, then import again. Keep each specimen's true ID.
- Genuine replicates in method or lot comparison: use Add row in Data, keeping the specimen ID and entering the new replicate label. Each method-comparison row needs both results.
- More measurements in repeatability, interference, stability or another study type: import only the new rows, with Replace the current rows unticked.
Appending keeps your corrections and exclusions. Replacing the rows drops them. See Append or replace.
A paired specimen still shows a missing result after appending#
What you see. In method comparison, after you append the missing results, both the old and the new rows ask for a result.
Why. Appending adds new rows. Each row must hold both results.
Recover. Exclude the appended half row with a reason, for example "Imported in error: second half of specimen P2 entered on row 3". Then type the missing result into the original row.
Formula text was imported instead of results#
What you see. Results such as =B2*1.05, flagged as a spreadsheet formula.
Why. The column holds formulas, and formulas are read as text.
Recover. In Excel, copy the column and use Paste values, check the values and save. Import again with Replace the current rows ticked, or correct a few rows in Data.
The wrong worksheet was imported#
What you see. The summary or the imported rows show another sheet's data.
Why. A workbook opens on the sheet that was open when it was last saved. Choose another sheet under Worksheet in the dialog before you import.
Recover. If the rows are already in the study, import the right sheet with Replace the current rows ticked.
Accented text looks wrong#
What you see. The dialog says the file was read as Windows text, and the words it shows look wrong.
Recover. Export the file again as UTF-8 (in Excel: CSV UTF-8) and choose it again.
The workbook or file is too large#
What you see. Choose a CSV or TSV file of at most 2 MB., Choose a workbook of at most 2.9 MB., Paste at most 2 MB of text, or choose the file instead., This workbook holds more than 40 MB of worksheet data… or An import can have up to 2,000 results and 40 columns.
Recover. Copy only the results table, one header row and the data rows, into a new workbook or a UTF-8 CSV, and remove unused columns. A study holds at most 2,000 observations. Split larger sets into studies by level, instrument or another design factor.
Leading zeros disappeared from IDs#
What you see. Specimen 00012 appears as 12.
Why. Excel stored the IDs as numbers. CSV files and text cells keep leading zeros.
Recover. Format the ID column as Text and re-enter the IDs, or export to CSV. Then import again with Replace the current rows. 12 and 00012 are different specimens, so use one form throughout.
The study changed while the dialog was open#
What you see. A message says … saved data version 5 while this page had data version 4 open. Nothing was overwritten., or that the study changed after the import was prepared.
Why. The study was saved in the meantime, by a colleague or from another tab. Nothing was imported.
Recover. Reload the study, reopen Import a file and repeat the import. See Someone else saved the study.