Importing Data to Datatable from CSV File - Revision history

Ollvihe: /* Import Settings */

2022-08-21T20:23:26Z

Import Settings

← Older revision		Revision as of 20:23, 21 August 2022
Line 6:		Line 6:
	The data import dialog has the following settings:		The data import dialog has the following settings:
	* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.		* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.
	* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). ~~Text~~, integer and date type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used. New columns can also be created to the datatable when the matching is used.		* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). Only text, integer and date type of columns can be selected as matching columns, as equality comparison is possible with those types. If the datatable doesn't yet have any data, matching cannot be used. New columns can also be created to the datatable when the matching is used.
	* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.		* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.
	* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.		* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.

Ollvihe: /* Import Settings */

2022-08-21T20:22:19Z

Import Settings

← Older revision		Revision as of 20:22, 21 August 2022
Line 6:		Line 6:
	The data import dialog has the following settings:		The data import dialog has the following settings:
	* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.		* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.
	* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). ~~Only text~~ and ~~integer~~ type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used. New columns can also be created to the datatable when the matching is used.		* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). Text, integer and date type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used. New columns can also be created to the datatable when the matching is used.
	* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.		* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.
	* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.		* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.

Ollvihe at 14:15, 16 November 2021

2021-11-16T14:15:40Z

← Older revision		Revision as of 14:15, 16 November 2021
Line 1:		Line 1:
	Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import. There is also a matching mode available, which is able to update existing rows in the datatable based on the CSV file data rather than adding new rows (see the ''Match by columns'' setting for more information).		Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import. There is also a matching mode available, which is able to update existing rows in the datatable based on the CSV file data rather than adding new rows (see the ''Match by columns'' setting for more information).

	When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually. When importing timestamps from different time zones, note how to [Managing Time Zones and Local Time\|manage the time zones and local time].		When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually. When importing timestamps from different time zones, note how to [[Managing Time Zones and Local Time\|manage the time zones and local time]].

	== Import Settings ==		== Import Settings ==

Ollvihe at 14:15, 16 November 2021

2021-11-16T14:15:33Z

← Older revision		Revision as of 14:15, 16 November 2021
Line 1:		Line 1:
	Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import. There is also a matching mode available, which is able to update existing rows in the datatable based on the CSV file data rather than adding new rows (see the ''Match by columns'' setting for more information).		Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import. There is also a matching mode available, which is able to update existing rows in the datatable based on the CSV file data rather than adding new rows (see the ''Match by columns'' setting for more information).

	When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually.		When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually. When importing timestamps from different time zones, note how to [Managing Time Zones and Local Time\|manage the time zones and local time].

	== Import Settings ==		== Import Settings ==

Ollvihe: /* Column Settings */

2021-10-25T11:17:51Z

Column Settings

← Older revision		Revision as of 11:17, 25 October 2021
Line 15:		Line 15:

	The following options are possible:		The following options are possible:
	* '''Import data to a new column in the datatable''': Write a column name that doesn't exist in the datatable. When the import is started, the needed new columns are automatically created to the datatable. When importing to a new column, the data type for the new column can be chosen freely.		* '''Import data to a new column in the datatable''': Write a column name that doesn't exist in the datatable. When the import is started, the needed new columns are automatically created to the datatable. When importing to a new column, the data type for the new column can be chosen freely. Note that the maximum allowed column length is 128 characters.
	* '''Import data to an existing column in the datatable''': Choose an existing column in the datatable from the dropdown list. For existing columns, the data type of the column is visible and it cannot be changed, so only that type of data can be imported to the column.		* '''Import data to an existing column in the datatable''': Choose an existing column in the datatable from the dropdown list. For existing columns, the data type of the column is visible and it cannot be changed, so only that type of data can be imported to the column.
	* '''Not to import the column''': Choose the ''<do not import>'' option to ignore this column in the import.		* '''Not to import the column''': Choose the ''<do not import>'' option to ignore this column in the import.

Ollvihe at 15:49, 23 September 2021

2021-09-23T15:49:49Z

← Older revision		Revision as of 15:49, 23 September 2021
Line 1:		Line 1:
	Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import.		Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import. There is also a matching mode available, which is able to update existing rows in the datatable based on the CSV file data rather than adding new rows (see the ''Match by columns'' setting for more information).

	When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually.		When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually.
Line 6:		Line 6:
	The data import dialog has the following settings:		The data import dialog has the following settings:
	* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.		* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.
	* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). Only text and integer type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used.		* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). Only text and integer type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used. New columns can also be created to the datatable when the matching is used.
	* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.		* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.
	* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.		* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.

Ollvihe: /* Import Settings */

2021-09-23T15:47:28Z

Import Settings

← Older revision		Revision as of 15:47, 23 September 2021
Line 6:		Line 6:
	The data import dialog has the following settings:		The data import dialog has the following settings:
	* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.		* '''Select CSV file''': This button opens the file selector to select the CSV file if you want to change the file.
			* '''Match by columns''': Choose datatable columns (one or several) to match with the CSV file data as follows: If a matching row is found in the datatable, that row is updated based on the CSV file data. If no matching row is found, a new row is created to the datatable (this is the behavior when no matching is used). Only text and integer type of columns can be selected as matching columns. If the datatable doesn't yet have any data, matching cannot be used.
	* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.		* '''Column separator''': Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select ''<space''>, or if you want to use tabulator, select ''<tab''>. Note that when changing the column separator, all column specific settings in the table are reset. It's also possible to define several characters for a column separator if that is the case in the CSV file.
	* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.		* '''Skip errors''': Allows to continue the import when encountering errors, and import ''null'' values in place of values where the conversion could not be made. If error skipping is not in use, the import stops to the first encountered error. The data conversions are checked entirely before storing data to the datatable, so conversion errors are observed early and they will not lead to partially imported data. When skipping errors, there is a summary of all the encountered errors when the import is completed.

Ollvihe at 19:48, 15 August 2021

2021-08-15T19:48:38Z

← Older revision		Revision as of 19:48, 15 August 2021
Line 1:		Line 1:
	~~<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">~~
	~~This functionality is available from 2021.6.~~
	~~</div>~~

	Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import.		Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import.

Ollvihe at 11:00, 7 August 2021

2021-08-07T11:00:48Z

← Older revision		Revision as of 11:00, 7 August 2021
Line 3:		Line 3:
	</div>		</div>

	Data can be imported to datatables ~~from CSV files~~ in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. When a CSV file is selected, the import ~~interpret~~ the contents and finds ~~the~~ suitable data types and other conversion ~~parameters~~ for each column. In some special formats, the automatic data type detection does not work, requiring to ~~set~~ the settings manually.		Data from CSV files can be imported to datatables in the [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Data_to_Datatable_from_CSV_File_.28available_in_2021.6.29\|Workspace screen]]. The data is added to the existing datatable and no existing data is removed during the import.

			When the CSV file is selected, the import analyzes the contents and finds suitable data types and other conversion settings for each column. In some special formats, the automatic data type detection does not work, requiring to adjust the settings manually.

	== Import Settings ==		== Import Settings ==

Ollvihe: Ollvihe moved page Importing Data to Datatables to Importing Data to Datatable from CSV File without leaving a redirect

2021-06-28T10:53:25Z

Ollvihe moved page Importing Data to Datatables to Importing Data to Datatable from CSV File without leaving a redirect

← Older revision	Revision as of 10:53, 28 June 2021
(No difference)