Problem on import payment mode

Linuxien · Novembre 17, 2022, 8:30

Hello,

I have a problem when importing data via the payment method. I am using the following xml file:

‹ base-config.xml ›

and the following standard Axelor csv file:

‹ PaymentMode.csv ›

In the user interface the program says that there are 0 imports done and 0 errors.

In the server logs, however, I have this:

2022-11-16 17:31:10.762 ERROR 18096 --- [io-8080-exec-10] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_tax.csv.

2022-11-16 17:31:10.762 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.762 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.762 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.762 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.762 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.763 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.763 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.763 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:31:10.763 ERROR 18096 — [io-8080-exec-10] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.226 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.226 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.226 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.227 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.228 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.229 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.230 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.230 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter 2022-11-16 17:32:06.230 ERROR 18096 — [nio-8080-exec-9] com.axelor.data.csv.CSVImporter : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_taxLine.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_tax.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_accountManagement.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/meta_metaTranslation.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_citizenship.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_fileType.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_globalTrackingConfigurationLine.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_mailBatch.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_main_activity.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/auth_permission.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/auth_role.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/auth_group.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/auth_group.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/meta_file.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_company.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_language.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_sequence.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_birtTemplate.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_birtTemplateParameter.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_printSetting.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_template.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_team.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_source.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_economicArea.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_country.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_region.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_departement.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_indicator_generator.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_canton.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_city.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_address.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_currency.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_unit.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_unitConversion.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_partnerCategory.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_duration.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_partner.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_bank.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_bankAddress.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_bankDetails.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_company.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_year.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_year.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_currencyConversionLine.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_companyDepartment.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_productFamily.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_productCategory.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_product.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_productVariantAttr.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_productVariantValue.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_productVariantConfig.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_partner.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_partner.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_company.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_appBase.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/auth_user.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_tax.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_taxLine.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_tax.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/account_accountManagement.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/meta_metaTranslation.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_citizenship.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_fileType.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_globalTrackingConfigurationLine.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_mailBatch.csv.
: Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (2)-20221116/base_main_activity.csv.

Can anyone help me ? Thanks.

Linuxien · Novembre 17, 2022, 9:04

I specify the temp directory, the directory /opt/tomcat/temp/1668614750196-0/

is empty.

bDurtaut · Novembre 17, 2022, 10:29

Hello , you want to import only one file ?

On the demo files , the file is name account_paymentMode.csv , and it s referenced in the account-config.xml

Linuxien · Novembre 21, 2022, 10:42

Thank you for your answer, can you tell me the link to these files please ?

bDurtaut · Novembre 21, 2022, 2:30

On the source , on the « axelor-open-suite-6.3.4\axelor-account\src\main\resources\demo »

Linuxien · Novembre 22, 2022, 8:57

When I try to import, with these files:

PaymentMode (4).csv
account-config.xml

I have this error in the logs:

    SVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/base_bankDetails.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/meta_schedule.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/account_moveTemplateType.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/account_moveTemplate.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/account_moveTemplateLine.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/account_accountingReportType.csv.
2022-11-22 09:53:14.937 ERROR 18096 --- [nio-8080-exec-2] com.axelor.data.csv.CSVImporter          : Error while accessing /opt/tomcat/temp/1668614750196-0/PaymentMode (4) (1)-20221122/account_accountingReportConfigLine.csv.

bDurtaut · Novembre 22, 2022, 9:42

Do you have modify the config xml file to import only the good file ?

malikfaisalawan · Novembre 22, 2022, 4:57

Its the issue of files path.

If you want to auto import one or more CSV files from a single input-config.xml then you should place CSV files in following directory i.e

/modules/« Your module name »/src/main/resources/data-init/input/

and the input-config.xml file should be placed in following directory
/modules/« Your module name »/src/main/resources/data-init/

malikfaisalawan · Novembre 22, 2022, 5:02

your input-config.xml should be look like something like this one i.e.

<input file="meta_schedule.csv" type="com.axelor.meta.db.MetaSchedule"  />
<input file="role.csv" type="com.axelor.auth.db.Role" />
<input file="my_group.csv"  type="com.axelor.auth.db.Group" search="self.code = :code" update="true"/>
<input file="my_user.csv" separator=";" type="com.axelor.auth.db.User" search="self.code = :code" update="true"/>

bDurtaut · Novembre 23, 2022, 11:51

it s exact if you compile souce to have a custom war ( with your init files )

malikfaisalawan · Décembre 10, 2022, 11:04

yes, it s exact if you compile source

system · Janvier 9, 2023, 11:05

Ce sujet a été automatiquement fermé après 30 jours. Aucune réponse n’est permise dorénavant.