Export Import Tool

Abstract

Check out these articles and learn everything you need to know about the WEBfactory2010 Export Import Tool.

The WEBfactory 2010Export Import Tool makes possible the operations of exporting information from a database to an XML file, importing it back to another database and displaying differences between the different information sets. Used for migrating data from one WEBfactory 2010 database to another, or used for comparing data between databases and XML data, the WEBfactory 2010Export Import Tool aims for ease of usage and direct workflow.

The following article contains detailed information regarding the WEBfactory 2010Export Import Tool, from a developer’s point of view.

The WEBfactory 2010Export Import Tool is used for:

Exporting information from a database to an xml file
Importing information from an xml file into a database (overwrite /extend)
Displaying differences between the information in the database and the information in the xml file and allowing to select just certain selected information to be imported.

Export Import WEBfactory 2010 Tool

Tip

For a complete guide on how to use the WEBfactory 2010Export Import Tool, follow the link: Using the WEBfactory 2010Export Import Tool tutorial

Export Import Tool Database Connection

Option	Description
Database server	The server that hosts the desire database.
User ID	The user name for accessing the database server.
Password	The password required for accessing the database server.
Database	The database that will be worked upon.

Export Import Tool menu

Option	Description
Export	Exports the database to an XML file.
Import	Imports the database from and XML file. The import can be made in two ways: Overwrite Configuration Extend Configuration
Diff	Displays the differences between a database and an XML file.

References

