• j4l5
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies

I am exporting files using the data loader command line tool. Is there a way I change the text delimited from " to something else and the column delimited from ,  to something else?

  • February 24, 2012
  • Like
  • 0

I will be automatically creating 2 files each day for uplaod into salesforce via apex data loader, a contacts and an account file.

 

The contacts file will need the sales force account id in order to link the 2 files once uploaded, however if I am uploading both a contact and an account (accunt is not pre existing) I will not be able to determine the account id for the contact.

 

What is the best method to obtain an account id?

 

So far I guess I will need to 1. create and upload account file 2. download account table 3. obtain sales force account id from the downloaded file 4. create and upload contact file

 

Obviously seems a little long winded to me, isnt there a better method for automated uploading with apex data loader

  • February 01, 2012
  • Like
  • 0