IDML to Pergamon CSV Converter

Check rows alignment Detects misalignments between DE and EN-GB columns using structural anchor pairs (WARNUNG/WARNING, section headers, etc.). Marks affected rows in the COMMENT column with ⚠ ALIGNMENT: …. Run before all other tasks.

Detect sections Scans paragraph styles and content to tag rows in the COMMENT column by section type: marks standard text sections (Entsorgung, Garantie, Service…), introduction text (Einleitung), product name, and symbols table rows. Required before "Remove standard texts" and "Adjust columns in tables".

Extract footnotes Finds all <footnote>…</footnote> tags in DE and EN-GB. Replaces each tag in the source row with a <CharacterCustom9>*</CharacterCustom9> marker, then inserts a new row directly below with the footnote text, PARAGRAPH_STYLE = Body, and SCRIPT_LABEL = FOOTNOTE_1 (FOOTNOTE_2 for a second footnote, etc.).

Remove standard texts Deletes all rows tagged STANDARD_TEXT in the COMMENT column (set by "Detect sections"). These are boilerplate sections like Disposal, Warranty, and Service that are shared across documents and not individually translated.

Convert introduction Replaces the Einleitung (introduction) section with a single Pergamon topic reference code in the DE column (<IT01805> for Lidl, <IT01739> for Parkside). Keeps the Headline-01 row, removes duplicates, and sets LOCALIZATION_MODE to PergamonTM_Multi.

Confirm tag location Sets the TAGS column on every row to the full Pergamon folder path derived from the IDML filename. Extracts the IAN code (e.g. 515722_2501 from 03_515722_2501_DE.idml) and builds: Customer→LIDL→Migrated projects (LIDL)→{IAN}.

Apply conditional style mappings 0 rules Replaces style names in PARAGRAPH_STYLE, TABLE_PARAGRAPH_STYLE, TABLE_STYLE, and TABLE_CELL_STYLE columns according to your mapping rules. Supports exact match, ANY_STYLE wildcard, and optional conditions (e.g. only when COMMENT equals SYMBOLS_TABLE_ICON).

Apply mappings for unsupported styles 0/0 mapped Replaces styles not listed in Pergamon supported styles with mapped equivalents. Task completes only when every unsupported style has a replacement assigned.

Apply asset mappings Replaces named linked asset references with mapped equivalents. Only named assets are considered (unidentified placeholders are ignored).

Adjust columns in tables Sets TABLE_COLUMN_1_WIDTH and TABLE_COLUMN_3_WIDTH to "1/7" in the symbols table header row (SYMBOLS_TABLE_HEADLINE_OPENER), matching the required column proportions for the symbols explanation table in Pergamon. Also sets TABLE_STYLE to BasicTableWithBorders on the Table opener and Table closer rows of that table.

Merge tab-indented IS_TABLE rows into previous row Finds IS_TABLE = YES rows where DE or EN-GB begins with [[:TAB:]] — indicating a second InDesign paragraph from the same cell that was exported as a separate row. Appends the content (with [[:TAB:]] replaced by [[:FLB:]]) to the immediately preceding row's corresponding column, then removes the now-empty IS_TABLE row. Run Restart sequence afterwards.

Split indented paragraphs in table cells Finds rows where IS_TABLE = YES and DE or EN-GB contains [[:TAB:]] not at the very start of the text — indicating that two InDesign paragraphs were merged into one cell during export. Splits each such row into two: the first row keeps the text before the tab, the second row starts with [[:TAB:]] and inherits all table metadata from the original row. Run Restart sequence afterwards to renumber rows.

Conversion of headline-02 tables with symbol Detects 2-row tables (Table opener immediately followed by Table closer) where the opener row contains an asset placeholder in DE or EN-GB and the closer row has any Headline- paragraph style. Merges both rows into one non-table row: the asset placeholder is prepended to the headline text (separated by a single space), and all table metadata is cleared.

Apply "With headers" preset to header-style tables Scans all tables, skipping only the symbols explanation table (SYMBOLS_TABLE_HEADLINE_OPENER). For each remaining table, detects whether any content row already carries TableHeaderParagraph as its PARAGRAPH_STYLE: if so, applies the With headers preset (first N rows → TableHeaderParagraph, rest → Body, where N = column count); otherwise applies the Without headers preset (all content rows → Body). In both cases, opener/closer rows receive TABLE_PARAGRAPH_STYLE = InlinePicture and TABLE_STYLE = BasicTableWithBorders. The layout preview shows a green With headers or brown Without headers badge above each table.

