On my extjs webclient I hit a button and it downloads an excel template and populates data. When I click on the CHROME popup to open excel file, it gives me the excel error message below. Does anyone know how I can fix this?The actual file looks fine to me.
When trying to download Excel templates from the Excel-Entity Mappings screen, following error occurs Error: Mixed content: Load all your resources via HTTPS to improve the security of your site.
Excel Template Download Error
Download Zip: https://jinyurl.com/2vCSLp
Dear Ericsorry: It is a very very long time ago since there was the need to upload the EXCEL macro. I have no idea about the error message.Normally you get more \\\"hints\\\" from SAP (what does error message \\\"1\\\" means (as part of the text \\\"\\\"Error when uploading file : 1\\\"). One topic might be: there is a \\\"customizing\\\" missing. You need to make sure that you can store \\\"Xls\\\" files in DMS. Without that you can not store the \\\"Xls\\\" file in SAP.With out successful upload you can not use the output vaiant \\\"EXCEL\\\". You will always get the error message as mentioned by you. And \\\"yes\\\": the XLS file is uploaded in DMS (if you would succeed) and therefore eror message as mentioned by you should be solved.C.B.\",\"author\":\"username\":\"christoph.bergemann\",\"displayName\":\"Christoph Bergemann\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"eric.sun2\",\"displayName\":\"Eric Sun\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10340481,\"creationDate\":1381213399000,\"activeRevisionId\":10983689,\"lastActivity\":1381213400000,\"parentId\":10340047,\"originalParentId\":10339216,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 10339216, plug: "cg02---error-loading-the-excel-template-from-dms", votes: 0, questionTitle: "CG02 - Error loading the Excel template from DMS", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"10339154\":\"rootParentId\":10339154,\"commentsCount\":4,\"comments\":[\"body\":\"Dear Ericsorry: It is a very very long time ago since there was the need to upload the EXCEL macro. I have no idea about the error message.Normally you get more \\\"hints\\\" from SAP (what does error message \\\"1\\\" means (as part of the text \\\"\\\"Error when uploading file : 1\\\"). One topic might be: there is a \\\"customizing\\\" missing. You need to make sure that you can store \\\"Xls\\\" files in DMS. Without that you can not store the \\\"Xls\\\" file in SAP.With out successful upload you can not use the output vaiant \\\"EXCEL\\\". You will always get the error message as mentioned by you. And \\\"yes\\\": the XLS file is uploaded in DMS (if you would succeed) and therefore eror message as mentioned by you should be solved.C.B.\",\"author\":\"username\":\"christoph.bergemann\",\"displayName\":\"Christoph Bergemann\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"eric.sun2\",\"displayName\":\"Eric Sun\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10340481,\"creationDate\":1381213399000,\"activeRevisionId\":10983689,\"lastActivity\":1381213400000,\"parentId\":10340047,\"originalParentId\":10339216,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 2, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Dear EricAssumption_ you have \\\"copied\\\" Standard \\\"EXCEL\\\" output variant to folder \\\"OUTVAR\\\" and renamed itIf this assumption is correct you need to check customizing. Regarding output variant \\\"EXCEL\\\" some help is provided there. Explanaiotn is given there how to handle the \\\"EXCEL\\\" macro which you need (to be stored in e.g. DMS).If assumption is wrong: you need to ask your developer of output variant (which function module to use; which EXCEL macro needed; how to prepare it etc.)C.B.\",\"author\":\"username\":\"christoph.bergemann\",\"displayName\":\"Christoph Bergemann\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10339154,\"posted\":1381161193000,\"votes\":2,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"This is a long shot, but we ran into this as well and it was just an authorization issue. Did you run and SU53 or have the user run an SU53 to see if that might be it?\",\"author\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":10554949,\"posted\":1388778063000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/10339216/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/10339216/answers.rss', answersAndComments: '/feed/10339216/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Eric Sun Oct 07, 2013 at 03:45 PM CG02 - Error loading the Excel template from DMS 117 Views Follow RSS Feed Hi Expert,
The Offline Excel Feature is a downloadable excel template of the UDS Performance Report forms where you can perform data entry without being connected to the internet and upload the completed Excel file to the EHBs.
We have a problem using our uploaded Excel templates. When we try to fill them with data from our SQL statement or another data Source,the downloaded Excel file is just empty (neither data nor things from the template) and has the name of the BI-Publisher folder.Before the file opens there is an errormessage: 'The file you are trying to open, '... .xls', is in a differnet format than specified by the file extension. Vertify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? Yes/No/Help' 2ff7e9595c
Comments