BusinessObjects Board

Cant Create a .csv in BO 6.5.1

building reports desktopintelligence
#1

Cant Create a .csv in BO 6.5.1

In BO 5.1.8, I can Export to csv in the data manager, give it and extension of .csv when I create it and open the file directly in Excel. The file that was created has an extension of “Microsoft Excel Comma Seperated Values File” When viewed in notepad, the comma seperators are apparent.
In BO 6.5.1 the same key strokes produces a .txt file. It can be opened in Excel and it appears the same as a .csv would in excel. When opened in Notepad it does not show the comma delimiters. I have a user with a macro that uses 28 reports that they created in BO5. They require a “Microsoft Excel Comma Seperated Values File” to be produced . I know you can pick (.) and chose a Character delimiter of ‘,’ but it does not produce a csv. entension.

Is there some setting or option that I am Missing?

Doctordien (BOB member since 2018-04-23)

#2

What version of 6.5.1 are you on?

There were several issues with the early service packs when saving as text and Excel files. You already know you’re on a very old version - have you considered upgrading to XI3.1 or are you small enough not to want to move to a server-based architecture?