webi to txt

system · March 12, 2007, 6:46pm

is there any way to extract WEBI reports into a text file with out using queries.

santosh4bo (BOB member since 2006-11-20)

system · March 12, 2007, 8:55pm

I don’t think you can directly save it as txt file.
save it as excel and open in excel and save as txt file from there.

MR

Mahi (BOB member since 2004-07-22)

system · March 12, 2007, 8:57pm

i know abt that but by making use of certain SDK functionalities is there any possibilities of adapting that

santosh4bo (BOB member since 2006-11-20)

system · May 4, 2007, 12:11pm

Hi,

I have a similar requirement to save report in txt format.
Please share the solution.

Thanks in advance,
Shivangini

shivangini (BOB member since 2007-04-13)

system · May 4, 2007, 12:20pm

you can save them manually as csv with webi or infoview html viewer. but you can’t planify this extraction.

ggouzy (BOB member since 2005-10-25)

system · May 4, 2007, 5:00pm

I know that ways anyways thanks for the reply but i am looking for extraction i clearly mentioned in the question

santosh4bo (BOB member since 2006-11-20)

system · May 7, 2007, 8:24am

hi everyone,

select the webi report and right click on it u can see a option “copy as text” in this way u can save the webi report as a text.But this is possible only in edit mode.

i think i have answered to your question

regards,
vamsi

vamshikrishna99 (BOB member since 2006-10-18)

system · May 7, 2007, 2:06pm

Hey vamsi once u right click you will be able to see only excel/pdf, there is no option of rtf, make sure once again !

santosh4bo (BOB member since 2006-11-20)

system · May 8, 2007, 7:46am

hi,

please confirm the version you are using because it is possible in BOXI R2.

regards
vamsi

vamshikrishna99 (BOB member since 2006-10-18)

system · May 8, 2007, 8:00am

Hi,
vamsi wrote

checked this couldnt find the option

currently on boxi r2 and viewing in html mode.
please let me know if we are missing some thing.
thanks

mockingbird (BOB member since 2007-02-07)

system · May 9, 2007, 10:57am

hi,

try out in java report panel not in html mode.hope u will find the solution this time

regards,
vamsi

vamshikrishna99 (BOB member since 2006-10-18)

system · May 9, 2007, 1:36pm

Hi,
Vamsi wrote

Sorry still cant find it!
Please attach screen shots of your preferences and the window with saves as text option if possible.
Thanks in advance

mockingbird (BOB member since 2007-02-07)

system · May 10, 2007, 7:30am

hi,

iam sending you the screen shot of webi report which is in edit mode.when u right click on the report it will show “copy as text” option.please see the screen shot for reference.And one more thing you should open the report in the java report panel.but once check for both html mode and javareport panel mode.

hope this time it will slove your problem.

regards
vamsi
screenshot.doc (47.0 KB)

vamshikrishna99 (BOB member since 2006-10-18)

system · May 18, 2007, 4:50pm

Hi Vamshi

This might seem a dumb question but once i copy it as text what should i do next

tahnks in advance for your reply
jaango

jaango (BOB member since 2007-03-26)

system · May 27, 2007, 6:10am

hi,
paste it in a excel or word the result u can see in text format

vamshikrishna99 (BOB member since 2006-10-18)

system · May 29, 2007, 4:49pm

thanks for the reply , but i was looking for a way to save a webi report on the repositoryt as text format.
My requirement is that the users want to see a report in text format and they dont want to go thru the extra steps of saving as CSV and then opening as text. moreover that report has to be scheduled to run everyday.
thanks for the response again .

jaango (BOB member since 2007-03-26)

system · September 11, 2009, 8:30pm

Hi Vamshi,

Thanks for the solution to save a webi report as .txt .But i am having a problem with this method,the column headers are misaligned.Can you suggest a way to get a fix to this.besides i read in other posting that we can save it to .CSV and later save to.TXT format.This process is having issue with the rows that can be handled (max 65536).My report has data of 96000.Any other ideas or suggestions please.

pan1969 (BOB member since 2005-01-27)

system · September 14, 2009, 6:25am

Hi Jaango,

If you want to save a .txt format in the repository you can use Import Wizard and select the source as Text file. however I dont see a posibility of this if the report is scheduled. you will Import the txt file manually.

Tell me if im missing something

Thanks

jvmauricio (BOB member since 2009-08-03)