Гость
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

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


Sackgesicht VIP
Total posts: 1,636
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,636
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,636
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,748
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,748
05 Янв 2013 09:42

I think the example of sackgeshist will work.


pepperstreet VIP
Total posts: 3,837
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.


kennedystewart
Total posts: 1
07 Июль 2022 10:03

Thank you for the practical and easy-to-understand solutions from admin. Hope our forum grows more and more ^^ drift boss


AprilHull
Total posts: 3
21 Сен 2022 04:20

Гость thank you for your answer,

I know a little sql, I try all developed its own, pacman 30th anniversary 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)

Я такой же, как и вы, но кажется, что у операций где-то проблемы.


xeniat
Total posts: 8
25 Сен 2023 09:34

Whether you're a casual gamer looking for a quick escape 2048 cupcakes or a dedicated enthusiast seeking epic adventures, the world of gaming has something to 2048 cupcakes unblocked offer for everyone."


lindamartn15
Total posts: 6
28 Сен 2023 07:49

Thank you for this answers. I finally understand it now. credit repair annapolis


Sam William
Total posts: 1
24 Нояб 2023 07:05

For more specific guidance, consider providing details about your tech stack, the platform you're developing on, and any specific frameworks or libraries you are using. Commercial Mechanic Near Me


jendy henna
Total posts: 2
27 Янв 2024 08:59

The faster the descent, the higher Snow Rider the score. Successfully avoiding obstacles and executing tricks also contribute to point accumulation.


aserty Anastasyia
Total posts: 23
12 Март 2024 19:42

Sinceramente, personas en el mundo les encanta jugar a los casinos online. Si no quieres perder tu tiempo en investigaciones inútiles sólo tienes que visitar el casino Spin City casino y hacerte con tus bonos.El único casino que puedo recomendar es ESTE casino porque la gente confía en él. No podía creer que pudiera ganar https://spin-sity.com/es-cl/ dinero con la diversión. Además, es increíble que no tenga que trabajar durante todo el día para tener suficiente dinero.

Работает на Cobalt