[Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator='
ImportPreview=1

[Output]
FileOutputOnly=0

[MLXML]
UID={55021F80-0823-4791-AC71-95214751F9E8}
PreProcessor=unidb.mip
AllowImport=1
AllowExport=0
ErrorLogFile=
AllowDirectStart=0
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
UserCaption=WMC Brokerstar MySQL-Import (Template)
PartName=crm_address

[RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[ProcessingOptions]
modifyexisting=0
updatecheck=0
binaryhandlingmode=cdata

[DB]
Database=
Port=3306
Provider=MySQL
Query=@{@$APP$mlxml\wmc_contact.query}
Host=
Username=
Password=

[DBProviderOptions]
UseUnicode=True

[ConstantValuesImport]
crm_address_source=wmc_mysql
responsibleid--sourcefield=shortcut
bssachbearbeiterid--sourcefield=shortcut
mandatmanagerid--sourcefield=shortcut
bssharerid--sourcefield=impid

[CA24C5AD86E245B3BD012B5A5CB1D371_DB]
Query=@{@$APP$mlxml\wmc_contact_group.query}

[CA24C5AD86E245B3BD012B5A5CB1D371_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator='
ImportPreview=0

[CA24C5AD86E245B3BD012B5A5CB1D371_MLXML]
UID={741282D9-FF32-4F93-B1C2-CCA35D4CC9FC}
PartName=address_addressassignment
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
UserCaption=Contactgroups

[CA24C5AD86E245B3BD012B5A5CB1D371_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[CA24C5AD86E245B3BD012B5A5CB1D371_ProcessingOptions]
modifyexisting=1
updatecheck=1
binaryhandlingmode=cdata

[CA24C5AD86E245B3BD012B5A5CB1D371_Mapping]
name=ptypeid

[CA24C5AD86E245B3BD012B5A5CB1D371_ConstantValuesImport]
address_addressassignment_source=wmc_mysql

[CA24C5AD86E245B3BD012B5A5CB1D371_MLXML Options]
showparams=0

[E7B27972821341C1842245FEAD6E1666_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator='
ImportPreview=0

[E7B27972821341C1842245FEAD6E1666_MLXML]
UID={BAA9092B-8833-4FEE-8CD4-A379627BE16C}
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
PartName=nwm_contract
UserCaption=Policy

[E7B27972821341C1842245FEAD6E1666_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[E7B27972821341C1842245FEAD6E1666_ProcessingOptions]
modifyexisting=1
updatecheck=1
detailmode=3
binaryhandlingmode=cdata

[E7B27972821341C1842245FEAD6E1666_DB]
Query=@{@$APP$mlxml\wmc_policy.query}

[E7B27972821341C1842245FEAD6E1666_ConstantValuesImport]
customerid--sourcefield=impid
nwm_contract_source=wmc_mysql
societyid--sourcefield=impid
recruiterid--sourcefield=impid
ownerid--sourcefield=shortcut

[E7B27972821341C1842245FEAD6E1666_Replacements_contractstateid]
in Kraft=Angenommen

[E7B27972821341C1842245FEAD6E1666_MLXML Options]
showparams=0

[06E744FA2D814094B137D0B47DE128AD_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator='
ImportPreview=0

[06E744FA2D814094B137D0B47DE128AD_MLXML]
UID={D2FB40CC-C0D2-4361-B80A-1A5AA8738A40}
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
PartName=nwm_contract_attachement
UserCaption=PolicyDocuments

[06E744FA2D814094B137D0B47DE128AD_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[06E744FA2D814094B137D0B47DE128AD_ProcessingOptions]
modifyexisting=1
updatecheck=1
detailmode=3
binaryhandlingmode=cdata

[06E744FA2D814094B137D0B47DE128AD_DB]
Query=@{@$APP$mlxml\wmc_policydocuments.query}

[06E744FA2D814094B137D0B47DE128AD_ConstantValues]
contractid--sourcefield=impid

[06E744FA2D814094B137D0B47DE128AD_Mapping]
local_filepath=attachmentfile
filename_text=filename
category_text=destpath
policy_id=contractid

[AF7620FE4382400DAA87D67C3158D16A_DB]
Query=@{@$APP$mlxml\wmc_contactdocuments.query}

[AF7620FE4382400DAA87D67C3158D16A_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator='
ImportPreview=0

[AF7620FE4382400DAA87D67C3158D16A_MLXML]
UID={81DBFCE1-1C90-44C0-9D16-F817550BFB53}
PartName=crm_address_documents
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
UserCaption=Contactdocuments

[AF7620FE4382400DAA87D67C3158D16A_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[AF7620FE4382400DAA87D67C3158D16A_ProcessingOptions]
modifyexisting=1
updatecheck=1
detailmode=3
binaryhandlingmode=cdata

[AF7620FE4382400DAA87D67C3158D16A_ConstantValues]
ownerid--sourcefield=impid

[MLXML Options]
showparams=0

[06E744FA2D814094B137D0B47DE128AD_MLXML Options]
showparams=0
mlxml_documentroot={PATH}\Data\Brokerstar\clientfiles
mlxml_documenterrorlog=$APP$Data\FileImportError.log

[AF7620FE4382400DAA87D67C3158D16A_MLXML Options]
showparams=0
mlxml_documentroot={PATH}\Data\Brokerstar\clientfiles
mlxml_documenterrorlog=$APP$Data\FileImportError.log

[Replacements_talkto]
{}=Firma

[Replacements_internet1]
{http://}=
{https://}=

[Replacements_internet2]
{http://}=
{https://}=

[E1143DB899DD41EFBAA214DF1A517392_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator=’
ImportPreview=0

[E1143DB899DD41EFBAA214DF1A517392_MLXML]
UID={803F87A6-2A81-4D52-A4DF-9D12C71CA82D}
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
PartName=crm_address
UserCaption=Users

[E1143DB899DD41EFBAA214DF1A517392_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[E1143DB899DD41EFBAA214DF1A517392_ProcessingOptions]
modifyexisting=1
updatecheck=1
binaryhandlingmode=cdata
detailmode=2

[E1143DB899DD41EFBAA214DF1A517392_DB]
Query=@{@$APP$mlxml\wmc_user.query}

[E1143DB899DD41EFBAA214DF1A517392_Replacements_isactive]
{1}=Aktiv
{0}=Inaktiv

[E1143DB899DD41EFBAA214DF1A517392_ConstantValuesImport]
crm_address_source=wmc_mysql

[E1143DB899DD41EFBAA214DF1A517392_Mapping]
firstname=name
lastname=surname
username=shortcut
enabled=isactive
talkto=talkto
nickname=nickname
phone_fixed=phone2
phone_mobile=mobile2
email=email2
position=function
id=crm_address_ident

[6FEE5622F2944AD8801DC70AE500E125_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator=’
ImportPreview=0

[6FEE5622F2944AD8801DC70AE500E125_MLXML]
UID={50243E51-2180-464C-A701-98283E141AA4}
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
PartName=address_contactperson
UserCaption=ContactPersons

[6FEE5622F2944AD8801DC70AE500E125_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[6FEE5622F2944AD8801DC70AE500E125_ProcessingOptions]
modifyexisting=1
updatecheck=1
binaryhandlingmode=cdata
detailmode=3

[6FEE5622F2944AD8801DC70AE500E125_DB]
Query=@{@$APP$mlxml\wmc_contactpersons.query}

[6FEE5622F2944AD8801DC70AE500E125_ConstantValuesImport]
addressid--sourcefield=impid
parentaddressid--sourcefield=impid
address_contactperson_source=wmc_mysql
connectionstateid=Aktiv

[6FEE5622F2944AD8801DC70AE500E125_Mapping]
link_caption=contactpersontypeid
contact_sub_id=addressid
contact_id=parentaddressid
id=address_contactperson_ident

[AF7620FE4382400DAA87D67C3158D16A_Mapping]
entry_id=ownerid
filename_text=filename
local_filepath=attachmentfile
foldername=destpath
created_at=creadate
updated_at=lastchangedtsp

[E1143DB899DD41EFBAA214DF1A517392_MLXML Options]
showparams=0

[6FEE5622F2944AD8801DC70AE500E125_MLXML Options]
showparams=0

[Mapping]
updated_at=lastchangedtsp
created_at=creadate
companyname=companyname
name=name
surname=surname
address=adress
postcode=zip
city=city
country_text=countryid
nr=adrnumber
responsibleid=responsibleid
remarks=acomment
status_text=isactive
activity=activitystateid
marstate=marstate
language_text=corresp_language_id
tax_nr=ustnumber
trade_register_nr=companyregnumber
confessionid=confessionid
salutation_form=talktoform
talkto=talkto
title=title
nationalid=nationalid
birthday=birthday
birth_place=birthcity
marriageday=marstatesince
children=childrens
phone_fixed_private=phone1
phone_fixed=phone2
phone_mobile=mobile1
phone_direct=officephonedirect
fax=faxnumber2
mail_private=email1
mail=email2
url_2=internet1
url=internet2
skype_name=skypenumber1
social_security_number=ahvinsnumber
profession=educationjob
employer=employer
department=department
branch=branchid
income_amount_year=inamount
residence_permit_date=atcountrysince
driver_licence_date=driverlicdate
license_bike=driverlicdatebike
license_truck=driverlicdatetruck
smoker=issmocker
contract_start_date=mandatebegin
contract_end_date=mandateend
customervalue=customervalue
mandatmanagerid=mandatmanagerid
sachbearbeiter_name=bssachbearbeiterid
income_amount=incomeother
id=crm_address_ident
adress_assignment=crm_address_groups

[C95D87A9A0AA45F89E52329A7F1A95B9_Settings]
DateFormat=dd/MM/yyyy
TimeFormat=hh:mm
DateSeparator=.
TimeSeparator=:
DecimalSeparator=.
ThousandSeparator=’
ImportPreview=0

[C95D87A9A0AA45F89E52329A7F1A95B9_MLXML]
UID={45F2FFDD-4532-4E55-B4A6-91F7BB640818}
AskForDataFile=0
AllowMultipleDataFile=0
AllowUserConfigure=1
PartName=crm_address
UserCaption=UpdateSharer

[C95D87A9A0AA45F89E52329A7F1A95B9_RTF]
DefaultFontSize=8
HTMLReaderOptions=-usecr

[C95D87A9A0AA45F89E52329A7F1A95B9_ProcessingOptions]
modifyexisting=1
updatecheck=1
binaryhandlingmode=cdata
detailmode=3
updatefields=bssharerid
checkfields=bssharerid

[C95D87A9A0AA45F89E52329A7F1A95B9_DB]
Query=@{@$APP$mlxml\wmc_contact.query}

[C95D87A9A0AA45F89E52329A7F1A95B9_Mapping]
sharer_id=bssharerid
id=crm_address_ident

[DetailParts]
CA24C5AD86E245B3BD012B5A5CB1D371=
E7B27972821341C1842245FEAD6E1666=
06E744FA2D814094B137D0B47DE128AD=
AF7620FE4382400DAA87D67C3158D16A=
E1143DB899DD41EFBAA214DF1A517392=
6FEE5622F2944AD8801DC70AE500E125=
C95D87A9A0AA45F89E52329A7F1A95B9=

[C95D87A9A0AA45F89E52329A7F1A95B9_ConstantValuesImport]
bssharerid--sourcefield=impid
crm_address_source=wmc_mysql

[C95D87A9A0AA45F89E52329A7F1A95B9_MLXML Options]
showparams=0
inheritedsettings=0

[E7B27972821341C1842245FEAD6E1666_Mapping]
nr=pnumber
contact_id=customerid
user_text=ownerid
start_date=startdate
end_date=stopdate
assurance_contact_id=societyid
currency_text=currencyid
cancelled_at=quitdate
conclusion_date=signdate
acceptance_date=contdate
branch_text=prtypeid
total_year_amount_netto=coastnet
total_year_amount_brutto=coastbrut
info=acomment
payment_type_text=paymentmodid
status_text2=contractstateid
hauptf_m=mainsettlementmonth
hauptf_d=mainsettlementday
receipt_date=incommingdate
duration=runtime
ismandat=ismandat
year_right_cancel=cancelationrightyearly
berater_contactid=recruiterid
car1_brand=car1_mark
car1_model=car1_model
car1_nr=car1_sign
car2_brand=car2_mark
car2_model=car2_model
car2_nr=car2_sign
sum_insured=hginsuredamount
id=nwm_contract_ident

