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
deleteedit185Input Security RestrictionsTo add additional security around data Qrimp allows you to add white and black lists.

A Whitelist will only allow the characters specified in the list.

A Blacklist will strip out the characters specified in the list.

To add either functionality to a system the first step is Develop > System Tables.

<img src="/attachments/f4f304ca-0b5b-4e8c-89b1-85ee86b74279/Security5.jpg">

Then click on the t_groups WITHOUT the magnifying glass.

<img src="/attachments/abb21f03-1668-48e8-a0a7-82df4892155f/Security6.png">

To add the additional field to the table click on the Table Management Icon in the [Content Header]

<img src="/attachments/0ea6eb9a-40f6-4f4a-89d3-34398246ec58/S.png">

Scroll down to "Add a Column" and input either inputwhitelist or inputblacklist all one word

<img src="/attachments/d628e2dc-67b7-4906-a578-b097597ea4ba/Security8.png">

Once the column is added there are two steps. First you must log out and log in to make the change take effect. Then go back to the table and click Design > Field Layout to move the field to a usable spot.

It should look like this when complete. Now click the Edit Icon in the [Content Header] enter in the characters that can ONLY be entered. For this example lets say I don't want numbers. I will only include the 26 letters of the alphabet and click save.

<img src="/attachments/651ac779-8356-460b-8f2f-a3b3f84ea600/Security9.png">









The System Tables
deleteedit265Changing a DatatypeTo change the [datatype] for a field, go to your table, then to Develop > Table Management.

Choose the field that you want to change and click 'change datatype'.

<img class="border" src="/attachments/c8ae671f-4210-4ab4-a9cf-848a68f2470d/ChangeDatatypeLink.png" />

In the dialog box, select a new datatype from the drop-down list.

<img class="border" src="/attachments/ab431970-6824-42f2-b9e1-164566e1d93b/ChangeDatatype.png" />

<h2>Before you Convert</h2>
Make sure your data is clean. Use the [grid edit] view and sort by the column you wish to convert to a drop-down.

You would not want to change this data to a drop-down:

Category:
Restaurant
Gas Station
Reeatruant
Restaurant
Grocery Store
Diner
Grocery STrore
Gas Station
Restaurant
GroceryStore

If you converted data like that, every time someone was picking from the drop-down they would see all the misspellings!

So take the time to correct them first.		Manage Tables
deleteedit20Adding SkinsTo change the look and feel of the site, go to the Design tab and click on [Skins]. Enter the url to your stylesheet.

<img src="attachments/6c9fb3b8-6046-4d32-a767-ad3478d2a4f5/Skins.jpg">

To customize all of the elements that we use on our site, download the <a href='styles/twocolflexbannerbrochure.css'>default stylesheet </a> and edit the properties you would like to change.

To get your CSS files onto the server, create a project you'll use to manage your style sheets and upload the CSS file as an attachment. Then use the url of the attached file as the URL you paste in the URL box.		Changing the Look and Feel of Your App
deleteedit207Convert a Field to a Drop-DownTo convert a field to a drop-down (also known as pick-from or look-up table), first go to the table with the field you want to convert and go to Table Management.

<img class="border" src="/attachments/3f1407ef-0b8c-4d3a-bace-966c351ad865/Lookup1.jpg">

Beside the column you wish to convert, click the "Convert to Pick From List" link.

<img class="border" src="/attachments/622bbe93-f4ad-4e7d-b1ab-69b239a2fb7b/Lookup2.png">

You will get a warning pop-up asking you to confirm the change. Click okay. Once you have converted the field, you will notice a magnifying glass in your table management list and a link to the look-up table.

<img class="border" src="/attachments/f60ca418-8cdd-4f9b-8db2-4f5e4ea68c74/Lookup3.png">

As always when adding a new column, use the [form designer] to position the new field in your [Detail View]/[Edit View]/Add New View.		Creating a Look-up Table
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
deleteedit179Custom Pagination Look and FeelTo create your own Custom Paging for your system you will have to write some [JavaScript].