Element	Description
<Configuration>	Root of the document.
<SignalWriteGroup>	Represents a write signal group definition. Attributes: Name – mandatory; should be unique; Description - optional; RestrictedAccess – mandatory; should contain only one of two values: True or False;
<DiscreteValue>	Represents a discrete value definition. Attributes: Name – mandatory; should be unique; Value – mandatory; double type in InvariantInfo format; Child elements: <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language;
<DiscreteValueType>	Represents a discrete value type definition. Attributes: Name – mandatory; should be unique; Description – optional;
<DiscreteValueTypeMap>	Represents a map between a DiscreteValueType and a DiscreteValue. Attributes: DiscreteValueType – mandatory; should be one of the already defined <DiscreteValueType>. DiscreteValue – mandatory; should be one of the already defined < DiscreteValue >. Remarks: The combination DiscreteValueType and DiscreteValue should be unique; For every <DiscreteValueType> defined it should be at least one map;
<Server>	Represents a server definition. Attributes: Name – mandatory; should be unique; Description - optional; Active – mandatory; should contain only one of two values: True or False; Child elements (optional): <Connector> - see the description below;
<Connector>	Represents a connector definition. Attributes: Name – mandatory; Host – mandatory; Active – mandatory; should contain only one of two values: True or False; Timestamps – mandatory; should contain only integer values from 0 to 3; Configuration – mandatory; this will be filled with a string configuration data only for native connectors; Child elements (optional): <Group> - see the description below; Remarks: Inside a server definition, a connector is uniquely identified by the combination of Name and Host;
<Group>	Represents a group of signals definition. Attributes: Name – mandatory; should be unique inside a connector definition; Description – optional; Mode – mandatory; should contain only integer values from 1 to 5; UpdateTime – mandatory; should contain only integer values from 1 to 26; Active - mandatory; should contain only one of two values: True or False; LoadBalancing - mandatory; should contain only one of two values: True or False; DefaultText – optional; always should be an empty string; Child elements (optional): <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language; <Signal> - see the description below;
<Signal>	Represents a signal definition. Attributes: Name – mandatory; should be unique inside a connector definition; OpcName – mandatory; represents the name of the OPC signal name; Active - mandatory; should contain only one of two values: True or False; LogUserActivity - mandatory; should contain only one of two values: True or False; Description – optional; WriteGroup – optional; the name of one of the languages already defined below by <SignalWriteGroup> element; DiscreteValueType – optional; the name of one of the languages already defined below by <DiscreteValueType> element; FactorX1 – mandatory; float type in InvariantInfo format; FactorX2 – mandatory; float type in InvariantInfo format; FactorY1 – mandatory; float type in InvariantInfo format; FactorY2 – mandatory; float type in InvariantInfo format; Hysteresis – mandatory; double type in InvariantInfo format; HysteresisPercent – mandatory; double type in InvariantInfo format; HysteresisLog – mandatory; double type in InvariantInfo format; HysteresisLogPercent – mandatory; double type in InvariantInfo format; HysteresisAlarm – mandatory; double type in InvariantInfo format; HysteresisAlarmPercent – mandatory; double type in InvariantInfo format; Maximum – mandatory; double type in InvariantInfo format; Minimum – mandatory; double type in InvariantInfo format; Unit – mandatory; IsVChannel - mandatory; should contain only one of two values: True or False; VChannelType – mandatory; should contain only one of two integer values: 0 or 1; VChannelInitValue – mandatory; DataType – mandatory; should contain only one of two integer values: 0 or 1; UseSubstituteValue - mandatory; should contain only one of two values: True or False; SubstituteValue – mandatory; double type in InvariantInfo format; OPCEnabled – mandatory; should contain only one of two values: True or False; DefaultText – optional; always should be an empty string; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language; <Script> Content - mandatory; represents a script function; <ScriptParameter> Attributes: Signal – mandatory; the name of the signal, except the name of the current signal; <CollectiveAlarm> Attributes: Alarm – mandatory; the name of one of the alarms already defined below by <Alarm> element expecting the alarms defined for the current defined signal; Signal – mandatory; the name of the signal, except the name of the current signal;
<AlarmGroup>	Represents an alarm group definition. Attributes: DefaultName – mandatory; should be unique; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language;
<AlarmType>	Represents an alarm type definition. Attributes: DefaultName – mandatory; should be unique; AutoConfirm - mandatory; should contain only one of two values: True or False; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language;
<AlarmCondition>	Represents an alarm condition definition. Attributes: Server – mandatory; the name of one of the servers already defined above by <Server> element; Name – mandatory; should be unique per server; Criteria – mandatory; should contain only integer values from 1 to 9; Constant1 – optional; double type in InvariantInfo format; Constant2 – optional; double type in InvariantInfo format; Signal – optional; the name of one of the signals already defined above by <Signal> element;
<ExtendedAlarmProperty>	Represents an alarm condition definition. Attributes: Index – mandatory; should be unique; should contain only integer values from 1 to 32; Active – mandatory; should contain only one of two values: True or False; DataType – mandatory; should contain only integer values from 0 to 2; DefaultText – mandatory; should not be an empty string; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language;
<Alarm>	Represents an alarm definition. Attributes: Server – mandatory; the name of one of the servers already defined above by <Server> element; Name – mandatory; Signal – mandatory; the name of one of the signals already defined above by <Signal> element belonging to the same server of the current alarm; Active – mandatory; should contain only one of two values: True or False; Type – mandatory; the name of one of the alarm types already defined above by <AlarmType> element; Group – mandatory; the name of one of the alarm groups already defined above by <AlarmGroup> element; Condition – mandatory; the name of one of the alarm conditions already defined above by <AlarmCondition> element belonging to the same server of the current alarm; ReplaceSignal1 to ReplaceSignal20 – optional; the name of one of the signals already defined above by <Signal> element belonging to the same server of the current alarm; ReplaceOn – mandatory; should contain only one of two values: True or False; Priority – mandatory; PlcOn – mandatory; should contain only one of two values: True or False; PlcSignalName – optional; the name of one of the signals already defined above by <Signal> element belonging to the same server of the current alarm; PlcNewValue – optional; float type in InvariantInfo format; AlarmLinkURL – optional; OnlineAlarm – mandatory; should contain only one of two values: True or False; ExecuteScript – mandatory; should contain only one of two values: True or False; ScriptPath – mandatory; EnableLinePrinter – mandatory; should contain only one of two values: True or False; Symbol – mandatory; should contain only integer values from 0 to 4; SuppressionDuration – mandatory; NavigationSource – optional; NavigationTarget – optional; GeneralComment – optional; CustomAlarm – mandatory; should contain only one of two values: True or False; ExtendedProperty1 – ExtendedProperty32 – optional; DefaultText – mandatory; the symbolic text name of the current defined alarm; HelpCauseDefaultText – optional; the symbolic text name for the help cause of the current defined alarm; HelpCauseCategory – optional; the category type of the help cause of the current defined alarm; should contain only one of two integer values: 0 (standalone) or 1 (shared); HelpCauseGroup – optional; in case of a shared help text, it uniquely identifies the shared help text used for the help cause of the current defined alarm; HelpEffectDefaultText – optional; the symbolic text name for the help effect of the current defined alarm; HelpEffectCategory – optional; the category type of the help effect of the current defined alarm; should contain only one of two integer values: 0 (standalone) or 1 (shared); HelpEffectGroup – optional; in case of a shared help text, it uniquely identifies the shared help text used for the help effect of the current defined alarm; HelpRepairDefaultText – optional; the symbolic text name for the help repair of the current defined alarm; HelpRepairCategory – optional; the category type of the help repair of the current defined alarm; should contain only one of two integer values: 0 (standalone) or 1 (shared); HelpRepairGroup – optional; in case of a shared help text, it uniquely identifies the shared help text used for the help repair of the current defined alarm; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language; <HelpCauseName> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language for the help cause symbolic text; <HelpEffectName> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language for the help cause symbolic text; <HelpRepairName> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language for the help cause symbolic text; Remarks: Inside a server definition, an alarm is uniquely identified by the combination of Name and Signal name;
<LogCondition>	Represents a log condition definition. Attributes: Server - mandatory; the name of one of the servers already defined above by <Server> element; Name - mandatory; should be unique per server; LogMode - mandatory; should contain only integer values from 1 to 16; LogInterval - mandatory; should contain only integer values from 0 to 22; Constant - optional; double type in InvariantInfo format; Signal - optional; the name of one of the signals already defined above by <Signal> element belonging to the same server of the current log condition; ReportInterval - mandatory; should contain only integer values from 0 to 22;
<Log>	Represents a log definition. Attributes: Server - mandatory; the name of one of the servers already defined above by <Server> element; Name - mandatory; should be unique per server; Signal - mandatory; the name of one of the signals already defined above by <Signal> element belonging to the same server of the current log; Active – mandatory; should contain only one of two values: True or False; Condition – mandatory; the name of one of the log conditions already defined above by <LogCondition> element belonging to the same server of the current log; MaxDays – mandatory; MaxNumbers – mandatory; TargetDBSuffix – mandatory; DefaultText – optional; always should be an empty string; Child elements – optional <Name> Attributes: Language - mandatory; the name of one of the languages already defined below by <Language> element; Content - mandatory; represents the translation text for the specified language;
<Language>	Represents a language definition. Attributes: Name - mandatory; should be unique; should be the native name one of the neutral cultures installed on a PC; Active - mandatory; should contain only one of two values: True or False; Used - mandatory; should contain only one of two values: True or False;
<Translation>	Represents a generic symbolic text together with its translations (if any defined). Attributes: Name - mandatory; should be unique; should not be empty string; Category - mandatory; always should be 0; Child elements – optional <Text> Attributes: Language - mandatory; the name of one of the languages already defined above by <Language> element; Content - mandatory; represents the translation text for the specified language;
<ProjectAuthorization>	Represents a project authorization definition. Attributes: Name - mandatory; should be unique; should not be empty string; Description - optional;
<VCScriptFunction>	Represents a script function definition. Attributes: Name - mandatory; should be unique; should not be empty string; Description - optional; Child elements – optional <Code> Content - mandatory; represents a script function;

In this section:

WEBfactory 2010

Export Import Tool

Tip

References

Search results