Service - Import Data - Revision history

Mint: /* CsvImportConfig */

2025-11-03T00:54:20Z

CsvImportConfig

← Older revision		Revision as of 00:54, 3 November 2025
Line 165:		Line 165:
	objectTypes: [		objectTypes: [
	{		{
	setObjectTypeFieldNames: { // if a value in a specific field sets the rows objectType		setObjectTypeFieldNames: { // optional if a value in a specific field sets the rows objectType
	[fieldName]: {		[fieldName]: {
	[fieldValue]: {		[fieldValue]: {
Line 215:		Line 215:
	],		],
	defaultActionField: "c", // if not set action from feed of config use action defaultActionField		defaultActionField: "c", // if not set action from feed of config use action defaultActionField
	actionField: {		actionField: { // optional
	fieldName: "action",		fieldName: "action",
	createValue: "c",		createValue: "c",
Line 239:		Line 239:
	openEnclose: "\"",		openEnclose: "\"",
	closeEnclose: "\"",		closeEnclose: "\"",
	alwaysEnclose: "always", // "always"\|"optional", default always // NOT SURE NEEDED, maybe always check if exists or not		alwaysEnclose: "always", //optional "always"\|"optional", default always // NOT SURE NEEDED, maybe always check if exists or not
	fieldNames: []		fieldNames: []
	}		}

2025-11-03T00:52:32Z

CsvImportConfig

2025-09-24T05:36:32Z

FloatingRelationships

← Older revision		Revision as of 05:36, 24 September 2025
Line 356:		Line 356:
	{		{
	importBatchId: "xx", // random uuid		importBatchId: "xx", // random uuid
	identifierRelationshipsId: "xx", // ~~random uuid~~		identifierRelationshipsId: "xx", // hash all and property in referenceProperty eg:(importBatchId,setRelationshipTagFieldNamesIndex,relationshipTag,action,relId,relType,objectAReferenceLinkId,objectBReferenceLinkId,relationshipProperties)
	referenceProperty:{		referenceProperty:{
	objectAReferenceLinks: "rateTableRef01",		objectAReferenceLinks: "rateTableRef01",// req
	objectBReferenceLinks: "delMethodStd01",		objectBReferenceLinks: "delMethodStd01", // req
	relationshipTag: "hasRateTable",		relationshipTag: "hasRateTable", // req
	relationshipProperty: {...}		relationshipProperty: {...} // optional
	}		},
			floatingStatus:"xx"//complete,processing
	}		}
	</syntaxhighlight>		</syntaxhighlight>

2025-09-24T05:31:31Z

CsvImportConfig

← Older revision		Revision as of 05:31, 24 September 2025
Line 133:		Line 133:
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
	csvImportConfigId: "xx", // random uuid		csvImportConfigId: "xx", // (now)hash all Object. (old)random uuid
	useUserReference:true, // optional , for user use table ImportUserReference.		useUserReference:true, // optional , for user use table ImportUserReference.
	recordDeliminator: "\n",		recordDeliminator: "\n",

2025-09-24T05:30:56Z

CsvImportConfig

← Older revision		Revision as of 05:30, 24 September 2025
Line 134:		Line 134:
	{		{
	csvImportConfigId: "xx", // random uuid		csvImportConfigId: "xx", // random uuid
	~~userId: "xx", // user who controls/created/owns the config,~~
	useUserReference:true, // optional , for user use table ImportUserReference.		useUserReference:true, // optional , for user use table ImportUserReference.
	recordDeliminator: "\n",		recordDeliminator: "\n",

2025-03-19T03:41:55Z

ImportUserReference

← Older revision		Revision as of 03:41, 19 March 2025
Line 122:		Line 122:
	userId: "xx",		userId: "xx",
	userReference: "xx", // hash {objType+referenceId}		userReference: "xx", // hash {objType+referenceId}
	// identifiers:{ eg: locationNodeId:"xyz"} // if have identifier		identifiers:{ eg: locationNodeId:"xyz"} // optional, if have identifier
	}		}
	</syntaxhighlight>		</syntaxhighlight>

2025-03-19T03:37:04Z

ImportUserReference

← Older revision		Revision as of 03:37, 19 March 2025
Line 126:		Line 126:
	</syntaxhighlight>		</syntaxhighlight>

	* partition key: userId		* partition key: userId // user submit.
	* sort key: userReferenceId		* sort key: userReferenceId

2025-03-19T03:36:25Z

ImportUserReference

← Older revision		Revision as of 03:36, 19 March 2025
Line 117:		Line 117:

	== ImportUserReference ==		== ImportUserReference ==
			Data of each user for create feed.
	<syntaxhighlight lang="JavaScript">		<syntaxhighlight lang="JavaScript">
	{		{
Line 127:		Line 128:
	* partition key: userId		* partition key: userId
	* sort key: userReferenceId		* sort key: userReferenceId

	== CsvImportConfig ==		== CsvImportConfig ==

2025-03-19T03:29:22Z

DynamoDB tables

@@ Line 115: / Line 115: @@
 * partition key: importBatchId
 * sort key: pendingLinkId
 == CsvImportConfig ==

2025-03-19T02:05:26Z

PendingObjectMain

← Older revision		Revision as of 02:05, 19 March 2025
Line 75:		Line 75:
	rowNumber: "xx", // the order in which this record was extracted from source file		rowNumber: "xx", // the order in which this record was extracted from source file
	objectMainStatus: "xx", // processing\|creating\|complete\|error		objectMainStatus: "xx", // processing\|creating\|complete\|error
			existingUserReference:true // optional, show the reason for changing the action from create to reference without using identifier to reference.
	errorsFound: {},		errorsFound: {},
	}		}