First, you will call the subset of numbers from the database that you will want to use to create the custom pagination.

You can call the subset two ways: JSON or XML.

If you use JSON:

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow:scroll white-space: nowrap ;">paginationJson = getUrlString('db.aspx?t=Inventory&vid=73&noheader=true&nofooter=true&_pagingInfo=JSON' + filterQueryString)</div>

This URL will pull the subset of numbers

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; white-space: nowrap ";">{"paginationInfo":{"pageSize":9,"numPages":9,"numRecords":79,"currentPage":1}}</div>

Then you must parse the information. In the example we pull the parser from the Yahoo JavaScript Library.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; white-space: nowrap ;"> try {
var paginationInfo = YAHOO.lang.JSON.parse(paginationJson).paginationInfo;
}
catch (e) {
alert(e);
}</div>

Finally, you can assign the global variables and begin to manipulate the page to create your own Custom Pagination.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ";">numPages = paginationInfo.numPages;
currentPage = paginationInfo.currentPage;
numItems = paginationInfo.numRecords;
pageSize = paginationInfo.pageSize;</div>



If you use XML you will parse the information differently

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ">try //Internet Explorer
{
xml=new ActiveXObject("Microsoft.XMLDOM");
}
catch(e)
{
try //Firefox, Mozilla, Opera, etc.
{
xml=document.implementation.createDocument("","",null);
}
catch(e)
{
alert(e.message);
}
}
var url = 'db.aspx?t=inventory&vid=73&qid=3&_paginginfo=true';
xml.async=false;
xml.load(url);
//<paginginfo><pagesize>25</pagesize><numpages>0</numpages><numrecords>92</numrecords><currpage>1</currpage></paginginfo>
document.write('numpages=' + xml.getElementsByTagName("numpages")[0].childNodes[0].nodeValue + '<br>');
document.write('pagesize=' + xml.getElementsByTagName("pagesize")[0].childNodes[0].nodeValue + '<br>');
document.write('numrecords=' + xml.getElementsByTagName("numrecords")[0].childNodes[0].nodeValue + '<br>');
document.write('currpage=' + xml.getElementsByTagName("currpage")[0].childNodes[0].nodeValue + '<br>');
</div>

As you can see XML does its own set of calls for the parsing. IE and other browsers are different so the beginning is checking to see what browser it is. Then the numbers get called in the query string just like JSON. The main difference is the way the strings are parsed.

Now you can manipulate the variables to the your type of Custom Pagination.

Here is an example of a 'footer' Custom Pagination for a shopping cart of items.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ">
function createItemListFooter () {

paginationJson = getUrlString('db.aspx?t=Inventory&vid=73&noheader=true&nofooter=true&_paginginfo=json' + filterQueryString);

try {
var paginationInfo = YAHOO.lang.JSON.parse(paginationJson).paginationInfo;
}
catch (e) {
alert(e);
}

numPages = paginationInfo.numPages;

currentPage = paginationInfo.currentPage;
numItems = paginationInfo.numRecords;

var paginationHtml = "";

for (var i = 1; i <= paginationInfo.numPages ; i++) {
if (i == 1) {
paginationHtml = paginationHtml + "<div id=page" + i + " class=\"selectedPage pageNumber\"><a href=\"#\" onclick=\"displayPage(" + i + ")\">" + i + "</a></div>";
} else {
paginationHtml = paginationHtml + "<div id=page" + i + " class=pageNumber><a href=\"#\" onclick=\"displayPage(" + i + ")\">" + i + "</a></div>";
}
}

if (paginationInfo.numPages > 1) {

paginationHtml = paginationHtml + "<div id=nextButton class=prevNextButtons><a href=\"#\" onclick=\"nextPage()\">Next</a></div><div id=prevButton class=\"prevNextButtons hide\"><a href=\"#\" onclick=\"previousPage()\">Previous</a></div>"
}

document.getElementById("itemListFooter").innerHTML = paginationHtml;
}

function displayPage (pageNumber) {

if (pageNumber != currentPage) {

YAHOO.util.Dom.removeClass("page"+currentPage, "selectedPage");
YAHOO.util.Dom.addClass("page"+pageNumber, "selectedPage");

if (pageNumber == 1) {
YAHOO.util.Dom.addClass("prevButton", "hide");
} else if (currentPage == 1) {
YAHOO.util.Dom.removeClass("prevButton", "hide");
}


if (pageNumber == numPages) {
YAHOO.util.Dom.addClass("nextButton", "hide");
} else if (currentPage == numPages) {
YAHOO.util.Dom.removeClass("nextButton", "hide");
}

currentPage = pageNumber;

displayItemList();

}

}

function nextPage() {
displayPage (currentPage + 1);
}

function previousPage() {
displayPage (currentPage - 1);
}
</div>

This code manipulates the JSON from the above example to create this:

<img src="https://developer.qrimp.com/attachments/664353d5-59b5-4408-90db-7a08300aefe3/PaginationFooter.png">

<img src="https://developer.qrimp.com/attachments/218508a3-c74d-404a-86e4-e52ca0e0cae5/PaginationFooter1.png">		Javascript and JQuery in Qrimp
deleteedit1277Delete an AttachmentTo delete a single attachment, go to the record that your item is attached to. Click the attachments link on the right-hand side at the top.

<img class="border" src="attachments/developer.qrimp.com-226976cd-1c68-4807-98f4-48f100319144/clickattachmentslink.png" />

Click the delete icon next to the item you want to delete:

<img class="border" src="attachments/developer.qrimp.com-ad673804-608c-4770-ab4e-e5792961fff8/deleteattachmentgridview.png" />

You will get a warning asking whether you are sure you want to delete this item. Click Okay to delete.

<img class="border" src="attachments/developer.qrimp.com-590bbbd6-17d5-43cb-b84b-93c517188fe0/areyousureyouwanttodeletethisitemattachment.png" />

Your item will be deleted from your database.		Attachments
deleteedit1270Deleting a UserTo delete a user, go to Admin > Manage Users.

Click the name of the user you want to delete:

<img class="border" src="/attachments/developer.qrimp.com-e624ebb2-0412-447f-a283-5f180dba3538/clickusername.png" />

In the [ContentHeader], click the red X delete button:

<img class="border" src="/attachments/developer.qrimp.com-c6a1fe39-81aa-48b4-9e45-7a7ff3f3c146/userdeleteormakeinactive.png" />

If the user has created records, or has permissions associated with their account, you will either need to delete or reassign those records:

<img src="attachments/developer.qrimp.com-d46cd829-58fe-4e81-a885-6bc04deab9c7/cantdeleteuserbecauserecords.png" />		Managing Users
deleteedit1282Delete Multiple AttachmentsTo delete multiple attachments, go to the record that your items are attached to. Click the attachments link on the right-hand side at the top.

<img class="border" src="attachments/developer.qrimp.com-226976cd-1c68-4807-98f4-48f100319144/clickattachmentslink.png" />

Click the checkboxes beside each item you wish to delete:

<img class="border" src="attachments/developer.qrimp.com-f5f0b1c0-608a-4b54-8775-6a2100d1b320/deletemultipleattachments.png" />

You will get a warning asking whether you are sure you want to delete all of these items. Click Okay to delete.

<img class="border" src="attachments/developer.qrimp.com-61066e9e-83c3-4540-9d02-e623beb98112/areyousureyouwanttodeletealltheseitems.png" />

Your items will be deleted from your database.
Attachments
deleteedit72Drop a ColumnTo drop a column, first make sure that you are viewing the table that you want to drop the column from.

Next, go to Develop > Table Management. You will see a list of your tables with several options below each. Click the 'edit' option. You will see a form showing the fields in your table, with an options column on the right. Under the options column click the 'delete' link in the row for the column you wish to drop. You will be prompted before you can delete the column.

Be careful! Deleting a column will delete any data that you have entered into the table!		Manage Tables
deleteedit1283Edit an Existing Custom ViewTo edit an existing custom view, go to the [grid view] of your table.

