Questions

0
votes
3
answers
55 views

Category: Questions

How is timezone for date/time handled when importing into Salesforce

When importing data into salesforce I'm seeing the datetime data appears to be handled as if it was GMT.  In the scenario where I saw it this is the setup. ....

Created by Brian Nolan Brian Nolan 11 May 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 14 May 2020.

0
votes
3
answers
29 views

Category: Questions

Cancel

Please cancel my test subscription. We keep trying this services ever few months and still find it lacking.  For example,  running  "Select * from productvariants where sku = 'TESTSKU'  This ....

Created by Rod Rod 11 May 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 13 May 2020.

0
votes
5
answers
38 views

Category: Questions

How to map update import with external ID but no name

Hi,   I am trying to update our Salesforce accounts with some data directly from a MySQL database table. The NAME field is required for an update function, but our MySQL ....

Created by Michael Bell Michael Bell 27 April 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 13 May 2020.

0
votes
2
answers
25 views

Category: Questions

Cannot get started

I want to used Skyvia Querey to add Jira data to Google Sheets. I created a Skyvia account and installed the add-on from Google Store but now I'm stuck. If I go ....

Created by Steve Rohde Steve Rohde 07 May 2020.

Latest by Steve Rohde Steve Rohde 08 May 2020.

0
votes
1
answers
19 views

Category: Questions

Zoho CRM synchronization

Hello, My Zoho account is located in an Australian DC. So when I try to connect my Zoho account to skyvia an "Invalid client" error is returned. For this to ....

Created by Michael thiriet Michael thiriet 29 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 29 April 2020.

0
votes
1
answers
41 views

Category: Questions

No expression editor and how to add todays date in an integration

Hi, it says in the documentation that when creating an integration I can use expression, and then click to get up an expression editor. That does not work as I ....

Created by Peter Alvestal Peter Alvestal 23 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 24 April 2020.

0
votes
6
answers
40 views

Category: Questions

Replicating from Salesforce to MS Azure MS SQL Database

I am trying to replicate Salesforce data to a Microsoft Azure SQL Database. I have set up connection and target correctly as both when tested connection succeeds. However when I ....

Created by Charles Cabato Charles Cabato 15 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 22 April 2020.

0
votes
1
answers
18 views

Category: Questions

SalesForce Query

Hi,   I'm getting "You have reached a limit of queries." after I ran around 5 queries, can you please advice on what would be the issue?  Regards, Sameh ....

Created by Sameh ELSOKKARY Sameh ELSOKKARY 18 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 21 April 2020.

0
votes
1
answers
21 views

Category: Questions

Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ?

Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ? ....

Created by Sanjeeva Gajula Sanjeeva Gajula 17 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 17 April 2020.

0
votes
1
answers
13 views

Category: Questions

Backup Files not creating -

Hi,   Our invoice has suddenly stopped working since your upgrade.  We have also stopped getting our data exported every night.  I left a message few days ago in your ....

Created by Vinny Vinny 17 April 2020.

Latest by Mariia Riabushenko Mariia Riabushenko 17 April 2020.

0
votes
2
answers
29 views

Category: Questions

Update Target Values ONLY if Blank

Hi, In an update mapping, is it possible to specify to update the target value with the source value ONLY if the target value is blank? I don't want to ....

Created by Jennifer Good Jennifer Good 14 April 2020.

Latest by Jennifer Good Jennifer Good 16 April 2020.

0
votes
3
answers
293 views

Category: Questions

HubSpot Contacts to Microsoft Dynamics Leads Synchronization

I was able to successfully sync HubSpot contacts to Dynamics 365 contacts, but when I attempt the same synch with HubSpot contacts to Dynamics LEADS, I am returning an error ....

Created by Scott Harris Scott Harris 13 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 16 April 2020.

0
votes
1
answers
16 views

Category: Questions

multiple users refreshing Google Sheets

We have a few users who all share a Google Sheet. I've just built some queries in Skyvia to pull in data from a PgAdmin database and am able to ....

Created by Dana Meroniuk Dana Meroniuk 15 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 15 April 2020.

0
votes
1
answers
11 views

Category: Questions

Scheduling

Hi,  I am creating a schedule where a) Occurs once a day at 80 AM (central time). b) Starting on 10th April 2020 at 80AM.  the scheduler did not run. ....

Created by Alex Ramos Alex Ramos 10 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 13 April 2020.

0
votes
1
answers
12 views

Category: Questions

Do you have a real time event

Hello Dear Skavia Support, My name is Iryna. We want to suggest to our client to use Skyvia. But we have one question. Do you have a real time event ....

Created by Priya Jethwa Priya Jethwa 09 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 09 April 2020.

0
votes
1
answers
12 views

Category: Questions

unable to connect to the zoho people

unable to connect to the zoho people ....

Created by ECS Financials ECS Financials 06 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 07 April 2020.

0
votes
2
answers
58 views

Category: Questions

Need to concatanate data types "DT_WSTR" and "DT_NTEXT"

Trying to concatanate "DT_WSTR" and "DT_NTEXT" in to a single DT_NTEXT field via an expression. but get the following error. The data types "DT_WSTR" and "DT_NTEXT" are incompatible for binary operator "+". ....

Created by Brian Price Brian Price 30 March 2020.

Latest by Brian Price Brian Price 06 April 2020.

0
votes
1
answers
17 views

Category: Questions

Combine two csv fields into one mysql field

Hey, So i am importing 4 CSV spreadsheets with sales that we recieve from suppliers every few weeks. Was wondering if its possible to combine two fields from the CSV ....

Created by Lachlan Young Lachlan Young 06 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 06 April 2020.

0
votes
3
answers
55 views

Category: Questions

Import job with sql server as source, to get incremental (delta) data changes using LAST_RUN

After initial data sync with SQL Server as source, we are trying to use an import job to pick up delta (new/changed) data. We are comparing the dateUpdated column (datetime datatype ....

Created by robert fisher robert fisher 19 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 April 2020.

Close