Importing Custom Data and dashboard

Avatar

clavenk152237

16-05-2017

Hi, I having a requirement to allow update crm data into adobe analytic for create a dashboard view. 

e.g

importing FTP via data source into system.

sample field like. 

transaction id, application type, status, created date, created by, etc

The end goal for this is basically using the import data to drag and drop to output say rejected rate in graph for dashboard. Something that can be achieve by splunk.

Can anyone guide me where i can find these information?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

hyderziaee

Employee

16-05-2017

---Correction---

The evarN should be as 'Evar X', where X = {1, 250}

similarly event should be 'Event Y', where Y = {1, 1000}

Make sure the the first letter is capitalized and there is a space in between the word and the number.

-Hyder

Answers (3)

Answers (3)

Avatar

hyderziaee

Employee

16-05-2017

Looks like your third file failed as well. Make sure that the 'V' is capital in 'eVar' 

Do you also have an event in the file? There must be at least one eVar and one event in the file along with the date column. Also make sure the 13 variables you are using are enabled in the report suite settings.

-Hyder

Avatar

clavenk152237

16-05-2017

HI i already did, but after upload with custom header name. It throw error. 

                  
Summary 
                
Description
Status:ERROR
The Data Source could not be processed
Data Source Filename:trx_appl_20170516.txt
Upload Date:Tue. 16 May 2017
Details 
                
Report Suite
Site Title: 
Site URL: 
Username:apdapdapactemplate
                                                                    
Notes
:The file could not be processed due to the following conditions:
:
  • Column header: "trx_application_id" is not a valid column header
:
  • Column header: "name" is not a valid column header
:
  • Column header: "id_type" is not a valid column header
:
  • Column header: "id_num" is not a valid column header
:
  • Column header: "mob_tel" is not a valid column header
:
  • Column header: "email" is not a valid column header
:
  • Column header: "education_level" is not a valid column header
:
  • Column header: "interview_date" is not a valid column header
:
  • Column header: "fist_date" is not a valid column header
:
  • Column header: "status" is not a valid column header
:
  • Column header: "created_by" is not a valid column header
:
  • Column header: "updated_date" is not a valid column header
:
  • Column header: "updated_by" is not a valid column header
:
  • At least one enabled metric is required
:
  • At least one enabled dimension is required

 

after that i did try to change all the column name to eVar1...eVar13. Now the status is in queue

please refer to attachement on the current upload file status