Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
134

name:

NextPrevious



description:
The next/previous arrow icons in the Edit View and Detail View of a record let you page through the items without changing your view.

Previous Help TopicNext Help Topic
PreviousNext

The next previous icons

To add the next/previous icons to the top of your records go to the table you want to add them in, then go to Develop > Header/Footer.

Copy and paste the following HTML with square brackets into the Header field of your Content Header



Note: HTML formatting must be not have line breaks.
NextPrevious url code


ParentTopic:
 

id:
135

name:

Too much white space around elements



description:
If you edit text or HTML in Headers and Footers and Field Templates and other System Tables, remove the spaces between your HTML tags before saving.

The description field of system tables automatically inserts a hard line break when you are entering text, so if you leave spaces between your HTML tags, you will notice extra spaces appearing once you have saved the item.


ParentTopic:
 

id:
136

name:

Item Footer



description:
On the right of the Detail View for an item, you can see the "Item Footer". This is where Attachments and Related Data can be found. Though the item footer appears to the right by default, it can be moved with CSS to appear anywhere on the page.

Editing the Item Footer


To edit your Item Footer go to Develop > Header/Footer. The footer field corresponds to the footer. You can style the item footer using #rightcontent.


See also Headers and Footers and Related Data.


ParentTopic:
 

id:
137

name:

Attachments



description:
You can upload nearly any type of file as an attachment to your Qrimp app including Word, Excel, PDF, .jpeg, .mp3, .mpeg and other file types.

Each attachment is uploaded to a record in one of your tables.

Viewing Attachments


If attachments to a record exist, you will see a thumbnail or a link to the attachment in the right hand side of the detail view of the record. Images will be displayed as thumbnails. Other documents show an icon that represents the type of document you have uploaded. You will see thumbnails for up to six documents.


To open the attachment, click the link or thumbnail. To change what happens when you open an attachment using Attachment Viewers.

To view all of the attachments to all records in a table, click the attachments link above the thumbnails. You will be redirected to the Attachments table. From there you can sort by columns or use the search function to limit the results.

Adding an Attachment


To add an attachment, go to the detail view of the record you want to attach the item to. Then click the "add" link below Attachments in the right-hand column.

Select your file or files and click the upload button. Once you have uploaded your file(s), they will be attached to the item, and will appear in the right-hand column in the detail view.



ParentTopic:
 

id:
138

name:

Qrimp Server



description:
To install and use Qrimp on your server behind your firewall, you will need to download and install the Qrimp Server binaries. Qrimp Server works on Microsoft Server with SQL Server 2000, 2005 and 2008 as a database.

Please contact us for more information about Qrimp Server Licensing.


ParentTopic:
 

id:
139

name:

Clean Urls



description:
Clean urls direct visitors to a shortened version of the web address (url) for your site. Clean urls help make web addresses "human readable" and improve search engine optimization (SEO) by indicating to the search engine that the page content at a web address is the same as the terms searched. This is great for public-facing websites, splash pages and any other site that you would like visitors to access easily, remember and link to.

Clean vs. Dirty


Dirty url:
http://demo.qrimp.com/db.aspx?t=Oscars&vid=1
Clean url:
http://demo.qrimp.com/Oscars

Creating clean urls


To create clean urls, go to Develop > Add Module > Clean URL Mapper. Once your clean url table is created, navigate to Design > Clean URL Map. Enter the 'clean url' that you would like users to type in and the 'dirty url' that is used to access the item directly.
Entering the clean and dirty urls
Click the add new icon . You will see two fields "dirty url" and "clean url".
Dirty Url
In the dirty url field, enter the part of the address of the table/id/view, starting at db.aspx like so: db.aspx?t=OscarsTable&id=1&vid=1. It is important to enter only the end of your url, starting at db.aspx. Do not enter the "http://oscars.qrimp.com/" or a backslash (/).
Clean Url
This is the name of the site to which you are directing traffic, for example "home". Enter only the word you want to appear after your site name in the url and nothing else.



Advanced Clean URLs
Full web address on the Qrimp platform contain the db.aspx page, your table name, the record number and the view. The link below shows the "American Gangster" Record of the Oscars table in detail view.
http://demo.qrimp.com/db.aspx?t=Oscars&id=3&vid=11

You can use Field names and view numbers in your clean url to make your web address "human readable". Replace spaces in your records with a plus sign.
http://demo.qrimp.com/Oscars/American+Gangster/11

The web address is hierarchical, from site name to table name to record name to view:
http://myapp/tablename/itemname/viewname

