Hello everyone ^^ In Config applicative → Maintenance technique → Imports, I am trying to import leads and It doesn’t work. It does not show me an error like in the pic below
Any solution? I really appreciate your help in advance.
Bonjour Jamal,
Dans le .xml comment tu as nommé le .csv : « Lead.csv » ou « Lead(1)(1).csv » ?
please share your .xml and .csv
This is my .csv file for roles named role.csv
« id »;« name »;« description »;« permissions »
1;« role.crm »;« Accès à l’ensemble des objets du module CRM »;« perm.base.all|perm.crm.all|perm.purchase.rwc|perm.sale.rwc|perm.stock.rwc|perm.mail.all|perm.dms.all|perms.user|perm.meta.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r|perm.team.all »
2;« role.supplychain »;« Accès à l’ensemble des objets du module Supply Chain »;« perm.base.all|perm.crm.all|perm.purchase.all|perm.sale.all|perm.stock.all|perm.production.rwc|perm.account.rw|perm.team.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r|perm.meta.menu.r »
3;« role.operations »;« Accès à l’ensemble des objets liés aux opérations (Production, Stock…) »;« perm.base.all|perm.crm.all|perm.purchase.rwc|perm.sale.rwc|perm.stock.rwc|perm.production.all||perm.team.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r »
4;« role.accounting »;« Accès à l’ensemble des objets du module Account »;« perm.base.all|perm.crm.all|perm.purchase.rwc|perm.sale.rwc|perm.stock.rwc|perm.account.all|perm.team.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r »
5;« role.hr »;« Accès à l’ensemble des fonctionnalités RH »;« perm.base.all|perm.crm.all|perm.team.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r|perm.contract.all »
6;« role.manager »;« Accès à l’ensemble des fonctionnalités »;« perm.base.all|perm.account.all|perm.hr.all|perm.production.all|perm.crm.all|perm.purchase.all|perm.sale.all|perm.stock.all|perm.mail.all|perm.dms.all|perms.user|perm.businessproject.all|perm.cash.management.all|perm.supplier.management.all|perm.message.all|perm.meta.all|perm.project.all|perm.supplychain.all|perm.client.portal.all|perm.team.all|perm.bankpayment.all|perm.studio.all|perm.quality.all|perm.helpdesk.all|perm.fleet.all|perm.talent.all|perm.marketing.all|perm.base.app.block|perm.account.config.block|perm.bankpayment.config.block|perm.sale.config.block|perm.stock.config.block|perm.purchase.config.block|perm.production.config.block|perm.hr.config.block|perm.crm.config.block|perm.supplychain.config.block|perm.base.company.r|perm.contract.all »
7;« role.client »;« Accès au portail client »;« perms.user|perm.base.partner.r|perm.sale.saleOrder.r|perm.sale.saleOrderLine.r|perm.sale.saleOrderLineTax.r|perm.crm.event.r|perm.crm.eventCategory.r|perm.account.invoice.r|perm.account.invoiceLine.r|perm.account.invoiceLineTax.r|perm.helpdesk.Ticket.rwc|perm.helpdesk.TicketType.rwc|perm.helpdesk.Sla.rwc|perm.project.rwc|perm.stock.rwc|perm.project.projectTask.all|perm.meta.menu.r|perm.teamTask.rwc|perm.projectTask.rwc|perm.base.product.r »
8;« role.consultant »;« Accès au portail consultant »;
9;« role.supplier »;« Accès au portail fournisseur »;« perms.user|perm.base.partner.r|perm.purchase.purchaseOrder.r|perm.purchase.purchaseOrderLine.r|perm.purchase.purchaseOrderLineTax.r|perm.suppliermanagement.PurchaseOrderSupplierLine.rw|perm.stock.stockMove.r|perm.stock.stockMoveLine.r|perm.base.Product.rwc|perm.account.invoice.r|perm.base.product.r|perm.meta.menu.r|perm.bank.details.r|perm.budget.distribution.r|perm.meta.file.r|perm.stock.location.line.r|perm.stock.rules.r|perm.bill.of.material.r »
And this is my .xml file named role-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<input file="role.csv" separator=";" type="com.axelor.auth.db.Permission"
search="self.name = :name" call="com.axelor.csv.script.ImportPermission:importPermissionToRole">
<bind to="canRead" eval="can_read == 'x' ? 'true' : 'false'"/>
<bind to="canWrite" eval="can_write == 'x' ? 'true' : 'false'"/>
<bind to="canCreate" eval="can_create == 'x' ? 'true' : 'false'"/>
<bind to="canRemove" eval="can_remove == 'x' ? 'true' : 'false'"/>
<bind to="canExport" eval="can_export == 'x' ? 'true' : 'false'"/>
</input>
<input file="base_metaMenu.csv" separator=";" type="com.axelor.meta.db.MetaMenu"
search="self.name = :name and self.module = 'axelor-base'" update="true">
<bind column="roles" to="roles" search="self.name in :roles"
eval="roles.split('\\|') as List"/>
</input>
<input file="base_metaMenu.csv" separator=";" type="com.axelor.meta.db.MetaMenu"
search="self.name = :name and self.module = 'axelor-core'" update="true">
<bind column="roles" to="roles" search="self.name in :roles"
eval="roles.split('\\|') as List"/>
</input>
</csv-inputs>Hello,
The column « id » should be removed or replaced per « importId ». The id field is automatically filled per the system.
Regards
Thank you. Does that mean I should not fill the field of id? I tried the import again by changing the id to importId but it still not working.
importId is use to have a key from imported data ( can be used to update data)
1 « J'aime »