UPDATE: CorelDraw (.CDR) Production Automation – Multi-Size Laser Foil Templates with CSV Data Merge

UPDATED Description: We are looking for an expert CorelDraw (.CDR) automation designer/programmer to construct a highly robust, automated industrial template system for laser cutting and etching coin capsule foil inserts, coin slab labels, and banknote slab banners. The goal is to create a single master .CDR file utilizing CorelDraw’s Print Merge / Data Merge functionality paired with custom VBA/VSTA macros. The system must seamlessly ingest our attached external master CSV data file to automatically adjust layout dimensions, toggle border designs, center text fields dynamically, scale inner cutouts, and format the canvas boundaries on the fly without crashing. Please refer directly to the attached "[login to view URL]" file to review the exact multi-line columns that your script must parse. --- 1. PRODUCT DIMENSIONS & PROPORTIONAL ANCHORING (Multi-Size Support) The template must dynamically adapt its outer red hairline vector cut boundary to varying shapes based on two incoming CSV column variables: [SLAB_WIDTH] and [SLAB_HEIGHT]. The system must natively generate: - Capsule Inserts: Square frames (80x80mm, 60x60mm, 40x40mm) - Coin Slab Labels: Landscape rectangles (e.g., 46.0x23.5mm, 46.0x35.0mm, 55.0x25.0mm) - Banknote Slab Labels: Long horizontal banners (e.g., 200.0x25.0mm, 150.0x25.0mm, 200.0x35.0mm) CRITICAL DESIGN RULE: Linear percentage scaling of the entire document is strictly forbidden. When the outer layout dimensions change, text boxes and toggleable borders must use Object Positioning / Anchoring constraints relative to the outer boundaries. Typography must remain locked at a highly legible, fixed single-line point size (5pt to 12pt depending on hierarchy) and shift positions proportionally rather than distorting. --- 2. MULTI-LINE TYPOGRAPHY & TOGGLEABLE DESIGN LAYOUTS - Font Requirement: You MUST use clean, single-line/stick/wire fonts optimized for high-speed laser scoring (e.g., CNC or CAD stick fonts) so characters do not blur or dual-trace. - The template must read the column variable [LAYOUT_STYLE] to toggle between two completely independent layer arrangements: * Option A: "Classic" Layout - Text fields are locked to a curved Text-on-Path envelope tracking the radius of the center coin hole. * Option B: "Modern" Layout - All fields bypass arced tracking and remain perfectly straight, aligned to a clean horizontal grid block. TEXT ARCHITECTURE FIELDS: - [FRONT_TOP_L1]: Primary upper text field. For Quadrums, this maps Year (Large font). - [FRONT_TOP_L2]: Secondary upper text field. For Quadrums, this maps Issuing Country (Smaller font). For Banknotes, this houses the prominent face value / denomination (Massive font). - [FRONT_BOTTOM_L1]: Primary lower text field. For Quadrums, this maps Coin Series (Large font). For Banknotes, this acts as the bottom descriptive data line. - [FRONT_BOTTOM_L2]: Secondary lower text field. For Quadrums, this maps Mint Location (Smaller font). --- 3. DYNAMIC HOLE SIZING, TOGGLEABLE BORDERS, & BANKNOTE MICRO-TEXT - Center Cutout: For capsule items, the central laser-cut circle (hairline red path) must automatically scale its diameter exactly to the millimeter based on the numerical value provided in the [HOLE_DIAMETER] CSV column. This must remain mathematically locked to the geometric center of the template. If [HOLE_DIAMETER] reads as "0", the circle cutout must automatically deactivate for a solid label. - Border Selection Layers: The file must contain three distinct geometric border layers within the Object Manager that can be toggled on/off automatically: * Theme 1: An elegant, wavy Guilloche/Geometric pattern line. * Theme 2: A classic Greek Key or Braided Rope loop pattern line. * Theme 3: A clean, modern minimalist double-rule frame line. - Banknote Reverse Layer: If [PRODUCT_TYPE] is set to "Banknote", the reverse side layer must remain 100% static and automatically trigger a "Micro-Text Step-and-Repeat" security print effect, looping a continuous string of currency codes at a miniature single-line size (1.5pt to 2.5pt font) across a dense horizontal grid of 12 to 14 rows. --- 4. DYNAMIC SUPPRESSION & CUSTOMER DATA VALIDATION Because this data is generated from a front-end e-commerce website, the macro script must be highly resilient: - Blank Field Suppression: If an auxiliary text column (such as FRONT_TOP_L2 or FRONT_BOTTOM_L2) is left completely empty in the CSV because a customer wants a minimalist look, the template must use auto-collapse logic. The empty line object must vanish entirely, and the remaining populated text fields must automatically re-center themselves vertically within their margin thresholds. - Case Insensitivity & Trimming: The macro must auto-trim accidental trailing whitespaces and ignore case variations. - Text Auto-Wrapping/Fitting: Text paths must use envelope/force-fit tracking. If a customer inputs a long country name, the text must scale down slightly in width to remain safely inside the margin thresholds rather than clipping past the borders. - Error Catching: If a row contains a critical physical error, the script must cleanly skip that entry and log an error report rather than freezing the batch process. --- REQUIRED DELIVERABLES LIST To claim the milestone payment, the following packaged ZIP directory must be submitted: 1. Master CorelDraw Production File (.CDR): Fully unlocked, multi-layer automated file compatible with CorelDraw 2022 or newer, preserving active data tags and raw single-line font paths. 2. Production-Ready Samples (.DXF and .EPS): Flat vector files demonstrating a clean export tracking the color code standard (Red hairline for cuts, Black lines for etching paths). 3. Asset & Instruction Kit: The precise single-line font assets utilized (.TTF/.OTF) and a quick 2-minute video walkthrough (.MP4) proving data ingestion, border switching, and automated multi-size generation function properly. Please confirm in your bidding proposal if you possess verified experience programming CorelDraw Print Merge macros and CAD object anchoring constraints. --- REFERENCE DATA ARCHITECTURE MATRIX Bidders, please configure your CorelDraw Print Merge template and VBA macro to cleanly parse this exact spreadsheet structure. Use these exact column headers to test your dynamic multi-size, multi-line, and blank-field suppression rules: SLAB_WIDTH,SLAB_HEIGHT,PRODUCT_TYPE,LAYOUT_STYLE,FRONT_TOP_L1,FRONT_TOP_L2,FRONT_BOTTOM_L1,FRONT_BOTTOM_L2,BACK_TOP,BACK_BOTTOM,HOLE_DIAMETER 80.0,80.0,Capsule,Classic,2026,UNITED STATES,AMERICAN SILVER EAGLE,US MINT,1 TROY OZ,.999 FINE SILVER,41.6 80.0,80.0,Capsule,Classic,2024,CANADA,CANADIAN MAPLE LEAF,,1 TROY OZ,.9999 FINE SILVER,39.0 46.0,23.5,Coin_Slab,Modern,AUSTRALIA 1943,,FLORIN,,92.5% SILVER • 11.31g,MELBOURNE MINT,0 46.0,35.0,Coin_Slab,Classic,ANCIENT GREECE,,ATHENIAN TETRADRACHM,,RAW SILVER • 17.20g,ATTICA REGION MINT,0 55.0,25.0,Coin_Slab,Modern,CANADA 1965,,VOYAGEUR DOLLAR,,80.0% SILVER • 23.33g,ROYAL CANADIAN MINT,0 200.0,25.0,Banknote,Modern,AUSTRALIA / RESERVE BANK OF AUSTRALIA / NOTE PRINTING AUSTRALIA,10 DOLLARS,FIRST POLYMER SERIES • 1993 • SERIAL: AA 93000001 • SIGNATURES: FRASER-EVANS • P#52A,,,0 150.0,25.0,Banknote,Modern,PAPUA NEW GUINEA / BANK OF PNG / DE LA RUE,2 KINA,FIRST PAPER ISSUE • 1975 • SERIAL: AGA 000001 • SIGNATURES: TOROBERT-NARAKOBI • P#1,,,0 I will upload the CSV file version tomorrow

Project ID: 40559470