début avec openconcerto : questions

LTE · mer. janv. 30, 2013 4:56 am

Bonjour, je suis une restauratrice et mon mari et moi avons un out petit resaurant. Je m'occupe de la comptabilité et je suis autodidacte pour l'informatique et les logiciels compta.Je viens de démarrer avec openconcerto. J'étais sous OpenSI(linux) et après avoir touché à Dolibarr je me retourne vers Openconcerto avec un Windows Vista. L’installation monoposte c'est bien passée. La prise en main est assez simple. Cependant lors des mes premiers "test" je rencontre des problèmes:
1- je tente un EXPORT EXPERT après avoir saisi mes fournisseurs et quelques opérations d'achat et cela me donne un fichier csv vide.
2- lors d'une saisie au km, une ligne remplie m'en génère d'office 2 à 4 lignes suplémentaires que je dois éffacer si besoin. Est ce normal?
3- j' ai installé openconcerto sur un autre pc (windows 7) et je souhaite faire une sauvegarde de la base de donnée pour pouvoir l'uiliser sous l'autre PC comment fait on avec H2? y a t'il une interface comme mysql? j'ai essayé d'utiliser mysql que je connais mais le fichier sql fourni est trop volumineux pour l'import. Quelqu'un peut il m'aider?
Merci beaucoup de vos réponses.

ven. févr. 01, 2013 4:32 pm

Bonjour,

1/ Sans plus d'info, impossible à diagnostiquer.
2/ Bug de la 1.2, corrigé en 1.3 (encore en version beta)
3/ Vous pouvez juste copier/remplacer le fichiers de base de données H2

Cordialement,

LTE · ven. févr. 01, 2013 5:13 pm

Bonsoir merci de vos réponses. Que dois je vous fournir comme éléments pour vous aider à comprendre mon fichier vide?
Merci

LTE · sam. févr. 02, 2013 8:30 am

Bonjour,
Voici le log de ce matin après avoir tenté l'export des écritures:

