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
deleteedit159Cancelling PayPal SubscriptionsThe following is from the PayPal website and tells you how to cancel your Qrimp subscription. We added screenshots to make it easier.

A subscription can be canceled up to the day of the next scheduled payment.

1. Log in to your account
2. Click the My Account tab.
3. Click the History subtab.
4. Choose the Subscriptions field from the Show drop-down menu.
<img src="attachments/6bc9e2f3-5360-4f88-9125-cb1fe80414a0/ppsubscriptionsdropdown.JPG" />
5. Check the From box and change the date back to your subscription date.
6. Click Search, and then click Details.
<img src="attachments/52ba7245-98a1-4c5a-902d-c90b2d3dfa73/ppsubscriptionsdetailslink.jpg" />
7. Click Cancel Subscription.
<img src="attachments/56f00d36-c3fa-42cf-99c3-6db5efb4ebc0/cancel button.JPG" />		Billing
deleteedit56Calendar ViewAll tables with a date field (Date/Time [datatype]) will be viewable on a Calendar. When the Calendar view is available, the calendar icon <img align="absmiddle" src="/attachments/d8b7ffcf-fc7d-4ec9-ae46-a5428e455455/CalendarIcon.png">appears near the top of the page in the [Content Header]. A link to the calendar view also appears by default in sub-menu tabs.

The Calendar View opens for the current month. You can select other months and years from the drop-downs at the top of the page. You can also go to a day view.

<h2>Tables with CreateDate and Other Date Fields</h2>
If you choose the [Auditing] option when creating your table, your table will be given a "createdate" field, which means that when you click on the Calendar View icon, you will see a calendar of when items were created.

If there is more than one Date field in a table, the Calendar will show items with the FIRST date column by default. Once you are in the Calendar, you will be able to choose to show the calendar with items from another date field using a drop-down box.

<img class="border" src="attachments/developer.qrimp.com-d2a90262-4623-4a26-8112-8eb1194a17ae/choosedateforcalendarview.png" />

For example, if I have a Projects table with two date fields "Start Date" and "End Date", when I first open the table in Calendar view, I will see items that Start on days in the month I am in. If I want to see when items end, I can choose "End Date" from the "View By" drop-down box at the top left of the view.

<h2>Changing Due Dates with Drag and Drop</h2>
You can [drag and drop] an item on the Calendar and the selected date field will update the item to the new date.		Views
deleteedit1330CachingCaching is a way that data from your website is stored temporarily in your browser to make your browsing experience faster. Caching is very common on the internet. Stored data is kept in your browser's cache, and can be cleared from your browser. Qrimp makes use of caching.

<a href="http://en.wikipedia.org/wiki/Web_cache">Wikipedia article on caching</a>		Definitions
deleteedit1325Building Your SystemEverything you need to know about how to build an app in Qrimp.
deleteedit39Brief Intro to Data Modeling<h2>What is a data model?</h2>
A data model is an organized overview of the data you need to keep track of, like a blueprint for your application. When you create a data model, you decide which "things" you want to store information about, and which information about those things is important.

<h2>Why model data?</h2>
Mapping out a data model before you start building your database will help you build a more efficient system. Data modeling is not required to build a Qrimp app.

<h2>Example</h2>
Let's say I have a grocery store. When I think about my information, I decide that I want to track the following "things":

- Employees
- Stock
- Suppliers

Information in a database is stored in tables. So in my database application, I will have three tables: Employees, Stock, and Suppliers. In each table, I enter further details about the things you want to keep track of.

In the grocery store example, I would create a <strong>table </strong>for each of these "things". I would also want to track certain information about each item, so I would add several columns in each table. For example, I would want to track my employees <strong>names</strong> and <strong>hire dates</strong>, so I'd add columns for those.

In a database, it's best to break down column names into the most detail possible. Rather than tracking "EmployeeName: Jane Doe" it's best to track "FirstName: Jane" and "LastName: Doe".