The itemname and viewname can be replaced with the number representing the ID for the entry as well:
http://myapp/tablename/25/11
Adding Static Content with Clean Urls
Use Clean Urls with a Pages table to manage static websites.
Watch this demo to learn more:



The clean url mapper will comb the Pages table for pages that contain the word in your clean url when executing a clean url.


ParentTopic:
 

id:
140

name:

Configuring your web.config



description:
The web.config file in the root folder of your IIS web application contains settings for your Qrimp App for the database, SMTP server (for sending email), and more. Below you will find a list of the configuration keys and what they mean.

To get to your web.config files here are the steps:
1. Open My computer C: Drive
2. inetpub
3. Qrimp
4. Scroll to the bottom and double click 'web', Microsoft Visual Studio should open and you will see the web.config files.

connectionstring


The connection string tells Qrimp how to connect to your database. It should be in a form that looks like the following. Add the values for your particular environment.

"database=;Password=;Persist Security Info=True;User ID=;Data Source=;"

The database is the name of the database containing your Qrimp App.

The User ID is the username of a user that has DBO rights to your database. DBO rights are needed so that you can create database tables and perform other operations within your database.
If you are unable to use DBO privileges for your web application, Qrimp will still work, but you will not be able to modify the database from the web.

The password is the password for the user.

The Data Source is the name of the physical server on which your database resides. If you are running your Qrimp Application on the same machine as the database, you can use (local) for the data source.

enablecaching


If enablecaching is "true" Qrimp will cache your database values. This will improve performance significantly, but does require clearing the cache in certain circumstances. In an pooled application environment, each application instance will have its own cache.

Any other value will disable caching.

showselectsastrees


In situations where you can access a Tree View for your drop down list boxes can also be displayed as trees. A value of "true" will show the data in these drop down list boxes as trees, any other value will show the data in a single list.

autoapproveaccounts


If you Automatically Approve Accounts, then users who fill out the Create Account page will be created assigned to the group id (see below) and instantly emailed a password they can use to log in to your Qrimp App. If you do not automatically approve accounts, then each new user will need to be manually approved and the Group can be set at that point.

autoapprovegroupid


This is the group id new users will be assigned to if you choose to Automatically approve accounts (see above).

requiresecureconnection


If this value is true, then users will be required to access your Qrimp App via an SSL encrypted line. This will require a secure certificate on your server and users must use the HTTPS:// url protocol.

ignoreselectcachetablename


If caching is enabled, then select lists are cached in their HTML form to improve performance. There are some instances where caching these select boxes can be problematic. In this case, you can disable caching for a particular table by setting this key to true. For example, to turn off select cache for the users table, you'd add this key to your web.config:

ignoreselectcachet_users=true

notificationemail


The notification email is the email that will appear in the from line of emails sent by your Qrimp App.

smtp-relay


The smtp-relay is the name of the email server you will use to send emails for notifications that occur within your Qrimp app.

smtp-username


The smtp-username is the username that will authenticate your SMTP session. Qrimp requires SMTP authentication to send emails to improve security and reduce the risk of spamming.

smtp-password


This is the password for your SMTP server.

AmazonAccessKeyId


This is the Amazon Access key that will allow you to perform remote backups and other functions that will be announced in future releases of Qrimp.

AmazonSecretKeyId


This is the Amazon secret key, see above.


ParentTopic:
 

id:
141

name:

Deployment Manager



description:
With the Deployment Manager, you can push changes in an application to another application. This allows you to customize an application in a development environment, then move those changes to a test environment, then to a production environment.

We highly recommend you backup your target application before performing a deployment. If an error occurs during the deployment process or network connectivity is lost, your target application may be rendered unusable.

There are two ways to deploy your application:
  1. Full Deployment

    If you click the check box by the Full Deployment option, an full copy of your application will be moved to the target application specified in the Application text box.

    This option will overwrite all system tables and user tables containing data for your application. If you would like to preserve information entered into your target application, do not check this box.

    Changes to your user tables, including new columns or new tables will be copied in a full deployment.

  2. Default Deployment

    The default deployment scenario will copy all system tables except those that manage user configuration, including the following tables: Users, Groups, Attachments, Site Settings, User Groups, User Portals, and others like that. This will allow you to configure design and development aspects of your system while preserving user settings for different environments.

    Under the default deployment scenario, changes to the user tables are not deployed, only content of the system tables. If you add a column or table to your development environment, you will need to modify your target environment to include the new tables and columns before deploying your Qrimp App to the target system.



Usage


To use the deployment manager, use this suffix for your app:

synchronize.aspx?deploy=true

For example, if your app is http://localhost/qrimp, then the deploy url would be:

http://localhost/qrimp/synchronize.aspx?deploy=true

