Summary

Imports data from text file or CSV file. Additional XML file describing the structure of the file is required.

TiTextCsvImport.xsd
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Sabine Wahl (XIMES GmbH) -->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="TITextImport">
<xs:annotation>
<xs:documentation>Comment describing your root element</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="ColumnDelimiter">
<xs:complexType>
<xs:attribute name="Delimiter" use="required">
<xs:simpleType>
<xs:restriction base="xs:string"/>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="NumberOfColumnHeaders" default="1">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NumberOfRowHeaders" default="0">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TableType">
<xs:complexType>
<xs:attribute name="Type" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="IEvents"/>
<xs:enumeration value="IDurations"/>
<xs:enumeration value="ITimePattern"/>
<xs:enumeration value="Durations"/>
<xs:enumeration value="Events"/>
<xs:enumeration value="TimePattern"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="RegularExpressionForRow" type="xs:string" minOccurs="0"/>
<xs:element name="ColumnTypes" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="ColumnType" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Semantics" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="Date"/>
<xs:enumeration value="DateTo"/>
<xs:enumeration value="Time"/>
<xs:enumeration value="DateTime"/>
<xs:enumeration value="ToTime"/>
<xs:enumeration value="DateToTime"/>
<xs:enumeration value="Duration"/>
<xs:enumeration value="Identifier"/>
<xs:enumeration value="IdentifierDateTime"/>
<xs:enumeration value="Number"/>
<xs:enumeration value="Text"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Index" use="required">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Type" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="Int32"/>
<xs:enumeration value="String"/>
<xs:enumeration value="Double"/>
<xs:enumeration value="DoubleWithKomma"/>
<xs:enumeration value="Date_ddMMyyyy"/>
<xs:enumeration value="Date_MMddyyyy"/>
<xs:enumeration value="Date_yyyyMMdd"/>
<xs:enumeration value="DateTime_ddMMyyyy_HHmm"/>
<xs:enumeration value="DateTime_ddMMyyyy_HHmmss"/>
<xs:enumeration value="DateTime_yyyyMMdd_HHmm"/>
<xs:enumeration value="DateTime_yyyyMMdd_HHmmss"/>
<xs:enumeration value="Time_HHmm"/>
<xs:enumeration value="Time_HHmmss"/>
<xs:enumeration value="Boolean"/>
<xs:enumeration value="Int32WithNullValues"/>
<xs:enumeration value="String_HHmm_HHmm"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="IgnoreFirstRows" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IgnoreLastRows" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IgnoreLastColumns" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Operation" minOccurs="0">
<xs:complexType>
<xs:choice>
<xs:element name="DateFromToSinglePerson">
<xs:complexType>
<xs:sequence>
<xs:element name="InfoRotaStartDate">
<xs:complexType>
<xs:attribute name="Rowindex" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Colindex" use="required">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWords" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWordsDelimiter" type="xs:string" use="optional"/>
<xs:attribute name="Type" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="Date_ddMMyyyy"/>
<xs:enumeration value="Date_MMddyyyy"/>
<xs:enumeration value="DateTime_ddMMyyyy_HHmm"/>
<xs:enumeration value="DateTime_yyyyMMdd_HHmm"/>
<xs:enumeration value="Date_yyyyMMdd"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="InfoUnit">
<xs:complexType>
<xs:attribute name="Rowindex" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Colindex" use="required">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWords" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWordsDelimiter" type="xs:string" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="InfoPerson" minOccurs="0">
<xs:complexType>
<xs:attribute name="Rowindex" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Colindex" use="required">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="InfoRotaStarts">
<xs:complexType>
<xs:attribute name="Rowindex" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="Colindex" use="required">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWords" use="optional">
<xs:simpleType>
<xs:restriction base="xs:int">
<xs:minInclusive value="0"/>
<xs:maxInclusive value="255"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="IgnoreFirstWordsDelimiter" type="xs:string" use="optional"/>
<xs:attribute name="Type" use="optional">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="String_HHmm_HHmm"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name="NewColHeaders">
<xs:complexType>
<xs:attribute name="Person" type="xs:string" use="required"/>
<xs:attribute name="Unit" type="xs:string" use="required"/>
<xs:attribute name="Date" type="xs:string" use="required"/>
<xs:attribute name="FromTime" type="xs:string" use="required"/>
<xs:attribute name="ToTime" type="xs:string" use="required"/>
<xs:attribute name="Symbol" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

 

Example: ...

Situation

...

Settings

...

Result

...

Project-File

...

Want to learn more?

Settings

Imports data from text file or CSV file. Additional XML file describing the structure of the file is required.

Parameter

Examples

Example 1: ...

...

Calculation method

Settings

Result

...

 

 

Troubleshooting

Problem

Frequent Cause

Solutions

...

 

...

Related topics

  • ...