Questions

0
votes
0
answers
13 views

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 Gabriel Longarai Gabriel Longarai 12 April 2021.

0
votes
1
answers
379 views

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 Rick Krause Rick Krause 06 April 2021.

Latest by Nataliia Nikulina Nataliia Nikulina 09 April 2021.

0
votes
2
answers
48 views

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 Shad Mickelberry Shad Mickelberry 06 April 2021.

Latest by Shad Mickelberry Shad Mickelberry 08 April 2021.

0
votes
1
answers
40 views

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 Gabriel Longarai Gabriel Longarai 07 April 2021.

Latest by Olena Romanchuk Olena Romanchuk 08 April 2021.

0
votes
1
answers
66 views

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 David Cook David Cook 05 April 2021.

Latest by Olena Romanchuk Olena Romanchuk 08 April 2021.

0
votes
1
answers
169 views

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 Steve Graham 06 April 2021.

Latest by Nataliia Nikulina Nataliia Nikulina 07 April 2021.

0
votes
2
answers
81 views

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 Lukas Reindl Lukas Reindl 06 April 2021.

Latest by Lukas Reindl Lukas Reindl 07 April 2021.

0
votes
11
answers
113 views

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 Dougal Guppy Dougal Guppy 23 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 07 April 2021.

0
votes
4
answers
68 views

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 Steve Graham 05 April 2021.

Latest by Olena Romanchuk Olena Romanchuk 07 April 2021.

0
votes
2
answers
52 views

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 Client ABYZ Client ABYZ 02 April 2021.

Latest by Client ABYZ Client ABYZ 06 April 2021.

0
votes
5
answers
71 views

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 Luc Mornat Luc Mornat 22 March 2021.

Latest by Ernesto Ibañez Ernesto Ibañez 06 April 2021.

0
votes
3
answers
47 views

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 Steve Graham 01 April 2021.

Latest by Steve Graham Steve Graham 06 April 2021.

0
votes
1
answers
44 views

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

ftp

Created by Richard Clark Richard Clark 02 April 2021.

Latest by Dmitriy Muzurov Dmitriy Muzurov 05 April 2021.

0
votes
2
answers
27 views

Category: Questions

JIRA

While the package supports replication for JIRA issuelinktypes, I don't see a issuelink table? ....

Created by David Don David Don 02 April 2021.

Latest by David Don David Don 05 April 2021.

0
votes
1
answers
46 views

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 mi ma mi ma 30 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 02 April 2021.

0
votes
2
answers
38 views

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 Tomas Chejanovich Tomas Chejanovich 30 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 02 April 2021.

0
votes
7
answers
80 views

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 Andrew Ditty Andrew Ditty 30 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 01 April 2021.

0
votes
3
answers
66 views

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 Technology Specialist Technology Specialist 19 March 2021.

Latest by Dmitriy Muzurov Dmitriy Muzurov 28 March 2021.

0
votes
3
answers
57 views

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 Fabio Pitorri Fabio Pitorri 21 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 26 March 2021.

0
votes
1
answers
27 views

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 Murray Costello Murray Costello 24 March 2021.

Latest by Sabina Bashuk Sabina Bashuk 26 March 2021.

Close