If you use the deployment manager frequently, you can add a menu. You can read more about Menus for help with this.


ParentTopic:
 

id:
143

name:

Insert Statements



description:
To view scripts that will allow you to use the data in your Qrimp application to run them in your own database.

Go to Admin > Backups

You can choose to download either create and insert statement or just insert statements.



ParentTopic:
 

id:
144

name:

Anonymous Access



description:
By default, data in your application is only visible to individuals with usernames and passwords. The default user group "Anonymous" is used when you want to make your data accessible to the public, such as for an online store, a blog, or a company website. (See also User Groups.)

To allow your data to be visible on the internet, you must set each database table as visible to the Anonymous user group by using Table Security. You must also make sure that anonymous users have permission to see each menu tab by setting up Group Menu Visibility.


ParentTopic:
 

id:
145

name:

Ad hoc queries



description:
You can create your own queries using the Query Designer under the Develop menu.




Querying Data

To quickly show the SQL Statement for a particular table, select the table name in the drop down and click the show sql link. This selected table will be used for the templates for the data that is returned. Click Run Query to show the results.



Saving Queries

You can save your queries for use later. Specify the query to use by adding a &qid= parameter to the end of your querystring using the ID or the Name of the query you save. To keep your data secure, you must assign permissions to the query by group. When you first click the Save Query link, you will be presented with a list of Groups who you want to allow to view the Query Results. Click the view queries link to view, delete or modify existing queries.



Updating Data

The Query Designer will let you write ad hoc SQL statements against your database. You can run any statement you like, but we suggest using only SELECT statements to prevent damage to your database. If you are going to run statements to update your data, you should do a backup first, which is covered in Backing up your data.


ParentTopic:
 

id:
146

name:

Backing up your data



description:
You can back up your data with Qrimp Backup, which you will find below the Admin menu.

Qrimp Backup will allow you to backup your data in many ways, including SQL Scripts to insert your data into another database and create tables to store it. You can also download a full MS SQL Server backup of your data. This backup will be compressed and secured with a password to prevent tampering.

If you would like to restore your database to that backup, create a trouble ticket and we will assist you.


ParentTopic:
 

id:
147

name:

JavaScript API



description:
The JavaScript API will allow dramatically expand the capabilities of your system. In this help topic, we are going to spend a little time detailing the functionality you can accomplish rather quickly using a little bit of JavaScript. If you've used Share Data, you've already done a little bit of JavaScript Programming.

Background on JavaScript

There are many JavaScript Tutorials on the net to help you understand it better. JavaScript is a standard technology and has been in use for many years. We chose to use JavaScript because a lot of developers are familiar with it. Javascript can make your applications more accessible and platform independent.

Examples

Every Qrimp app comes with some features that are built using JavaScript. Share Data for sharing data and Field Templates for columns validation are built with Javascript. These validation routines are fairly standard. To try an example, go to Design > Field Templates on the Add New view for many of your tables.

Extensibility Options

In this Help Topic, we are going to concentrate on some of the techniques you can use to pull data out of Qrimp and use it in your custom programming activities. To get the most out of this topic, you should be familiar with the Query String Parameters first.

To make AJAX programming with Qrimp easier, we are using Matt Kruse's AjaxRequest.js from http://www.ajaxtoolbox.com/. If you are familiar with JavaScript and would like to use Dojo, Prototype, or some of the other common libraries in your site, Open a Ticket and we will help you with this.

Retrieving Data with AJAX

Because we are using the XMLHTTPRequest object the following functions will only get data from local urls within your Qrimp app. Attempting to use them with remote URLs will return a security error.

getUrlString(url) This method will download the url and return the content as a string. You can use this function to retrieve a particular value of a particular field for example. Click the button below to retrieve the name of the help topic indicated by the id you enter into the box:



Here is the JavaScript for the example above, click to copy it into your app:

getContent(url,element,clearcontent,startmsg) We could have stream lined the above example using this method, which will download the url and insert the content into the page element indicated by the element parameter. Try this example:


Clear Content

Here is the JavaScript for the Example, click to copy it into your app:

Special Query String Parameters

_INDICATESUCCESS=true will tell Qrimp to execute a command only returning only the status of the operation. If the message is a success it will return the value of the EXECUTE_SUCCESS variable, which is "Changes applied successfully." If the operation fails, the exception message will be returned.

_RETURNRESULT=true is used for creating new records or operations on individual items. For example, say you want to create a new record in a database table. If you append _RETURNRESULT=true to the URL querystring parameter list, the system will return just the single value response. For an INSERT operation that creates a new record, that result will be an integer number identifying the ID value of the new record.

