Excel file dam upload issue

Avatar

Avatar

Balu_M

Avatar

Balu_M

Balu_M

10-11-2017

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

mjb54261515

Avatar

mjb54261515

mjb54261515

11-11-2017

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

1346558_pastedImage_7.png

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

1346548_pastedImage_1.png

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

Answers (2)

Answers (2)

Avatar

Avatar

Balu_M

Avatar

Balu_M

Balu_M

10-11-2017

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

Avatar

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K

Avatar

smacdonald2008

Total Posts

12.7K

Likes

1.4K

Correct Answer

2.3K
smacdonald2008

10-11-2017

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