Exporting to CSV - Date Format Changed

building reports webintelligence
1

Hi,

I am on WEBI XI R2. And I have created a report with 20 columns. The record count is 85,000.

Now when I save the report in CSV problem, I am facing two problems -

  1. The columns alignment is changed. Means first column goes to the third position and third column comes to the first position.

  2. There is a date in the report , it’s format is M/dd/yy. But when I export it in CSV, it is taking timestamp also.

Could some one guide me if this is a bug or I am missing anything.

aniketp :uk: (BOB member since 2007-10-05)

2

Hi

  1. The columns alignment is changed. Means first column goes to the third position and third column comes to the first position.

A.Plz check the Edit query columns order,You can find the same oder which is ur finding in the CVS file.

2.There is a date in the report , it’s format is M/dd/yy. But when I export it in CSV, it is taking timestamp also.

A.Check the Date cloumn in the data base,it will display with Timestamp.

CSV file is take the data from the query level,not from Boxi level.

:wave:

kumar123 (BOB member since 2007-08-19)

3

Kumar, thanks for your inputs.

Can you please elaborate your point? Actually when I take this report in excel, it comes perfectly, but when I take CSV dump, it is happening.

aniketp :uk: (BOB member since 2007-10-05)

4

Aniket,

Your issue is similiar to the one I just posted to: https://bobj-board.org/t/140875

Thanks,
John

jsanzone :us: (BOB member since 2006-09-12)

5

It’s quite simple. When you save as Excel, you are saving the report. So, the columns are in whatever order you see them on the report. If you have 6 objects and only display 5, then you will have 5 columns in Excel.

CSV is a totally different story. It is not saving the report. It is saving the results of the query. So, it duplicates the order of the objects in the data provider itself and display all columns. The report is completely irrelevant.

Steve Krandel :us: (BOB member since 2002-06-25)

6

I’m having the same issue, but I don’t think the initial response is correct… it looks to me like something else in SAP BI is adding the time stamp in the same way any program might “interpret” a field and change the data type

I say this because even if I build the re-build the offending field myself, the time stamp is STILL being added as 00:00:01

e.g. Business objects will add the time to the end of all these custom formulas

=FormatDate([Date_Field_Name];“MM/dd/yyyy”)

=MonthNumberOfYear([Date_Field_Name]) + “/” + DayNumberOfMonth([Date_Field_Name])+ “/” + FormatNumber(Year([Date_Field_Name]);"#")

I had to use FormatNumber in the second one otherwise instead of a “time stamp” BI exported to CSV with a thousand separator

e.g.
11/7/2,016

Is there some format that allows me to send integers separated by forward slashes that will not be formatted with time into CSV?

puja21 (BOB member since 2016-11-07)