SQL Import Template

This window serves to create and edit the rules of content import from the files in SQL format.

The upper part of the window contains template names. Double-clicking on the template will open it for editing.

The editor consists of 4 parts:

1. Articles (main) – the rules of formatting of the main fields – name and text;

2. Articles (additional) – the rules of formatting of the rest of the fields;

3. Categories – the rules of category formatting;

4. Filters and replacement – the rules of search and replacement in the text after import.

It is recommended to use “SQL file Analysis” button which will reparse the file and will mark the tables and fields contained there. It will significantly facilitate the process of template construction.

Warning: it is not recommended to create import templates by those who have never worked with databases before.

Articles (main)

Table – the title of the table from which the posts will be imported. Relates to the first and second inlay.

Name – the rule of article name formation. Tags in this field are written in double braces.

For example: {{name}} - {{author}} – in this case the name will consist of the two fields.

Article text – the rule of article tag formation. Just place the needed tags where needed. Just as in the previous case the tags are written in double braces (the editor will light them with blue).

Articles (additional)

Here is the table where the belonging of certain tags to the article fields is determined. It consists of 2 main columns:

Parameter – a field, where the meaning of the tag will be placed. The list of available parameters:

• Category (identificator)

• Category (name)

• Marks

• Date (Windows format)

• Data (Unix format)

• Indicator of the static page

• alt_name

• description

• keywords

• post id

Field – the name of the field in the table of posts, which will be the source for meaning имя поля в таблице постов, с которого будет браться значение.

Categories

This inlay should be filled if category structure is described in the base separately. There is nothing new in this inlay, except the list of parameters for the categories is a little different:

• Name

• Identificator

• Alt_name

• Parent (name)

• Parent (identificator)

Parent (identificator) – is a field that helps to determine parent category.

Filters and replacement

In this inlay the rules of replacements should be created. These rules are needed to translate the content, saved in the database with screened symbols, into the one which is ready for use. Also one should create the rules to remove/replace CMS service tags.

Selection options

For each table, there is a possibility to set the options of selection. These options determine the need for selection or screening of imported records using specific criteria. Selection options may be few, but if you want the record was added to the program, they all have to be true to this entry.

Options take the following steps:

• = (Equals)

• != (Not equal)

• > (Greater than)

• < (Less than)

• >= (Greater than or equal to)

• <= (Less than or equal to)

The first 2 are applicable to numbers or strings, and the rest - only to strings. examples:

• name = Zebra - the value of the field name must be equal to the word Zebra (case does not matter)

• id >= 50 - id field value must be greater than or equal to the number 50