Openerp Venezuela

Merge lp:~vauxoo/openerp-venezuela-localization/jose-init-company into lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk

  1. jose-init-company
  2. Merge into 6.0-trunk
Status: Rejected
Rejected by: Gabriela Quilarque
Proposed branch: lp:~vauxoo/openerp-venezuela-localization/jose-init-company
Merge into: lp:~openerp-venezuela/openerp-venezuela-localization/6.0-trunk
Diff against target: 742 lines (+688/-0)
11 files modified
account_account.csv (+256/-0)
account_partner.csv (+3/-0)
account_payment_term.csv (+3/-0)
account_payment_term_line.csv (+3/-0)
account_types.csv (+20/-0)
account_types_ids.csv (+20/-0)
geany_run_script.sh (+16/-0)
generacion_empresa.py (+328/-0)
res_partner.csv (+31/-0)
res_partner_address.csv (+1/-0)
res_partner_category.csv (+7/-0)
To merge this branch: bzr merge lp:~vauxoo/openerp-venezuela-localization/jose-init-company
Reviewer Review Type Date Requested Status
Nhomar - Vauxoo sin efecto Disapprove
hbto [Vauxoo] http://www.vauxoo.com Pending
Review via email: mp+80633@code.launchpad.net

Description of the change

Install modules automatically if they are in the list

To post a comment you must log in.
Revision history for this message
Nhomar - Vauxoo (nhomar) wrote :

Este merge proposal, no deberia ir a este branch.

Saludos.

review: Disapprove (sin efecto)

Unmerged revisions

6. By openerp <openerp@jose-desktop>

[ADD] Added chage for install module in a list

5. By josemorales

[FIX] Change in the model

4. By hbto [Vauxoo] http://www.vauxoo.com

MODIFICACION DEL SCRIPT AGREGANDO PARTNERS
PAYMENT TERMS, ETC.

3. By Juan Jose Pimentel <juan@VMGTECNOLOGIA>

[ADD] Agregamos el script para la creacion de las cuentas contable

2. By Juan Jose Pimentel <juan@VMGTECNOLOGIA>

[ADD] Agregamos el patron de cuentas al script
[MOD] Renombramos el script de importar_account_types.py generacion_empresa.py

1. By Juan Jose Pimentel <juan@VMGTECNOLOGIA>

