Tickets Tagged With:salesforce
Category: Questions
Convert DateTime to Date field in Salesforce
Hi, I have a few columns in my CSV import file that contain DateTime values in the format of DD/MM/YY HH:MM and I would like to convert them to a target date ....
Category: Questions
An item with the same key has already been added.
Hi Team, While migrating the opportunities from one Salesforce instance to another instance, I'm getting the "An item with the same key has already been added." error. I've reviewed the ....
Category: Questions
Salesforce Can Not Access A Closed System
I am receiving the “Can not access a closed system” for the “Attachment” object in Salesforce. ....
Category: Questions
Salesforce Upsert
Hi Team, I've created a package to upsert the data - Salesforce to Salesforce. However, when I try to select the external id, it isn't showing any fields. Could you ....
Category: Questions
Update Task
Hi Team, I hope you're doing good. I've created an Update task to create a record in it already exists in the system - Salesforce to Salesforce. I want it to update ....
Category: Questions
Not able to map DT_WSTR to DT_I4 using new skyvia expression int4()
Hi there, I am testing Skyvia's Synchornzation package and I have run into an error while mapping a non-pk id column from Salesforce to an empty table in a postgresql ....
Category: Questions
Salesforce Error record type missing
Hello Skyvia Support, I am getting an error "record type missing for: Student" when I am trying to upsert records in Salesforce object from Dropbox. Can you please look into ....
Category: Questions
INSERT Salesforce CreatedById/CreatedDate
I understand it is not possible to edit Salesforce audit fields, however, I cannot find a way to map these fields for INSERTS. Similar import tools can modify these fields ....
Category: Questions
How to export field mapping in import task
Hi Team, I'm trying to export the field mapping in the import task (account) so that we can review it with senior management. However, I couldn't find any option to ....
Category: Questions
Unable to match file name pattern
Hello, I have a scenario where I am exporting some records from Salesforce to a csv file in sftp server. I do use the data flow to generate the files ....
Category: Questions
Salesforce Record Id not being written back
Hi, I have a synchronization in place with Salesforce as Source and SQL Server as Target. When I add a row to a table in SQL Server a corresponding record ....
Category: Questions
Will Salesforce MFA requirement affect my SQL replication connection?
https://help.salesforce.com/s/articleView?id=000352937&type=1 Salesforce will require multi-factor authentication. How does this affect my Salesforce to SQL Server replication OAuth 2.0 connection. I use the web service not the installed agent. ....
Category: Questions
How we can run SOQL inner query in Skyvia?
Hi Team , I have below query to run SELECT Name,ccrz__SKU__c,ccrz__ShortDescRT__c,(select Id,ccrz__Price__c from ccrz__E_PriceListItems__r where ccrz__Pricelist__r.ccrz__PricelistId__c ='UP_Price_Main' LIMIT 1),(select ccrz__URI__c from ccrz__E_ProductMedias__r where ccrz__URI__c != null LIMIT 1) FROM ccrz__E_Product__c ....
Category: Bug Reports
Object reference not set to an instance of an object.
I have re-logged in, Cleared Meta data, and tried running the package several times with different filter. ....
Category: Questions
Multiple Contact records being generated
Hello, I am using advanced query to create a list of contacts that have been created in our Salesforce ORG. Please see the screen shot of the fields from Contact ....
Category: Bug Reports
Export from Salesforce to FTP changes date format
Hi, I made a connection between Salesforce and one sftp, and package runs smoothly to export a set of data. The issue is that the date format from the source ....
Category: Questions
Issue Migrating DT_NTEXT from Salesforce to Dynamics 365
Hi, Currently I'm trying to migrate the values from a DT_NTEXT field from Salesforce to Dyn365CRM, which destination field has the same format, but when the Skyvia update process is ....
Category: Questions
How to check Source Connection Unmapped Fields in Import Package
I have a data import package, where the source connection is Salesforce and the Target Connection is a MS SQL Server. When the package was deployed all the fields in ....
Category: Questions
Data Import File Mask Format
Is there a way to ignore characters in a file mask? We are receiving files with name "Accounts_2021_06_15_122503", but we need to ignore the hour, minute and second at the ....
Category: Questions
Unable to connect to SFMC FTP
Hi, We are trying to connect to Marketing Cloud (SFMC) via FTP option but unable to, receiving an error 'Timed out trying to read data from the socket stream!' Do ....