<strong>In other words...</strong>
What you have to do is think of the tables you'd like to create and decide which information you want to store. The tables will be the things we want to keep information about (ie: Books), and the columns will be specifics about that thing (ie: Author). Remember - Qrimp allows for [Adding Columns] if you think of something else you want to track later.

You create a table by navigating to Develop > Create Tables.

Once you have a basic set of data tables, you can manage your application by [Adding Columns] to existing tables and by creating more tables. You can also [Import Data] if you already have your information in spreadsheets or .csv files. Most applications, including Quickbooks, MS Outlook, banking websites and more allow for .csv export of data.

Here are some good links to help you get started with the concept of data modeling:

<a href="http://en.wikipedia.org/wiki/Table_(database)">Table (database)</a>
<a href="http://en.wikipedia.org/wiki/Relational_database">Relational Database</a>
<a href="http://en.wikipedia.org/wiki/Data_modeling">Data modeling (wiki)</a>
<a href="http://en.wikipedia.org/wiki/Database_normalization">Database normalization</a>
<a href="http://bytes.com/forum/thread585228.html">Database normalization discussion</a>.		An Introduction to Qrimp
deleteedit1297BillingCover topics related to paying for your Qrimp account and Services
deleteedit123Before You Start<!--<nobreak>-->
<p>Before you get started, think about what your application is for. Which information do you want to track? Which types of users do you want to have? Who will be able to view and change your data?</p>

<p>You may wish to start with a data model. If so, read our [Brief Intro to Data Modeling].</p>

<h2>Basic steps to creating a Qrimp app</h2>

<ol><li>Designing your data model</a></li><li>[Create Tables] <ul> <li>Option 1: Create Tables Manually</li> <li>Option 2: Import Data</li> </ul></li><li>[Entering and Editing Data]</li><li>Customize your Application with<ul> <li>Views</li> <li>Templates</li> <li>Headers and Footers</li><li>Security</li> <li>Menus</li></ul></li></ol>

<p>We recommend drawing out a list of tables and listing the columns you want to have before you get started. You can add additional tables, add rows, delete rows, change data types, and drop columns at any time, so nothing is set in stone. Having a structured idea of what type of database you will build before you start will save you time and help you mentally organize your information first.</p>

<p>There are many resources on the web that teach you about database methodology.<!--We have gathered some links for you here: <a href="db.aspx?t=HelpTopics&id=55&vid=11">Designing your data model</a-->.</p>

<p>Of course, you can also get started with no learning, and figure it out as you go! A good place to start is by adding your first data table. There are two ways to add data: [Create Tables] and [Import Data].</p>
<!--</nobreak>-->		An Introduction to Qrimp
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
deleteedit166Automating SynchronizerIf you would like to automate the synchronization process to create a [redundant fail over system] for [disaster recovery], you will want to automate your Synchronizer on an hourly or daily interval.

Automating Synchronizer will allow you to create two systems that are identical up to the last synchronize -- including data and file attachments.

Because the synchronize process takes a bit of time itself, remote copies of applications are not identical and should not be considered identical. Using Synchronizer in this way is fine for remote sites that are all copies of a master. In this way, your system can be set up as a [Content Delivery Network] to serve users in remote locations on Qrimp nodes closer to them. You can also [Automate Qrimp Publisher] in this way to push static copies of your site to remote servers around the globe.

Imagine a scenario where your data management happens inside a firewall and you publish content to a CDN outside your firewall. You could first deploy your application from inside the firewall to a secure node in the cloud. Remote nodes around the world could be set to automatically synchronize from that remote node, then publish their contents using templates customized to the locale of the visitors hitting those nodes.

If you would like to configure Qrimp to deliver your information in this way, please contact [Qrimp Support].		Synchronizer
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
deleteedit165Automated Backup ProcessIf you'd like to set up an automated process, here's how to do it.

Issue a form post to your application like this:
https://yourqrimpappurl/login.aspx
txtUsername= {your username}
txtPassword= {your password}
uid=true

