The supplier file goes to EDI in ASCII with a stable id

Goal Send EDI the suppliers in the form it requires, with an id that does not change.

Purchasing's EDI platform requires names in ASCII, upper case, at most 35 characters, and one id per supplier. The ERP's export has accents, long company names, inactive suppliers, and ids that read N/A, 0 or nothing.

names put in the EDI's form;
N/A and 0 emptied and counted, a missing id derived from the code;
the next day, the same ids.

lumnik Open
Purchasing
EDI
Connector
Entity

suppliers.csv

FOURN_CODE;FOURN_NOM;ACTIF;EXT_ID;PAYS
F0001;Société Générale d'Équipements Industriels du Rhône;O;N/A;
F0002;Électricité Ménard & Fils;O;3f2b8c1e-5a7d-4c2e-9b1f-0a6d8e4c2b71;FR
F0003;Ancien Fournisseur;N;0;FR
F0004;Transports Lefèvre;O;;FR
F0005;Société Générale d'Équipements Industriels du Rhône-Alpes;O;7c9e6679-7425-40de-944b-e07fc1f90ae7;
F0006;Garage Müller;O;0;DE
F0007;Imprimerie Côté, S.A.;O;;BE
F0008;Fournisseur Fermé;N;;FR

manifests/10-suppliers.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-suppliers-b  connector_type: csv-file  scopes: [purchasing-b]spec:  transport:    kind: local    path: /tmp/lumnik-scenario/supplier-master-edi/b/suppliers.csv  parser:    delimiter: ";"  after_process: none  mapping:    dataset:      - filter-where: { column: ACTIF, equals: "O" }        # inactive suppliers out, counted    row:      - map-columns:          rename: { FOURN_CODE: code, FOURN_NOM: name, ACTIF: active, EXT_ID: ext_id, PAYS: country }      - defaults: { country: FR }                            # an empty country is France    cell:      - remove-diacritics: { columns: [name] }               # Électricité -> Electricite      - upper: { columns: [name] }      - regex-replace: { column: name, pattern: "&", replacement: " ET " }      - regex-replace: { column: name, pattern: "[^A-Z0-9 ]", replacement: " " }   # what the EDI refuses      - regex-replace: { column: name, pattern: " +", replacement: " " }      - clean: { columns: [name], strip: true }      - truncate: { column: name, length: 35 }               # the EDI's hard limit      - to-uuid: { column: ext_id, on-invalid: keep }        # look first: N/A and 0 left as they came

manifests/20-supplier.yaml

kind: Entityname: supplier_blabel: Fournisseur EDIdescription: "An active supplier as the EDI platform takes it: ASCII upper-case name cut at 35 characters, country, and a stable identifier."match: [code]scopes: [purchasing-b]columns:  code: { label: "Code fournisseur" }  name: { label: "Nom EDI (35)" }  ext_id: { label: "Identifiant" }  country: { label: "Pays" }sources:  - table: t_scenario_suppliers_b    map: { code: code, name: name, ext_id: ext_id, country: country }

$ lm apply -f 10-suppliers.yaml
Applied connector "scenario-suppliers-b" — 1 endpoint

$ lm connector run scenario-suppliers-b
run scheduled: f1f15d71-e48a-4d17-8829-62bb645fd20b

$ lm run get f1f15d71-e48a-4d17-8829-62bb645fd20b
ID        CONNECTOR             ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED
f1f15d71  scenario-suppliers-b  default   Completed  8   6    2        0             2026-11-03 15:51  2026-11-03 15:51

$ lm entity apply -f 20-supplier.yaml
Applied entity "supplier_b" → connector."v_supplier_b"

$ lm entity get supplier_b
CODE   NAME                                 EXT_ID                                COUNTRY  _CONFLICTS
F0001  SOCIETE GENERALE D EQUIPEMENTS INDU  N/A                                   FR       {}
F0002  ELECTRICITE MENARD ET FILS           3f2b8c1e-5a7d-4c2e-9b1f-0a6d8e4c2b71  FR       {}
F0004  TRANSPORTS LEFEVRE                                                         FR       {}
F0005  SOCIETE GENERALE D EQUIPEMENTS INDU  7c9e6679-7425-40de-944b-e07fc1f90ae7  FR       {}
F0006  GARAGE MULLER                        0                                     DE       {}
F0007  IMPRIMERIE COTE S A                                                        BE       {}

manifests/11-suppliers-policy.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-suppliers-b  connector_type: csv-file  scopes: [purchasing-b]spec:  transport:    kind: local    path: /tmp/lumnik-scenario/supplier-master-edi/b/suppliers.csv  parser:    delimiter: ";"  after_process: none  mapping:    dataset:      - filter-where: { column: ACTIF, equals: "O" }        # inactive suppliers out, counted    row:      - map-columns:          rename: { FOURN_CODE: code, FOURN_NOM: name, ACTIF: active, EXT_ID: ext_id, PAYS: country }      - defaults: { country: FR }                            # an empty country is France    cell:      - remove-diacritics: { columns: [name] }               # Électricité -> Electricite      - upper: { columns: [name] }      - regex-replace: { column: name, pattern: "&", replacement: " ET " }      - regex-replace: { column: name, pattern: "[^A-Z0-9 ]", replacement: " " }   # what the EDI refuses      - regex-replace: { column: name, pattern: " +", replacement: " " }      - clean: { columns: [name], strip: true }      - truncate: { column: name, length: 35 }               # the EDI's hard limit      - to-uuid: { column: ext_id, on-invalid: "null", generate-from: code }   # junk emptied, counted; an empty id derived from the code

