Forums

Data Exchange to Excel

Last post 02-11-2008, 4:45 PM by rlcazomi_lquigley. 3 replies.
Sort Posts: Previous Next

     10-16-2007, 4:53 PM 8893

    Data Exchange to Excel

    Is anyone using an Excel spreadsheet with routines to access Fellowship One for updated demographic information using Data Exchange and XML.

     01-17-2008, 8:06 AM 9444 in reply to 8893

    Re: Data Exchange to Excel

    I have been trying for serval months to figure out how to successful communicate with F1 through Data Exchange. I need help too. Anybody? My skill set is PERL, MySQL, PHP, JavaScript etc. Have not learned Visual Basic or Visual Studio. I try to avoid MicroStuff
    Bob VanDerPloeg
    IT Director
    Discovery Church
    | Filed under: , , ,

     01-23-2008, 8:28 AM 9510 in reply to 9444

    Re: Data Exchange to Excel

    Danl:
    I have not heard of anyone directly using Excel to call DataExchange, however I have a few churches using macros to create XML from an Excel workbook and then having some process push the data up to DataExchange.

    What you're looking for can be done using the script editor and some of the developer soap libraries provided by Microsoft.  Last year @ DC07 illustrated the concept using outlook - but the same principles still hold true - see my post on it here.  Let me know if you want the code and Office libraries for my illustration.


     Bob:
    You can download the DataExchange code libraries here to help you accomplish what you’re trying to do.

    --Nick

     02-11-2008, 4:45 PM 9820 in reply to 9444

    Re: Data Exchange to Excel

    I have some experience in the Data Echange API for F1, I made www.rlc.info and made them work together for the most part.   The site is fully based on PHP & MySQL, so if you need any code, just let me know and I will get it to you.  My email is lquigley@rlc.info.  Ha, I avoid MicroStuff as well.

View as RSS news feed in XML