The order lines of a flat EDI file read at their place

Goal Read the order lines of a fixed-width EDI file as columns, with no mapping tool.

A manufacturer and its logistics provider exchange flat files. No separator: each field has its place and its width.

the header set aside and counted;
eleven fields cut at their place;
accents right, even in a one-line file.

lumnik Open
Logistics
EDI
Connector
Entity

ZINT_CC_42100001.txt

SAPPRD           NPEC      
SAPPRD           NPEC      EC100001  M. DURAND                               12 RUE DES LILAS                                  69003   FR 42100001    KIT0012     Couverture à barres automatique 8x4 coul30.000    M2  6880001   
SAPPRD           NPEC      EC100001  M. DURAND                               12 RUE DES LILAS                                  69003   FR 42100001    KIT0031     Kit anti-soulèvement sur tube pour couve1.000     U   6880002   
SAPPRD           NPEC      EC100001  M. DURAND                               12 RUE DES LILAS                                  69003   FR 42100001    LIV0000     Livraison couverture à barres France mét1.000     U   6880003   
SAPPRD           NPEC      EC100245  MME FAURE                               LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN       84120   FR 42100002    BAC0450     Bâche hiver opaque 10x5                 50.000    M2  6880011   
SAPPRD           NPEC      EC100245  MME FAURE                               LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN       84120   FR 42100002    ENR0002     Enrouleur télescopique                  2.000     U   6880012   
SAPPRD           NPEC      EC100245  MME FAURE                               LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN       84120   FR 42100002    LIV0000     Livraison bâche France métropole        1.000     U   6880013

manifests/10-order-lines.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-edi-cc-b  connector_type: csv-file  scopes: [logistics-b]spec:  transport:    kind: local    path: /tmp/lumnik-scenario/edi-flat-order-lines/b/ZINT_CC_*.txt   # one file per order the ERP sends  parser:    lines: true                        # one line = one row, no separator to guess  after_process: none  mapping:    dataset:      - filter-where: { column: line, regex: ".{27}EC.*" }   # order lines carry a customer code; the header does not    cell:      - regex-extract:                 # every field at its place and width          column: line          required: true          pattern: "^(.{17})(.{10})(.{10})(.{40})(.{50})(.{8})(.{3})(.{12})(.{12})(.{40})(.{10})(.{4})(.*)$"          groups: { 3: customer, 4: customer_name, 5: address, 6: postcode, 7: country, 8: order_no,                    9: article, 10: label, 11: quantity, 12: unit, 13: line_id }      - clean: { columns: [customer, customer_name, address, postcode, country, order_no, article, label,                           quantity, unit, line_id], strip: true }      - parse-number: { column: quantity, decimal-separator: "." }

$ lm apply -f 10-order-lines.yaml
Applied connector "scenario-edi-cc-b" — 1 endpoint

$ lm connector run scenario-edi-cc-b
run scheduled: 2073ef7a-01dd-48b3-ac8f-c6f194b1ee61

$ lm run get 2073ef7a-01dd-48b3-ac8f-c6f194b1ee61
ID        CONNECTOR          ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED
2073ef7a  scenario-edi-cc-b  default   Completed  7   6    1        0             2026-11-03 16:10  2026-11-03 16:10

manifests/20-order-line.yaml

kind: Entityname: order_line_blabel: Ligne de commande à livrerdescription: "An order line the ERP sent the logistics partner: customer, delivery address, article, quantity and unit."match: [line_id]scopes: [logistics-b]columns:  line_id: { label: "Ligne" }  order_no: { label: "Commande" }  customer: { label: "Client" }  customer_name: { label: "Nom" }  address: { label: "Adresse de livraison" }  postcode: { label: "Code postal" }  article: { label: "Article" }  label: { label: "Libellé (40)" }  quantity: { label: "Quantité" }  unit: { label: "Unité" }sources:  - table: t_scenario_edi_cc_b    map: { line_id: line_id, order_no: order_no, customer: customer, customer_name: customer_name, address: address,           postcode: postcode, article: article, label: label, quantity: quantity, unit: unit }

$ lm entity apply -f 20-order-line.yaml
Applied entity "order_line_b" → connector."v_order_line_b"

$ lm entity get order_line_b
LINE_ID  ORDER_NO  CUSTOMER  CUSTOMER_NAME  ADDRESS                                      POSTCODE  ARTICLE  LABEL                                     QUANTITY  UNIT  _CONFLICTS
6880001  42100001  EC100001  M. DURAND      12 RUE DES LILAS                             69003     KIT0012  Couverture à barres automatique 8x4 coul  30        M2    {}
6880002  42100001  EC100001  M. DURAND      12 RUE DES LILAS                             69003     KIT0031  Kit anti-soulèvement sur tube pour couve  1         U     {}
6880003  42100001  EC100001  M. DURAND      12 RUE DES LILAS                             69003     LIV0000  Livraison couverture à barres France mét  1         U     {}
6880011  42100002  EC100245  MME FAURE      LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN  84120     BAC0450  Bâche hiver opaque 10x5                   50        M2    {}
6880012  42100002  EC100245  MME FAURE      LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN  84120     ENR0002  Enrouleur télescopique                    2         U     {}
6880013  42100002  EC100245  MME FAURE      LIEU-DIT LES ÉPINETTES - 4 CHEMIN DU MOULIN  84120     LIV0000  Livraison bâche France métropole          1         U     {}

ZINT_CC_42100003.txt

SAPPRD           NPEC      
SAPPRD           NPEC      EC100377  M. NGUYEN                               3 IMPASSE DES CHENES                              13100   FR 42100003    ENR0002     Enrouleur télescopique                  1.000     U   6880021

$ lm connector run scenario-edi-cc-b
run scheduled: c2846cc8-55ce-40b6-9734-2ec59fa12352

$ lm run get c2846cc8-55ce-40b6-9734-2ec59fa12352
ID        CONNECTOR          ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED
c2846cc8  scenario-edi-cc-b  default   Completed  2   1    1        0             2026-11-03 16:10  2026-11-03 16:10
• 1 file(s) unchanged since they were last read — not read again

$ lm entity get order_line_b --filter order_no=42100003
LINE_ID  ORDER_NO  CUSTOMER  CUSTOMER_NAME  ADDRESS               POSTCODE  ARTICLE  LABEL                   QUANTITY  UNIT  _CONFLICTS
6880021  42100003  EC100377  M. NGUYEN      3 IMPASSE DES CHENES  13100     ENR0002  Enrouleur télescopique  1         U     {}

Limits

The widths are the file's: if the ERP changes its layout, the expression changes with it.
A label the ERP cut stays cut: lumnik does not recover what was not sent.
Synthetic files, on the template of a real exchange.

Logistics · flat EDI

Orders arrive as a flat file.

One line per item, each field at its place.

ISO-8859-1, fixed width

The problem

No separator.

A field is a position and a width.
A mapping tool is costly.

What is not changed

The ERP writes as before.

The same file, the same folder.
No format to negotiate.

The trap

Accents in a tiny file.

One line, one é.
Too little to guess the encoding.

What had to be written

lines: true

One line.

One file line, one table row.
The fields cut at their place.
A 47-line scenario, two manifests.

The result

Six order lines as columns.

Customer, order, article, quantity.
« Couverture à barres », accent included.

The limit

The widths are the file's.

If the ERP changes its layout, the manifest changes with it.

Try it

The scenario replays locally.

Every step is published with its output.

This scenario runs on lumnik Open, free and open source.

Try lumnik Open →