Plugin: CSV Importer - Revision history

CarlosRuiz: deprecated

2024-04-22T15:34:21Z

deprecated

2020-11-28T11:18:23Z

2019-12-17T14:09:39Z

2019-04-23T09:51:42Z

remove dead w4grb extension

2019-02-22T14:05:25Z

2017-01-31T00:03:32Z

JIRA Reference

2015-05-20T13:31:23Z

link

2015-05-20T11:06:53Z

2015-05-20T11:06:25Z

2015-05-20T11:04:12Z

← Older revision		Revision as of 15:34, 22 April 2024
Line 54:		Line 54:


−	[[Category:~~Available_Plugins~~]]	+	[[Category:Deprecated_Plugins]]

@@ Line 1: / Line 1: @@
 *'''Maintainer:''' [[User:Diego.ruiz|Diego Ruiz]] - [[User:TBayen|Thomas Bayen]] - BXService GmbH, Krefeld
-*'''Status:''' Beta
+*'''Status:''' Beta - Unsupported
 *'''License:''' [http://www.gnu.org/licenses/gpl-2.0.html GPLv2]
 *'''Sources:''' [https://github.com/bxservice/de.bxservice.csvimporter GitHub]
 == Description ==

@@ Line 2: / Line 2: @@
 *'''Status:''' Beta
 *'''License:''' [http://www.gnu.org/licenses/gpl-2.0.html GPLv2]
-*'''Sources:''' [https://bitbucket.org/tbayen_bxservice/de.bxservice.csvimporter/overview bitbucket]
+*'''Sources:''' [https://github.com/bxservice/de.bxservice.csvimporter GitHub]
 == Description ==

← Older revision		Revision as of 09:51, 23 April 2019
Line 10:		Line 10:

	'''Note: This plugin has a time improvement only for postgresql database instances'''		'''Note: This plugin has a time improvement only for postgresql database instances'''
−
−	~~== Feedback ==~~
−
−	~~Please rate this plugin:~~
−
−	~~{{#w4grb_rate:Plugin:_CSV_Importer}}~~
−
−	~~<w4grb_ratinglist pagevotes idpage="Plugin:_CSV_Importer" items="30"/>~~
−

	If you want to provide additional comments, please use the [[Talk:Plugin:_CSV_Importer\|Discussion page]]		If you want to provide additional comments, please use the [[Talk:Plugin:_CSV_Importer\|Discussion page]]

← Older revision		Revision as of 14:05, 22 February 2019
Line 48:		Line 48:

	As you can see in the results the second process took '''16 minutes 48 seconds''' less time committing, that means a '''22.16% faster''' than the standard way.		As you can see in the results the second process took '''16 minutes 48 seconds''' less time committing, that means a '''22.16% faster''' than the standard way.
		+
		+	== Warning about Asynchronous Commit ==
		+	As explained in the [https://www.postgresql.org/docs/9.6/wal-async-commit.html PostgreSQL documentation]
		+	<blockquote>
		+	Asynchronous commit introduces the risk of data loss. There is a short time window between the report of transaction completion to the client and the time that the transaction is truly committed (that is, it is guaranteed not to be lost if the server crashes). Thus asynchronous commit should not be used if the client will take external actions relying on the assumption that the transaction will be remembered. As an example, a bank would certainly not use asynchronous commit for a transaction recording an ATM's dispensing of cash. But in many scenarios, such as event logging, there is no need for a strong guarantee of this kind.
		+	</blockquote>

	== JIRA Reference ==		== JIRA Reference ==

@@ Line 51: / Line 51: @@
 == JIRA Reference ==
 [https://idempiere.atlassian.net/browse/IDEMPIERE-2630 IDEMPIERE-2630]
 [[Category:Available_Plugins]]

← Older revision		Revision as of 13:31, 20 May 2015
Line 49:		Line 49:
	As you can see in the results the second process took '''16 minutes 48 seconds''' less time committing, that means a '''22.16% faster''' than the standard way.		As you can see in the results the second process took '''16 minutes 48 seconds''' less time committing, that means a '''22.16% faster''' than the standard way.

		+	== JIRA Reference ==
		+	[https://idempiere.atlassian.net/browse/IDEMPIERE-2630 IDEMPIERE-2630]

	[[Category:Available_Plugins]]		[[Category:Available_Plugins]]

← Older revision		Revision as of 11:06, 20 May 2015
Line 40:		Line 40:


−	[[Image:Idempeirecsvimporter.png\|~~aaaaaaa~~]] ''IDEMPIERE STANDARD IMPORTER''	+	[[Image:Idempeirecsvimporter.png\|IDEMPIERE STANDARD WAY]] ''IDEMPIERE STANDARD IMPORTER''

@@ Line 24: / Line 24: @@
 == Configuration ==
 After installing the plugin login as System and go to the Report/Process window, go to the Import CSV Process record and change the classname for "de.bxservice.process.ImportCSVProcess" to run the new class.
 After you do that, you can configure the Import CSV Process as usual, in the Import Template window you will see a new field (Asynchronous Commit)
@@ Line 38: / Line 40: @@
-[[Image:Idempeirecsvimporter.png]]    ''IDEMPIERE STANDARD IMPORTER''
+[[Image:Idempeirecsvimporter.png|aaaaaaa]]    ''IDEMPIERE STANDARD IMPORTER''

@@ Line 37: / Line 37: @@
 In the tables below you can see the result after applying a csv file with 103.222 records. The first table shows the behavior in the normal iDempiere way, the second one the behavior after applying the plugin.
-[[Image:Idempeirecsvimporter.png]]
+[[Image:Idempeirecsvimporter.png]]    ''IDEMPIERE STANDARD IMPORTER''
 [[Image:Csvpluginresults.png]]
 As you can see in the results the second process took '''16 minutes 48 seconds''' less time committing, that means a '''22.16% faster''' than the standard way.