Гость
13 Нояб 2012 08:22

hello,

I would like to give the possibility to export the tables data (with options as the current table, or all fields, if possible)

in Excel / pdf ..

how can I do? have a plugin, documentation or an API?

thank you

Последние изменения: 07 Март 2025


Sackgesicht VIP
Total posts: 1,626
13 Нояб 2012 08:56

Netcom91,

Cobalt 7 does not provide this functionality.

You might have to develop or get a 3rd party plugin for this.


Sackgesicht VIP
Total posts: 1,626
13 Нояб 2012 09:08

Here an example how to create a query to get a TYPE into a nice export format (1 Type with 1 text field and 1 date field)

Select `title`,

(select `field_value` from `#__js_res_record_values` where ( (`field_id` = 1) and (`record_id` = `a`.`id`) ) ) AS `Field 1`,

(select DATE_FORMAT(field_value, '%d-%b-%Y') from `hsb0a_js_res_record_values` where ((`field_id` = 3) and (`record_id` = `a`.`id`) ) ) AS `Date`

from `#__js_res_record` `a` 

where (`bla bla bla condition') 

Гость
13 Нояб 2012 11:10

thank you for your answer,

I know a little sql, I try all developed its own, the problem is that I lack the basis for starts, I do not know where and what files I should write my code, and retrieve information about the page (just retrieve the elements chosen in relation to the current page, not export all records)


Sackgesicht VIP
Total posts: 1,626
13 Нояб 2012 17:18

try to see the tutorials here,

You will find the information you need to start your own development there.


Sergey
Total posts: 13,688
13 Нояб 2012 19:21

Please try to explain what you need to get. Just briefly what you have and what you need to get into the report.


Гость
14 Нояб 2012 02:22

Exactly, it is a project relationships, members probably want to export datas.

text fields (part name, quantitiy, phone ..), what the user can see here an example of a table with jQuery: http://www.datatables.net/extras/tabletools/


Гость
22 Нояб 2012 16:04

have news?


Sergey
Total posts: 13,688
05 Янв 2013 09:42

I think the example of sackgeshist will work.


pepperstreet VIP
Total posts: 3,832
07 Янв 2013 02:53

In fact he even managed to migrate from Resources to Cobalt. :)

Article, Article, Article !

Or even better and a-must-have: import/export in Tools for Cobalt 7 & 8.

Работает на Cobalt