ImpFrac

Below is an example of a start command:

AiolosConsoleUI.exe /serveraddress:http://localhost/NewAiolosService /configuration:Demo2014  /settingsfile:impfrac.autopar

And below is an example of the file impfrac.autopar when importing from a database file.

/name:ImpFrac

/action:impfrac

/source:C:\Aiolos\Demo2014\tmp\import\ImpFrac\sqlimport.xml

/type:database

/keypattern:1;3

                                                                And below is an example on the xml-file for the sql-import

 

<?xml version="1.0" encoding="ISO-8859-1"?>

<AiolosSQLImportFractions>

 

    Anslutning till databasen

   <Connect>

       Data Source="C:\Aiolos\Demo2014\tmp\import\ImpFrac\impfracsql.accdb"

   </Connect>

 

    Fråga att ställa mot databasen.

   <SQL>

       SELECT Netarea, Balance, Supplier, Period, FactorPercent from TwoRowPercent

   </SQL>

 

    <RSType>

        TwoRowsPercent

    </RSType>

 

    Provider mot SQL Server: SQLOLEDB

    <Provider>

        Microsoft.ACE.OLEDB.12.0

    </Provider>

 

    <DateFormat>

   YYYYMM

    </DateFormat>

 

</AiolosSQLImportFractions>