openfairdb icon indicating copy to clipboard operation
openfairdb copied to clipboard

Include all custom links in the export csv file

Open wellemut opened this issue 3 years ago • 2 comments

It would be helpful to just get all social links and custom links #278 in the csv download file of entries...

wellemut avatar Sep 25 '20 07:09 wellemut

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?

flosse avatar Dec 21 '20 16:12 flosse

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.

wellemut avatar Dec 21 '20 23:12 wellemut