There are four types of field mapping available in the Celigo Platform. Standard mapping, which is a direct one-to-one match, is the default type. The other three options are hard-coded, lookup, and handlebars expression. We can switch to the field mapping type that we need by selecting the gear icon at the end of a… Continue reading Field Mapping Types in Celigo
Tag: field mapping
Custom Field missing in CSV Field Mapping
Follow the steps below to ensure the custom field is visible on the CSV Import Field Mapping: Navigate to Customization > Lists, Records, & Fields > Entity Fields or Transaction Body Fields Edit Custom Field Under Display subtab make sure that the Display Type = Normal Click Save Navigate to Customization > Forms > Entry… Continue reading Custom Field missing in CSV Field Mapping
Proposal for NetSuite Jira Integration and Field Mapping
Proposal Summary This proposal outlines the development of NetSuite Jira Integration sync, including the field Mapping setup for custom records for Growire Group. The primary objective is to synchronize project details, Epics, Jira Tasks, and Time tracking between NetSuite Custom records and Jira. The proposed solution aims to facilitate one directional syncing of project and… Continue reading Proposal for NetSuite Jira Integration and Field Mapping
Mapping fields to null value in CSV imports
While CSV importing records, we can map the fields to NULL value. In the Field mapping stage, Add the fields. Click on the edit icon. Select “SET VALUE TO NULL“. And click “OK”. The field is mapped to NULL value.
CSV import – Invalid reference key issue fix
During CSV import sometimes record importing will fail with an error response message like ‘Invalid entity reference key…’This is due to the field mapped to the document row value having different value types. But in some scenarios, the value will look similar to that of the record field.To fix this issue check whether the correct… Continue reading CSV import – Invalid reference key issue fix
Field mapping type indicators
Letters next to mapped values indicate the field mapping type. none – Standard: Product is a standard mapping value. L – Lookup: Country is a lookup mapping value. M – Multi-field: Transaction_date is a multi-field mapping value. H – Hard-coded: City is a hard-coded mapping value
PROPOSAL FOR UPDATING THE BILLING ADDRESS OF THE PARENT ACCOUNT AND THE SUB-CUSTOMER ACCOUNTS
Requirement: Client wants to update the billing address of the parent accounts and all their sub-customers accounts. The following are the changes to be made : The Billing street Address 1 to: new value The Billing street Address 2 to: make the field empty The Billing Postal Code/Zip to: new postal code. The billing information… Continue reading PROPOSAL FOR UPDATING THE BILLING ADDRESS OF THE PARENT ACCOUNT AND THE SUB-CUSTOMER ACCOUNTS
Field Mapping in integrator.io
Field Mapping in integrator.io
Item Import
Steps to item import.