}bedrock.hier.import

Description

This process will import Dimension elements into a specified Hierarchy from a File. The process is able to read a file generated by }bedrock.hier.export.
Format of the file:

• 1st line: File metadata contains summary information about the dimension, hierarchy, number of elements and date/time when file was generated.
• 2nd line: Source dimension and hierarchy.
• 3rd line: Dimension sort order.
• 4th and 5th line: Reserved for future development.
• 6th line: Header for elements export.
• 7th line and forth: Elements export data.

Use Case:

1. Restore a dimension from a backup.
2. Quick replication of a large dimension.

Note:
Valid dimension name (pDim) is mandatory otherwise the process will abort.
If needed, custom delimiter might be used by specifying parameter pDelim value as either exactly one character or as a 3-digit (decimal) ASCII code. For example to use TAB as a delimiter, use 009.

⚠️Caution: Process was redesigned in Bedrock4 but is able to process dimension extracts from prior versions of Bedrock in legacy mode (pLegacy = 1).

Process Parameters

Parameter	Data Type	Default	Prompt Text
pLogOutput	Numeric	0	OPTIONAL: Write parameters and action summary to server message log (Boolean True = 1)
pDim	String		REQUIRED: Dimension
pHier	String		OPTIONAL: Target Hierarchy (defaults to dimension name if blank)
pSrcDir	String		OPTIONAL: Source Directory Path (defaults to Error File Directory)
pSrcFile	String		OPTIONAL: Source File Name (defaults to 'Dimension Hierarchy _Export.csv' if blank)
pDelim	String	,	OPTIONAL: AsciiOutput delimiter character (Default=comma, exactly 3 digits = ASCII code)
pQuote	String	"	OPTIONAL: AsciiOutput quote character (Accepts empty quote, exactly 3 digits = ASCII code)
pLegacy	Numeric	0	OPTIONAL: 1 = Legacy format (bedrock v3) 0 or empty = new bedrock v4 format

Full Process Dependencies

Process	ExecuteProcess	RunProcess
}bedrock.hier.unwind	Y	N
}bedrock.hier.create	Y	N