search

creecros / MetaMagik

Custom Fields for Kanboard - Plugin MetaMagik
MIT License
98 stars 16 forks source link

Export functionality #9

Closed TheCloud closed 6 years ago

TheCloud commented 6 years ago

I was thinking how to manage the export.

Currently Kanboard export feature saves all TAGs into a single CSV cell with comma separated values, so it's very hard to group them using Excel filters.

For Metadata I was thinking to extend the current export table with a column for each metakey. If Metaval <> empty then it's populated, otherwhise a "null" value is inserted so the CSV is respected.

What do you think ?

creecros commented 6 years ago

Im fine with whatever here. Hadn't even thought about it tbh. This something you are going to work on?

TheCloud commented 6 years ago

Yes - if you could share your thoughts on how to report Inwould appreciate

creecros commented 6 years ago

I agree, but if I rewrite the code to not include empty meta data in task_has_metadata, then there won't be empty values.

I think there should be empty values, if we are treating these as custom fields.

creecros commented 6 years ago

Columns aren't going to line up either. Actually aren't going to line up if one task has extra meta data defined from the previous portion of the plugin.

creecros commented 6 years ago

This now works, just sorting out the columns, I'm making it so it only exports custom fields, not any extra metadata defined somewhere else. This is because, The fields would never lineup with the data without extensive amounts of code, that I'm not really wanting to write.

creecros commented 6 years ago

oh, it's in the export branch for testing

creecros commented 6 years ago

Works perfectly. Merged to master.