Tickets Tagged With:csv
Category: Questions
XML files from SFTP
Is there any way of viewing / importing XML files on an SFTP server? I'm attempting to integrate with an external company and they'll only output XML files to their ....
Category: Bug Reports
Error message import
Hi, For our last imports, we have this message : An exception has occurred during data processing, the message returned from the provider is: Insertion failed because the database is ....
Category: Questions
Zoho Multi Value Fields
I have an integration running to pull data from the contact module(zoho crm) to then place that data in a csv. That csv is stored in a s3 bucket. ....
Category: Feature Requests
Can FTP integrations only accept CSV format to send and receive
I'm trying to integrate salesforce to a FTP storage, but I can't send a CSV file because the company that uses this FTP storage has a specific format for their files. ....
Category: Bug Reports
Bug use external id
Hi, I duplicate a package and change ftp preprod to ftp prod / It's working well and i have my mapping with external id, https://app.skyvia.com/#/packages/75328 But i run the package ....
Category: Questions
The data was truncated ?
Hi, With import CSV to salesforce i have some error like The data was truncated. Column name: 'CDE.NOAFF'. The data was truncated. Column name: 'CONTACT.NOM'. But no details on the ....
Category: Questions
Active campaign customs fields
Hi, I want to connect ftp with csv and active campaign I see on your doc : "Skyvia does not support custom fields in the default ActiveCampaign connector. However, if you need ....
Category: Questions
Need Help File with 2 external ID
Hi, I have a problem to make an integration, i Have : - 1 flow for order / quotation : OK- 1 flow for biling : OK- 1 flow to ....
Category: Bug Reports
FTP locked for 1 file, don't understand
Hi, On a ftp we have 1 file locked and we cannot deposit a new file to upgrade the csv file, it's ok for mots of our flow but just ....
Category: Questions
CSV Export > Change Column Order
Hi, I have an export from Salesforce To CSV and i want to choose the order of the colums I try with order by but it's not working because not ....
Category: Questions
Import / Export contact with filters / Advice
Hi, i created ticket because i didn't receive answers from me email I need advice / validation for ou import / export betwin salesforce and CSV file form FTP ....
Category: Questions
I can't import product category using csv source of Magento 2.
"ErrorDescription";"Id";"Sku";"Categories" "The value for property 'Categories' of table 'Products' is not valid. The value must have a valid JSON array format.";"3";"dot001";"2,1274,2005,2006" ....
Category: Questions
Tab delimited CSV
I am trying to export to a CSV. It needs to be tab delimited. How do I change the delimiter to a tab? ....
Category: Questions
Import Expressions: If field = Yes, insert date
Trying to import a csv file where, if column 1 = Yes, I insert todays date into a SF date field. This isn't working: () == "Yes" ? (GETDATE) : ....
Category: Questions
SFTP to Salesforce Integration Failed
Hi, I set up an integration to upsert data from a CSV via SFTP to Salesforce contact fields, scheduled it to run daily. It worked fine for 4 days then ....
Category: Questions
System.LimitException: Apex CPU time limit exceeded
Hello, I test the import in Salesforce. I have the following error: System.LimitException: Apex CPU time limit exceeded this error is related to mass insertion of data in salesforce. ....
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: Bug Reports
Error loading CSV to Freshdesk.
Hello I was testing the tool with the domain vegalsaes.freshdesk , ”. I uploaded a CSV file gives us the following error in each row "The remote server ....
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 ....