on 04-14-2006 11:24 PM
Hi,
I have a requirement where i need the Excel Queries to be displayed in Flat file(.CSV) format.
To be more clear i have an excel query but my client requires this query to be displayed in a Flat file format. Can someone explain me how i can acheive this.
Thanks
Hi,
In Web reporting we have the option of downloading the report output to .csv format.
and in Bex,just save the output file with extension of .csv..
i.e. >file>save as...>xxxx.csv (where xxxx is file name ) and select 'Save as Type' as CSV(Comma delimited) from drop down box.
ThankS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for all the information provided by i missed mentioning one point, actually thse queries are to be automatically schedule. the requirement is like this i need to bring to extract data and build queries export it as a .CSV file these queries are not end user queries so they have to be automatically scheduled and will be picked up by an interface so they do some mapping with the .CSV file we provide.
So we decided to do it in Reporting Agent in Excel format and automate it and send the file to a specific location from where the Interface team can pick it. which doesnt need an user to run the query.
so can someone tell me if i can automate a query and as well as have the query in .CSV format?? I hope i was clear
Thanks.
hi priya,
file>save as
file name xxxx
save as type csv(Ms-dos)
and say save.
that's it.
pls assign points.
by
ANR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Priya,
Welcome to SDN
Have you tried saving the output of the query in .csv format on the local desktop on which the query is executed. I think it should work give it a try.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Options might depend on what release you're at.
If you are at 3.5, there was a note - think it is with SP 14, perhaps 15. That adds csv as an output option of Information Broadcasting.
At 3.1 you could look at using Openhub/Infospoke.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.