View Full Version : HyperSpin File Checker MS Excel
gixxerrider73
12-01-2011, 08:40 PM
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.
Hypnoziz
12-01-2011, 09:06 PM
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
Very cool, I'll give it a whirl when I get a minute.
xagesz
12-02-2011, 04:38 AM
Genius. I will no longer be frustrated trying to figure out what I am missing.
gixxerrider73
12-02-2011, 07:13 PM
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
12-02-2011, 09:59 PM
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).
And I have Excel, just not installed (yeah I'm THAT lazy all the time).
Fixed it for you.
Hypnoziz
12-03-2011, 12:11 AM
Suck it, djvj! :p
keno21176
12-04-2011, 12:00 PM
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
keno, does openoffice support VBS? If not, then no.
keno21176
12-04-2011, 04:41 PM
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
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
12-04-2011, 08:31 PM
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?
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!
There are a number of tools like this already, each has their own pluses and minuses.
keno21176
12-05-2011, 01:30 PM
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