Available Data Imports in AgNote

To facilitate a quick and easy account setup in AgNote, we provide data import functionality.

Importing an existing data into your account is quick and simple. With each import we provide you a starter template with detailed instructions. Some templates will also include some sample data which can be used as good starting point.

After each data import is completed, you will get an email with a short import summary. This summary will give you details such as:

  • Which rows (row number) were successfully imported.
  • A list of row numbers and likely reason(s) why the row was not imported, if one or more rows were not imported.
  • For your reference, this email will include the original file you uploaded as an attachment.

You will also get an email, if the data import fails. Here are some possible reasons why data import may can fail:

  • Incorrect file format. You can import your farm data only in .csv or .xlsx (Microsoft Excel) file format.
  • If importing Excel file, it may contain more than one workbook (tabs at the bottom). You can have only one workbook in the spreadsheet when uploading your farm data.

After successful farm data import, you will see an Undo Snapshot on the Undo slide-out tab on the right side of the page. I strongly recommend, double checking the imported date for accuracy and if something does not look right, you can undo (delete) the farm data you just imported, make the needed corrections and import again.


Below is a list of available imports in AgNote:

Farm Task Import
Farm Task import template file.

This template file includes some sample tasks already.

It is important to note that the column headings, in the file you will be uploading, need to match the headings in the sample file.

Column order can be different and if the file you are uploading includes other columns, which you don't see in the template file, will be ignored.

Please do read the Instructions and suggestions in the template file carefully. Make sure you have all required information in the spreadsheet, before uploading it.

I recommend that you also fill in the optional information such as:

  • Crop. If you do assign Crop to each task that will help you to stay organized throughout the application, because you will see Row Crop related tasks only in Row Crop management area(s). It is possible that you may want to have tasks in your application which should not be assigned to the crop at all, instead, it should be assigned to farm. For example, Water Truck (watering dirt roads around the field to keep the dust down), this task would be captured in general for the individual farm. Even more so, if you would like to use the Tasks functionality in AgNote for billing (invoicing).
  • Category. Categories will help you to group your farming tasks into common farming (bookkeeping) categories such as Tillage, Plant, Application, Harvest, Labor, etc.
Permanent Crop Yield Import
Permanent Crop Yield import template file.

Inputting / saving yield information for Permanent crops maybe cumbersome, because you may have multiple varieties and harvest for each crop, therefore it would require quite a bit of time to input yield information for each harvest and variety.

For Permanent Crops, yield is recoded for each variety. There are Permanent Crop plantings which have multiple varieties planted in the same field. A perfect example are Almond plantings. Almond plantings usually have several varieties planted in the field for pollination, and it is particularly important that we capture yield per variety, so later, we can compare the production for each variety.

Another good reason Permanent Crop yield information is more practical to import versus input, is that Permanent Crop yield is usually delivered to a processor, warehouse, or huller, which can provide the yields data in tabular format, which further can be imported into AgNote.

Please do read the instruction & suggestions inside the template file.

Row Crop Planting Import
Row Crop Planting import template file.

This import will give you "quick start" on populating your AgNote's account with your Row Crop planting history.

Initially, when you will be setting up your account, you will need to input the current plantings information, along with field and field irrigation's systems information. But once that is done, and if you do have a planting information available, you can quickly import that.

Please do make sure that the Company (farm) and Property (farm field) names match to what you currently have in your account.

Row Crop Yield Import
Row Crop Yield import template file.

If you do have your previous row crop yield information available, I strongly recommend importing it into your account. By having row crop yield history in your account, you will be able to quickly visualize different variety production over time. You will have the row crop yield history visible in several dashboard charts on your Row Crop Dashboard.

Note that Harvest Method(s) will need to be added in your account before you import the crop yield information.

If you have any questions about data imparting, please contact us, and we will be more than happy to help you.