Tickets Tagged With:import
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 ....
Category: Questions
Import Google sheet data to sql server
Is there anyway to create connection with Google sheet and import gsheet data into Sql Server ? Thank you ! ....
Category: Questions
HubSpot import Engagement (MEETING) Outcome parameter
Hello, Importing to HubSpot, of object Engagements and type MEETING. Everything is working as it should but can't find the correct mapping of column for "Outcome". CSV column: Outcome CSV column ....
Category: Feature Requests
Target Lookups to Allow Expressions
When running a data import it would be incredibly useful to enable the use of Expressions in the Lookup functionality. The explicit use case is when the data types do ....
Category: Bug Reports
Object reference not set to an instance of an object. - Import SQL to Salesforce
When importing from the SQL Server to Salesforce, the import package always fails with the error. Object reference not set to an instance of an object. ....
Category: Bug Reports
Import Package Error
I am performing an UPSERT import operation which pulls a CSV fle from S3 and imports it it into the lead table in Marketo. It works great except there are ....
Category: Questions
Initial mapping error from a mysql db
I am trying to do the intial mapping of my products table to bigcommerce and keep getting "task has some invalid columns mappings." please help I have tried all different ....
Category: Bug Reports
Import Taking to long
I have an Import process that is taking to long to complete. The process keeps running and does not give any error. There are only 591 records. My replication process ....
Category: Bug Reports
Server returned an error: (400) Bad Request on upsert operation (Amazon S3 and Salesforce)
Hello! My Import operation seemed to be working up until a certain point when it suddenly cut out stating the following: An exception has occurred during upsert operation, the message returned ....
Category: Questions
Help needed Writing an Expression
Hey Skyvia! I'm currently performing a data import to zoho. The conncetions are set and established and I have data importing. I want to add in an expression to ....
Category: Questions
Bulk importing tickets from MySQL to Zendesk
1. Is it possible to use the Zendesk create_many endpoint in order to do a bulk ticket import? I am setting up the appropriate mapping for tickets I have strored ....
Category: Questions
How to have the import match on Person Account unless a Contact exists under a normal Account
I am creating a Shopify à Salesforce import package that we would like to schedule on a regular basis. We are mapping Orders à Donations, and Customers à Accounts (in our setup ....
Category: Questions
File Masking
I receive a csv every day at 1:45am EST into an S3 bucket. I am trying to set up a schedule for that to run daily. I have the S3 ....
Category: Questions
Problems importing to Postgresql using auto-generated id
Hi, I would like to import new rows into a Postgresql table where the primary key uses uuid_generate_v4() to generate unique Id's. The problem is that Skyvia requires me to map ....
Category: Questions
Retrieving csv from api or url that requires authentication.
Please is there, a method of using skyvia to import .csv files from an API or URL that requires authentication. ....
Category: Feature Requests
Integrations CSV Import - ability to move or remove files after success
After a successful import of the files it would be good to have the ability to move the files to another folder or remove the files entirely. Otherwise a seperate ....
Category: Questions
Integrations CSV Import - need filename wildcard
In integrations I am trying to import a CSV file from a SFTP server. The source files are created with the following format: GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMddhhmmss}.csv and placed there for us to ....
Category: Questions
Managing Upsert Record Usage
Hello, I am trying to import records from an sql server database to salesforce using skyvia. I wanted to use the upsert feature so that I did not have duplicate ....
Category: Questions
Can you use upsert to insert only new records?
I am using the free plan and was wondering, if I wanted to schedule imports to salesforce from a databse using upsert, only the records that were inserted/updated would count ....
Category: Feature Requests
Zoho Layouts - Skyvia cannot find other layout fields
In Zoho, a module such as an Account or Potential can have different Layouts. See screenshot below - when creating a new Potential, I can create a Standard one or ....