JSON Exporter (Worker Process)

Manifest Contents

1. Structure
   
   
   
   

   
    <?xml version="1.0" encoding="UTF-8"?>
    <configuration id="json_export">
     <section name="core">
      <!-- Process Configuration-->
      <config name="process">
       <config name="type">json_export</config>
       <config name="name"></config>
       <config name="description"></config>
       <config name="start"></config>
       <config name="end"></config>
      </config>
      
      <!-- Export Configuration -->
      <config name="export">
       <config name="source">
        <!--types: file, folder-->
        <config name="type"></config>
        <config name="definition"></config>
        <config name="all"></config>
        <config name="exceptions"></config>
        <config name="files"></config>
        <config name="extension"></config>
       </config>
       
       <config name="destination">
        <!--types: filesystem, table, database-->
        <config name="type"></config>
        <config name="definition"></config>
        <config name="contenttype"></config>
        <config name="converter"></config>
        <config name="extension"></config>
       </config>
       
       <config name="xml">
        <config name="xmlmark"></config>
        <config name="roottag"></config>
        <config name="rowtag"></config>
        <config name="extension"></config>
        <config name="encoding"></config>
       </config>
       
       <config name="dif">
        <config name="title"></config>
        <config name="extension"></config>
       </config>
       
       <config name="json">
        <config name="roottag"></config>
        <config name="extension"></config>
       </config>
       
       <config name="excel">
        <config name="singlefile"></config>
        <config name="filename"></config>
        <config name="extension"></config>
       </config>
       
       <config name="tab">
        <config name="extension"></config>
       </config>
       
       <config name="csv">
        <config name="extension"></config>
       </config>
       
       <config name="title"></config>
       <config name="method"></config>
      </config>
      
      <!-- Destination Database Connection -->
      <config name="databases">
       <config name="destdb">
        <config name="dbtype"></config>
        <config name="host"></config>
        <config name="username"></config>
        <config name="password"></config>
        <config name="dbname"></config>
       </config>
      </config>
      
     </section>
    </configuration>
    

   
   
   
   


2. Parameters
   
   
   
   
   1. id
      
      The identity of manifest.
      
   
   
   2. core.process.type
      
      The process type of manifest. Type is json_export.
      
   
   
   3. core.process.name
      
      The name given to this manifest.
      
   
   
   4. core.process.description
      
      The additional information to manifest.
      
   
   
   5. core.process.start
      
      The first date (time) the process will be executed.
      
   
   
   6. core.process.end
      
      The last date (time) the process will be executed.
      
   
   
   7. core.export.source.type
      
      The type of source. Source type can be: file, or folder.
      
   
   
   8. core.export.source.definition
      
      The definition of the source, actual location defined by its type.
      
   
   
   9. core.export.source.all
      
      If all source contents will be processed.
      
   
   
   10. core.export.source.exceptions
       
       Some exceptions from source. Separate list using comma.
       
   
   
   11. core.export.source.files
       
       Additional files as source.
       
   
   
   12. core.export.source.extension
       
       The file extension of the source.
       
   
   
   13. core.export.destination.type
       
       The type of destination. Type can be: filesystem, table or database.
       
   
   
   14. core.export.destination.definition
       
       The definition for destination type, actual location defined by its type.
       
   
   
   15. core.export.destination.contenttype
       
       The content-type of destination data file.
       
   
   
   16. core.export.destination.converter
       
       The converter name if exists.
       
   
   
   17. core.export.destination.extension
       
       The destination file extension.
       
   
   
   18. core.databases.destdb.dbtype
       
       The database type of connection. The database connection for data destination. See Adodb documentation for correct values.
       
   
   
   19. core.databases.destdb.host
       
       The host name or IP on which database is running.
       
   
   
   20. core.databases.destdb.username
       
       The username to make a connection to database.
       
   
   
   21. core.databases.destdb.password
       
       The password of username to make a connection to database.
       
   
   
   22. core.databases.destdb.dbname
       
       The name of database on which data will be stored or retrieved.
       
   
   
   23. core.export.xml.xmlmark
       
       If xml data includes xml marker. If using xmlmark, set value to 1, you may need to define its xml encoding.
       
   
   
   24. core.export.xml.roottag
       
       The root tag of xml data.
       
   
   
   25. core.export.xml.rowtag
       
       The row tag of xml data.
       
   
   
   26. core.export.xml.extension
       
       The xml file extension.
       
   
   
   27. core.export.xml.encoding
       
       The xml file data encoding. Default to UTF-8.
       
   
   
   28. core.export.dif.title
       
       The title for dif data.
       
   
   
   29. core.export.dif.extension
       
       The file extension of dif file.
       
   
   
   30. core.export.json.roottag
       
       The root tag of json data.
       
   
   
   31. core.export.json.extension
       
       The file extension of json file.
       
   
   
   32. core.export.excel.singlefile
       
       If destination excel file is only one.
       
   
   
   33. core.export.excel.flename
       
       The file name of excel file.
       
   
   
   34. core.export.excel.extension
       
       The file extension of excel file.
       
   
   
   35. core.export.tab.extension
       
       The file extension of tab file.
       
   
   
   36. core.export.csv.extension
       
       The file extension of csv file.
       
   
   
   37. core.export.title
       
       If title will be included inside destination data if applicable.
       
   
   
   38. core.export.method
       
       The method regarding existing destination file. Method can be: replace or none.
       
   
   
   
   


3. Example
   
   
   
   

   
    <?xml version="1.0" encoding="UTF-8"?>
    <configuration id="json_export">
     <section name="core">
      <!-- Process Configuration-->
      <config name="process">
       <config name="type">json_export</config>
       <config name="name"><![CDATA[JSONExport]]></config>
       <config name="description"><![CDATA[JSON Export]]></config>
       <config name="start"></config>
       <config name="end"></config>
      </config>
      
      <!-- Destination Database Connection -->
      <config name="databases">
       <config name="destdb">
        <config name="type">DATABASE</config>
        <config name="dbtype">mysql</config>
        <config name="host">127.0.0.1</config>
        <config name="username">root</config>
        <config name="password">13294132el</config>
        <config name="dbname">test</config>
       </config>
      </config>
      
      <!--Export Configuration-->
      <config name="export">
       <config name="source">
        <!--types: file, folder-->
        <config name="type">folder</config>
        <config name="definition"><![CDATA[/tmp/]]></config>
        <config name="files"></config>
        <config name="all">1</config>
        <config name="exceptions"></config>
        <config name="extension">json</config>
       </config>
       
       <config name="destination">
        <!--types: filesystem, table, database-->
        <config name="type">filesystem</config>
        <config name="definition">/tmp/</config>
        <config name="contenttype">excel</config>
        <config name="converter">pdf</config>
        <config name="extension">tbl</config>
       </config>
       
       <config name="xml">
        <config name="xmlmark">1</config>
        <config name="encoding">UTF-8</config>
        <config name="roottag">root</config>
        <config name="rowtag">row</config>
        <config name="extension">xml</config>
       </config>
       
       <config name="dif">
        <config name="title">root</config>
        <config name="extension">dif</config>
       </config>
       
       <config name="json">
        <config name="roottag">root</config>
        <config name="extension">json</config>
       </config>
       
       <config name="excel">
        <config name="singlefile">0</config>
        <config name="filename">ciis.xls</config>
        <config name="extension">xls</config>
       </config>
       
       <config name="tab">
        <config name="extension">tab</config>
       </config>
       
       <config name="csv">
        <config name="extension">csv</config>
       </config>
       
       <config name="title">1</config>
       <config name="method">replace</config>
      </config>
     </section>
    </configuration>