Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Import Data - English Forum - Axelor Forum

    Uploaded by

    Hor Edward

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Import Data - English Forum - Axelor Forum

    Uploaded by

    Hor Edward
    15 views5 pages

    Original Title

    Import data - English Forum - Axelor Forum

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    15 views5 pages

    Import Data - English Forum - Axelor Forum

    Uploaded by

    Hor Edward

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    For proven anomalies on the software, please report it on our GitHub page : Axelor GitHub for

    Axelor Open Suite

    For proven anomalies on the Axelor Open Platform, please report it on our GitHub page : Axelor
    GitHub for Axelor Open Platform

    Please review the :

    FAQ/Guidelines
    Terms of service
    Privacy Policy

    Import data

    wotikar févr. '22

    I got Axelor up and running, nice application!. Now I want to import customer/lead/contact data
    from our ERP system with CSV and or XML through the mapping-files, but I haven’s got a clue
    where to start. Are there examples for this? I searched but I couldn’t find any of them.

    bDurtaut Durtaut févr. '22

    Hello , demo datas are good for the structure .


    Regards

    wotikar févr. '22

    where can i find these files?

    bDurtaut Durtaut févr. '22

    On sources or war file

    wotikar févr. '22

    Could you please be a little bit more specific? I checked the WAR files contents but couldn’t
    find XML mapping files. Also searched on google for Axelor sources but no examples

    bDurtaut Durtaut févr. '22


    Passer au contenu principal
    On source it s on the demo repository of each module :
    for example for base module axelor-base\src\main\resources\demo
    on fr repository files csv in french , and the structure for import in the file base-config.xml

    siddique Siddique Ahmad févr. '22

    I wrote in following link for axelor import chart of accounts, but process is general, let me know
    if you need anything

    https://link.medium.com/0VcHO37vsnb

    wotikar févr. '22

    Thanks @siddique for this. I understand the technique on how data should be imported
    through 2 files. What I dont understand for example is how do i know what is the name of the
    database field and which type I should use? For me it is really easy to export the data from our
    ERP to CSV/XML files. But how to map these so that the Axelor importer can use them. The is
    not much documentation about this subject (or I can’t find it) I would like to start with a
    simple importer for Customers for example

    siddique Siddique Ahmad févr. '22

    do you know how to get model of any grid?? if you click on settings it will open menu in grid

    as shown in image, 2nd way is to see demo data

    wotikar févr. '22

    You mean this screen:

    Passer au contenu principal


    siddique Siddique Ahmad févr. '22

    yes, it’s structure of table, you were looking for same?

    wotikar févr. '22

    I think I was looking for that. Is that also the adapter which is under the package label?

    siddique Siddique Ahmad févr. '22

    couldn’t get later part

    wotikar févr. '22

    I mean this part, is that the adapter?

    Passer au contenu principal


    siddique Siddique Ahmad févr. '22

    yes, it is model linked with that

    wotikar févr. '22

    Thanks @siddique for the support. Going to do my best to get it working.

    wotikar févr. '22

    Alright, one step further now. I have managed to import data in the simple table
    « base_country » through CSV. Now I want to import customers (is it right that they are called
    Partners in Axelor?). How do i know which fields in the database are mandatory?

    siddique Siddique Ahmad févr. '22

    yes partners, from domain model XML file

    wotikar févr. '22

    OK, Axelor tells me that i have imported 3512 customers as succeded, When I click on
    customers under CRM there are no records. Also the BASE_PARTNER table is empty.
    Passer au contenu principal
    siddique Siddique Ahmad févr. '22

    can you share CSV and XML mapping file in gist

    You might also like