In an FTP transfer step, expand the Advanced settings. Enter a Backup files path value relative to the file system’s root directory. For example, if you want integrator.io to store a copy of the transferred file at ftps://ftp.my-site.com/integrations/backup, enter /integrations/backup. This path must already exist on the server. Save your export, run the flow, and verify the existence of the archived files. The… Continue reading Back up files transferred from a source application
Category: Celigo
PreMap hook to convert EDI JSON to objects in order to map
function preMap(options) { const result = options.data.map(function(record) { const errors = []; const formattedRecord = {}; // Existing mappings formattedRecord.syntaxIdentifier = record[“SYNTAX IDENTIFIER”] && record[“SYNTAX IDENTIFIER”][“Syntax identifier”] ? record[“SYNTAX IDENTIFIER”][“Syntax identifier”] : null; formattedRecord.syntaxVersionNumber = record[“SYNTAX IDENTIFIER”] && record[“SYNTAX IDENTIFIER”][“Syntax version number”] ? record[“SYNTAX IDENTIFIER”][“Syntax version number”] : null; formattedRecord.sender = record[“INTERCHANGE SENDER”] && record[“INTERCHANGE… Continue reading PreMap hook to convert EDI JSON to objects in order to map
File Definition Rule to parse NetSuite Invoice JSON to EDI format
{ “_id”: “66ebff0507368eaa45cc3eba”, “lastModified”: “2024-09-27T07:48:31.520Z”, “name”: “Samios”, “sandbox”: true, “description”: “Invoice”, “version”: “1”, “format”: “delimited/edifact”, “skipEmptyEndColDelimiter”: true, “delimited”: { “rowSuffix”: “‘”, “rowDelimiter”: “n”, “colDelimiter”: “+” }, “rules”: [ { “maxOccurrence”: 1, “required”: true, “skipRowSuffix”: true, “elements”: [ { “name”: “UNA”, “value”: “UNA:+.?” } ] }, { “maxOccurrence”: 2, “required”: true, “elements”: [ { “name”: “UNB”,… Continue reading File Definition Rule to parse NetSuite Invoice JSON to EDI format
File Definition Rule for converting EDi Order to Sales Order
{ “resourcePath”: “”, “fileDefinition”: { “_id”: “66e01a66e98dc5437ecc38fe”, “lastModified”: “2024-09-25T09:01:04.872Z”, “name”: “Samios EDIFACT ORDERS”, “sandbox”: true, “description”: “Samios Purchase Order”, “version”: “1”, “format”: “delimited/edifact”, “delimited”: { “rowSuffix”: “‘”, “rowDelimiter”: “n”, “colDelimiter”: “+” }, “rules”: [ { “maxOccurrence”: 1, “required”: true, “skipRowSuffix”: true, “elements”: [ { “name”: “UNA”, “value”: “UNA:” } ] }, { “maxOccurrence”: 1, “required”:… Continue reading File Definition Rule for converting EDi Order to Sales Order
Sales Order EDI Segments and their Explanations with Example data
EDI File: UNA:+.? ‘ UNB+UNOA:3+SUPPEDI:ZZZ+BGW:ZZZ+231024:2358+115883′ UNH+1+INVOIC:D:96A:UN’ BGM+381+9036648188+9′ DTM+137:20231024:102′ RFF+OI:3988367′ NAD+BY+100++BGW TEST COMPANY+675 MACARTHUR AVENUE CENTRAL+PINKENBA+QLD+4008′ RFF+AHP:48009669836′ NAD+SU+30000++SUPPLIER EDI’ RFF+AHP:42004969304′ PAT+3′ DTM+13:20231231:102′ LIN+1++EVH4S11NC:VP’ PIA+1+XXXEVH4S11NC:BP’ IMD+F++:::AC EASY HOME CHARGER’ QTY+47:1:PCE’ MOA+128:1009.85′ PRI+AAA:1009.85′ TAX+7+GST’ MOA+124:100.99′ UNS+S’ CNT+2:1′ MOA+77:1110.84′ MOA+128:1009.85′ MOA+176:100.99′ TAX+7+GST’ MOA+124:100.99′ UNT+26+1′ UNZ+1+115883′ Explanation: ### UNA Segment – UNA:+.? ‘ – UNA: Service String Advice segment, used… Continue reading Sales Order EDI Segments and their Explanations with Example data
Error: Unable to export the matrix item. because the linked matrix children items might not have one of the following required criteria details: – Variation Theme and Variation Options – eTail Channel, Shopify Store – eTail Shopify Item ID map
The error you’re encountering during the matrix item export in NetSuite, suggests that some of the matrix children items are missing required criteria for Shopify integration. Here’s what the missing details imply: Variation Theme and Variation Options: The matrix children must have a variation theme (e.g., size, color) and their respective variation options set properly… Continue reading Error: Unable to export the matrix item. because the linked matrix children items might not have one of the following required criteria details: – Variation Theme and Variation Options – eTail Channel, Shopify Store – eTail Shopify Item ID map
Error : All matrix children doesn’t contain same product_id.
The error “All matrix children doesn’t contain same product_id” in Celigo typically occurs when syncing a matrix item from NetSuite to Shopify. This happens because Shopify expects all variants (matrix children in NetSuite) of a matrix item to share the same product_id, whereas in NetSuite, each matrix child might be treated as a separate product.… Continue reading Error : All matrix children doesn’t contain same product_id.
Maximum file size limits
While the Celigo platform generally supports processing extremely large files (such as 200 MB or greater), here are the few exceptions worth noting: Parsing individual EDI and fixed width files: The maximum limit is 10 MB. Parsing individual XLSX files: The maximum limit is 100 MB. Parsing individual XML files: The maximum limit is 5… Continue reading Maximum file size limits
Remove whitespace in Handlebar Expressions
Whitespace placed before any symbol inside the handlebar expression will cause an error. Correct: {{expression}}{{dateFormat}} Incorrect: {{ expression}}{{ dateFormat}} // note the leading whitespace Error: {{expression {{field}} // second set of opening braces seen as new expression
File naming for FTP Imports
Specify how the files uploaded to the FTP site should be named. You can type ‘{{{‘ to include a predefined timestamp or unique file identifier in your file name. For example, FileXYZ-{{{timestamp “YY-MM-DD” “America/Los_Angeles”}}}.txt will upload files with the following pattern: FileXYZ-16-06-30.txt in America/Los_Angeles time. Or, FileXYZ-{UUID}.txt will upload files with the following pattern: FileXYZ-69368e91d9a440f79165b73afd46859d.txt… Continue reading File naming for FTP Imports