search

AncientSwordRage / nWoD-db

Web app for creating new world of darkness characters and browsing character data (Mage spells, vampire disciplines merits, etc)
1 stars 0 forks source link

Bulk Upload of spells #3

Open AncientSwordRage opened 9 years ago

AncientSwordRage commented 9 years ago

I have all the spells in a google drive spreadsheet and I'm not adding them one by one.

rozza2058 commented 9 years ago

http://www.mysqltutorial.org/import-csv-file-mysql-table/

On Wed, Feb 11, 2015 at 5:07 PM, AncientSwordRage notifications@github.com wrote:

I have all the spells in a google drive spreadsheet and I'm not adding them one by one.

— Reply to this email directly or view it on GitHub https://github.com/AncientSwordRage/nWoD-db/issues/3.

AncientSwordRage commented 9 years ago

@rozza2058 That's great for flat tables.

But I have a link table between Spells and Arcana with how that Arcana is used (primary, e.g. it's a Space spell, ergo it uses Space; secondary, e.g. Also needed, but not primary, for instance Mind; optional, e.g. Cool stuff happens when used in conjunction). So I need to do more processing. It would also be good to make this programmatic so that if I loose my database I can repopulate more easily.

Thanks for the heads up though.

rozza2058 commented 9 years ago

http://stackoverflow.com/questions/1293147/javascript-code-to-parse-csv-data

Create a gulp task to parse csv into javascript array which can be manually analysed to identify which values need to be links etc.

On Thu, Feb 12, 2015 at 10:32 AM, AncientSwordRage <notifications@github.com

wrote:

@rozza2058 https://github.com/rozza2058 That's great for flat tables.

But I have a link table between Spells and Arcana with how that Arcana is used (primary, e.g. it's a Space spell, ergo it uses Space; secondary, e.g. Also needed, but not primary, for instance Mind; optional, e.g. Cool stuff happens when used in conjunction). So I need to do more processing. It would also be good to make this programmatic so that if I loose my database I can repopulate more easily.

Thanks for the heads up though.

— Reply to this email directly or view it on GitHub https://github.com/AncientSwordRage/nWoD-db/issues/3#issuecomment-74049487 .

AncientSwordRage commented 9 years ago

@rozza2058 Or I could write it in python, I already have something very similar for putting all attributes, skills and arcanum on a new character. Also I have no idea what Gulp is.

rozza2058 commented 9 years ago

JavaScript > Python :P. Gulp is a JS based productivity/workflow tool. I use it to compile JavaScript, Less, HTML, upversion and push to production. But if you're Python-focused with Django it's probably worth doing it in Python.

On Thu, Feb 12, 2015 at 10:52 AM, AncientSwordRage <notifications@github.com

wrote:

@rozza2058 https://github.com/rozza2058 Or I could write it in python, I already have something very similar for putting all attributes, skills and arcanum on a new character. Also I have no idea what Gulp is.

— Reply to this email directly or view it on GitHub https://github.com/AncientSwordRage/nWoD-db/issues/3#issuecomment-74051952 .