Search the help documentation

Search:

Can't find what you are looking for? Use the Feedback tab in your app to submit an issue, or email support@ qrimp.com.


idnamedescriptionParentTopic
deleteedit224Changing your favicon (tab image)You can change the image that appears in a browser tab.
<img class="border" src="/attachments/developer.qrimp.com-2405b1bf-4476-46ad-b456-b801be0c1eea/favicon screen -1.png" />

First, create or find your favicon. It should be 16 pixels wide and 16 pixels high. Although it is created as a png or jpg, you will need to re-save it as a .ico. Your operating system may ask if you wish to do this, say yes.
<img class="border" width="200" src="/attachments/developer.qrimp.com-c72aaffe-0f5b-4de5-a8f3-907b73050ba0/favicon screen 0.png" /> <img class="border" width="200px" height="217px" src="/attachments/developer.qrimp.com-1dfb919c-3853-415f-ac89-afb820923293/favicon ico.png" />

Then navigate to Design > Skins
<img class="border" src="attachments/developer.qrimp.com-e986be40-2e63-4cbe-8df0-e52b908fa9fa/favicon screen 1.png" />

Scroll to the bottom of the skin and click the link that says Upload Images.
<img class="border" width="550" src="/attachments/developer.qrimp.com-4e19a9f6-9ae3-4613-b28d-901a167cc4c4/favicon screen 2.png" />

Upload your image.
<img class="border" width="400" src="attachments/developer.qrimp.com-6fae9db7-f476-4c7b-9b9a-581818405556/favicon screen 3.png" />

After it uploads, you will see the attachment detail view. Look on the right hand side under attachments and click on the image of your favicon. It will take you to your attachment url.

<img class="border" width="400" src="attachments/developer.qrimp.com-c035e92e-b45d-4e88-b92c-31e0472fb5e9/favicon screen 4.png" />

Copy the attachment url to your clipboard. Only copy the part starting at the word "attachments", ie: "/attachments/app.qrimp.com-c035e92e-b45d-4e88-b92c-31e0472fb5e9/img.ico".
<img class="border" width="400" src="/attachments/developer.qrimp.com-be66b43d-a75a-4d6c-90bf-b2bb802f3e97/ico%20attachment.png" /><!--You will see the details about your image. Don't worry, your icon won't actually be this big! Click the link that says "View attachment details".<img class="border" width="500" src="/attachments/developer.qrimp.com-1aa2bb5e-a7ac-435f-99c0-f481f50d2494/favicon screen 6.png" /-->

Now, go to Design > Clean URL map.
<img class="border" src="/attachments/developer.qrimp.com-a6647cc0-cd14-4566-9df8-b02394bcfbb9/favicon screen 7.png" />

Click the add new button at the top.
<img class="border" width="500" src="/attachments/developer.qrimp.com-bb6cce7f-124b-47fa-9255-477c30813948/favicon screen 8.png" />

In the CleanUrl field, enter "favicon.ico". In the DirtyUrl field, paste the file location from your clipboard and add a slash "/" in front of the word attachment.
<img class="border" src="/attachments/developer.qrimp.com-1241479d-935c-4e05-8bcf-382cae55f8b9/favicon screen 9.png" />

Depending on your browser, it may take up to several days for your new favicon to appear. Favicons are stored in the browser cache and we're not sure why sometimes they take so long to refresh. You can sometimes see it sooner by checking your site on a different computer. There may be problems with certain combinations of operating system/browser. If your favicon does not populate within a couple of days, let us know.
Changing the Look and Feel of Your App
deleteedit1274Custom CSSYou can use [CSS] to style any part of your Qrimp app. If you only want the style to be applicable to a particular page, table or view, you can write the CSS in a style tag in [views] or [headers and footers].Changing the Look and Feel of Your App
deleteedit1276Change your skinYou can change the look and feel of your site in an instant by changing the skin. The skin is the CSS code that determines the colors and positions of elements in your app.

To change your skin, go to Design > Skins.

<img class="border" src="attachments/developer.qrimp.com-645b1be6-6700-4912-bf16-19663049f4f0/designskins.png" />

Select a different skin from the [drop-down] and click "Select Skin".

<img class="border" src="attachments/developer.qrimp.com-4b5b4814-933e-4cab-b830-8161bd61bcff/selectskin.png" />

Now your site will look different:

