Import - Revision history

Unknown user: /* Database connection */

2020-10-20T13:24:58Z

Database connection

← Older revision		Revision as of 15:24, 20 October 2020
Line 61:		Line 61:
	You must provide a databasename, an username and a password to connect to the database. And the Sql Query to read the data from it.		You must provide a databasename, an username and a password to connect to the database. And the Sql Query to read the data from it.

	You can download a Parameter files (.ini) from this site, to have the right sql query. There is a working example for [https://sourceforge.net/projects/gestinux/files/Imports%20for%20test/English/OpenERP/~~openerp~~.ini/download importing from OpenERP].		You can download a Parameter files (.ini) from this site, to have the right sql query. There is a working example for [https://sourceforge.net/projects/gestinux/files/Imports%20for%20test/English/OpenERP/import_openerp.ini/download importing from OpenERP].

	== Lines ==		== Lines ==

2020-02-05T13:21:39Z

Text replacement - "{{#customtitle:" to "{{DISPLAYTITLE:"

2014-03-12T12:55:21Z

Overview

← Older revision		Revision as of 14:55, 12 March 2014
Line 9:		Line 9:
	* [[Import accounts\|Account chart]]		* [[Import accounts\|Account chart]]
	* [[ImportAccountingRecords\|Accounting records]]		* [[ImportAccountingRecords\|Accounting records]]
			* [[Import_bankstatements\|Bank statements]]

	== Example ==		== Example ==

2013-08-30T11:50:41Z

Database connection

← Older revision		Revision as of 13:50, 30 August 2013
Line 54:		Line 54:
	== Database connection ==		== Database connection ==

	Supported DBMS are MySql, PostgreSQL, MS-Sql-Server, Oracle, Sybase, Interbase, Firebird, SqlLite, or others through ODBC.		Supported DBMS are MySql, MariaDb, PostgreSQL, MS-Sql-Server, Oracle, Sybase, Interbase, Firebird, SqlLite, or others through ODBC.

	For MySql you have already the drivers installed for gestinux. For other DBMS you may have to install the appropriate driver. On Windows this is generally a .dll file to put somewhere. On Linux Ubuntu, you only need to use the Software center (or Synaptics, or apt-get) to find and install a package. Use the forum if you need help.		For MySql you have already the drivers installed for gestinux. For other DBMS you may have to install the appropriate driver. On Windows this is generally a .dll file to put somewhere. On Linux Ubuntu, you only need to use the Software center (or Synaptics, or apt-get) to find and install a package. Use the forum if you need help.

2013-04-19T09:00:21Z

Character set

← Older revision		Revision as of 11:00, 19 April 2013
Line 119:		Line 119:
	When the file to import is in another character set, accentuated characters in non english languages are not displayed correctly.		When the file to import is in another character set, accentuated characters in non english languages are not displayed correctly.

	If you choose the right character set, your input file will be converted, and displayed correctly.		If you choose the right character set, your input file will be converted, and displayed correctly.

	~~In version 0.5, only ISO-8859 is available. In version 1.0 much more character sets are available~~.

2013-01-29T08:12:46Z

2013-01-22T08:19:33Z

← Older revision		Revision as of 10:19, 22 January 2013
Line 8:		Line 8:
	* [[Import journals\|Journals]]		* [[Import journals\|Journals]]
	* [[Import accounts\|Account chart]]		* [[Import accounts\|Account chart]]
	* [[~~Import moves~~\|~~Moves~~]]		* [[ImportAccountingRecords\|Accounting records]]

	== Example ==		== Example ==
Line 64:		Line 64:
	== Lines ==		== Lines ==

	Pour simple data (journals, accounts), each line of the file produces one data object. For more complex data, like ~~moves~~, read the specific explanations.		Pour simple data (journals, accounts), each line of the file produces one data object. For more complex data, like accounting records, read the specific explanations.

	== Columns ==		== Columns ==

2013-01-12T09:19:39Z

Character set

← Older revision		Revision as of 11:19, 12 January 2013
Line 121:		Line 121:
	If you choose the right character set, your input file will be converted, and displayed correctly.		If you choose the right character set, your input file will be converted, and displayed correctly.

	~~Currently~~, only ISO-8859 is available. ~~If you need another, please contact the developpers~~.		In version 0.5, only ISO-8859 is available. In version 1.0 much more character sets are available.

2012-09-04T20:31:10Z

Database connection

← Older revision		Revision as of 22:31, 4 September 2012
Line 56:		Line 56:
	Supported DBMS are MySql, PostgreSQL, MS-Sql-Server, Oracle, Sybase, Interbase, Firebird, SqlLite, or others through ODBC.		Supported DBMS are MySql, PostgreSQL, MS-Sql-Server, Oracle, Sybase, Interbase, Firebird, SqlLite, or others through ODBC.

	For MySql you have already the drivers installed for gestinux. For other DBMS you may have to install the appropriate driver. On Windows this is generally a .dll file to put somewhere. On Linux Ubuntu, you only need to use Synaptics to find and install a package. Use the forum if you need help.		For MySql you have already the drivers installed for gestinux. For other DBMS you may have to install the appropriate driver. On Windows this is generally a .dll file to put somewhere. On Linux Ubuntu, you only need to use the Software center (or Synaptics, or apt-get) to find and install a package. Use the forum if you need help.

	You must provide a databasename, an username and a password to connect to the database. And the Sql Query to read the data from it.		You must provide a databasename, an username and a password to connect to the database. And the Sql Query to read the data from it.

2012-09-04T20:29:36Z

Character set

← Older revision		Revision as of 22:29, 4 September 2012
Line 121:		Line 121:
	If you choose the right character set, your input file will be converted, and displayed correctly.		If you choose the right character set, your input file will be converted, and displayed correctly.

	Currently, only ISO-8859 is available. If you need another, please contact the ~~developers~~.		Currently, only ISO-8859 is available. If you need another, please contact the developpers.