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
Author: Aishwarya M J
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
Display Child Item Name and Exclude Parent Item Name in Results of Saved Search
Scenario User wants to display only the child item name in search results. Since there is no field or setting that excludes the hierarchical information, users will have to use a formula to achieve this. This Formula (Text) works when used in ‘search results’. Solution To create the saved search, follow the steps below: Navigate… Continue reading Display Child Item Name and Exclude Parent Item Name in Results of Saved Search
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
Make Items Unavailable on Webstores in the Magento2-NetSuite Integration App
Scenario: The Celigo integrator does not support the deletion of items from Magento2. To remove items from your webstore, Celigo recommends marking items as unavailable on the webstore. Solution: The Celigo Magento2 Integration App hardcodes all items as Catalog/Search visible in the Item Export Mapping. To adjust this option, a custom field must be created on… Continue reading Make Items Unavailable on Webstores in the Magento2-NetSuite Integration App
Restore the error logs of a removed step in Celigo flow.
To view a removed step’s error logs, restore the step using steps below: Create a new step that uses the same connection as the removed step. Click on “Your existing flow steps”. Select the removed step from the list and add it the flow. The removed step will be restored along with the open error… Continue reading Restore the error logs of a removed step in Celigo flow.
NetSuite routing request to Amazon Vendor Central routing request
This flow syncs NetSuite routing requests (item fulfillments) as Amazon Vendor Central routing requests. When a new item fulfillment is created in NetSuite, this integration flow exports the item fulfillment from NetSuite to Amazon Central Vendor routing request. Flow details Export Source: NetSuite Built-in export: Get NetSuite item shipments – get all item shipments from NetSuite… Continue reading NetSuite routing request to Amazon Vendor Central routing request
preSavePage hook in Celigo
The preSavePage hook is invoked on a page of records before the page is sent to subsequent steps in your flow. This hook can be used to add, update or delete records. This hook is a great place to execute logic on batches of records at the same time. For example: Filter or group records… Continue reading preSavePage hook in Celigo
preMap Hook in Celigo
The pre map hook is invoked on a page of records before the records are mapped from source to destination structures. This hook can be used to validate, update, or ignore records before mapping rules are run. Changes made to records in this hook are localized and will not get passed along to subsequent steps… Continue reading preMap Hook in Celigo
Error in dateFormat handlebar expression when input is empty
Scenario: The below given handlebar expression is used for date format conversion. {{dateFormat “YYYY-MM-DD” custbody_field1 “DD-MM-YYYY”}} An error is encountered when the field1 is empty in NetSuite. Failed to generate field value from template: {{dateFormat “YYYY-MM-DD” custbody_field1 “DD-MM-YYYY”}}. Details: handlebars Helper {{dateFormat}} expects date argument when you have i/p date format. Solution: Modify the expression… Continue reading Error in dateFormat handlebar expression when input is empty