Error Message Element value “[STRING]” exceeds the fixed length of 30. Use the truncate property if you wish to allow this element value to be truncated. Solution To set the truncate property for CSV files, modify the FTP import configuration. Select Truncate last row delimiter and save the configuration.
Author: Aishwarya M J
Proposal For NetSuite To NetSuite Integration Between warroad and Touchstone using Celigo
Proposal Summary Touchstone Merchandise Group would like to Transfer the Transactions between the Touchstone NetSuite and Warroad NetSuite using Celigo. Requirement The requirement is to Transfer different Transactions between the Touchstone NetSuite account and the Warroad NetSuite account. Deliverables Prerequisites Access to Touchstone NetSuite account and Warroad NetSuite account. Access to Celigo integrator.io. Licence for… Continue reading Proposal For NetSuite To NetSuite Integration Between warroad and Touchstone using Celigo
Confirm if Advanced Financial Add-On is installed.
To check if the License is available on the account: Navigate to Setup > Company > View Billing Information Under Add-On Modules tab, look for Advanced Financials under Name column Next to Advanced Financials, check if the Enabled column is marked as Yes
Navigate your Integration App
When you open an integration, you can use the tools available from the following tabs to track the status of flows in your integration. Your Settings tab helps you customize your forms and fields at the integration, flow, export, import, or connection level. The Flows tab allows you to monitor the status of all your integration flows. The integration Dashboard shows… Continue reading Navigate your Integration App
Custom Product Attribute missing for Mapping
Scenario: A new custom Product attribute is created in Magento. However this attribute is not available in the mapping of the flow “NetSuite Item to Magento Product Add/Update”. Solution: Run the flow “Magento Attribute Set to NetSuite Add/Update”. Even though this flow add/update the Magento Attribute set to NetSuite, it has got a connection to… Continue reading Custom Product Attribute missing for Mapping
Reference fields outside the “Path to many” in import settings
You can append _PARENT before any fields that you need to reference outside the Path to many that you set in your import. Note that ALL fields referenced anywhere in the import (mappings, import configuration, scripts, etc.) will be affected when One to many is set to Yes (advanced). For example, let’s say your import data looks like this: { “exampleField”: “value”,… Continue reading Reference fields outside the “Path to many” in import settings
Debug scripts in integrator.io
To add JavaScript debugging statements to your integrator.io scripts, call a console object method, as follows: Method Description Level console.debug(string1, string 2, …) Fine-grained informational events that are most useful to debug an application. Debug console.info(string1, string 2, …) Equivalent methods for printing informational messages to the execution log. Info console.log(string1, string 2, …) console.warn(string1, string 2, …)… Continue reading Debug scripts in integrator.io
Item Shows as Back Ordered in a Sales Order Despite Having Sufficient Quantity on Hand
Scenario This explains why the items show as back ordered in a transaction even though there’s enough Quantity on Hand. Solution Check if a location is entered on the Sales Order. If not, then a location must be assigned to the Sales Order so that the system will know where to source the item/s from… Continue reading Item Shows as Back Ordered in a Sales Order Despite Having Sufficient Quantity on Hand
Relevance of integrator.io sandbox license
If you are building a custom integration, then you can create an integrator.io connection to the NetSuite sandbox environment without purchasing an integrator.io sandbox license. You can specify the Environment setting of the NetSuite connection. In this use case, NetSuite is taken as an example, but this applies to any other application. Integration app environment licensing requirements:… Continue reading Relevance of integrator.io sandbox license
Switch connection within an integration app from a sandbox to a production instance
The integration apps on the Celigo integrator.io platform are built with fairly heavy components or dependencies on each application and thus switching endpoints or accounts wouldn’t be permitted. Attempting to make changes might impact the overall stability of your integration app and is NOT recommended. If a connection is dependent on a user within the… Continue reading Switch connection within an integration app from a sandbox to a production instance