Jump to content
(Public Beta) HyperSpin 2 is now available for everyone ×

HyperSpin File Checker MS Excel

gixxerrider73

Recommended Posts

gixxerrider73 Newbie

gixxerrider73

Posted
Posted

I'm pretty new to Emulators and Hypersin and love it. I found it frustrating to get my file names in sync between the Database, ROMS, Videos, Snaps etc.

I created a tool in Microsoft Excel that reads the xml files, creates a list of games, then shows you the status of the ROMS, video clips etc to see if they all match. If one doesn't match you can simple check the file name to see if it exists or just needs to be renamed. I have uploaded a screen shot. It is very easy to you. You can create a sheet for each system to keep track of your roms, media etc.

If you want to try it out, I uploaded it to virtualelevators.com/HyperFileChecker1.1.zip or send me your e-mail address and I'll send it to you. I would like to get some feedback on how useful people think it is and other possible features to add.

post-38467-14287057386_thumb.jpg

Hypnoziz Explorer

Hypnoziz

Posted
Posted

And this is your FIRST post here on the forums? Well then...I commend you!

It must have been quite painstaking to create this all in Excel. I'm curious to see what people say if they get around to testing it. I don't have Excel installed at the moment, otherwise I'd give it a whirl. Thanks for the contribution. :D

<em class='bbc'>"But does one ever truly have a choice? One can only match, move by move, the machinations of Fate, and thus defy the tyrannous stars."</em>

djvj Collaborator

djvj

Posted
Posted

Very cool, I'll give it a whirl when I get a minute.

"Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."

RocketLauncher's Official Home

If you appreciate my work:
donate_button.png

My Apps:
Window Logger
Idle Volume Adjuster
ExplorerRestorer
Rom Folder Cleaner
Module Updater
My Guides:
How To Mod Guncons with Aimtrak

gixxerrider73 Newbie

gixxerrider73

Posted
  • Author
Posted

Hypnoziz, Thanks for the reply. I never really thought about this being my first post. I plan to add features to this tool. too bad you don't have excel yet

This was created using VBA - Visual Basic for applications which is part of MS Office. I could easily create a few ASP - Active Server Pages to do the same thing. You would need to setup IIS - Internet Information System which is a webserver built into windows.

One feature I'm going to add is the ability to rename ROMS. For example I had a bunch of ROMS with (U) in the name where the database has (USA) in the name. The program would replace the (U) wtih (USA) so it matches the database files.

I'm no expert programmer by anymeans but know enough to get by.

Please let me know if you try it and how it works. Let me know what could be different or added to it.

I'm not good with grphics to create themes. I wanted to contribute something to the cause. If this is well received then I could spend the time to create a stand alone application for all to use. This would take awhile to create though.

Hypnoziz Explorer

Hypnoziz

Posted
Posted

Well hey, I'm glad you put it out there. Of course it's been well-received.

