Apsona ShopAdmin - a free tool for import/mass update/reporting

Ok, after using the above fix, I was able to access Apsona, and get as far as importing (a portion) of my product file. Of 2500+, after "Importing" only 900 (always 900), I get

Quote:

---

The server is not responding. Please check your network connection.
Status: error

---

. Then, if I cancel the upload, and try again, I get

Quote:

---

System progress bar unavailable: Maybe some other component is using it?

---

I've tried reading through the thread but haven't found (not yet at least) a reason or solution for this.

Delia, do you know anything about why this may be happening, or a possible fix?

There are previous posts along this line. As I said, I think that you have to start looking at server issues. I've never ever had any problem with Apsona and I have installed in it many carts.

Quote:

---

Originally Posted by delia

There are previous posts along this line. As I said, I think that you have to start looking at server issues. I've never ever had any problem with Apsona and I have installed in it many carts.

---

What server are you using. I'm using Namecheap, and until Apsona, I've never had an issue with them either. This is the first plugin that's ever caused any "server based" issues for me.

I work with clients all over the world on many different servers. Don't know that I've ever worked on their servers before. I have two servers of my own as well.

Here is a screen shot of the import page and the error I keep getting. As you can see, the import stops at 900, and then the error pops up. Every single time.

Attachment 14680

There is at least one post in this thread about this and I believe he solved it by moving to a new host.

Hi guys,

I am hoping that Apsona is monitoring this thread. I have now mailed them twice to resend me the installation files as I upgraded to Zencart 1.5.3 and need to reinstall this addon. Unfortunately I have not had any replies from them.

If they are not responding to this post, is anyone willing to share their copy of the installation files with me? You can send me a PM.

Louis, did you read any of the posts before now? Please go back and read post 608 and pick up the file in post 601. Once you make those changes, you should be good to go.

I'm not seeing this work with 1.5.4. Don't see why there would need to be changes but it has to be in the functions torvista. Have you checked it out yet?

Works for me in 1.54 locally, and I have not done anything extra.
Is this local, with a local configure?
Exactly what happens?

argh, tried a different browser and success. dummy.....

