pkONE^® : BLPK Documentation

<file-configuration>
    <!-- KPD: 85020.1 -->
    <file-name>\d{8}-\d\d.\d\d.\d\d_Upload_(85020\.0|85020\.1)\.(txt|csv)</file-name>

    <!-- Parser types, s. DataCrawler.EntryParser -->
    <processor-type>4</processor-type>
    <processor-configuration>
        <entry>
            <entry-type>REPEATABLE</entry-type>
            <check-for-binary>true</check-for-binary>
            <encoding>ISO-8859-1</encoding>
            <!-- projector-command-id has to be a unique text identifier for the used command -->
            <projector>
                <projector-id>standard</projector-id>
                <projector-class>
                    ch.optimizeit.datacrawlerblpk.projection.NonKantonMutationProjector
                </projector-class>
            </projector>

            <!-- field list -->
            <field id="1">
                <field-name>bookingYear</field-name>
                <field-type>not-used</field-type>
                <field-regex>\d{4}</field-regex>
            </field>
            <field id="2">
                <field-name>bookingMonth</field-name>
                <field-type>not-used</field-type>
                <field-regex>\d{2}</field-regex>
            </field>
            <field id="3">
                <field-name>mandantNo</field-name>
                <field-type>string</field-type>
                <field-regex>(.{7})</field-regex>
            </field>
            <field id="4">
                <field-name>departmentNo</field-name>
                <field-type>string</field-type>
                <field-regex>(\d{6})</field-regex>
            </field>
            <field id="5">
                <field-name>personalNo</field-name>
                <field-type>string</field-type>
                <field-regex>(.{18})</field-regex>
            </field>
            <field id="6">
                <field-name>pkNo</field-name>
                <field-type>string</field-type>
                <field-regex>(\d{6})</field-regex>
            </field>
            <field id="7">
                <field-name>ahvNo</field-name>
                <field-type>string</field-type>
                <field-regex>(\d{11}|\s{11})</field-regex>
            </field>
            <field id="8">
                <field-name>mutationsCode</field-name>
                <field-type>not-used</field-type>
                <field-regex>\d{2}</field-regex>
            </field>
            <field id="9">
                <field-name>lastName</field-name>
                <field-type>string</field-type>
                <field-regex>(.{25})</field-regex>
            </field>
            <field id="10">
                <field-name>firstName</field-name>
                <field-type>string</field-type>
                <field-regex>(.{20})</field-regex>
            </field>
            <field id="11">
                <field-name>valutaDate</field-name>
                <field-type>bigEndianDate</field-type>
                <field-regex>(\d{8})</field-regex>
            </field>
            <field id="12">
                <field-name>grossIncome</field-name>
                <field-type>double</field-type>
                <field-regex>(\d{7})</field-regex>
            </field>
            <field id="13">
                <field-name>pensum</field-name>
                <field-type>decimal3</field-type>
                <field-regex>(\d{6})</field-regex>
            </field>
            <field id="14">
                <field-name>versicherungsTyp</field-name>
                <field-type>not-used</field-type>
                <field-regex>[\d\s]{1}</field-regex>
            </field>
            <field id="15">
                <field-name>birthday</field-name>
                <field-type>bigEndianDate</field-type>
                <field-regex>(\d{8})</field-regex>
            </field>
            <field id="16">
                <field-name>sex</field-name>
                <field-type>integer</field-type>
                <field-regex>(\d{1})</field-regex>
            </field>
            <field id="17">
                <field-name>civilStatus</field-name>
                <field-type>integer</field-type>
                <field-regex>(\d{1})</field-regex>
            </field>
            <field id="18">
                <field-name>entryDate</field-name>
                <field-type>bigEndianDate</field-type>
                <field-regex>(\d{8})</field-regex>
            </field>
            <field id="19">
                <field-name>austrittsGrund</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{1}</field-regex>
            </field>
            <field id="20">
                <field-name>street1</field-name>
                <field-type>string</field-type>
                <field-regex>(.{35})</field-regex>
            </field>
            <field id="21">
                <field-name>street2</field-name>
                <field-type>string</field-type>
                <field-regex>(.{35})</field-regex>
            </field>
            <field id="22">
                <field-name>zip</field-name>
                <field-type>string</field-type>
                <field-regex>(.{8})</field-regex>
            </field>
            <field id="23">
                <field-name>city</field-name>
                <field-type>string</field-type>
                <field-regex>(.{26})</field-regex>
            </field>
            <field id="24">
                <field-name>countryCode</field-name>
                <field-type>string</field-type>
                <field-regex>(.{3})</field-regex>
            </field>
            <field id="25">
                <field-name>spouseLastname</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{25}</field-regex>
            </field>
            <field id="26">
                <field-name>spouseFirstname</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{20}</field-regex>
            </field>
            <field id="27">
                <field-name>spouseBirthday</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{8}</field-regex>
            </field>
            <field id="28">
                <field-name>marriageDate</field-name>
                <field-type>bigEndianDate</field-type>
                <field-regex>(\d{8})</field-regex>
            </field>
            <field id="29">
                <field-name>numberChildren</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{2}</field-regex>
            </field>
            <field id="30">
                <field-name>internalNumber</field-name>
                <field-type>not-used</field-type>
                <field-regex>.{5}</field-regex>
            </field>
            <field id="31">
                <field-name>exitDate</field-name>
                <field-type>bigEndianDate</field-type>
                <field-regex>(\d{8})</field-regex>
            </field>
            <field id="32">
                <field-name>sovNo</field-name>
                <field-type>string</field-type>
                <field-regex>(\d{13})</field-regex>
            </field>

            <!-- specify output builder name -->
            <!-- multipleEntry processor can have multiple csv builder, therefore a list of builders must be
                passed to the processor -->
            <outputbuilder>
                <outputbuilder-id>
                    clanOnlineMutationOutputBuilder
                </outputbuilder-id>
            </outputbuilder>
        </entry>
    </processor-configuration>

    <!-- distributor configuration -->
    <distributor-configuration>
        <distributor-id>fileDistributor</distributor-id>
        <destination-filename-strategies>
            <destination-filename-strategy>
                <strategy>change-suffix</strategy>
                <parameter>.txt</parameter>
                <parameter>.csv</parameter>
            </destination-filename-strategy>
        </destination-filename-strategies>
    </distributor-configuration>
</file-configuration>

    public String doProjection(HashMap<String, Object> fieldsAndValues)
{
    String explanation = null;

    // Add exit reason = 1 if an exitdate exists
    Date exitDate = (Date) fieldsAndValues.get("exitDate");
    if (exitDate != null)
    {
        fieldsAndValues.put("exitReason", "1");
    }
    else
    {
        fieldsAndValues.put("exitReason", "");
    }

    // Check if the record adresses the correct mandantNo. If not return with
    // error message.
    if ((explanation = ProjectionHelper.checkMandantNoValid(fieldsAndValues)) != null)
    {
        return explanation;
    }

    // Add sovnr for future compatibility
    String sovNo = (String) fieldsAndValues.get("sovNo");
    if (sovNo.equals("0") || sovNo.equals("0000000000000"))
    {
        fieldsAndValues.put("sovNo", "");
    }

    // Map civil status
    // AGs Non Kanton: 1=ledig, 2=verheiratet, 3=geschieden, 4=verwitwet,
    // 5=Konkubinate, 6=eingetragene Partnerschaft
    // Clan: 0=ledig, 1=verheiratet, 2=geschieden, 3=verwitwet, 4=getrennt,
    // 6=eingetragene Partnerschaft, 7=aufgeloeste Partnerschaft, 8=Konkubinat
    int civilStatus = ((Integer) fieldsAndValues.get("civilStatus")).intValue();

    _log.trace("Received civilStatus: {} ", civilStatus);

    switch (civilStatus)
    {
        case 1:
        case 2:
        case 3:
        case 4:
            civilStatus--;
            break;

        case 5:
            civilStatus = 8;
            break;

        default:
            explanation = "No mapping for civilStatus: " + civilStatus;
            _log.error(explanation);
            break;
    }
    if (_log.isTraceEnabled())
        _log.trace("Computed civilStatus: " + civilStatus);
    fieldsAndValues.put("civilStatus", Integer.valueOf(civilStatus));

    // TODO: Map country code
    // ONLY for testing purposes. In production the ISO standard should be used
    // so no mapping must be applied.
    String countryCode = (String) fieldsAndValues.get("countryCode");
    if (countryCode.equalsIgnoreCase("deu") || countryCode.equalsIgnoreCase("fra"))
    {
        if (_log.isTraceEnabled())
            _log.trace("Received countryCode: " + countryCode);
        countryCode = countryCode.substring(0, 2);
        if (_log.isTraceEnabled())
            _log.trace("Computed countryCode: " + countryCode);
        fieldsAndValues.put("countryCode", countryCode);
    }

    // Add Anrede/title
    fieldsAndValues.put("title", fieldsAndValues.get("sex"));

    // Add valutaDate if it is null
    Date valutaDate = (Date) fieldsAndValues.get("valutaDate");
    if (valutaDate == null)
    {
        Calendar cal = Calendar.getInstance();
        cal.clear();
        cal.set(2008, 0, 1);
        valutaDate = cal.getTime();
        fieldsAndValues.put("valutaDate", valutaDate);
    }

    // Add Sprache/language
    fieldsAndValues.put("language", Integer.valueOf(1));

    // Add entryInsuranceDate = entryDate
    fieldsAndValues.put("entryInsuranceDate", fieldsAndValues.get("entryDate"));

    // Add salaryType
    fieldsAndValues.put("salaryType", "1");

    // Add missing fields not provided by source
    fieldsAndValues.put("street3", "");

    // Added as of version 10.7.0
    fieldsAndValues.put("divorceDateNew", "");
    fieldsAndValues.put("annotations", "");

    // Added as of version 10.7.8
    fieldsAndValues.put("unpaidHolidaysFrom", "");
    fieldsAndValues.put("unpaidHolidaysTo", "");

    // Newly required field, but not delivered via interface
    fieldsAndValues.put("ivGrad", null);
    fieldsAndValues.put("code", null);

<outputbuilder-configuration>
    <!-- field delimiter -->
    <field-delimiter>;</field-delimiter>

    <!-- fields -->
    <field id="1">
        <field-name>mandantNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="2">
        <field-name>departmentNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="3">
        <field-name>pkNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="4">
        <field-name>personalNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="5">
        <field-name>lastName</field-name>
        <field-type>string</field-type>
    </field>
    <field id="6">
        <field-name>firstName</field-name>
        <field-type>string</field-type>
    </field>
    <field id="7">
        <field-name>ahvNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="8">
        <field-name>sovNo</field-name>
        <field-type>string</field-type>
    </field>
    <field id="9">
        <field-name>birthday</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="10">
        <field-name>civilStatus</field-name>
        <field-type>string</field-type>
    </field>
    <field id="11">
        <field-name>sex</field-name>
        <field-type>string</field-type>
    </field>
    <field id="12">
        <field-name>title</field-name>
        <field-type>string</field-type>
    </field>
    <field id="13">
        <field-name>language</field-name>
        <field-type>string</field-type>
    </field>
    <field id="14">
        <field-name>entryDate</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="15">
        <field-name>entryInsuranceDate</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="16">
        <field-name>exitDate</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="17">
        <field-name>exitReason</field-name>
        <field-type>string</field-type>
    </field>
    <field id="18">
        <field-name>valutaDate</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="19">
        <field-name>grossIncome</field-name>
        <field-type>double</field-type>
    </field>
    <field id="20">
        <field-name>salaryType</field-name>
        <field-type>string</field-type>
    </field>
    <field id="21">
        <field-name>bonus</field-name>
        <field-type>empty</field-type>
    </field>
    <field id="22">
        <field-name>pensum</field-name>
        <field-type>double</field-type>
    </field>
    <field id="23">
        <field-name>vspbgrd</field-name>
        <field-type>empty</field-type>
    </field>
    <field id="24">
        <field-name>ivGrad</field-name>
        <field-type>double</field-type>
    </field>
    <field id="25">
        <field-name>fil1cd</field-name>
        <field-type>empty</field-type>
    </field>
    <field id="26">
        <field-name>street1</field-name>
        <field-type>string</field-type>
    </field>
    <field id="27">
        <field-name>street2</field-name>
        <field-type>string</field-type>
    </field>
    <field id="28">
        <field-name>street3</field-name>
        <field-type>string</field-type>
    </field>
    <field id="29">
        <field-name>countryCode</field-name>
        <field-type>string</field-type>
    </field>
    <field id="30">
        <field-name>zip</field-name>
        <field-type>string</field-type>
    </field>
    <field id="31">
        <field-name>city</field-name>
        <field-type>string</field-type>
    </field>
    <field id="32">
        <field-name>marriageDate</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="33">
        <field-name>code</field-name>
        <field-type>string</field-type>
    </field>
    <field id="34">
        <field-name>divorceDateNew</field-name>
        <field-type>germanLittleEndianDate</field-type>
    </field>
    <field id="35">
        <field-name>annotations</field-name>
        <field-type>string</field-type>
    </field>
    <!-- Added as of version 10.7.8 -->
    <field id="36">
        <field-name>unpaidHolidaysFrom</field-name>
        <field-type>string</field-type>
    </field>
    <field id="37">
        <field-name>unpaidHolidaysTo</field-name>
        <field-type>string</field-type>
    </field>
</outputbuilder-configuration>