Facebook
Salesforce
Alltop
Zipcar
Get Documents and Attachments out of Salesforce
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!
Filtered Lookups, Validation Rules, and Order of Execution
Reading the cheatsheet for Filtered Lookup (beta), I noticed an interesting line:
Lookup filters function similarly to validation rules when you save a record. That is, actions that cause related records to save, such as changes to a roll-up summary fields, also trigger the lookup filters on the related record and block the save.
The implications for this are massive. Let's explore two examples:
Example 1: Filter as Validation Rule from Parent Record
- We create a lookup on a Child object to Parent.
- We filter the lookup to EXCLUDE Parent.Status = 'Closed' (Parent.Status is only Open or Closed.)
- We can edit the Child records as long as the Parent Status is not Closed.
- When Parent.Status is changed to Closed, existing related Child records are not affected...
- BUT if we attempt to edit a Child when the Parent is Closed, Force.com will throw an error (which we can customize) beause that the Lookup is invalid.
- (and clearly we cannot add new Child records either)
Conclusion: Thus, Filtered Lookups act much like Validation Rules. A quick experiment shows that Filtered Lookup errors actually fire before Validation Rules.
Example 2: Filter as Validation Rule on Roll-Up Summary (from Child Record) - what the line above was referencing
- Use the above example, but change the lookup to a master-detail relationship
- Create a Roll-Up Summary field to count all child records
- Prevent saving more than 10 child records for one parent record
Here, we have triggered a filter error without touching a parent record, yet we throw an error based on a value on the parent record.
This second example is significant because we could already prevent more than 10 child records from saving, but doing so required a Roll-Up Summary field on the parent object AND a Validation Rule on the child object. Now we can replace the Validation Rule with the Lookup Filter, though we still need the Roll-Up Summary field. Whether or not this simplifies things is definitely up for debate...
Conclusion
This is a very powerful feature! Thanks to salesforce.com for rolling it out, even in beta form.
Real world example: The above example would be great for Time Sheet Entry and Time Sheet Header objects, as they would create, in effect, a validation rule on the Header record preventing editing of any child records. Awesome!
For further reading, check Salesforce Help's Lookup Filters examples.
Preparing a New Org
With the impending arrival of the Winter 2010 (aka 162 or Winter'10) edition of Salesforce CRM, as with every other release, comes a prerelease org. (You can get one at https://www.salesforce.com/form/trial/prerelease_winter10.jsp.)
Every time one encounters a fresh org, there are maintenance tasks to perform. I usually go through an org (whether a Developer Edition org or a Prerelease version) and do the same tasks, generally in no particular order. This time, however, I wrote down what I did as I did it. Looking at the list, it's hardly in any "best practices" order at all - it's just how I did it.
There's no need to follow every step, and it is not a complete list of all possibilities, but this should give you some idea of the possibilities and available tweaks: (*** indicates some of the new features in WInter '10)
- Save login with 1Password/Roboform
- Reset (Set) Security Token
- Administration Setup | Security Controls
- Session time 8 hrs
- Passwords never expire
- Create Record Types (and Business Processes) for Lead, Opportunity, Case
- (Campaigns were not enabled in this prerelease org) - would have configured them here, similarly
- Activities section: Calendar link on sidebar
- Download latest versions of Connect for Outlook, Office Edition
- Opportunities:
- Enable Similar Opportunities
- Enable Opportunity Teams
- Create Account Master Record Type
- Enable Account Teams
- Create Contact Master Record Type
- Note: Asked to add to page layout. Not asked for Opportunities.
- Enable Case Teams
- Enable Public Solutions
- Solutions:
- Enable Solution Browsing
- Enable Solution HTML
- Could have created a Solution Process & Record Type
- Did not enable multilingual solutions
- Enable Self-Service
- Enable Web-to-Case
- Create default Owner, etc (auto prompted)
- Enable PRM and Partner Portal (though have no licenses)
- Salesforce to Salesforce
- Enabled S2S
- Set up S2S Connection Finder ***
- Added fields to page layout - Kept read-only for all profiles except System Administrator
- Enable Public & Private Tags
- Enable Console for all Profiles
- Search Settings - Enable Enhanced Lookup & Auto-Complete
- User Interface
- Separate loading of related lists
- Spell Checker on Tasks & Events
- Collapsible Sidebar
- Custom Sidebar on all Pages
- Enhanced Profile Management ***
- Set myself as default Workflow User
- Looked at Develop | Custom Settings ***
- Created a Default Queue and added myself
- Set all Sharing Rules to Private
- Update Home Page to the way I like it
- Order of wide section (top down): Calendar, Tasks, Items to Approve, Dashboard
- No changes to narrow section
Other things that may be possible in other orgs:
- Enable Customer Portal
- Customize Campaigns
- Set up Sites
Again, this is not meant to be a complete list. Also, it is not intended to be a how-to; for more information you may search the Help link at the top of every org page, check Salesforce Community, or Developer Force.
Happy configuring!
Show Current Year Using Only Visualforce
While perusing some websites, looking at html code, I saw something interesting:
A company had used Javascript to update the copyright date of its website using Javascript. This is the code.
Copyright © 2005-<script type="text/javascript">document.write(new Date().getFullYear());</script> This Company. All rights reserved.
Of course, as a Force.com developer, I prefer to use Visualforce and Apex over Javascript (as it makes the client thinner - thick clients are not my preferred modus operandi).
This is the Visualforce version of the above code; it requires no Apex controller nor extension, and will always display the current year.
Copyright © 2005-{!year(today())} This Company. All rights reserved.
Feel free to use this snippet in your Visualforce pages (including Sites) to ensure that on January 1, you won't look foolish for failing to (shudder) manually update the footer in your site template.
Happy coding!