Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Rochndil]

Good afternoon.

I'm contemplating yet another project (I know, I haven't finished the first one yet), and what I need is to translate the data for all the mineral/stone/soil raws into a CSV file. I can do the data-crunching the hard way, of course, but it'd be nice to have a faster (and less error-prone) method.

Suggestions?

Rochndil, dreading all that re-keying...

[Mephansteras]

I'd suggest using Perl for it. Assuming you know how to program, of course. Should be trivial to throw it all into a hash and get it outputted as a CSV.

[Rochndil]

Yah, IF I could program. I'm a tech writer, my only programming background was about a century ago when I studied Turbo Pascal 3.0 in my undergraduate days. I've heard of Perl, but never touched the beast.

Rochndil, who does have an MS, but in the wrong field...

[Great Cthulhu]

I'm feeling helpful today.

Let me know what you think.

[Rochndil]

Thank you very much!

I'll take it for a spin later on today. The next phase of my MMO (Metals and Minerals Overhaul) project is to set all the tile and color values for all the "in the ground" items based on some more logical rules. BUT, before I do that, I need to read out what things are NOW, and distill all that data into a spreadsheet. I could do it by hand (and actually started on the layout yesterday), but that's a lot of manual data-keying. CSV import won't be perfect either (since not all raws are in proper order), but it'll be a HELL of a lot better than doing it all by hand.

Thanks again, ancient dreamer!

You might want to check this http://www.macguff.fr/goomi/unspeakable/ out, when you want a chuckle.

Rochndil, who is almost ready for a beta release of phase 1...

[Great Cthulhu]

Hey, no problem. Just let me know if you run into any problems.

Thanks for the link!