Questions
Category: Questions
mask file
is it possible in a csv import package (S3 for postgresql), to use a mask to bring files from the previous 4 days? ....
Created by
Category: Questions
Salesforce 'Owner ID: id value of incorrect type' error
Hi Skyvia Support, I'm trying to import a .csv file into the Salesforce Leads table. But no matter what value I use for record Owner ID, which I'm assuming ....
Created by
Latest by
Category: Questions
Admin User Account
Hello, I at least our Account id is 67056. Or rather when I go to our Account page the url is: https://app.skyvia.com/#/accounts/67056/subscriptions I am a user on this Account but not ....
Created by
Latest by
Category: Questions
Columns were automatically marked by Skyvia
In the replication of data from CRM Dynamics to our PostgreSQL database, I have been observing that when new columns are created in the tables of the source system, ....
Created by
Latest by
Category: Questions
Get custom field values from Asana tasks
I'm new to Skyvia but the company I work for is interested in using your service to automate reports. I'm currently trying to import Asana tasks into a BigQuery table for analysis. ....
Created by
Latest by
Category: Questions
Why it is showing invalid column mapping
I am not sure why the mapping is giving the error "Task has some invalid columns mappings".Can you please help, please check below screenshot ....
Created by
Steve Graham
06 April 2021.
Latest by
Category: Questions
FTP: Rename and map fields
Hi, I need to export SObjects from Salesforce to a specific csv format on an ftp server.The Problem I am facing, is that I need to rename fields, order them and additionally ....
Created by
Latest by
Category: Questions
lastsynctime - accidently reset
Hi - I've accidently reset the the lastsynctime to empty for both my replication jobs; I'd like to set this date to 23rd March but it doesn't let me. ....
Created by
Latest by
Category: Questions
Where are the fields?
We have been working in Tasks to try and find where the fields arer for columns. Cannot seem to be able to display the fields within any of the tables. ....
Created by
Steve Graham
05 April 2021.
Latest by
Category: Questions
Replace an old CSV by a new one !
Hi, I've built a package wich exports data from "Zoho Invoice" to my "Google Drive" on a daily basis. My main goal is to receive the latest data about ....
Created by
Latest by
Category: Questions
SQL SERVER on amazon RDS conexion
Hello, I try to connect my sql server database hosted on amazon rds but I have this error message : A network-related or instance-specific error occurred while establishing a ....
Created by
Latest by
Category: Questions
Table join question
We are looking to connect Pipedrive with Activecampaign. In Pipedrive there is a table join between the Organization and the Contact and we are trying to understand if we can ....
Created by
Steve Graham
01 April 2021.
Latest by
Steve Graham
06 April 2021.
Category: Questions
FTP Connection
Hello, I have created a Connection to an FTP (Magento 2 FTP). A can successfully test the Connection, however when I try to create a new Import and I add ....
Created by
Latest by
David Don
Category: Questions
Integration between Amazon RDS and Salesforce does not work.
I'm trying to handle data from Amazon RDS (PostgreSQL) as an external object in Salesforce. I have registered Skyvia's IP in the RDS security group, and I can see the ....
Created by
Latest by
Category: Questions
Can't find custom dimension on Google Analytics CompleteAnalytics table
I cant find my custom dimension (ga: dimension1) on the columns of CompleteAnalytics table. I can succesfully query it on GA query explorer. Where can I find it? ....
Created by
Latest by
Category: Questions
Interrent CSV Customization
Hello, I have several requests for my client to customize the CSVs output by SkyVia. I need the query replaced on three files in two similar packages with the following SQL. The packages ....
Created by
Latest by
Category: Questions
SQL Transport Layer Error
Hello Support Team!I'm having an issue with Skyvia importing data into SQL and the issue seems to be inconsisntently happening. Today most of the automatic (Scheduled) package runs were successful ....
Created by
Latest by
Category: Questions
"Update" function is not working in Import Package
Oracle to Big Query connection - thru agent (Oracle) Error message: Action 'UpdateKeysRequiredAction' is not supported. Not being able to use the UPDATE function - tried several ways but cannot find ....
Created by
Latest by
Category: Questions
Export a file with a custom name and a date attached
Hi, I'm trying to export a file through a package using salesforce as the connection and an ftp site as the destination. I'm trying to do this with a ....
Created by
Latest by
