Updating the Master List - Revision history

Revac at 23:02, 15 February 2024

2024-02-15T23:02:46Z

← Older revision		Revision as of 01:02, 16 February 2024
Line 66:		Line 66:

	<noinclude>[[Category:Meta]]</noinclude>		<noinclude>[[Category:Meta]]</noinclude>
			<noinclude>[[Category:Legacy articles]]</noinclude>

Revac at 23:02, 15 February 2024

2024-02-15T23:02:03Z

← Older revision		Revision as of 01:02, 16 February 2024
Line 1:		Line 1:
			'''Note: The Game and Animation Master List are no longer used, this is a legacy guide.'''

	This page describes how to use Flashpoint's database file to export and update the Game Master List and Animation Master List.		This page describes how to use Flashpoint's database file to export and update the Game Master List and Animation Master List.

	First, download the [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] if you don't have it already.		First, download the [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] if you don't have it already.

			'''As of Version 12, the database file now lives [https://gitlab.unstable.life/flashpoint/components/core/Database on Gitlab].'''

	== Exporting CSV Files ==		== Exporting CSV Files ==

Prostagma: /* Exporting CSV Files */

2023-05-14T23:16:36Z

Exporting CSV Files

← Older revision		Revision as of 01:16, 15 May 2023
Line 8:		Line 8:
	# Download, install and open [https://sqlitebrowser.org/ DB Browser for SQLite].		# Download, install and open [https://sqlitebrowser.org/ DB Browser for SQLite].
	# Open the <code>flashpoint.sqlite</code> file (<code>File -> Open Database...</code>)		# Open the <code>flashpoint.sqlite</code> file (<code>File -> Open Database...</code>)
	# Open the <code>Execute SQL</code> tab and use the following: <pre>SELECT id, title, developer, publisher, REPLACE(platformsStr, "; HTML5", ;"") AS platform FROM game WHERE library = "arcade";</pre>		# Open the <code>Execute SQL</code> tab and use the following: <pre>SELECT id, title, developer, publisher, REPLACE(platformsStr, "; HTML5", "") AS platform FROM game WHERE library = "arcade";</pre>
	Change <code>arcade</code> to <code>theatre</code> if you intend to update the Animation Master List instead. Execute the command and save the view as a CSV file.		Change <code>arcade</code> to <code>theatre</code> if you intend to update the Animation Master List instead. Execute the command and save the view as a CSV file.

Prostagma: /* Exporting CSV Files */ simpler steps, update for 12.0

2023-05-14T22:02:33Z

Exporting CSV Files: simpler steps, update for 12.0

@@ Line 8: / Line 8: @@
 # Download, install and open [https://sqlitebrowser.org/ DB Browser for SQLite].
 # Open the <code>flashpoint.sqlite</code> file (<code>File -> Open Database...</code>)
-# Click <code>File -> Export -> Table(s) to CSV file...</code>
+# Open the <code>Execute SQL</code> tab and use the following: <pre>SELECT id, title, developer, publisher, REPLACE(platformsStr, "; HTML5", ;"") AS platform FROM game WHERE library = "arcade";</pre>
-# Select the <code>game</code> table and leave all other options at their default values. Save the file.
+Change <code>arcade</code> to <code>theatre</code> if you intend to update the Animation Master List instead. Execute the command and save the view as a CSV file.
 == Adding a Platform to the Game Request Form ==

Nosamu: Minor updates

2022-08-03T03:12:26Z

Minor updates

