Topic 7: Data Import/Export Flashcards
When setting up SFTP, something goes wrong. What should you do first? Check the file name? Check the credentials? Make sure that Eloqua’s IP address’s are whitelisted?
NEED TO VERIFY (personally, I would verify the credentials first)
Make sure Eloqua’s IP addresses are whitelisted.
source: http://topliners.eloqua.com/thread/4794
When doing a list upload, what are the data priorities?
The data priority system will not allow data of a lower level to overwrite data from a higher level on a per-field basis.
From highest to lowest priority:
Bulk API
CRM Data
Third Party Data
Eloqua Report
Remote File over SFTP
Manual Upload
A field will be updated if it is blank as no priority exists.
What is the SFTP export time interval limit?
30 min
What settings can be changed for an existing Eloqua hosted URL export? delimitors, file name, port, file size?
Export Name, File Name, Compress File toggle, Append Date Stamp toggle, Schedule, Notifications, Data Set, Data type, file extension, delimeter, text qualifier, row delimiter, character encoding
When exporting a list in data export, where do you define “on demand” as when the file is exported?
Select the “on Demand” radio button under the “Schedule” section from Setup » Import/Export » Export Settings
SFTP connection works, but no field exporting. What do you do? Whitelist? check file path?
** Need to verify**
check file path
http://topliners.eloqua.com/docs/DOC-1380
If you experience trouble while trying to do a string manipulation via API and the fields are not mapping, what do you do? The fields do not show up and instead you get an credential error.
This is likely because your cloud connector credentials have expired. You must update your cloud connector credentials within the credentials management area at cloudconnectors.eloqua.com.
Or, if contact level security is enable, make sure that whatever account you are using to run the app has the proper access.
(Source: http://topliners.eloqua.com/community/do_it/blog/2013/07/22/eloqua-cloud-connectors–updating-your-credentials)
You run into trouble using the string manipulation cloud connector. After checking that your credentials are correct and making sure API access is enabled for the database, what should you do?
Make sure the user whose Eloqua credentials you provide is added to the “API Users” security group to ensure it has API access
http://topliners.eloqua.com/docs/DOC-3069
What happens in this scenario: you are doing a list upload and one of the fields has a pick list. For one of the records, the values in the upload do NOT match the values in the list. What happens when uploading? Does the record not get created? Does the record get created and the pick list field remain blank? Does the field get overwritten with the values within the list?
The record gets created and the picklist value assinged to the record is added to the destination picklist
Once a Data Import has been created and saved, what two Import Settings can be modified?
Schedule and Import NameThe Import Name and the Schedule can be modified on existing Data Imports.
True or False: The ‘Priority Source’ Import setting can be modified on existing Data Imports
False.Priority Source cannot be changed after the Data Import has been created and saved.
True or False: The ‘Schedule’ Import setting can be modified on existing Data Imports
True.Schedule can be changed after the Data Import has been created and saved.
True or False: The ‘Import Purpose’ Import setting cannot be modified on existing Data Imports
True.Import Purpose cannot be changed after the Data Import has been created and saved.
True or False: The ‘Import Name’ Import setting cannot be modified on existing Data Imports
False.Import Name can be changed after the Data Import has been created and saved.
When exporting to an Eloqua Hosted URL, what type of URL is generated?
httpsScheduled data exports to an Eloqua Hosted URL generate the URL type ‘https’
