Salesforce Wallpaper for iPad (by request)

August 13, 2010 · Filed Under Companies, salesforce.com · 2 Comments 

Because he asked so nicely, here's a cloudy iPad wallpaper just for JP Seabury (and anyone else who wants it). Enjoy!

iPad Salesforce Wallpaper

iPad Wallpaper (1024x768 at 132ppi)

(Click on the image to download the full-sized version.)

I Found a Bug – And Salesforce Support Was Great

June 10, 2010 · Filed Under salesforce.com · 6 Comments 

A week ago, I installed Scott Hemmeter’s amazing app, Geopointe. Everything was going smoothly until I decided to manage the licenses I had assigned to the app.

I successfully managed the licenses and tried to click the “Back to Previous Page” link, but something broke:

Salesforce CRM's standard "Bad URL" error

This should never happen for a Salesforce-generated URL

Here’s a video of the problem in action: Managing Licenses Previous Page Link Is Broken.

This is a story about the super-responsiveness of the salesforce.com support team. (I’m not including peoples’ names, but for any employees, it is Case 03580410.

I submitted my case May 24, and the first response was received May 25. The first person, JW, sent an email asking me to clear my cache and change my browser. I cleared the cache, used multiple browsers, and even tried with different packages in my org. All had the same problem.

May 27, JW tried to call me, but I was unavailable. (Good follow-up.) He also sent an email, and I promised to get back to him. I replied the next day and told him that the problem occurred even on different computers, with different browsers, and different packages. He quickly replied and asked to login to the org to try to recreate the issue.

The next step was for us both to login to the org while on the phone. He verified that the problem was happening, and we noticed something interesting:

Clicking “View Installed Packages” gives a URL like …/0A3?setupid… and clicking Manage Licenses gives a long URL including ?allPackageId=033600000004Pjn. The broken link was https://na7.salesforce.com/033600000004Pjn. See anything there?

The “Back to Previous Page” link should have taken me back to the /0A3 page (exactly as the browser Back button did), but instead tried to show me the inner workings of a package, which Salesforce clearly cannot display.

JW suggested that this was a problem with the app, as the link was on a page managing licenses for two managed apps by the same publisher. I quickly explained that I had developed managed applications before and that I knew that this was a feature created by salesforce.com, and therefore salesforce.com was responsible for the broken link. He said that he understood and that he would escalate the case to Tier 2.

Quick recap so far: Salesforce Support has responded quickly, so they get good points for that, but I’ve not been available to talk. The support rep has tried everything he and I can think of, and we have found a problem in a link that directs to the wrong URL. I’m up to Tier 2.

At this point, I don’t have any more communication until June 8. I’m not fussed, as I know it’s a real issue, but I have a good workaround (use the Back button).

June 8, GE sends me an email saying that he reproduced the error and escalated it to Tier 3 for further investigation. I thanked him and said that it felt bittersweet because I had found a real problem and it’s no fun when my beloved Salesforce CRM has a bug. He validated my feelings. (Warm fuzzies all around.)

The next day, GE sends an email. This is the text:

An issue tracking number has been attached to your case, and is awaiting prioritization by R&D. I will receive updates on this, but the timeline for rollout may not be known for some time. Just wanted to let you know that it has been queued up for a fix, and I will let you know more when I know. Feel free to check in any time, and also bear in mind that there is a very good workaround for this, being the browser back button J We’re just required to mention workarounds, even though I know you know this. Let me know if you need anything else.

Music to my ears! An issue tracking number! R&D looking into it! I had found a real bug and it would be fixed!

The point of all this is to say that for all the complaints (many justified) that people have about salesforce.com support (why do they automatically want login access when the problem sometimes has nothing to do with anything in an org???) there are times that they really shine.

Thank you, JW and GE. At least I know a fix is coming.

Extended NA1 Maintenance Next Weekend (3/20)

March 13, 2010 · Filed Under Spring 10, salesforce.com · 1 Comment 

Next weekend, March 20, 2010, Salesforce NA1 will be down for an extended (8-hour) maintenance window - the longest in memory - from 7pm 3/20 to 3am 3/21 (All times PST).

Overlapping this is another 8-hour window for NA0 (SSL) starting two hours earlier.

Also starting at 7pm PST, EU0 (EMEA) will be down for 2.5 hours.

All other instances will be down for 30 minutes, from 9pm PST.

As the email from salesforce.com explains:

 

Dear Salesforce Administrator,

At salesforce.com, customer success through system availability and reliability is our top priority. As part of our ongoing plan to deliver high availability and reliability, we are enhancing our service infrastructure on our NA1 instance.

Please be aware that salesforce.com will be performing scheduled maintenance that will extend beyond standard system maintenance windows. The current scheduled window is:

Saturday, March 20th, 2010 from 7:00pm PST to Sunday, March 21st at 3:00am PST

During this time, the salesforce.com NA1 service will be unavailable. Users attempting to access the service during this time will be presented with a scheduled maintenance notification page.

We appreciate your patience during this maintenance window.

Best regards,
-salesforce.com Support


Copyright 2000-2010 salesforce.com - All rights reserved - Various trademarks held by their respective owners
Salesforce.com, One Market Street, Suite 300, San Francisco, CA 94105
NA0 (SSL) March 20, 5:00 pm PDT -
March 21, 1:00 am PDT
The NA0 instance will have maintenance performed at this time. The instance will be unavailable for the duration of the maintenance.
EU0 (EMEA) March 20, 7:00 pm PDT -
March 20, 9:30 pm PDT
The EU0 instance will have maintenance performed at this time. The instance will be unavailable for the duration of the maintenance.
NA1 March 20, 7:00 pm PDT -
March 21, 3:00 am PDT
The NA1 instance will have maintenance performed at this time. The instance will be unavailable for the duration of the maintenance.
All instances March 20, 9:00 pm PDT -
March 20, 9:30 pm PDT
The Salesforce.com Technology will be performing maintenance at this time. During this time all instances will be unavailable for the duration of the maintenance.

Get Documents and Attachments out of Salesforce

February 8, 2010 · Filed Under Configuration, Spring 10, Tips and Tricks, salesforce.com · 3 Comments 

As Content will be included in all Salesforce licenses (for completeness, I'll add 'to some degree') with the Spring '10 release, orgs will be faced with the daunting prospect of getting their documents and attachments out of Salesforce and into Content.

I had this problem when Content was first released and I was asked to be one of the first SysAds to use it. At the time, we used Solution 1 (below), but since then, other products have been released to help with this.

Why is it even an issue?

  • Surely we can download each file? Yes, but who wants to?
  • Can't we do a Data Export and then upload those to Content? Yes, but all the files are renamed with their 15-character Ids, making renaming them all-but-impossible.

salesforce.com and DreamFactory to the rescue!

Solution 1

Summary: Use a script to rename all exported files. A (wonderful!) salesforce.com employee, Nick Marcantonio, wrote a Perl script to perform the transformation. Here it is, in all its glory:
# Nick Marcantonio
# nmarcantonio at salesforce.com
# 08/07

$file = 'Attachment.csv';

open (F, $file) || die ("Could not open $file!");

$line = <F>; #read first line which is nothing but column headers
while ($line = <F>)
{
  ($id,$name) = split ',', $line;
  chomp($id);
  $id =~ s/\"//g;
  chomp($name);
  $name =~ s/\"//g;
  
  #print "$id : $name\n";
  
  $result = rename($id, $name);
  #print "$result\n";
}

close (F);
The instructions:
If you've done a data export you've noticed that all attachments are placed in the Attachments subfolder and named with their salesforce ID, not the actual file name or extension. One must then consult the Attachment.csv file included in the data export to find the name associated with the ID and rename the file. Attached to this solution is a Perl script that will rename all of the exported attachments to their proper names. Please follow these steps to run this:

1. Perform a data export and unzip the resulting zip file
2. Launch the data loader and export from the Attachments table ONLY the Id and Name column. This file must be named Attachment.csv.
3. Install ActivePerl. This will allow perl scripts to be run on a Windows machine. ActivePerl is available here (http://www.activestate.com/activeperl).
4. Copy the Attachment.csv file and the attached AttachmentParser.pl file to the Attachments subdirectory of the data export.
5. Double-click on AttachmentParser.pl.

All of the files named with their salesforce IDs will be renamed with their proper names and file extensions.

(This solution will work for documents as well. Follow the same procedure and be sure to name the extract from the Documents table Attachment.csv) 

Note: This will not preserve folders, as far as I know. You may be able to recreate this by exporting the Folder table and doing some work on that, as the Document table does include a FolderId column.

A heartfelt thank-you to Nick Marcantonio for his help!

Solution 2

Install DreamFactory's FREE DreamTeam Document Management application from the AppExchange to drag-and-drop your Documents to your desktop.
This doesn't work with Attachments, though, so you may need to use another method for them.

Please let us know how it goes - good luck and enjoy Content!

New Developer Library Released

Today, Developer Force (http://developer.force.com) released its new library. Here are a few of them. All can be found at http://wiki.developerforce.com/index.php/Documentation.

Workbook
http://www.salesforce.com/us/developer/docs/workbook/index.htm

Fundamentals
http://www.salesforce.com/us/developer/docs/fundamentals/index.htm

Cookbook
http://www.salesforce.com/us/developer/docs/cookbook/index.htm

Apex Advanced Code Example
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_shopping_cart_example.htm
https://sites.secure.force.com/appexchange/listingDetail?listingId=a0N30000001saDCEAY

And many more to come!

Next Page »