Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System Cook book

Here you can find answers to frequetnly asked questions (F.A.Q.)

Q. How can I create a new table ?

A. Use Table Editor

A: Currently Younicycle offers 3 selfinstallation packages for Fedore, Ubuntu and Debian. So you shoudn't  worry about any missed software components on your server, because selfinstaller installs and configures all the needed software by itself.

As for other Linux versions before setup YSP on your server you have to install the following software:

PosgreSQL 8.4+
Apache 2.2
PHP 5.2.x (lates version is highly preferred) with module for Apache
Magickwand 1.0.7 (module/plugin for PHP)
Uploadprogress 1.0.1 (module/plugin for PHP)
Gifsicle 1.59
InfoZIP zip and unzip
Cron Sudo (will need some setup too)
PDFLib 7 extension for PHP from here:

A: You can create unlimited number of web sites within an account or YSP, depending on your server configuration (RAM, etc).  Younicycle does not impose a specific limit.

A: With Younicycle you can create unlimited and diferent kinds of reports, because you are able to design, draw and create templates for your reports yourself using Template Editor GYRE. Then you can make a PDF, HTML or IMAGE report on the fly.

Captcha is a type of challenge-response computer test to ensure that the response is generated by a human and not a bot.  Most frequently captcha used for registering or authentication.  Often captcha is an image of numbers and letters that user has to enter in a specified text box, but the image is distorted to prevent reading by automatic recognition software.
Step 1: Select Captcha GEAR
System Action Captcha (1)

Step 2. Customize the output. Optionally you can remove the border (Border thickness = 0).

System Action Captcha (2)

Step 3. The result.

System Action Captcha (3)

Gallery is used to display images saved in the same folder.

Step 1. Select Gallery gear from the list.

Action System 'Gallery' (1)

Step 2. Customize the output

Action System 'Gallery' (2)

Step 3. Setting gallery properties.

Select the folder in which the images are located (Source folder). Specify the name of the gallery (Gallery name), the height and width of the images (Image height, Image width), the direction of the scroll (Scroll direction) and other properties.

Step 4. The result.

System action Contact form is used to create a simple feedback form.

Step one 1. Select Contact form gear from the list.

Action System 'Contact Form'

Step 2. Customizing output

Step 3. Editing form properties.

The form consists of four fields. The names of these fields are determined by the properties  Label # 1 - Label # 4.  Form title property specifies the header of the form.  The property Button caption specifies the  button label . The e-mail address to which the data from the form is sent to is stored in Mailto property.

Step4. The result.

Shopping cart is the result of work of two system actions: List and Cart Toolbar. System action List is used to display information from the data source in form of a list. It can be used separately or in conjunction with the action Cart toolbar, allowing to create a simple online store.

Prior to working on the site, you must configure the system (s) of payment. Younicycle works with Google Checkout, Paypal Express checkout and LiqPay payment systems. To set up payment systems, choose from the main menu Tools-> Checkout settings. To add settings, click Add Payment system.

Payment system settings

Field Name defines the name of a given set of settings. This name is unique within an account and used by GYRE editor or custom actions for loading the payment system settings:

$ CheckoutSettings = getCheckoutSettings ('settings_set_name');

Field Server type defines the type of settings:

* Sandbox is used to test payment in Google and Paypal
* Checkout is used for payment in Google
* Sale is used for payment in Paypal system

Number of payment systems' settings is not limited, ie You can add several settings for Paypal Express checkout and several for Google checkout.

Step 1. Create a product list

List of products can be in form of a table (Table), query (Query) or presentation (View).

Example of product list

Mandatory fields are:

    * Identifier (ID)
* Name of the product (service)
* A short description
* Price

You can also add a File field to store the image of a product. This field is optional. The column names can be arbitrary.

Step 2. Customize the output.

In GYRE editor choose two system actions - List and Cart toolbar - and place them in a desired order.

In List properties choose a datasource (property Datasource) (in this example - a product table).

List properties

You will also need to choose the columns to be displayed in the product list, using property Datafield. To select more than one column, press and hold Ctrl. The order of column selection will be saved. Then you should compare custom and system columns, so the system would "know" what data is stored in specific columns, and could work with this data. For comparison, use the property Fields mapping. It is necessary to map the fields from the left side of the dialog with the fields from the right side.

After setting the output region List, you can proceed to configure the output region Cart toolbar. This area will contain buttons to control the basket on the status of the basket and a button payment systems. The first step is to associate the Cart toolbar with domain List. For this property ispolzetsya Linkage. Linkage dialog contains the names of all system actions, which were added to the page, besides the action of which the cause of this dialogue. In this case, the dialogue is only one object - product_list - which is the area List (preferably immediately give meaningful names to all objects on the page to avoid confusion later).

Cart toolbar settings are just as extensive as the List settings. Here you can set up payment system, the button labels, etc.

Cart toolbar settings

Step 3. The result


To add a product to your cart, pick it from the list, select the desired quantity and click Add to cart.


Google Checkout payment system

Paypal Express checkout payment system

Q. Alternative way for Google verification - Upload an HTML file.

A. There're a few simple steps:

1. Make new action

2. Copy content from the file to the variable in the action. See example:

$data['content'] = "put your content here";
return $data;

3. Open website wizard and add new page. Make sure you give it the same name as you found in Google's instructions.

4. Open page properties and expand "On before load action" drop down.

5. Select action you made in item 1.

6. Press "Save".