Red Gate forums :: View topic - Output to excel or xml
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

Output to excel or xml

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
green squirrel



Joined: 01 Mar 2012
Posts: 2

PostPosted: Thu Mar 01, 2012 6:49 pm    Post subject: Output to excel or xml Reply with quote

Hi there,
What I'd like is to only generate tables and columns, and put this info into excel. However, I see thats not possible (correct me if Im wrong?)
So I thought: ok, I'll create the html stuff, and read it as xml (in vba, for instance). The trouble is, I don't think the generated HTML is well formed - msxml2 parser doesnt like it.
So is it possible to output just pure xml?

OK thats it, thanks all.
_________________
destination anywhere
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Mar 01, 2012 9:53 pm    Post subject: Reply with quote

Thanks for your post. Unfortunately, it's not possible to output to pure XML.

Out of curiosity, why do you want the outputted documentation in Excel format?

Peter
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
green squirrel



Joined: 01 Mar 2012
Posts: 2

PostPosted: Fri Mar 02, 2012 4:01 pm    Post subject: Re: Reply with quote

peter.peart wrote:
Thanks for your post. Unfortunately, it's not possible to output to pure XML.

Out of curiosity, why do you want the outputted documentation in Excel format?

Peter


We need to document our system, and we do not use vizio, so excel is the only alternative.
Im trying to do a database dictionary of all the relevant fields in all the relevant tables. I want to design excel in such a way that all fields can have a hyperlink (or something else) which allows them to automatically see the database dictionary definition by hovering or clicking. I was thinking about automatically launching the html one, but unfortunanately you can only open the page, not focus (and autoscroll ) onto the field definition.

So I have to do this the hard way.

Im a little bemused that theres no xml output, though - I would have thought the xml would have existed, and HTML page would have been created by running a transformation stylesheet over the xml.

Ah well. I suppose i could always create the xml myself using ....
SELECT objtype, objname, name, value
FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'table', 'claimmoney', 'column', default)
for xml auto, elements

... or something like that. Quite simple actually!

You guys should think about having an xml output option - nothing wrong with having raw, unadulterated data!
It would be easy after that - excel 2007 can open xml with no difficulty.

Anyway, thanks v much for getting back to me.
_________________
destination anywhere
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
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


Powered by phpBB © 2001, 2005 phpBB Group