FusionXL DataAuthor - Revision history

Vmurrell: /* Features Overview */

2023-09-13T10:37:32Z

‎Features Overview

Vmurrell: /* Publish Data */

2022-10-04T14:23:26Z

‎Publish Data

Vmurrell: /* Supported Formats */

2022-05-30T14:42:43Z

‎Supported Formats

Vmurrell: /* Data Format */

2021-08-03T12:43:26Z

‎Data Format

Vmurrell: /* Data Format */

2021-08-03T12:34:25Z

‎Data Format

Vmurrell: /* Uncoded Components */

2021-08-03T12:29:53Z

‎Uncoded Components

Vmurrell at 12:24, 3 August 2021

2021-08-03T12:24:59Z

Vmurrell: /* Uncoded Components */

2021-08-02T15:16:44Z

‎Uncoded Components

Vmurrell: /* Supported Formats */

2021-08-02T15:15:00Z

‎Supported Formats

Vmurrell at 12:45, 2 August 2021

2021-08-02T12:45:09Z

@@ Line 23: / Line 23: @@
 |-
 | [[File:Convert Data Button.PNG|60px]] || Convert Data|| Allows users to convert the data into one of the supported formats.
 |}

← Older revision		Revision as of 14:23, 4 October 2022
Line 229:		Line 229:

	==Publish Data==		==Publish Data==
		+	''Note: This feature is not available in FXL V3.0<br>''
		+
	For data providers who have been configured to publish data to the linked Fusion Registry, the Publish Data button facility can be used. This will publish the data in the current worksheet to the linked Registry, for processing, validation, and import.		For data providers who have been configured to publish data to the linked Fusion Registry, the Publish Data button facility can be used. This will publish the data in the current worksheet to the linked Registry, for processing, validation, and import.

@@ Line 64: / Line 64: @@
 ! Colour !! Used for
 |-
-| Black|| Coded attributes which are not mandatory
+| Black|| Coded Attributes which are not mandatory. Time and Measure Components
 |-
 | Black + Bold|| Coded Dimensions
 |-
-| Brown|| Uncoded Components
+| Brown|| Uncoded Dimensions and Attributes)
 |-
-| Brown + Bold|| Mandatory Uncoded Components and Uncoded Dimensions
+| Brown + Bold|| Mandatory Uncoded Attributes and Uncoded Dimensions
 |-
-| Red + Bold|| Mandatory Coded Components
+| Red + Bold|| Mandatory Coded Dimensions and Attributes
 |-
 |}

@@ Line 189: / Line 189: @@
 ===Data Format===
-As well as the components which appear on a worksheet, the Data Structure allows formats to be set is Step 3 of the wizard via the Allowable Content feature.
+As well as the components which appear on a worksheet, the Data Structure allows formats to be set is Step 3 of the wizard via the '''Allowable Content''' feature.
-[[File:Data Format Change button.PNG|500.png]]
-  If
+[[File:Data Format Change button.PNG|900px]]
 =Data Set Action=

← Older revision		Revision as of 12:34, 3 August 2021
Line 188:		Line 188:

	===Data Format===		===Data Format===
		+
		+	As well as the components which appear on a worksheet, the Data Structure allows formats to be set is Step 3 of the wizard via the Allowable Content feature.
		+
		+	[[File:Data Format Change button.PNG\|500.png]]
		+	If

	=Data Set Action=		=Data Set Action=

@@ Line 177: / Line 177: @@
 ===Uncoded Components===
 Attributes which are not linked to a codelist appear on the worksheet in brown text unless they are Dimensions. Dimensions are in black text, bold if coded and normal type if they are not coded.
@@ Line 189: / Line 186: @@
 Instead of displaying a list of codes, the Author Helper will present you with a insert box to enter data, one you press '''Insert''', the text entered will be placed into the worksheet in the selected cell.
 =Data Set Action=

@@ Line 49: / Line 49: @@
 * FUSION-JSON
-An example of a dateset (a subset of ECB:TRD taken from our demo site) is shown below.
+An example of a dataset (a subset of ECB:TRD taken from our demo site) is shown below.
@@ Line 58: / Line 58: @@
 The way the labels are displayed differs depending on the type of component and whether it is 'coded' or not. Components in a Data Structure can be linked to a Codelist to ensure that only permitted data is entered. The permitted values and be see in the '''Author Helper''' which is discussed below.
-Three colors are in use along with bold text:
+Three colours are in use along with bold text:
 {| class="wikitable"
@@ Line 82: / Line 82: @@
 This option allows a logged in user (with the appropriate permissions) to create a dataset for a Provision Agreement held in the connected Registry.
-Once this option is selected new window will open enabling you to chose from the Provision Agreements held on the connected Registry as shown in the example below.
+Once this option is selected new window will open enabling you to choose from the Provision Agreements held on the connected Registry as shown in the example below.
 [[File:Create a Data Set.PNG|600px]]
@@ Line 103: / Line 103: @@
 The red indicators show that more information is available using the Note or Comment Excel feature (depending on which version of MS Excel you are using) and will reveal more information regarding the component.
-The dataset is built by reference to the Data Structure linked to the selected Dataflow for the chosen Data Provider. The Data Structure allows a user to define the components included in the FXL worksheet and specify whether they are coded (by reference to a codelist within the Registry). Components have types which again influences the worksheet. Types can be Dimensions, Attributes and two will be of type Time Dimension and Measure. The time dimension show a period for a measure which is the Observational value.
+The dataset is built by reference to the Data Structure linked to the selected Dataflow for the chosen Data Provider. The Data Structure allows a user to define the components included in the FXL worksheet and specify whether they are coded (by reference to a codelist within the Registry). Components have types which again influences the worksheet. Types can be Dimensions, Attributes and two will be of type Time Dimension and Measure. The time dimension shows a period for a measure which is the Observational value.
 The Components can (optionally) be further refined by applying data formats and restrictions. This information is available to view in the Registry from the Data Structure list, using the '''View Data Structure Definition'''
@@ Line 141: / Line 141: @@
 ===Mandatory Attributes===
-Will appear in bold Red text if the attribute is coded, or bold Brown text if it is uncoded. In the example above, In this case, the OBS_STAUS, TIME_FORMAT and COLLECTION attributes are mandotory and coded.
+Will appear in bold Red text if the attribute is coded, or bold Brown text if it is uncoded. In the example above, In this case, the OBS_STAUS, TIME_FORMAT and COLLECTION attributes are mandatory and coded.
 ===Observation Attributes===

← Older revision		Revision as of 15:16, 2 August 2021
Line 177:		Line 177:

	===Uncoded Components===		===Uncoded Components===
		+
		+	'''This article is work in progress, waiting for format type fix DEV-354'''
		+

	Attributes which are not linked to a codelist appear on the worksheet in brown text unless they are Dimensions. Dimensions are in black text, bold if coded and normal type if they are not coded.		Attributes which are not linked to a codelist appear on the worksheet in brown text unless they are Dimensions. Dimensions are in black text, bold if coded and normal type if they are not coded.

← Older revision		Revision as of 12:45, 2 August 2021
Line 172:		Line 172:

	First, select the Component (in this case REF_AREA) that you want to search on, next enter refine your search. In this example Z has been entered to search for all codes which contain 'z' in either the ID or description. Matches are displayed when the '''Filter''' button is clicked.		First, select the Component (in this case REF_AREA) that you want to search on, next enter refine your search. In this example Z has been entered to search for all codes which contain 'z' in either the ID or description. Matches are displayed when the '''Filter''' button is clicked.
−

	===Long Code Lists===		===Long Code Lists===