Three Great New Features - Interfaces, Query Builder, Excel File Import

Posted: 4/20/2008 11:47:00 PM
We released new code with three great new features that make Qrimp even more flexible and easy to use.


Uploading Data is nice, but it's better when that data is managed with an intuitive interface. Many times, these interfaces can be inferred from the relationships in the data and the types of data. Qrimp has done this for one-to-many and many-to-many relationships for quite some time, but what about more complex data relationships? The Qrimp Interface Designer will examine your data and find new patterns in your data: Spreadsheets and Shopping Carts.

Spreadsheets are formed where there is a table with two foreign keys and a decimal field. These occur where you want to assign a value to a matched pair, for example, in a student gradebook, you'll want to assign a grade to a student for a particular course. In the spreadsheet view, you'll see courses along the top and students on the left. At the intersections, there will be a text box where you can enter a value for the grade. Click save at the bottom and you're done. There are more arrangements like this in the world. For example, you may have custom pricing for your products by pricing model. You can see this in our CRM Demo.

Shopping carts are formed where you want to assign an item from one table in a many-to-many fashion when those items can be filtered by another foreign key. The example that lends its name to this pattern is where you want to allow users to add items to their shopping cart and those items are in particular product categories. Other examples include adding menus to groups. You might also add tasks to employees filtered by priority.

Query Builder

With the query builder, you can create custom queries that will return very particular data sets. You can also save these queries for later retrieval and custom business logic. With custom queries, there's no limit to the depth of reporting or filtering with Qrimp.

Import .xls files

It just got a lot easier to build applications with Qrimp. Just create an Excel spreadsheet with multiple sheets containing your data. Make the names of the sheets the table names you want to import and upload the file into the Import Data... page. As usual, Qrimp will examine the data for data types and relationships and create an enterprise ready Application automatically with the full power of a relational database.