Questions tagged [data-import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
6
votes
2answers
877 views

SFDX force:data:tree:import MALFORMED_ID

I am creating scripts to export and import test data for our sfdx scratch orgs. I've used the sfdx force:data:tree:export command with -p to generate my plan file, plus three object files (one parent (...
5
votes
2answers
234 views

Bulk data load make the global search unusable

We are migrating data from saleforce org A to org B. While migrating we are processing data out of salesforce and its out of scope of this question. When we load data into target org it breaks the ...
3
votes
0answers
60 views

Lumen Salesforce Application

Can anyone briefly explain these Lumen Salesforce Application/Lumen Software concepts? Objective Data Model Editions Is there a free trial version of Lumen Salesforce Application/Lumen Software ...
3
votes
2answers
5k views

How do I make the checkbox checked when loading data from .csv file [closed]

I am trying to populate a check box in a custom object with "checked" (True/1) using Apex Data Loader v 32.0.0 in command line mode. I have tried all values documented => True, TRUE, YES, Y & 1 ...
2
votes
1answer
971 views

DE Special Character when importing from a CSV

I've been importing data from CSV - excel pages register as DOC CSV in the rolling menu. Except it doesn't take into accoung my special character (much needed in french words). I tried changing them ...
2
votes
1answer
102 views

Why is the LastName field required for the contact? What is the best approach to import contacts that only have the first name?

The reason for this question is that I have a spreadsheet with lots of contacts to import, but some of them only have the first name. The LastName, being mandatory, will make my job harder. I have ...
2
votes
2answers
2k views

Automation studio SFTP file drop trigger to Import Activity

Background: We have a simple automation studio workflow defined that would trigger when file with a certain name pattern is dropped and that then initiates the import activity (which also relies on a ...
2
votes
1answer
61 views

How to reinstall a managed beta package without losing custom objects data?

I created a managed package that, among other things, defines a custom object. I installed this package on my client's Sandbox and created several instances of this custom object. Now I've created a ...
2
votes
1answer
145 views

Export and Import of Salesforce Files and Notes from one production org to another production org

I have completed a data export of an org we acquired through the following steps: In Setup, navigate to Data Management | Data Export Click on either Export Now or Schedule Export button, whichever ...
2
votes
2answers
1k views

Import Notes in an object

I would like to import Notes via INSERT in a particular object using Dataloader.io , have tried various times but not able to. Can anyone tell me the .csv file format which needs to be used while ...
2
votes
1answer
203 views

Test.loadData() is there a way to load sObects with lookups to itself?

We have some custom object that has lookups to itself. Those objects used for some configs and there are quite a lot of them. Would be nice to create and load them from static resource for tests as ...
2
votes
1answer
106 views

ValueOutofRange error

I am trying to upload some records in a DAta Extension and getting the ValueOutOfRange error. Apparently, all field data types and lengths are correct. Could you please advise the reason. Thanks!
1
vote
2answers
275 views

Salesforce relational data backup and reload after sandbox refresh

I have a specific situation. There is an important relational data set (data spanning across more than 5 tables) in full sandbox which I do not want it to be deleted when I do the sandbox refresh with ...
1
vote
1answer
3k views

Is it possible to preserve created date and last modified date on importing records

I need to import Accounts and Opportunities into my sfdc org and I want to enter the created date and last modified date which is given by users in the excel sheet. How can I achieve this, I was told ...
1
vote
1answer
559 views

How do I restrict access to the Data Import Wizard but still allow object edit/create in UI?

I like the new Data Import Wizard, as it is a great tool for power users, but is there any way to limit the use of this tool, aside from the object permissions. I need my users to have read/write ...
1
vote
1answer
35 views

Correctly read CSV text attachment into BLOB

I'm facing difficulties reading & parsing a CSV attachment that was sent to an email. When I debug the code, the debugger writes empty lines between each new row, which to me looks like some kind ...
1
vote
1answer
139 views

Generated ID for Update

We generate leads and event attendance data from our website, which is connected through REST API. We'd like to update the event attendance data through an Data import activity from an external FTP. ...
1
vote
1answer
200 views

Escape comma in Salesforce Data Import Wizard

I am trying to import a .csv file that contains commas in the data. I tried to import it using Data Import Wizard using a tab as a separator but the Data Import Wizard doesn't detect the sublime text ...
1
vote
1answer
548 views

NPSP Data Import Wizard Contacts mapping issue

I have trouble mapping over basic Account and Contact fields. I use the wizard to test a small batch of Account/Contacts but not all the fields are listed when I have to map over half the fields. Also,...
1
vote
0answers
56 views

Picklist Value during Data Import

i came across this section in the Salesforce Documentation: If you import a picklist value that doesn’t match an existing picklist value: For an unrestricted picklist, the Data Import Wizard uses ...
1
vote
0answers
24 views

Scheduled import of leads

I have a requirement whereby leads are imported, but due to a process, they can only handle 5 leads every 10 minutes (inserting a lead triggers an inbound call to an agent). I have come up with the ...
1
vote
1answer
52 views

force:data:tree:export / force:data:tree:import across __r relationships

I am still fairly new to SaleforceDX. I have been tasked with putting together a sample data plan matching a small portion of our production data, for our new Scratch-Orgs. With foreign-key type ...
1
vote
0answers
127 views

Validation errors while CSV upload

Our company has just started the salesforce and we had a demo tool access we are practicing in that demo account. While loading data we got the following error. The following import has completed ...
1
vote
1answer
39 views

Ignore blank field in Data Extension import file activity

I am using Automations and an Import File Activity to ingest events logs in a specific data extension. Salesforce is reading a log of successive events, so I am leaving blank field in my CSV log to ...
1
vote
2answers
133 views

Populating Big Objects from CSV

I need to create a client application where users can upload CSV files, which will then be used to populate Custom Big Objects. My problem is I'm not sure which API to use. The Salesforce ...
1
vote
0answers
29 views

Salesforce report (for leads) fields not syncing with marketing cloud

Have created a report for leads in sales cloud. It creates the report with 9 fields only whereas there are some 60 fields in the leads. If I import this report in marketing cloud, I am able to do so, ...
1
vote
0answers
28 views

Export data to Marketing Cloud

I have a SQL Server database with near real-time updated consumer data. Other than using an SFTP or Mulesoft, how can I export it to my contact list in Marketing Cloud? Using a connector, API, or ... ?...
1
vote
0answers
604 views

Data Extension Import CSV Error

I have been having issues lately getting a CSV File to import into a Data Extension. The initial error was that the Array Index was out of bounds - like the field counts were off. So, I created a ...
1
vote
0answers
74 views

Import Users in Salesforce Error when User licenses limit exceeded

With Talend Open Studio for Data Integration, the tSalesforceOutputBulkExec component is used to import users in Salesforce. I tested the import of 1000 new users whith only 30 user licences ...
1
vote
0answers
135 views

Error with new unified import wizard

I am getting the following error when I try to import new contacts (using the email field to match on). Your import failed: Import for object Account did not succeed. Error received - null I have ...
1
vote
0answers
104 views

How to import contacts and opportunity records using npsp data import wizard

I am trying to upload contact that has opportunity in salesforce using npsp data import wizard. but when I try to upload my data, it successfully uploaded but when I click the opportunity record , the ...
1
vote
2answers
884 views

How to assign leads to a campaign using der Data Import Wizard (for leads)

I want to import leads with a CSV-file and assign them to an existing campaign. The CSV contains a field 'campaign' with the name of the campaign. If you import the CSV with the Data Import Wizard ...
1
vote
0answers
423 views

Have CLI/batch dataloader process multiple files e.g. *.csv

Before I go down start creating something or going down another path / solution, I am hoping someone has a done this already and can share. I have my process-confg.xml file which references one CSV ...
0
votes
1answer
63 views

Notes. Mass Upload. Hitting some limit and getting “Note can't be saved”

I'm doing data migration and need to upload ~500k Notes. 192k Notes were uploaded and now I'm getting Note can't be saved error via API and Note contains characters that can't be saved when trying to ...
0
votes
1answer
46 views

Import Definition - File not found (automation studio)

I want to import a csv file by using the automation studio. the csv looks like that: WERBEKO-2019_10_15 Starting source: File drop (use filename Pattern "Begins with" - "WERBEKO-" Import Definition: ...
0
votes
2answers
41 views

How to clear the values in a number data type field while importing data?

I tried using apex data loader and Dataloader.io So i knew i need to enable Insert Null values option in apex data loader settings but it isn't working for the fields with Number data type. I am ...
0
votes
1answer
66 views

Import definition for mobile connect

I have created a data extension containing phone number, ID and locale of all the contacts. I then created an import definition and mentioned this data extension as source. Till here it's fine, ...
0
votes
1answer
22 views

Importing 40k PDF as attchments

I have 40k PDF's in windows shared drive. Each pdf should be attached to parent account. The name of each pdf is an external ID in salesforce. e.g AA123.pdf corresponds to AccountRecordId '...
0
votes
1answer
25 views

MobileConnect Contacts Import Doesn't update Contacts' Status (Opted Out => Opted In) [closed]

How can we change contacts' status from Opted Out To Opted In using Import? Is this possible?
0
votes
1answer
155 views

InvalidDecimalScale SFMC CSV data import

Anyone run into an InvalidDecimalScale error in the SFMC CSV data import? I came up with a contrived example to test. I made my data extension super simple: It's a data extension with three fields. ...
0
votes
1answer
12 views

imported data not displaying and no option to set tab to show “All”

I have imported data to a custom object using dataloader. It said all records imported successfully. When I run a report I can see the data. However, when I go to the tab it only shows "recent" with ...
0
votes
1answer
940 views

Marketing Cloud - Import - User does not have access to Salesforce objects or reports

I am new to SF and SFMC. I am trying to create a new import activity in Email Builder. Everytime I try to create a new Data Extension using a Report through SF, I receive this error. Import ...
0
votes
1answer
545 views

enable a user to use the import wizard to upload custom object records?

How can I enable a user to use the Data Import Wizard to upload records to a custom object? Currently I have a user with Create permission on a custom object, the custom object has a Master detail ...
0
votes
3answers
2k views

ContentNote Insertion through DataLoader

I see ContentNote has been introduced as enhanced note feature, Can anyone let me know in what format I need to insert the contentnote in a particular object via dataloader.io I am getting the error ...
0
votes
0answers
16 views

Does Salesforce Marketing cloud support .gz compressed files

I have just been asked if .gz can be unzipped in marketing Cloud? I can't find a list of supported compressed files in the help docs
0
votes
0answers
13 views

Schedule weekly import of documents from external location

I want to schedule a weekly batch import of documents from an external drive into Salesforce. Say, in the external drive there is a folder called 'CompetitorScore' and in that folder there are 50 ...
0
votes
0answers
9 views

How to call back imported articles in salesforce knowledge

I have imported knowledge articles using 'Import article' tool in salesforce. Is there any way if I want to call back the inserted articles from org.
0
votes
1answer
39 views

How to map case and category while import articles in lightning knowledge using article import

In classic there are multiple article types. I have taken backup and need to import them again to lightning knowledge using article import tool. I am able to import articles using csv file and ...
0
votes
1answer
25 views

Transferring activities associate with accounts to lead

1) On changing the "whoId" of the activities for the conversion of activities associated with the account to lead should we also change the "whoId" field of open activity and activity history too? 2) ...
0
votes
0answers
132 views

Import File Activity . field not found validation error

In Marketing Cloud's Automation Studio, we created an automated import file activity based on a file drop trigger (i.e. file naming pattern, not the folder-based drop). Even though the automation runs ...