BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[BOBJ 5.x] Wrongly formatted data from CSV file for Time


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 9


flag
PostPosted: Mon Jan 28, 2019 11:19 am 
Post subject: Wrongly formatted data from CSV file for Time

Hi Experts,

I am running a report, which is extracting data from csv file and Universe. I am getting the data but one of the columns from csv file is Time and it's populating as Date format.

Please let me know what should I do?

Thank you very much.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11429
Location: Manchester, UK


flag
PostPosted: Tue Jan 29, 2019 3:42 am 
Post subject: Re: Wrongly formatted data from CSV file for Time

Is the data correct in the underlying csv file? If not, return to sender.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 9


flag
PostPosted: Tue Jan 29, 2019 4:18 am 
Post subject: Re: Wrongly formatted data from CSV file for Time

Thank you Mark,

In the csv file its showing as Time format, 08:48:38, but in BOB report's output as Excel is showing in Date format.

Thank you.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11429
Location: Manchester, UK


flag
PostPosted: Tue Jan 29, 2019 6:42 am 
Post subject: Re: Wrongly formatted data from CSV file for Time

Have you populated it as time format or as a time string in the report?

The export to Excel is notoriously flaky - I've had to write scripts in the past to open an Excel file and run a vba macro to format columns! icon_cry.gif

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Rob_mot
Forum Member
Forum Member



Joined: 28 Jan 2019

Posts: 9


flag
PostPosted: Tue Jan 29, 2019 6:53 am 
Post subject: Re: Wrongly formatted data from CSV file for Time

Much appreciated your time Mark!

The csv file's format is as Custom. I tried to change it to time and run it again but it didn't make any difference. I am running Macro to get the Excel output.

Thank you.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0272 seconds using 18 queries. (SQL 0.0028 Parse 0.0009 Other 0.0235)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo