Importing Commands
 
Importing Commands
The Import Commands should always be placed after the name of the Registry or Attribute, separated by semicolon ( ;) each other. Each command must be given a value with the equal symbol (=). In the examples below the spaces between the symbols and commands are not required, they serve only to give greater clarity.
A text type Attribute called Course Name can be formatted like this:
Course Name ; type = text ; description = Course names. ;
Many commands allow more than one spelling. Commands can be given in any language. It´s possible to mix command language in the same line.
Registry commands
Registry commands are given after que name of the Registry, in the same cell.
Command Description Value
description Registry description. text
keep removed The removed data of this Registry could be recovered. yes/y or no/n
remove association
remove assoc
When some data of this registration is removed all other data associated with they are removed in a cascade way. Very careful when using this command because it may cause the removal of too much information into one click. Without this command, when there exist data associated the removal will not be allowed. yes/y or no/n
 
Attribute formatting commands
Attribute formatting commands must be placed after que name of the Attribute, in the same cell.
Command Description Value
type Attribute type. From table Attribute types.
description Attribute description. text
mandatory Mandatory value. yes/y or no/n
main order Attribute used to data ordering. yes/y or no/n
partial filter Only attributes with this property can be used in searches for the initial part of the text or numerical and date ranking. yes/y or no/n
equality filter Attributes with this property can be used in equality searches. yes/y or no/n
currency
cur
Currency symbol to currency type Attributes. Ignored in other Attribute types. text
decimal separator
dec separator
dec sep
Decimal separator to number and currency types. character
group separator
group sep
Group separator to number and currency types. character
decimal length
dec length
Decimal length of number and currency. number
max
maximum
Máximum value for numbers. Maximum length for texts. number
min
minimum
Minimum value for numbers. Minimum length for texts. number
default value Default value to be assigned if the user do not provide one. Depends on Attribute type.
 
Attribute types
text
string
Any text with any chareacter (limited to 500 in length).
email
e-mail
Well fomatted email address.
url
site
website
Internet website address.
phone Phone number and related symbols.
alpha numeric
alpha num
Numbers and letters. Do not allow symbols.
alpha Just letters. Do not allow numbers nor symbols.
number General purpose numbers. Decimal separator are accepted.
currenncy Currency number with or without a symbol.
date Dates and/or time.
marked
boolean
Two states: marked or unmarked;
list Selection list. The items could be provided at definition or must come from another Registry.
label Read only text. Could be imported, but could not be changed.
zip ZIP code.
cep Brazilian equivalent ZIP code.
last access Time of datum last access. It could not be imported, just exported.
last user User that last accessed the datum. It could not be imported, just exported.
last action Last action on datum. It could not be imported, just exported.
 
List type Attribute formatting commands
The following commands are only applied to list type Atribute.
Command Description Value
list type Type of the list elements when thay are provided at definition. Could be text, number, or date. text
list elements Elements of the list separed by semicolon (;). The list type is assumed as text. text
list elements with id List of elements separated by semicolon(;) , but taken in pairs to form the selection list. The first element is the mnemonic identifier and the second is the text of the first item in the selection list. The third element is the identifier of the next item in the selection list and the fourth element is it text. So on until completing all items. The number of list items is equal to the number of supplied elements divided by two. Each identifier must be of the type specified by the type of list. text
list registry Reference of the Registry that provide the data of the list, when they are not provided at definition. text
list registry name Name of the Registry that provide the data of the list, when they are not provided at definition. It is not necessary when Registry reference was provided. text
list text attribute Reference of the Attribute to be used as text in the selection list. The Attribute must belong to the Registry that provide the data of the list. text
list text attribute name Name of the Attribute to be used as text in the selection list. The Attribute must belong to the Registry that provide the data of the list. It is not necessary when text Attribute reference was provided. text
list identifying attribute Reference of the Attribute to be used as identifier in the selection list. The Attribute must belong to the Registry that provide the data of the list. text
list identifying attribute name Name of the Attribute to be used as identifier in the selection list. The Attribute must belong to the Registry that provide the data of the list. It is not necessary when identifier Attribute reference was provided. text
 
Linked Attributes Commands
One Attribute can have its values (and its definitions) copied from another Attribute of another Registry. Multiple Attributes can be copied simultaneously allowing a complete set of data to be loaded (eg code, name and description of a product). You can give the user the option to change or not the data after copying. The data source Registry must be selected in an Attribute of type List that must be previously present in the Attributes list.
Command Description Value
copyfrom source list name Name of the Attribute of type List (values from another Registry) from which the source Registry of the data is obtained. text
copyfrom source list Reference of the Attribute of type List (values from another Registry) from which the source Registry of the data is obtained. text
copyfrom source attribute name Name of the Attribute in the source Registry (defined by the list of the previous property) whose data will be copied when the list is selected. text
copyfrom source attribute Reference of the Attribute in the source Registry (defined by the list of the previous property) whose data will be copied when the list is selected. text
copyfrom readonly When copied the value can not be changed by the user. yes/y or no/n
 
Commands to define association amoong Registries
Associations between Registries are defined in the Registry commands (in the same cell of Registry name). A child Registry when referencing another parent Registry (always at left in the import file) causes to be created in the parent an Attribute of the type Other Registry grid. If specified that the association is reverse another Attribute will also be created in child Registry of the same type.
Command Description Value
parent registry Reference of the parent Registry where is the association Attribute. It will be createed if not exists. text
parent registry name Name of the parent Registry where is the association Attribute. It will be createed if not exists. text
parent attribute Referente of the association Attribute on parent Registry. It only must be provided if the Attribute alread exists. text
parent attribute name Name of the association Attribute on parent Registry. if it does not exist, it will be created with this name. text
exclusive The association is exclusive. Child Registry data can only be associated exclusively with each given data in the parent Registry. yes/y or no/n
reverse The association is also reversed. An attribute should be created (if it does not exist,) in this child Registry doing the inverse association with the parent Registry. yes/y or no/n
reverse attribute name Name to be given to the reverse Attribute. Note that it will be created in the child Registry. text
reverse screen Screen reference to be set to the inverse association. This Screen should be defined on the parent Registry. See Commands to define Screens. text
reverse screen name Screen name to be set to the inverse association. This Screen should be defined on the parent Registry. See Commands to define Screens. text
 
Commands to define Screens
Screens are defined in the Registry commands (in the same cell of Registry name). As many screens can be defined as desired. Each screen is defined by a group of commands that begins with the definition of the name of the Screen. After these commands all others refer to this screen until a new Screen name definition command is found.
Command Description Value
screen Reference to an existing Screen. All subsequent Screen commands refer to this Screen until another Screen reference or Screen name is found. text
screen name Screen name. If it does not exist it will be created. All subsequent Screen commands refer to this Screen until another Screen reference or Screen name is found. text
screen attributes Attributes screen, given by their names or references, separated by commas (,). If not specified it means that the Screen will contain all Registry attributes (defined so far). You can declare the properties of the screen field, just after the name or the reference of the Attribute, colon (:) separeted. Use the words read to indicate that the field can not be edited in the edit screen (read-only field), edit to indicate that the field can be edited in the list scfreen, and sort to indicate that the field can be sorted in the list screen. Ex: screen attributes = Name:read:sort, Status:edit:sort text
read only It indicates that the screen is read-only, ie it does not allow adding or editing data. yes/y or no/n
add The Screen allows data adding. yes/y or no/n
remove The Screen allows data removing. yes/y or no/n
export The Screen allows data exporting. yes/y or no/n
import The Screen allows data importing. yes/y or no/n
menu The screen will not be shown on the vertical side menu. Screens that are used exclusively in associations need not appear on the vertical side menu and can be marked this way. Is is useful in order to keep that cleaner. yes/y or no/n
 
Data reference commands
Data can be exported with their references in INubem. These data can be changed externally and when imported with their references they can be updated in INubem. Each row of data has a reference to be informed in the same column that the Registry.

Figure 1 (Click to enlarge/reduce)
Associations can also be exported with their references. When imported again with these references they can be updated. The association reference is placed in the same cell as the associated data reference, using the keyword association = .

Figure 2 (Click to enlarge/reduce)
When no references was exported from INubem (or when the data is new) an Attribute that is unique (does not accept repeated values) can be used with this role. It must necessarily be an Attribute that has unique values in order to be unambiguously identified. The indication of this attribute must be made in the Registry commands and must inform the Attribute reference using identifier attribute = (or id attribute =) or the Attribute name using identifier attribute name = (or id attribute name =).
 
Other commands
The first line of importing spreadsheet can inforn the references of the Registries and Attributes involved in the importation. This line can be omitted if the imports involve a single Registry. When omitting this line the identification of Attributes is made by name. If the importation involve more than one Registry this line is mandatory.
New Registries have no reference, so, when the first row of the spreadsheet with the references is present, in its place should be used the keyword NR or nr (New Registry). The same goes for the new Attributes that do not have reference. The keyword used in this case must be NA or na (New Attribute).
When the Registry is not new but you do not have it (or choose not to use it) in its plance can be used the keyword R or r. In the case of an existing Attribute the keyword must be A or a. In both cases the Registru name or Attribute name will be used to identify it.