Using &_RETURNRESULT=true can be very useful for creating parent child relationships. For example, you may want to create an Expense Report, get the ID of that new expense report, then create new expense line items under that Expense Report.

_RECORDCOUNT=true will return only the number of items that would be returned for a particular query string.

Special Pages for Programming

banner.aspx allows you to perform Mash Up operations that grab information from external websites. Use banner.aspx with the following Query String Parameters:

?importimage=imageurl&t=table&column=columnname&id=itemid
This command will retrieve an image from a remote website specified by imageurl and save it into your local Qrimp app. The value for the column specified and corresponding to the particular item indicated by itemid and the table will be set to the url for the local file. This functionality will allow you to ingest remote resources and use them locally within your Qrimp App. The imageurl specified need not be only an image, but could be a text file, html file, etc

?getrgb=imageurl will return the average hexidecimal color of a remote image. This is useful for determining, for example, if there are any storm clouds in a weather radar. If the average hex value is close to black, it's a clear day, if it is closer to red, it is very stormy.

?externalurl=urltodownload&starthtml=starthtmlstring&stophtml=stophtmlstring&t=table&column=columnname&id=itemid
This parameter group will download a remote resource and save the value contained in that resource between the specified start and stop html strings, display it with a link to the original resource, and if the user has rights to update the specified table, save it into the column specified.

This feature is used to create powerful mash ups that persist data from multiple locations around the net. The values saved in these columns can be used in Calculated fields, sorted, and used like any other data entered via the normal routes like HTML forms, etc.


You can use Square Brackets to use values in your database to build custom urls. Watch the External Data Sources demo on our Demos Page to get a visual idea of how to do this with Amazon's Online Store.

savedesign.aspx
This page is used to enable drag and drop Field Layouts, but can also be used to update fields in your database for a particular record with a particular value. Here are the query parameters:
savedesign.aspx?ptable=tabletoupdate&id=itemid&f=field&v=value

If the update is successful, the value EXECUTE_SUCCESS will be returned. Otherwise, a failure message will be returned.

Summary

The JavaScript API is a complete set of tools that remove all limits on your application. If you need additional support, please contact Qrimp Support.


ParentTopic:
 

id:
148

name:

Iterative Development



description:
Iterative Development is a development methodology that is based on building a project quickly, in a series of short development cycles that allow for frequent feedback between the developer and the purchaser/end user/testers of the system.

Iterative development can reduce development time as it allows the changes that the user requests to be implemented sooner in the development process, reducing the amount of work that has to be done or undone.

There is a fairly comprehensive article on iterative development at wikipedia.


ParentTopic:
 

id:
150

name:

Icons



description:
Icons are used throughout Qrimp applications as visual cues. You can use icons anywhere in your application for any reason.


Qrimp has a large selection of icons to choose from

Using Icons in your HTML



To view all of the icons, go to Design > Icons/Icons List

Click the icon you wish to use.

Copy the filepath from the iconurl field and paste it into the "source" (url) of your img tag (src=).

Pull the image from the icons folder using a relative url, like this:


See also: Icontheme
Action Icons


ParentTopic:
 

id:
152

name:

Tutorial - Importing Data



description:
In this video demo, we get right down to business and import some data in one of our spreadsheets. This is the quickest way to get data into your Qrimp App and start building reports and adding information to your portal. In this demo, we also add a cross tab report to give us another view of our data.



ParentTopic:
 

id:
153

name:

Tutorial - Stacked and Custom Charts



description:
In this 5 minute demonstration, you'll learn how to build stacked charts from your cross tab reports and custom drill down reports.



ParentTopic:
 

id:
154

name:

Tutorial - Email Notifications



description:
In this tutorial, you'll see how to add a notification so you can be alerted by email when changes are made to information in your Qrimp App. We also briefly jump into some table management to make a field a bit bigger. We'll also customize the notification template so that we see only information that meets certain criteria.




ParentTopic:
 

id:
155

name:

Tutorial - Menus



description:
Here you'll learn a little more about the system menus that come with all Qrimp apps and also how to control the visibility of menus for your users and anonymous browsers from the Internet. We'll also add read access for the anonymous users so they can see the data in your tables.



ParentTopic:
 

id:
156

name:

Tutorial - Intuitive Interfaces



description:
Qrimp automates many of the software development tasks needed to manage relational information intuitively. Checkboxes for many-to-many relationships and spreadsheets to edit tabular data. In this tutorial we show you how to view those more intuitive interfaces for the information and add menus to get to those views easily.




ParentTopic:
 

go to page: 1 2 3 4 5 6 7 8 9 10 11 12 13 243 records. Showing