Differences

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

--- game_import_setup [2023/09/05 15:35] – created pinupadmin
+++ game_import_setup [2025/01/04 11:41] (current) – 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 export a puplookup.csv file to use directly;
+===== How to import and use a puplookup.csv 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).
+[[https://virtualpinballspreadsheet.github.io/export|https://virtualpinballspreadsheet.github.io/export]]
+export from above website (select popper format) and take the downloaded file and place into your local PINUPSYSTEM folder.  NOTE:  filename must be named EXACTLY **puplookup.csv**
+Popper Config will use the file directly to import the meta data. It doesn't support a global(all tables) import as names and filename formats are not a standard in the vpin community. So importing meta data needs to be done on a individual table/game basis.
+Before we start with the instructions, there’s one thing you need to do before hand:
+===== A. Backing up your (current) DB =====
+. Start '**PinUP Popper Config**'.\\
+. Go to the '**Popper Setup**' tab (
+ <font inherit/inherit;;#c0392b;;inherit>**1**</font>  ).\\
+. Click on the '**Backup DB**' button (
+ <font inherit/inherit;;#c0392b;;inherit>**2**</font>  ).
+**{{:d488b9c816e609819eafb73879a9195f.png}}**
+. Confirm with ‘**Yes**’ in the Popup Window that opens:
+\\
+**{{:200d5a37aa190229fc18ba892662585b.png}}**
+. Now Close Pinup Popper Config by clicking ‘**Exit Setup**’.
+===== Using the Import function =====
+//** <font 14px/inherit;;inherit;;inherit>TIP: double clicking on a game in Games Manager will take you to the import tab automatically</font>  **  //
+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>  ).