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

[torvista]

My hosting is php 5.4.28 and Apsona works fine.

Locally Xampp is on 183-4 (php 5.5.11) which doesn't work: I have to use 182 (php 5.4.27) when I need Apsona.

The "re-coding" is fixing a few functions in apsona_functions.php.
I spent about 10 minutes on it about a year ago without success (early adopter that I used to be...) so I was just wondering if someone had fixed it yet so I can bin the older Xampp install.

[FoodSourceDirect]

Hi Torvista:

I am interested in knowing the same thing as well.

[FoodSourceDirect]

Hi.Diva,

I have a little time but no technical skills. Let me know if some capable person does the re-coding.

BTW are you the current developer of TPP?

AJ

[torvista]

Just a FYI that there is a problem using Chrome as the browser with Apsona.
Scenario:
1) load in english.
2) import/insert some new products from a csv. ok.
3) change to secondary language.
4) import/update these products with second language information from same csv. Flags errors as it cannot find the model number, (nor product id if added to the csv prior to the update).



The process works ok with Firefox and IE.

[torvista]

Just a FYI that there is a problem using Chrome as the browser with Apsona.

No there isn't...

Be aware that when Shopadmin first loads it creates a snapshot of the database. It uses this for error-checking in the browser prior to doing imports.
It is cached and the cache does not renew with changing language, nor with reloading the Shopadmin page nor with closing and reopening it from the admin: you have to manually delete it.

This caused me a problem as I do multiple test-drives of importing large, complex .csvs locally to get them note-perfect before importing them to the real shop.
By not clearing the cache after completing local testing, Shopadmin was error-checking the csv against the wrong database info.

So, the moral is, use one browser for local work and another for remote work when using Apsona Shopadmin.

[torvista]

I have modified the apsona_functions.php file to use mysqli.
I only use Apsona for exports and imports so it would be prudent for all and sundry to try this out on their DEVELOPMENT servers and see if it is working in all instances.
apsona_functions.zip

I have it working on php 5.5.15.

[FoodSourceDirect]

I have modified the apsona_functions.php file to use mysqli.
I only use Apsona for exports and imports so it would be prudent for all and sundry to try this out on their DEVELOPMENT servers and see if it is working in all instances.
apsona_functions.zip

I have it working on php 5.5.15.

This is great news. Are you running zc 1.5.3?

[torvista]

Are you running zc 1.5.3?

Yes...and I was about to say that's irrelevant but there is a problem with the self-determination of the admin path in the admin configure.php using the new function zen_parse_url that I haven't figured out yet which means you need to hard-code the admin path in the defines that use that function otherwise the shopadmin index page does not load.

[FoodSourceDirect]

Yes...and I was about to say that's irrelevant but there is a problem with the self-determination of the admin path in the admin configure.php using the new function zen_parse_url that I haven't figured out yet which means you need to hard-code the admin path in the defines that use that function otherwise the shopadmin index page does not load.

Hi Torvista:

I noticed the same thing.

Fatal error: Call to undefined function zen_parse_url() in /home3/xxxx/pubic_html/admin/includes/configure.php on line 29

[FoodSourceDirect]

How do I hard-code the admin path in the defines?

Yes...and I was about to say that's irrelevant but there is a problem with the self-determination of the admin path in the admin configure.php using the new function zen_parse_url that I haven't figured out yet which means you need to hard-code the admin path in the defines that use that function otherwise the shopadmin index page does not load.