Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

MS Access or SQL Query Page


Reply


5 Posts   1287 Views

Avatar
growin

Community Member, 41 Posts

22 October 2009 at 8:58pm

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!

Avatar
growin

Community Member, 41 Posts

25 October 2009 at 9:17am

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?

Avatar
dalesaurus

Community Member, 283 Posts

26 October 2009 at 12:41pm

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.

Avatar
Mo

Community Member, 510 Posts

27 October 2009 at 12:20pm

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 :(.

Avatar
rbquirke

Community Member, 70 Posts

2 November 2009 at 6:52pm

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.