Questions tagged [data-extract]
The data-extract tag has no usage guidance.
65
questions
7
votes
2
answers
3k
views
Zip data extract and push to an external FTP
I am needing to zip and push data extension extract files to an external ftp. I recently enabled the 'zip' extract type in the account, which allowed me to zip files stored on the marketing cloud FTP ...
- 2,615
3
votes
1
answer
4k
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 ...
2
votes
0
answers
1k
views
Automation generates yesterday's data and file name when run early morning (fine under other hours)
We have an automation to export the people in a Data Extension with the LastDeliveryDate value equal to 21 days ago. The file will end up on an SFTP server that is not Salesforce's own Enhanced server....
- 630
3
votes
1
answer
3k
views
Data Extract of data extension to Enhanced FTP
I am trying to extract Contact Keys from a data extension so that I can load them back into the system to unsubscribe them. I am gathering these contact keys from multiple SQL Queries to different ...
1
vote
1
answer
1k
views
Extract mobile connect list of unsubscribes
I have tried to find information about how to automate the export of MobileConnect status for unsubscribes with stop-code.
I've found this official documentation about querying data views as ...
- 266
2
votes
2
answers
790
views
Export all subscribers file content is in hexadecimal, I need it to be readable text
I have an automation to export all subscribers to fetch the "status" column. My shceduled automation extracts the all subscribers list and then drops the file on the dedicated FTP with correct name ...
- 266
0
votes
2
answers
68
views
Exiting Salesforce
Our organisation has made a decision to stop using Salesforce which means i need to extract all of the data from the system.
I have ran the Data Extract funcationality, however this extracts all of ...
- 1
0
votes
1
answer
51
views
How does the new Data Extract interface compare to the old one?
I am trying to perform a data extract via the new "lightning enabled interface" in Automation Studio.
I have the configuration below, but it keeps erroring.
I have searched for documentation, but ...
- 6,563
1
vote
1
answer
210
views
Is it possible to create an automation that exports a list (not a DE) to an FTP?
I need a way to automatically export a list (not DE) to an FTP. I know this is possible when using DE's, data extracts, and file transfer activities. However, no documentation seems to exists when ...
- 181
1
vote
1
answer
468
views
Data extract UserAgent with Mac
We are running data extract on a daily basis, recently we added the 'Include User Agent Information'.
Checking the consistency of the data we have found a user who opens the email with a Mac and ...
- 807
2
votes
2
answers
1k
views
Is Document Body Blob field value encoded in Base64 when extracted by Dataloader? Can this encoding be used for insert or update?
I want to use Salesforce DataLoader to extract and upload Documents.
However, I don't understand in which format Blob Body values are stored, is it Base64 encoded?
Looks like yes, but why it is not ...
- 16.1k
0
votes
1
answer
7k
views
Updating All Subscribers List with query, extract and import
I have followed instructions from this link :
How to Query a Data Extension and Update the Subscriber list at the Child Business Unit Level?
Our current configuration allows existing users to update ...
- 6,563
0
votes
1
answer
134
views
Extract Competitor Information from Opportunity
Salesforce Opportunities has the possibility to record competitor data for an opportunity. On an opportunity this is represented as a related list which allows you to select a competitor and then type ...
- 1,345
1
vote
1
answer
1k
views
Data Extension Extract using API
I would like to execute a Data Extension extract using API. Went through the below documentation but it asks for Start and End Date which doesn't make sense for Data Extension extract. Any suggestions?...
- 2,164
8
votes
1
answer
4k
views
Help with incomplete Tracking Extract documentation
Would anyone out there be able to provide some additional documentation for these Include Options for a Data Extract of Tracking Data?
I've requested an update to the one wiki page that has most of ...
- 30.2k