Import-ID column in excel to update cards and avoid duplication

[andjar]

It would be wonderful to have a way to use a spreadsheet as a flatfile database - for example, to bulk create and modify cards. One way to sync the spreadsheet with postgres would be the import/export mechanism of memcode.

An extension of the import/export mechanism may be to add an optional ID column, so that if I upload an excel file with an import-ID column, the same ID can later be used to update the card and avoid duplication

[lakesare]

Hi! How would you benefit from it, is it because you'd like to create/update flashcards offline?

[andjar]

Hi! Sorry for my late reply, and thank you for your response. My suggestion is inspired by Ankify that does this for Anki; in your notes, you can write

<!-- This is the front -->
And all the text here is the back

and when Ankify adds it to Anki, it also adds an ID to the note to avoid duplications

<!-- This is the front b:1093-29fn-nfj3-0019 -->
And all the text here is the back

It seems quite nifty - writing a parser to convert the markdown to excel seems trivial - but I don't think this request needs high priority:)

[lakesare]

Price assignment (re: memcode#requesting-a-feature)

Id column for imports/exports: $60