cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

With which type of ID Origin contacts are uploaded through Excel CSV files

former_member654580
Participant
0 Kudos
251

Hi Experts

I hope you will concentrate well on these times of tension by the Covid-19.

I'm uploading some contact data to MKT via Excel CSV but I don't identify that ID Origin should be used in the Origin_ID

The file is fed from an ERP source.

But those same contacts with certain attributes are also loaded via integration from C4C

Thanks

Elio C.

con cual ID origen se suben los CSV

Accepted Solutions (1)

Accepted Solutions (1)

SCHNEIDERT
Active Contributor
0 Kudos

Hi eliocentenob,

I don't know which data comes from which system in your case. Usually I would say ERP system is the Single Source Of Truth and needs a higher priority. But you have to define that depending on your needs.

If every customer can have only one ID in each of the systems, you can mark both of them with "One per Contact". In my opinion that would make sense but it also depends on your configuration.

BR Tobias

Answers (3)

Answers (3)

SCHNEIDERT
Active Contributor

Hi eliocentenob,

I'm not sure if I understood your question.

You would like to know which ID Origin you should use in the first column ID_ORIGIN in the csv file for contacts from SAP ERP?

Why don't you use SAP_ERP_CUSTOMER or SAP_ERP_CONTACT or SAP_ERP_BUPA?

Basically you can use any ID Origin of your choice. Which data you can then see in the Golden Record (after match & merge) depends on the priorities you defined in customizing.

BR Tobias

former_member654580
Participant
0 Kudos

It's okay Tobias,

Thank you very much for your valuable support.

Best regards

Elio C.

former_member654580
Participant
0 Kudos

Hi Tobias.


If you understood my doubt, the data comes from SAP ISU, and from what I understand I can use one of these three SAP_ERP_CUSTOMER or SAP_ERP_CONTACT or SAP_ERP_BUPA in the CSV file.

Regarding the priority, I suppose that it must first be the data that I bring from C4C in integration of the Origin ID SAP_C4C_BUPA and then the ID of the SAP_ERP_CUSTOMER.

Should I mark one of the two as One per Contact?

Best regards
Elio C