Jammy at 08:46, 27 February 2026

2026-02-27T08:46:19Z

← Older revision		Revision as of 08:46, 27 February 2026
Line 415:		Line 415:
	}		}
	</syntaxhighlight>		</syntaxhighlight>

			= Working documents =

			[[:Category:Working_documents - Import Data\|Working_documents - Import Data]]

			[[Category:Backend services\| Import Data]]

Jammy at 08:43, 27 February 2026

2026-02-27T08:43:36Z

Show changes

Jammy: Created page with "= CsvImportConfig = { "csvImportConfigId": "xxxxx", "recordDeliminator": "\n", "useUserReference": true, "fieldDeliminator": ",", "escapeString": "\\", "removeFloatingEscapeString": true, "removeWhiteSpace": true, "fieldNames": { "titleRow": 1, "titleRowOpenEnclose": "\"", "titleRowCloseEnclose": "\"", "replacefieldNames": {} }, "ignoreRows": [4,5], "overwriteColumnNam..."

2026-02-26T11:07:31Z

Created page with "= CsvImportConfig = <syntaxhighlight lang="JavaScript"> { "csvImportConfigId": "xxxxx", "recordDeliminator": "\n", "useUserReference": true, "fieldDeliminator": ",", "escapeString": "\\", "removeFloatingEscapeString": true, "removeWhiteSpace": true, "fieldNames": { "titleRow": 1, "titleRowOpenEnclose": "\"", "titleRowCloseEnclose": "\"", "replacefieldNames": {} }, "ignoreRows": [4,5], "overwriteColumnNam..."

New page

= CsvImportConfig =
<syntaxhighlight lang="JavaScript">
{
"csvImportConfigId": "xxxxx",
"recordDeliminator": "\n",
"useUserReference": true,
"fieldDeliminator": ",",
"escapeString": "\\",
"removeFloatingEscapeString": true,
"removeWhiteSpace": true,
"fieldNames": {
"titleRow": 1,
"titleRowOpenEnclose": "\"",
"titleRowCloseEnclose": "\"",
"replacefieldNames": {}
},
"ignoreRows": [4,5],
"overwriteColumnName": {
"fieldName": "{replaceToValue}"
},
"objectTypes": [],
"floatingRelationships": []
}

</syntaxhighlight>
*csvImportConfigId (required) = The ID of the CsvImportConfig

*recordDelimiter (required) = The row delimiter

*fieldDelimiter (required) = The column delimiter

*escapeString (required) = The character used to escape delimiters (e.g., " to indicate that this is a quotation mark, not a column delimiter)

*removeFloatingEscapeString (required) = Remove any standalone (floating) escape characters

*removeWhiteSpace (required) = Remove whitespace within the column

*titleRow (required) = Specify which row (x) of the CSV is the header row

*ignoreRows (required) = Ignore the specified rows

=objectTypes=

<syntaxhighlight lang="JavaScript">
"objectTypes": [
{
"setObjectTypeFieldNames": {},
"objType": {
"serviceTag": "Translations",
"objectType": "translationLink"
},
"searchPattern": "^translationLink.*:",
"instancePattern": "(?<=translationLink)(.*)(?=:)",
"fieldNamePatterns": [
{
"fieldNamePattern": "(?<=:translationLink-A)",
"fieldName": "translationLink"
}
],
"fieldNameSearchPattern": "(?<=:)(.*)",
"referenceFieldNames": [
"userRef",
"ref"
],
"referenceLinks": {
"linkTagetToTL": {
"relType": {
"serviceTag": "Translation",
"relationshipTag": "hasTranslationLink"
},
"direction": "from"
}
},
"defaultActionField": "create",
"actionField": {
"fieldName": "actionField",
"createValue": "c",
"updateValue": "u",
"referenceValue": "r"
},
"defaultEnclose": {
"openEnclose": "\"",
"closeEnclose": "\""
},
"enclose": [
{
"openEnclose": "\"",
"closeEnclose": "\"",
"alwaysEnclose": "always",
"fieldNames": [
"weight",
"textTag",
"languageId",
"userRef"
]
}
],
"emptyDataFieldNames": [],
"overwriteValues": {}
}
]
</syntaxhighlight>
*setObjectTypeFieldNames (optional) = Specify the objType for each instancePattern (used when the same searchPattern is shared but the instancePattern differs). For example:
<syntaxhighlight lang="JavaScript">
"setObjectTypeFieldNames": {
         "subObjectTypeX": {
           "serviceDeliverySTD1": {
             "serviceTag": "DelivMethodSTD",
             "objectType": "deliveryMethod"
           },
           "rateTable001": {
             "serviceTag": "DeliveryMethodRAT",
             "objectType": "rates"
           }
         }
       }
</syntaxhighlight>

{| class="wikitable"
! deliveryDELIVERYSTD:actionField !! deliveryDELIVERYSTD:subObjectTypeX !! deliveryRATETABLE:actionField !! deliveryRATETABLE:subObjectTypeX
|-
| c || serviceDeliverySTD1 || c || rateTable001
|-
|}
By defining "searchPattern": "^delivery.*:",

the instancePattern is DELIVERYSTD, the objType will be set accordingly
<syntaxhighlight lang="JavaScript">
{
        "serviceTag": "DelivMethodSTD",
        "objectType": "deliveryMethod"
}

</syntaxhighlight>

the instancePattern is RATETABLE, the objType will be set accordingly.
<syntaxhighlight lang="JavaScript">
{
        "serviceTag": "DeliveryMethodRAT",
        "objectType": "rates"
}

</syntaxhighlight>
*searchPattern (required) = The system will look for column names that start with the value of searchPattern, followed by :

*referenceLinks (optional) = Used in the case of a ReferenceLink to specify the targetObject and which Relationship to use

*instancePattern (required) = Extract the Instance name (e.g., if searchPattern = translationLink, then translationLinkA will extract A as the Instance)

*referenceFieldNames (required) = The fields used as references

*actionField (required) = Define the action abbreviation in the CSV (e.g., c = create, u = update, r = reference)

*defaultActionField (optional) = If no Action is specified, the system will use the Action defined here

*enclose (required) = The fields specified in fieldNames must be enclosed

*defaultEnclose (required) = Fields not specified in enclose will use the defaultEnclose value

=FloatingRelationShip=

2026-02-26 - ImportData CsvImportConfig - Revision history

Jammy at 08:46, 27 February 2026

Jammy at 08:43, 27 February 2026