Originally Posted by
torvista
Well, I keep banging on about this...Pentaho Data Integration Community.
In short it is a method to get data from A, manipulate it in multiple simple steps, then send it to B. A and B can be any database or filetype.
I use it to extract product data from a dBase legacy system to a csv, then use my own script to get that into my shop db. Pentaho could do it all but I have a lot of oddities that need special treatment and I did that in the script.
Pentaho can produce a job file that can be run automatically.
Well Torvista! Thanks for the tip! I'll look into Pentaho, I was looking at some solutions, my idea was to query the db, and then with the data stored somewhere create a csv and then use js to generate a JSON file. As there's no API for zencart to connect to other platforms I was planning to do something custom, but wasn't sure if I would run into conflicts, if I used the Zen Cart Query suite just to retrieve information directly from products instead of doing joins to achieve the same result using plain SQL.
BTW I noticed you ported Apsona to PHP 7, is it still working? I do have an old ID, it was pretty good to check prices and inventories, although I made my own custom auto inventory system, my problem is I can't find a way to prevent the system from using the default images directory for product images, instead of my cloud URL, it does work sometimes, but not with Zoomed
images, I use a jQuery plugin to navigate the zooomed ones the problem is the template adds
Code:
https://www.mydomain.com/shop/images/https://www.mycloud.com
so evidently fails, no matter where I performed a search I couldn't find a way to prevent this from happening, even by canceling some concatenation rules in the string that's pulled by the templates.
Bookmarks