Metadata Output Files

Currently certain EWA Stages provide support for creating metadata output files in the following formats:

XML

Here is an example metadata output file in XML format.

XML

<?xml version="1.0" encoding="utf-8"?>
<EWA-Document>
  <File version="">
    <Id>d603fa0b-a423-4122-9625-02657ed5b3b8</Id>
    <Created>2022-12-07T03:48:41.2013577Z</Created>
    <LastModified>2022-12-07T03:52:36.4044349Z</LastModified>
    <CreatedBy />
    <CreatedByUser />
    <Name>img-Z06122416-0001.pdf</Name>
    <ItemId>cc4f3af9-d91a-49ff-b759-ce6853767d49</ItemId>
    <OutputBy>indexing</OutputBy>
    <OutputByUser>admin</OutputByUser>
    <Output>
      <Page>
        <Id>indexing</Id>
        <Name>Remote Index</Name>
      </Page>
      <Queue>
        <Id>1d97627a-174e-498c-b499-f8df9c3da745</Id>
        <Name>admin@localhost.ewa</Name>
      </Queue>
      <QueueType>
        <Id>99b1621a-4e26-488c-9024-c59a9c1a1eb6</Id>
        <Name>Personal</Name>
      </QueueType>
      <User>
        <Id>admin</Id>
        <Name>admin</Name>
        <Email>admin@localhost.ewa</Email>
      </User>
      <Action>
        <Id>08ff275c-f7f6-4681-9497-8222c349f490</Id>
        <Name>Submit</Name>
      </Action>
    </Output>
  </File>
  <Metadata>
    <abn name="" type="object">
      <Abn name="Abn" type="single">18102594883</Abn>
      <AbnStatus name="AbnStatus" type="single">0000000001</AbnStatus>
      <IsCurrent name="IsCurrent" type="single">True</IsCurrent>
      <Name name="Name" type="single">Outback Imaging Pty Ltd</Name>
      <NameType name="NameType" type="single">Entity Name</NameType>
      <PostCode name="PostCode" type="single">4170</PostCode>
      <Score name="Score" type="single">100</Score>
      <State name="State" type="single">QLD</State>
      <EntityName name="EntityName" type="single"></EntityName>
    </abn>
    <invoice_date name="Invoice Date" type="single">14/12/2022</invoice_date>
    <invoice_total name="Invoice Total" type="single">10.49</invoice_total>
    <invoice_number name="Invoice Number" type="single">INV2442</invoice_number>
    <line_items name="Line Items" type="collection">
      <Value name="" type="object">
        <gl_account name="GL Account" type="single">GL3</gl_account>
        <amount name="Amount" type="single">20.00</amount>
        <narrator name="Narrator" type="single">Test Narrator</narrator>
      </Value>
    </line_items>
    <document_id name="Document Id" type="single">123</document_id>
  </Metadata>
  <History>
    <Event>
      <Type>AddedToIndexingQueue</Type>
      <Name>AddedToIndexingQueue</Name>
      <Timestamp>2022-12-07T03:48:41.5811856Z</Timestamp>
      <User>admin</User>
      <Metadata>
        <queueId name="queueId" type="single">1d97627a-174e-498c-b499-f8df9c3da745</queueId>
        <pageId name="pageId" type="single">indexing</pageId>
      </Metadata>
    </Event>
    <Event>
      <Type>FileCreated</Type>
      <Name>FileCreated</Name>
      <Timestamp>2022-12-07T03:48:41.2942503Z</Timestamp>
      <User>admin</User>
      <Metadata />
    </Event>
    <Event>
      <Type>EzeScan.WebApps.Indexing.Action</Type>
      <Name>EzeScan.WebApps.Indexing.Action</Name>
      <Timestamp>2022-12-07T03:52:35.2718102Z</Timestamp>
      <User>admin</User>
      <Metadata>
        <action name="" type="object">
          <id name="id" type="single">08ff275c-f7f6-4681-9497-8222c349f490</id>
          <name name="name" type="single">Submit</name>
          <display name="" type="object">
            <icon name="icon" type="single">check-circle</icon>
            <colour name="colour" type="single">success</colour>
          </display>
        </action>
        <payload name="" type="object">
          <document_id name="Document Id" type="single">123</document_id>
          <invoice_number name="Invoice Number" type="single">INV2442</invoice_number>
          <invoice_date name="Invoice Date" type="single">14/12/2022</invoice_date>
          <line_items name="Line Items" type="collection">
            <Value name="" type="object">
              <gl_account name="GL Account" type="single">GL3</gl_account>
              <amount name="Amount" type="single">20.00</amount>
              <narrator name="Narrator" type="single">Test Narrator</narrator>
            </Value>
          </line_items>
          <abn name="" type="object">
            <Abn name="Abn" type="single">18102594883</Abn>
            <AbnStatus name="AbnStatus" type="single">0000000001</AbnStatus>
            <IsCurrent name="IsCurrent" type="single">True</IsCurrent>
            <Name name="Name" type="single">Outback Imaging Pty Ltd</Name>
            <NameType name="NameType" type="single">Entity Name</NameType>
            <PostCode name="PostCode" type="single">4170</PostCode>
            <Score name="Score" type="single">100</Score>
            <State name="State" type="single">QLD</State>
            <EntityName name="EntityName" type="single"></EntityName>
          </abn>
          <invoice_total name="Invoice Total" type="single">10.49</invoice_total>
        </payload>
      </Metadata>
    </Event>
    <Event>
      <Type>IndexItemClaimedForProcessingEvent</Type>
      <Name>IndexItemClaimedForProcessingEvent</Name>
      <Timestamp>2022-12-07T03:48:44.3568019Z</Timestamp>
      <User>admin</User>
      <Metadata />
    </Event>
  </History>
</EWA-Document>

CSV

CSV output option requires you configure your output file.

CODE

"FORMAT BATCH IMPORT , STANDARD 1.0"
Title,DOCID,DREF1,DDATE,LINEID,LINEDETAILTYPE,LLDGCODE,LACCNBR,LAMOUNT1
TAX INVOICE,123,INV2442,14/12/2022,1,L,AP,,10.49
,123,,,2,A,,,
,123,,,,L,GL,GL3,20.00