Choose the view you want to edit from the drop-down list of views.

Click the link that says "Edit View"

<img class="border" src="attachments/developer.qrimp.com-c31964c8-6dd8-4d6b-acb8-77bb3e6e898b/editexistingview.png" />

Edit your view to suit your needs.

See also [Custom Views (Sorting and Filtering)]		Custom Views (Sorting and Filtering)
deleteedit247Custom Views (Sorting and Filtering)To enable custom views, you must install the custom views module. Go to Develop > Add Modules. Scroll down to "Custom View By Reports" and click "Add module".

To add a new custom view, go to the [grid view] of your table. At the top of the page you will see a drop down that shows "View By". In the drop down, select "Add new view".
<img class="border" src="/attachments/developer.qrimp.com-5cf417dc-577b-47ba-b6e2-0f10b9a36501/custom views add new.png" />

Enter a Name for your view and select whether you want to make it the default view for yourself or all other users. Choose the columns you wish to appear in the view. Put the columns in the order you would like them in.
<img class="border" src="/attachments/developer.qrimp.com-5c26dc45-db4c-4c6a-859b-87f470f11700/custom views 1.PNG" />

If desired, you can add further sorting and grouping to your columns.

Note: You must select a column in the GroupBy section in order to add totals for your view.

<img class="border" src="/attachments/developer.qrimp.com-2eda0aab-df5f-49a6-9ffe-e04b1236e459/custom views sorting and grouping.png" />

You can also add optional filters to the view, to only show data that meets certain requirements.
<img class="border" src="/attachments/developer.qrimp.com-4e89830b-e98a-48f8-8917-e564829492da/custom views filtering.png" />

Select which users and/or groups can see the view:
<img class="border" src="/attachments/developer.qrimp.com-28f2f10b-1f33-4a20-adab-89a885b6fbc2/custom views permissions.png" />

Last but not least, click Save:
<img class="border" src="/attachments/developer.qrimp.com-93ddb351-22ea-4b1d-a018-2856d3973e14/custom views save.png" />

And then you have a view. This is a very simple view of Teams by year formed.
<img class="border" src="/attachments/developer.qrimp.com-655b7af9-1337-49e7-a310-a26357c3edb7/custom views teams by year.png" />
Views
deleteedit63Entering and Editing DataTo enter data, go to the menu tab for your table, which appears on the top or left of your window. Hover over the tab, click the add icon in the sub-menu.

To edit records from the grid view, click the edit icon <img src="/images/edit.gif" /> next to the row you would like to edit.

To edit items from the [detail view] click the Edit icon <img src="icons/crystal_project/32x32/apps/kate.png" /> in the [Content Header].

Clicking on this icon takes you to the [Edit View].		Working with Data
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
deleteedit59Enabling the Attachments SidebarTo keep the size of your Qrimp application small, the attachments sidebar is not automatically visible on every table. If you would like to see attachments on the right in the [detail view] of each record, the table must be created with 'Attachments' enabled. If you do not see the attachments box to the right of your item, this option may not have been turned on. You can add it by following the instructions below.

<h2>Creating Tables with Attachments Sidebar Enabled</h2>
When you add a table, click the checkbox beside "Enable Attachments” in the Advanced options. (See [Add a Table]).

<img alt="Enable Attachments Checkbox" src="/attachments/105659f8-adf8-4c89-8658-69cfbd79a23a/Capture.PNG">

<h2>Enabling Attachments Sidebar for Existing Tables</h2>
If you created a table without the attachments sidebar capability (see above), you will have to add some code that will turn this feature on for a table.

First, go to the table you want to add the sidebar to. Then go to Develop > Header/Footer (see [Headers and Footers]). Copy and paste the following HTML into the footer section:

<textarea height="200px"><div id="attachmentsdata" class="relateddata"><h4><a href="db.aspx?t=attachments&tableid=1006&itemid=59" title="View All Attachments...">Attachments</a></h4></div><a href="uploadfile.aspx?t=1006&id=59&vid=11" id="Attachmentsadd" title="Upload Attachments...">add</a><script>showHtml("attachments&tableid=1006&itemid=59&vid=21&orderby=1,1","attachmentsdata");</script></textarea>

