Agent not connecting
We started getting errors that Skyvia can't connect to on premise agent we use to connect to MS-SQL. We checked the agent and see this error: What can we check on the agent? thank you chad
How to use REST Connector?
I'm trying to use the REST Connector, and I'm having some trouble. There are no examples in the Gallery and it's the only connector that doesn't have a page in the docs: https://docs.skyvia.com/connectors/ I have a URL that I would like to POST data to,
Is there a way to move or clone an object from one Workspace to another?
We have a production and a sandbox workspace. I would like to be able to copy an object from one to the other. Is this possible?
Simply connect to any source
Discussion forums for open issues and questions regarding Skyvia Connectors
How do I populate a custom field with a column from a database?
I have connections to Jira and the database but can't seem to find the documentation on how to do this. Any help is much appreciated!
Integration failed: Invalid number of output records.
When attempting to replicate from saleforce we receive the following error message after it "runs". For context, everything was functioning fine before yesterday. Integration failed: Invalid number of output records. Appreciate it.
Can't sign in with Salesforce
My main account uses Salesforce to sign in however, every time I try I keep receiving an error like this one: Authorization Error - Skyvia User with same name exist Request Id: 462455d9-3d3d-40c9-bb79-707040a8e00a I also tried signing in on a different
SFTP file masking capabilities
I recently had the requirement of processing a csv file from an SFTP source with Skyvia and when I attempted to grab the file using a file mask, I was unable to create a mask that could grab the file by date and ignore the irrelevant part of the filename.
Skyvia integrations + terraform
Is there a way to terraform the integrations in the skyvia?
Queue Times Inceasing?
I've noticed job time in queue increasingly lately. Is this something the Skyvia team is aware of? Has anything changed in capacity or prioritization?
Moving an Integration to a different workspace
We are trying to organize our integrations. How do we move existing Integrations to a new Workspace?
Any issues with the Pipedrive Conection?
I recently encountered a boolean error detected by Skyvia. Has anyone else experienced the same issue? Regards
Package Controls
Hello, I need to know if skyvia has package reprocessing controls and execution controls to have notifications in case of error in the execution of the packages.
Queue
Hello everyone, What should I know about the queue? and what dictates how long it will be? Does the amount of data change the duration of the queue? Thank you, I am exited to be joining this community. Noah
FTP connection with DearSystems
I want to connect my FTP to DearSystems for Stock Adjustment. I have a simple CSV that contains SKU and Quantity. I need help with field mapping. Also which subscription plan is suitable for this FTP Integration?
Options for error notifications when scheduled packages execute other packages?
Hi - I was wondering if you have any suggestions for generating failed package notifications when the packages are executed inside a Control Flow, and it is the Control Flow that is scheduled. For an example see package ID 216134. This scheduled Control
File Mask for Yesterday, not today
Can I use the file mask to import a CSV that was produced yesterday? The data source I'm using (Toast POS) exports CSV files at 4am for the day prior in a folder structure like this: RestaurantID / yyyyDDmm / TimeEntries.csv So if I run this task at 4:30am
Technical feasibility of bi-directional sync JIRA(JSM and JWM) <-> ASANA
The goal of this question is: To validate whether this is possible with Skyvia If it is possible, has anyone here tried to do something like this or do you have any recommendations to point me in the right direction in terms o the approach? Im new to
Expression to replace Multi Picklist fields in Salesforce
Hi, We were wondering if anyone else has implemented this before. We have a Multipicklist field in Salesforce that needs to be mapped to multiple checkboxes in Salesforce, Question 1: Is this the correct way of populating the checkboxes if one of the
Importing to existing contact records in Salesforce NPSP
Hello, I'm attempting to import opportunities into existing contact records in Salesforce NPSP. I know the contacts have existing account but my lookup is not finding the records. I am currently using a Target lookup that searches the First Name, Last
Airtable Repliaction Set Up Error: Cannot access child value on Newtonsoft.Json.Linq.JValue
Hi there, I am trying to create a replication using an Airtable connector as my source, but am getting the below error when trying to add the Airtable connector: Cannot access child value on Newtonsoft.Json.Linq.JValue https://gyazo.com/40b64b7b4ab0cb6ca96571499d5df398
Convert a String to Date using Expression builder
Hello, Is there a way for us to convert a text string which is dd/mm/yyyy into a date value for importing? Thanks
Data Flow schedule does not work
The Data Flow schedule of the type to run every 2 hours between 2 hours does not work. I had set the data flow below to run between 10PM and 2AM every 2 hours... but it didn't start. Now I changed it to between 8PM and 4AM to see if it runs. https:/
Data flow stfp connection fails while normal import works
I've run into a situation where I would prefer to use dataflow but for some reason when I try to run the sftp file through data flows I get the error, 'an established connection was aborted by the server'. I know that the connection is working, however
Can I create a custom inbound webhook to receive POST data?
We use this platform for client survey data: https://formcrafts.com There's no integration available in Skyvia but Formcrafts over the ability to pipe survey responses into an external API using a webook connection. How to Configure Webhooks (formcrafts.com)
Data not inserting at bulk to the target Table.
I've been trying to insert all the data in a table from MySQL to Salesforce. But, it inserts the last row only. ''' SELECT * FROM countries where id > :MaxId ''' This is the query running from the source table
Amplitude query running for long periods of time with no output
Hi, I have written a query to pull data from Amplitude, but the task runs for a long time and produces no output - here is the url of the export task: https://app.skyvia.com/#/151008/packages/228237 Does the query in the task look okay in your opinion?
Updating data into Hubspot
Trying to update data into Hubspot from SQL Server (so I want to take the data in Hubspot and update it from what I have in SQL Server), but I'm not sure which integration to use. Which integration would update the existing files with new data without
error connecting to datasource using odbc
hi, I'm trying to connect looker datastudio to a database called ocient using the ODBC driver but I'm getting this error, any idea what this meant? An invalid connection string attribute was specified (failed to decrypt cipher text)
Data flow "Integration failed: Disposable provider cannot be reused."
My last 3 runs of a simple import integration have all failed with the message "Integration failed: Disposable provider cannot be reused.". The data integration is valid and I have tested the connection to my source and target. We have not exceeded our
Wordpress backup integration. Not a real backup
Hello, Our Wordpress backup should come out to a compressed size of around 1.6Gigabytes. Once I managed to get the Wordpress Connection working and then configured a Skyvia backup process against this, the resutled data comes out to 3.2Megabytes. So either
i want to have imported data direct references
Good Afternoon, I want to be able to import data from NetSuite into my Jira Service Management environment and make said imported data referenceable via a custom field within JSM for the end user. If i could get some assistance with accomplishing this
Lookup
Hi, We have a integration , wherein we are doing lookup on target which has 717188 rows. The data flow goes in hung state for hours and we cancel it after few hours. Is there any other alternative?Run id 155117268.
Append timestamp not working as expected
I have created an export integration and checked the "Append timestamp" checkbox. The resulting file does not have either a date or timestamp added. Here is the integration package I am using https://app.skyvia.com/#/138012/packages/232230 Here is a screenshot
Handling of Null or blanks during import
It appears that Skyvia is replacing content when a null or blank field is imported. Is there a setting that will allow us to ignore null values during imports, leaving any existing values in the destination unchanged?
Skyvia to Hubspot - Inserting Contacts and associating them to an existing related Company
Hello team! We're trying to add contacts to an existing company via Skyvia via Hubspot's Compan We see the existing option to import to Company and associate contacts - but we want to do it the other way - associate new contacts to an existing company
Issues Importing Related Objects
I am attempting to load data from SQL Server to Salesforce. The SQL Server Data relates to 3 salesforce objects which is have a relationship to each other. The 3 tables are Timeentries (this is the parent table and links to the other 2 through the common
Partial Shipment
Hello, We need assistance in partial shipment. Will you be available to connect with us.
Skyvia Agent for QuickBooks Desktop Connector
We have QuickBooks Desktop installed on a hosted server accessible with Remote Desktop. We want to use Skyvia to connect QuickBooks with Google BigQuery. We installed the Skyvia Agent on the server, but it only connects to the Skyvia Dashboard when someone
Concatenate Expression Help Needed
We have an sync integration between Salesforce and Netsuite and need to combine a number of 2 fields and 3 items of text to place a script in a Netsuite field on the invoice. "Sample Text 1" [inserted field 1] "Sample Text 2" [inserted field 2] "Sample
Next Page