ApatarForge
Apatar.com  |  Log In   
close x
First Name Last Name E-mail Telephone Message

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister 
  ProfileProfile     Log in to check your private messagesLog in to check your private messages    Log inLog in  

MS Access to Salesforce useing Upsert

 
Post new topic   Reply to topic    Apatar Community Forums Forum Index -> DataMaps
View previous topic :: View next topic  
Author Message
michaelp



Joined: 15 Apr 2009
Posts: 4
PostPosted: Tue Nov 10, 2009 6:08 am    Post subject: MS Access to Salesforce useing Upsert Reply with quote
Good day,

I have a table in Salesforce that has an external ID I need to update or creat new records from Acess,

but Im not sure of how that will look What do I need to join to the Update connector????
Back to top
View user's profile Send private message
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Tue Nov 10, 2009 9:20 am    Post subject: Re: MS Access to Salesforce useing Upsert Reply with quote
michaelp wrote:
Good day,

I have a table in Salesforce that has an external ID I need to update or creat new records from Acess,

but Im not sure of how that will look What do I need to join to the Update connector????


Your datamap will look like:

MS Access - Transform - SFDC

1. Configure your MS Access connector.
2. Configure your SFDC connector in Update mode and choose your External ID field against which you would update your records.
3. In Transform you need to map all the fields between two tables that you would like to update/upsert/insert. Do not forget to map Id filed from MS Access to External Id filed from SFDC.

Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
michaelp



Joined: 15 Apr 2009
Posts: 4
PostPosted: Tue Nov 10, 2009 11:30 pm    Post subject: Thank you for the qucik reply Reply with quote
Hi,

Thank you fo rth equick reply,

I set my data map up like that but it does not run
I do not get any error message

but will keep trying
Back to top
View user's profile Send private message
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Wed Nov 11, 2009 11:48 am    Post subject: Re: Thank you for the qucik reply Reply with quote
michaelp wrote:
Hi,

Thank you fo rth equick reply,

I set my data map up like that but it does not run
I do not get any error message

but will keep trying


Could you please share your datamap with me? If yes please send it at may email (sergei.l at apatar.com)

Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Apatar Community Forums Forum Index -> DataMaps All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group