Post by apsona » Wed May 15, 2013 8:30 am

kelemvor - I doubt that this report is possible from within ShopAdmin, because it uses a 4-table chain: Categories, Products, Orders and line items.

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by kelemvor » Wed May 15, 2013 9:41 am

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

Active Member

Posts

Joined
Fri Oct 12, 2012 6:58 am

Post by grahamp » Wed Jun 12, 2013 9:27 pm

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?

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Wed Jun 12, 2013 10:22 pm

grahamp - are you using https on your server? If so, would you know if the same problem arises without https?

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Wed Jun 12, 2013 10:29 pm

Yes. I checked and it's doing it with HTTP and HTTPS.

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Wed Jun 12, 2013 10:46 pm

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).

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Wed Jun 12, 2013 10:54 pm

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

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Wed Jun 12, 2013 10:59 pm

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.

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Wed Jun 12, 2013 11:12 pm

Hmmmm....is the apsona.com website running? It doesn't seem like the scripts can be pulled from it.

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 12:06 am

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!

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Thu Jun 13, 2013 2:09 am

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

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 2:36 am

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.

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Thu Jun 13, 2013 2:42 am

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

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 2:49 am

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?

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Thu Jun 13, 2013 2:58 am

Yip - replaced everything you've told me to.

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

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 3:04 am

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?

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Thu Jun 13, 2013 3:09 am

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)}});

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 3:13 am

Still not sure what's happening, but want to try something, so please try again - reload your page, and let me know what happens.

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am

Post by grahamp » Thu Jun 13, 2013 3:37 am

It's slow to load, but working!

New member

Posts

Joined
Sun May 27, 2012 5:08 am

Post by apsona » Thu Jun 13, 2013 3:40 am

Ok, that's good to know. SSL is definitely slower than plain HTTP, so I'm not surprised about the speed.

Thanks.

New member

Posts

Joined
Sat Jan 15, 2011 3:23 am
Who is online

Users browsing this forum: No registered users and 3 guests