XML Data

[GraemeMitchell]

I have a simple XML file that I would like to import into the CDS using the New Entity from Data.  I locate the XML file which is on my companies Sharepoint and it loads it and I can see 4 columns (Name, Namespace, Value and Attributes).  Below those headers I have 1 line of information, Detail, nothing in Namespace, then [Table] in Value and [Table] in Attributes.  If i click the Value [Table] link i now see the same column headers as before but I see the word data in the Name column and there are 43 lines (which is the number of employees).  If I click the [Table] in the Value column again i finally get to the data that I need, 3 bits of information showing employee Clock, Name and In-Out.

How do I choose the right primary key, it should be the Clock and all I want is those 3 pieces of data

[Leo09]

can you share your xml file here? Or a similar XML file and remove the sensitive data.

[GraemeMitchell]

<?xml version="1.0" encoding="utf-8" ?> 
- <detail>
- <data>
  <Clock>101</Clock> 
  <Name>Alan H</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>149</Clock> 
  <Name>Darshan Brar</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>215</Clock> 
  <Name>Clare M</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>280</Clock> 
  <Name>Stewart B</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>371</Clock> 
  <Name>Jan A</Name> 
  <In-Out>1</In-Out> 
  </data>

This is a few lines of the XML I am looking to import in CDS

[GraemeMitchell]

Is the XML is the correct format? 

[GraemeMitchell]

Is there documentation posted on how to use XML's with the import? I get to the first pic and select next and then in the next pic I am not sure what to select to correct the error.  The XML I am trying to import is in Post #3 in this thread