locked
Generating Text file from MS CRM 4.0 RRS feed

  • Question

  • I need to create action button from Account & Contact screens the to perform
    the following on selected items:

    1- Extract the Contact detail (name....,Address,Mobile number) into text
    file as
    \\ABC\folder1\crmfile.txt
    2-Generate sql insert statment into a sql server on a diffrent serve.

    Can you help me please?

    hussain
    Wednesday, March 11, 2009 12:32 PM

Answers

  • I would create a simple web page in the crm website's ISV folder.  Do a post to the webpage using javascript on button click (through ISV config) with the information in the post or query string.  The pageload of the page will take in the information from the request.  It will save it to file, and save the information to your external SQL server.   You can then post a response to CRM that javascript can read.  It will determine whether the processing is successful so you can alert an error message if need be.

    You can also create a web service and call it using javascript.  It is a cleaner implementation, but the XML that you need to post is more complicated.   You just need to use Fiddler to determine what you need to send exactly.

    Let me know if you need more information.

    Thanks,
    Andrew 
    • Marked as answer by Jim Glass Jr Friday, March 13, 2009 8:08 PM
    Wednesday, March 11, 2009 1:34 PM