Updating the Master List: Difference between revisions
Jump to navigation
Jump to search
(Add CSV export script) |
m (fixed script) |
||
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 |
Revision as of 11:56, 31 July 2022
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 latest Flashpoint database file if you don't have it already.
Exporting CSV Files
Follow these steps to export the entire game/animation database as a CSV file:
- Download, install and open DB Browser for SQLite.
- Open the
flashpoint.sqlite
file (File -> Open Database...
) - Click
File -> Export -> Table(s) to CSV file...
- Select the
game
table and leave all other options at their default values. Save the file.
Next, follow these steps to create separate game and animation CSV files:
- Download and run CSVFileView.
- Open the CSV file that you exported.
- In the Options menu, change the "Unicode/Ascii Default Open Mode" to UTF-8. Then change the "Unicode/Ascii Save Mode" to "Always UTF-8."
- In the Options menu, check "Add header line to CSV/Tab-Delimited File." Then check the "Allow MultiLine Fields" option.
- Click the Refresh button to reload the file.
- Click
View -> Edit Display Filter
. Check "Use the following display filter", then type one of the following:library = 'arcade'
for the Game Master Listlibrary = 'theatre'
for the Animation Master List
- Click
View -> Choose Columns
and check only these columns: id, title, series, developer, publisher, platform. - Click
File -> Save All Items
. Save as the CSV file type.
Alternatively, use the following batch script to export the game and animation CSV files automatically:
@ECHO off SET cols="id,title,series,developer,publisher,platform" 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 = 'theatre'" /aload %1 /scomma theatre.csv
To run the script, place it in the same folder as CSVFileView, then run exportMasterLists.bat sourceCSVPath
from the command line.