← Older revision		Revision as of 05:12, 3 August 2022
Line 45:		Line 45:
	* These steps are only necessary if the option name on the Game Request Form corresponding to this Platform differs from the actual Platform name in Flashpoint. For example, the option name for the "Flash" platform is "Flash Player", so "Flash" goes in column A and "Flash Player" goes in column B.		* These steps are only necessary if the option name on the Game Request Form corresponding to this Platform differs from the actual Platform name in Flashpoint. For example, the option name for the "Flash" platform is "Flash Player", so "Flash" goes in column A and "Flash Player" goes in column B.
	* These steps ''must'' be performed '''before''' updating the Master List sheets!		* These steps ''must'' be performed '''before''' updating the Master List sheets!
			* The steps for updating the Animation Request Form are the same, except that you need to use the [https://docs.google.com/spreadsheets/d/1aCGXBPwueSU_MVXD_-MF2GryGod0BThw5xSoHJR7eBQ/edit#gid=1026610466 Animation Master List] spreadsheet instead.

	== Updating the Google Sheets ==		== Updating the Google Sheets ==
Line 55:		Line 56:
	# Click the Upload tab and select the arcade.csv file.		# Click the Upload tab and select the arcade.csv file.
	# Click the "Import location" dropdown and select "Replace current sheet". Uncheck "Convert text to numbers, dates, and formulas".		# Click the "Import location" dropdown and select "Replace current sheet". Uncheck "Convert text to numbers, dates, and formulas".
			#* '''Do not select "Replace spreadsheet"! That will delete all the other tabs of the spreadsheet! Double-check that you've selected the correct option before you continue!'''
	# Click "Import data" and wait a bit for the new data to appear.		# Click "Import data" and wait a bit for the new data to appear.
	# Delete the Series column by selecting it and clicking Edit => Delete => Column.		# Delete the Series column by selecting it and clicking Edit => Delete => Column.
Line 73:		Line 75:
	# Click the Upload tab and select the downloaded CSV file.		# Click the Upload tab and select the downloaded CSV file.
	# Click the "Import location" dropdown and select "Replace current sheet". Uncheck "Convert text to numbers, dates, and formulas".		# Click the "Import location" dropdown and select "Replace current sheet". Uncheck "Convert text to numbers, dates, and formulas".
			#* '''Do not select "Replace spreadsheet"! That will delete all the other tabs of the spreadsheet! Double-check that you've selected the correct option before you continue!'''
	# Click "Import data" and wait a bit for the new data to appear.		# Click "Import data" and wait a bit for the new data to appear.
	# Delete the header row at the top of the sheet: right-click the top-left cell, then click "Delete row".		# Delete the header row at the top of the sheet: right-click the top-left cell, then click "Delete row".
Line 79:		Line 82:
	=== Updating the Animations spreadsheets ===		=== Updating the Animations spreadsheets ===

	The steps for updating the Animation Master List and Animation Requests sheets are ~~largely~~ the same. ~~I will add some notes below (LATER):~~		The steps for updating the [https://docs.google.com/spreadsheets/d/1aCGXBPwueSU_MVXD_-MF2GryGod0BThw5xSoHJR7eBQ/edit Animation Master List] and [https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit Animation Requests] sheets are the same as their respective Games sheets. Refer to the instructions above.

	<noinclude>[[Category:Meta]]</noinclude>		<noinclude>[[Category:Meta]]</noinclude>

Nosamu: Added procedures for updating the google spreadsheets

2022-08-02T09:35:53Z

Added procedures for updating the google spreadsheets

@@ Line 33: / Line 33: @@
 </pre>
 To run the script, place it in the same folder as CSVFileView, then run <code>exportMasterLists.bat sourceCSVPath</code> from the command line.
 <noinclude>[[Category:Meta]]</noinclude>

Nosamu: fixed script

2022-07-31T10:56:20Z

fixed script

← Older revision		Revision as of 12:56, 31 July 2022
Line 27:		Line 27:
	@ECHO off		@ECHO off
	SET cols="id,title,series,developer,publisher,platform"		SET cols="id,title,series,developer,publisher,platform"
	SET baseopts=/AsciiUnicodeMode 3 /AsciiUnicodeOpenMode 3 /AddExportHeaderLine 1 /AllowMultiLineFields 1		SET baseopts=/AsciiUnicodeMode 3 /AsciiUnicodeOpenMode 3 /AddExportHeaderLine 1 /AllowMultiLineFields 1 /UseLoadFilter 1

	CSVFileView /Columns %cols% %baseopts% /LoadFilterStr "library = 'arcade'" /aload %1 /scomma arcade.csv		CSVFileView /Columns %cols% %baseopts% /LoadFilterStr "library = 'arcade'" /aload %1 /scomma arcade.csv

Nosamu: Add CSV export script

2022-07-31T10:11:03Z

Add CSV export script

← Older revision		Revision as of 12:11, 31 July 2022
Line 20:		Line 20:
	#* <code>library = 'arcade'</code> for the Game Master List		#* <code>library = 'arcade'</code> for the Game Master List
	#* <code>library = 'theatre'</code> for the Animation Master List		#* <code>library = 'theatre'</code> for the Animation Master List
	# Click <code>View -> Choose Columns</code> and check only these columns: title, series, developer, publisher, platform.		# Click <code>View -> Choose Columns</code> and check only these columns: id, title, series, developer, publisher, platform.
	# Click <code>File -> Save All Items</code>. Save as the CSV file type.		# Click <code>File -> Save All Items</code>. Save as the CSV file type.

			Alternatively, use the following batch script to export the game and animation CSV files automatically:
			<pre>
			@ECHO off
			SET cols="id,title,series,developer,publisher,platform"
			SET baseopts=/AsciiUnicodeMode 3 /AsciiUnicodeOpenMode 3 /AddExportHeaderLine 1 /AllowMultiLineFields 1

			CSVFileView /Columns %cols% %baseopts% /LoadFilterStr "library = 'arcade'" /aload %1 /scomma arcade.csv
			CSVFileView /Columns %cols% %baseopts% /LoadFilterStr "library = 'theatre'" /aload %1 /scomma theatre.csv
			</pre>
			To run the script, place it in the same folder as CSVFileView, then run <code>exportMasterLists.bat sourceCSVPath</code> from the command line.

	<noinclude>[[Category:Meta]]</noinclude>		<noinclude>[[Category:Meta]]</noinclude>

Nosamu: Undo revision 8049 by Prostagma (talk)

2022-07-21T23:03:30Z

Undo revision 8049 by Prostagma (talk)

← Older revision		Revision as of 01:03, 22 July 2022
Line 1:		Line 1:
	This page describes how Flashpoint's database ~~was used~~ to export and update ~~this wiki's~~ Game Master List and Animation Master List~~; see [[Searching the Collection]] nowadays~~.		This page describes how to use Flashpoint's database file to export and update the Game Master List and Animation Master List.

	~~The~~ [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] ~~is used during the process~~.		First, download the [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] if you don't have it already.

	== Exporting CSV Files ==		== Exporting CSV Files ==

Prostagma at 21:52, 21 July 2022

2022-07-21T21:52:05Z

← Older revision		Revision as of 23:52, 21 July 2022
Line 1:		Line 1:
	This page describes how ~~to use~~ Flashpoint's database ~~file~~ to export and update ~~the~~ Game Master List and Animation Master List.		This page describes how Flashpoint's database was used to export and update this wiki's Game Master List and Animation Master List; see [[Searching the Collection]] nowadays.

	~~First, download the~~ [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] ~~if you don't have it already~~.		The [http://infinity.unstable.life/Flashpoint/Data/flashpoint.sqlite latest Flashpoint database file] is used during the process.

	== Exporting CSV Files ==		== Exporting CSV Files ==