Excel file dam upload issue

[Balu_M]

Hi ,

I am uploading .xls file(which is created using POI API) to DAM using AssetManager API , file uploading to DAM but when we download the file its not opening. its showing error "content corrupted message".

I have updated MIME type but issue not resolved. can you help me to resolve this issue.

Log data while uploading to DAM:

10.11.2017 16:42:26.709 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.adobe.xmp.worker.files.ncomm.XMPFilesNComm [PERF][EXECUTE_START] | /var/tmp/cq-dam-wf-file6516477676489263172.tmp | XMP extraction

10.11.2017 16:42:26.723 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.adobe.xmp.worker.files.ncomm.XMPFilesNComm [XMPFilesProcessor-4127] PROC: Executing request extractXMP

10.11.2017 16:42:26.723 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.adobe.xmp.worker.files.ncomm.XMPFilesNComm [PERF][EXECUTE_END] | /var/tmp/cq-dam-wf-file6516477676489263172.tmp | XMP extraction

10.11.2017 16:42:26.725 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.adobe.granite.asset.core.impl.metadata.xmpjcr.XmpToJcrVisitor No custom schema available, using default XMP schema service

10.11.2017 16:42:26.738 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.video.FFMpegThumbnailProcess execute: asset [/content/dam/report/poi-test.xls] is not of a video mime type, asset ignored.

10.11.2017 16:42:26.739 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.process.CommandLineProcess execute: mime type [application/vnd.ms-excel] of asset [/content/dam/report/poi-test.xls] is not in list of accepted mime types [[image/eps, image/x-eps, application/postscript, application/eps, application/x-eps]], ignoring.

10.11.2017 16:42:26.739 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.video.FFMpegTranscodeProcess execute: asset [/content/dam/report/poi-test.xls] is not of a video mime type, asset ignored.

10.11.2017 16:42:26.743 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.gfx.CommonsGfxRenderer gfx: cannot get image for rendition: /content/dam/report/poi-test.xls/jcr:content/renditions/original

10.11.2017 16:42:26.743 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.gfx.CommonsGfxRenderer gfx: cannot get image for rendition: /content/dam/report/poi-test.xls/jcr:content/renditions/original

10.11.2017 16:42:26.743 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.gfx.CommonsGfxRenderer gfx: cannot get image for rendition: /content/dam/report/poi-test.xls/jcr:content/renditions/original

10.11.2017 16:42:26.750 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.gfx.CommonsGfxRenderer gfx: cannot get image for rendition: /content/dam/report/poi-test.xls/jcr:content/renditions/original

10.11.2017 16:42:26.754 *INFO* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.pim.impl.sourcing.upload.process.ProductAssetsUploadProcess payload path :/content/dam/report/poi-test.xls/jcr:content/renditions/original

10.11.2017 16:42:26.757 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.process.SendTransientWorkflowCompletedEmailProcess Cannot get email id of useradmin

10.11.2017 16:42:26.757 *WARN* [JobHandler: /etc/workflow/instances/server0/2017-11-07_1/update_asset_28:/content/dam/report/poi-test.xls/jcr:content/renditions/original] com.day.cq.dam.core.impl.process.SendTransientWorkflowCompletedEmailProcess Did not send email. No recipient addresses available.

[smacdonald2008]

How are you uplaodin the file. Are you creating the file using the API and then manually uploading the Excel file?

[Balu_M]

Hi, i am creating excel using POI api and using AssetManager API i am uploading to AEM DAM.

Steps:

1. Create HSSFWorkbook object and update data.

2. Converted workbook object to InputStream object

3. Uploded to DAM using AssetManager API

[mjb54261515 · Accepted solution]

Hi ​

I understand what you are trying to do. To find out exactly whats wrong going on. Upload an .xls file manually and compare the node structure, properties of each node that you manually updated and programmatically created asset. Then you can find out the differences. This generally happens when asset is not perfectly created.

MIME type/Internet media type for .xls file is as follows

I tried creating assetmanager and regular node API it worked. assetmanager make sure u are using correct mime type.

here is very good article using this.

Adobe Experience Manager Help | Uploading files to Adobe Experience Manager DAM using AssetManager A...

ref:

Programatically working with the DAM

Assets Supported Formats