Questions
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
Category: Questions
What about date format to upload records to salesforce from CSV.
p ....
Created by
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
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
Latest by
Category: Questions
unable to connect to the zoho people
unable to connect to the zoho people ....
Created by
Latest by
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
Latest by
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
Latest by
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
Latest by
