+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: User Support (https://discussions.corebos.org/forumdisplay.php?fid=6)
+--- Thread: Export to csv columns from current filter (/showthread.php?tid=1823)
Export to csv columns from current filter - radu - 05-29-2020
When on a module, if you press export it will create a csv file with all the fields defined in that module. Is it possible to export only the fields(columns) visible in the filter?
Thanks
RE: Export to csv columns from current filter - joebordes - 05-29-2020
update, give it a try and let me know how it goes
RE: Export to csv columns from current filter - radu - 05-30-2020
(05-29-2020, 09:50 AM)joebordes Wrote: update, give it a try and let me know how it goes
Looks good!
I notice when you have certain fields in filter columns, the exported content gets scrambled. The header is ok. for example in Organization module, if you add Acc number field in the filter, it's value will became almost always the second one in the csv and the rest of the values are getting offset.
I attached some screenshots with the filter and the csv data.
If you adjust the filter and put the fields which generates the offset/scrambling(ACCNo in this case) in to the columns they seem to prefer(column 2 in this case) then data is correctly allocated. As a workaround.
Thanks
RE: Export to csv columns from current filter - joebordes - 05-31-2020
update and try again, I think I got it
thanks for informing!
RE: Export to csv columns from current filter - radu - 06-01-2020
(05-31-2020, 09:49 PM)joebordes Wrote: update and try again, I think I got it
thanks for informing!
Works great!
Thank You.