You need to sign in to do that
Don't have an account?
BK
DATA LOADER SOURCE CODE QUESTION
I have a couple of questions
1. How can I view and mod the dataloader code. I am a vb developer and I heard the data loader was written in java. Is there a vb edition?
2. If i can modify the code, is there anywway we could run a schedule task to exports certain tables to an ftp url nightly? Also, the files that are being uploaded need to be modified as well. For example, the phycial_zip_code in the account table will need to have a (') inserted in front of each zip code. Another example would be elliminate all carragie returns in the address field cells with a space ( " ") . How can this be done? Any sugeestions or helpful code?
1. How can I view and mod the dataloader code. I am a vb developer and I heard the data loader was written in java. Is there a vb edition?
2. If i can modify the code, is there anywway we could run a schedule task to exports certain tables to an ftp url nightly? Also, the files that are being uploaded need to be modified as well. For example, the phycial_zip_code in the account table will need to have a (') inserted in front of each zip code. Another example would be elliminate all carragie returns in the address field cells with a space ( " ") . How can this be done? Any sugeestions or helpful code?
It sounds like you'd might be better of with a full blown ETL tool such as Pervasive, Scribe, etc. Check out the solutions here: http://www.salesforce.com/partners/solutions.jsp?id=Integration%20(EAI/ETL)
If you are going to do this yourself, you should be able to export the data, and then either use a Java ftp class to upload your files, or script it using perl or something else. Adding translations to the data loader would be a nice feature
Thanks
Jose