Exporting to Excel from Survey
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Exporting to Excel from Survey

 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services
Author Message
rj
Guest
Posted: Mon Jan 17, 2005 6:15 pm    Post subject: Exporting to Excel from Survey Reply with quote
I'm trying to export a survey to Excel and the questions that are Rating
Scales don't come through. Is there any way to get this data also?
Back to top
Ian Morrish
Guest
Posted: Tue Jan 18, 2005 5:55 am    Post subject: Re: Exporting to Excel from Survey Reply with quote
Hi,
You can get all the survey data out as XML using the following url
http://www.wssdemo.com/_vti_bin/owssvr.dll?Cmd=Display&List={E3B89446-F326-4891-892D-7BC5593FEBAA}&XMLDATA=TRUE

Just replace the host name and list guid # with yours. (get the list guid
from the urlfor Modify settings and columns page)

Regards,
Ian
http://www.wssdemo.com

"rj" <rj@discussions.microsoft.com> wrote in message
news:E458D1B4-B9A7-47D7-9B4E-DC28BCF7DF52@microsoft.com...
Quote:
I'm trying to export a survey to Excel and the questions that are Rating
Scales don't come through. Is there any way to get this data also?
Back to top
rj
Guest
Posted: Tue Jan 18, 2005 9:23 pm    Post subject: Re: Exporting to Excel from Survey Reply with quote
Thanks, I'm sure I can figure iut how to get what I want from this.

"Ian Morrish" wrote:

Quote:
Hi,
You can get all the survey data out as XML using the following url
http://www.wssdemo.com/_vti_bin/owssvr.dll?Cmd=Display&List={E3B89446-F326-4891-892D-7BC5593FEBAA}&XMLDATA=TRUE

Just replace the host name and list guid # with yours. (get the list guid
from the urlfor Modify settings and columns page)

Regards,
Ian
http://www.wssdemo.com

"rj" <rj@discussions.microsoft.com> wrote in message
news:E458D1B4-B9A7-47D7-9B4E-DC28BCF7DF52@microsoft.com...
I'm trying to export a survey to Excel and the questions that are Rating
Scales don't come through. Is there any way to get this data also?


Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Windows Services All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB