Jump to:

23007 Posts in 11866 Topics by 2828 members

General Questions

SilverStripe Forums » General Questions » MS Access or SQL Query Page

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

Page: 1
Go to End
Author Topic: 1168 Views
  • growin
    Avatar
    Community Member
    41 Posts

    MS Access or SQL Query Page Link to this post

    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!

  • growin
    Avatar
    Community Member
    41 Posts

    Re: MS Access or SQL Query Page Link to this post

    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?

  • dalesaurus
    Avatar
    Community Member
    283 Posts

    Re: MS Access or SQL Query Page Link to this post

    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.

  • Mo
    Avatar
    Community Member
    485 Posts

    Re: MS Access or SQL Query Page Link to this post

    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 .

  • rbquirke
    Avatar
    Community Member
    70 Posts

    Re: MS Access or SQL Query Page Link to this post

    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.

    1168 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.