Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [import]

The tag has no usage guidance.

0
votes
1answer
29 views

Invalid decimal on values less than zero e.g. “,5”

I am trying to import a file from the enhanced SFTP location into one of my data extensions. I have a decimal column in my DE with the length of (8,2). When I import the file I get the error ...
0
votes
1answer
42 views

Auto Generate Subscriber Key

I a have a file drop automation which is importing data into specific data extension - there is no subscriber info in the data and I do not want to set one to email address. What would be the best way ...
-1
votes
1answer
27 views

Importing Contacts error “Name”

I am trying to import contacts and keep getting a name error. I have checked my data and it is accurate. Any help?
1
vote
1answer
22 views

Records not being imported properly into SMS All Contacts

I've created a DE that's populated via entries on a Smart Capture form a user completes via a link in an email. The form captures the user's submission for 'MobileNumber', passes the 'ContactKey' as a ...
1
vote
1answer
50 views

import es6 from an extra javascript file in another component bundle in LWC

I think the documentation completely misses the case when you want to import an extra es6 module from another component bundle. Example, suppose we have the following folder structure. lwc module1 ...
2
votes
1answer
224 views

sfdx import failure ENOENT: no such file or directory

I'm trying to import data in a scratch org but I'm always getting the error andresbrav-ltm2:sfdx-out local.user$ sfdx force:data:tree:import --targetusername test-user@example.com --plan export-demo-...
1
vote
2answers
156 views

bad value for restricted picklist field (from dataloader)

How to Solve this issue to Import record SOURCE: 'fsCore__Customer_Name_Format__c' DESTINATION: 'fsCore__Customer_Name_Format__c' ERROR:bad value for restricted picklist field: Account Only picklist ...
5
votes
1answer
165 views

Why it is forbidden to import several Apex Methods at once in LWC module?

I have Apex Controller Class, say, LWCController and several methods inside of it, let's say Method1, Method2, Method3, Method4, Method5. Documentation says that to Use default import syntax to ...
2
votes
2answers
141 views

Is there a way to load every label data and every SObject description data in Lightning Web Component using only Javascript without any Apex?

Is there a way to load every label data and every SObject description data using only Javascript without any Apex Server-side code? How do I import * from @salesforce/schema or @salesforce/label? I ...
2
votes
1answer
43 views

“id value of incorrect type” when using force:data:tree:import

This is a follow-up to my previous question where I asked for help importing data for lookup fields: How do lookup relationships work with force:data:tree:export? Don't know where to start I can ...
3
votes
1answer
93 views

How do lookup relationships work with force:data:tree:export? Don't know where to start

I'm trying to import and export data between scratch orgs using force:data:tree:export, and I'm having trouble finding documentation that explains how to handle lookup relationships. Lets's say that ...
0
votes
1answer
24 views

How can I lookup an account ID for a Case using a field I am importing that is not the account name?

I have to import a history of cases in Service Cloud and, sadly, the account names I already have in Sales Cloud and the ones in the import don't match. I have a Client ID though in the Account object ...
1
vote
1answer
57 views

What is the correct syntax for using “Begins With” when setting a Filename Pattern in an import automation?

I am new to Salesforce and I am trying to setup an import automation. I am having trouble figuring out the correct syntax when using the "Begins with" option in the filename pattern. The docs say you ...
0
votes
0answers
95 views

How to remove double quotes from CSV

A .csv file I have imported via FTP (too large to manually upload) is wrapping several of the contained columns values in double quotes. When I review the file in Excel the quotes don't exist and the ...
0
votes
0answers
18 views

Best Approach To Upload Big CSV to Apex Object

I have 2000 to insert into Standard object by importing the CSV using custom code only and than creating the csv and make it available for user to download to see passed and failed records. I am able ...
0
votes
1answer
16 views

Importin Excel files in xls format

Does anybody know if it's possible to import .xls files into SFMC ?
1
vote
1answer
87 views

Resubscribe to Publication List

I have an automation that extracts a specific set of records, daily, with the end goal of having their status in a publication list updated from 'Unsubscribed' to 'Active.' All steps of the automation ...
3
votes
0answers
67 views

SFDX force:data:tree:export Document “Reference”

Since you cannot have a formal field relationship (Lookup) from an SObject to a Document object we have a SObject (let's call it "Settings") that "references" a Document object by simply storing a ...
0
votes
1answer
43 views

Create new filtered mobile contact list with automation

I've currently got an import automation which imports files dropped in an SFTP location. It adds them to a mobile list I have called SMS_Master. It works fine. Our marketing team then has to filter ...
1
vote
1answer
136 views

Automate importing of SMS MobileConnect data

I recently engineered an automation to import data from our FTP to a data extension based on a file drop. Marketing Cloud does this very easily. What I haven't been able to figure out is how to do ...
2
votes
2answers
757 views

Updating All Subscribers from Data Extension

Is there a way to update a record in the AllSubscribers List from a Data Extension Import? I'm hoping to set up a daily automation that imports data file into a Data Extension on the subscriber key ...
1
vote
1answer
159 views

Add Only on an import definition requires a primary key?

I am confused - why does the "Add Only" option on an Import Definition require a primary key? This doesn't make much sense to me. The nature of this data extension in question doesn't necessitate ...
0
votes
2answers
101 views

Problem importing data with standard lookup via Salesforce DX

So problem is with Contact records. There is required lookup field called Account Name ( API Account ). So i did download records with SFDX commend : sfdx force:data:tree:export --query "SELECT ...
0
votes
1answer
31 views

Importing external CRM data with new households/accounts joins

Is there a best practice / simplified methodology for importing bulk records from an external CRM when there are new intricate household and account joins? I have looked into dataloader.io, but what ...
1
vote
0answers
129 views

Import File Activity - File Naming Pattern / Wildcards - How far will the default go back in time?

My question is about wildcards / file name pattern inside automation studio. When you define a file name pattern inside an import file activity like FULL_IMPORT_%%Day%%%%Month%%%%Year%%.csv how will ...
0
votes
1answer
14 views

Import adding quotes around address value

I've imported a file into a data extension and one of the fields is for ADDRESS in the file there are no quotes but when I import and look at the data extension the output reads ("123 N Main St.") ...
0
votes
2answers
33 views

Why is the email field getting imported to a data extension as text?

I use an import activity + automation studio to import the data from a salesforce report to marketing cloud daily at a given time in the morning so after importing it an email can be sent to those ...
1
vote
1answer
37 views

How many concurrent import activities to DE

In the documentation here it is said: Concurrent Imports to a Data Extension ,Normal: 1, Aggresive: 2, Extreme: 3 or more. Does anyone know if it means that its not recommended to perform 3 or more ...
0
votes
0answers
37 views

Data Import not importing full amount - only existing susbcribers

We get files placed on our FTP to use as data extensions for email campaigns. I have a custom automation with 4 steps (using a combination of query activities, ampscript and SSJS): Import File to ...
1
vote
0answers
31 views

Import Activity locking file before import starts

I have created an automation that has an Import Activity from my SFTP. What we have noticed is that the automation seems to have been writing over the file prior to the automation running (it's set to ...
0
votes
1answer
77 views

Marketing Cloud - Contact Delete - does SFMC remember?

In January my company had a subscriber purge by getting rid of lots of subscribers we no longer email/unsubscribed long ago. Most of our data is held primarily in a SAS platform and we receive ...
1
vote
1answer
459 views

Is there a way to import Products and Opportunities in Salesforce Essentials?

I can see that you can import Accounts and Contacts, but I don't see a way to import a CSV of Products, or even past Opportunities so my reporting would be right. Am I missing something?
0
votes
0answers
285 views

Can we delete file from SFTP Import folder after import activity?

Can we delete file from SFTP Import folder after import activity? I have an automation that picks up the file based on name. The file is uploaded frequently on SFTP import folder and I have noticed ...
0
votes
1answer
115 views

Is there a CSV template for Contact Import

I want to import my customer list but I'm not sure what the correct ordering of fields should be. Is there a CSV template I can use to export my data and then import it into Salesforce Essentials?
0
votes
1answer
124 views

MobileConnect Import Definition to create new list each time

I've just started using an automation which imports a list of MobileConnect contacts into a list called SMS_Master. The mapping works fine and the file drop trigger works great. However, we run ...
0
votes
1answer
34 views

Data Import Wizard congratulations window not able to close it

Logged in as a standard user and tried to insert the lead record using data import wizard. I flowed all steps which were mentioned step by step but at the end, I am getting "congratulations your ...
0
votes
1answer
260 views

Import Automation for Mobile Studio - 'File Not Found' error

I'm running a file-drop triggered automation to import people from a CSV list into a MobileConnect Contact List. I've created the Import Definition - very simple, just 3 fields (contact key, mobile no ...
2
votes
2answers
174 views

How to import data that is dependant on records created via a trigger

My aim is to have sample data automatically imported into any scratch org I make. The problem I have is that one of the records that I insert using a plan has a trigger action that creates another ...
0
votes
0answers
142 views

15CharacterContactID imported at 18characterContact ID

In my salesforce report I have the ContactID in a 15character digit format. When I import in Marketing Cloud it automatically imports with the 18 digit Character and I know the 18 digits is the ...
2
votes
0answers
291 views

Process not triggered by Import

We built a process which auto populates a text field when three other text fields have certain values. It work fine when I change values manually, but not when I update the fields with the Data Import ...
4
votes
1answer
99 views

Can I use a Triggered File Drop Automation with an External FTP?

Can I use a triggered file drop automation with an External sFTP? Within Automation Studio I have the Starting Source set to File Drop and the Step One Activity as an Import Activity>ImportFile>File ...
-1
votes
1answer
383 views

Is it possible to copy fields from Sandbox to Production?

I have had to manually add 100+ fields (don't ask...) to a clients sandbox environment in order to test some updates. However now that the testing seemed to be fine I am tasked with replicating all ...
1
vote
1answer
292 views

How to import records into Marketing cloud from Salesforcce

I want to import records in Marketing cloud from Salesforce objects or reports because I'm not able to see the option of IMPORT in the interactions tab in Marketing cloud?
0
votes
2answers
1k views

Limitations for Import from Enhanced FTP in SFMC

I am using Data Extract -> File Transfer -> Import via an automation to upload my synchronized data extensions to All Subscribers in Marketing Cloud. Currently everything seems to work fine, however ...
0
votes
2answers
905 views

Update MobileConnect Demographics from a Data Extension

I seem unable to update an existing row in MobileConnect All Contacts list. I also seem to not be the only one with the confusion: Is there a way to update MobileConnect Subscription Data from a ...
1
vote
1answer
279 views

Import is not writing over the original Data Extension

I have an import that is based on a SF report, import is set to overwrite. If the new report results are empty, the original information remains in the Data Extension. I need it to remove any prior ...
1
vote
1answer
350 views

Update to “undeliverable” status from subscribers

I was facing the issue of importing a list to "All Subscribers" with the status Undeliverable. The problem is that the keyword "Undeliverable" do not exist in order to update the subscriber status. I'...
0
votes
1answer
145 views

French characters do not appear correctly in a Data Extension

We've uploaded a product table with French product data. The characters came out as gobblygook and researching here I found that we should save the file as UTF-8. Doing this made the TXT file data ...
1
vote
1answer
832 views

Not able to remove Import button from Contact list view in lightning

I have deselected the "Import Personal Contacts / Import personal accounts and contacts" under "App Permissions" section on the custom Profile. But still list view shows "Import" button. How can I ...
0
votes
1answer
212 views

How to display number of records in .csv file import in visualforce page

How to display the number of records in .csv file import in the visualforce page. I am able to import csv file and display the records in VF page, but I don't know how to display the record count in ...