OK, so I took the default report called Items Sold Last 30 Days and just added the category column and it's exactly what I needed. However, I tried to export the file to Excel and it looks like crap.
Every field is surrounded by \" \" So it looks like:
Name Qty Category
\"Item 1\" \"5\" \"1\"
\"Item 2\" \"13\" \"2\"
[/code]
In the report on the screen, the category shows the actual Name of the category which is what I want. How do I make the export contain the name and not the number.
Also, how do I get rid of all the \" things all over the place?
Thanks
Every field is surrounded by \" \" So it looks like:
Code: Select all
\"Item 1\" \"5\" \"1\"
\"Item 2\" \"13\" \"2\"
[/code]
In the report on the screen, the category shows the actual Name of the category which is what I want. How do I make the export contain the name and not the number.
Also, how do I get rid of all the \" things all over the place?
Thanks
With and without HTTPS comes up with the same erros:
[blocked] The page at https://xxxxx.co.za/admin/apsona_index. ... 5fd119d22e ran insecure content from http://ajax.googleapis.com/ajax/libs/jq ... ery.min.js.
apsona_index.php:1
[blocked] The page at https://xxxxx.co.za/admin/apsona_index. ... 5fd119d22e ran insecure content from http://shopadmin-svc.apsona.com/ec/open ... ona.min.js.
apsona_index.php:1
Uncaught ReferenceError: $ is not defined apsona_index.php:37
No, not so. That's the issue right there: your main page xxxxx.co.za (apsona_index.php) is being run under https. Therefore, Google Chrome expects every script/css/image loaded by that page to be loaded using https. But shopadmin-svc.apsona.com does not support HTTPS (we don't have an SSL cert there). So Google Chrome blocks the request, and then of course everything goes to hell.
Try this: In the file apsona_config.php, replace the line
define ('APSONA_BASE_URL', 'http://shopadmin-svc.apsona.com');
with the line
define ('APSONA_BASE_URL', 'https://service.apsona.com');
Please post your results.
Thanks!
define ('APSONA_BASE_URL', 'http://shopadmin-svc.apsona.com');
with the line
define ('APSONA_BASE_URL', 'https://service.apsona.com');
Please post your results.
Thanks!
Still nothing
[blocked] The page at https://xxxx/admin/apsona_index.php?tok ... c913f11df2 ran insecure content from http://ajax.googleapis.com/ajax/libs/jq ... ery.min.js.
apsona_index.php:1
Uncaught ReferenceError: $ is not defined apsona_index.php:37
Failed to load resource https://service.apsona.com/ec/opencart1.5/apsona.min.js
Ah, but we are making progress. Please make the following changes to apsona_index.php: replace the line
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jq ... "></script>
with the line
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/j ... "></script>
Please post your results.
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jq ... "></script>
with the line
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/j ... "></script>
Please post your results.
It spit out these:
Code: Select all
Uncaught ReferenceError: ApsonaApp is not defined apsona_index.php:39
Failed to load resource https://service.apsona.com/ec/opencart1.5/apsona.min.js
If you simply paste this URL https://service.apsona.com/ec/opencart1.5/apsona.min.js in your browser's URL, what do you see?
A page full of lots of text.
Code: Select all
/**
*
* ---------------------------------------------------------------------------------------------------
* Copyright (c) 2010 apsona.com
* All rights reserved
* You may not modify, redistribute, reverse-engineer, decompile or disassemble this software product.
* Please see http://apsona.com/pages/ec/tos.html for full copyright details.
* ---------------------------------------------------------------------------------------------------
*
*/
var ApsonaAppLoader=function(B){var E=B.appName||"zencart";var D=B.apsonaVersion;var I=B.picklists;var F=B.backendVersion;var H=B.bodyTemplate||' <div class="sf-banner"> <a href="http://apsona.com" border="0" target="_new" style="position: absolute; top: 5px; left: 5px;" title="Link to apsona.com (opens in new window)"> <img border="0" src="__1/img/apsona_125x30.png"/> </a> <span class="sf-welcome-msg">Hi, <span class="sf-username">ShopAdmin User</span></span> <div class="sf-banner-topright"> <span class="sf-pseudolink ap-sa-accountinfo" title="Show account information">Account info</span> <span class="sf-pseudolink sf-feedbacklink" title="Send feedback to the Apsona team">Feedback</span> </div> <h1 style="text-align: center" class="sf-apptitle">Apsona ShopAdmin</h1> <div id="mainMenuBar"></div> <div id="ap-lang-sel-wrap"> Language: <select id="ap-lang-sel"></select> <span class="sf-icon-help"> <span>Choose the language in which to show the name, description, category and metadata for product records.</span> </span> </div> </div> <div id="sf-content-pane"></div><div class="ap-footer">version <span class="ap-versionstring"></span><br/>copyright © apsona.com 2010<br/>all rights reserved</div> <form name="sf-default-form" method="post" action="#" target="_blank" style="display: none;"> <input name="sessionId" type="hidden" value="" /> <input name="parameters" type="hidden" value="" /> </form>';function G(L,M){var J=L&&L.length>=1?L[0]:null;if(J){var K=L.slice(1);jQuery.getScript(J,function(){G(K,M)})}else{setTimeout(M,100)}}var C=["cs","da","de","es","fr","it","nl","no","se"];var A={};(function(){var M,J=/\+/g,K=/([^&;=]+)=?([^&;]*)/g,N=function(O){return decodeURIComponent(O.replace(J," "))},L=window.location.search.substring(1);while(M=K.exec(L)){A[N(M[1])]=N(M[2])}})();this.init=function(M,N,Q,R){$("head").append('<link rel="stylesheet" href="'+M+"/css/apsona."+D+'.min.css" />');document.body.innerHTML=H.replace(/__1/g,M);var P="v"+(F||"1.0")+"-b"+D;$(".ap-versionstring").html(P);var J={loc:window.location.href.replace(/https?:\/\//i,""),ua:navigator.userAgent,pfx:R};var K=A.languageId;var T=null;if(K&&I&&I.language){for(var S=I.language.length-1;S>=0;S--){if(I.language[S].value==K){break}}if(S>=0){T=I.language[S].code.toLowerCase()}}else{if(I&&I.language.length<=1){T=I.language[0].code.toLowerCase()}}var L=[M+"/ec/"+E+"/apsona-ec."+D+".min.js",M+"/app/app_ec/"+E+"/"+N+"/js/app-all.js"+(M.indexOf("?")>=0?"&":"?")+jQuery.param(J)];if(T&&C.indexOf(T)>=0){L.splice(1,0,M+"/js/lang/"+T+".js")}function O(){var V="";if(typeof (sf)=="object"&&typeof (sf.App)=="object"){try{sf.App.initialize(M,N,Q,I);return }catch(U){V=U.name+": "+U.message;$.get(M+"/app/app_ec/"+E+"/"+N+"/js/log.js",{action:"loadFailed: "+V.substring(0,400)},function(){});throw U}}}G(L,O)}};var ApsonaApp=new function(){var A="1103152126";this.init=function(D,C){var B=new ApsonaAppLoader({appName:"opencart1.5",apsonaVersion:A,picklists:D.dbInfo.picklists,backendVersion:D.addonVersion});B.init(D.apsonaBaseURL,D.appId,C,D.dbInfo.tablePrefix)}};jQuery(function(){if(jQuery.browser.msie){setTimeout(function(){document.body.innerHTML="<h1>Apsona ShopAdmin does not yet fully support Internet Explorer. <br/>Please try using Google Chrome, Mozilla Firefox or Apple Safari.</h1>"},700)}});
Who is online
Users browsing this forum: No registered users and 35 guests