How can I map a value from my DB to a salesforce picklist?

  • 132Views
  • Last Post 14 November 2019
0
votes
Jonny Katz posted this 13 November 2019

I am trying to map an ID value to a salesforce picklist. The picklist has an ID number in the API value field...

in my table, i have id 1 and in salesforce, the API value is 1 but the salesforce field name is dealer. when mapping skyvia to salesforce does skyvia look at the field name or the api value for that field?

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 14 November 2019

 Dear Jonny!

 

Unfortunately, we don't provide phone support for now. Technical support is provided on Support Portal, in the live chat, and by email.

We checked your package #78787. It processed 23062 records successfully and 10 records were failed. Failed records:

Account Phone: data value too large: +971-552019000, +971554406898, +97142353993 (max length=40)

Sub Company Type: bad value for restricted picklist field: 0

Thus, you need to check the values being sent to these target fields. If you mean another package, please tell us its name/id and specify the errors you are getting.

 

You can see the errors in the CSV file which can be downloaded by clicking the number of failed rows (per object) in the Run History. This CSV file contains all failed records, and for every record, there is the reason why it failed. You can find more information in our documentation: https://skyvia.com/resources/docs/error_processing.htm

 

Best regards,

Mariia

0
votes
Jonny Katz posted this 14 November 2019

Its not syncing...

Can I speak to someone on the phone, this is taking longer than it should... I have mapped the field correctly but the information isnt being synced with salesforce... How do i troubleshoot?

0
votes
Mariia Zaharova posted this 14 November 2019

Hi Jonny!

 

Please use Expression mapping: (DT_WSTR, 5) MainCompanyTypeID 

where 5 is the length of the string (set here the value that is suitable for your scenario).

 

Please tell us if this helps.

0
votes
Jonny Katz posted this 14 November 2019

I get invalid...

 

 

 

0
votes
Mariia Zaharova posted this 14 November 2019

Hi Jonny!

 

It is not clear for us what do you have in your source database table. Do you have a column in your source database with the IDs that correspond to the API values of your target Salesforce field (Main_Company_Type__c)? If yes, then please use direct Column mapping. In this case, values from the source column will be sent to the target one.

 

JIC: We used Constant mapping just for example. 

0
votes
Jonny Katz posted this 14 November 2019

Hi, I have about 18 values so how will I map these?

is it a 1:1 relationship? I have many company types and 1 field in Salesforce, how do I do this? We will pass IDs, I have managed to map it in Skyvia but I can only map 1 ID to the salesforce field...

Company Types in postgress table

 

Skyvia mapping

0
votes
Mariia Zaharova posted this 13 November 2019

 Hi Jonny!

 

when mapping skyvia to salesforce does skyvia look at the field name or the api value for that field?

 

In case of importing data to Salesforce picklist field, you should use API names.

For example:

Salesforce Picklist field:

Mapping in Skyvia (for example, we select Constant mapping to see available values):

 

 

Feel free to ask any further questions.

 

Best regards,

Mariia

 

Close