Avançar para o conteúdo principal

Validation rules

Before importing, the system validates the file and flags the errors by row. This page gathers all the rules, by field. The Excel file itself contains guidance notes on the information for each column. Correct everything that is flagged before re-importing, because a row with an error is not imported.

Also applies to manual editing
These data rules are the same for Excel import and for direct editing on the platform. If a value is rejected on one side, it is rejected on the other.

General rules (SFM and CoC)

Addresses

FieldRule
Descrição da morada, Linha 1, Código Postal, Localidade, País (Address description, Line 1, Postcode, Locality, Country)Required.
PaísMust exist in the system.
Distrito, Concelho, Freguesia (District, Municipality, Parish)If filled in (and the country is Portugal), they must exist.
ConcelhoMust belong to the specified Distrito.
FreguesiaMust belong to the specified Concelho. If there are parishes with the same name, the Concelho must be specified.

Dates

FieldRule
Data de entrada (Entry date)Required, valid date.
Data de saída (Exit date)Optional. If it is filled in, the reason for exit must be specified.

NIF / NIPC

The NIF must be unique in the system. It is accepted if it is new, or if it already belongs to your organisation (or to an entity shared with you). It fails if it is already being used by another organisation (an entity sharing request is required).

Format of the number: only the number, without spaces or punctuation; digits, letters, dot and hyphen; 9 digits are treated as a Portuguese NIF and the check digit is verified; foreign numbers with 9 digits carry the country prefix (e.g. GB749933773). NIFs that already exist in the application pass even with a wrong check digit. Messages and examples in Import data (Excel).

SFM

Properties

FieldRule
Área (ha) (Area, ha)Required, numeric, greater than 0 (minimum 0.01 ha; values that round to 0 are rejected).
% de área certificada FSC (% of FSC certified area)Required, integer between 0 and 100.
% com alto valor ecológico (% with high ecological value)Required, integer between 0 and 100.
Funcionalidade: Produção, Conservação, Protecção (Function: Production, Conservation, Protection)Required, integers. The sum of the three must be exactly 100.
Propriedade fundiária (Land ownership)Required, one of the permitted values.
Parcelas (Parcels)Required, integer, minimum 1.
GFS / TOF (SFM / TOF)Required, "GFS" or "TOF". If it is "TOF", the TOF type becomes required.

Members

FieldRule
Estado do membro (Member status)Required, one of the permitted values.
NIF dos membros (Members' NIF)Required. Cannot be repeated (Group and Regional). In an Individual certificate there can only be one member.

Property names

Within the same NIF, property names cannot be repeated. The comparison ignores capitalisation and accents (e.g. "São João" and "Sao Joao" count as the same name).

CoC

Sites

FieldRule
Nome, NIF/NIPC (Name, NIF/NIPC)Required.
Estado (Status)Required, one of the permitted values.
Tem actividade? (Has activity?)Required, "Sim" (Yes) or "Não" (No).
Razão da ausência de actividade (Reason for absence of activity)Required when "Tem actividade?" is "Não".

Activity and turnover
If the site has activity, there must be a turnover greater than 0. If it has no activity, the reason must be specified. The two must be consistent.

Turnover

FieldRule
Ano (Year)Required, integer. Only the current year and the two previous years are accepted.
Volume de negócios (Turnover)Required, numeric, up to 2 decimal places.
Referência ao site (Site reference)Nome + NIF/NIPC + Morada (Descrição) (Address description) must exist in the Sites sheet.

Products

FieldRule
Categoria de produto (Product category)Required, must exist in the catalogue. Codes with fewer than 6 digits are padded with leading zeros (10000 → 010000).
Métodos (Separação física, Percentagem, Crédito) (Methods: Physical separation, Percentage, Credit)"Sim" or "Não". An empty cell counts as "Não".
Alegações (X% Certificado PEFC, Fontes controladas PEFC, 100% de Origem PEFC) (Claims: X% PEFC Certified, PEFC Controlled Sources, 100% PEFC Origin)"Sim" or "Não". An empty cell counts as "Não".
Reciclado (Recycled)"Sim" or "Não".
Referência ao siteNome + NIF/NIPC + Morada (Descrição) must exist in the Sites sheet.

Species

FieldRule
Espécie (Species)Required, the scientific name must exist in the species catalogue.
Referências (References)The site and the product category must exist in the respective sheets.

Uniqueness by application level

LevelRule
IndividualA single site.
Multi-siteThe same NIF can be repeated, provided the address is different. The NIF + address combination must be unique.
Multi-site (Group of Producers)Several entities, each with a unique NIF (no repetitions).

How the sheets link to each other

The sheets refer to one another. A row in Propriedades (Properties) points to a member in the Membros (Members) sheet; a row in Produtos (Products) or Espécies (Species) points to a property (SFM) or to a site (CoC); and so on. To link the rows, the validation compares the identification columns between the two sheets.

The comparison is exact
The names must be written in exactly the same way on both sheets. The comparison only ignores leading and trailing spaces; differences in accents, upper/lower case, extra spaces or missing words such as «de/da» cause the row to fail. The NIF/NIPC must also match. If a row fails the reference, it is not imported.

Columns that must match the source sheet:

SFM

SheetColumns that must matchWith the sheet
PropriedadesNome do proprietário (Owner name) + NIF/NIPCMembros
ProdutosNome da propriedade (Property name) + Nome do proprietário + NIF/NIPCPropriedades
EspéciesCategoria + Nome da propriedade + Nome do proprietário + NIF/NIPCProdutos

CoC

SheetColumns that must matchWith the sheet
Volume de negóciosNome do site (Site name) + NIF/NIPC + Morada (Descrição)Sites
ProdutosNome do site + NIF/NIPC + Morada (Descrição)Sites
EspéciesNome do site + NIF/NIPC + Morada (Descrição)Sites
EspéciesCategoria de produto (+ Nome do site + NIF/NIPC + Morada)Produtos

The Descrição (Description) column (of the product category) is ignored in the comparison.

Renaming an entity
In the Membros and Sites sheets, the Nome is imported: if it is changed, the entity takes on that name. In that case, update the same name in all the sheets that refer to it, otherwise those rows no longer match and fail validation.

Empty and incomplete rows

A completely empty row is ignored without error, even in sheets with mandatory fields. In SFM, the Membros (Members), Propriedades (Properties) and Produtos (Products) sheets must have at least one row; the Espécies (Species) sheet may be empty. A partially filled row (for example, with data but without the site reference columns) generates an error, indicating the missing columns. The Descrição column (in the product link) is ignored for import purposes.