Jun 1, 2008

SketchUp and database Mashup for store fixtures

A store fixture manufacturer wanted to be able to visualize proposed store layouts, and then automatically produce a priced bill of materials for alternative layouts. They already used SketchUp to create 3D layouts. I integrated SketchUp with Access databases to store component prices and build up a the priced bill of the components required to make up a floor plan.

The interface to apply prices to components, and produce a variety of reports was created in HTML and VB script, all living within a web browser. SketchUp's internal "macro" language is Ruby, and one of the biggest challenges was making Ruby talk to Access.