Omniture Data Warehous FTP Output | Community
Skip to main content
K
kamlesh_khollam
October 16, 2015
Solved

Omniture Data Warehous FTP Output

  • October 16, 2015
  • 4 replies
  • 3164 views

Hi,

Can anyone tell me how to format Omniture Data Warehouse FTP output i.e. Date Column formatting (as 'YYYY-MM-DD') and output column delimiter.

 

Regards,

Kamlesh

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TanmayMathur

Hi Kamlesh,

You can use Comma as a column delimiter, and after that select the date column and change the date format. 

Let me know if that works for you.

Regards,

TM

4 replies

darrynk23768843
darrynk23768843
Level 2
October 16, 2015

Hi Kamlesh,

I think the answer you are looking for is: You can't change the format of fields for output in a DataWarehouse report, you can only select the items, and they will be output in the format that Adobe uses. You will have to change the format once you receive the file and use it, or, if you are an admin, you can change it in the Company Settings -> Preferences by selecting the "Use ISO 8601 Date format for CSV (2015-06-30)", but this will affect everyone's extracts.

You can only use a comma delimiter for csv files as there is no choice for a different delimiter. 

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
October 16, 2015

Hi Kamlesh,

Thanks for reaching out!

Could you elaborate some more on how is your data arranged and how you want to format your it? It would be great if you could post a screenshot.

Regards,

TM

K
kamlesh_khollamAuthor
October 16, 2015

Thank you Tanmay for Response.

 

Current Output:

"May 1, 2015","0","abcd",1,0,0,0,0.00
"May 1, 2015","0","fydss",1,1,0,0,0.00
"May 1, 2015","0","abdkjsahf17267",1,0,0,0,0.00

 

Expected Output:

2015-05-01,0,abcd,1,0,0,0,0.00
2015-05-01,0,fydss,1,1,0,0,0.00
2015-05-01,0,abdkjsahf17267,1,0,0,0,0.00

 

Regards,

Kamlesh

TanmayMathur
Adobe Employee
TanmayMathurAdobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

Hi Kamlesh,

You can use Comma as a column delimiter, and after that select the date column and change the date format. 

Let me know if that works for you.

Regards,

TM

Terms & ConditionsAccessibility statement

Loading footer...