And I have Excel, just not installed (yeah I'm THAT lazy at times).

<em class='bbc'>"But does one ever truly have a choice? One can only match, move by move, the machinations of Fate, and thus defy the tyrannous stars."</em>

djvj Collaborator

djvj

Posted
Posted

And I have Excel, just not installed (yeah I'm THAT lazy all the time).

Fixed it for you.

"Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."

RocketLauncher's Official Home

If you appreciate my work:
donate_button.png

My Apps:
Window Logger
Idle Volume Adjuster
ExplorerRestorer
Rom Folder Cleaner
Module Updater
My Guides:
How To Mod Guncons with Aimtrak

Hypnoziz Explorer

Hypnoziz

Posted
Posted

Suck it, djvj! :P

<em class='bbc'>"But does one ever truly have a choice? One can only match, move by move, the machinations of Fate, and thus defy the tyrannous stars."</em>

keno21176 Newbie

keno21176

Posted
Posted

would it be a dumb question to ask if this app has compatability with Openoffice Calc, for those folks like myself who are too cheap to buy Excel and/or too lazy to pirate it?

K

djvj Collaborator

djvj

Posted
Posted

keno, does openoffice support VBS? If not, then no.

"Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."

RocketLauncher's Official Home

If you appreciate my work:
donate_button.png

My Apps:
Window Logger
Idle Volume Adjuster
ExplorerRestorer
Rom Folder Cleaner
Module Updater
My Guides:
How To Mod Guncons with Aimtrak

keno21176 Newbie

keno21176

Posted
Posted
keno, does openoffice support VBS? If not, then no.

Presumably the answer is no, because I fired up the XLS in OO anyway ("what could possibly go wrong?" ;) ). it did load but once I clicked one of the browse buttons, I got a scripting framework error.

since I'm just a "standard user" as opposed to a "power user" when it comes to OO (or pretty much any program for that matter :o ) I dont know nuthin bout VBS/VBA and whether it can be added to OO via some kind of patch or addon? something to look into, I guess

K

Rain Enthusiast

Rain

Posted
Posted
would it be a dumb question to ask if this app has compatability with Openoffice Calc, for those folks like myself who are too cheap to buy Excel and/or too lazy to pirate it?

K

OpenOffice.org does support VBS, C#, C++ scripting if you install and configure the UNO runtime environment. I use Linux as my desktop distro and do a lot of work with OpenOffice. If you need help setting up, I'd be glad to help. Thanks a lot!

:D

gixxerrider73 Newbie

gixxerrider73

Posted
  • Author
Posted

Keno, djvj is correct. This file uses Macros or VBA (Visual Basic for Applications). If it can run MAcros then it should work.

I would be interestd to see how many people are intereted in this. I could create this as a stand alone program in Visual Sudio. Although I'm not nor do I claim to be an expert programmer so it would take me sometime to create it in Visual Studio. I own Visual Studio, just need the time to develope it.

Are there other tools out there that already do this?

Rain Enthusiast

Rain

Posted
Posted
Keno, djvj is correct. This file uses Macros or VBA (Visual Basic for Applications). If it can run MAcros then it should work.

I would be interestd to see how many people are intereted in this. I could create this as a stand alone program in Visual Sudio. Although I'm not nor do I claim to be an expert programmer so it would take me sometime to create it in Visual Studio. I own Visual Studio, just need the time to develope it.

Are there other tools out there that already do this?

I for one would like to see this ported over to a standalone application. I would find it very useful (as would many of the community I would assume.) I love utilities, and there are no shortage of them out there - but out of the many there are very few that I would ever use; but I could see myself using this one for sure!

Keep up the good work on this project!

djvj Collaborator

djvj

Posted
Posted

There are a number of tools like this already, each has their own pluses and minuses.

"Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."

RocketLauncher's Official Home

If you appreciate my work:
donate_button.png

My Apps:
Window Logger
Idle Volume Adjuster
ExplorerRestorer
Rom Folder Cleaner
Module Updater
My Guides:
How To Mod Guncons with Aimtrak

keno21176 Newbie

keno21176

Posted
Posted

true.

Hypersync is pretty simple to use, but the simplicity can also be its downfall, its pretty easy to double-click the wrong thing and hose a filename, maybe without even realizing it. Plus the way it stays always on top is kind of annoying

Hyperspin XML bidouleir (sp?) is promising and seems very feature rich but I'm personally not a fan, i found it a little non-user friendly with orphan files and tolerances and all that stuff. I had tried it to rename some neogeo cd media from old tosec to new hyperlist and was not very successful

so, i'm all for another entry in the database management realm. it tends to promote innovation.

@ Rain:

I'm a little confused about how to get the UNO environment. According to OO dev website:

"The UNO Runtime Environment (URE) used to be available as an individual download, but today is only available as the URE layer within a complete OpenOffice.org download"

I'm currently using the regular ole stable Win32 release 3.2.1, do I have it already and just need to enable or do I need to get a different release?

K

  • 8 months later...
  • 1 month later...
gixxerrider73 Newbie

gixxerrider73

Posted
  • Author
Posted

I've been working on a stand alone version of this. I'm almost ready to publish it. It should be out this week. If anyone would like to volunteer to be a beta tester before I release it to everyone, I would really apprciate it. Send mye a private message and I'll send you a link to where you can download it.

I think I've added some really nice features for manageing your media files. One feature I've included is the ability for the app to update via the web without the user downloading a zip file. This will make adding features to the app pretty easy and painless to the user to get the updates. I now call this utility HyperMedia. I hope if will be usefull to many people.

Thanks,

Jay

richardbmw Newbie

richardbmw

Posted
Posted

Hi Gix. I just downloaded the excel sheet and it seems to be just what I needed.

One thing I have noticed though is that it audits image files but doesnt have an option to select and image folder.

It has options to select rom, video, wheel and misc locations but not image and the audit results have video, video, image, wheel and misc.

Other than that I love where this is going and I wish I had the skills to create something like this

gixxerrider73 Newbie

gixxerrider73

Posted
  • Author
Posted

Richard,

Thanks for the feedback, Could you post an image of your fodlerstructure for the images? Is it different than the standard Hyperspin structure? I haven't worked on the Excel Version of this tool for some time. I'm working on a stand alone software for windowss that has the same functions and more. I hope to post it in the next week. Thanks, Jay

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...