You can also use a get, but then the logs show the query string in some server setups. Better to use a post.

Now, the response will contain a GUID representing the user who just logged in. Next, download a file from the following url using GET:
https://yourqrimpappurl/inserts.aspx?backup=true&download=true&uid={uid from above}

or more securely using FORM Post to:
https://yourqrimpappurl/inserts.aspx
backup=true
download=true

and then save the result to a local .zip file. By default, the filename will include the Qrimp app URL and the date and time in the file name, but you can save it as whatever filename you like.

Your file will be encrypted and zipped up and locked with a password to prevent tampering. If you ever need to restore your database to one of these points in time, then email [Qrimp Support] or [Open a Trouble Ticket] and we will restore your system. Additional fees may be required for certain hosted plans or download accounts.

Enterprise customers can backup their database to Amazon S3 in an automated fashion like this as well. Please contact [Qrimp Support] for more information about how to do this. We will soon be adding backup to Mosso CloudFS for databases smaller than 5 GB.

Also, remember, this does not copy the attachments, it only backs up the data. If you would like to copy attachments as well, use [Synchronizer] with automation.		Backing up your data
deleteedit40AuditingAuditing keeps track of who created an entry into the table and when. Adding auditing to your tables will allow you to use the [date search] feature to find all items created on a particular date.

You can also use auditing to quickly find all the items created by a particular user or setup security so that users can only see the items they have created.

<img src="/attachments/71aa356f-a1e3-4e2f-a880-3d8095cc6f6b/Auditing.png">

<strong>Please note the warning. To have the functionality to sync with your laptop you must select Auditing and Versioning.</strong>		Data Analysis
deleteedit137AttachmentsYou 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.

<h2>Viewing Attachments</h2>
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.
<img src="/attachments/3a94e630-8601-4710-8313-483ed15552c3/attachmentthumbs.PNG">

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.

<h2>Adding an Attachment</h2>
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].

<img src="/attachments/c2edc05c-7776-4b97-b65f-52aba415bde8/Attachments.png">		Working with Data
deleteedit26Attachment ViewersUse attachment viewers to control how attachments are displayed (with img tags or embeds). We have included default displays for several common types of attachments:
<img src="/attachments/d391bca0-5be9-424b-9258-b0e9abd0004e/AttachmentViewer.png">

To change how an attachment type displays, go to Admin > Attachment Viewers. Edit the itemtemplate field you want to change. For example, if the attachment file is an mp4 file, embed a Quicktime plugin in the itemtemplate to make the file play in Quicktime.

<img class="border" src="attachments/de8100e4-29f5-4e92-a3ea-da2d97f12a16/AttachmentViewersHelp2.JPG" />
Attachments
deleteedit1278Attachment PermissionsUser accounts need the appropriate security permissions to add attachments. An admin can grant permission to a user to upload attachments by going to Manage Users > Manage Security Groups and clicking "yes" under Enable Uploads. (See [User Group Settings])Attachments
deleteedit12Assigning Users to GroupsBy default, every Qrimp application comes with the following [user groups]: Administrator, Developer, Tester, User and Anonymous. You may wish to create additional groups based on specifics of your organization, such as "Accounting", "Editors" or "Human Resources".

By default the first user is an Administrator. Administrators can see most tables by default.

To add a user to a group go to Admin > Assign User to Groups. Click the add new icon.

You will see two drop-down boxes. Choose the user from the first, and the group from the second. Click the Create button.

<img src="/attachments/931603f9-0552-4351-9984-17befcb57aba/AssignUsertoGroup.png">

