Importing csv to Record Plant and Harvest Information (Metrc Manual)

Metrc provides the option of making data entries of Plant and Harvest information using comma separated value (.CSV) files which are uploaded to Metrc using the Data Import feature described in Section 9.

The CSV files are most commonly generated from third party software, but can be created manually as well.  The Metrc Mobile application also creates CSV files for upload using the Data Import feature.

Plant and Harvest CSV File Formats

Use the following information when building a CSV file for upload to Metrc:

Create Plantings

 

Fields:

<New Tag ID>,<Plants Type>,<Plants Count>,<Strain>,<New Room>,<not used>,<Planting Date>

Example:

1A4FF0000000022000000200,Clone,25,Bubba Kush,Immature Room A,,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

New Tag ID

Alphanumeric (24)

Yes

Immature Plant Lot Tag ID

Plants Type

Alphanumeric

Yes

Valid Values:

Clone

Seed

Plants Count

Numeric

Yes

Number of immature plants in new plant lot

Strain

Alphanumeric

Yes

Strain Name exactly as defined in Metrc

New Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Not Used in California

NA

No

NA

Planting Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Plantings from Plants

 

Fields:

<Plant Tag ID>,<New Tag ID>,<Plants Type>,<Plants Count>,<Strain>,<New Room>,<not used>,<Planting Date>

Example:

1A4FF0000000022000000100,1A4FF0000000022000000201,Clone,80,FOG,Immature Room B,,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Tag ID

Alphanumeric (24)

Yes

Tag ID of Flowering Plant from which planting was created

New Tag ID

Alphanumeric (24)

Yes

Immature Plant Lot Tag ID

Plants Type

Alphanumeric

Yes

Valid Values:

Clone

Seed

Plants Count

Numeric

Yes

Number of immature plants in new plant lot

Strain

Alphanumeric

Yes

Strain Name exactly as defined in Metrc

New Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Not Used in California

NA

No

NA

Planting Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Plantings from Packages

 

Fields:

<Package Tag ID>,<Package Quantity>,<Unit of Measure>,<New Tag ID>,<Plants Type>,<Plants Count>,<Strain>,<New Room>,<not used>,<Planting Date>,<Unpackaged Date>

Example:

1A4FF0100000022000000700,5,Each,1A4FF0000000022000000202,Clone,5,Shark's Breath,Immature Room B,,2018-01-01,2017-12-31

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Package Tag ID

Alphanumeric (24)

Yes

Tag ID of Package of Immature Plants from which planting was created

Package Quantity

Numeric

Yes

Quantity of immature plants taken from package to create planting

Unit of Measure

Alphanumeric

Yes

Package unit of measure

New Tag ID

Alphanumeric (24)

Yes

Immature Plant Lot Tag ID

Plants Type

Alphanumeric

Yes

Valid Values:

Clone

Seed

Plants Count

Numeric

Yes

Number of immature plants in new plant lot

Strain

Alphanumeric

Yes

Strain Name exactly as defined in Metrc

New Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Not Used in California

NA

No

NA

Planting Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Unpackaged Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Immature Plants Growth Phase

 

Fields:

<Plant Lot Tag ID>,<Plants Count>,<Starting Tag ID>,<Growth Phase>,<New Room>,<Change Date>,<not used>

Example:

1A4FF0000000022000000200,5,1A4FF0100000022000000300,Flowering,Flower Room B,2018-01-01,

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Lot Tag ID

Alphanumeric (24)

Yes

Immature Plant Lot Tag ID

Plants Count

Numeric

Yes

Number of plants being promoted to the Flowering growth phase

Starting Tag ID

Alphanumeric (24)

Yes

Starting Tag ID for Flowering Plants

Growth Phase

Alphabetic

Yes

Valid Values: Flowering

New Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Change Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Not Used in California

NA

No

NA

Record Immature Plants Waste

 

Fields:

<Waste Method>,<Material Mixed>,<Waste Weight>,<Waste Unit of Measure>,<Reason>,<Optional Note>,<Waste Date>,<Plant Batch>

Example:

Compost,Soil,10,Pounds,Failure to Thrive,Frost Damage,2018-01-01,1A4FF0000000022000000150

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Waste Method

Alphanumeric

Yes

Valid values: Compost

Self-Haul

Waste-Hauler

Material Mixed

Alphanumeric

Yes

Material that was combined with the waste while performing the Waste Method

Waste Weight

Alphanumeric

Yes

Weight of waste

Waste Unit of Measure

Numeric

Yes

Unit of measure for waste

Reason

Alphanumeric

Yes

Waste Reason exactly as defined in

Metrc - See 

Exhibit 39: State of California Waste Reasons

Optional Note

Alphanumeric

Optional

Explanation of reason for waste

Waste Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Plant Lot Tag ID

Alphanumeric (24)

Yes

Tag ID of Immature Plant Lot that produced the waste

                 

Immature Plants Packages

 

Fields:

<Plant Lot Tag ID>,<Item>,<Plants Count>,<Package Tag ID>,<Package Date>

Example:

1A4FF0000000022000000205,Immature Shark,1A4FF0100000022000000707,5,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Lot Tag ID

Alphanumeric (24)

Yes

Tag ID of Immature Plant Lot that was used to create the package

Item

Alphanumeric

Yes

Item exactly as defined in Metrc

Package Tag ID

Alphanumeric (24)

Yes

Tag ID of Package

Plants Count

Alphanumeric

Yes

Number of immature plants from Plant Lot used in package

Package Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

                 

Destroy Immature Plants

 

Fields:

<Plant Lot Tag ID>,<Plants Count>,<Note>,<Destroy Date>

Example:

1A4FF0000000022000000151,3,Mandated,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Lot Tag ID

Alphanumeric (24)

Yes

Immature Plant Lot Tag ID

Plants Count

Numeric

Yes

Number of plants destroyed

Note

Alphanumeric

Yes

Explanation of reason for immature plant destruction

Destroy Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Plants Room

 

Fields:

<Plant Tag ID>,<New Room>,<Move Date>

Example:

1A4FF0000000022000000520,Flower Room C,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

 

Field

Format

Required

Description

Plant Tag ID

Alphanumeric (24)

Yes

Tag ID for Flowering Plant

New Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Move Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

 

                 

Record Plants Waste

 

Fields:

<Waste Method>,<Material Mixed>,<Waste Weight>,<Waste Unit of Measure>,<Reason>,<Optional Note>,<not used>,<Waste Date>,<Plant Tag ID(s)>

Example - Waste Event Involving Multiple Plants:

Self-Haul,NA,5,Pounds,Pruning,Frostbit,,2018-01-01,1A4FF0000000022000000210|1A4FF000000002200 0000215

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Waste Method

Alphanumeric

Yes

Valid values:

Compost

Self-Haul

Waste-Hauler

Material Mixed

Alphanumeric

Yes

Material that was combined with the waste while performing the Waste Method

Waste Weight

Alphanumeric

Yes

Weight of waste

Waste Unit of Measure

Numeric

Yes

Unit of measure for waste

Reason

Alphanumeric

Yes

Waste Reason exactly as defined in

Metrc - See 

Exhibit 39: State of California Waste Reasons.  Must match exactly.

Optional Note

Alphanumeric

Optional

Explanation of reason for waste

Not Used in California

NA

No

NA

Waste Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Plant Tag ID(s)

Alphanumeric (24)

Yes

Tag ID of Flowering Plant that produced the waste.

Multiple Plant Tag IDs can be specified separated by a ‘|’.

                 

Manicure Plants

 

Fields:

<Plant Tag Id>,<Manicure Weight>,<Manicure Unit of Measure>,<Drying Room>,<Harvest Name>,<not used>,<Manicure Date>

Example:

1A4FF0000000022000000322,5,Kilograms,Drying Room A,Bubba Kush Manicure,,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

 

Field

Format

Required

Description

Plant Tag ID

Alphanumeric (24)

Yes

Tag ID of Flowering Plant that was manicured

Manicure Weight

Alphanumeric

Yes

Weight of manicure harvest

Manicure Unit of Measure

Numeric

Yes

Unit of measure for manicure harvest

Drying Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Harvest Name

Alphanumeric

Optional

Name assigned to the manicure harvest.  If not specified, Metrc will assign a Harvest Name.

Not Used in California

NA

No

NA

Manicure Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

                 

Harvest Plants

 

Fields:

<Plant Tag Id>,<Harvest Weight>,<Harvest Unit of Measure>,<Drying Room>,<Harvest Name>,<not used>,<Harvest Date>

Example:

1A4FF0000000022000000375,10,Kilograms,Harvest Room,Blue Dream Harvest,,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Tag ID

Alphanumeric (24)

Yes

Tag ID of Flowering Plant that was harvested

Harvest Weight

Alphanumeric

Yes

Weight of harvest

Harvest Unit of

Measure

Numeric

Yes

Unit of measure for harvest

Drying Room

Alphanumeric

Yes

Room Name exactly as defined in Metrc

Harvest Name

Alphanumeric

Optional

Name assigned to the harvest.  If not specified, Metrc will assign a Harvest Name.

Not Used in California

NA

No

NA

Harvest Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

                 

Destroy Plants

 

Fields:

<Plant Tag ID>,<Reason Note>,<Destroy Date>

Example:

1A4FF0000000022000000151,Mandated,2018-01-01

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Plant Tag ID

Alphanumeric (24)

Yes

Tag ID of Flowering Plant that was destroyed

Reason Note

Alphanumeric

Yes

Explanation of reason for destroying the plant

Destroy Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

                 

Packages from Harvests

 

Fields:

<Package Tag ID>,<not used>,<Item>,<Package Unit of Measure>,<not used>,<Package

Date>,<Production Batch Number>,<Harvest Name>,<Harvest Quantity>,<Harvest Quantity Unit of

Measure>

Example 1 - Package with Single Harvest (Non-Production Batch):

1A4FF0100000022000000800,,Shark Flower,Pounds,,2018-03-01,,Shark-2018.3.11-H,12,Pounds

Example 2 - Package with Multiple Harvests (Production Batch):

1A4FF0100000022000000801,,Shark Kief,Kilograms,,2018-03-01,PB 2018.03.01 Shark,2018-01-01-Shark-M,10,Kilograms

1A4FF0100000022000000801,,Shark Kief,Kilograms,,2018-03-01,PB 2018.03.01

Shark,2017-12-15-Shark-H,15,Kilograms

Please note that the commas are just to designate the next column in the file. These commas should NOT be placed in the file if you are using a .csv file/excel spreadsheet. If you are using a .txt file, however, the commas are NEEDED.

Field

Format

Required

Description

Package Tag ID

Alphanumeric (24)

Yes

Tag ID of Package being created

Not Used in California

NA

No

NA

Item

Alphanumeric

Yes

Item exactly as defined in Metrc

Package Unit of Measure

Numeric

Yes

Unit of measure for package

Not Used in California

NA

No

NA

Package Date

MM/DD/YYYY or YYYY-MM-DD

Yes

US Short Date or ISO 8601 Date

Production Batch

Number

Alphanumeric

Optional

Production Batch Number (if applicable)

Harvest Name

Alphanumeric

Yes

Name of harvest used in package

Harvest Quantity

Alphanumeric

Yes

Quantity of harvest used in package

Harvest Quantity Unit of Measure

Numeric

Yes

Unit of measure for harvest quantity

NOTE: Once a CSV is imported successfully, there is no way to automatically reverse the import. Any corrections will have to be performed manually.


How did we do?


Powered by HelpDocs (opens in a new tab)