<em>Note: be sure to change the id number (tableid=1006 and t=1006) of the table to the id of your table. (See [automaticids]</em>		Attachments
deleteedit1269Managing UsersTo manage users and user groups go to Admin > Manage Users.Security
deleteedit64Rename TableTo rename a table, navigate to your table, then go to Develop > Manage Tables > Find your Table in the list.

Below the name field, there is a link "rename table". Click on it. Choose a new name for your table and click save.

<span class="error">Caution: Default sub-menus will be renamed to the name of the new table</span>

Rarely, but sometimes, renaming tables can be problematic if you have other tables or data in your application that refers to the table you want to rename.		Table Settings
deleteedit213Reordering columnsTo reorder the columns in a table, go to the [grid edit] view of the table. Click and hold the column header of the column you wish to rearrange. A multi-directional arrow icon will appear and a red line will show to the left side of the column you are moving. Hold and drag the column to its new position. All views will be updated to reflect your new column order.

<img class="border" src="attachments/developer.qrimp.com-1cd04005-3933-4475-8b37-998704321f50/grideditreorder.png" />		Grid View
deleteedit1322Table SearchTo search a table, click on the search icon <img class="noborder" align="absmiddle" src="/icons/crystal_project/32x32/actions/filefind.png"> in the [Content Header].

<img class="border" src="attachments/developer.qrimp.com-9abb3da6-dba7-45dc-b14e-bf8797606785/tablesearch.png" />

You will see a dialog box that will allow you to enter criteria for your search:

<img class="border" src="/attachments/12e532dc-8bc0-46c0-b26b-11494d7d4bbb/searchdialogbox.png">

Choose a search filter from the drop-down list of operators (contains, greater than, equals, etc.) to limit the results of your search. For example, if we only wanted to find modules that contained the word "tasks" in the description field, our search would look like this:

<img class="border" src="/attachments/fca0436d-1a11-4662-8b1a-9e6a22b370a5/searchfilter.png" />		Search
deleteedit1321Date SearchTo search by date, look near the top right of your app. You will see a calendar icon. Click on the icon.

<img class="border" src="attachments/developer.qrimp.com-69e9ac70-5df6-44b1-8b2f-6f0b1996c8f9/datesearch.png" />

Click a date then click search.
<img class="border" src="attachments/developer.qrimp.com-075663bf-d8f2-4ff2-b862-ea8cc7d55dbc/dateinsearchfield.png" />

Your search results appear. They are linked to the database records, so click them to go to the record.
<img class="border" src="attachments/developer.qrimp.com-237ff48f-f87e-4ddc-9ec7-83738ee50b39/datesearchresults.png" />		Search
deleteedit1320Site SearchTo search your entire site (all tables in your Qrimp app), use the search field at the top right of your app.

<img class="border" src="attachments/developer.qrimp.com-6d5f06b4-168a-4841-962d-9e9d81031799/sitesearch.png" />

You will see a list of any tables that contain the word or number you searched for.

Click the link to go to that table or record.

Search
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
deleteedit50Drag and DropTo use the drag-and-drop calendar, go to the calendar view of a table.

Now when you put your mouse over the mini calendar icon <img src="/attachments/d8b7ffcf-fc7d-4ec9-ae46-a5428e455455/CalendarIcon.png"> in front of the task name, the cursor will change to the move pointer, on Windows machines, it's usually a cross with arrows. On Macs, it's a little hand.

Click and hold this icon to drag the task to another day on the calendar. The due date for the task will automatically update to the day you dragged the task to.
Calendar View
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
deleteedit182Adding a User GroupUnder Admin > [User Groups] you will find the default Groups: Administrators, Developers, Testers, Users and Anonymous. To add a new group, click the "Add New" Icon in the [Content Header]. Select the group security permissions you would like the user group to have and click Save.Managing Users
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing