SID-01866: Get values from Twiki Tables from remote perl script (csv?)?

Status:	Answered	TWiki version:	5.1.3	Perl version:	5.8.8
Category:	CategoryPlugins	Server OS:	Centos	Last update:	10 years ago

We have many Twiki tables that are updated by manual edits, sometimes with the EditTablePlugin. It would be very useful to be able to extract the values from some of these tables for processing by perl scripts on a different host. Is there a way to have direct URL access to a csv export of a table's header and values so the perl Text::CSV module would parse them? If not, is there any similar paring of export/view and parsing module that would work for this operation? Or 3rd choice, something that could run locally on the twiki host to get the values?

-- Les Mikesell - 2014-02-03

Discussion and Answer

The blog on How to Export TWiki Data in CSV Format for Use in Excel, it works though on TWikiForms-based apps, not EDITTABLE. The search can be tweaked with multiple="on" to return just table rows in a topic.

-- Peter Thoeny - 2014-02-05

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- Peter Thoeny - 2015-12-03

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.