User Tools

Site Tools


game_import_setup

Differences

This shows you the differences between two versions of the page.


game_import_setup [2023/09/05 15:35] (current) – created pinupadmin
Line 1: Line 1:
 +====== How to import metadata for your games ======
 +
 +There are two ways to import game metadata (year, manufacturer etc.). You can use '**Web lookup'** to fetch the information directly from the internet, or alternatively import a puplookup database file. For '**Web lookup, **skip straight to step C.
 +===== How to import and use a puplookup.csv DataBase file =====
 +
 +The ‘puplookup.csv’ is a DataBase (DB), which is filled with data, that you normally would have to type in yourself in the fields of the **‘All Games’**section of the **Game Manager.**
 +
 +Data like for example: TableName, Manufacturer, Release Year, Game Type, etc.
 +
 +This DataBase file will help you automatically fill in the fields by just doing some simple mouse clicks (or typing in a few keywords).
 +
 +\\
 +That sounds pretty handy, right?
 +
 +Before we start with the instructions, there’s one thing you need to do before hand:
 +
 +===== A. Backing up your (current) DB =====
 +
 +1. Start '**PinUP Popper Config**'.\\
 +2. Go to the '**Popper Setup**' tab (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ).\\
 +3. Click on the '**Backup DB**' button (
 + <font inherit/inherit;;#c0392b;;inherit>**2**</font>  ).
 +
 +**{{:d488b9c816e609819eafb73879a9195f.png}}**
 +
 +4. Confirm with ‘**Yes**’ in the Popup Window that opens:
 +
 +\\
 +**{{:200d5a37aa190229fc18ba892662585b.png}}**
 +
 +5. Now Close Pinup Popper Config by clicking ‘**Exit Setup**’.
 +===== B. How to use a downloaded puplookup.csv file =====
 +
 +Create a the latest puplookup.csv from this website: [[https://virtual-pinball-spreadsheet.web.app/|https://virtual-pinball-spreadsheet.web.app/]]
 +
 +There is a "CSV Export" Button on main screen. The filename must be **puplookup.csv**
 +
 +1. First make a Backup of your current Database, as explained in **4.A**.\\
 +2. Copy the above '**puplookup.csv**' into the root of your ‘**PinUPSystem**’ folder on your hard drive (Your Hard drive:\**PinUPSystem\ **).\\
 +4. Start '**PinUP Popper Config**'.\\
 +5. go to the '**Popper Setup**' tab (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ).\\
 +6. Click on ‘**DB Editor (advanced)**’ (**
 + <font inherit/inherit;;#c0392b;;inherit>2</font>  **).
 +
 +**{{:5e89748d48c6eac85300bf9cbab6eac9.png}}**
 +
 +**{{:e539f31d98c12d9dc845b375c85f76da.png}}** \\
 +7. There click on '**Import Lookup**' button.\\
 +8. Confirm with ‘**Yes**’ in the Popup Window that opens.
 +
 +***Now the importing process starts*** **
 + <font inherit/inherit;;#c0392b;;inherit>Note</font>  **  This can take a while and it may seem that PinUP Popper is frozen or reacting, but don’t worry it's still working. Give it some time.
 +
 +When done, you should see an amount of numbers on the ‘**Import Lookup**’ and a message that the importing is complete.
 +
 +**{{:70066eb1251d7fd951f952dd2bf2df2a.png}}**
 +
 +9. Now click the ‘Close Form’ button to close the ‘**DB Editor (advanced)**’ screen.
 +===== C. Using the Import function =====
 +
 +A. Click on the '**Game Manager**' tab (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ).
 +
 +B. Click on the '**Games Manager**' button (
 + <font inherit/inherit;;#c0392b;;inherit>**2**</font>  ) and you'll go to the '**All Games**' screen, which should have all your games in it.
 +
 +**{{:e64594ff095f66562c3cb951b969bcfe.png}}**
 +
 +** <font inherit/inherit;;#c0392b;;inherit>Note</font>  **I’ll use an example for the next few steps, but you can try it on any game you want. Do take into account that whether a game and data is available depends on which ‘**puplookup.csv**’ you have downloaded. Some don’t have all games or data fields included.
 +
 +**Example: Editing ‘The Addams Family (Bally 1992).vpx’ using ‘import’.**
 +
 +**{{:9ea8257818e8b166627a92d6805a4f5d.png}}**
 +
 +Take a second to watch the picture.
 +
 +The steps in the next page will make more sense after that.\\
 +\\
 +C.In you **Gamelist ** (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ) select the game that you want edit or use the import function on.
 +
 +** <font inherit/inherit;;#c0392b;;inherit>Note</font>  **  You can use the ‘**Search Game**’ (
 + <font inherit/inherit;;#c0392b;;inherit>**2**</font>  ) function to find a game in your game list quickly before doing step C.
 +
 +Also Notice how the most of the fields on the right (
 + <font inherit/inherit;;#c0392b;;inherit>**3**</font>  ) aren’t filled in yet.
 +
 +D. After selecting a game, click either the '**import**' button (
 + <font inherit/inherit;;#c0392b;;inherit>**4**</font>  ) or double click the GameDisplay game. The following screen will now open:
 +
 +**{{:a697366a5be09b30c42bfa1786ef37ce.png}}**
 +
 +In most cases the table should already be shown in the list (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ). If this correct you can **double click** it and you will go back to ‘**All Games**’ screen.
 +
 +** <font inherit/inherit;;#c0392b;;inherit>Note</font>  **If your **game** is **not shown** in the list or the list is empty, you can try typing in (parts) of the Game Name in the ‘**Search Game String**’ (
 + <font inherit/inherit;;#2980b9;;inherit>**2**</font>  ) and click on the ‘**lookup**’ (
 + <font inherit/inherit;;#27ae60;;inherit>**3**</font>  ) or ‘**Web lookup**’ button, depending on wether you want to fetch data locally or from the Internet, to show the results.
 +
 +Notice there’s an ‘**Overwrite Game Name on import **‘ option (
 + <font inherit/inherit;;#f39c12;;inherit>**4**</font>  ). Enabling this will change the Game Name on the '**All Games**' screen to the name that’s shown here on the '**ImportData**' screen. If you want the name to stay the same, for instance if you have set the names to your liking, even if you update files and/or metadata you should leave this unchecked.
 +
 +Either double click the result you want to import, or click the '**Import Fields' **button bottom right.
 +
 +Note: The '**Rename Current Game to PrOPPER Format'** and **'Rename Current Game Manual Entry'** can be used to rename the table and all associated backglass, media, POV files etc with one handy action, see more here:
 +
 +[[https://www.youtube.com/watch?v=AoVkUBsUT-Q|https://www.youtube.com/watch?v=AoVkUBsUT-Q]]
 +
 +F. Now you're back in the '**All Games**' window. Notice that several fields (
 + <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ) on the right have been populated with data.
 +
 +**{{:0c4114a5be52e4fa5fad699103ed2d50.png}}** \\
 +G. Remember to always click the '**Save**' button (
 + <font inherit/inherit;;#c0392b;;inherit>**2**</font>  ) before exiting or else all the data fields will remain empty next time you go here.\\
 +H. When you’re done editing your games using import, click the ‘**Close**’ button (
 + <font inherit/inherit;;#c0392b;;inherit>**3**</font>  ).
 +
 +**Repeat Steps 4.C - G for all your games.**
 +