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
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
deleteedit65Adding Related DataYou can add a link to the footer (#rightcontent) of a table that makes it easy to create a new related item (in a different table). One example of related data is the "add attachments" link that you see in almost every table.

In this example, let's say we wanted to be able to quickly look at Poll Numbers associated with that particular candidate. To do this, we'll add a link in the footer of the table.

<img src="/attachments/f8757fc8-aefe-4a8c-8c31-c27429dec238/AddRelatedData1.png">

Related Data
deleteedit1265AutomaticIDsQrimp automatically assigns every table and every record in every table an id number. This number is used by the system to identify those tables and records. IDs are created sequentially and start at 1 for the records in a table.

By default, you will see the id for a record in the [grid view] for a table. Click the id number to go to the [detail view] for that record.

<img class="border" src="attachments/developer.qrimp.com-5d15d512-7b06-4546-bf2d-e1b81cb2f754/ids.png" />

The default link or <a href="db.aspx?t=helptopics&id=261&vid=11">url</a> for each record will also show the id. You can find this in the [location bar] of your browser. The url for customer with an id of 238 will look like this:

<strong><noeval>http://myapp.qrimp.net/db.aspx?t=customers&vid=11</noeval><span class="error">&id=238</span></noeval></noeval></strong>

The customer with an id of 238 is the 238th customer that was added to your system. If a record is deleted, the id numbers in that table will become non-sequential.		Table Best Practices
deleteedit152Tutorial - Importing DataIn 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.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="1026" height="786" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/Tutorial-Importing-Data.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/Tutorial-Importing-Data.swf" width="1026" height="786" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>		Import Data
deleteedit212Importing Large Datasets<!--<nobreak>-->
The following tips and tricks will help you import large datasets. If you are working with a small dataset, you can use the menu item Develop > Import data. See [Import Data].

<h3>Copy Paste from Excel to Form</h3>
Keep the number of rows under 10,000 and the width less than 8,000 characters. We've noticed IE pastes large data sets better than Firefox. Sometimes the browser will crash if you try to paste a very large data set into a text field. So if this happens, try using one of the methods below. You can also paste this data into a .txt file and upload it using the Tab delimited file method described below.

<h3>Tab Delimited File Upload</h3>
One flat file import can be many megabytes, but upload time will depend on your connection speed. Since this is just one flat file, only a single table will be built. All the data should be consistent, meaning all date fields should be valid dates, numbers should all be numbers, no letters in the number fields. These rules apply to all import methods.

<h3>Excel 97/2000 .xls Import</h3>
File size < 20 MB, < 100,000 records per sheet, fewer than 20 sheets. Match sheet names to table names in Qrimp. Use this if you want to build the relational model to support multiple data sets automatically. Each sheet will be a table.

<h3>Importing Large Datasets</h3>
If you are converting an existing application or have extremely large sets of data you need to import, then the web is not a viable option. Because network latency, script timeouts, and other factors designed for a high scale environment like a web application are not designed to accommodate very long running batch processes, we need to import large sets without using the web.

<h3>Qrimp Hosted</h3>
If you are using Qrimp's Hosted solution, you can import data using the Rest-like API. This could take a while with millions of records to import, so in a scenario like this, it may always be best to contact support first. You can also download the [Qrimp Server Installation] and use the method described below.

<h3>Qrimp Enterprise Solution</h3>
If you are using the Enterprise solution installed on your local network, there are many options available for importing data. You will probably want to get help from someone experienced with Microsoft SQL Server to perform one of these import options.

The first step to importing a large data set with Qrimp installed is to define the application. This is usually easiest using Qrimp's web interface to define tables manually. This process will create the underlying primary keys, foreign keys, and support tables needed to run your Qrimp application.

A more difficult, but more flexible way is to define the data model directly using SQL Management Studio, export from UML, Earl, or some other relational modeling tool. For this to work, each table must have an INT IDENTITY field named id.

The next step is to get the data into your data model.

<h3>Data Transformation Services (DTS)</h3>

Qrimp is built on top of the Microsoft SQL Server product, so getting data into Qrimp is similar to migrating data between any existing databases. The best way we have found is to use Microsoft's DTS to import the data. Here are a few resources on the Web to help you understand how to use DTS to import your data.
<a href="http://technet.microsoft.com/en-us/library/ms365330(SQL.90).aspx">
Creating a DTS Package with SQL Server 2005</a>

<a href="http://technet.microsoft.com/en-us/library/ms365330.aspx">Creating a DTS Package with SQL Server 2008</a>

<a title="Permanent Link: Data import / export with SQL Server Express using DTS Wizard" rel="bookmark" href="http://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/">Data import / export with SQL Server Express using DTS Wizard</a>

You can download DTS for SQL Server 2005 Express here:
<a href="http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi">http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi</a>

<a href="http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en">Download More Microsoft SQL Server 2005 Express Tools Here</a>
<!--</nobreak>-->		Import Data
deleteedit1331Legacy Fields Imported from WebOfficeThrough out your newly imported Webex WebOffice system, you may find some fields with names like these:

Owning Record ID, Owning App ID, Modified or Created, Activity Flags, and some others that can be confusing.

We've adapted the first one, Owning Record ID to point to the original record in your system.

The last three are no longer used. Qrimp tracks the createid and createdate in separately. The modified date is stored in the Audit Logs. You can hide the last three unused fields by adding adding the following to your Qrimp App Skin, via Design > Skins.
<pre>
#OwningAppIDdiv,td.owningappid,#OwningAppID{display:none}
#Modifieddiv,#Createddiv,td.created,td.modified,#Modified,#Created{display:none}
</pre>		Import Data
deleteedit259Grid EditGrid edit is a [view] that makes data entry faster.

You also use the Grid Edit view to re-order columns in your [database table]. See [reordering columns].

In grid edit, you look at multiple rows in your table, and you can click each field to edit it from the table, without going into each record.

To get to grid edit, go to the table you want to edit and select the "Grid Edit" sub-menu tab.

<img class="border" src="attachments/developer.qrimp.com-ce4f3be9-1b73-45e0-86e6-1a0614eb76d6/grideditmenu.png" />
--------
Click the field you want to edit. Edit your data. Click save when you are finished.

<img class="border" src="attachments/developer.qrimp.com-e705a79e-1bc2-437d-9cfe-595d4d2936df/gridediting.png" />

<h2>Advanced: Grid Edit Query String</h2>
Enter &_showeditgrid=true" in your query string to get a grid view for any table. (See [query strings]).		Entering and Editing Data
deleteedit1339Entering Currency AmountsIf you have chosen currency as your [datatype], there is no need to enter the $ with the amount.

If you do this, you will get an error message stating you have entered a value that was not the correct type. (See [Error Messages]).		Entering and Editing Data
deleteedit245Why can't I see my column in grid view (view 1)?There are a couple reasons why you may not be able to see a newly added column to a table in your Qrimp app.

First reason, some apps may have a setting that only shows 10 columns at a time in the grid view.

To see more columns, go to Design > Form Designer. Click "Edit Column Labels" in the right hand column. Click on the "N" in the "Hide In Table" column for the column you wish to show.
Return to your table to see your column.

The second reason your column may not appear would be due to [Column Security] being enabled on the Table. When column security is enabled, you'll see a message at the top of the table description after you add the column letting you know that you'll need to configure column security to enable users of the system to see the column you just added. In that message is a link to configure column security.

If you miss the link, you can easily get to the column security configuration page by hovering over Develop, clicking Table Management. Then find the table you added the column to and click the Column Security link for that table. You'll notice on the configuration page that appears that the checkboxes for the new field are all empty for all the groups. Click the checkboxes for the groups you'd like to see the column. Your changes are saved automatically.
Showing and Hiding Columns with the Query String
deleteedit208WidgetsYou can also add widgets to your form to create borders around groups of text entry fields or to otherwise spruce it up. Watch the video below for more a demonstration of widgets.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="876" height="728" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-12-05_0209.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-12-05_0209.swf" width="876" height="728" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>		Form Designer
deleteedit1291Form Field LayoutWe have changed the name of the form field layout feature. Please see [Form Designer].Form Designer
deleteedit1341Hidden Page VariableQrimp has a special hidden HTML form field called "page" that allows you to configure where the user goes to after clicking a link, creating or saving records.

To modify the location the user goes to, Design > Design Mode ON. Go to the form from which you want to control where the user goes to after clicking the button.

Click the gear near the buttons. You'll find in that HTML a hidden INPUT form field called "page". You can change this variable to a URL that you'd like the user to go to after submitting the form. This URL can contain variables that are updated with values from the saved form you can also use [square brackets] to include SERVER variables like the HTTP_REFERER to send the user back to the page they were on when they clicked the edit or add new link.

<h2>Add a Create and Add Another button</h2>
Sometimes, you may want the ability to quickly create a lot of items at once. On the add new item screen (vid=8 in the url), you'll want to edit the header footer, add the button, and then when that button is clicked, change the value of the hidden page variable so that it sends the user back to the page you are on, rather than going to the detail view of the newly created item.

Here's how to do that. First, be sure design mode is on according to the instructions above. Then, go to the Add New form where you want to create many items quickly.

Click the gear next to the save buttons at the bottom. A lightbox will appear with the HTML for the Create and Cancel buttons. We'll add another button. To do that, copy the Text that starts with the Less than sign and INPUT type=submit. Select all of that text through to the Greater than sign. That's one HTML tag for the create button. Copy and paste it.

Change the value of the pasted INPUT button to "Create and Add Another". You'll need to have all of that text including the quotes so your browser knows to include all of it on the button. Now, we need to add another attribute to the input tag that changes the hidden PAGE variable. Add onclick='$("#page").val(document.location.href);' somewhere inside the newly copy/pasted INPUT field.

Next, add an attribute to the HIDDEN page variable that we can use to tell JavaScript which input value to update. Just add id="page" inside the HTML tag for the hidden input variable named page.

Your new HTML inside the lightbox should look like what is in the TEXTAREA below. In most cases, you can probably just copy/paste this HTML into your lightbox area to get the results we've described here.
<textarea><INPUT type=submit value=Create name=op class=button> <INPUT type=submit value="Create and Add Another" name=op class=button onclick='$("#page").val(document.location.href);' > <INPUT type=hidden value=5 name=o><input type=hidden id=page name=page value="db.aspx?t=HelpTopics&vid=11&id={id}"> <a class=button href="javascript:history.back()" title=Cancel>Cancel</a></textarea>


Click save. Now you can click the "Create and Add Another" button to quickly add a lot of items to the same table.






Form Designer
deleteedit41PicklistsSee [Look-up Tables].Definitions
deleteedit42DatatypeA datatype is a type of data. Some data types include currency, decimals, text, date/time, yes/no and [look-up tables]. Choosing a datatype allows you increase data accuracy by restricting which kind of information users can enter when they are creating new records.

<h2>Data Accuracy</h2>
Choose a datatype that accurately describes which type of data a field will contain will make your application more efficient and less error-prone. It will also make any reports and charts you generate more precise. Think carefully about which datatype is most appropriate for your field. If you create a field called HireDate in your Employees table, choose the datatype date/time, users will only be able to enter properly formatted dates. If you chose a less specific datatype, such as Multi-line text, employees could enter the entire story of how they were hired in the HireDate field.		Definitions
deleteedit73Reserved WordsThe following is a list of special words that are used in the code and cannot be used as the name of a table or column.
<ul><span id=reservedwords></span></ul>
<script>
getContent("db.aspx?t=reservedwords&vid=15&pagesize=800&noheader=true&nofooter=true","reservedwords",true);
</script>		Definitions
deleteedit78Data TableRead more about <a href="http://en.wikipedia.org/wiki/Table_(database)">database tables</a> on wikipedia.Definitions
deleteedit99Look-up TablesLook-up tables are tables that are connected to other tables as drop-downs to make data entry easier. This is very convenient for oft-repeated data entry areas, such as country or say 'productcategory'. Enabling users to select data from a drop is great for data integrity, increasing accuracy and reducing spelling errors.

In this example, FurColor is a look-up table:

<b>TeddyBears</b>
Name: Fuzzy
Nickname:<input type=text size =20 id=name name=name maxlength=50 >
FurColor: <select name="datatype0"><option value='pickfrom_accounttypes'>Brown</option><option value='pickfrom_t_furcolor'>White</option><option value='pickfrom_t_users'>Blue</option><option value='pickfrom_t_views'>Black</option><option value='pickfrom_yesno'>Beige</option></select>

I could only have this drop-down if I already have a FurColor table in my application.

See also [Creating a Look-Up Table], [Adding a Drop-Down Field], and [Convert a Field to a Drop-Down].
Definitions
deleteedit148Iterative DevelopmentIterative 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 <a href="http://en.wikipedia.org/wiki/Iterative_development">article on iterative development</a> at wikipedia.		Definitions
deleteedit150IconsIcons are used throughout Qrimp applications as visual cues. You can use icons anywhere in your application for any reason.

<img class="border" width="500px" src="/attachments/developer.qrimp.com-2779e58c-5d00-47c6-aaf0-1aac672f08f1/pageoficons.png" />
<span class="small">Qrimp has a large selection of icons to choose from</span>

<h2>Using Icons in your HTML</h2>

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" (<a href="db.aspx?t=helptopics&id=261&vid=11">url</a>) of your img tag (src=).

Pull the image from the icons folder using a relative url, like this:
<textarea>
<img src="/icons/crystal_project/32x32/actions/edit_add.png">

This will pull in the icon, like so: <img src="/icons/crystal_project/32x32/actions/edit_add.png"> or so <img src="/icons/crystal_project/16x16/actions/edit_add.png"></textarea>

See also: <a href="db.aspx?t=helptopics&id=70&vid=11">Icontheme</a>
[Action Icons]		Definitions
deleteedit175CRUDIn every Qrimp app, there are five default [operations] that users can perform on a database: Create, Read, Update, Delete and Admin. To allow your users to perform these operations, give them the permission to do so using [Table Security].

You can create as many levels of access as you like. Add, remove, or adjust the configuration of existing operations to fine tune the capabilities your users have within your Qrimp Application.

Learn more about CRUD by searching the web.		Definitions
deleteedit203HTML<h2>What is HTML?</h2>
HTML stands for Hyper Text Markup Language, it is how web pages are made. Knowledge of HTML will help you modify the way your Qrimp application is displayed, but is not required to use a Qrimp app.

<h2>Working with HTML</h2>
You can see the HTML for any web page by using the Developer Tools in your web browser. You can also right-click and select View Source or View Page Source.

You can use HTML in a Qrimp app when editing records, in the Header/Footer for records, in Views, and in Field Templates. You will need to make sure that your user group has permission to edit HTML (See [User Groups].

Here are some resources to help you learn HTML.
<a href="http://www.w3schools.com/html/">W3C Schools HTML Tutorial</a>
<a href="http://www.w3.org/MarkUp/Guide/">Dave Raggett's Getting Started with HTML</a>
<a href="http://www.echoecho.com/html.htm">EchoEcho.com's HTML Tutorial</a>
<a href="http://www.davesite.com/webstation/html/">Interactive Tutorial for Beginners</a>		Definitions
deleteedit252Database tableA database table is the master sheet of data in a particular area. It is best to create a new database table for each separate type of thing ie: Contacts, Contact Type, Employees, Inventory, Tasks, Invoices, etc. See also [Introduction to Tables].

To see all of your database tables go to Develop > Manage Tables. (See also: [Manage Tables])

Database tables can be linked together with relationships. For example, one employee may be related to many tasks. This would be a 'many-to-many' relationship. See [Many-to-Many].		Definitions
deleteedit261urlA url (uniform resource locator) is the string of words and symbols that makes an address on the internet.

<img class="border" src="attachments/developer.qrimp.com-69a2f894-65ef-4795-bcdc-064b54a403e9/url.png" />
<span class="small">A url</span>

If you type in www.qrimp.com into the [location bar] of your [web browser], you have just written a url.

Links on websites are also urls.

A url usually has two parts. A file path leads to a location on the internet, like a website, and [query strings] contain parameters that specify which data from a site or database to pull back into your browser for display. Query strings are used when a website communicates with a database - the information in the query string tells the database which data to pull in to the web browser.		Definitions
deleteedit262location barThe location bar or address bar is the part of your [web browser] where you type in a website address on the internet. Most browsers will also let you enter a search query.Definitions
deleteedit263web browserA program used to browse the internet. Common web browsers are Chrome, IE, Firefox, Safari and Opera.

<img class="border" src="attachments/developer.qrimp.com-aeee3ea5-8820-43ec-aa22-10774895d5af/webbrowsericons.png" />
<span class="small">Some web browser icons</span>

Many smart phones have built-in web browsers.		Definitions
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing