[RESOLVED] "javax.validation.ConstraintViolationException" CSV data import semicolon ( ; ) separator within file

LifeNum · Novembre 15, 2023, 11:44

I just leave this here, it may help someone (as well as new colleagues ) with data imports using csv files :

Use demo files from the Axelor github repository :
ex : axelor-account/src/main/resources/apps/demo-data/fr/account_account.csv

You can see that values are separated with the semicolon " ; " separator :

To get the demo files :

(https://rpubs.com/lokraj/github_csv)

To import the file in Axelor, it must be saved ONLY with the semicolon separator activated :

This way you can avoid error such as : « javax.validation.ConstraintViolationException: Validation failed for classes »

Path In Axelor : Application Config > Technical Maintenance > Imports :

XML Binding File from Axelor github repository :

github.com

axelor/axelor-open-suite/blob/7.2/axelor-account/src/main/resources/apps/demo-data/account-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<csv-inputs xmlns="http://axelor.com/xml/ns/data-import"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://axelor.com/xml/ns/data-import http://axelor.com/xml/ns/data-import/data-import_6.1.xsd">

  <input file="account_accountType.csv" separator=";"
    type="com.axelor.apps.account.db.AccountType"/>

  <input file="account_fiscalPosition.csv" separator=";"
    type="com.axelor.apps.account.db.FiscalPosition"/>

  <input file="account_serviceType.csv" separator=";"
    type="com.axelor.apps.account.db.ServiceType" search="self.importId = :importId"/>

  <input file="account_account.csv" separator=";" type="com.axelor.apps.account.db.Account"
    search="self.importId = :importId"/>

  <input file="account_accountEquiv.csv" separator=";"
    type="com.axelor.apps.account.db.AccountEquiv"/>

This file has been truncated. show original

CSV data source from Axelor github repository:
axelor-account/src/main/resources/apps/demo-data/fr/account_account.csv

and IMPORT !