decode_import_file.py

# since the import file structure is changing over different versions of Dolibarr, these functions help extract
# the respective order
# the data_of_interest dictionary contains the relation between unique identifiers in Dolibarr and the name convention
# of this module
# the unique identifiers are contained in the headline of the import file template, which can be output from Dolibarr's
# import module

import csv
import re


def read_structure(template_file, data_of_interest):
    with open(template_file, newline='') as csvfile:
        content = csv.reader(csvfile, delimiter=',', quotechar='|')
        headline = content.__next__()
        position = ['' for nn in range(len(headline))]  # list initialization with empty strings

        for data_of_interest_key, data_of_interest_value in data_of_interest.items():
            index = 0
            for field in headline:
                mat = re.search(data_of_interest_key, field)
                if mat:
                    position[index] = (data_of_interest_value)
                index += 1

    return position

if __name__ == '__main__':
    GePartnerDatei_Template = '/home/hhhans/Lokal/Labor/Dolibarr/Datenimport/Beispiel_Import_Datei_societe_1.orig.V12.csv'
    GeKontaktDatei_Template = '/home/hhhans/Lokal/Labor/Dolibarr/Datenimport/Beispiel_Import_Datei_societe_2.orig.V12.csv'
    # mapping = {'s.nom': 'company_name', 's.client': 'status_customer', 's.fournisseur': 'status_supplier',
    #            's.status': '1', 's.code_client': 'auto', 's.code_fournisseur': 'auto', 's.address': 'address_parts[0]',
    #            's.zip': 'address_parts[1]', 's.town': 'address_parts[2]'}

    # mapping = {'s.nom': 'company_name', 's.client': 'status_customer', 's.fournisseur': 'status_supplier',
    #            's.status': '1', 's.code_client': 'auto', 's.code_fournisseur': 'auto', 's.address': 'address_parts[0]',
    #            's.zip': 'address_parts[1]', 's.town': 'address_parts[2]'}

    mapping = {'s.fk_soc': 'company_name', 's.firstname': 'first_name', 's.lastname': 'last_name',
               's.address': 'address_parts[0]', 's.zip': 'address_parts[1]', 's.town': 'address_parts[2]',
               's.email': 'email'}

    print(read_structure(GeKontaktDatei_Template, mapping))