Logger logs: C:\Users\LTE\Documents\OpenConcerto\logs\LTE-PC-LTE\OpenConcerto-%u-age%g.log
Mise à jour désactivées (fichier de configuration manquant)
Ip:file:C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\DBData/
févr. 02, 2013 9:23:40 AM org.openconcerto.sql.model.DBSystemRoot setRootPathFromDS
WARNING: db default schema is PUBLIC and the schemas of DBSystemRoot OpenConcerto are empty ; the first created schema will become the default one
Init phase 1:5516ms
Loading properties from C:\Program Files\OpenConcerto\.\Configuration\Email.properties
Warning: C:\Program Files\OpenConcerto\.\Configuration\Email.properties does not exist
Loading properties from C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\Configuration\OpenConcerto_User.properties
Init phase 2:780ms
Loading properties from C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\Configuration\Printer.properties
Warning: C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\Configuration\Printer.properties does not exist
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table DISCIPLINE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table POINTAGE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table AFFACTURAGE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table AFFAIRE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table AFFAIRE_ELEMENT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table ASSOCIATION_ANALYTIQUE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table AVIS_INTERVENTION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table BANQUE_POLE_PRODUIT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table CODE_FOURNISSEUR
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table CODE_MISSION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table ECHEANCIER_CCI
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table ECOTAXE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table FICHE_RENDEZ_VOUS
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table FICHE_RENDEZ_VOUS_ELEMENT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table NATURE_MISSION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table ORDRE_MISSION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table PERIODICITE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table POCHETTE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table POLE_PRODUIT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table POURCENT_SERVICE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table POURCENT_CCIP
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table PROPOSITION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table PROPOSITION_ELEMENT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table RAPPORT
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table SECRETAIRE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table SECTEUR_ACTIVITE
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.request.SQLFieldTranslator load
INFO: unknown table SITE_INTERVENTION
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.ShowAs show
WARNING: DBRoot SQLSchema OpenConcerto49 does not contain the table:ACTIVITE
org.openconcerto.sql.element.GlobalMapper
accounting.name : Comptabilité
address.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
autonumbering.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
civility.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
common.address.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
country.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.contact.list.table : CONTACT
customerrelationship.customer.chaseletter.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.customer.chaseletter.type.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.customer.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.customer.list.table : CLIENT
customerrelationship.customer.mail.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.customer.mailtemplate.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.customer.ref.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
customerrelationship.name : Relation client
department.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.account.kind.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.account.type.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.analytic.account.relation.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.analytic.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.analytic.set.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.book.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.code.enterprise.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.code.national.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.distribution.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.entry.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.entry.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.piece.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.userentry.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.accounting.userentry.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.cheque.due.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.cheque.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.cheque.supplier.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.mode.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.regulation.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.payment.type.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
finance.tax.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.employe.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.employe.info.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.employe.salesman.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.advance.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.base.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.comment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.raw.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.subscription.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.type.net.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.category.type.raw.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.contract.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.contract.employe.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.convention.category.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.convention.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.convention.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.convention.job.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.convention.status.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.conventions.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.employe.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.employe.variable.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.governement.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.info.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.job.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.payment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.payment.type.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.payment.variable.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.payslip.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.payslip.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.print.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.rights.code.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.template.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.template.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.total.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.vacation.total.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
humanresources.payroll.validity.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
language.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
month.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.common.component.SocieteCommonSQLElement-SOCIETE_COMMON.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.customerrelationship.customer.element.ContactSQLElement$ContactAdministratifSQLElement-CONTACT_ADMINISTRATIF.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.customerrelationship.customer.element.ContactSQLElement$ContactFournisseurSQLElement-CONTACT_FOURNISSEUR.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.customerrelationship.customer.element.ContactSQLElement-CONTACT.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.finance.accounting.element.ExerciceCommonSQLElement-EXERCICE_COMMON.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.humanresources.employe.SituationFamilialeSQLElement.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.humanresources.payroll.element.CaisseCotisationSQLElement-CAISSE_COTISATION.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.core.sales.price.element.DeviseSQLElement-DEVISE.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.generationDoc.element.ModeleSQLElement.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.erp.generationDoc.element.TypeModeleSQLElement-TYPE_MODELE.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.sql.element.SharedSQLElement-CLASSE_COMPTE.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.sql.element.SharedSQLElement-EMPLOYEUR_MULTIPLE.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.sql.users.UserCommonSQLElement-USER_COMMON.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.sql.users.rights.RightSQLElement-RIGHT.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.sql.users.rights.UserRightSQLElement-USER_RIGHT.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.task.element.TaskRightSQLElement-TACHE_RIGHTS.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
org.openconcerto.task.element.TaskSQLElement-TACHE_COMMON.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.credit.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.credit.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.invoice.commitment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.invoice.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.invoice.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.invoice.list.table : SAISIE_VENTE_FACTURE
sales.invoice.list.table.editor : class org.openconcerto.erp.core.sales.invoice.ui.SaisieVenteFactureItemTable
sales.invoice.name : Factures client
sales.name : Gestion commerciale
sales.order.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.order.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.pos.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.pos.sale.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.pos.ticket.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.price.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.family.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.name.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.price.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.quantity.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.ref.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.sale.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.product.unit.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.quote.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.quote.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.quote.list.table : DEVIS
sales.quote.name : Devis client
sales.quote.state.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.shipment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
sales.shipment.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
style.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.credit.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.order.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.order.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.order.purchase.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.receipt.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.receipt.item.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.stock.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.stock.transaction.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.supplier.commitment.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
supplychain.supplier.element : org.openconcerto.erp.config.ComptaPropsConfiguration@ab40bf
134 identifiers found
Loading properties from C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\Pref.properties
Loading properties from C:\Users\LTE\.java\ilm\sql-config\OpenConcerto\Configuration\Template.properties
Warning: no default directory stored for document output
Warning: no default directory stored for PFD output
org.openconcerto.erp.generationDoc.DocumentLocalStorageManager
Default document directory: 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49'
Default PFD directory : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49'
Document directories:
'VenteComptoir' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Saisies de ventes comptoir' does not exist !!
'Courrier' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Commandes fournisseur' does not exist !!
'AvoirF' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Factures d'avoir fournisseur' does not exist !!
'Fiche de paye' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Fiche paye' does not exist !!
'Etat des charges' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Etat des charges' does not exist !!
'Livre de paye' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Livre paye' does not exist !!
'Journaux' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Journaux'
'BonLivraison' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Bons de livraison' does not exist !!
'VenteFacture' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Factures' does not exist !!
'Relance' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Relances clients' does not exist !!
'Balance' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Balance'
'Commande' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Commandes fournisseur' does not exist !!
'Avoir' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Factures d'avoir' does not exist !!
'Devis' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Devis' does not exist !!
'Grand Livre' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Grand Livre' does not exist !!
'CommandeClient' : 'C:\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49\Commandes clients' does not exist !!
PDF directories:
'Journaux' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49'
'Balance' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49'
'Grand Livre' : 'C:\Program Files\OpenConcerto\..\..\Users\LTE\Documents\OpenConcerto\LA TABLE DES ECOLIERS-49'
org.openconcerto.erp.generationDoc.TemplateManager
Default provider: org.openconcerto.erp.generationDoc.DefaultLocalTemplateProvider@6af6c3
Templates:
'Devis' : ok
'VenteFacture' : ok
'CommandeClient' : ok
'BonLivraison' : ok
'Avoir' : ok
'AvoirF' : ok
'Commande' : ok
'Balance' : ok
'Grand Livre' : stream missing
'Journaux' : ok
'Etat des charges' : stream missing
'Fiche de paye' : stream missing
'Livre de paye' : stream missing
'Courrier' : ok
'Relance' : stream missing
'VenteComptoir' : stream missing
févr. 02, 2013 9:24:36 AM org.openconcerto.sql.model.DBSystemRoot setRootPathFromDS
WARNING: db default schema is PUBLIC and the schemas of DBSystemRoot are empty ; the first created schema will become the default one
févr. 02, 2013 9:24:37 AM org.openconcerto.erp.modules.ModuleManager startRequiredModules
INFO: starting required modules
févr. 02, 2013 9:24:37 AM org.openconcerto.erp.modules.ModuleManager startRequiredModules
INFO: starting required modules, done
SELECT "CLASSE_COMPTE"."ID", "CLASSE_COMPTE"."NOM", "CLASSE_COMPTE"."TYPE_NUMERO_COMPTE"
FROM "OpenConcerto"."OpenConcerto49"."CLASSE_COMPTE"
WHERE ("CLASSE_COMPTE"."ID" != 1) AND ("CLASSE_COMPTE"."ARCHIVE" = 0)
ORDER BY "CLASSE_COMPTE"."TYPE_NUMERO_COMPTE"
SELECT "ECRITURE"."NOM", "MOUVEMENT"."NUMERO", "COMPTE_PCE"."NUMERO", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "JOURNAL"."CODE", "PIECE"."NOM"
FROM "OpenConcerto"."OpenConcerto49"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."COMPTE_PCE" "COMPTE_PCE" on (("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID") AND ("COMPTE_PCE"."ARCHIVE" = 0)) AND ("COMPTE_PCE"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."MOUVEMENT" "MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "MOUVEMENT"."ID") AND ("MOUVEMENT"."ARCHIVE" = 0)) AND ("MOUVEMENT"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."JOURNAL" "JOURNAL" on (("ECRITURE"."ID_JOURNAL" = "JOURNAL"."ID") AND ("JOURNAL"."ARCHIVE" = 0)) AND ("JOURNAL"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."PIECE" "PIECE" on (("MOUVEMENT"."ID_PIECE" = "PIECE"."ID") AND ("PIECE"."ARCHIVE" = 0)) AND ("PIECE"."ID" != 1)
WHERE ("ECRITURE"."ID" != 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("ECRITURE"."DATE" BETWEEN '2012-01-01' AND '2011-12-31') AND ("ECRITURE"."ID_JOURNAL" = 1)))
ORDER BY "ECRITURE"."ID_MOUVEMENT", "COMPTE_PCE"."NUMERO"
févr. 02, 2013 9:26:13 AM org.openconcerto.utils.ExceptionHandler display
INFO: null
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[AWT-EventQueue-0,6,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:86)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:90)
at org.openconcerto.erp.config.Gestion$1.uncaughtException(Gestion.java:115)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.awt.EventDispatchThread.processException(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: unknown field DATE_EXPORT in ECRITURE. The table ECRITURE contains the followins fields: [ID, NOM, ID_MOUVEMENT, ID_COMPTE_PCE, DATE, DEBIT, CREDIT, ID_JOURNAL, ARCHIVE, VALIDE, ORDRE, POINTEE, DATE_POINTEE, DATE_VALIDE, IDUSER_CREATE, IDUSER_VALIDE, IDUSER_DELETE, LETTRAGE, DATE_LETTRAGE, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, JOURNAL_NOM, JOURNAL_CODE, COMPTE_NOM, COMPTE_NUMERO]
at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:726)
at org.openconcerto.erp.panel.compta.ExportRelationExpertPanel.actionPerformed(ExportRelationExpertPanel.java:288)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
... 6 more

SELECT "ECRITURE"."NOM", "MOUVEMENT"."NUMERO", "COMPTE_PCE"."NUMERO", "ECRITURE"."DATE", "ECRITURE"."DEBIT", "ECRITURE"."CREDIT", "JOURNAL"."CODE", "PIECE"."NOM"
FROM "OpenConcerto"."OpenConcerto49"."ECRITURE"
LEFT JOIN "OpenConcerto"."OpenConcerto49"."COMPTE_PCE" "COMPTE_PCE" on (("ECRITURE"."ID_COMPTE_PCE" = "COMPTE_PCE"."ID") AND ("COMPTE_PCE"."ARCHIVE" = 0)) AND ("COMPTE_PCE"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."MOUVEMENT" "MOUVEMENT" on (("ECRITURE"."ID_MOUVEMENT" = "MOUVEMENT"."ID") AND ("MOUVEMENT"."ARCHIVE" = 0)) AND ("MOUVEMENT"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."JOURNAL" "JOURNAL" on (("ECRITURE"."ID_JOURNAL" = "JOURNAL"."ID") AND ("JOURNAL"."ARCHIVE" = 0)) AND ("JOURNAL"."ID" != 1)
LEFT JOIN "OpenConcerto"."OpenConcerto49"."PIECE" "PIECE" on (("MOUVEMENT"."ID_PIECE" = "PIECE"."ID") AND ("PIECE"."ARCHIVE" = 0)) AND ("PIECE"."ID" != 1)
WHERE ("ECRITURE"."ID" != 1) AND (("ECRITURE"."ARCHIVE" = 0) AND (("ECRITURE"."DATE" BETWEEN '2012-01-01' AND '2011-12-31') AND ("ECRITURE"."ID_JOURNAL" = 3)))
ORDER BY "ECRITURE"."ID_MOUVEMENT", "COMPTE_PCE"."NUMERO"
févr. 02, 2013 9:26:43 AM org.openconcerto.utils.ExceptionHandler display
INFO: null
org.openconcerto.utils.ExceptionHandler: UncaughtException on thread Thread[AWT-EventQueue-0,6,main]
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:86)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:90)
at org.openconcerto.erp.config.Gestion$1.uncaughtException(Gestion.java:115)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.lang.ThreadGroup.uncaughtException(Unknown Source)
at java.awt.EventDispatchThread.processException(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: unknown field DATE_EXPORT in ECRITURE. The table ECRITURE contains the followins fields: [ID, NOM, ID_MOUVEMENT, ID_COMPTE_PCE, DATE, DEBIT, CREDIT, ID_JOURNAL, ARCHIVE, VALIDE, ORDRE, POINTEE, DATE_POINTEE, DATE_VALIDE, IDUSER_CREATE, IDUSER_VALIDE, IDUSER_DELETE, LETTRAGE, DATE_LETTRAGE, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, JOURNAL_NOM, JOURNAL_CODE, COMPTE_NOM, COMPTE_NUMERO]
at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:726)
at org.openconcerto.erp.panel.compta.ExportRelationExpertPanel.actionPerformed(ExportRelationExpertPanel.java:288)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
... 6 more

