Skip to main content

File format

A spreadsheet with one row per piece. .csv, .xlsx, or a .zip containing one of those.

The ZIP package

exemplo.zip
├── pieces.csv ← exactly ONE spreadsheet, at the root
├── images/ ← optional: the original order drawing
│ └── imagem.png
└── shapes/ ← optional: SVG or RC2 of the piece outline
└── forma.svg

Exactly one spreadsheet at the root. Two, or none, rejects the whole package before any row is read.

The SVG and Rc2 columns accept either the content inline, or the name of a file inside shapes/. Same for ImagemPedido and images/.

Columns

The separator is semicolon (;).

ColumnRequiredNotes
CodigoBarraYesYour business key. See Overview
DescricaoYesWhat the piece is, in human words
Largura · AlturaYesIn millimetres
EspessuraYesIn millimetres. Decimals allowed
ServicosAplicaveisYesThe operations, in square brackets: [SERVICE_A],[SERVICE_B]. Without at least one there is no production route
TipologiaYesGlass type. Created automatically if new
NomeClienteYesCreated automatically if new
DataFinalizacaoNoThe deadline. Missing means today plus 30 days
QtdeNoQuantity. Missing means a single piece
ItemNoThe order line, for serial lots
InativaNoTrue refuses the piece — see below
PedidoCliente · PedidoInternoNoYour order references
UrgenteNoRaises the scheduling priority
ObservacaoNoFree text, carried through to the shop floor
RotaNoDelivery route
PrioridadePadraoNoScheduling priority, as a number
RecortesNoNumber of cut-outs
PecaPaiIdNoBarcode of the parent piece, for assemblies
Rc2NoPiece outline. Inline content, or the name of a file in shapes/
SVGNoTechnical drawing. Inline content, or the name of a file in shapes/
Services use commas, not semicolons

Inside the file, separate services with a comma: [SERVICE_A],[SERVICE_B].

The file itself is semicolon-delimited, so a semicolon inside a field becomes a new column and shifts the rest of the row silently.

How numbers are read

This applies to Largura, Altura, Espessura and Qtde, in all three formats.

The decimal separator can be a dot or a comma — the system works out which, instead of demanding a format. What it will not do is guess when guessing is impossible:

You sendResultWhy
6.5 · 6,56.5A lone separator outside the thousands position is the decimal
1.234,5 · 1,234.51234.5With both present, the last one is the decimal. Both conventions agree
1.234.5671234567The same separator repeated can only be grouping
1.234REFUSEDGenuinely ambiguous: one thousand two hundred and thirty-four, or one point two three four?
abc · 12mm · emptyREFUSEDNot a number

Three guarantees that follow:

  1. Nothing becomes a plausible value. An unreadable number refuses the piece; it does not become 0 in a measurement or 1 in a quantity.
  2. The reason names the field, and lists every bad one in the row at once, so a spreadsheet can be fixed in a single pass.
  3. The result does not depend on our server. The same input reads the same way regardless of the machine's language settings.
If your ERP writes 1.234 meaning one thousand

Send 1234. There is no way for the other side to tell that apart from a decimal, and guessing is exactly what we refuse to do.

Qtde missing means a single piece. Qtde fractional is refused rather than truncated — 2,5 pieces is an error in whatever produced the file, and rounding it to 2 would hide that.

Cancelled pieces

Inativa=True returns REJECTED, and nothing is stored — not the piece, not the glass type or customer it would have created.

This is deliberate. Registering something that is already cancelled is noise, and returning CREATED for a piece your own system cancelled would be technically true and practically misleading.

Refusing does not reserve anything: the barcode stays free. If the cancellation is undone and you resend the piece active, it goes in normally.

Getting a sample

The Mover.Glass Connector that runs at your site ships with a working example package. The Send sample button drops it into the input folder and the normal cycle processes it — a way to prove the pipeline end to end without waiting for your ERP.