openfairdb
openfairdb copied to clipboard
Include all custom links in the export csv file
It would be helpful to just get all social links and custom links #278 in the csv download file of entries...
It's unclear how to flatten the custom links. There are several options and complications.
source
[
{ "url": "https://one.org?with=comma,bla%2C", "description":"one with a comma, and foo", "title":"1" },
{ "url": "https://two.org", "description":"two", "title":"2" }
]
CSV serialization
Variant A
custom-links-0-url | custo-links-0-description | custom-links-0-title | custom-links-1-url | ... |
---|---|---|---|---|
"https://one.org?with=comma,bla%2C" | "one with a comma, and foo" | "1" | "https://two.org" | ... |
Variant B
custom-links-urls | custo-links-descriptions | custom-links-titles |
---|---|---|
"https://one.org?with=comma,bla%2C,https://one.org" | "one with a comma\, and foo,two" | "1,2" |
Open questions
- how to encode
,
in urls and descriptions? - how to handle a large amount of columns in variant A?
I would say, Variant A is the only human handable format. (The same problem we might get when it comes to download ratings.) if we put these columns at the end of the spreadsheet, it does not matter how many columns there are. As an mvp we can limit the downloadable links to 7 or 10.