Hi Gabriel

If you have a lot of such imports coming from other systems where you have always had to use a mapping, search for ID/ IDs, use ETL, transform data, clead before import, import with context, import in models and child models, conditional import [import if value or expression is true] etc,.. And also use python methods

I can recommend this powerful tool which is also used for mass importing or even a data connector [CSV, TXT, Excel]

https://braintec.com/r/Pip

With this module, the users can:

- Import data for several related models at the same time from a single file.

- Import data on batches, or select different delimiters or columns. Or define conditions to skip some lines or inactive records.

- Import data based on any field to compare existing records.

- Decide to import data based in another related model records.

- What actions this data needs to perform in the Database.

- Code a few lines in the import to transform the data or add new data before inserting it if needed. Or check that related records already exist in the database to allow the import of the line.

For example when importing "res.partner" from an excel with related fields for state_id (Provence or county), title  you can do it like that => 

Just build a record for your vals_list and do a lookup for the related fields

insert_record = {

...

"is_company": True,              

"title": self.env['res.partner.title'].search( domain=[('name', '=', rec.anrede.strip())],                            limit=1).id,                        "name": rec.name.strip(),                        "street": 

rec.adresse.strip(),                        

"zip": rec.plz.strip(),                        

"city": rec.ort.strip(),         

 "state_id": self.env['res.country.state'].search(domain=[('code', '=', rec.bundesland.strip())],                            limit=1).id                    

}

The problem is that I do not have the partner id in the csv file (it is a report that generates another system). I only have the field data "field1" and I want to relate this to the related field for the partner in the csv to import. I do not have the id, external id or the name.

Many thanks in advance for the answer Niyas!