Import from Spreadsheets

If you already keep records in a spreadsheet, you can bring them into Sporeline in one go instead of typing them in one at a time. Imports live at Settings > Import, and Managers and Owners can use them. Workers and Viewers don’t see the page.

What you can import

There are seven kinds of records you can bring in: recipes, customers, harvests, bag types, locations, batches, and blocks. Batches come with their blocks, either a set number of blocks per row or one block per row grouped into batches by a column you pick. Blocks go into batches that already exist, so import or create the batch first. Harvests are recorded on blocks that already exist, the same way a harvest entered in the app is, so the block’s totals, flushes and timeline all pick them up.

Check first, then import

An import happens in two steps. First you paste the rows or upload the file, match your columns to Sporeline’s, and click Validate & Preview. Nothing is saved yet. The preview tells you how many rows are good, lists every row that has a problem with its row number and what’s wrong, and shows the first ten rows as they’ll come in.

When the preview looks right, click Import to save the good rows. Rows that failed the check are skipped, and the results screen tells you how many rows came in and names any row that couldn’t be saved, so you can fix those in your spreadsheet and import just them.

If an import stops partway

A big import can occasionally get cut off before it finishes. When that happens, the import shows up under Recent imports marked Stopped, with a line that says how many of its rows are already in. It takes about five minutes after the import started for Sporeline to call it stopped, because until then it may still be running. A stopped import stays in the list until it’s resumed, and if you’ve run a lot of imports since, Show older imports at the bottom of the list brings in the earlier ones.

Click Resume import to finish it. Sporeline picks up at the rows that weren’t saved yet and doesn’t bring in the saved ones again, and when it’s done the import shows as completed with the full count. If the button says the import moved on, someone else already resumed it, so reload the page to see where it stands.

For recipes, customers, bag types and locations, a resume never makes a second copy of a row, even the row that was being saved at the moment the import stopped. It also leaves alone anything you changed in the meantime, so if you fixed a customer’s address while the import sat stopped, your fix stays. Batches and blocks are different: if the import stopped right as a batch or block was saved, that one can come in twice when you resume. When you import batches with one block per row grouped into batches, that means one batch with its blocks. It is never more than that one, so after resuming a batches or blocks import, look at the last batch or block from before the stop and delete the extra copy if there is one. A batches or blocks row that ran into a problem before the stop isn’t tried again either, because part of it may already be in. The results list it with a note to check whether it’s in Sporeline and import it from a new file if it isn’t.

Two kinds of stopped import show as Stopped without the button. A harvest import can’t be resumed, because a harvest saved right as the import stopped may not have reached your harvest inventory and traceability yet, and resuming wouldn’t finish that part. An import that stopped before Sporeline could resume imports can’t be either, because there’s no record of which of its rows came in. For either one, the line still says how many rows are in where it knows; check your records and import the missing rows from a new file.

Plan limits

Batches and blocks you import count toward your plan just like ones you create in the app. If a row would take you past your plan’s limit, that row is refused with a message saying so, and the rest of the import carries on. The Import Data reference covers the file limits and where those messages come from.

Who can import

Importing is for Managers and Owners, since an import can add a lot of records at once. Workers and Viewers can see the records once they’re in, the same as anything else on the farm.