Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
VeMan1542VeMan1542 

Any kind of Tool for Converting 15-character IDs into 18 character IDs???

I have to do a lot of work with Salesforce data in Excel which is case-sensitivity challenged. I understand how to derive the 18 character ID from a 15 character ID, but I can't do that for hundreds or thousands of records one-by-one. I saw some posting about a plugin for Excel in the subject title which discussed a function called "GetID18". I thought the posting implied that this was an Excel plugin, but I can't find anything else about it.
 
Is this part of the Excel Connector? Where do I get the Excel Connector- it's not listed on the App Exchange. IS there is ANY kind of solution for this problem available anywhere? Please, somebody, let me know.
 
VeMan 
KristinFKristinF
You can use the Excel Connector for this.  Check out this link - http://blogs.salesforce.com/features/2006/05/excel_connector.html

Once you install the Excel Connector, the function you are looking for is "FixID".  It's one of the functions listed in the Help for the Excel Connector.
VeMan1542VeMan1542

Thank You

 

from the bottom of my heart

 

V
kevinedelmannkevinedelmann
If you are doing updates to many records that already exist in salesforce you may want to look at the ApexDataloader (if you have API access) as it has the ability to Update existing records while Inserting new records at the same time.

Also, it has the ability to update records, without the SF ID, if you have another field designated as an ExternalID.  This has come in very handy for me when needing to keep data in sync.
ezradataezradata

I say, implement the 15-to-18-char conversion in a formula field and circumvent code entirely: http://tinyurl.com/15CharFix

 

Id & 
MID( 
    "ABCDEFGHIJKLMNOPQRSTUVWXYZ012345", 
    MIN(FIND(MID(Id, 5, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 16 + 
    MIN(FIND(MID(Id, 4, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 8 + 
    MIN(FIND(MID(Id, 3, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 4 + 
    MIN(FIND(MID(Id, 2, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 2 + 
    MIN(FIND(MID(Id, 1, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 1 + 1, 
    1) & 
MID( 
    "ABCDEFGHIJKLMNOPQRSTUVWXYZ012345", 
    MIN(FIND(MID(Id, 10, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 16 + 
    MIN(FIND(MID(Id, 9, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 8 + 
    MIN(FIND(MID(Id, 8, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 4 + 
    MIN(FIND(MID(Id, 7, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 2 + 
    MIN(FIND(MID(Id, 6, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 1 + 1, 
    1) & 
MID( 
    "ABCDEFGHIJKLMNOPQRSTUVWXYZ012345", 
    MIN(FIND(MID(Id, 15, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 16 + 
    MIN(FIND(MID(Id, 14, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 8 + 
    MIN(FIND(MID(Id, 13, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 4 + 
    MIN(FIND(MID(Id, 12, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 2 + 
    MIN(FIND(MID(Id, 11, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1) * 1 + 1, 
    1)