Questions

0
votes
6
answers
27 views

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 Jens Leweling Jens Leweling 07 May 2019.

Latest by Jens Leweling Jens Leweling 19 May 2019.

0
votes
1
answers
16 views

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 Vlad Shmulskyi Vlad Shmulskyi 16 May 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 17 May 2019.

0
votes
2
answers
18 views

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 Laurent Michel Laurent Michel 14 May 2019.

Latest by Laurent Michel Laurent Michel 15 May 2019.

0
votes
3
answers
34 views

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 Irfan Ahmad Irfan Ahmad 10 May 2019.

Latest by Simon Bubnov Simon Bubnov 13 May 2019.

0
votes
7
answers
26 views

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 Devang MISTRY Devang MISTRY 06 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
1
answers
13 views

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 John Emrich John Emrich 08 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
1
answers
23 views

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 Darshan Bhattad Darshan Bhattad 09 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
1
answers
40 views

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 Laurent Michel Laurent Michel 09 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
11
answers
165 views

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 Ben Willis Ben Willis 15 June 2018.

Latest by Laurent Michel Laurent Michel 09 May 2019.

0
votes
7
answers
36 views

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 James Schlimmer James Schlimmer 04 May 2019.

Latest by Mariia Zaharova Mariia Zaharova 08 May 2019.

0
votes
1
answers
16 views

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 greg lurie greg lurie 02 May 2019.

Latest by Mariia Zaharova Mariia Zaharova 03 May 2019.

0
votes
1
answers
6 views

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 Praveen Ch Praveen Ch 26 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 26 April 2019.

0
votes
1
answers
12 views

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 Sven Licht Sven Licht 25 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 26 April 2019.

0
votes
6
answers
97 views

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 Vlad Shmulskyi Vlad Shmulskyi 16 April 2019.

Latest by Vlad Shmulskyi Vlad Shmulskyi 25 April 2019.

0
votes
1
answers
15 views

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 Jonah Purinton Jonah Purinton 24 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 24 April 2019.

0
votes
2
answers
16 views

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 Peter Gutmann Peter Gutmann 13 April 2019.

Latest by Peter Gutmann Peter Gutmann 22 April 2019.

0
votes
29
answers
347 views

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 Sachin Dabrein Sachin Dabrein 04 February 2019.

Latest by Sachin Dabrein Sachin Dabrein 22 April 2019.

0
votes
1
answers
26 views

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? ....

csv

Created by Phelps Jackson Phelps Jackson 17 April 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 18 April 2019.

0
votes
3
answers
23 views

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 David Weninger David Weninger 12 April 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 17 April 2019.

0
votes
1
answers
10 views

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 Gidi cab Gidi cab 11 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 12 April 2019.

Close