I can't remember which of the databases we have at work for our inventory but what I'd like to do is have a page on our silverstripe site where a query to a copy of the inventory database kept on the server produces results from query requests. I'm a newbie at all this but I know the results of having this setup is vital to the clients with a monthly updated inventory. Any suggestions, links to descriptive webpages, books, etc would be greatly appreciated. Thanks!
I found out our inventory is MS Access. Is there a way to import our inventory in MS Access into the MySQL shopping card component of Silverstripe?
You'd probably end up doing a very manual data transformation into the Products table. You may want to ask/browse in the Module forum to see what those crazy Ecom maintainers have done to support this previously.
MySQl offer a "Migration Toolkit" on there site:
http://dev.mysql.com/doc/migration-toolkit/en/index.html (Good luck finding a download link)
That would get your database into MySQL at least.
I suppose you could try and create a new dataobject that matched your inventory layout (http://doc.silverstripe.org/doku.php?id=datamodel). You could then render each item out in the page, or in the CMS (using a table field). It will depend on how complex your database is though.
If there are a lot of relations, I imagine that approach wouldn't work very well, and like dalesaurus said, it would look like a manual process :(.
I don't think the OP is looking to migrate from Access, just update inventory from the Access database to the site regularly.
Is this possible?
Yes, but the current release of the ecommerce module does not have any inventory management built in, so you would need to either:
- create this code yourself (and hopefully submit it to this ticket: http://open.silverstripe.org/ticket/1926)
- wait for it to be added to ecommerce 0.7, which I frankly, I would not be counting on in the short term as there are a lot of tickets in for 0.7
How I would see it working in your particular case, is you would export a csv file with say, the sku's and inventory level of all your products, and then have some sort of import function on Silverstripe where you upload this csv and it updates the inventory.
An alternative would be to migrate the whole system to Silverstripe - so rather than using Access, you would have the whole inventory system in one place, on your web server. I am guessing that would be too much work though as I am sure there is more to the Access system than just a simple inventory tracker.
The final alternative is migrating the Access database to MySQL, but then connecting Access with the MySQL database. You can do this which allows you to keep using Access but everything is stored on the same MySQL database as Silverstripe. This would allow the inventory to be updated automatically.