I'm using Crystal 8.5, having difficulty pulling XML data in. How can I tell what the table and row hints should be to pull the data in (assuming that's the problem)? I'm connecting and getting the following fields but no other: <lastauthor>, <created> and <version>. I get no other fields and I'm not sure why... Need Account, Name, etc. The XML code is as follows:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html=" <DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice">
<LastAuthor>063857</LastAuthor>
<Created>2008-08-15T13:46:09Z</Created>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">
<WindowHeight>4875</WindowHeight>
<WindowWidth>7275</WindowWidth>
<WindowTopX>600</WindowTopX>
<WindowTopY>345</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="08142008test">
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1">
<Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="99"/>
<Column ss:AutoFitWidth="0" ss:Width="156"/>
<Row>
<Cell><Data ss:Type="String">account</Data></Cell>
<Cell><Data ss:Type="String">name</Data></Cell>
<Cell><Data ss:Type="String">street_address_line</Data></Cell>
<Cell><Data ss:Type="String">city_name</Data></Cell>
<Cell><Data ss:Type="String">state</Data></Cell>
<Cell><Data ss:Type="String">zip</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">53509792</Data></Cell>
<Cell><Data ss:Type="String">APRIL SMITH</Data></Cell>
<Cell><Data ss:Type="String">1010 CITY BLOCK</Data></Cell>
<Cell><Data ss:Type="String">DALLAS</Data></Cell>
<Cell><Data ss:Type="String">TX</Data></Cell>
<Cell><Data ss:Type="Number">75075</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel">
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html=" <DocumentProperties xmlns="urn:schemas-microsoft-comfficeffice">
<LastAuthor>063857</LastAuthor>
<Created>2008-08-15T13:46:09Z</Created>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comffice:excel">
<WindowHeight>4875</WindowHeight>
<WindowWidth>7275</WindowWidth>
<WindowTopX>600</WindowTopX>
<WindowTopY>345</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
</Styles>
<Worksheet ss:Name="08142008test">
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1">
<Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="99"/>
<Column ss:AutoFitWidth="0" ss:Width="156"/>
<Row>
<Cell><Data ss:Type="String">account</Data></Cell>
<Cell><Data ss:Type="String">name</Data></Cell>
<Cell><Data ss:Type="String">street_address_line</Data></Cell>
<Cell><Data ss:Type="String">city_name</Data></Cell>
<Cell><Data ss:Type="String">state</Data></Cell>
<Cell><Data ss:Type="String">zip</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">53509792</Data></Cell>
<Cell><Data ss:Type="String">APRIL SMITH</Data></Cell>
<Cell><Data ss:Type="String">1010 CITY BLOCK</Data></Cell>
<Cell><Data ss:Type="String">DALLAS</Data></Cell>
<Cell><Data ss:Type="String">TX</Data></Cell>
<Cell><Data ss:Type="Number">75075</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-comffice:excel">
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>