[ADD] Primera iteracion del script de creacion de empresa
[ADD] Creacion de Tipos de cuenta y la generacion de un
      archivo con los resultados

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'account_account.csv'
2--- account_account.csv 1970-01-01 00:00:00 +0000
3+++ account_account.csv 2011-10-27 22:56:23 +0000
4@@ -0,0 +1,256 @@
5+"user_type","type","code","name"
6+"Vista","view","0","Compania"
7+"Vista","view","1","ACTIVO"
8+"Vista","view","101","Activo circulante"
9+"Financiera","view","101001","Disponible"
10+"Financiera","view","1010010001","Efectivo"
11+"Financiera","liquidity","1010010001000000001","Caja Chica "
12+"Vista","view","1010010002","Bancos Moneda Nacional"
13+"Bancos","liquidity","1010010002000000001","Banco de Venezuela"
14+"Bancos","liquidity","1010010002000000002","Banco Provincial"
15+"Bancos","liquidity","1010010002000000003","Banco Banesco"
16+"Bancos","liquidity","1010010002000000004","Banco Fondo Comun"
17+"Bancos","liquidity","1010010002000000005","Banco Mercantil"
18+"Bancos","liquidity","1010010002000000006","Banco Nacional de Credito "
19+"Vista","view","1010010003","Bancos Moneda Extranjera"
20+"Bancos","liquidity","1010010003000000001","Banco 1"
21+"Vista","view","101002","Exigible"
22+"Vista","view","1010020001","Efectos por Cobrar"
23+"Vista","view","1010020002","Cuentas por Cobrar Comerciales Exterior"
24+"Vista","view","1010020003","Cuentas por Cobrar Comerciales Nacionales"
25+"Cuentas por Cobrar","receivable","1010020003000000999","Cuentas por Cobrar Comerciales Nacionales Generica"
26+"Vista","view","1010020004","Cuentas por Cobrar Vinculadas"
27+"Vista","view","1010020005","Inversiones"
28+"Cuentas por Cobrar","other","1010020005000000001","Certificados y Depositos a Plazo"
29+"Cuentas por Cobrar","other","1010020005000000002","Bonos "
30+"Cuentas por Cobrar","other","1010020005000000003","Titulos"
31+"Cuentas por Cobrar","other","1010020005000000004","Papeles Comerciales"
32+"Vista","view","1010020006","Cuentas por cobrar org. oficiales"
33+"Cuentas por Cobrar Organismos Oficiales","other","1010020006000000001","Retenciones IVA"
34+"Cuentas por Cobrar Organismos Oficiales","other","1010020006000000002","Credito Fiscal (compras)"
35+"Impuestos Anticipados","other","1010020006000000003","ISLR pagado por anticipado"
36+"Impuestos Anticipados","other","1010020006000000004","Patente Industria y Comercio anticipado"
37+"Vista","view","1010020007","Provisiones Incobrables"
38+"Cuentas por Cobrar","other","1010020007000000001","Provision cuentas incobrables"
39+"Vista","view","1010020008","Anticipos "
40+"Cuentas por Cobrar","other","1010020008000000001","Anticipos a Proveedores"
41+"Vista","view","1010020009","Cuentas por Cobrar a Directores"
42+"Vista","view","1010020010","Cuentas por Cobrar a Empleados"
43+"Vista","view","1010020011","Cuentas por Cobrar Deudores Varios"
44+"Vista","view","101003","Realizable"
45+"Inventario","view","1010030001","Inventario"
46+"Vista","view","102","Activos Fijos"
47+"Vista","view","102001","Equipos de oficina"
48+"Vista","view","1020010001","Muebles y enseres"
49+"Mobiliario y Equipos","other","1020010001000000001","Muebles y enseres"
50+"Mobiliario y Equipos","view","1020010002","Equipos"
51+"Mobiliario y Equipos","other","1020010002000000001","Equipos"
52+"Vista","view","102002","Flota y equipos de transporte"
53+"Vista","view","1020020001","Vehiculos"
54+"Vista","other","1020020001000000001","Vehiculos"
55+"Vista","view","102100","Mejoras a las Instalaciones"
56+"Vista","view","1021000001","Mejoras a las Instalaciones"
57+"Mobiliario y Equipos","other","1021000001000000001","Mejoras Oficina y galpon"
58+"Vista","view","102890","Depreciaciones "
59+"Mobiliario y Equipos","view","1028900001","Depreciaciones "
60+"Mobiliario y Equipos","other","1028900001000000001","Depreciacion acumulada equipos de Oficina"
61+"Mobiliario y Equipos","other","1028900001000000002","Depreciacion acumulada vehiculos"
62+"Mobiliario y Equipos","other","1028900001000000003","Depreciacion acumulada mejora oficinas"
63+"Mobiliario y Equipos","other","1028900001000000004","Activos intangibles"
64+"Vista","view","103","Activos Intangibles"
65+"Vista","view","103001","Activos Intangibles"
66+"Vista","view","1030010001","Activos Intangibles"
67+"Vista","other","1030010001000000001","Activos Intangibles"
68+"Vista","view","104","Cargos Diferidos"
69+"Vista","view","104001","Cargos Diferidos"
70+"Vista","view","1040010001","Cargos Diferidos"
71+"Vista","other","1040010001000000001","Cargos Diferidos"
72+"Vista","view","105","Otros Activos"
73+"Vista","view","105001","Otros Activos"
74+"Vista","view","1050010001","Otros Activos"
75+"Vista","other","1050010001000000001","Otros Activos"
76+"Vista","view","110","Inversiones a Largo Plazo"
77+"Vista","view","110001","Inversiones a Largo Plazo"
78+"Vista","view","1100010001","Inversiones a Largo Plazo"
79+"Vista","other","1100010001000000001","Inversiones a Largo Plazo"
80+"Vista","view","2","PASIVO"
81+"Vista","view","201","Pasivo Circulante"
82+"Vista","view","201001","Obligaciones Financieras"
83+"Vista","view","2010010001","Bancos Nacionales"
84+"Cuentas por Pagar","other","2010010001000000001","Pagares"
85+"Cuentas por Pagar","other","2010010001000000002","Sobregiros bancarios"
86+"Cuentas por Pagar","other","2010010001000000003","Cartas de Credito"
87+"Vista","view","2010010002","Otras Entidades Financieras"
88+"Vista","view","2010010003","Bancos del Exterior"
89+"Cuentas por Pagar","other","2010010003000000001","Pagares"
90+"Cuentas por Pagar","other","2010010003000000002","Sobregiros bancarios"
91+"Cuentas por Pagar","other","2010010003000000003","Cartas de Credito"
92+"Vista","view","201002","Efectos y Cuentas por Pagar"
93+"Vista","view","2010020001","Documentos y Efectos por pagar"
94+"Vista","view","2010020002","Cuentas por pagar Vinculadas"
95+"Vista","view","2010020003","Cuentas por Pagar Comerciales CADIVI"
96+"Vista","view","2010020004","Cuentas por Pagar Comerciales Nacionales"
97+"Cuentas por Pagar","payable","2010020004000000999","Cuentas por Pagar Comerciales Nacionales Generica"
98+"Vista","view","2010020005","Anticipos de clientes"
99+"Vista","view","2010020006","Servicios Aduaneros"
100+"Vista","view","2010020007","Cuentas por Pagar Organismos Oficiales"
101+"Cuentas por Pagar Organismos Oficiales","other","2010020007000000001","Debito fiscal (IVA) ventas"
102+"Cuentas por Pagar Organismos Oficiales","other","2010020007000000002","ISLR Retenidos a Terceros por enterar"
103+"Cuentas por Pagar Organismos Oficiales","other","2010020007000000003","IVA Retenido a Terceros por Enterar"
104+"Cuentas por Pagar Organismos Oficiales","other","2010020007000000004","Impuestos Municipales Por Pagar"
105+"Vista","view","2010020008","Aportes Patronales y Retenciones Laborales por Enterar"
106+"Cuentas por Pagar","other","2010020008000000001","Retenciones Banavih"
107+"Cuentas por Pagar","other","2010020008000000002","Retenciones Inces"
108+"Cuentas por Pagar","other","2010020008000000003","Retenciones IVSS-Paro forzoso"
109+"Vista","view","2010020009","Cuentas por Pagar a Directores"
110+"Vista","view","2010020010","Obligaciones Laborales por pagar"
111+"Cuentas por Pagar Empleados","other","2010020010000000001","Sueldos , salarios y pagos Laborales"
112+"Cuentas por Pagar Empleados","other","2010020010000000002","Prestaciones sociales"
113+"Cuentas por Pagar Empleados","other","2010020010000000003","Intereses sobre prestaciones sociales"
114+"Cuentas por Pagar Empleados","other","2010020010000000004","Vacaciones"
115+"Cuentas por Pagar Empleados","other","2010020010000000005","Bono vacacional"
116+"Cuentas por Pagar Empleados","other","2010020010000000006","Bonificaciones"
117+"Cuentas por Pagar Empleados","other","2010020010000000007","Horas Extras"
118+"Cuentas por Pagar Empleados","other","2010020010000000008","Indemnizaciones laborales"
119+"Cuentas por Pagar Empleados","other","2010020010000000009","Otras Prestaciones"
120+"Cuentas por Pagar Empleados","other","2010020010000000010","Tickets Alimentacion"
121+"Cuentas por Pagar Empleados","other","2010020010000000011","Utilidades"
122+"Vista","view","2010020011","Otras Cuentas por pagar"
123+"Vista","view","202","Pasivo No Circulante"
124+"Vista","view","202001","Obligaciones Financieras Largo Plazo"
125+"Vista","view","2020010001","Bancos Nacionales"
126+"Cuentas por Pagar","other","2020010001000000001","Pagares"
127+"Cuentas por Pagar","other","2020010001000000002","Sobregiros bancarios"
128+"Cuentas por Pagar","other","2020010001000000003","Cartas de Credito"
129+"Vista","view","2020010002","Otras Entidades Financieras"
130+"Vista","view","2020010003","Bancos del Exterior"
131+"Cuentas por Pagar","other","2020010003000000001","Pagares"
132+"Cuentas por Pagar","other","2020010003000000002","Sobregiros bancarios"
133+"Cuentas por Pagar","other","2020010003000000003","Cartas de Credito"
134+"Vista","view","2020010004","Otras Cuentas por pagar"
135+"Cuentas por Pagar","other","2020010004000000001","Cuentas por pagar largo plazo"
136+"Vista","view","2020010005","Otros Pasivos"
137+"Cuentas por Pagar","other","2020010005000000001","Depositos recibidos en garantia"
138+"Cuentas por Pagar","other","2020010005000000002","Anticipos y avances recibidos"
139+"Cuentas por Pagar","other","2020010005000000003","Ingresos recibidos de terceros"
140+"Cuentas por Pagar","other","2020010005000000004","Bonos y papeles comerciales"
141+"Vista","view","3","PATRIMONIO"
142+"Vista","view","301","Capital Social"
143+"Vista","view","301001","CAPITAL SOCIAL"
144+"Vista","view","3010010001","Capital Social"
145+"Capital Social","other","3010010001000000001","Capital Suscrito y Pagado"
146+"Capital Social","other","3010010001000000002","Capital por Suscribir"
147+"Capital Social","other","3010010001000000003","Capital Suscrito por Cobrar"
148+"Vista","view","3010010002","Reservas "
149+"Capital Social","other","3010010002000000001","Reserva legal"
150+"Capital Social","other","3010010002000000002","Reserva prestaciones sociales"
151+"Vista","view","3010010003","Otras reservas"
152+"Vista","view","3010010004","Superavit"
153+"Capital Social","other","3010010004000000001","Superavit acumulado"
154+"Capital Social","other","3010010004000000002","Utilidad Perdida del ejercicio "
155+"Vista","view","4","INGRESOS "
156+"Vista","view","401","INGRESOS NETOS"
157+"Vista","view","401001","Ingresos Operacionales"
158+"Vista","view","4010010001","Ventas"
159+"Ingresos","other","4010010001000000001","Ingresos Por Venta de Materiales"
160+"Ingresos","other","4010010001000000002","Ingresos Por Venta de Servicios"
161+"Ingresos","other","4010010001000000003","Ingresos Por Venta de Proyectos"
162+"Ingresos","other","4010010001000000004","Ingresos Por Ventas de Equipos Medicos"
163+"Ingresos","other","4010010001000000005","Descuentos en ventas"
164+"Ingresos","other","4010010001000000006","Devoluciones en ventas"
165+"Vista","view","401002","Ingresos No Operacionales"
166+"Vista","view","4010020001","Otros Ingresos"
167+"Vista","view","5","COSTO DE VENTA"
168+"Vista","view","501","Costo de Venta"
169+"Vista","view","501001","Inventario "
170+"Vista","view","5010010001","Inventario Inicial"
171+"Costos de Venta","other","5010010001000000001","Inventario Inicial materiales"
172+"Costos de Venta","other","5010010001000000002","Inventario Inicial Equipos Medicos"
173+"Costos de Venta","view","501002","Compras"
174+"Costos de Venta","view","5010020001","Compras"
175+"Costos de Venta","other","5010020001000000001","Compras Nacionales"
176+"Costos de Venta","other","5010020001000000002","Compras Importacion"
177+"Costos de Venta","other","5010020001000000003","Fletes En Compra"
178+"Vista","view","501003","Descuentos y Devoluciones en Compras"
179+"Vista","view","5010030001","Descuentos y Devoluciones en Compras"
180+"Costos de Venta","other","5010030001000000001","Descuentos En Compra"
181+"Costos de Venta","other","5010030001000000002","Devoluciones En Compra"
182+"Vista","view","501004","Otros Costos"
183+"Vista","view","5010040001","Otros Costos"
184+"Costos de Venta","other","5010040001000000001","Otros Costos"
185+"Costos de Venta","other","5010040001000000002","Alquiler Galpon"
186+"Costos de Venta","other","5010040001000000003","Gastos Galpon"
187+"Costos de Venta","other","5010040001000000004","Alquileres Varios, Montacargas"
188+"Vista","view","501005","Inventario Final"
189+"Vista","view","5010050001","Inventario Final"
190+"Costos de Venta","other","5010050001000000001","Inventario Final Nacional"
191+"Costos de Venta","other","5010050001000000002","Inventario Final Importacion"
192+"Vista","view","6","GASTOS OPERATIVOS"
193+"Vista","view","601","GASTOS OPERATIVOS"
194+"Vista","view","601001","Gastos de Venta"
195+"Vista","view","6010010001","Gastos de Venta"
196+"Vista","view","601002","Gastos de Administracion"
197+"Vista","view","6010020001","Gastos de Personal"
198+"Gastos","other","6010020001000000001","Sueldos y Salarios empleados"
199+"Gastos","other","6010020001000000002","Sueldos y Salarops directores"
200+"Gastos","other","6010020001000000003","Sueldos y Salarios extras"
201+"Gastos","other","6010020001000000015","Bonificaciones"
202+"Gastos","other","6010020001000000016","Bono Alimentacion"
203+"Gastos","other","6010020001000000017","Horas Extras"
204+"Gastos","other","6010020001000000018","Utilidades"
205+"Gastos","other","6010020001000000019","Vacaciones"
206+"Gastos","other","6010020001000000020","Bono Vacacional"
207+"Gastos","other","6010020001000000021","Incentivos al Personal"
208+"Gastos","other","6010020001000000100","Pre-aviso"
209+"Gastos","other","6010020001000000101","Prestaciones Sociales"
210+"Gastos","other","6010020001000000102","Intereses Sobre Prestaciones Sociales"
211+"Gastos","other","6010020001000000103","Indemnizaciones Laborales"
212+"Gastos","other","6010020001000000200","Capacitacion y Adiestramineto"
213+"Gastos","other","6010020001000000201","Gastos de Seleccion y reclutamiento"
214+"Gastos","other","6010020001000000202","Gastos Medicos y Medicinas"
215+"Gastos","other","6010020001000000203","Polizas de Seguro para el Personal"
216+"Gastos","other","6010020001000000500","IVSS "
217+"Gastos","other","6010020001000000501","LPH"
218+"Gastos","other","6010020001000000502","INCES"
219+"Vista","view","6010020002","Oficina"
220+"Gastos","other","6010020002000000001","Electricidad y Aseo"
221+"Gastos","other","6010020002000000002","Telefonos"
222+"Gastos","other","6010020002000000003","Agua Potable"
223+"Gastos","other","6010020002000000004","Servicio Agua Hidrocapital"
224+"Gastos","other","6010020002000000005","Alquiler Oficina"
225+"Gastos","other","6010020002000000006","Limpieza Oficina"
226+"Gastos","other","6010020002000000007","Articulos de Limpieza"
227+"Gastos","other","6010020002000000008","Articulos de Oficina"
228+"Gastos","other","6010020002000000009","Servicio de Estacionamiento"
229+"Gastos","other","6010020002000000010","Servicio de Fumigacion"
230+"Gastos","other","6010020002000000011","Articulos Consumo Para el Comedor"
231+"Gastos","other","6010020002000000012","Diligencias y Mensajerias"
232+"Gastos","other","6010020002000000013","Gastos varios"
233+"Gastos","other","6010020002000000014","Honorarios Profesionales"
234+"Gastos","other","6010020002000000015","Servicio De Transporte"
235+"Gastos","other","6010020002000000016","Servicios de Contadores y Auditores"
236+"Gastos","other","6010020002000000017","Servicios De Recursos Humanos"
237+"Gastos","other","6010020002000000018","Mejoramiento Profesional y Tecnico"
238+"Gastos","other","6010020002000000019","Publicidad y Propaganda"
239+"Vista","view","6010020003","Reparaciones y Remodelaciones"
240+"Gastos","other","6010020003000000001","Reparacion y mantenimiento de equipos de oficina"
241+"Gastos","other","6010020003000000002","Reparacion y mantenimiento de vehiculos"
242+"Gastos","other","6010020003000000003","Reparacion remodelacion y mantenimiento inmueble"
243+"Vista","view","6010020004","Seguridad Industrial e Higiene Ambiental"
244+"Gastos","other","6010020004000000001","Gastos de Implementacion"
245+"Gastos","other","6010020004000000002","Gastos en Equipos y Materiales"
246+"Vista","view","6010020005","Otros Gastos de Administracion"
247+"Gastos","other","6010020005000000001","Polizas y Primas de Seguro "
248+"Gastos","other","6010020005000000002","Diferencia mas o menos"
249+"Gastos","other","6010020005000000003","Gastos Bancarios"
250+"Gastos","other","6010020005000000004","Gastos Administrativos y cheques devueltos"
251+"Gastos","other","6010020005000000005","Tasas y Contribuciones"
252+"Gastos","other","6010020005000000006","Donaciones"
253+"Vista","view","6010020006","Provisiones"
254+"Gastos","other","6010020006000000001","Provision Cuentas incobrables"
255+"Gastos","other","6010020006000000002","Provision por Obsolecencia"
256+"Vista","view","602","Gastos No Deducibles"
257+"Vista","view","602003","Gastos No Deducibles"
258+"Vista","view","6020030001","Gastos No Deducibles"
259+"Gastos","other","6020030001000000001","Gastos No Deducibles"
260+"Gastos","other","6020030001000000002","Multas"
261
262=== added file 'account_partner.csv'
263--- account_partner.csv 1970-01-01 00:00:00 +0000
264+++ account_partner.csv 2011-10-27 22:56:23 +0000
265@@ -0,0 +1,3 @@
266+name,type,user_type,property_account_partner,property_account_partner_default
267+Cuentas x Cobrar Nacionales,receivable,Cuentas por Cobrar,"1010020003","1010020003000000999"
268+Cuentas x Pagar Nacionales,payable,Cuentas por Pagar,"2010020004","2010020004000000999"
269
270=== added file 'account_payment_term.csv'
271--- account_payment_term.csv 1970-01-01 00:00:00 +0000
272+++ account_payment_term.csv 2011-10-27 22:56:23 +0000
273@@ -0,0 +1,3 @@
274+name,description
275+CONTADO,Pagos al Contado, Sin Crédito
276+CREDITO 30 DIAS,Crédito a 30 días a partir de la Fecha
277
278=== added file 'account_payment_term_line.csv'
279--- account_payment_term_line.csv 1970-01-01 00:00:00 +0000
280+++ account_payment_term_line.csv 2011-10-27 22:56:23 +0000
281@@ -0,0 +1,3 @@
282+payment_id,name,sequence,value,days,days2
283+CONTADO,CONTADO,5,balance,0,0
284+CREDITO 30 DIAS,CREDITO 30 DIAS,5,balance,30,0
285
286=== added file 'account_types.csv'
287--- account_types.csv 1970-01-01 00:00:00 +0000
288+++ account_types.csv 2011-10-27 22:56:23 +0000
289@@ -0,0 +1,20 @@
290+report_type,code,close_method,name
291+asset,Bancos,balance,Bancos
292+liability,Capital Social,balance,Capital Social
293+asset,Cargos Diferidos,balance,Cargos Diferidos
294+expense,Costos de Venta,none,Costos de Venta
295+asset,Cuentas por Cobrar,unreconciled,Cuentas por Cobrar
296+asset,Cuentas por Cobrar Organismos Of,unreconciled,Cuentas por Cobrar Organismos Oficiales
297+liability,Cuentas por Pagar,unreconciled,Cuentas por Pagar
298+liability,Cuentas por Pagar Empleados,unreconciled,Cuentas por Pagar Empleados
299+liability,Cuentas por Pagar Organismos Ofi,unreconciled,Cuentas por Pagar Organismos Oficiales
300+asset,Financiera,balance,Financiera
301+expense,Gastos,none,Gastos
302+asset,Impuestos Anticipados,unreconciled,Impuestos Anticipados
303+income,Ingresos,none,Ingresos
304+liability,Inventario,balance,Inventario
305+asset,Mobiliario y Equipos,balance,Mobiliario y Equipos
306+expense,Otros Egresos,none,Otros Egresos
307+expense,Otros Ingresos,none,Otros Ingresos
308+liability,Prestamos,unreconciled,Prestamos
309+liability,Vista,none,Vista
310
311=== added file 'account_types_ids.csv'
312--- account_types_ids.csv 1970-01-01 00:00:00 +0000
313+++ account_types_ids.csv 2011-10-27 22:56:23 +0000
314@@ -0,0 +1,20 @@
315+report_type,code,close_method,name,id
316+balance,Bancos,Bancos,asset,45,
317+balance,Capital Social,Capital Social,liability,46,
318+balance,Cargos Diferidos,Cargos Diferidos,asset,47,
319+none,Costos de Venta,Costos de Venta,expense,48,
320+unreconciled,Cuentas por Cobrar,Cuentas por Cobrar,asset,49,
321+unreconciled,Cuentas por Cobrar Organismos Of,Cuentas por Cobrar Organismos Oficiales,asset,50,
322+unreconciled,Cuentas por Pagar,Cuentas por Pagar,liability,51,
323+unreconciled,Cuentas por Pagar Empleados,Cuentas por Pagar Empleados,liability,52,
324+unreconciled,Cuentas por Pagar Organismos Ofi,Cuentas por Pagar Organismos Oficiales,liability,53,
325+balance,Financiera,Financiera,asset,54,
326+none,Gastos,Gastos,expense,55,
327+unreconciled,Impuestos Anticipados,Impuestos Anticipados,asset,56,
328+none,Ingresos,Ingresos,income,57,
329+balance,Inventario,Inventario,liability,58,
330+balance,Mobiliario y Equipos,Mobiliario y Equipos,asset,59,
331+none,Otros Egresos,Otros Egresos,expense,60,
332+none,Otros Ingresos,Otros Ingresos,expense,61,
333+unreconciled,Prestamos,Prestamos,liability,62,
334+none,Vista,Vista,liability,63,
335
336=== added file 'geany_run_script.sh'
337--- geany_run_script.sh 1970-01-01 00:00:00 +0000
338+++ geany_run_script.sh 2011-10-27 22:56:23 +0000
339@@ -0,0 +1,16 @@
340+#!/bin/sh
341+
342+rm $0
343+
344+python "generacion_empresa.py"
345+
346+echo "
347+
348+------------------
349+(program exited with code: $?)"
350+
351+
352+echo "Press return to continue"
353+#to be more compatible with shells like dash
354+dummy_var=""
355+read dummy_var
356
357=== added file 'generacion_empresa.py'
358--- generacion_empresa.py 1970-01-01 00:00:00 +0000
359+++ generacion_empresa.py 2011-10-27 22:56:23 +0000
360@@ -0,0 +1,328 @@
361+# -*- encoding: utf-8 -*-
362+##############################################################################
363+#
364+# OpenERP, Open Source Management Solution
365+# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
366+# d$
367+#
368+# This program is free software: you can redistribute it and/or modify
369+# it under the terms of the GNU General Public License as published by
370+# the Free Software Foundation, either version 3 of the License, or
371+# (at your option) any later version.
372+#
373+# This program is distributed in the hope that it will be useful,
374+# but WITHOUT ANY WARRANTY, without even the implied warranty of
375+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
376+# GNU General Public License for more details.
377+#
378+# You should have received a copy of the GNU General Public License
379+# along with this program. If not, see <http://www.gnu.org/licenses/>.
380+#
381+##############################################################################
382+
383+
384+import xmlrpclib
385+import socket
386+import ConfigParser
387+import optparse
388+import sys
389+import thread
390+import threading
391+import os
392+import time
393+import pickle
394+import base64
395+import socket
396+
397+
398+ACCOUNT_PARTNER_FILE = 'account_partner.csv'
399+HOST='localhost'
400+PORT=8069
401+DB='module_inst'
402+USER='admin'
403+PASS='karate'
404+url ='http://%s:%d/xmlrpc/' % (HOST,PORT)
405+common_proxy = xmlrpclib.ServerProxy(url+'common')
406+object_proxy = xmlrpclib.ServerProxy(url+'object')
407+wizard_proxy = xmlrpclib.ServerProxy(url+'wizard')
408+#### MODULE LIST TO BE INSTALLED
409+MODULE_LIST = ['account_coda','l10n_ve_fiscal_requirements','base_iban','account_management','account_sequence']
410+
411+
412+#### CSV FILE TO IMPORT
413+INPUT_FILE = 'account_types.csv'
414+OUTPUT_FILE = 'account_types_ids.csv'
415+ACCOUNT_FILE = 'account_account.csv'
416+RES_PARTNER_CATEGORY_FILE = 'res_partner_category.csv'
417+ACCOUNT_PAYMENT_TERMS_FILE = 'account_payment_term.csv'
418+ACCOUNT_PAYMENT_TERM_LINES_FILE = 'account_payment_term_line.csv'
419+RES_PARTNER_FILE = 'res_partner.csv'
420+
421+#### VARIABLES
422+PATTERN = '1,123,123456,1234567890,1234567890123456789'
423+
424+
425+#### LOGIN IN
426+uid = common_proxy.login(DB,USER,PASS)
427+
428+
429+
430+### DEF INSTALL MODULES
431+#def execute(connector, method, *args):
432+ # global wait_count
433+ # res = False
434+ # try:
435+ # res = getattr(connector,method)(*args)
436+ # except socket.error,e:
437+ # if e.args[0] == 111:
438+ # if wait_count > wait_limit:
439+ # print "Server is taking too long to start, it has exceeded the maximum limit of %d seconds."%(wait_limit)
440+ # clean()
441+ # sys.exit(1)
442+ # print 'Please wait %d sec to start server....'%(waittime)
443+ # wait_count += 1
444+ # time.sleep(waittime)
445+ # res = execute(connector, method, *args)
446+# else: raise e
447+ # wait_count = 0
448+ # return True
449+ # return res
450+
451+
452+
453+
454+
455+
456+
457+
458+
459+
460+
461+### INSTALL MODULES
462+from time import sleep
463+for mod in MODULE_LIST:
464+ values = [
465+ ('name','=',mod)
466+ ]
467+
468+
469+ mod_id = object_proxy.execute(DB,uid,PASS,'ir.module.module','search',values)
470+ print mod_id
471+ if mod_id:
472+
473+ status_mod = object_proxy.execute(DB,uid,PASS,'ir.module.module','read',mod_id[0],["state","name","dependencies_id"])
474+ print status_mod
475+ desesperacion = object_proxy.execute(DB, uid, PASS,'ir.module.module','button_install', mod_id)
476+ print "desesperacion", desesperacion
477+ desesperacion2 = object_proxy.execute(DB,uid,PASS, 'base.module.upgrade', 'upgrade_module', mod_id)
478+
479+
480+
481+ # if status_mod["state"] == "installed":
482+ # print "El modulo %s ya esta instalado" % status_mod["name"]
483+
484+ # else:
485+ # print "El modulo %s se instalara" % status_mod["name"]
486+ # print status_mod["dependencies_id"]
487+ # dep_id = status_mod["dependencies_id"]
488+ # print "aquiiii", dep_id
489+ # dep_mod = object_proxy.execute(DB,uid,PASS,'ir.module.module','read',dep_id[0],["name"])
490+ # if dep_mod:
491+ # print "Necesitas instalar el modulo %s " % dep_mod["name"]
492+ # nombre = dep_mod["name"]
493+ # MODULE_LIST.append(nombre)
494+ # print "listaaaaa", MODULE_LIST
495+ # else:
496+ # print "El modulo no tiene dependencia"
497+ #
498+ ##if status_mod["state"] == "unknown":
499+
500+ # record_id = object_proxy.execute(DB,uid,PASS,'ir.module.module','write',mod_id,{'state':'to install'})
501+
502+ #### Probando el codigo de openERP
503+
504+
505+
506+
507+
508+
509+
510+
511+
512+
513+
514+
515+
516+
517+for Line in Archive:
518+ values = {
519+ 'report_type': Line['report_type'],
520+ 'code': Line['code'],
521+ 'close_method': Line['close_method'],
522+ 'name': Line['name'],
523+ }
524+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
525+ record_id = object_proxy.execute(DB,uid,PASS,'account.account.type','create',values)
526+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'account.account.type','read',[record_id],['code','name'])
527+ for val in values:
528+ linea += str(values[val]) +','
529+ linea += '%s,\n'%record_id
530+
531+ #~ Acumulating id's for forward use
532+ user_type_dict[values['name']]= record_id
533+
534+
535+
536+
537+
538+
539+#### CREATING USER TYPES
540+import csv
541+Archive = csv.DictReader(open(INPUT_FILE))
542+values = {}
543+output_file = open(OUTPUT_FILE,"w")
544+
545+linea = 'report_type,code,close_method,name,id\n'
546+
547+user_type_dict = {}
548+
549+for Line in Archive:
550+ values = {
551+ 'report_type': Line['report_type'],
552+ 'code': Line['code'],
553+ 'close_method': Line['close_method'],
554+ 'name': Line['name'],
555+ }
556+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
557+ record_id = object_proxy.execute(DB,uid,PASS,'account.account.type','create',values)
558+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'account.account.type','read',[record_id],['code','name'])
559+ for val in values:
560+ linea += str(values[val]) +','
561+ linea += '%s,\n'%record_id
562+
563+ #~ Acumulating id's for forward use
564+ user_type_dict[values['name']]= record_id
565+
566+output_file.write(linea)
567+output_file.close()
568+
569+
570+#### WRITTING ACCOUNT PATTERN INTO COMPANY
571+values = {
572+'pattern': PATTERN
573+}
574+object_proxy.execute(DB,uid,PASS,'res.company','write',[1],values)
575+
576+
577+#### CREATING ACCOUNTING ACCOUNTS
578+Archive = csv.DictReader(open(ACCOUNT_FILE))
579+values = {}
580+
581+account_dict = {}
582+for Line in Archive:
583+ values = {
584+ 'auto' : False,
585+ 'company_id': 1,
586+ 'code': Line['code'],
587+ 'name': Line['name'],
588+ 'type': Line['type'],
589+ 'user_type': user_type_dict[Line['user_type']]
590+ }
591+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
592+ record_id = object_proxy.execute(DB,uid,PASS,'account.account','create',values)
593+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'account.account','read',[record_id],['code'])
594+ #~ CREATING A DICTIONARY WITH ACCOUNTING CODES AS KEYS
595+ #~ AND ACCOUNT ID'S AS VALUES
596+ account_dict.update({Line['code']:record_id})
597+
598+
599+#### CREATING ACCOUNTING PARTNER CLASSIFICATION
600+Archive = csv.DictReader(open(ACCOUNT_PARTNER_FILE))
601+values = {}
602+account_partner_dict = {}
603+for Line in Archive:
604+ values = {
605+ 'company_id': 1,
606+ 'name': Line['name'],
607+ 'type': Line['type'],
608+ 'user_type': user_type_dict[Line['user_type']],
609+ 'property_account_partner': account_dict[Line['property_account_partner']],
610+ 'property_account_partner_default': account_dict[Line['property_account_partner_default']],
611+ }
612+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
613+ record_id = object_proxy.execute(DB,uid,PASS,'res.partner.account','create',values)
614+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'res.partner.account','read',[record_id],['name'])
615+ account_partner_dict.update({Line['name']:record_id})
616+
617+
618+#### CREATING PARTNER CATEGORIES
619+Archive = csv.DictReader(open(RES_PARTNER_CATEGORY_FILE))
620+values = {}
621+res_partner_cat_dict= {}
622+for Line in Archive:
623+ values = {
624+ 'name': Line['name'],
625+ 'parent_id': Line['parent_id'] and res_partner_cat_dict.get(Line['parent_id'],False) or False
626+ }
627+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
628+ record_id = object_proxy.execute(DB,uid,PASS,'res.partner.category','create',values)
629+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'res.partner.account','read',[record_id],['name'])
630+
631+ res_partner_cat_dict.update({Line['name']:record_id})
632+
633+#### CREATING ACCOUNT PAYMENT TERMS
634+Archive = csv.DictReader(open(ACCOUNT_PAYMENT_TERMS_FILE))
635+values = {}
636+acc_pay_term_dict= {}
637+for Line in Archive:
638+ values = {
639+ 'name': Line['name'],
640+ 'description': Line['description'] and Line['description'] or ''
641+ }
642+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
643+ record_id = object_proxy.execute(DB,uid,PASS,'account.payment.term','create',values)
644+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'res.partner.account','read',[record_id],['name'])
645+
646+ acc_pay_term_dict.update({Line['name']:record_id})
647+
648+
649+#### CREATING ACCOUNT PAYMENT TERMS
650+Archive = csv.DictReader(open(ACCOUNT_PAYMENT_TERM_LINES_FILE))
651+values = {}
652+for Line in Archive:
653+ values = {
654+ 'payment_id': acc_pay_term_dict[Line['payment_id']],
655+ 'name': Line['name'],
656+ 'sequence': Line['sequence'],
657+ 'value': Line['value'],
658+ 'days': int(Line['days']),
659+ 'days2': int(Line['days2']),
660+ }
661+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
662+ record_id = object_proxy.execute(DB,uid,PASS,'account.payment.term.line','create',values)
663+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'res.partner.account','read',[record_id],['name'])
664+
665+#### CREATING RES PARTNER
666+Archive = csv.DictReader(open(RES_PARTNER_FILE))
667+values = {}
668+res_partner_dict = {}
669+for Line in Archive:
670+ values = {
671+ 'name': Line['name'],
672+ 'customer': bool(Line['customer']),
673+ 'supplier': bool(Line['supplier']),
674+ 'supplier': bool(Line['supplier']),
675+ 'category_id': [(6, 0, [res_partner_cat_dict[j] \
676+ for j in [i.strip() \
677+ for i in Line['category_id'].split(':')]])],
678+ 'account_kind_pay':account_partner_dict[Line['account_kind_pay']],
679+ 'account_kind_rec':account_partner_dict[Line['account_kind_rec']],
680+ 'property_payment_term': acc_pay_term_dict[Line['property_payment_term']]
681+
682+ }
683+ #~ record_id = object_proxy.execute(DB,uid,PASS,'model.model','create',{'keys':'values'})
684+ record_id = object_proxy.execute(DB,uid,PASS,'res.partner','create',values)
685+ print "se ha creado %s " % object_proxy.execute(DB,uid,PASS,'res.partner.account','read',[record_id],['name'])
686+ res_partner_dict.update({Line['name']:record_id})
687+
688+
689
690=== added file 'res_partner.csv'
691--- res_partner.csv 1970-01-01 00:00:00 +0000
692+++ res_partner.csv 2011-10-27 22:56:23 +0000
693@@ -0,0 +1,31 @@
694+name,customer,supplier,addresses,category_id,user_id,website,account_kind_rec,account_kind_pay,property_payment_term
695+PARTNER1,0,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
696+PARTNER2,1,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
697+PARTNER3,0,1,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
698+PARTNER4,1,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
699+PARTNER5,1,1,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
700+PARTNER6,1,1,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
701+PARTNER7,1,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
702+PARTNER8,1,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
703+PARTNER9,0,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
704+PARTNER10,1,1,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
705+PARTNER11,0,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
706+PARTNER12,1,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
707+PARTNER13,0,0,,Clientes: Proveedores de Materia Prima,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
708+PARTNER14,0,0,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
709+PARTNER15,1,0,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CONTADO
710+PARTNER16,0,0,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
711+PARTNER17,0,1,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
712+PARTNER18,0,1,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
713+PARTNER19,1,0,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
714+PARTNER20,0,0,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
715+PARTNER21,0,1,,Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
716+PARTNER22,1,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
717+PARTNER23,1,0,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
718+PARTNER24,1,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
719+PARTNER25,1,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
720+PARTNER26,0,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
721+PARTNER27,0,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
722+PARTNER28,1,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
723+PARTNER29,1,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
724+PARTNER30,0,1,,Clientes:Clientes Minoristas:Proveedores:Proveedores de Materia Prima:Proveedores de Insumos,,,Cuentas x Cobrar Nacionales,Cuentas x Pagar Nacionales,CREDITO 30 DIAS
725
726=== added file 'res_partner_address.csv'
727--- res_partner_address.csv 1970-01-01 00:00:00 +0000
728+++ res_partner_address.csv 2011-10-27 22:56:23 +0000
729@@ -0,0 +1,1 @@
730+partner_id,name,type,phone,street,mobile,zip,city,state_id,country_id,email
731
732=== added file 'res_partner_category.csv'
733--- res_partner_category.csv 1970-01-01 00:00:00 +0000
734+++ res_partner_category.csv 2011-10-27 22:56:23 +0000
735@@ -0,0 +1,7 @@
736+name,parent_id
737+Clientes,
738+Clientes Minoristas,Clientes
739+Clientes Mayoristas,Clientes
740+Proveedores,
741+Proveedores de Materia Prima,Proveedores
742+Proveedores de Insumos,Proveedores