I too am having the problem with the blank page and the "loading" circle thingy'. I have Zen 1.51, godaddy servers and have my admin section set to secure in my configure file. My ShopAdmin used to work, and at some time in the past months it quit working. (I don't know if it's related or not, but my Authorize.net AIM module quit working also, but I was able to fix that by uploading the current v1.54 updated Authorize.net AIM files). I uploaded the apsona_functions.php from post #601. After I do that, the 'loading circle thingy' disappears, but page is still blank. Then, I believe that I tried every combination of the other recommended changes, including the changes at the top portion of the quote below. Actually, I don't know if I tried 'not' doing the changes at the top, and only doing the changes at the bottom (I assume there is a typo in that bottom code on post #608, but not post #592?). I see the changes are for v1.53, but I tried them all anyway. I also tried different browsers. I have looked through many pages of these posts, and I can't seem to find a fix. I could be missing something. Heck, I don't even know what version of mysql is being used. I know very little about the tech part of all of this. If anyone can give me some help, I would really appreciate it. If I missed something I will apologize in advance; I don't want to waste anyone's time because I didn't read something. I have 2000 products, and it's almost impossible to update products without spending a few days. Any help or advice would be greatly appreciated. Thanks!!

Quote:

---

Originally Posted by delia

To recap all the issues I've run into and their solutions:

all zen cart versions
secure admin: if you are running admin in secure mode two changes must be made to the files provided by apsona
apsona_config.php - change url to https://service.apsona.com
apsona_index.php - about line 42 change the url to https://ajax.googleapis.com/ajax/lib.../jquery.min.js (adding in the s for https)

1.5.3
Use the apsona_functions.php file posted twice in this thread most recently in post 601

Change the admin configure file to hard code in the admin path as it used to be done. This is not difficult simply comment out this line in yourShopAdmin/includes/configure.php:

PHP Code:

---

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/'); 


---

and replace it with this

PHP Code:

---

define('DIR_WS_ADMIN', '/your shop admin folder/');//steve apsona 


---

Then replace this line

PHP Code:

---

define('DIR_WS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTP_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/'); 


---

with this line

PHP Code:

---

define('DIR_WS_HTTPS_ADMIN', DIR_WS_ADMIN);//steve apsona 


---

(Commenting out means placing // with a following space before the line.)

If you have done both of these for 1.5.3 and still get an error, try using an entirely new browser to check again. If nothing works your hosting company may be the problem. I've tested this on three different servers including my own which is highly secure with many closed ports etc. Apsona does not require anything special in the way of a hosting environment but there was mention earlier in this thread of possible mysql problems with a hosting company. This should work on every server.

wtashby, I was not getting anywhere until I made those changes to the admin configure and was getting both loading with that error message and a load of a non-working apsona page where no data was displayed between the three servers. Let me know if this works for you.

---

I use Apsona a lot and have not had that problem now. I was having a similar problem a while ago, and what was happening is that my login to my Zencart Admin site had timed out, and Apsona could no longer access it. I am not a programmer, so I really don't understand how all of this works, but try to login to your ZenCart Admin site and then immediately go to Apsona to do what you need to do. If you get the swirly thing again, log out of your admin site and relog in and try it again.

Additionally, I have 10,000 SKUs, and the admin site times out before I can update all of them, so I have to create 4 seperate batches. While I very much appreciate all of the work that the Zencart team is doing, sometimes the "improvements" that zencart makes to improve security can actually be detrimental to some of us.

Hope that works.

Thanks SPembletonk, but that didn't work. Still get the swirly thing. Anyone else with suggestions would be greatly appreciated. Is there another plugin that will allow me to edit my price, qty, etc via a spreadsheet on my computer and then upload?

I am updating and redesigning my ZenCart to 1.5.4 from 1.5.1 and I want to use Apsona Shop Admin on it. I don't use it often but I find it extremely effective/time saving when I do. I found that I need to recover my welcome packet and my password (normally I keep things like that religiously but for some reason I didn't or it might have been that someone was helping me out and they didn't keep it when they put on the Apsona). I have used their form and written to them three times and called them once and left a message (I don't think that anyone answers that phone but they do have an answering machine). Is there some other way to contact them, or are they impossible to get hold of and I would be better off registering as another e-mail address and just make sure to keep all of the information myself this time? Or would that just cause more problems than it solves and I would be better off doing something else? Thank you.

Please refer back to post 608 for instructions. Apsona does not provide support.

Delia, I believe you. Perhaps my problem was that I believed this on their site:

Get Apsona ShopAdmin to work for you today!http://apsona.com/img/satisfaction-100.jpg

• ShopAdmin is offered free of charge for as long as you want to use it.
• Free e-mail support

...their words, not mine. I will go back and read your post #608 carefully. If anyone else knows how to contact them, please say so. Thanks.

I have tried contacting apsona, with no luck. I have also followed all instructions that I can in this post, but nothing I have tried has worked. I believe our best bet is to start a new thread about this specific problem. ZenCart Forum folks will eventually get to the bottom of this, I'm sure. They always do. Not that they're not helping here, but perhaps with another thread, specific to this problem, more people will see it. This is the best Forum I have ever been a part of, so I'm positive we will get this fixed. If anyone reading this starts a new thread or finds a solution, please IM me and let me know where the thread is located. Thanks!

They have not updated their site I think since it went up. They aren't supporting it. period . the . end.

Aspona was totally impressive in exporting my stuff from Zen Cart 1.39H and I know your probably tired of the questions, but if they would only come up with a working installation for 1.54 would not only be awesome, but worthy of a fee.. Great tool/Utility, change $20-30 per license and you might be surprised how many are willing to pay for something like this.

OK, off my soap box and back to reality.. Zen Cart 1.54, PHP 5.4, Godaddy Linux CPanel hosting.. Any chance of getting a working installation or at least one set of how to's all together?? All I get is "The server is not responding, Please check your network connection. Status Error." Going to blow away new 1.54 installation and start over, but really would love to have one set of working docs..

Thanks!!

Please folks - do go back at least 2 or 3 posts to see what has been posted before. Please refer back to post 608 for instructions. Apsona does not provide support and has totally dropped this. It can work - if you aren't capable of following instructions, contact me via pm.

Quote:

---

Originally Posted by apsona

harlyman - we haven't had any similar bug reports concerning the product import errors you mention, but we'll gladly investigate the issue. Please send us email at support (at) apsona.com with any sample data you can provide us.

As for the other question about price updates: if you're talking about the editing or "update all" features in ShopAdmin, they are performed via product id, so they will only affect the record(s) you have selected for editing.

Hope this helps.
Apsona

---

Hi,

I have installed the Apsona Shopadin program just fine in Zencart. However, everything works great with my attempting to import manufacturers and image urls until I click Import then I get the following message

:System Progress Bar unavailable. Maybe some other component is using it?" My hosting service advised it is not an issue on their end. I have tried firefox, opera and internet explorer and various different cvs files and it happens every time I click to finish the import.

I see others have had this issue. Please advise how this can be corrected.

What I am using is a csv file using comma field separator and I am trying to just add the manufacturers and their urls at this time.

Just to re-iterate, Shop Admin DOES work in Zen Cart 1.54, but not out of the box.
1) Sign up and get the base files
2) Go to the support page and get the update
3) and the 1dot5 update.
4) go to post 601 and get my update
5) Now on your pc, make a directory to work in and
extract the files from 1)
overwrite them with the files from 2)
overwrite them with the files from 3)
overwrite the file with the update from 4)
Thats the fileset you copy to your admin.