<img class="border" src="/attachments/developer.qrimp.com-8794892c-141f-4a2e-9fe6-493c1090aaaa/adifferentskin.png" />		Changing the Look and Feel of Your App
deleteedit23Headers and FootersIn Qrimp, the area above your tables is the "Header" and the area to the right is the "[Footer]". The Header is also known as the "[Content Header]" (#contentheader in [CSS]).

<h2>Default Headers and Footers</h2>
Each table has a default header, in most cases containing the [Action icons] that allow you to change [Views], see [Reports], add new items, edit, etc. Each of the default <a href="db.aspx?t=1006&id=176&vid=11">views</a> has its own Header showing icons relevant to that view. For example, if you are in already edit view, you will not see the edit icon in the header. Headers are also a great place to put a custom messages to your users, rss feeds, shopping carts, images, shared data or even [Custom CSS] specific to that item and view.

The default footer usually contains [Related Data], [Attachments] , related tables, or custom messages to users.

<h2>Changing Headers and Footers</h2>
To change the header or footer, go to the table and the view you are changing it for. Then go to Develop > Header/Footer.

<img src="/attachments/3b12cead-6669-46a6-83b7-00ac5329fb79/Heade_Footer.jpg"/>

If a custom header or footer exists for that table and view, you will see it in the list.

<img class="border" src="attachments/c3500bae-f1ad-4b79-8b4e-786752c82cb9/HeaderFooterHelp2.JPG" />

Click the small edit icon <img src="/images/edit.gif" />to open the header/footer for editing.

You will see a text box for the HTML for your Header and a separate text box with the HTML for your footer.

Change the HTML to create your custom message. Save a copy of the working Header or Footer HTML for reference while you are working. [Versioning] is enabled by default for all header/footer tables. To view previous versions of your header/footer, click the [Versioning] icon <img src="/icons/crystal_project/32x32/mimetypes/file_temporary.png"> once you have saved the custom header/footer.

<img class="border" src="attachments/d62d2971-740c-4fdc-beb5-a1b40859ae4a/HeaderFooterHelp3.JPG" />		Above and beside your data
deleteedit58Related DataWhen you create one-to-many relationships between your tables, links to the related tables will appear by default on the right hand side of the page. If those related tables contain data, you will see the data rows listed.

<strong>Adding More Related Data</strong>
You may also see the option to add related data. For example, if I am in sub-project 2 and I wish to add another sub-project section, I click the "+ add..." and it takes me to a new sub-project, already configured to be related to sub-project 2.

<img class="border" src="attachments/0bd253ce-f5ff-4a48-b947-709b240c8ec6/RelatedDataHelp1.JPG" />

If you have enabled [Attachments] to your table, you will see a list of attachments with the related data.

Read more about [Adding Attachments].

Read more about [Headers and Footers].		Above and beside your data
deleteedit110Content HeaderThe "Content Header" or "Header" is the area below the menu tabs and above your records. By default, this area contains the [Action Icons] that allow you to perform actions and navigate to different [Views] of your data.

<img class="border" src="attachments/developer.qrimp.com-d26922e7-cfd9-41b7-bf0b-b117d3ff7c2f/contentheader.png" />
<span class="small">A default content header with a custom message to users of the products table.</span>

Content Headers are completely customizable with a combination of custom messages, [HMTL], [CSS] and [JavaScript]. You can add [Icons], error messages, warnings, shared data, external links, queries and more. (See: [Headers and Footers]).

<img class="border" src="attachments/beedb418-951d-4e64-93a3-e2032bbf0101/2008-12-14contentheader.png" />
<span class="small">A customized content header with fewer icons than normal.</span>

<h2>Advanced: For CSS and Javascript in Content Headers</h2>
For [CSS], declare #contentheader to style the content header.		Above and beside your data
deleteedit136Item FooterOn 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.

<h3>Editing the Item Footer</h3>
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.
<img src="/attachments/500ad038-88ba-4e6d-997b-64f5fbfdb35b/Footer.png">

See also [Headers and Footers] and [Related Data].		Above and beside your data
deleteedit18Add a TableTo create a new table, go to Develop > Add a Table.

<img class="border" src="attachments/27da6af9-4600-4320-b652-a48d42c45ebc/AddTable.jpg">

Provide names for the table and columns, select a [datatype] for each column, and specify whether a column (field) should be required to have data in it in order for the record to save.

<img class="border" src="attachments/b5f345e3-0d3f-49e7-b5e5-3cc95a3cc37b/AddTable1.png">

Fields contain the specific data about the "thing" your table is for. For example, if I created a table for TeddyBears the columns might be Name, FurColor, EyeColor etc.

All fields will get an id number, which helps us track the particular item. (See [automaticids]. The first teddy I enter will have an id of 1, the second 2, etc.

<h2>Advanced Features</h2>
After you have entered the field names, you can choose to enable additional options, [Auditing] (createdate and createid), [Versioning] (record history), [Attachments], [Menus] and [Tree View] (folder display).

At the bottom of the table creation page, click the Create Table button. Qrimp will create the table in the database. After the table is created, you should make sure that your [User groups] have the correct permissions to the table (See [Table Security]).

<h2>See Existing Tables</h2>
To see your tables go to Develop > [Manage Tables].		Building Your System
deleteedit19Adding ColumnsYou can add additional fields to any table in your Qrimp app.

Go to Develop > Manage Tables. Find your table in the list. Add the bottom of the page you will see a section called "Add a Column". Enter a name for your field in the table and a [datatype] and click "Save" or "Add Column".

<img class="border" src="/attachments/e11af951-c4aa-4655-9407-2d768f6e1ade/AddColumn1.png">

Configure [Column Level Security] for your table.		Building Your System
deleteedit61Table Best Practices<h2>Naming a Table</h2>
When you are creating a table, the table name should be the thing you want to keep track of, ie: "Customers", "Projects" or "TeddyBears". The name you choose should not have spaces and cannot be from the list of [Reserved Words].

<h2>Creating Fields</h2>
Fields are also known are records and are sometimes referred to as columns.

A Field name for the data we want to collect about our "thing" is the type of data we want to keep track of. For example, we may wish to store our TeddyBears Names, so we enter "Name" in the first field. Other fields we may want to keep track of would be FurColor, DateAcquired, Height, etc. The name you choose should not have spaces and cannot be from the list of [Reserved Words].

<h2>Selecting Field Data Types</h2>
Next we have to decide which type of data "BearName" is (see [datatype]). We choose which type of data this will be from the [datatype] drop-down list. If the datatype is a number, a date/time, or text, we choose from the first part of the drop-down list. BearName would be plain text, so we choose "Single-line text - 50 characters". We limit the length of the field to 50 spaces, because we don't want people to enter a lot of text in this field.

<h2>Creating from a Look-up Table</h2>
If we already have a table called 'FurColor' that lists colors of fur, we could choose furcolor from a [drop-down]/pick from/look-up table when we were choosing the [datatype] for the FurColor field. This would enable users entering data in the FurColor field to choose from a drop-down list of fur colors. You can choose these when the data entry options for a field already exist in a separate table. This will link the fields to other tables in your database. See [Look-up Tables]

<select name="datatype0"><option value='decimal(18, 2)'>Number with decimals</option><option value='int'>Number without decimals</option><option value='datetime'>Date/Time</option><option value='varchar (2)'>Text (2 characters)</option><option value='varchar (50)'>Text (50 characters)</option><option value=''>-- picklist from --</option><option value='pickfrom_accounttypes'>accounttypes</option><option value='pickfrom_t_furcolor'>furcolor</option><option value='pickfrom_t_users'>t_users</option><option value='pickfrom_t_views'>t_views</option><option value='pickfrom_yesno'>yesno</option></select>
Building Your System
deleteedit62Import DataIf you have your data in excel spreadsheets, .csv files or tab delimited format, you can use the Data Import feature. This is a fast way of getting a large amount of data into your Qrimp database. Import data is also the best way to create [drop-downs].

To import data, simply copy/paste a spreadsheet or .csv file into a text box and Qrimp will create your table(s) for you. You can also type data into the text box.

To use the data import feature, go to Develop > Import Data. If you do not see an import data link, go to Develop > Create Tables, then click the Import Wizard link near the top of the page.

<img class="border" src="attachments/developer.qrimp.com-6d61a212-a8f6-491a-b559-066b0a28ed2f/importwizardlink.png" />

To make sure your table is created properly, use "clean" data and prepare it in a spreadsheet or text editor as follows:

Put the name of the column in the top row and all of the data to be in that column in the column below it.

The following data is in the correct format for import:

FirstName Position Salary
John Cashier $30,000
Christina Cashier $32,000

Note that if you are using a text editor, there should be tabs between each item (where the spaces are above).

When you are ready to import your data, copy and paste it into the text box, or upload a file. Check the box beside "First row contains field names", unless you are using the importer to [import data into an existing table].

<img class="border" src="attachments/developer.qrimp.com-e3da82e0-2ebe-4013-b682-973bf6346ddc/manufacturerslookup.png" />
<span class="small">Some simple data, ready to import.</span>

----
Choose Advanced Options.

If this is a lookup table, do not enable any advanced options.
----
Wait for the data to be imported.

<img class="border" src="/attachments/developer.qrimp.com-3a8cc099-9b5d-4a16-aa41-da62eab5a8bd/waitfortheimporttocomplete.png" />
----

You will see your newly imported data.
<img class="border" src="attachments/developer.qrimp.com-c42ec091-0af6-4a6a-9de5-c01eceeab695/newmanufactererslookup.png" />
---
Now you must:
Give permission to your users to see this table with [Table Security]. If you are adding this field to an existing table (if it's a lookup table), you will need to configure [Column Level Security].

<h3>Data Import Tips</h3>
<ol><li>Field names must start with a letter and can only contain letters, numbers and _. Spaces will be converted to _. </li><li>Data must be in tab-delimited format </li><li>If you want the data to be searchable, it needs a description field</li><li>Don't edit the data after you paste it, it will look funny because the lines wrap in the box, but it's okay, we'll take care of it. If you edit the data, your data table may not be created correctly.</li>
</ol>

If you have a name for your sheet, Qrimp will automatically name the data tables it creates with that name.

<strong>Multiple Sheet Import</strong>
You can import a spreadsheet file with multiple sheets. The data from each sheet will be created as a separate table, and relationships will be implied and constructed from and between your tables automatically.
Building Your System
deleteedit98ModulesModules add functionality to your app at the click of a button. Modules contain pre-built [database table]s, [views], [menus], [operations] and more.

Some parts of modules may be included in other modules. As an example a "Priorities" look-up table might be included both an events module and a tasks module.

There are simple modules such as [look-up tables] for countries or states or complex modules like the PayPal Order IPN.

<h2>A List of Current Modules</h2>
<em>Note: Not all modules are available in all apps</em>
<span id=Modulesbodydata> <h4>Current Modules</h4> </span> <script> getContent('db.aspx?t=Modules&vid=1&orderby=2&hidecolumns=id,description,status,scripturl,createid,createdate&noheader=true&nofooter=true' ,'Modulesbodydata'); </script>

Building Your System
deleteedit122SynchronizerTo use synchronizer to work offline, you will have to have <a href="http://learn.iis.net/">IIS7</a> web server software and the database <a href="http://www.microsoft.com/sql/editions/express/default.mspx">SQL Server 2005 Express</a> (free) installed on your computer.Working Offline, Backing Up, Getting Data out
deleteedit138Qrimp ServerTo 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.		Working Offline, Backing Up, Getting Data out
deleteedit141Deployment ManagerWith 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.

<strong>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.</strong>

There are two ways to deploy your application:
<ol><li><strong>Full Deployment</strong><p class=blurb>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. <br><br>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.<br><br>Changes to your user tables, including new columns or new tables will be copied in a full deployment.</p></li><li><strong>Default Deployment</strong><p class=blurb>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.<br /><br />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, <strong>you will need to modify your target environment to include the new tables and columns before deploying</strong> your Qrimp App to the target system.</p></li></ol>

<h4>Usage</h4>
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.		Working Offline, Backing Up, Getting Data out
deleteedit143Insert StatementsTo 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.

Working Offline, Backing Up, Getting Data out
deleteedit146Backing up your dataYou can back up your data with <img src="/icons/crystal_project/32x32/mimetypes/shellscript.png" height=16 width=16 align=absmiddle style="border:0" />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, <img align="absmiddle" class="menuicon" src="/icons/crystal_project/32x32/apps/kword.png" style="border:0" /> <a href="https://developer.qrimp.com/db.aspx?t=1013&vid=8"> create a trouble ticket</a> and we will assist you.		Working Offline, Backing Up, Getting Data out
deleteedit163Installing Qrimp on Windows VistaThe following instruction guide works with Windows Vista and Windows 7 Home Edition or better.

<h4>Installing Internet Information Services</h4>

When installing IIS on Windows Vista Home, <strong>be sure to include ASP.NET</strong> as in this more detailed installation guide:
<a href="http://learn.iis.net/page.aspx/28/installing-iis-70-on-windows-vista/">http://learn.iis.net/page.aspx/28/installing-iis-70-on-windows-vista/</a>

<h4>Installing SQL Server Express</h4>
For Microsoft Vista, you can install either the 2005 or 2008 editions of SQL Server Express.
<ul>
<li>To install SQL Server 2005 Express with Advanced Services SP2, including advanced tools such as the management studio, reporting services, and full-text search, from <a href="http://www.microsoft.com/express/2005/sql/download/default.aspx">http://www.microsoft.com/express/2005/sql/download/default.aspx</a>. It is the 234MB download file.</li>
<li>To install SQL Server 2008 Express with Advanced Services, you have two options:
<ul><li>Leverage a single installer to install SQL Server 2008 Express and all the prerequisites, use the following link:
<ul><li><a href="http://www.microsoft.com/express/sql/download/">http://www.microsoft.com/express/sql/download/</a></li></ul></li>
<li>Manually install SQL Server 2008 Express and all the prerequisites individually, use the following link:
<ul><li><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336&DisplayLang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336&DisplayLang=en</a></li>
<li>Note: Make sure that you follow the steps outlined in the <b>Instructions</b> section</li></ul></li>
</ul></ul>
Tips for installing the SQL Server:<ul><li>Include all the options when selecting what features to install</li><li>Use "Mixed Mode" for the security model</li><li>Rember the password created for the <b>sa</b> account because it will be used in the connection string in the web.config (see below).</li>
</ul>
Once SQL Server is installed, open the management studio. Log in as <b>sa</b> using the password you created. Create a new database called "intranet" with the default settings. The name you provided for the new database will be used in the connection string in the web.config (see below).

<h4>Installing Qrimp</h4>
You should have received an email with a personalized Qrimp downloadable zipfile with a password designed for only your use. Download that file and unzip the contents as follows.

Note, if you want to run qrimp from http://localhost instead of http://localhost/qrimp then you'll need to copy the contents of the qrimp folder to the wwwroot folder.

<strong>File Upload Security Settings</strong>

Add modify rights for the following directories:<ul><li>c:\inetpub\wwwroot\qrimp\attachments<li>c:\inetpub\wwwroot\qrimp\fileicons</ul>
to IIS_IUSRS group by right clicking on the folder in Windows explorer, choosing properties, clicking edit button, clicking ok to the permissions prompt, clicking IIS_IUSRS, click the checkbox by Modify in the list below.

<img src="https://developer.qrimp.com/attachments/55bf722b-d758-4f3f-932e-4e54df8e38cf/Vista1.png">

<h4>Install .NET 3.5</h4>
You can download the redistributable from <a href="http://www.microsoft.com/downloads/details.aspx?familyid=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en</a>

<h4>Reboot</h4>
A reboot here is necessary to let all the components come together. You may also want to use Windows Update to add any service packs that are necessary now.


<h4>Configuring IIS and Qrimp</h4>
From the Control Panel, under Computer Management > Services and Applications > Internet Information Services

Drill down to ComputerName > Web Sites > Default Web Site > qrimp

Right click choose Convert to Application

Either modify the web.config or the application settings > connectionstring to point to the intranet database created above. If you use notepad, you'll have to run notepad as Administrator to save the file.

<h4>Accessing Qrimp Locally</h4>
After all this is finished, type this into your browser:

<a href="http://localhost/qrimp">http://localhost/qrimp</a> (if you are using the default qrimp folder) or
<a href="http://localhost">http://localhost</a> (if you moved Qrimp to the root url, which we prefer)

Now you will step through a couple install screens. Qrimp will download the latest database configuration files from the Internet, create your database, and register the installation with us. After that you are good to go. You can synchronize with an application online by visiting http://localhost/qrimp/synchronize.aspx or http://localhost/synchronize.aspx and entering the details for another Qrimp application.

<h4>Potential Problems</h4>
<Strong>Directory browsing is not allowed</strong>
If you get an error that directory browsing is not allowed, then you probably forgot to add ASP.NET to the list of IIS technologies to install. See the first step above.

<strong>SQL Server Connection Problems</strong>
If you access the url and it redirects you to a page asking you to configure the database settings, but you have already configured them in the web.config, then your SQL Server instance may be configured to accept Windows Authentication only, see: <a href="http://support.microsoft.com/kb/555332">http://support.microsoft.com/kb/555332</a>

To enable mixed mode authentication, see this tutorial on the web:
<a href="http://www.hostmysite.com/support/vps/windows/mixedmode/">http://www.hostmysite.com/support/vps/windows/mixedmode/</a>

<strong>Blank Page Displayed</strong>
If you access Qrimp through the browser, but see a blank page, then there may be a problem with some of the security settings for IIS, which needs to write temporary files to the system.

You can test this by creating a test.aspx file in the wwwroot folder and trying to access it via http://localhost/test.aspx If you see an error indicating access is denied to c:\windows\temp or something like that, see this page for help enabling the correct security on that folder: <a href="http://geekswithblogs.net/ranganh/archive/2005/05/13/39582.aspx">http://geekswithblogs.net/ranganh/archive/2005/05/13/39582.aspx</a>		Working Offline, Backing Up, Getting Data out
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing