Getting File Extensions from a Folder

Just found this....

I was needing to find a way to pull out all of the file extensions in bulk so they could be imported into Salesforce in one way or another.

Simply open the command prompt and type the following

dir c:\users\josh\desktop\foldername /b /s >c:\users\josh\desktop\outputfile.txt

The /b gives you a 'bare' file with just the extensions and nothing else

The /s gives you all of the sub-folders within that folder that you are looking into

The '>c:\users\josh\desktop\outputfile.txt' outputs the file into a text document

http://spreadsheetpage.com/index.php/tip/getting_a_list_of_file_names/

Excel Contains Formula

Just a quick little formula that checks to see if a cell contains specific text. This one checks to see if the cell contains the "@" sign, if it does then it puts an X in the cell if not then it will be left blank.

=IF(ISNUMBER(SEARCH("@",A2)),"X","")

Exporting Attachments from Salesforce.com

When you export attachments from Salesforce.com you can choose to include the attachments in the export however when SF exports the attachments it does not give you the actual files. What they give you is quite useless...

I found this tool that was put together by someone that wanted to extract all attachments from Salesforce and because they wouldn't give them in the data extract he created this tool.

Below is a link to download the tool called FileExporter. It works great!


https://sites.google.com/site/ezrakenigsberg/blog/fileexporterexportattachmentscontentordocuments