Export Query results to CSV.

7 views
Skip to first unread message

Arber, Benjamin (Contractor)

unread,
Jul 13, 2009, 3:10:37 AM7/13/09
to semanti...@googlegroups.com

HI,
I would like to be able to export the results of an #ask query to a .csv file.  Is that possible? 

I know I can save the webpage as htm then open that in EXCEL and use a vb script to remove the formatting and parts of page that are not relevent but the ideal solution would be a "Save to CSV" button on the bottom of the query. 

Exporting specific pages does not export the xml-results of the query, just the wiki #ask text.

Does such an extension exist?

Thanks
Ben
--------------------
I am using: (from Special:Version)
MediaWiki 1.15.0
PHP 5.2.6-3ubuntu4.1 (apache2handler)
MySQL 5.0.75-0ubuntu10.2

Data Transfer (Version 0.3.1)
Semantic Drilldown (Version 0.5.7)
Semantic Forms (Version 1.7.1)
Header Tabs (Version 0.6.5)
Semantic MediaWiki (Version 1.4.2)
SemanticQueryFormTool (Version 0.2.5b)




IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914. If you have received this email in error, you are requested to contact the sender and delete the email.

 

Patrick Nagel

unread,
Jul 13, 2009, 3:19:36 AM7/13/09
to semanti...@googlegroups.com
Hi Ben,

On 2009-07-13 15:10, Arber, Benjamin (Contractor) wrote:
> I would like to be able to export the results of an #ask query to a .csv
> file. Is that possible?

That's a Semantic MediaWiki related question, nothing to do with Semantic Forms
(and thus the best place to ask would have been the Semantic MediaWiki user
mailing list [1]).

But I think I can help - have a look at the CSV result format [2].

Patrick.

[1]: http://sourceforge.net/mail/?group_id=147937
[2]: http://www.semantic-mediawiki.org/wiki/Help:CSV_format

--
Key ID: 0x86E346D4 http://patrick-nagel.net/key.asc
Fingerprint: 7745 E1BE FA8B FBAD 76AB 2BFC C981 E686 86E3 46D4

Reply all
Reply to author
Forward
0 new messages