thatman84 Posted June 30, 2016 Posted June 30, 2016 Im view only on the main sheet i think. Im currently doing that themes spread sheet with links to everything so I can do that if i get access. I will just fill out the themes one im doing. Only have consoles and Handhelds to do. Let me know Omega Hyperspin 2.0 Latest Download Hyperspin 2.0 Documentation -------Pre Hyperspin 2.0 Below---------- HS Android Overview & Install HS Android Base Pack Download My Tutorials
JSinn Posted June 30, 2016 Posted June 30, 2016 Im view only on the main sheet i think. Im currently doing that themes spread sheet with links to everything so I can do that if i get access. I will just fill out the themes one im doing. Only have consoles and Handhelds to do. Let me know Omega Alright brotherman 84 you should be a able to edit the main sheet and welcome aboard. |Visit my [YouTube] channel || My projects - [Downloads] || GameCube HQ Disc Project || GameCube HQ Disc Progress || HyperSpin United Spreadsheet |
thatman84 Posted June 30, 2016 Posted June 30, 2016 Updated Main Menu Wheel download links for Arcade systems Im a bit tired but noticed that Technos is not in Hyperlist or spreadsheet but is in the downloads I hylighted the ones on Hyperlist that dont have a download section also Hyperspin 2.0 Latest Download Hyperspin 2.0 Documentation -------Pre Hyperspin 2.0 Below---------- HS Android Overview & Install HS Android Base Pack Download My Tutorials
adamg Posted July 1, 2016 Posted July 1, 2016 On the google doc that you guys are keeping, you could link the more up to date databases there. And to give an update on what I have been working on. I have not had much time, I am nearing a release for my arcade business BUT I am writing vb code in excel to generate a list similar to what is shown on the google docs based on what media we might have in our folders. This will allow me to create it in the format that I want and easily allow anyone else who might want to use it to see what the have. Kind of like an audit program but better for analysis. Will upload it soon if anyone is interested. If anyone is interested, I am making retropie based arcade control panels that plug directly into hdmi. This is what is taking most of my time at the moment unfortunately. http://imgur.com/a/sgb1U
diskmach Posted July 1, 2016 Posted July 1, 2016 If anyone is interested, I am making retropie based arcade control panels that plug directly into hdmi. This is what is taking most of my time at the moment unfortunately. http://imgur.com/a/sgb1U Heck, that seems advanced,man! I have a Retropie setup, I'm using wired Snes USB pads. But maybe this would be something... Nintendo 3DS wheels thread || Nintendo 3DS wheel set download Bandai Wonderswan Color wheels thread || Bandai Wonderswan wheels thread NEC PC Engine wheels COMPLETED || Nintendo Wiiware wheels COMPLETED
JSinn Posted July 1, 2016 Posted July 1, 2016 On the google doc that you guys are keeping, you could link the more up to date databases there. And to give an update on what I have been working on. I have not had much time, I am nearing a release for my arcade business BUT I am writing vb code in excel to generate a list similar to what is shown on the google docs based on what media we might have in our folders. This will allow me to create it in the format that I want and easily allow anyone else who might want to use it to see what the have. Kind of like an audit program but better for analysis. Will upload it soon if anyone is interested. Eventually there will be links to all the databases, but this is a giant WIP and will take some time. Some type of list for all the media that you have is interesting to me. |Visit my [YouTube] channel || My projects - [Downloads] || GameCube HQ Disc Project || GameCube HQ Disc Progress || HyperSpin United Spreadsheet |
adamg Posted July 1, 2016 Posted July 1, 2016 I used the official databases. I currently do not have a way to easily show what I got from the sync. I'm writing the spreadsheet but suggestions are appreciated.
JSinn Posted July 1, 2016 Posted July 1, 2016 I used the official databases. I currently do not have a way to easily show what I got from the sync. I'm writing the spreadsheet but suggestions are appreciated. Not really sure, we're all kind of learning as we go. Maybe a spreadsheet for each system/console with each of the media types? |Visit my [YouTube] channel || My projects - [Downloads] || GameCube HQ Disc Project || GameCube HQ Disc Progress || HyperSpin United Spreadsheet |
diskmach Posted July 1, 2016 Posted July 1, 2016 There's an article over at How to geek, if that's what you're talking about? http://www.howtogeek.com/98064/how-to-print-or-save-a-directory-listing-to-a-file/ Nintendo 3DS wheels thread || Nintendo 3DS wheel set download Bandai Wonderswan Color wheels thread || Bandai Wonderswan wheels thread NEC PC Engine wheels COMPLETED || Nintendo Wiiware wheels COMPLETED
adamg Posted July 1, 2016 Posted July 1, 2016 Not really sure, we're all kind of learning as we go. Maybe a spreadsheet for each system/console with each of the media types? Yeah that is what I am currently working on. I have all of that figured out. What I am struggling with is that each system tab has a dynamic list of game names based off of the xml found in the database folders. I am having a difficult time comparing the range of game names against the available files and outputing the comparison to columns for each type of artwork (artwork1, artwork2, themes, wheels, videos... etc). So basically my spreadsheet allows you to import your main menu list, create sheets for each system in your main menu, import all of the games from the database and find all the files in the artwork folders in the media section of hyperspin. Now I need the vb code to compare the game names against the media files. Something like this: game names artwork1 does Artwork1 exsist asteroids asteroids.png yes
Suhrvivor Posted July 1, 2016 Posted July 1, 2016 I'm currently working on video snaps for the Nintendo Wii U, I've done like 40 so far and I have another 80 low quality ones I've found on the web (they are random raw 35 seconds from a trailer, will be replaced eventually with better ones), since most games are not playable on PC at the moment, I use gameplay videos and gamplay trailers of the highest quality I can find to do them (mostly from Gamersyde. Youtube for Nintendo games since they seem to not allow anyone else to host their videos ). I was thinking about sharing them at some point, should I upload them to Emumovies FTP, Hyperpin FTP or HyperVault? I also have the source videos and vegas files, in case of someone wanting to edit them.
Circo Posted July 1, 2016 Posted July 1, 2016 Feel free to throw them up on the EM FTP till we get the official sets done Sent from my iPhone using Tapatalk ___________________________________ HyperSpin Website Admin Team Also Visit EmuMovies.com
SeanDyer87 Posted July 1, 2016 Posted July 1, 2016 There's an article over at How to geek, if that's what you're talking about? http://www.howtogeek.com/98064/how-to-print-or-save-a-directory-listing-to-a-file/ I actually made/posted a batch script that does bassically this it's posted a page or 2 back
thcdgaf Posted July 1, 2016 Posted July 1, 2016 Well I been out of commission for awhile I'll be working with this when I get setup in effingham soon after this doctor crap for rotator cuff got few projects I'm going get done also including Retroarch tutorial not video but step by step its halfway completed and I'm from wiiflow team I know they got their HQ covers from hyperspin and I was away because of narcolepsy so now on nuvigil I'm in better shape since then...I use gimp2 its open source for art similar to Photoshop but it's free...my favorite price I'll help what I can but real contribute be when I'm down south...happy hyperspinning
xALPHAxOMEGAx Posted July 1, 2016 Author Posted July 1, 2016 sorry guys the last 2 days my nephews have been sleeping over and i dont like to do boring stuff while they are here ill be getting a bunch of work done when they leave probly tomorrow sorry again and thank you for all the hard work guys! well get things up and running were making great progress -Your Friendly Neighborhood Scrub HyperSpin Community United HyperSpin United Spreadsheet xALPHAxOMEGAx Universal Theme "DarkSide" (W.I.P) on hold or discontinued idk Vector Logos, Consoles, Controllers, Handhelds Project
thatman84 Posted July 1, 2016 Posted July 1, 2016 Adamg I'm interested in your audit spreadsheet. What are the audit options ATM for Hyperspin . I have never used or done one. Is it Hypertools I saw a post about here? Hyperspin 2.0 Latest Download Hyperspin 2.0 Documentation -------Pre Hyperspin 2.0 Below---------- HS Android Overview & Install HS Android Base Pack Download My Tutorials
adamg Posted July 1, 2016 Posted July 1, 2016 Ok, I have completed the base of my spreadsheet, I need to add functionality so that other people can use it (like choosing your hyperspin directory instead of defaulting to mine). I need to figure out the best way to format the output but I am happy with the way it builds itself. When I run 1 system it does not take long, maybe a couple of seconds but I am dreading the moment I do it for all 196 official systems... Here is my current output:
adamg Posted July 1, 2016 Posted July 1, 2016 Initial run of all 196 systems took 8:01:60 minutes. That is not terrible considering how many files it processed. I think I can clean up some code though which may increase speed.
thatman84 Posted July 1, 2016 Posted July 1, 2016 Was that from the hypersync only media? Hyperspin 2.0 Latest Download Hyperspin 2.0 Documentation -------Pre Hyperspin 2.0 Below---------- HS Android Overview & Install HS Android Base Pack Download My Tutorials
adamg Posted July 1, 2016 Posted July 1, 2016 No, I have since decided that I need to do it that way though. I used my existing folders and did not think about it till after the fact. I plan or redoing it minus videos in the near future. Trying to finish the spreadsheet first. Will resync media tonight.
adamg Posted July 1, 2016 Posted July 1, 2016 A few questions/suggestions, but disclaimer: I've only used HyperSync once to verify something wasn't broken for a member. It seems like the Y and Z columns are redundant since any files that match the db will have the same name so I don't think they would be needed. From what I understand you can download boxes and carts to any of the Artwork folders. So when you're downloading as an audit of HSync it would probably be best to designate 2D boxes to Artwork 1, 3D carts to 2, 2D carts to 3, etc. and name those columns to reflect the media type not artwork number. Feel free to correct me if I'm wrong in my assumptions of HSync or what you're trying to accomplish with the sheet. Y and Z, and AA, AB, AC, AD, AE that you cannot see are outputs of what is located in each media folder. While unimportant for output, very important for checking to see what I have. Checking could be done by not writing to the file BUT I want it there so that I can identify things that are not needed by checking each file against the database, a reverse of the other check I guess. If for instance I have a file in the Wheel folder named GAMENOTONDATABASE, I can find that easily and remove it from the folder. I think we should come up with a standard as you purpose. I like what you have. I will set that in sync and rerun. I used all defaults with the run I did the other day. I think my initial run took so long because of videos so I will forgo syncing them again but will update later this evening. Spreadsheet now calculates percentages on a totals page. Nothing is pretty yet but everything is functioning as intended.
KlopjerO Posted July 1, 2016 Posted July 1, 2016 One bottle of wine later Sent from my SM-A700FD using Tapatalk | My themes / downloads | Get the MS-DOS Wheel sound pack | Get your MS-DOS game themes here | Get the MS-DOS wheel set here | My YouTube channel | WarcrafT - Lord of the clans |ZeroJay's Ultimate DooM archive
JSinn Posted July 1, 2016 Posted July 1, 2016 I like what your doing adamg, very impressive! A question, how do we know which type of media is in each artwork folder? Usually Artwork3 and 4 are reserved for game boxes and carts/discs and vise-versa. |Visit my [YouTube] channel || My projects - [Downloads] || GameCube HQ Disc Project || GameCube HQ Disc Progress || HyperSpin United Spreadsheet |
JSinn Posted July 1, 2016 Posted July 1, 2016 Today I'm going to continue my sort of the WiiWare wheels. WiiWare Wheel Progress WiiWare Wheels Thread I made a lot of headway with the wheels yesterday and I should have a lot of goodies to post up today. |Visit my [YouTube] channel || My projects - [Downloads] || GameCube HQ Disc Project || GameCube HQ Disc Progress || HyperSpin United Spreadsheet |
adamg Posted July 1, 2016 Posted July 1, 2016 Yeah agent47 pointed out the same. What I am going to do for the sync is assign 2d carts/dics to artwork1, 3d carts to artwork2, 2d Box art to artwork3 and 3d Box art to Artwork4. That will be the standard that I use. I know that different themes use media differently but for the sake of completion I am just going to stick with that for now. Advise if this is a bad idea.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.