The first time you refresh the Admin, Shopadmin menu item should be installed in the Tools menu.
Open it. it should show a partially loaded window with the shop name at the top you used to sign up at Apsona.

Now it will not load completely until you make the change to the config file in post #608.

I have just done all this on a vanilla ZC154 on a local install and all is ok.

The only other issue may be if you are running your admin in ssl, then make the changes as noted in the same post#608.

While I wish Apsona would fight their corner a bit more as this software is superb, it's free and it works, they should change their site info though.

Aspona works great on 1.39H, all exported, build new Zen Cart 1.54 PHP5.3 on Godaddy hosted Cpanel, install Aspona including updates for 1.5 and does not work.

I get popup "The server is not responding. Please check you network connection. Status: error"

Cannot not find any references to this.

Yes I totally agree and you did help me get working!!

Quote:

---

Originally Posted by torvista

Just to re-iterate, Shop Admin DOES work in Zen Cart 1.54, but not out of the box.
1) Sign up and get the base files
2) Go to the support page and get the update
3) and the 1dot5 update.
4) go to post 601 and get my update
5) Now on your pc, make a directory to work in and
extract the files from 1)
overwrite them with the files from 2)
overwrite them with the files from 3)
overwrite the file with the update from 4)
Thats the fileset you copy to your admin.

The first time you refresh the Admin, Shopadmin menu item should be installed in the Tools menu.
Open it. it should show a partially loaded window with the shop name at the top you used to sign up at Apsona.

Now it will not load completely until you make the change to the config file in post #608.

I have just done all this on a vanilla ZC154 on a local install and all is ok.

The only other issue may be if you are running your admin in ssl, then make the changes as noted in the same post#608.

While I wish Apsona would fight their corner a bit more as this software is superb, it's free and it works, they should change their site info though.

---

Just implemented this on Z154 and it worked perfectly. It ended with the spinning circle in Chrome and Firefox which is just the java script error and resolution noted in your post #608.

Thanks Steve.

Paul

Hello there. Does anyone know where I can download Apsona Shopadmin for Zen Cart 1.5? It's not in the plugins section, and the Apsona.com website returns a 404 - Not Found page. If anybody has a copy of this I would greatly appreciate it!

Oh dear, oh dear. The site has been removed completely but looks to be reinstalled. I hope this is a temporary situation. The server that the plugins connect seems to be up because the plugin is still working. I'm sorry but without your site being registered on their servers, Apsona cannot work. If anyone who has registered needs the files because they have lost them or need the upgraded ones if you are upgrading from 1.3.9, pm me. Otherwise, please follow instructions in this thread.

If the site does not come up again at all, I'll package them altogether and post either a link to the package or else upload them to the plugins section. I don't really think it's appropriate to put in the plugins if no one new can use them though.

Quote:

---

Originally Posted by delia

I'm sorry but without your site being registered on their servers, Apsona cannot work.

---

Delia, I have not been able to get my Apsona ShopAdmin to work for some time now. It used to work great. I have tried to get it working, but still get the spinning circle thing. What do you mean it will not work without {my} site being registered on their servers? Thanks :) ps. Is there any other software/plugin that will allow me to export/import products, mass edit prices, etc. that you are aware of? Thanks!!!!!

Quote:

---

Originally Posted by Johnnycopilot

Is there any other software/plugin that will allow me to export/import products, mass edit prices, etc. that you are aware of? Thanks!!!!!

---

http://www.zen-cart.com/showthread.p...Support-Thread

Quote:

---

Originally Posted by mc12345678

http://www.zen-cart.com/showthread.p...Support-Thread

---

Thanks mc12345678 !

If you got it before now, your problems are addressed in this thread - from ssl errors to 1.5.4 etc. To get it originally you signed up on their website - essentially registering it. You have an account number in your config file.

Since the servers are still up, it's worth fixing your files rather than switching to ezpopulate as mc12345678 just suggested. Ezpopulate is extremely hard to use.

I just had a tweet only a few weeks ago from someone who works at Aspona and got no indication of problems. I'm thinking the website issue is temporary because they have a viable business doing other things besides this mod.

Thanks delia. I really appreciate it. I'll run through all of these fixes again and try to get it working. To my knowledge I've tried everything in this thread, but it's not unlikely that I did something wrong.. so, I'm guessing I didn't do something correct.. ha.. I'll give it another shot.

We have heard of it not working on some servers but I don't have any hands on experience with that.

Hi Delia- I read your comment here:
"Since the servers are still up, it's worth fixing your files rather than switching to ezpopulate as mc12345678 just suggested. Ezpopulate is extremely hard to use."

I guess there is something for everyone. I used apsona and liked it but found it very difficult to use, confusing. On the other hand I thought that ezpopulate was a snap. Download, change in an Excel-like program, upload, done. You can get a lot of things from apsona, but you have to fiddle with it and learn it before you get what you want. YMMV.

Ezpopulate is very unforgiving. My clients really had a hard time with it and I usually had to tell them what was wrong with the file.

If you are wanting just to import and export, Apsona is extremely straight forward - the only thing you really have to learn is what fields are required. Now all I have to do is send them a sample file to get started.

Just easier to teach.

delia, when you said {I} had to be registered with Apsona for it to work,,,,,,, WHAT exactly is registered with them? The Website URL? I have ShopAdmin installed on 2 sites, and I still have the program and wanted to use it on another website; So, if I install it on a new website, will that work for me? How does Apsona know it's "ME"? Or can I not do that? Thanks!! @fabiene, thanks for the input. I'll install ezpopulate at some point and check it out.

If you have them installed now, you are registered. When you sign up, that config file you get sent has a account number in it. I have never tried to install it on another site like that. I have no idea if it will work. I suspect it will because it does not take the domain name to make it work - I've used it just recently on an ip address instead.

One of the things that was really nice while they were still fully supporting this, is that I was able to get them to add other database tables /mods in to your specific cart. So they could turn on things for each website. I really regret not paying them to add in my product extra fields mod!

I'm not sure what or how they were doing but you are totally dependent on them for this mod. Kudos to them for keeping everything going so long when it was never a moneymaker for them.

By the way, the actual shopadmin pages on their website are still up and working: http://apsona.com/pages/ec/sa.html

Their homepage is at http://apsona.com/pages/sfdc/index.html - I think the placeholder page that shows up is a mistake.

Question: I don't know the in's and out's of Software Licenses, open source or otherwise, but would it be possible for them to make another version of this and sell it and provide support, or do something that would make it worth their time for support of this product? Maybe charge for the 'server fee'? Heck I don't know.. ha.. I'm just thinking about the future, and thinking this will be useful for some time,, and as ZenCart gets updates, I'm afraid this program will disappear.

delia, I don't remember getting a config file from them....? I just remember installing the plugin. I'm pretty sure I didn't get anything from them.. Could THIS be the reason mine isn't working? I installed it about 1.5 or 2 years ago. I COULD have received something from them, but I'm don't recall THEM sending anything to me. As a matter of fact, I had a problem with the install, emailed them, and a girl emailed me back. She was very nice.. but I don't remember getting anything from them to 'add' to my install.

They have found a money maker (salesforce) so they just simply have a totally difference business now. Since it is their server that it involved, unless they decide to give it away to someone else, it's out of our hands. It's the backend on the server that is the real working part to this.

Yeah, I don't like the way this is heading. My contact there hasn't worked with the store admin in a long time but I might approach them about taking over. Don't know if I want it...

One of the files you got is apsona_config.php - if you've never changed anything since you got it, then you need to make changes to your files as noted in this thread.

Well, I don't know the numbers of people that would be willing to pay to use it, but I would pay for it. Knowing what I know now about it, I would have purchased it for $50 - $100... I know that's not a lot, but I'm broke. haha.. I bought Conner's Advanced Shipper, and it's worth every penny. If you could find a way to charge for service, that would be good. deleted the last part of this post because I didn't see your post above. thanks.

Yeah, I was thinking they would move to a paid module at some point but it never happened.

I have been in contact with them, and the page is back up now.

They do intend to keep it running albeit with no support.
No, they cannot release it to the community as it has a great deal of their current codebase included.

They are in a different market now, they found the zen cart/oscommerce/open cart users didn't want to pay for anything...so they have put that development down to experience.

If it ever does disappear, I have a good friend who does something similar with reporting and he would come up with an equivalent if given a large sum of money!

Thanks delia, and everyone else too. I finally got my ShopAdmin up and running again. I REEEEEEEEALLY appreciate it!!!!!!!

Quote:

---

I finally got my ShopAdmin up and running again.

---

Great...and did you need to do anything that is not already detailed in this thread?

Well, if I had to fix it again, I would follow instructions better.. ha. But seriously, no. Everything I needed is here in this thread. Don't forget, if your Admin is secure, change those 2 files!

It seems like service.apsona.com is down. Does anyone know if this is the end of Apsona?

I was assured just about 10 days ago that they had no intention of getting rid of the server. I'm hoping that they are just having issues and it will be back up later.

It's working again now.

i'm having two issues with apsona.


issue 1: it was working great and all of a sudden it stop displaying! I cannot get it to show. the url is fine but i get a small icon where an image should be in the center of a blank page.

issue 2: i look on my zencart product profile for products that were uploaded using apsona and no information is displayed. When I review the website the products are displaying and when i look in the admin categories they show as if they are there as well. But when I look at the actual product profile in the admin it doesn't display there. please help!

Quote:

---

Originally Posted by delia

If you got it before now, your problems are addressed in this thread - from ssl errors to 1.5.4 etc. To get it originally you signed up on their website - essentially registering it. You have an account number in your config file.

Since the servers are still up, it's worth fixing your files rather than switching to ezpopulate as mc12345678 just suggested. Ezpopulate is extremely hard to use.

I just had a tweet only a few weeks ago from someone who works at Aspona and got no indication of problems. I'm thinking the website issue is temporary because they have a viable business doing other things besides this mod.

---

I'm having the same issues - suddenly today, the Shop Admin page was blank except for a missing image icon. Does anyone know if Apsona has taken down its interface?

There definitely was some sort of outage yesterday - and they have changed some things it looks like. Even if you are running admin in nonsecure mode, I found a site needed the ssl link to the server. The ssl link is totally different from the old link so I'm thinking they streamlined the access to the server. So the old code no longer works.

At a minimum, you have to change the link in apsona_config.php.
The first line needs changing to this:

$APSONA_BASE_URL = 'https://service.apsona.com';

After you do this and you are still having problems, I suggest changing browsers to see if caching prevents you from seeing the correct view.

That fixed the apsona issue one of my post.

I have a second issue that is confounding to say the least.

I cannot see the product descriptions, id, or anything on zencart yet they appear on apsona and on the live site.

i tried a suggestion included in post #539 on page 54 of this thread and updated through the store manager to no avail.

I need help in understanding why this is happening and how to fix this issue because if apsona ceases to work then I will not be able to edit any products uploaded through the software.

Please help!

Quote:

---

Originally Posted by delia

There definitely was some sort of outage yesterday - and they have changed some things it looks like. Even if you are running admin in nonsecure mode, I found a site needed the ssl link to the server. The ssl link is totally different from the old link so I'm thinking they streamlined the access to the server. So the old code no longer works.

At a minimum, you have to change the link in apsona_config.php.
The first line needs changing to this:

$APSONA_BASE_URL = 'https://service.apsona.com';

After you do this and you are still having problems, I suggest changing browsers to see if caching prevents you from seeing the correct view.

---

Are you available for customization work on our site? I am looking for a Zencart programmer to modify some of the functionality in zencart relating to the media collection setup and i am also seeking an integrated video system that would allow video uploads to appear on any page of the site especially a video gallery page using the media manager. Is that the type of work you can accomplish for us?

The problem last week was DNS only. The server was fine but some settings got lost - so that some apsona admins stopped working. I posted a fix in post 663 and then installed apsona on a website. That site does not use SSL for it's admin and it doesn't work. So if you made that change and things are no longer working it needs to be changed back. This would only be for folks not using a secure HTTPS admin.

Is anyone using Apsona in a non-english language and seeing accented characters in the Shopadmin menus as "??" where they were ok previously?
I am, in spanish. It's not an encoding issue.

After these most recent posts to this thread, I have been checking to see if my ShopAdmin is still working. Well, it was - up until 3 days ago, when I moved to a different server. Although I have the same domain name, my url is now different (I am keeping the old url on the old server for 30 days "just in case"). Now, all I get is this:


Attachment 15102

Sorry about the little itty-bitty picture; I couldn't figure out how to make the picture fit the Forum's picture limits. What could be causing this partial loading of Apsona Shop-Admin? Do I need to change some config file that I don't know about? I tried logging in to the Apsona website to possibly change some portion of my account, but I don't seem to know how to do that either.

Is this even related to the server change, or is it something else?

Please advise.

It would have to be related to the server change unless you have also upgraded your zen cart or changed admin to secure. In any rate there's no way to tell without actually looking into it. If there absolutely no changes made whatsoever then perhaps your new hosting is the problem.

I have browsed through this thread and need to get this plugin to work. I have registered on their site, but haven't received any link to download the module. Have installed the export utility into the right places. Nothing relating to Apsona in Admin>Tools

My current site runs 1.3.9 with 3000+ products, lots of redundant items. My new site, 1.5.4 under construction will be a totally fresh build, new overrides etc, but I want to be able to export & edit the existing product database before populating. This is my dilemma

When you registered, the page should have shown a link to download the files. If you didn't see it, you probably didn't get registered. If you missed it, then you need to register again with a different email address - even a fake one if necessary. If you did get registered, your email address would have been logged and you can't register under the same email address again. You have to get the files to get the id code you need in the config file. You probably can't use the files though on your site.

I have packaged up the files for 1.5.3 - 1.5.4 and will gladly provide those to anyone.

Quote:

---

Originally Posted by delia

When you registered, the page should have shown a link to download the files. If you didn't see it, you probably didn't get registered. If you missed it, then you need to register again with a different email address - even a fake one if necessary. If you did get registered, your email address would have been logged and you can't register under the same email address again. You have to get the files to get the id code you need in the config file. You probably can't use the files though on your site.

I have packaged up the files for 1.5.3 - 1.5.4 and will gladly provide those to anyone.

---

Thanks for the explanation. I used my Mac with no result. Then I used a Windows PC and downloaded the ShopAdmin module. Downloaded and FTP'd with FileZilla to my site.

Gone to Admin>Tools - nothing there?

what version of zen cart do you have?

Quote:

---

Originally Posted by delia

what version of zen cart do you have?

---

1.5.4 on Camelot Hosting Server

Quote:

---

Originally Posted by Parafanaylya

1.5.4 on Camelot Hosting Server

---

and I downloaded the update for 1.5 from Apsona

That is for 1.5.1. Do me a favor next time and read back a little ways in this thread.

I am posting this link for 1.5.3/1.5.4 files with some instructions. It only works with 1.5.3 or 1.5.4 - NOTHING ELSE.

Follow the instructions!
http://zencartdelia.com/zen-cart-sto...-ssl-1.5.4.zip

thanks for great service

Quote:

---

Originally Posted by delia

