GPSViewer
PDA & GIS
GPS Tools
Uhrwerk
Content Management
Programmierung
     
 

Outlook DataSet Schema

Softwareentwicklung
Softwarequalität
Systeme & Branchen
Werkzeuge
Techniken
Datenbanken
Open Source Projekte
Quelltext Snippets
Outlook->XML->MySQL
Outlook DataSet Schema 
MySQL mit C# und .NET
Settings in C#
  <xs:schema id="OutlookDataSet"
                   targetNamespace="
http://atlsoft.de/XMLSchema/Outlook
                   xmlns:mstns="
http://atlsoft.de/XMLSchema/Outlook"
                   xmlns="
http://atlsoft.de/XMLSchema/Outlook"
                   xmlns:xs="
http://www.w3.org/2001/XMLSchema"
                   xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
                   attributeFormDefault="qualified"
                   elementFormDefault="qualified"
                   msdata:schemafragmentcount="2">
  <xs:element name="OutlookDataSet" msdata:IsDataSet="true" msdata:Locale="en-US">
  <xs:complexType>
  <xs:choice minOccurs="0" maxOccurs="unbounded">
  <xs:element name="MailItem">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="SenderName" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
  <xs:element name="Subject" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="ReceivedTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="SentTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="SenderAddress" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="To" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  <xs:element name="CC" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
  <xs:element name="BCC" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
  <xs:element name="BillingInformation" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
  <xs:element name="Body" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
  <xs:element name="BodyFormat" type="xs:string" minOccurs="0" msdata:Ordinal="12" />
  <xs:element name="Categories" type="xs:string" minOccurs="0" msdata:Ordinal="13" />
  <xs:element name="Companies" type="xs:string" minOccurs="0" msdata:Ordinal="14" />
  <xs:element name="ConversationTopic" type="xs:string" minOccurs="0" msdata:Ordinal="15" />
  <xs:element name="CreationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="16" />
  <xs:element name="ExpiryTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="17" />
  <xs:element name="FlagDueBy" type="xs:dateTime" minOccurs="0" msdata:Ordinal="18" />
  <xs:element name="FlagRequest" type="xs:string" minOccurs="0" msdata:Ordinal="19" />
  <xs:element name="FlagStatus" type="xs:string" minOccurs="0" msdata:Ordinal="20" />
  <xs:element name="HtmlBody" type="xs:string" minOccurs="0" msdata:Ordinal="21" />
  <xs:element name="Importance" type="xs:string" minOccurs="0" msdata:Ordinal="22" />
  <xs:element name="LastModificationDate" type="xs:dateTime" minOccurs="0" msdata:Ordinal="23" />
  <xs:element name="Mileage" type="xs:string" minOccurs="0" msdata:Ordinal="24" />
  <xs:element name="DeliveryReceiptRequested" type="xs:string" minOccurs="0" msdata:Ordinal="25" />
  <xs:element name="ReadReceiptRequested" type="xs:string" minOccurs="0" msdata:Ordinal="26" />
  <xs:element name="Sensitivity" type="xs:string" minOccurs="0" msdata:Ordinal="27" />
  <xs:element name="VotingOptions" type="xs:string" minOccurs="0" msdata:Ordinal="28" />
  <xs:element name="VotingResponse" type="xs:string" minOccurs="0" msdata:Ordinal="29" />
  <xs:element name="IsRead" type="xs:string" minOccurs="0" msdata:Ordinal="30" />
  <xs:element name="Attachement" minOccurs="0" maxOccurs="unbounded">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="FileName" type="xs:string" minOccurs="0" />
  <xs:element name="DisplayName" type="xs:string" minOccurs="0" />
  <xs:element name="PositionIndex" type="xs:long" minOccurs="0" />
  <xs:element name="Content" type="xs:string" minOccurs="0" />
  </xs:sequence>
  </xs:complexType>
  </xs:element>
  </xs:sequence>
  <xs:attribute name="entryId" form="unqualified" type="xs:string" use="required" />
  <xs:attribute name="outlookVersion" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  <xs:element name="NoteItem">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="Body" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="Categories" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="CreationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="LastModificationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="Subject" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  </xs:sequence>
  <xs:attribute name="entryId" form="unqualified" type="xs:string" use="required" />
  <xs:attribute name="outlookVersion" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  <xs:element name="TaskItem">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="ActualWork" type="xs:long" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="BillingInformation" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="Body" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="CardData" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="Categories" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  <xs:element name="Companies" type="xs:string" minOccurs="0" msdata:Ordinal="7" />
  <xs:element name="Complete" type="xs:boolean" minOccurs="0" msdata:Ordinal="8" />
  <xs:element name="ContactNames" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
  <xs:element name="Contacts" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
  <xs:element name="ConversationTopics" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
  <xs:element name="CreationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="12" />
  <xs:element name="DateCompleted" type="xs:dateTime" minOccurs="0" msdata:Ordinal="13" />
  <xs:element name="DelegationState" type="xs:string" minOccurs="0" msdata:Ordinal="14" />
  <xs:element name="Delegator" type="xs:string" minOccurs="0" msdata:Ordinal="15" />
  <xs:element name="DueDate" type="xs:dateTime" minOccurs="0" msdata:Ordinal="16" />
  <xs:element name="Importance" type="xs:string" minOccurs="0" msdata:Ordinal="17" />
  <xs:element name="IsRecurring" type="xs:boolean" minOccurs="0" msdata:Ordinal="18" />
  <xs:element name="LastModificationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="19" />
  <xs:element name="Mileage" type="xs:string" minOccurs="0" msdata:Ordinal="20" />
  <xs:element name="Owner" type="xs:string" minOccurs="0" msdata:Ordinal="21" />
  <xs:element name="PercentComplete" type="xs:long" minOccurs="0" msdata:Ordinal="22" />
  <xs:element name="Role" type="xs:string" minOccurs="0" msdata:Ordinal="23" />
  <xs:element name="Sensitivity" type="xs:string" minOccurs="0" msdata:Ordinal="24" />
  <xs:element name="StartDate" type="xs:dateTime" minOccurs="0" msdata:Ordinal="25" />
  <xs:element name="Status" type="xs:string" minOccurs="0" msdata:Ordinal="26" />
  <xs:element name="StatusOnCompletionRecipients" type="xs:string" minOccurs="0" msdata:Ordinal="27" />
  <xs:element name="StatusOnUpdateRecipients" type="xs:string" minOccurs="0" msdata:Ordinal="28" />
  <xs:element name="Subject" type="xs:string" minOccurs="0" msdata:Ordinal="29" />
  <xs:element name="TeamTask" type="xs:boolean" minOccurs="0" msdata:Ordinal="30" />
  <xs:element name="TotalWork" type="xs:long" minOccurs="0" msdata:Ordinal="31" />
  </xs:sequence>
  <xs:attribute name="entryId" form="unqualified" type="xs:string" use="required" />
  <xs:attribute name="outlookVersion" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  <xs:element name="ContactItem">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="Account" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="Anniversary" type="xs:dateTime" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="AssistantName" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="AssistantTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="BillingInformation" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  <xs:element name="Birthday" type="xs:dateTime" minOccurs="0" msdata:Ordinal="7" />
  <xs:element name="Body" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
  <xs:element name="CallbackTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
  <xs:element name="CarTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
  <xs:element name="Categories" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
  <xs:element name="Children" type="xs:string" minOccurs="0" msdata:Ordinal="12" />
  <xs:element name="Companies" type="xs:string" minOccurs="0" msdata:Ordinal="13" />
  <xs:element name="CompanyMainTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="14" />
  <xs:element name="CompanyName" type="xs:string" minOccurs="0" msdata:Ordinal="15" />
  <xs:element name="ComputerNetworkName" type="xs:string" minOccurs="0" msdata:Ordinal="16" />
  <xs:element name="CreationTime" type="xs:dateTime" msdata:Ordinal="17" />
  <xs:element name="CustomerId" type="xs:string" minOccurs="0" msdata:Ordinal="18" />
  <xs:element name="Department" type="xs:string" minOccurs="0" msdata:Ordinal="19" />
  <xs:element name="FileAs" type="xs:string" minOccurs="0" msdata:Ordinal="20" />
  <xs:element name="FirstName" type="xs:string" minOccurs="0" msdata:Ordinal="21" />
  <xs:element name="FTPSite" type="xs:string" minOccurs="0" msdata:Ordinal="22" />
  <xs:element name="FullName" type="xs:string" minOccurs="0" msdata:Ordinal="23" />
  <xs:element name="Gender" type="xs:string" minOccurs="0" msdata:Ordinal="24" />
  <xs:element name="GovernmentIdNumber" type="xs:string" minOccurs="0" msdata:Ordinal="25" />
  <xs:element name="Hobbies" type="xs:string" minOccurs="0" msdata:Ordinal="26" />
  <xs:element name="Importance" type="xs:string" minOccurs="0" msdata:Ordinal="27" />
  <xs:element name="IMAddress" type="xs:string" minOccurs="0" msdata:Ordinal="28" />
  <xs:element name="Initials" type="xs:string" minOccurs="0" msdata:Ordinal="29" />
  <xs:element name="ISDNNumber" type="xs:string" minOccurs="0" msdata:Ordinal="30" />
  <xs:element name="JobTitle" type="xs:string" minOccurs="0" msdata:Ordinal="31" />
  <xs:element name="Language" type="xs:string" minOccurs="0" msdata:Ordinal="32" />
  <xs:element name="LastModificationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="33" />
  <xs:element name="LastName" type="xs:string" minOccurs="0" msdata:Ordinal="34" />
  <xs:element name="ManagerName" type="xs:string" minOccurs="0" msdata:Ordinal="35" />
  <xs:element name="MiddleName" type="xs:string" minOccurs="0" msdata:Ordinal="36" />
  <xs:element name="Mileage" type="xs:string" minOccurs="0" msdata:Ordinal="37" />
  <xs:element name="MobileTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="38" />
  <xs:element name="NetMeetingAlias" type="xs:string" minOccurs="0" msdata:Ordinal="39" />
  <xs:element name="NetMeetingServer" type="xs:string" minOccurs="0" msdata:Ordinal="40" />
  <xs:element name="Nickname" type="xs:string" minOccurs="0" msdata:Ordinal="41" />
  <xs:element name="OrganizationIdNumber" type="xs:string" minOccurs="0" msdata:Ordinal="42" />
  <xs:element name="PagerNumber" type="xs:string" minOccurs="0" msdata:Ordinal="43" />
  <xs:element name="PersonalHomePage" type="xs:string" minOccurs="0" msdata:Ordinal="44" />
  <xs:element name="Profession" type="xs:string" minOccurs="0" msdata:Ordinal="45" />
  <xs:element name="RadioTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="46" />
  <xs:element name="ReferredBy" type="xs:string" minOccurs="0" msdata:Ordinal="47" />
  <xs:element name="Sensitivity" type="xs:string" minOccurs="0" msdata:Ordinal="48" />
  <xs:element name="Spouse" type="xs:string" minOccurs="0" msdata:Ordinal="49" />
  <xs:element name="Subject" type="xs:string" minOccurs="0" msdata:Ordinal="50" />
  <xs:element name="Suffix" type="xs:string" minOccurs="0" msdata:Ordinal="51" />
  <xs:element name="TelexNumber" type="xs:string" minOccurs="0" msdata:Ordinal="52" />
  <xs:element name="Title" type="xs:string" minOccurs="0" msdata:Ordinal="53" />
  <xs:element name="TTYTDDTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="54" />
  <xs:element name="UserCertificate" type="xs:string" minOccurs="0" msdata:Ordinal="55" />
  <xs:element name="WebPage" type="xs:string" minOccurs="0" msdata:Ordinal="56" />
  <xs:element name="Email" minOccurs="0" maxOccurs="unbounded">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="Address" type="xs:string" minOccurs="0" />
  <xs:element name="AddressType" type="xs:string" minOccurs="0" />
  <xs:element name="DisplayName" type="xs:string" minOccurs="0" />
  </xs:sequence>
  </xs:complexType>
  </xs:element>
  <xs:element name="ContactDetails" minOccurs="0" maxOccurs="unbounded">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="AltTelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
  <xs:element name="Address" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="City" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="Country" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="PostalCode" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="PostOfficeBox" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  <xs:element name="State" type="xs:string" minOccurs="0" msdata:Ordinal="7" />
  <xs:element name="Street" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
  <xs:element name="FaxNumber" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
  <xs:element name="HomePage" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
  <xs:element name="TelephoneNumber" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
  </xs:sequence>
  <xs:attribute name="location" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  </xs:sequence>
  <xs:attribute name="entryId" form="unqualified" type="xs:string" use="required" />
  <xs:attribute name="outlookVersion" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  <xs:element name="AppointmentItem">
  <xs:complexType>
  <xs:sequence>
  <xs:element name="AllDayEvent" type="xs:boolean" minOccurs="0" msdata:Ordinal="2" />
  <xs:element name="BillingInformation" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
  <xs:element name="Body" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
  <xs:element name="Categories" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
  <xs:element name="Companies" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
  <xs:element name="CreationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="7" />
  <xs:element name="Duration" type="xs:long" minOccurs="0" msdata:Ordinal="8" />
  <xs:element name="End" type="xs:dateTime" minOccurs="0" msdata:Ordinal="9" />
  <xs:element name="Importance" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
  <xs:element name="IsOnlineMeeting" type="xs:boolean" minOccurs="0" msdata:Ordinal="11" />
  <xs:element name="IsRecurring" type="xs:boolean" minOccurs="0" msdata:Ordinal="12" />
  <xs:element name="LastModificationTime" type="xs:dateTime" minOccurs="0" msdata:Ordinal="13" />
  <xs:element name="Location" type="xs:string" minOccurs="0" msdata:Ordinal="14" />
  <xs:element name="MeetingStatus" type="xs:string" minOccurs="0" msdata:Ordinal="15" />
  <xs:element name="Mileage" type="xs:string" minOccurs="0" msdata:Ordinal="16" />
  <xs:element name="OptionalAttendees" type="xs:string" minOccurs="0" msdata:Ordinal="17" />
  <xs:element name="Organizer" type="xs:string" minOccurs="0" msdata:Ordinal="18" />
  <xs:element name="RequiredAttendees" type="xs:string" minOccurs="0" msdata:Ordinal="19" />
  <xs:element name="Resources" type="xs:string" minOccurs="0" msdata:Ordinal="20" />
  <xs:element name="ResponseRequested" type="xs:boolean" minOccurs="0" msdata:Ordinal="21" />
  <xs:element name="ResponseStatus" type="xs:string" minOccurs="0" msdata:Ordinal="22" />
  <xs:element name="Sensitivity" type="xs:string" minOccurs="0" msdata:Ordinal="23" />
  <xs:element name="Start" type="xs:dateTime" minOccurs="0" msdata:Ordinal="24" />
  <xs:element name="Subject" type="xs:string" minOccurs="0" msdata:Ordinal="25" />
  </xs:sequence>
  <xs:attribute name="entryId" form="unqualified" type="xs:string" use="required" />
  <xs:attribute name="outlookVersion" form="unqualified" type="xs:string" />
  </xs:complexType>
  </xs:element>
  </xs:choice>
  </xs:complexType>
  <xs:unique name="MailId">
  <xs:selector xpath=".//mstns:MailItem" />
  <xs:field xpath="@entryId" />
  </xs:unique>
  <xs:unique name="NoteId">
  <xs:selector xpath=".//mstns:NoteItem" />
  <xs:field xpath="@entryId" />
  </xs:unique>
  <xs:unique name="TaskId">
  <xs:selector xpath=".//mstns:TaskItem" />
  <xs:field xpath="@entryId" />
  </xs:unique>
  <xs:unique name="ContactId">
  <xs:selector xpath=".//mstns:ContactItem" />
  <xs:field xpath="@entryId" />
  </xs:unique>
  <xs:unique name="AppointmentId">
  <xs:selector xpath=".//mstns:AppointmentItem" />
  <xs:field xpath="@entryId" />
  </xs:unique>
  </xs:element>
  </xs:schema>
 
Newsletter Kontakt/Impressum Login
    
Druckansicht
© 2007 ATLSoft