[XP] Character Data Exporter?

Started by Redd, February 10, 2014, 07:07:30 pm

Previous topic - Next topic

Redd

Hey, if someone could make this REALLY fast for me that would be so great!
I'm going pretty in depth with the planning in my game, and we plan over at my friend's house, who doesn't have RMXP. So after spending an hour typing up all of one character's stats in a spreadsheet, I figured that there had to be an easier way to do it.

If someone could make a script SUPER FAST for me that would read the game's character data and export all of the stats for every character at every level into even like a notepad document, that would be sooooooo nice. Credit in-game would be given for your help.

It would just be like at level 1, this character has 99 hp, at level 2, at level 3, etc etc etc.

Thank you so much! :D

Seltzer Cole

Quote from: Redd on February 10, 2014, 07:07:30 pm


Why are you collecting this data? You haven't even specified whether or not you messed around with the values of the parameters or not.
You know you play video games to much when you put sunglasses on and whisper "Plus 10 Appearance"

If at first you don't succeed, call it version 1.0

WhiteRose

Quote from: Seltzer Cole on February 11, 2014, 10:22:39 pm
Quote from: Redd on February 10, 2014, 07:07:30 pm


Why are you collecting this data? You haven't even specified whether or not you messed around with the values of the parameters or not.


I think that what he is looking for is either a script or standalone program that analyzes the Actors database file and converts it to CSV or some other spreadsheet format. It actually doesn't sound that hard to do; I'm pretty sure that RMXP scripts can write to the external file system, can't they?

G_G

February 12, 2014, 12:56:06 am #3 Last Edit: February 12, 2014, 03:03:53 am by gameus
Hmmm. Lemme see what I can whip up. It'll probably be an external ruby program, but if I can do what I want, then I can convert to CSV and from CSV.

EDIT: Here. Place this in your Projects Directory and it'll export the actor's data into a CSV file. However, I have yet to implement data importing, so you can't use option 2 yet.
http://jugglingcode.com/projects/csv_module.zip

This is what I used to view the CSV files and it worked pretty good.
https://sheet.zoho.com/excelviewer

Here's an example of the default actor data
https://sheet.zoho.com/view.do?url=http%3A%2F%2Fjugglingcode.com%2Fprojects%2Factors.csv

Whatever program you use, make sure you have the option to enable "multi-line fields". This program also puts the field names in the first row.

Still gonna work out some kinks and figure out a better way to export the actor's parameters. And also eventually add data re-importation and possibly include all data export/import.

WhiteRose

Quote from: gameus on February 12, 2014, 12:56:06 am
Hmmm. Lemme see what I can whip up. It'll probably be an external ruby program, but if I can do what I want, then I can convert to CSV and from CSV.

EDIT: Here. Place this in your Projects Directory and it'll export the actor's data into a CSV file. However, I have yet to implement data importing, so you can't use option 2 yet.
http://jugglingcode.com/projects/csv_module.zip

This is what I used to view the CSV files and it worked pretty good.
https://sheet.zoho.com/excelviewer

Here's an example of the default actor data
https://sheet.zoho.com/view.do?url=http%3A%2F%2Fjugglingcode.com%2Fprojects%2Factors.csv

Whatever program you use, make sure you have the option to enable "multi-line fields". This program also puts the field names in the first row.

Still gonna work out some kinks and figure out a better way to export the actor's parameters. And also eventually add data re-importation and possibly include all data export/import.


This is awesome, G_G! :D I can actually see this getting quite a bit of use. Once you get it polished up, you should make a dedicated thread for it.

G_G

Thanks! :3 Was actually just getting ready to post an update. This new version exports Actors stats in a separate file and dumps actors in their own individual files, rather than one file. Lot easier to browse and organize.

Also, this is now my recommendation for viewing CSV files. Free and portable. (Also supports first row field names and multiline entries)
http://www.nirsoft.net/utils/csv_file_view.html

If you use my program and the above CSV viewer, be sure to enable Options > First Line Contains Column Names.
Basic Actor Info: ShowHide

Actor Parameters: ShowHide


I think what I'm going to do, not sure, maybe I'll add it as a configurable option. But dump all the actors into one file and then dump their stats into individual files. Trying to think what will be easier for me to do when it comes time to re-import data.

Anyways, new download.
http://jugglingcode.com/projects/csv_module_0.2.zip

EDIT: I might end up posting my own thread lol.

Redd

Wow this is superb and it exactly what I asked for and more! Thank you very much good sir!