You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
Introduction
- The migration template has been formulated for QuickBooks to Salesforce data migration.
- The purpose of this template is to migrate the user's historical data on a single integration run.
- Also the update functionality has been provided with this to make sure that the records are updated both at QuickBooks as well as Salesforce.
- The following section gives you step by step instructions to initiate the migration of your Quickbooks records to Salesforce objects using Salesforce & Quickbooks Migration Process Template.
Purchasing Migration Template
- Go to www.mydbsync.com and register using Register Link on the left hand side of the page or at top right corner of the page.
- To Add Adapters go to www.mydbsync.com and click on Customer Login.
- Enter your USER NAME and PASSWORD and click on Login. Select Library link from the top menu.
- In the Library page, scroll to the bottom of the page and navigate to page 2 to select the Salesforce & Quickbooks Migration template as shown in the screenshot below.
![](/docs/download/attachments/819516/migration1.png?version=1&modificationDate=1312470548000&api=v2)
- Click on View More Button besides the Template and on the next screen click on Add Now Button to add the Migration Template to your DBSync profile. The below screenshot illustrates the same.
![](/docs/download/attachments/819516/migration2.png?version=1&modificationDate=1312470771000&api=v2)
![](/docs/download/attachments/819516/migration3.png?version=3&modificationDate=1312471928000&api=v2)
- Once you click on the Add Now button, you will be re-directed to the properties window.
Enter your login information in the properties window for Salesforce and click on validate button to validate the login credentials of Salesforce. Once you receive the message "Connection settings are valid" click on Continue button at the bottom. If you receive the message "Connection settings are invalid" then please check for the following
- Check whether User ID and Password for Salesforce is correct.
- Is there any invalid Network Access Settings.
- Make sure that security token is added in your password (for Salesforce Adapter)
![](/docs/download/attachments/819516/G1.jpg?version=1&modificationDate=1275602612000&api=v2)
- The validation for the Salesforce adapter is a must for proceeding further in the properties window.
- Click on QuickBooks link from the left Menu to open QuickBooks configuration settings. Enter you QuickBooks Desktop file path in the "file:*" text box and click on **{}Save{}* *{}Properties* _button. Click on configuration Link at the bottom of the Edit Properties Area.
- You can retrieve full path / location of your Quickbooks file by pressing 'F2' key on your keyboard when in Quickbooks 'Home' page as shown below.
- A Pop-up box will appear, asking to open the file with "QuickBooks Web Connector (default)" click on OK button as highlighted below in screenshot.
- Click on OK in the next window (first screenshot below) and on the next window select the option button "Yes, always; allow access even if QuickBooks is not running" and check the check box for "Allow this application to access personal data" and click on continue button (second screenshot below).
- In the Access Confirmation window click on the Done button. And the profile will get added to your QuickBooks Web Connector. A screenshot of the QuickBooks Web Connector is displayed
- Click on the Advanced Properties on the left column and select Log Level as ALL from the drop down. The below image illustrates the same.
![](/docs/download/attachments/819516/migration4.png?version=1&modificationDate=1312472995000&api=v2)
- For Validating the process click on the button Click to Validate Process. This process will check all the Adapter settings, mappings and states for the sync and present you with a report. In the report all the valid actions are marked with a green check icon as and all invalid actions are marked with red minus icon as . If all the actions are valid ( ) then click on continue button at the bottom.
Customer to Account Migration
- Select CustomerToAccount from the left column and enter in the details as required. Hovering your mouse cursor on the blue Question mark icon indicates how to fill-up the fields. Care should be taken to make sure that the data is entered in the prescribed format as it is case sensitive. A simple example is illustrated in the below screenhot
![](/docs/download/attachments/819516/G2.jpg?version=1&modificationDate=1275602648000&api=v2)
- There are generally four maps for each state as update and upsert as for example the CustomerToAccount has been shown. The maps are for updating the already existing Customer or for creating a new Customer.
Global Variables are used to assign the dates to query QuickBooks to pull accounting data. So for example, if you want to migrate data from 1/1/2009 to 1/1/2010, you will need to assign from to end dates accordingly.
Items to Product Migration
- Select ItemServiceToProduct from the left column and enter in the details in the same way as illustrated in the above Customer to Acocunt section. A screenshot for the same is shown below.
![](/docs/download/attachments/819516/migration5.png?version=1&modificationDate=1312473972000&api=v2)
- Similar procedure can be followed to migrate Items belonging to Item types, Inventory,Non-Inventory,Discount,Other Charge and Sales Tax.
Global Variables are used to assign the dates to query QuickBooks to pull accounting data. So for example, if you want to migrate data from 1/1/2009 to 1/1/2010, you will need to assign from to end dates accordingly.