VFP and Act! 2011 SDK

[ebaer]

I need to populate an Act! 2011 database with data exported from Salesforce.com. I would like to use Visual FoxPro 9.0 and the Act! 2011 SDK. The SDK documentation uses VB and C# code samples and I'm having difficulty translating them to VFP. So far I've been able to open an Act! database and add a contact name. I need to be able to populate other contact record fields and add records to other related tables.

Can anyone give me an example of how they've accomplished this?

Here's what I've been able to make work so far:


* Get the ACT Framework object
objDatabase = CreateObject("Act.Framework.Interop.ActFramework")

* What PAD File to open
Padfilename = "C:\Documents and Settings\<username>\My Documents\ACT\ACT Data\Databases\ACT2011Demo.PAD"

* Open said PAD File
objDatabase.Logon(Padfilename, "Chris Huffman", "") && "" = password

* Are we logged in?
IF objDatabase.IsLoggedOn = .f.
MESSAGEBOX("Could not log on at this time.", 16)
ENDIF

* Add a contact record
o = objdatabase.Contacts.CreateNewContact("John Smith", "jsmith@abc.com", 999)

 

[DSummZZZ]

Without having that SDK installed or having access to it, it is pretty much impossible to know how to update the files. As in, what function calls a required and how to implement them.
But since you're able to access it and update it with what you've done so far, the rest shouldn't bee too bad.

That said, if you find a particular function or procedure you think you can use, or have a specific question regarding VB->VFP code usage, post it and we may be able to help.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm