Zynk CSV to Zynk Suppliers XML

The supplier CSV works on the basis of one CSV line representing one supplier, where that line holds all the information about that supplier and it is not split over multiple lines.

Example CSV

UniqueId,   CompanyName,    AccountReference,   VatNumber,  CreditLimit,    Balance,    Title,  Forename,   Surname,    Address1,   Address2,   Address3,   Town,   County, Postcode,   Country,    Email,  Mobile, Fax,    Website
123,    Zynk Software Limited,  ZYNK001,    GB988 3453 23,  17000,  1644.39,    Mr, Joe,    Harrison,   Nelson House,   Fleming Business Centre,    Jesmond,    Newcastle upon-Tyne,    NE23AE, GB, [email protected],   0845 123 2920,  0845 123 2921,  ,   https://zynk.com/
456 ,   Example Company ,   EXAM002 ,   GB988 3453 23,  12000,  1300,   Mr, Joe,    Harrison,   Nelson House,   Fleming Business Centre,    Jesmond,    Newcastle upon-Tyne,    NE23AE, GB, [email protected],   0845 123 2920,  0845 123 2921,  ,   https://zynk.com/

<?xml version="1.0" encoding="utf-8"?>
<Company>
    <Suppliers>
        <Supplier>
            <UniqueId>123</UniqueId>
            <CompanyName>Zynk Software Limited</CompanyName>
            <AccountReference>ZYNK001</AccountReference>
            <VatNumber>GB988 3453 23</VatNumber>
            <CreditLimit>17000</CreditLimit>
            <Balance>1644.39</Balance>
            <SupplierInvoiceAddress>
                <Address1>Nelson House</Address1>
                <Address2>Fleming Business Centre</Address2>
                <Address3>Jesmond</Address3>
                <Town>Newcastle upon-Tyne</Town>
                <County>NE23AE</County>
                <Postcode>GB</Postcode>
                <Country>[email protected]</Country>
                <Title>Mr</Title>
                <Forename>Joe</Forename>
                <Surname>Harrison</Surname>
                <Mobile>0845 123 2921</Mobile>
                <Fax></Fax>
                <Website>https://zynk.com/</Website>
                <Email>0845 123 2920</Email>
            </SupplierInvoiceAddress>
            <SupplierDeliveryAddress>
                <Address1>Nelson House</Address1>
                <Address2>Fleming Business Centre</Address2>
                <Address3>Jesmond</Address3>
                <Town>Newcastle upon-Tyne</Town>
                <County>NE23AE</County>
                <Postcode>GB</Postcode>
                <Country>[email protected]</Country>
                <Title>Mr</Title>
                <Forename>Joe</Forename>
                <Surname>Harrison</Surname>
                <Mobile>0845 123 2921</Mobile>
                <Fax></Fax>
                <Website>https://zynk.com/</Website>
                <Email>0845 123 2920</Email>
            </SupplierDeliveryAddress>
        </Supplier>
        <Supplier>
            <UniqueId>EXAM002 </UniqueId>
            <CompanyName>Example Company </CompanyName>
            <AccountReference>EXAM002 </AccountReference>
            <VatNumber>GB988 3453 23</VatNumber>
            <CreditLimit>12000</CreditLimit>
            <Balance>1300</Balance>
            <SupplierInvoiceAddress>
                <Address1>Nelson House</Address1>
                <Address2>Fleming Business Centre</Address2>
                <Address3>Jesmond</Address3>
                <Town>Newcastle upon-Tyne</Town>
                <County>NE23AE</County>
                <Postcode>GB</Postcode>
                <Country>[email protected]</Country>
                <Title>Mr</Title>
                <Forename>Joe</Forename>
                <Surname>Harrison</Surname>
                <Mobile>0845 123 2921</Mobile>
                <Fax></Fax>
                <Website>https://zynk.com/</Website>
                <Email>0845 123 2920</Email>
            </SupplierInvoiceAddress>
            <SupplierDeliveryAddress>
                <Address1>Nelson House</Address1>
                <Address2>Fleming Business Centre</Address2>
                <Address3>Jesmond</Address3>
                <Town>Newcastle upon-Tyne</Town>
                <County>NE23AE</County>
                <Postcode>GB</Postcode>
                <Country>[email protected]</Country>
                <Title>Mr</Title>
                <Forename>Joe</Forename>
                <Surname>Harrison</Surname>
                <Mobile>0845 123 2921</Mobile>
                <Fax></Fax>
                <Website>https://zynk.com/</Website>
                <Email>0845 123 2920</Email>
            </SupplierDeliveryAddress>
        </Supplier>
    </Suppliers>
</Company>