Exportation Print/PDF/CSV + Notes

Hi Babynus,

I'm working on the export functionality of Project'Or RIA and I had one proposition, one remark and one question.

PROPOSITION :

I made a dialog that pops up when you try to print/PDF/CSV on objectList.php.
This dialog proposes to choose the colomn you want to see in your print/PDF/CSV.

The idea comes from the lack of some infos when they are not in the model layout.

If you are interested, I can introduce it more to you with screenshot and .. text..

I was thinking of creating a XLSX export thingy too..

REMARK :

When exporting as a PDF, it seems that it does not take all the page width ... Columns are thin whereas when printing then the table takes all the page (sometimes more when it's to much ^^)

It is a bug ?

QUESTION :

I want to be able to export Notes as well as other column.. do you think it is possible with, for example, the jsonQuery.php ?



Have a good week end.

I made a dialog that pops up when you try to print/PDF/CSV on objectList.php.
This dialog proposes to choose the colomn you want to see in your print/PDF/CSV.
The idea comes from the lack of some infos when they are not in the model layout.

Good idea.
I don't thing it is a real lack for CSV, as every data is exported.
But this could be a good improvement, and to keep the as-is behavious, maybe an automatic "check all" could be good.
Just pay attention to access rights. For instance some profiles may not see work or cost...

There is already a check all and uncheck all boxes
And I made a new table to store previous checkboxes configuration as soon as my customized datas have a lot of possible column and the operator could be bored to check his own config..
Today, it stores the config for everyone per model, but it can easily be done per user too.

I did not at all work on accessright .. because my own datas do not have such problem. But I guess I could add it and check when checkboxes are build. I'll investigate.

If you are interested, I can introduce it more to you with screenshot and .. text..

Yes please

When you click on extract buttons, this pops ups : (here for status)

I think it speacks for itself (at least for french readers..)
I am thinking of adding th section information to organize the window a bit more..

If you try to extract more than 200 data this shows up :

I added this because I think that it is unrealistic to extract that much of data..

Of course, every texts are translated by il18n().

Print window is unchanged.

I was thinking of creating a XLSX export thingy too..

Another good improvement

Only thinking ^^

When exporting as a PDF, it seems that it does not take all the page width ... Columns are thin whereas when printing then the table takes all the page (sometimes more when it's to much ^^)
It is a bug ?

I don't really understand what you mean.
Possibly some unexpected behavious depending on screen resolution ?
if you have any example / print screen ...

Two images to show my problem.
When I extract Status I have those two results : (with the same input layout)
With Print :
With PDF :

I don't really understand why the table does not takes all the page in the pdf extraction.. I would have if it was also in the print view.. but..

I want to be able to export Notes as well as other column.. do you think it is possible with, for example, the jsonQuery.php ?

Well, jsonQuery won't be an issue, but it will be to export as CSV or XSLS : and don't see how you'll export several notes in one only line

If I can print it in one column like a basical varchar I'll be happy ^^
My operators have some particular way of using notes so perhaps should I make my own notes.. like a new field...

Annnh... And my happiness is gone..

I actually thought that the width parameter worked like print, and did not care too much about it ^^

So yes, when I create the export Layout, it has its own witdhs..



OK, I think I have a solution...



And problem solved

Very interresting these developments!! Congratulations.

Another point would be interresting: Add possibility of extracting data to import.

1. Do not write the name (project, type, ...), but the IDs
2. Set the first line in the correct import format

This will have the advantage of being able to do extractions, make the changes to the file and import effortlessly.

Thanks