2022
Page History
...
- Enter the following query within the query section of the database adapter.
Code Block select * from account- Right-click on the DBwriter now and select "properties" and configure the following.
...
- 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" |
- At this point, your DBSync is set to move Account records from your database table to Quickbooks Customer.
...
Overview
Content Tools