Import Layout

[John Saul]

I know the import format is specific, but when I try to export the importable format with custom fields, it doesn't open in Excel. Can you perhaps post the format structure for me for the import wizard?  Especially the format for importing a NEW asset. 

[Bradley Bell]

Try using the latest code from the 2.0-trunk branch on github, if you
aren't already:
https://github.com/chakatodd/rt-extension-assettracker/tree/2.0-trunk

To make new assets, you just put 'new' in the id column.

Here is a complete importable example with 2 existing assets and 1 new asset:

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Version>12.0</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<Date1904/>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="Verdana"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s21">
<NumberFormat ss:Format="General Date"/>
</Style>
<Style ss:ID="s23">
<NumberFormat ss:Format="0"/>
</Style>
</Styles>
<Worksheet ss:Name="Export">
<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="4"
x:FullColumns="1" x:FullRows="1">
<Column ss:Width="60.0" />
<Column ss:Width="60.0" />
<Column ss:Width="60.0" />
<Column ss:Width="60.0" />
<Column ss:Width="60.0" />
<Row><Cell ><Data ss:Type="String">id</Data></Cell>
<Cell ><Data ss:Type="String">Name</Data></Cell>
<Cell ><Data ss:Type="String">Description</Data></Cell>
<Cell ><Data ss:Type="String">Status</Data></Cell>
<Cell ><Data ss:Type="String">Type</Data></Cell>
</Row>
<Row><Cell ss:StyleID="s23"><Data ss:Type="Number">1</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">widget 1</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">none</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">production</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">Servers</Data></Cell>
</Row>
<Row><Cell ss:StyleID="s23"><Data ss:Type="Number">2</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">widget 2</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">none</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">production</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">Servers</Data></Cell>
</Row>
<Row><Cell ss:StyleID="s23"><Data ss:Type="Number">new</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">new asset</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">none</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">production</Data></Cell>
<Cell ss:StyleID="Default"><Data ss:Type="String">Servers</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>

> --
> You received this message because you are subscribed to the Google Groups
> "at-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to at-users+u...@googlegroups.com.
> To post to this group, send email to at-u...@googlegroups.com.
> Visit this group at http://groups.google.com/group/at-users?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>