That is for 1.5.1. Do me a favor next time and read back a little ways in this thread.

I am posting this link for 1.5.3/1.5.4 files with some instructions. It only works with 1.5.3 or 1.5.4 - NOTHING ELSE.

Follow the instructions!
http://zencartdelia.com/zen-cart-sto...-ssl-1.5.4.zip

---

I don't know code, but I found this in my admin/includes/configure.php:

Quote:

---

define('DIR_WS_HTTPS_ADMIN', preg_replace('#^' . str_replace('-', '\-', zen_parse_url(HTTPS_SERVER, '/path')) . '#', '', dirname($_SERVER['SCRIPT_NAME'])) . '/');

---

the difference being that the second (HTTPS_ has an "S", and your instruction does not.

Do I replace?

and this being the result:

Umm, yes. Is yours a 1.5.4 install and not upgrade from another version?

Quote:

---

Originally Posted by delia

Umm, yes. Is yours a 1.5.4 install and not upgrade from another version?

---

yes - fresh install

Nobody had noticed that discrepancy before! Thanks. I've made the correction in my instructions.

Quote:

---

Originally Posted by delia

Nobody had noticed that discrepancy before! Thanks. I've made the correction in my instructions.

---

I copied and pasted the instruction from your readme file. It couldn't pick up the script in the find and replace, so I matched it as closely as possible.

Busy saving now. Will revert with result.

My admin crashed, so I reverted to the old coding. Admin working again.

Can I send you the files?

Could someone tell me if I can use my own product datanames that I've added to the products table, in the import facility using Apsona please?

If not, would it be easy enough to add new fields to the import? I don't want to go to the trouble of installing it, if it won't do it! Thanks!

Quote:

---

If not, would it be easy enough to add new fields to the import?

---

When you import, you can choose what csv columns to map to which database fields so yes it accomodates non-standard zen fields that you have added.

Quote:

---

Originally Posted by torvista

When you import, you can choose what csv columns to map to which database fields so yes it accomodates non-standard zen fields that you have added.

---

Thank you so much for getting back to me! I'm really pleased with your answer! My sister wasn't comfortable with doing the import of the .csv file in phpMyAdmin, so this should save me a lot of work, as she will now be able to do it herself with Apsona Store Manager and won't need to get me involved at all! Good news!

Thanks!

Still struggling to use the Apsona import csv to add descriptions to some new products. After a few go arounds I was able to get it to import my csv file. But..

All the first occurrence apostrophes are replaced with the little black diamond with a question mark in it. Second occurrence translates fine.

I've tried (without spaces)

& # 8217 ;
& # 39 ;
and escaping with \

all to no avail. Anyone have any hints for this stubborn module? I'm trying to update about a hundred products and doing these by hand isn't a great alternative.

and if you might include an escape for double quotes and for an accent mark.

I wish this was as easy to use as the old EZ populate.

You have an encoding issue.
Use Libre/Openoffice to ensure you save it as utf-8 encoded, assuming you have an utf-8 database...or as whatever you want. I found Excel lacking in this aspect for both opening and saving csv files.

Quote:

---

Originally Posted by torvista

You have an encoding issue.
Use Libre/Openoffice to ensure you save it as utf-8 encoded, assuming you have an utf-8 database...or as whatever you want. I found Excel lacking in this aspect for both opening and saving csv files.

---

Thanks for the reply. The bad characters are sporadic and not present for every instance of apostrophe, double quote, or accent. Only some.

But that's why I made the comment about EZ. I used to use Excel freely with EZ Pop and as long as I saved as a CSV things were always ok.

Great fix for Apsona for ZenCart 1.5++, Thanks Now I can stay married for a bit longer.

Weird question for anyone who may be listening:

In Shop Admin, I can click on any of the searchable items until I hit about 20 clicks. After that, my site spits out a "No Data Records" warning. After that I hit refresh in my browser and it returns with "No Data Received" - ERR_EMPTY_RESPONSE.

Using 1.5.1 as my ZenCart version. Anyone else seeing this error?

Another issue with Apsona CSV import.

The products are importing into Apsona, getting assigned Product ID's. Great! Everything looks fine inside Apsona. No errors, nothing done differently from other new product imports.

What's not so great is that they are missing from regular Zencart admin where I need to edit their descriptions then make them enabled.

Tried exporting the CSV after the intial new product import and updating existing products but no joy.

Is there a secret key to get the Apsona to agree with regular Zencart? Now I've got several dozen products in my database and they do not show up within Zencart admin. I'm baffled as to what I need to do other then start fiddling with phpmyadmin.

Attachment is my initial import file.

Anyone have any help?

Without looking I suspect you didn't do the categories correctly. category and master category id?

Hi Delia,

I "seeded" a test listing in the category and downloaded the CSV for that. Then created my dozen or so listings using that as my template. I only added Master Category and did not include Category.

Is that the trick? Meaning Apsona has to have both Master Category and Category fields specified even tho' they are the same?

That seems to be the case - had a client who went thru this and that's what worked for him in the end.

I re-ran the csv with the added Product ID's and Category filled in and I was able to see the products show up. What a pain! Really wish Easy Populate worked; it was so forgiving and unfussy.

Thank you for the tip!

Hi, I installed all the files into my admin as instructed. I do have the Apsona tool showing up in my zen cart tools. However, when I go to my Apsona in tools, I get a blank page as indicated in my photo snapshot here. What needs to be done? http://www.yazzaorganics.com/KEEP/apsona.png

blank page usually means a php error. Have you checked your error logs folder?

Is anybody having trouble with Apsona the last few days? I've been running it successfully on ZenCart 1.5.4 (I do have the patch installed) until yesterday. Now, for some reason, every time I try to mass delete products, or mass update records, I receive the message "The server is not responding." I can successfully export products but not delete or update. I can't even delete a product by selecting it individually. I have not changed anything locally and have tried it both on Firefox and Chrome.

Also, when I try to import records, the "manufacturer" field is not being recognized. It will not match the manufacturer in my .csv file to an existing manufacturer in the database.

Any insight any of you might have would be greatly appreciated.

I've not had any one of my clients mention it but most folks don't use it on a regular basis. I did check one to make sure it's showing up and looking correct and it is.

I have been getting:

413 Request Entity Too Large
The requested resource
/XXXXXXXXX/apsona_svc.php
does not allow request data with GET requests, or the amount of data provided in the request exceeds the capacity limit.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Zen Cart 1.5.4 PHP Version 5.4.40 --

Was working great a couple of weeks ago and we made no changes to the server. Anybody else seen this?

Uploads just fine - just does not download

Quote:

---

Uploads just fine - just does not download

---

You mean a product export to create a csv does not work?

Just tried mine, it's ok (on php 5.4.45 and 5.6.8).

I am having trouble reinstalling Apsona after a complete site rebuild. I have read through the thread and cannot find a solution.

I have been using Apsona for many years. My site reecently got hosed by me trying to uninstall TaxCloud and I decided to literally start over. I installed 1.5.4, updated the database, and restored the old database into the new site. Everything is working fine. The last step was to reinstall Apsona ShopAdmin. I installed the basic files from the Apsona website, then installed the 1.5.x specific files. The menu listing shows up fine, but when I select it, it opens a new tab, but it is blank with a swirly-thing going around. I let it go for about 2 hours and nothing changed. I looked at the database and the 2 columns for Apsona are there. They were probably there from when I originally installed in in 1.3x. No error logs were created. I also did not install any sql patches like I did in the older version. Should I remove all of the files, including the 2 apsona columns in the database and start over? Any other ideas?

did you get the functions file for 1.5.4? I packaged up what is needed - https://www.zen-cart.com/downloads.php?do=file&id=1985

Thanks for your quick response! I installed all of the files and now I have the ShopAdmin Tab with the header and the footer on it. It does not show any of my site data. Do need to sign in or anything? Sorry to be "High Maintenance"!

did you make the changes to your admin config file?

Thank you Delia. I thought I had done all of the things in the Readme file, but the password didn't seem to have changed. Perhaps I forgot to ftp that file over. The files work better when they are on the site rather than on my computer!!

I really appreciate the fact that you are supporting this mod. I have over 10k SKUs on my site that vary with the price of gold and silver. I would really struggle without this type of mod.

Can I buy you a "cup of coffee". I would be happy to make a donation, just let me know how.