Bring your client list from any spreadsheet, CSV or CRM export. We match your columns and you check every row before anything is created. Each row becomes a client farm that your practice manages until its grower claims it, the same as when you set up a client farm by hand.
The import goes through these steps: Source, Columns, Review, Who pays and manages the data, Fields file (optional) and Done. Nothing is created until you confirm at the end of the fields file step. You can leave and come back, and the import keeps your progress.
Before you start
- Owners, admins and agronomists of the practice can import clients. Others see Your role can't import clients.
- Confirm your email address before you create the farms.
- Each farm counts towards the client farms your practice can set up. That is 1 on the Free plan, no limit during the trial and no limit on the Advisor plan. Rows over the limit are marked Over your limit of new clients.
- If the grower already uses Truleaf Fields, connect to their farm instead of importing it.
Bring your list
- On the client list or the portfolio, select Add client, then Import my clients.
- With File, drop the file on Drop your client list here, or select Choose a file. XLSX, ODS, CSV and TSV files work, and so do exports from your CRM. In a workbook, only the first sheet with data is read.
- Or choose Paste a table. Copy the rows with the column names from your spreadsheet or email. Then select Read my list.
You see Opening your list… while the list opens.
Your own column names are fine. If you'd rather start from ours, Download a template gives you an empty file with them.
The largest list an import can take is shown under the file box. Split a longer list and import it in parts.
Note
We only use this list to set up your clients. It is deleted 7 days after the import. Column matching only looks at the header row and 5 sample rows, with emails and phones masked.
Match the columns
The import suggests which of your columns holds the farm name, the grower's email, the country and so on. A column matched from the template shows From the template. One matched by its name shows Matched by header, and other suggestions show Suggested. When there is nothing to suggest, you see Match the columns yourself. It takes a minute.
- Select Review mapping. The sheet How your columns match lists Your column, a few Examples and Imports as.
- For each column, pick what it imports as, or choose Don't import. Check the columns marked Check this column.
- You need a Farm name column. Without it, you see Choose the column with the farm name.
- Select Confirm all to accept the suggestions, close the sheet, then select Continue.
Review every row
Each row gets a status: Ready, Check, Can't import or Duplicate. The chips above the table filter the rows by status.
- Fix opens the row to correct it.
- Skip row leaves a row out, and Import this row brings it back.
- For a duplicate, choose Skip or Import anyway. A row is a duplicate when it repeats another row (same email, same reference, or same name and town). It is also a duplicate when it looks like a client you already have (same email, or a very similar name in the same country). Importing it anyway creates a separate farm. Nothing is merged.
- Skip rows with errors leaves out every row that can't be imported.
Rows without a country or a language take your practice's own. To change these defaults, select Change.
Common row messages:
- Farm name is missing.
- No email: the claim invitation can't be sent yet.
- Already your client.
- Truleaf Fields isn't open in this country yet.
Select Continue when every row you want is ready.
Who pays and who manages the data
The imported farms start on the Free plan, with 1 field each of at most 10 ha. To cover more for some clients, write to support.truleaf@truleaf.org.
- Tick the box confirming that your practice manages the data of these farms for their growers until they claim them. Data management terms opens the terms that apply.
- Select Continue.
Invitations to claim: held. You choose who to invite at the end.
Add the fields from a single file (optional)
One file with the outlines of many farms? Add it here to give each farm its fields at once. KML, KMZ, GeoJSON, Shapefile, GPX or CSV with coordinates.
- Select Choose a fields file.
- Choose the Column in your client list and the Property in the fields file. Pick the two that name the same farm, like the farm name.
- Select Match outlines. The preview says how many farms matched and how many have no outlines.
This file has points, not outlines. Add the fields of each farm later.
Then select the button that creates the clients. It works with or without a fields file. You can leave this page; the import carries on.
Invite the growers
The last step shows how many farms are ready, how many have no fields yet, how many were over the plan limit and how many invitations are not sent.
Under Invite growers, owners and admins choose to:
- invite every grower with an email at once;
- pick the growers with Choose who to invite;
- invite them later from the client list, with Later.
Agronomists see Ask an owner or admin to invite the growers.
Below, Your new clients lists each farm with Open and Add fields. Rows that failed show the reason. Select Retry failed rows to try them again. Finish with Open client list or Open portfolio.
To follow the invitations, see Hand over a farm to its grower.
Cancel an import
Until the farms are created, select Cancel import. Nothing has been created yet.
An unfinished import expires after some days without changes. It then shows This import has expired. Select Start again to begin again.
Limits
- File size. A file that is too large shows This file is larger than 5 MB. Split the list or paste the table instead.
- Rows. Each import takes a limited number of rows, shown under the file box.
- Imports a day. You've started 5 imports today. Try again tomorrow, or set up one client by hand. Starting an import and creating its farms both count towards this daily limit.
Common problems
- We can't open XLS files. Save it as XLSX or CSV, or copy the table and paste it here.
- We can't read this list. Use an XLSX, ODS or CSV file, or paste the table from your spreadsheet.
- This list has no rows.
- Your practice's account is read-only. Update payment to add clients.
- Someone else changed this import. We've loaded the latest.
- This is taking longer than usual. You can keep waiting or cancel the import and start again.
- You're offline. Importing clients needs a connection.
Related pages
Still stuck?Email support.truleaf@truleaf.org