Apex Code Development You need to sign in to do that
Don't have an account?
sforce Connector: new version 5.30
I'm posting this version here to try and get some more feedback on the new features before posting on sourceforge, which I hope will be soon.
This version, 5.30 has lots of minor fixes but a few cool new features
Option Dialog to configure the ServerURL, ( allows you to default to 5.0)
Option to trigger assignment rules for Lead and Case insert
Option to use API Names not labels
new feature in a query filter allows you to use TODAY , TODAY - 1 or TODAY + 1 , handy for pulling a window of data
Not to mention the most recent change a method or three of building a Join between two or more tables is described in the On line Help file
added mapping for record types and owner ID's now will display the names instead of the actual ID's, also fix a bug with large queries
http://sforce.sourceforge.net/excel/index.htm
After a bit more testing I will post this out on the primary download link under sforce.sourceforge, but you can try it out now, please let me know if you see problems or regressions.
PS: I've posted the latest version on the http://sforce.sourceforge.net/excel/index.htm
site, this version is now one rev back
have fun,
Ron Hess
Message Edited by Ron Hess on 12-17-2004 10:47 PM
Message Edited by Ron Hess on 01-25-2005 05:55 PM
Hi Ron, thanks a ton for the connector.
I've made some slight modifications to what's installed on my system and would like to know if I could send those changes to you to be incorporated into the next version? Short version, I've added a 'starting with' option to the query wizard. ie. LIKE xyz%
Tim Bouscal
great idea, I did make this change to my code and loaded it up over the weekend past.
so it is now at 5.33 and supports as operators, "starts with", "ends with" and "regexp" , this last one just passes the string into "like" so you can specify in the value cell things like "%foo%"
doc has also been updated, check it out
Would anyone be interested in a quick-n-dirty Visual Studio Installer package for the .xla?
(I'm testing one that simply copies the .xla into the [ProgramFiles]\Microsoft Office\Office10\XLStart (and Office11\XLStart) directories.)
[Edit: Preview Button too close to submit...]
Eventually I'd like to find a way to determine what version(s) of Excel are on the PC and only install the correct ones... If someone can point me to a generic registry entry I'll give it a crack.
We're going to be deploying a signed version of the SLA to our workstations in our Windows Domain via Domain Policies. If others are interested I can do a write-up when we're finished...
Message Edited by daroz on 02-08-2005 05:09 PM
I'd be interested to see what you end up with, sounds interesting, i would like have to have it in source form so i could customize it to wrap my own signed version of the XLA.
thanks
Source, of course... The answer that I'd endorse...
(Ok, ehough Mr. Ed jokes)
I'm waiting to see if I can get from SFDC either the Office Toolkit in an .msi (for our automated deployment scripts and this) so that I can add it in as a merge module as well. Kill 2 birds with one stone. Once it's done and we're deploying successfully I'll dig up your email and fire it off to you.
Exactly -- I have no problems doing that. Just want to make sure everything gets installed/registered in the right place though.