Can I bulk add flashcards from Excel?

Submitted by Pauliina_10 on Thu, 05/17/2018 - 09:02
Forums: 
Content creation

Hi,

Is it possible to bulk add data from Excel to make flashcards?

 

Content types: 
Flashcards
BV52's picture

BV52

Fri, 05/18/2018 - 03:28

Hi finkingcap,

I'm afraid this is not possible.

-BV52

serettig's picture

serettig

Mon, 05/21/2018 - 21:21

Hi,

depending on how far your technical knowledge goes, you can use the tool I wrote for this purpose (still work in progress). It's written in NodeJS and you'll find it at GitHub. It expects CSV files with the headings 'question' and 'answer' that are separated by semi-colons. Optionally, you can specify columns with 'tip' and 'image' (urls). The actual creation process works, but it's not possible to pass in parameters at the command line, as there are some issues with a libraries I'm using that need to be fixed. So you'll have to replace the 'test/flash1.csv' file with your file and it will always emit 'test.h5p'.

BV52's picture

BV52

Tue, 05/22/2018 - 04:02

Thank you for the suggestion serettig.

serettig's picture

serettig

Wed, 05/23/2018 - 22:35

I've worked on this a bit and now you can actually properly start the program from the command line. These are the steps to run it:

  • install NodeJS
  • clone the repository
  • in the command-line at the directory you've cloned the repository into:
  • run npm install
  • run npm run build
  • run npm run h5p-creator --help and npm run h5p-creator flashcards --help to see what options you can specify.
  • example: npm run h5p-creator flashcards ./myflashcards.csv ./outputfile.h5p -l=de -n="Meine Karteikarten"

It will download a fresh copy of the current Flashcards module from the H5P hub, parse the CSV file and put its content into the specified output file. I know running this is a bit technical, but if you've got lots of content to convert, I guess it's worth the effort to get this running.

Shake

Fri, 06/03/2022 - 17:47

Hi serettig, 

did you ever make any new updates to this project? are you available for paid consultation? i want to bring you idea more to life.

 

afarough

Fri, 01/22/2021 - 17:55

Hi,

I have a handful of  large excel question data sets that I'm going to need your help with converting that using your GitHub code. Are you interested?

 

willip521

Thu, 08/22/2019 - 16:42

I have been trying to convert a csv to h5p using the cli-creator tool mentioned above. The github install instructions and commands are easy enough to execute. I get the output.h5p file as specified on github but when I go to import it into wordpress the file does not validate! Even extracting the archive files and changing a single question/answer by hand throws dozens of failed validations when uploading.

What am I missing here???

Has there been an update to h5p that makes the cli-creator obsolete? 

I have tens of thousands of flashcards that I would like to import and doing this all by hand is out of the question. Please help!

studyaid's picture

studyaid

Sun, 10/06/2019 - 22:57

How are you compressing your zip file?  What OS or command line switches are you using?  Depending on what you are using I can give you the commands that should work.

serettig's picture

serettig

Mon, 01/25/2021 - 09:03

Hi afarough,

you can use the tool on GitHub, but I'm afraid I have my hands full at the moment, so I won't be able to fix issue that might have occured since I released it.

Sebastian

lucytallents

Wed, 09/15/2021 - 12:36

Hi Sebastian,

Thanks for creating this useful CLI!  I'd love to contribute to its further development - I can see so much potential for adding new content types.  I don't have NodeJS skills myself, but I could invest in working with you, someone you recommend if you're too busy, or a contractor (who is unlikely to be familiar with H5P) to develop my fork on GitHub, submitting PRs to you once new functionality is tested.  What's your preferred way forward?

Best wishes, Lucy

lucytallents

Wed, 09/15/2021 - 12:38

Hi Sebastian,

Thanks for creating this useful CLI!  I'd love to contribute to its further development - I can see so much potential for adding new content types.  I don't have NodeJS skills myself, but I could invest in working with you, someone you recommend if you're too busy, or a contractor (who is unlikely to be familiar with H5P) to develop my fork on GitHub, submitting PRs to you once new functionality is tested.  What's your preferred way forward?  You can reach me on lucy dot tallents at verdantlearn dot com

Cheers, Lucy