$ lm apply -f 11-suppliers-policy.yaml
Applied connector "scenario-suppliers-b" — 1 endpoint

$ lm endpoint reset-cursor scenario-suppliers-b/default

$ lm connector run scenario-suppliers-b
run scheduled: d24b789d-c390-4764-a8ab-c947118b768e

$ lm run get d24b789d-c390-4764-a8ab-c947118b768e
ID        CONNECTOR             ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED
d24b789d  scenario-suppliers-b  default   Completed  8   6    2        0             2026-11-03 15:51  2026-11-03 15:51
⚠ 2 cell(s) a hook did not deliver as declared — the rows were still written

$ lm entity get supplier_b
CODE   NAME                                 EXT_ID                                COUNTRY  _CONFLICTS
F0001  SOCIETE GENERALE D EQUIPEMENTS INDU                                        FR       {}
F0002  ELECTRICITE MENARD ET FILS           3f2b8c1e-5a7d-4c2e-9b1f-0a6d8e4c2b71  FR       {}
F0004  TRANSPORTS LEFEVRE                   673eb8c7-b4b2-3a79-91c0-7f21160d86f4  FR       {}
F0005  SOCIETE GENERALE D EQUIPEMENTS INDU  7c9e6679-7425-40de-944b-e07fc1f90ae7  FR       {}
F0006  GARAGE MULLER                                                              DE       {}
F0007  IMPRIMERIE COTE S A                  4a515c7a-0e97-3802-b74d-7e5c916331b5  BE       {}

suppliers-day2.csv

FOURN_CODE;FOURN_NOM;ACTIF;EXT_ID;PAYS
F0001;Société Générale d'Équipements Industriels du Rhône;O;N/A;
F0002;Électricité Ménard & Fils;O;3f2b8c1e-5a7d-4c2e-9b1f-0a6d8e4c2b71;FR
F0003;Ancien Fournisseur;N;0;FR
F0004;Transports Lefèvre;O;;FR
F0005;Société Générale d'Équipements Industriels du Rhône-Alpes;O;7c9e6679-7425-40de-944b-e07fc1f90ae7;
F0006;Garage Müller;O;0;DE
F0007;Imprimerie Côté, S.A.;O;;BE
F0008;Fournisseur Fermé;N;;FR
F0009;Cartonnages Dubois;O;;FR

$ lm connector run scenario-suppliers-b
run scheduled: e381bc54-9178-42d6-83d7-6240412ab7fc

$ lm run get e381bc54-9178-42d6-83d7-6240412ab7fc
ID        CONNECTOR             ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED
e381bc54  scenario-suppliers-b  default   Completed  9   7    2        0             2026-11-03 15:51  2026-11-03 15:51
⚠ 2 cell(s) a hook did not deliver as declared — the rows were still written

$ lm entity get supplier_b
CODE   NAME                                 EXT_ID                                COUNTRY  _CONFLICTS
F0001  SOCIETE GENERALE D EQUIPEMENTS INDU                                        FR       {}
F0002  ELECTRICITE MENARD ET FILS           3f2b8c1e-5a7d-4c2e-9b1f-0a6d8e4c2b71  FR       {}
F0004  TRANSPORTS LEFEVRE                   673eb8c7-b4b2-3a79-91c0-7f21160d86f4  FR       {}
F0005  SOCIETE GENERALE D EQUIPEMENTS INDU  7c9e6679-7425-40de-944b-e07fc1f90ae7  FR       {}
F0006  GARAGE MULLER                                                              DE       {}
F0007  IMPRIMERIE COTE S A                  4a515c7a-0e97-3802-b74d-7e5c916331b5  BE       {}
F0009  CARTONNAGES DUBOIS                   a9a76ea1-bb08-30e3-bab4-27ecf986ea99  FR       {}

Limits

truncate cuts without warning: F0001 and F0005 carry the same 35-character name; only their codes tell them apart.
A derived id joins to no other system.
Synthetic suppliers.

Purchasing · EDI

Suppliers go to EDI.

Every night, from the ERP.

Eight suppliers, six active

The problem

EDI requires its own form.

ASCII, upper case, 35 characters.
One id per supplier.

What is not changed

The ERP stays as it is.

Its export, accents included.
No fix at the source.

The trap

Ids that are not ids.

N/A, 0, or nothing at all.
A random id changes every night.

What had to be written

to-uuid: { generate-from: code }

One line.

The same code gives the same id.
Wrong values are emptied and counted.
A 43-line scenario, two manifests.

The next day

The same ids.

One more supplier gets its own.
No row removed.

The limit

Cutting at 35 can merge two names.

Only their codes tell them apart.

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 →