You must repeat this process for each user and each group.
<h2>Bulk Assigning</h2>
To bulk assign users to groups, go to the gridedit view of your users table. There is no link to this by default so you will have to type in a url: http://myapp.qrimp.net/db.aspx?t=t_users&_showeditgrid=true Replace myapp with your app name.
Managing Users
deleteedit144Anonymous AccessBy 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 <a href="db.aspx?t=helptopics&id=252&vid=11">database table</a> 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].		User Groups
deleteedit8An Introduction to Qrimp<!--<nobreak>-->
<h3>What is Qrimp?</h3>
Qrimp is a web platform that allows you to create and operate your own custom information management system.
<h3>How does it work?</h3>
When you create an app, you get a url, such as http://myapp.qrimp.com, plus a login and password by email. When you log in to your Qrimp app you have the tools you need to build custom solutions for any type of software system and manage your data securely on the web.
<h3>What is Qrimp for?</h3>
Qrimp is used to create web-based software applications with forms, workflow, reporting, business rules, data views, design templates and more. You can start with your existing data or add data as you go. Some types of software that have been built on Qrimp include Customer Relationship Management, Inventory Management, Enterprise Resource Planning, Supply Chain Management, Knowledge Management, Digital Asset Management, Financial Management, Human Resources, Intranet and more.

<h3>How do I sign up?</h3>
If would like to create a new web application for yourself or your company, go to<a href="http://www.qrimp.com/signup.html"> www.qrimp.com/signup</a>. If your company already has an app, speak to your administrator and they will create an account for you.

<h3>How do I access it?</h3>
Qrimp systems are accessible online any time from any web browser, including mobile phone browsers. There is no software to download. If desired, Qrimp can be installed behind a firewall on a local machine (see <a href="http://developer.qrimp.com/db.aspx?t=HelpTopics&id=138&vid=11" alt="Qrimp Server">Qrimp Server</a>).

<h3>Who can see my data?</h3>
Qrimp systems are all private by default. If you would like to show data to the public, use the anonymous user group under security permissions (see <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=4&vid=11>User Groups</a>).

<h3>Does Qrimp work with ...?</h3>
Qrimp can integrate with external services for payment processing (PayPal, Authorize.Net), maps, UPS (shipping), Flickr, Twitter, RSS - anything with an API. You can also share data from your Qrimp application to external sites using <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=130&vid=11>Share Data</a>.

<h3>What about my existing files?</h3>
Qrimp lets you upload existing documents, such as Word, Excel, PDF, video, and other files. These documents are stored in Qrimp as attachments. See <a href="db.aspx?t=HelpTopics&id=137&vid=11">Adding Attachments</a>.

<h3>Can you build my system?</h3>
If you do not have the time or knowledge to build your system, the Qrimp Services team can provide help. If you'd like our help, please <a href="http://www.qrimp.com/contact.html">contact us</a>.
<!--</nobreak>-->
deleteedit1337All query parameters in the list for menuid must be numeric.You may come across this error when re-ordering your menu tabs. You can ignore it, it doesn't seem to have any effect.Error Messages
deleteedit209Advanced DevelopmentThe features in this section will be useful to those with a web development background. Be cautious when implementing these features.
deleteedit5Adding UsersTo add a user, go to Admin > Manage Users. Click the link that says "Add a New User"

<img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d518f04e-6263-42c2-aacb-86fb4e3f9154-add%20user%20screen%201.png">

Enter the user's information in the form and select a user group for them: <img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d2b6612f-73c9-4d3f-9ec6-d507b59edbf7-add%20user%20screen%202.png">

Your user will get an email from support@qrimp.com with login and password information on their account. Make sure they check their spam!

<img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/8b4d3cfd-f13a-44c8-89e3-89923298cf41-add%20user%20screen%203.png">

Repeat this for all users. If you have a large number of users <a href="http://www.qrimp.com/contact.html">please contact us</a> for information on bulk user creation.		Managing Users
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
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
deleteedit230Adding Modules[Modules] are sets of [database table]s that add functionality instantly.

To add a module go to Develop > Add Module

Your module is added instantly. You may see new menus across the top that allow you to access the new tables. Sometimes you will not, for example, the "Countries" module simply adds the countries table to your list of tables. You can then use this as a look-up table (see [Look-up Tables]) in your other tables.		Modules
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
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing