Merge lp:~max3903/addons-tko/import_odbc into lp:~dreis-pt/addons-tko/reis

Status: Merged
Approved by: Daniel Reis
Approved revision: 15
Merge reported by: Daniel Reis
Merged at revision: not available
Proposed branch: lp:~max3903/addons-tko/import_odbc
Merge into: lp:~dreis-pt/addons-tko/reis
Diff against target: 58 lines (+16/-13)
1 file modified
import_odbc/__openerp__.py (+16/-13)
To merge this branch: bzr merge lp:~max3903/addons-tko/import_odbc
Reviewer Review Type Date Requested Status
Daniel Reis Pending
Review via email: mp+117913@code.launchpad.net
To post a comment you must log in.
lp:~max3903/addons-tko/import_odbc updated
15. By Maxime Chambreuil (http://www.savoirfairelinux.com)

[MERGE]

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== renamed directory 'reis_import_odbc' => 'import_odbc'
2=== modified file 'import_odbc/__openerp__.py' (properties changed: +x to -x)
3--- reis_import_odbc/__openerp__.py 2012-07-20 16:24:33 +0000
4+++ import_odbc/__openerp__.py 2012-08-02 14:53:22 +0000
5@@ -25,34 +25,37 @@
6 'category': 'Tools',
7 'description': """
8 Import data directly from other databases.
9-Installed in the Administration module, menu Configuration > Import from ODBC.
10+
11+Installed in the Administration module, menu Configuration -> Import from ODBC.
12
13 Features:
14-* Connects to other databases using ODBC (pyodbc) or Oracle Client (cx_Oracle).
15-* Fetched data from the databases are used to build lines equivalent to regular import files. These are imported using the standard "import_data()" ORM method, benefiting from all its features, including xml_ids.
16-* Each table import is defined by an SQL statement, used to build the equivalent for an import file. Each column's name should correspond to the column names you would use in an import file. The first column must provide an unique identifier for the record, and will be used to build it's xml_id.
17-* The last sync date is the last (successfull) execution. You can select only records changed since the last execution by adding a WHERE clause using this date with the representation "%s".
18-* When errors are found, only the record with the error fails import. The other correct records are commited. However, the "last sync date" will only be automaticaly updated when no errors are found.
19-* The import execution can be scheduled to run automaticaly.
20+ * Connects to other databases using ODBC (pyodbc) or Oracle Client (cx_Oracle).
21+ * Fetched data from the databases are used to build lines equivalent to regular import files. These are imported using the standard "import_data()" ORM method, benefiting from all its features, including xml_ids.
22+ * Each table import is defined by an SQL statement, used to build the equivalent for an import file. Each column's name should match the column names you would use in an import file. The first column must provide an unique identifier for the record, and will be used to build its xml_id.
23+ * The last sync date is the last (successfull) execution. You can select only records changed since the last execution by adding a WHERE clause using this date with the representation "%s".
24+ * When errors are found, only the record with the error fails import. The other correct records are commited. However, the "last sync date" will only be automaticaly updated when no errors are found.
25+ * The import execution can be scheduled to run automatically.
26
27 Example SQL:
28 SELECT PRODUCT_CODE as "ref", PRODUCT_NAME as "name", 'res_partner_id_'+SUPPLIER_ID as "partner_id/id"
29 FROM T_PRODUCTS
30 WHERE DATE_CHANGED >= %s
31
32-To use ODBC you need to install unixodbc and python-pyodbc packages.
33-To connect to SQLServer you need to install and configure FreeTDS driver (tdsodbc package) and confire it through ODBC.
34-To connect to Oracle you need to install and configure the Instant Client, and install the cx_Oracle python library. This library can be used to establish the connection without the nedd for ODBC.
35+To use ODBC, you need to install unixodbc and python-pyodbc packages.
36+
37+To connect to MS SQL Server, you need to install and configure FreeTDS driver (tdsodbc package) and configure it through ODBC.
38+
39+To connect to Oracle, you need to install and configure the Instant Client, and install the cx_Oracle python library. This library can be used to establish the connection without the nedd for ODBC.
40 """,
41 'author': 'Daniel Reis',
42 'website': '',
43 'depends': ['base'],
44- 'init_xml': [],
45- 'update_xml': [
46+ 'init': [],
47+ 'data': [
48 'import_odbc_view.xml',
49 'security/ir.model.access.csv',
50 ],
51- 'demo_xml': [],
52+ 'demo': [],
53 'test': [],
54 'installable': True,
55 'active': False,
56
57=== modified file 'import_odbc/import_odbc.py' (properties changed: +x to -x)
58=== modified file 'import_odbc/import_odbc_view.xml' (properties changed: +x to -x)

Subscribers

People subscribed via source and target branches