Reid’s Blog

????????????????????????????????????????? - January 8, 2009 at 6:07 pm

 Cloud Converter(???????????)??????????????????????????(??????????)?????? 

 
????????????Google Code??????????????????Java???????????????????? 
 
?    ????????????JDBC???????????????????(Lotus Notes, Oracle, MySQL, ??)? 
?    ???????? 
?    ?????????????????? 
?    ??????????????????????????????????????? 
?    ????????????? 
 
???????????????ReadMe.txt??????????????
 
??????????????????rcarlberg@modelmetrics.com

Cloud Converter: Automatically turn your dirt bound db tables to Force.com objects - January 4, 2009 at 6:38 pm

(???

I just posted Cloud Converter to Google code.  It’s a bunch of Java code that:

** connects to a dirt bound database you specify — anything with a JDBC connector should work (MySQL, Lotus Notes, Microsoft SQL, Oracle)
** inspects the meta data
** creates a matching object in Force.com
** modifies the default page layout to include all of the fields and creates a custom tab for it
** moves data from the dirt to the cloud

Pretty straightforward.  The "ReadMe.txt" gives more detail.  I’ll be putting together a screen flow shortly.  Questions?  Drop me an email: rcarlberg@modelmetrics.com.

Model Metrics has released this as open source with an MIT License

Enjoy!

1/7 Update: This is now on Salesforce.com’s Code Share.

Web 11.0 and Other Top Buzzwords for 2009 (pt. 1) - December 22, 2008 at 5:10 pm

He's an Abe

Cloudware — used as early as 2007 to refer to things like Google Maps, normal people will start saying it this year to refer to just about everything.

"AWS It" — putting something on AWS’s S3, EC2 or Turk instead of going the dirt computing route.

Web 11.0 — someone will surely co-opt this meaningless string of syllables in a vain attempt to lend it real significance.  Won’t be dull enough to be widely used until mid 2010.  But seriously: I had to go all that way to Web 11.0 to find one that wasn’t  in some degree of use.  Check this out: formal definitions for Web 1.0 through Web 8.0.

"He’s an Abe"* — that guy — you know the one — who keeps arguing that you need to keep data on a server in house and that you can’t really deal with the downtime imposed by an external service provider’s schedule maintenance window.**

Pie — OK, that’s not PaaS / SaaS or otherwise buzzworthy.  I just like pie.   Any you’d like to contribute? Feel free in comments.

* Estimated time until we get a cease and desist or whatever on the image above? 9 minutes.  Special thanks to Josh Birk for  finding the image.

** Cause you know in house servers never go down.

I call dibs: The opposite of “cloud computing” is “dirt computing” - December 22, 2008 at 2:44 pm

It’s the time of year for predictions.  Everyone has their prognostication hat on. My thoughts?  We’ll need a buzzword for all those servers we’re killing.  It should be slightly negative.

I call dibs on "dirt computing". 

From what I can tell, 2009 is not likely to be a good year for dirt computing.

Chicago User Group Notes: FreshDM, Dreamforce and Verizon Wireless - December 18, 2008 at 4:35 pm

Just finished up at the Chicago User Group.  Pretty good crew showed up despite the weather and the time of year.  The particular one was hosted by Click Commerce and sponsored by Allegro and Model Metrics.
 
Who is Allegro?  Fair question.  They produce FreshDM, an on-demand direct marketing print fulfillment thing.  (There’s a catchier phrase for it — I just can’t find it right now.)  You know all those hours you’ve spent on postcard addressing?  Or letters?  Or whatever?  They take that process and make it point and click.  Put in your direct mail piece template, select the recipients and they do the rest: print, address, stamp, mail.  
 
One word: AWESOME!
 
If I think back a few years to when I would design a postcard and ship it out to PrintingForLess.com (who, by the way, still rocks) (I think, I haven’t used them in a few years), wait for the results to ship to me, print out a bunch of labels, peel and stick and run it through the postage machine OR WORSE apply stamps — you get the idea.  What a waste of time that was.
 
FreshDM — if you read this — feel free to set me up with a sample account so I can try it out on my Christmas cards.  You would make my day!
 
OK enough of a non-too-subtle plea for help getting Christmas cards done — back to CUG.  
 
We talked about Winter 09.  Standard stuff.  It’s funny — no one is talking about Visualforce Email templates which I LOVE.  Think about it — the ability to create an attachment that’s either CSV or PDF and send the whole thing out.  It’s AWESOME.  Not that the rest of the release isn’t — but I’d like to see more people talk about it for sure.
 
Then we had a chance to talk about some of the Model Metrics neatness — Lasso2Go mostly.  Ever notice that your Verizon wireless card sloooooooows down when you’re in front of a crowd?  Mine certainly did this time.  Ah the many joys of live demos!
 
But we had a good number of questions (not soft balls — actual questions) about how to work with Force.com sites and Amazon Web Services — enough that I don’t think too many people other than me noticed the slow wireless.  I took pictures of cards with my web cam, everything was transcribed in pretty near real time and we had what were I think a couple of pretty legitimate ooh’s and ah’s.
 
Thanks to Cecile and Denise for organizing everyone and for inviting us.  I look forward to the next one!

Force.com Sites, Visualforce & Your Mobile Device - December 15, 2008 at 5:57 pm

Note – Screen shots for Blackberry and iPhone below.

Dreamforce ’08 has come and gone.  We had a couple of nice mentions — Lasso2Go of course but we also had the DFMobile application. Hit http://dfmobile.force.com from your mobile device if you’d like to see it.  It works on a Blackberry, a WAP/ simple XHTML compatible device or an iPhone.

The use case: you’re a Dreamforce 08 attendee and you want to find out about the event from your phone.  And if you’ve already registered on the Dreamforce portal, you can access the schedule you built there on your mobile device.  You can search partners and sessions, find out more information about the Foo Fighters and local watering holes, and a whole lot more.*

The basic system is pretty straightforward.  Some details:

  • The back end is the existing SFDC event registration system based on customer portal.
  • The DFMobile piece starts at a page that inspects the client and redirects to either the WAP / simple XHTML page or to the iPhone page based on the HTTP_ACCEPT environmental variable.
  • Both resulting pages use the same Apex controller and are based on Force.com Sites.  Sites lets users see public information — partners, sessions, local info — without authenticating.
  • Users have the ability to search partners and sessions based on some simple criterial.
  • Users also have the ability to login.  Once logged in, the user can see the schedule they originally created on the full web client.

There were a few other features that didn’t quite make it to production.  For example, we created a way to highlight the particular room a session was in on the iPhone client.  And to be clear, this is used a single image that the iPhone highlighted based on coordinates in the object.  The only reason it didn’t make it to production was the timing of go-live.

For the iPhone developers out there, this is using the CiUI library from CNET.  Over all, CiUI was pretty serviceable.  The only thing that came up occassionally was an odd timing issue related to how fast CiUI could respond to user input.  Sometimes, during testing, the javascript that replaces the body of a page would get out of synch with the results coming back from SFDC.  The page would then display without the decorative wrapper containing the header, footer and CSS.  Note: this apears to have only been an issue in artificial rapid fite tesing, not in production, and wasn’t an issue related to Force.com response times.

The biggest lesson learned? Getting the permissions aligned between the custom object, customer portal and Force.com sites takes a minute to get used to.  If something isn’t checked, your application will appear unresponsive.  If your app appears unresponsive, chances are good that it’s related to permissions.

A pretty exciting project all in all.

Blackberry Screenshots

Blackberry Main Screen (WAP/Simple XHTML)

Blackberry Session Search Form

 

Blackberry Session Search Results

 iPhone Splash Screen

iPhone Main Menu

iPhone, post login, My Sessions > Tuesday view

* OK, well, not a whole lot more, but some more.  Check it out on the

My Adventures with Salesforce.com and Alec Baldwin in NYC - December 8, 2008 at 4:43 pm

Attended SFDC’s Cloudforce in NYC today.  It was at The Pierre — a pretty nice hotel.  Two digressions to get out of the way: love the new Tommy Bahama shirts, was not a big fan of the chicken salad sandwiches.

Mr. Benioff & crew did their job.  Highlights:

One person came out of the keynote and said, "I didn’t get it.  But I can tell you the last thing I want to buy right now is a server."  (Michael Dell should meet him.)

Another, "I advise a national non-profit. They keep wanting to build infrastructure.  I keep telling them not to and now I have more alternatives."

And my favorite, when I explained Lasso2Go and the whole Force.com Sites + Amazon AWS connection, "You can do that?" Yes.

Pretty good day.  And a side note on Lasso.  Today is the first day I’ve used it in ernest.  It’s pretty cool.  I used it to capture every business card someone handed me.

And where you might ask does Alec Baldwin come in? He was talking on a phone outside of Topaz, a Thai place we stopped at (get the Drunken Chicken —- AWESOME).  We — OK, I — gawked.  

Learn How To Migrate Apps to the Cloud @ Cloudforce NYC - December 2, 2008 at 11:29 am

 Heading to Cloudforce in NYC?  So am I.  We’ll be talking about some of the standard stuff as well as one supercool addition.  You should definitely stop by our booth (I think it’s a booth — might be a table — either way stop by) and ask for a demo.  I’ll be there all day.

 

 

Galorath: 80% Reduction In Development Effort with Force.com - November 15, 2008 at 9:22 am

So Dan Galorath has noticed Force.com and started to quantify the savings he believes users can achieve with it.  It looks like Marc Benioff sent the results around to all of SFDC.  With good reason – Galorath estimates 30-40% lower costs when compared to Java.

Very cool.  And consistent with my experience. 

In an explanatory article, How Galorath Quantified the Salesforce.com Platform, there are a couple of interesting nuggets hidden all the way at the bottom:

"For applications that are consistent with the built in capabilities of the SalesForce.com Platform, there appears to be about an 80% reduction in the actual development effort. Because of the ability to create with point-and-click operations to support prototyping, the requirements and design effort is reduced with estimates ranging from 10% to 25%."

You read that right: 80% reduction in development effort.  Wow.

And, since I’m a nitpicker, I’m going to pick on one thing.  Galorath writes:

"APEX does not provide UI services or support external web service calls, the primary focus is to provide data oriented transactional services – more like Stored Procedures in Oracle or SQL Server."

The web services call issue is just incorrect.  APEX absolutely supports those.  And the UI services section — I think this is splitting hairs.  APEX doesn’t, but Visualforce does.

Oh and since I’m really a nitpicker, it’s not "SalesForce.com" with a capital "F".  It’s lower case.  C’mon people.

Glad to see Force.com getting some good formal attention.  Now if we could just get some Z notation animators for it.

Just Noticed This in the Force.com IDE re: Sites - November 5, 2008 at 7:14 pm

 

So it’s post Dreamforce 08 — awesome.  Love DF, love getting home from DF. 

On the flight, I noticed something interesting: if you cruise into Eclipse, the plugins directory, where you have the Force.com IDE, you’ll see a "com.salesforce.ide.documentation.[a bunch of numbers]".  If you look in there, you’ll see a directory called "platform_labs", and if you look in there you’ll see a fair amount of info re: Force.com Sites.

All of which was released on 10/27/2008, several days before THE BIG ANNOUNCEMENT.

Note to self: look for hidden goodies in the next release of the IDE.