You need to sign in to do that
Don't have an account?
The_Phoenix
Weekly Data Export and Attachments & Documents
I've requested a Data Export, but the attachments and documents in the zip file are useless... My guess is that they are probably encoded, but there's no file type attached to it (such as .uue). How can we extract these files directly on Windows?
Thanks
Good catch. This is another breakage of the weekly backup which dates all the way back to the Winter04 release (last november).
While it doesn't help us much, the problem isn't that the attachments are encoded, but that the names have lost the extension that allows Windows to open them.
Prior to the Winter04 release (last november) the attachments had names like:
00P00000003qpxw_eBIS Customers by Industry and Country.xls
Since that time ... as you have noted ... they have become useless. That same attachment is now named:
00P00000003qpxwEEA
You can no longer select a file based on it's real name, nor can you determine what type of file it is, or open it.
Theoretically, you could use one of these files by
1) Finding the file in the attachments.csv file
2) Determining the file name and the id
3) Finding the file whose name is equal to the id
4) Renaming the file to the filename
5) Opening it
In my opinion, this is awful. I am embarassed not to have noticed the change (since I now have more than six months of backups that are less useful), but I'm also disturbed that we had no notice of this major change.
Good catch. This is another breakage of the weekly backup which dates all the way back to the Winter04 release (last november).
While it doesn't help us much, the problem isn't that the attachments are encoded, but that the names have lost the extension that allows Windows to open them.
Prior to the Winter04 release (last november) the attachments had names like:
00P00000003qpxw_eBIS Customers by Industry and Country.xls
Since that time ... as you have noted ... they have become useless. That same attachment is now named:
00P00000003qpxwEEA
You can no longer select a file based on it's real name, nor can you determine what type of file it is, or open it.
Theoretically, you could use one of these files by
1) Finding the file in the attachments.csv file
2) Determining the file name and the id
3) Finding the file whose name is equal to the id
4) Renaming the file to the filename
5) Opening it
In my opinion, this is awful. I am embarassed not to have noticed the change (since I now have more than six months of backups that are less useful), but I'm also disturbed that we had no notice of this major change.
-----
Scot, thanks for the quick reply, but that's quite ridiculous... I had already figured the work-around, but I didn't thought that there wasn't anything smarter than this. I guess I should log a case if I want decend backup?
Thanks again!
Agreed ... it is pretty appalling.
I just logged a case myself.
See the admin preview for the Winter release. http://www.salesforce.com/newsevents/winter05/index.jsp
Benji,
Thank you for the research and answers.
I can't help but note that
> the changed naming of the attachments was not described in either the admin preview nor the final release documents.
> while the information is available in the csv file to alter the attachments, the change does make it much more difficult to access them
> the attachments.csv file as an index to the attachments is useful, but is not new. It existed before in the same form as today
Anyway, I'll pursue it further outside the forum ...
Scot
Response from support:
Thank you for your feedback. This is a known issue that is currently being prioritized on our product roadmap. I have logged your case against this known issue.
We value each and every request submitted by our customers and make all efforts to include your request in future releases.
At the present time, you have to use the documents.csv and the attachments.csv files to get the file type extensions. Using the IDs to match the proper file to the proper file type extension, you can rename the links with the proper extensions.
Thank you,