Questions
Category: Questions
Substring
I'm connecting to Magento and the BilingStreet returns values in the following format: -- I would like to use a substring expression to remove the . How would I use ....
Created by
Latest by
Category: Questions
Determining identical records during initial sync
I want to setup bi-directional integration between SalesForce and MS SQL Server. The amount of data is very large so we would like to import data beforehand from Source to ....
Created by
Latest by
Category: Questions
Use external correspondance table
Hi, I have a question regarding the possibility to use external correspondance table, We have flow on ftp in CSV from ERP to Salesforce, In this flow we have a ....
Created by
Latest by
Category: Questions
Your merge fields were invalid. Errors: Please enter a value(Field: 'FNAME')
hi, i am trying to export my customers CSV file via FTP but its giving me this error Your merge fields were invalid. Errors: Please enter a value(Field: 'FNAME'). Thanks i ....
Created by
Latest by
Category: Questions
Import from Sugar to Salesforce
Hi, I am trying to migrate couple of accounts from SugarCRM to Salesforce as testing. For some reason its failing, please see below. I have a conditional filter added ....
Created by
Latest by
Category: Questions
Assistance with Zoho to Hubspot Migration
Hi, I've connected my Zoho and Hubspot api's. I'm now trying to set up the connections but they seem a bit confusing. Do you have a template or suggestions for ....
Created by
Latest by
Category: Questions
Unable to connect to SQL Server
Hi All, We are trying to connect to our local database (SQL Server) but even after setting the TCP/IP and Firewall as given in documentation it is not working. Please ....
Created by
Latest by
Category: Questions
Import / Export contact with filters / Advice
Hi, i created ticket because i didn't receive answers from me email I need advice / validation for ou import / export betwin salesforce and CSV file form FTP ....
Created by
Latest by
Category: Questions
IF Statements in Expression
Is it possible to use if statements in an Expression Mapping when doing a data import. For example: IF(Field1 = "X","AB",IF(Field2 ="Y","ABC",IF(Field3 = "Z","ABCD",A))) ....
Created by
Latest by
Category: Questions
Help With REST API Connection to QuickBooks Online
In Skyvia I'm setting up a new REST connection, choosing this as the URL: https://sandbox-quickbooks.api.intuit.com Here's the getting started for QBO for REST: https://developer.intuit.com/app/developer/qbo/docs/get-started Authentication, I'm choosing OAuth2 What do I ....
Created by
Latest by
Category: Questions
I can't import product category using csv source of Magento 2.
"ErrorDescription";"Id";"Sku";"Categories" "The value for property 'Categories' of table 'Products' is not valid. The value must have a valid JSON array format.";"3";"dot001";"2,1274,2005,2006" ....
Created by
Latest by
Category: Questions
Integration between Jira Service desk and Issue tracking tools and CRM tools
Hi this is Praveen, I like to Integrate my Jira Service desk and my partner Zen-desk, Bugzilla, Service now, etc., (Issue tracking tools and CRM Tools). where the tickets and metrics ....
Created by
Latest by
Category: Questions
Import CSV descriptions/template
Does anyone have a list of Skyvia's column/target descriptions.. I keep getting error messages but am not given (nor can I find) information on how to rectify the errors. I ....
Created by
Latest by
Category: Questions
Rest Connector Metadata Issue
Hi, I'm working on integration between SalesForce and Cloud App via REST connector. When I performed initial sync it was successful, according to history state column. Then I performed the Update operation on ....
Created by
Latest by
Category: Questions
Can I access my Skyvia Target Demo DB from Desktop SQL Client?
If so, is there documentation on how to connect? Thanks! ....
Created by
Latest by
Category: Questions
separate "last, first" values from csv
I'm trying to upsert a csv of Contacts from Cvent into Salesforce. The Contact names in the csv are formatted "last, first", and I need to separate them so they ....
Created by
Latest by
Category: Questions
Date fields query as '1-1-0001' even though data in source environment (ZOHO) displaying correctly
Hello, We are trying to integrate data from Zoho to an Azure Database. Several records keep failing due to the error 'SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and ....
Created by
Latest by
Category: Questions
Tab delimited CSV
I am trying to export to a CSV. It needs to be tab delimited. How do I change the delimiter to a tab? ....
Created by
Latest by
Category: Questions
Assembly Items not syncing
I am setting up a sync between NetSuite and MS SQL. We have several hundred assembly items in NetSuite. When I run the sync, only 19 are loaded in SQL. ....
Created by
Latest by
Category: Questions
Record Sync
this is what i get when I try to sync data from sql server to crm N:B i have granted create trigger permissions, please what do you advise ....
Created by
Latest by
