2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Similarly right-click on the DBmap state now and select "properties". Click on* {}Edit{} link besides  *****_map.xml file to open the mapping page in a new window or a new tab. Enter the following mapping.
    || Target || = || Source ||

    CustomerAddRq/CustomerAdd/BillAddress/Addr1

    =

    VALUE("billingstreet")

    CustomerAddRq/CustomerAdd/BillAddress/City

    =

    VALUE("billingcity")

    CustomerAddRq/CustomerAdd/BillAddress/Country

    =

    VALUE("billingcountry")

    CustomerAddRq/CustomerAdd/BillAddress/PostalCode

    =

    VALUE("billingcode")

    CustomerAddRq/CustomerAdd/BillAddress/State

    =

    VALUE("billingstate")

    CustomerAddRq/CustomerAdd/CompanyName

    =

    VALUE("company")

    CustomerAddRq/CustomerAdd/Fax

    =

    VALUE("fax")

    CustomerAddRq/CustomerAdd/FirstName

    =

    VALUE("firstname")

    CustomerAddRq/CustomerAdd/IsActive

    =

    "true"

    CustomerAddRq/CustomerAdd/LastName

    =

    VALUE("lastname")

    CustomerAddRq/CustomerAdd/Name

    =

    VALUE("Name")

    CustomerAddRq/CustomerAdd/Phone

    =

    VALUE("phone")

    VALIDATEROW

    =

    "true"

...

  • Make sure the XML Formatter section is filled up with the following code.
Code Block
customerid,billaddress,billingcity,billingstate,billingpostalcode,billingcountry,date,invoice_no,[item,itemdesc,quantity,salesprice]
  • Now configure the DBwriter 

...

autocreate  :  True

  •  Now open the DBmap and enter the following mapping in the mapping window.

...