[susmith.v_91]

7 years, 11 months ago in reply to: Formatting Billing address from a text field in Salesforce #5638

Quickbooks Maintains the address fields different from Salesforce.

In order to Split the address from Salesforce Text area field based on the new line character, we have to make use of Java script.

In DBSync, you can either write the Java script in the mappings or make use of Functions where you can develop or write user defined functions.

I am providing an example of a Java script that can be written in the maps.

In Order to get the first line, You can implement the below script

{return VALUE(““).split(“n”)[0];}

This will split the text area data and return only the first line.

For the second line, use the below script

{String ST = VALUE(““);int L1E = ST.indexOf(“n”);int L2E = ((L1E>-1)?(ST.indexOf(“n”,L1E+1))-1));int SL = ST.length(); if (SL>L1E & L2E>L1E) { String L2x = ST.substring(L1E+1,L2E); String L2 = L2x.substring(0,((L2x.length()>41)?(41):(L2x.length()))); return L2; }else if (SL>L1E & L1E>-1) { String L2x = ST.substring(L1E+1,SL); String L2 = L2x.substring(0,((L2x.length()>41)?(41):(L2x.length()))); return L2; }else { String L2 = “”; return L2; }}

And for the third line, use the below script

{String ST = VALUE(““);int L1E = ST.indexOf(“n”);int L2E = ((L1E>-1)?(ST.indexOf(“n”,L1E+1))-1));int L3E = ((L2E>-1)?(ST.indexOf(“n”,L2E+1))-1));int SL = ST.length(); if (SL>L2E & L3E>L2E) { String L3x = ST.substring(L2E+1,L3E); String L3 = L3x.substring(0,((L3x.length()>41)?(41):(L3x.length()))); return L3; }else if (SL>L2E & L2E>-1) { String L3x = ST.substring(L2E+1,SL); String L3 = L3x.substring(0,((L3x.length()>41)?(41):(L3x.length()))); return L3; }else { String L3 = “”; return L3; }}

[susmith.v_91]

8 years, 5 months ago in reply to: Software updates for dbsync #5632

Software updates for the On Demand users will be done automatically in the background during the weekends when the usage is less so that the integration is least affected. Nothing has to be done from Client side.

For those who are using on Premise version, Whenever there is a software update, client will be notified by our Support engineers and will be given instructions on the next steps. If required, Engineers will schedule a meeting and will go over the steps and help you out with the update to make the transition smooth.

[susmith.v_91]

8 years, 9 months ago in reply to: SQL server database with windows authentication #5584

Yes it is Possible. While Configuring the Database adapter in DBSync the URL should be provided as
‘jdbc:sqlserver://[hostname]:[port];databaseName=[databasename];integratedSecurity=true’
Instead of:

‘jdbc:sqlserver://[hostname]:[port];databaseName=[databasename]’

[susmith.v_91]

8 years, 9 months ago in reply to: Product not synced #5583

When syncing a product with colon to QuickBooks as an Item, the QuickBooks consider that the product has a parent child hierarchy since “:” is used to separate parent with child. So it is preferred not to use colon while creating products in Salesforce.

[susmith.v_91]

8 years, 9 months ago in reply to: Missing Opportunity ID in QuickBooks #5582

This error occurs when the transaction that you wish to modify in QuickBooks is already in use by another user or the QuickBooks database has temporarily locked the transaction for editing or update. Requesting that the user completes there editing and closes that process normally enable the transaction to be modified on a subsequent import. If you encounter these errors regularly then by switching the company file to single user mode and closing QuickBooks windows should minimize the occurrences.

[susmith.v_91]

8 years, 9 months ago in reply to: Deletion of QuickBooks ID In Salesforce #5576

In case if the QuickBooks Id is deleted in Salesforce, we have to run an update call from QuickBooks which will compare the Accounts with customers from QuickBooks based on the name and then update the Id when there is a match. Kindly contact us on support@mydbsync.com and we will help you with this.

[susmith.v_91]

8 years, 9 months ago in reply to: Web connector configuration #5575

DBSync (Web connector) is required to be configured only on one system, preferably the one in which the Company file is located. Changes made on all the computers will be reflected on the main company file and the configured web connector will push all the newly created/updated records when the sync is executed.