Importing your Crop Plan

Importing a crop plan lets you get going in VeggieCropper wherever you are in your crop planning. A half-finished crop plan from last year?  Hey, it is way better than starting from scratch, import it and keep planning with a simplified repeatable workflow (next year's crop plan is 75% done with one click to duplicate and add a year).

Automated 

Email your crop plan spreadsheet to import@veggiecropper.com to have VeggieCropper do it for you.

You can use your 1/2 finished plan from last year, VeggieCropper doesn't care. It will import what it can. Automated Imports typically take 0-2 days.

Importing your crop plan yourself

This is a flexible feature that you can use to import:
  • All of your crop plan
  • Crop names and crop details
  • Crop names only

After creating a new season before adding your first crop you can import part or all of your crop plan. 

You'll see this on the crops page:

To prepare your CSV for import just add the headers listed below to the appropriate columns in your crop plan exactly as they appear. VeggieCropper will only import a single CSV file, so you may have to include additional columns from other spreadsheets to put all direct seed and transplant plantings on the same page. Use the same columns and add new columns to your sheet as needed. 

Alternatively, here is a template csv file you can download and paste your crop plan into <<Right-click and click "Download linked file" 

Is your crop plan ready to import?  A few considerations...

  • Add the headers to your CSV that you want to import into VeggieCroper. For example: just use 'Crop' for the crop name column
  • Header names are case-sensitive
  • Do not include accidental additional spaces in the header "DTM" works but "DTM " will not work
  • The ONLY required field is Crop
  • Blank cells in your CSV will show as a 0 and are easy to update in
  • If you want to redo the import you can create a new season (or delete all your crops) and try again
  • Each planting needs a single row with a field week (date), crop name, variety (optional), and bed feet
    • Ideally, all details for each planting are present on every row, otherwise, VeggieCropper will take the transplant and seeding details for the crop the first time it sees the crop
  • Date formats must match the formats below. Google sheets is pretty good at converting date formats
  • Make sure to save it as a CSV file
  • VeggieCropper only cares about the header names below, leave other headers in if you like. Your crop plan can be pretty messy and VeggieCropper might just help to clean it
Spreadsheet headers to use for CSV import:

Header                                                                   


Description

Field week
Date format is important and must be either mm-dd-yyyy or  yyyy-mm-dd
This field cannot be a 'week number' like 10. Dash '-' or slash '/' will work in date formats and if you are using Excel yyyy-mm-dd is recommended using the dash.
Crop Name of the crop
Varieties do not need to be part of the name of a crop. 
Planting bed ft
Number only field for the total number of bed feet in this planting
Weeks to harvest Value is the same as DTM/7
If DTM and 'Weeks to harvest' are both completed, 'Weeks to harvest' will be used by default.
DTM Days to maturity is the number of days from planting to the first harvest.
DTM = Weeks to harvest x 7
Weeks of harvest This is the number of weeks you plan to harvest the planting. If you don't have this information, consider starting out by setting this value to 1 so that you can start mapping your plantings. 
Variety Name of variety for this planting 
Variety % of planting
Variety % of planting or Variety bed ft need to be filled out to let Veggiecropper know how many seeds and transplants are needed for this variety in this planting 
Variety bed ft This field OR Variety % of planting need to be filled out to let Veggiecropper know how many seeds and transplants are needed for this variety in this planting
Rows per bed This is a crop-specific number that goes into the details tab on each crop page
Seeds per row           For direct seed crops only, this is a crop-specific number that goes into the details tab on each crop page
Seeder details This is a note that shows on your crop plan download as well as in Tasks each time this crop is to be seeded
In-row spacing     For transplant crops only, this is a crop-specific number that goes into the details tab on each crop page
Weeks before transplant This is the total number of weeks a crop is in the greenhouse. 
It is the number of weeks from the seeding date to the transplant date
Seeds per cell The number of seeds per cell
Cells per flat The number of cells per flat used for this crop
Safety factor Generally, ignore this optional header: This is the transplant seed safety factor. A value of 10% will increase the number of transplants needed for each planting by 10%. This also increases your seed count for each variety for this crop.
Flat round up  This is an optional header: This header will take three specific values listed below and is crop-specific. A calculated number of flats of 2.14 for example, when set to:
  • 'No decimal' - Will be rounded to 3 flats by default 
  • '1 decimal' - Would use and display 2.1 to calculate seeds and the flats
  • '2 decimal' - Would use and display 2.14 to calculate seeds and flats

* Must be one of these three values to be accepted.

Weeks before pot up This number determines the pot-up date and creates an entry on your greenhouse schedule and in Tasks (if subscribed) for a pot-up task with a date, the variety, and a number of cells to pot up. 
Pot up cells per flat This number determines how many flats will be calculated to pot up based on the total number of plants required for each planting of this crop.
Pot up safety factor Generally, ignore this optional header: This is the transplant seed safety factor. A value of 10% will increase the number of transplants needed for each planting by 10%. This also increases your seed count for each variety for this crop.
Pot up flat round up This is an optional header: This header will take three specific values listed below and is crop-specific. See 'Flat round up' for more details.
Task
Generally ignore this optional header: Only values accepted are 'Transplant' or 'Direct seed' 
Mostly used if you are importing an exported 'Detailed Planting Schedule'
This column will fill itself if you have:
-  'Seeds per row foot' with 'Direct seed'
- 'In row spacing' with 'Transplant'

The CSV import file has similar headings as the 'Detailed planting schedule' that you can download from the Crops page. It is possible to download your detailed planting schedule from another season or a friend's season and then upload it to your site.

Learn more about crop-related details and how they are used in VeggieCropper

Learn more about planting related details and how they are used