Product name replacement Finds all rows with ProductName in PARAGRAPH_STYLE and replaces the DE and EN-GB content with the topic code <IT02046>.

Fix spacing before part markers Replaces any whitespace immediately before a product part marker — (1), [1], up to two digits — with a non-breaking space [[:NBSP:]] in the DE column. Ensures markers stay attached to the preceding word and never wrap to a new line.

Fix spacing around Inline_Small objects Replaces any regular whitespace immediately before and after an asset with object style Inline_Small with a non-breaking space [[:NBSP:]] in the DE and EN-GB columns. Keeps inline icons attached to surrounding words without wrapping.

Add approved status column Adds a STATUS column to the CSV (if not already present) and fills every data row with Approved.

Replace forbidden expressions Replaces all occurrences of expressions in the 🚫 Forbidden list with their configured replacements in DE and EN-GB columns. Reports which cells were changed.

Detect unsupported character styles Scans DE and EN-GB columns for paired character-style tags (e.g. <No Break>…</No Break>). Detected styles appear in Current Issues — click any issue to open the mapping window and choose a replacement or DELETE.

Apply character style mappings — Applies all character style replacements and deletions configured in the Character styles mapping. Tags mapped to another style are replaced; tags mapped to DELETE have their wrapper tags stripped while preserving inner text.

Detect headlines in tables Finds rows with a Headline- paragraph style inside a table (IS_TABLE = YES). Marks them with HEADLINE_IN_TABLE in the COMMENT column and lists each occurrence in Current Issues and the layout preview.

Detect assets in symbols table by descriptions 0 rules For each row with SYMBOLS_TABLE_DESCRIPTION in COMMENT, looks up the DE text in the Symbols table descriptions mapping and writes the matching <ASSET ID="…" objectStyle="Inline_Medium"> to the icon row above (DE and EN-GB). Rows not found in the mapping receive the default fallback asset. Skips rows where the icon row already has a resolved asset ID.

Add script labels Finds rows with SYMBOLS_TABLE_HEADLINE_OPENER in the COMMENT column and writes IN_TABLE_HEADLINE_01 into their SCRIPT_LABEL column.

Convert tables into Signal Words Automatically detects and converts IS_TABLE groups that are signal word tables. Type is determined by three rules: (1) Notice — first or second row EN-GB text contains "NOTICE" or "NOTE" (without WARNING/DANGER/CAUTION); (2) Warning — any body row (row 2 onwards) contains an asset tag; (3) Danger — no asset found in any row. First row gets the signal word style (SignalWordNotice/Warning/Danger), body rows get the corresponding Body style. IS_TABLE is set to NO, all TABLE_* columns are cleared. Asset-only rows are collected and prepended to the first body row. Already-converted groups are skipped.

Apply "Without headers" preset to tables in Technical data section Finds the section starting at any Headline row whose DE/EN-GB text matches Technische Daten / Technical data and ending at the next Headline-01. Runs after signal word conversion so signal word tables are already excluded. Applies the Without headers preset to every table in that range: all rows receive PARAGRAPH_STYLE = Body and TABLE_CELL_STYLE = TableCellBody1; opener/closer rows also receive TABLE_PARAGRAPH_STYLE = InlinePicture and TABLE_STYLE = BasicTableWithBorders.

Sync Bold tags from DE to EN-GB For Numbers rows where DE contains <Bold>…</Bold> but EN-GB does not, counts how many sentences are bolded in DE and applies <Bold> to the same number of sentences in EN-GB. Sentence boundaries are detected by punctuation (. ! ?) followed by an uppercase letter. Rows where EN-GB has fewer sentences than the DE bold count are bolded entirely and flagged in the log.

Unify embedded assets For each row where DE and EN-GB both contain <Asset Name Not Identified self="…"> tags, replaces the self ID in DE with the corresponding one from EN-GB (matched by position). All other tag attributes are preserved. This ensures both columns reference the same embedded asset graphic.

Restart sequence Renumbers the SEQUENCE column from 1 to N for every data row, ensuring a clean sequential order after rows have been added, removed, or reordered.

IDML to Pergamon CSV

Pergamon Styles

Style Mappings

Unsupported Style Mappings

Linked Asset Mappings

Symbols table descriptions

Preview Style Settings

IDML to Pergamon CSV

🚫 Forbidden Expressions

✏ Character Style Mappings