sam. févr. 02, 2013 6:33 pm

unknown field DATE_EXPORT in ECRITURE

Il manque un champs dans une table, étrange...
Avez vous fait une mise à jour?

Cordialement,

LTE · lun. févr. 04, 2013 2:44 pm

Bonjour , je suis effectivement passée de la 1.2 à la 1.3 mais ça le faisait déjà avant.
Cordialement

LTE · lun. févr. 11, 2013 5:52 pm

Bonsoir,
Vous dites qu'il manque un champ dans table, comment le rajouter?
Merci

ludovic · mar. févr. 12, 2013 10:34 am

Bonjour,

en effectuant la mise à niveau de votre base avec l'outil de configuration, ce champ doit être ajouter.
Avez vous fait cette mise à niveau quand vous êtes passé sur la version 1.3?

Cordialement,
Ludovic.

LTE · mer. févr. 13, 2013 6:49 pm

Bonsoir,
j'ai effectué la mise à jour (2 fois au cas où..) j'exporte et toujours un tableur avec rien dedans, poids 0Ko.
Une autre idée?

liloneum · dim. avr. 14, 2013 9:30 pm

Bonsoir,

Peut-être un peu idiot comme suggestion, mais avez-vous sélectionné une plage de dates dans laquelle il y a des mouvements lors de l'export ?