Data import and export - Revision history

Kpe: Kpe moved page CSV file import and export to Data import and export

2024-11-09T12:42:58Z

← Older revision	Revision as of 14:42, 9 November 2024
(No difference)

2024-11-09T12:42:29Z

Exporting data

← Older revision		Revision as of 14:42, 9 November 2024
Line 1:		Line 1:
	From the standard user interface its possible to both export and import CSV data files.		From the standard user interface its possible to both export and import CSV data files.

	== Exporting data ==		== Exporting spreadsheet data ==
	Data exports can be done in a blink of an eye		Data exports can be done in a blink of an eye

Line 16:		Line 16:
	* System export: Use field system names in columns (good for later insert/updates)		* System export: Use field system names in columns (good for later insert/updates)

	Note that the ~~CSV~~ export allow you to build VERY large data sets, so be carefull when selecting the "All records" option.		Note that the export allow you to build VERY large data sets, so be carefull when selecting the "All records" option.

	== Importing spreadsheet data ==		== Importing spreadsheet data ==

2024-11-09T12:41:55Z

Importing CSV data

← Older revision		Revision as of 14:41, 9 November 2024
Line 18:		Line 18:
	Note that the CSV export allow you to build VERY large data sets, so be carefull when selecting the "All records" option.		Note that the CSV export allow you to build VERY large data sets, so be carefull when selecting the "All records" option.

	== Importing ~~CSV~~ data ==		== Importing spreadsheet data ==

	In list mode of an solution click the Package import icon.		In list mode of an solution click the Package import icon.

2024-11-09T12:41:42Z

Exporting CSV data

← Older revision		Revision as of 14:41, 9 November 2024
Line 1:		Line 1:
	From the standard user interface its possible to both export and import CSV data files.		From the standard user interface its possible to both export and import CSV data files.

	== Exporting ~~CSV~~ data ==		== Exporting data ==
	Data exports can be done in a blink of an eye		Data exports can be done in a blink of an eye

2021-12-10T10:51:14Z

12 revisions imported

← Older revision	Revision as of 12:51, 10 December 2021
(No difference)

2013-03-08T13:54:19Z

← Older revision	Revision as of 15:54, 8 March 2013
(No difference)

2013-03-08T13:44:36Z

Exporting CSV data

← Older revision		Revision as of 15:44, 8 March 2013
Line 2:		Line 2:

	== Exporting CSV data ==		== Exporting CSV data ==
			Data exports can be done in a blink of an eye

	# In list mode of an solution click the XL sheet icon.		# In list mode of an solution click the XL sheet icon.
	# Choose relevant export options		# Choose relevant export options

	The options are as follows		Note that the export provided respects currect filters, sort order and grouping.

			The export options are as follows
	* All records: Include all records in range		* All records: Include all records in range
	* All fields: Include all exportable fields		* All fields: Include all exportable fields
Line 12:		Line 15:
	* Explode children: Include fields from child records in denormalizaed format (default in list)		* Explode children: Include fields from child records in denormalizaed format (default in list)
	* System export: Use field system names in columns (good for later insert/updates)		* System export: Use field system names in columns (good for later insert/updates)

			Note that the CSV export allow you to build VERY large data sets, so be carefull when selecting the "All records" option.

	== Importing CSV data ==		== Importing CSV data ==

2013-03-08T13:42:11Z

Exporting CSV data

← Older revision		Revision as of 15:42, 8 March 2013
Line 9:		Line 9:
	* All records: Include all records in range		* All records: Include all records in range
	* All fields: Include all exportable fields		* All fields: Include all exportable fields
	* Explode parents:		* Explode parents: Include fields from parent records (default in list)
	* Explode children:		* Explode children: Include fields from child records in denormalizaed format (default in list)
	* System export: Use field system names in columns (good for later insert/updates)		* System export: Use field system names in columns (good for later insert/updates)

2013-03-08T13:40:39Z

Exporting CSV data

← Older revision		Revision as of 15:40, 8 March 2013
Line 4:		Line 4:

	# In list mode of an solution click the XL sheet icon.		# In list mode of an solution click the XL sheet icon.
	# Choose relevant		# Choose relevant export options

			The options are as follows
			* All records: Include all records in range
			* All fields: Include all exportable fields
			* Explode parents:
			* Explode children:
			* System export: Use field system names in columns (good for later insert/updates)

	== Importing CSV data ==		== Importing CSV data ==

2013-03-08T13:38:19Z

Importing CSV data

← Older revision		Revision as of 15:38, 8 March 2013
Line 17:		Line 17:
	* FAILED [reason why]		* FAILED [reason why]

	In case of inserts an DataID column is also added to the response.		In case of inserts an DataID column is also added to the response.

			Tip: In case some lines fail. Just remove the lines with SUCCES, correct the faulty ones and try again after saving changes to the response file.

	=== New data (insert) ===		=== New data (insert) ===