Page 8 of 9

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed May 15, 2013 8:30 am
by apsona
kelemvor - I doubt that this report is possible from within ShopAdmin, because it uses a 4-table chain: Categories, Products, Orders and line items.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed May 15, 2013 9:41 am
by kelemvor
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

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 9:27 pm
by grahamp
I'm now getting a blank screen on the following browsers:
  • Chrome version 27.0.1453.110 m
  • IE version 10.0.9200.16576
  • Firefox version 21.0
Is there anything that can be done?

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 10:22 pm
by apsona
grahamp - are you using https on your server? If so, would you know if the same problem arises without https?

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 10:29 pm
by grahamp
Yes. I checked and it's doing it with HTTP and HTTPS.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 10:46 pm
by apsona
That's puzzling. Have you checked in the developer console if there are any errors showing? It would particularly help to see what Google Chrome's developer console shows when you use HTTP only (no SSL).

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 10:54 pm
by grahamp
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

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 10:59 pm
by apsona
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.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Wed Jun 12, 2013 11:12 pm
by grahamp
Hmmmm....is the apsona.com website running? It doesn't seem like the scripts can be pulled from it.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 12:06 am
by apsona
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!

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 2:09 am
by grahamp
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

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 2:36 am
by apsona
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.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 2:42 am
by grahamp
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

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 2:49 am
by apsona
Are you sure you fixed just that one line? Is this a PHP error, or is it something you are seeing in the browser's error console?

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 2:58 am
by grahamp
Yip - replaced everything you've told me to.

The browser shows up blank and this is in the console.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 3:04 am
by apsona
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?

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 3:09 am
by grahamp
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">&nbsp;            <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 &copy; 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)}});

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 3:13 am
by apsona
Still not sure what's happening, but want to try something, so please try again - reload your page, and let me know what happens.

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 3:37 am
by grahamp
It's slow to load, but working!

Re: [MOD] Apsona ShopAdmin - import, export and reporting

Posted: Thu Jun 13, 2013 3:40 am
by apsona
Ok, that's good to know. SSL is definitely slower than plain HTTP, so I'm not surprised about the speed.

Thanks.