Reply to thread

Message

<blockquote data-quote="dir" data-source="post: 356033" data-attributes="member: 24485">1.&nbsp; Extract information from Mame:mame -listxml &gt;mame.xml2.&nbsp; Create fields.txt with the following in it:game_name;description;year;manufacturer;cloneofgame_name==game|namecloneof==game|cloneof3.&nbsp; Open mame.xml in Notepad.&nbsp; do a find/replace of .c&quot;&gt;.c&quot; cloneof=&quot;NONE&quot;&gt;and save it again.&nbsp; This finds all games that aren't clones and adds the 'cloneof' value to them.It's a big file so this might take a while.4.&nbsp; Convert the file to csv:xml2csv.exe mame.xml mame.csv fields.txt -D=;5.&nbsp; At this point I opened the mame.csv file in a spreadsheet app (not Excel) and told it to use the &quot;;&quot; as the delimiter.&nbsp; This neatly formatted the file so that each field was in it's own column:&nbsp; GameName, Description, Year, Manufacturer, and Visible.I then changed the Visible column so that anything that was &quot;NONE&quot; I changed to &quot;True&quot;. and the rest I changed to False.Note that in the editor I used, it tried to interpret the values as boolean.&nbsp; I just want them as text.Save the file again.You should now have a csv file that shows the Visible status of each game that isn't a clone.The file should then be able to be used by sqlite3.exe as the temp input file for updating the database.Should.</blockquote>

[QUOTE="dir, post: 356033, member: 24485"] 1. Extract information from Mame: mame -listxml >mame.xml 2. Create fields.txt with the following in it: game_name;description;year;manufacturer;cloneof game_name==game|name cloneof==game|cloneof 3. Open mame.xml in Notepad. do a find/replace of .c"> .c" cloneof="NONE"> and save it again. This finds all games that aren't clones and adds the 'cloneof' value to them. It's a big file so this might take a while. 4. Convert the file to csv: xml2csv.exe mame.xml mame.csv fields.txt -D=; 5. At this point I opened the mame.csv file in a spreadsheet app (not Excel) and told it to use the ";" as the delimiter. This neatly formatted the file so that each field was in it's own column: GameName, Description, Year, Manufacturer, and Visible. I then changed the Visible column so that anything that was "NONE" I changed to "True". and the rest I changed to False. Note that in the editor I used, it tried to interpret the values as boolean. I just want them as text. Save the file again. You should now have a csv file that shows the Visible status of each game that isn't a clone. The file should then be able to be used by sqlite3.exe as the temp input file for updating the database. Should. [/QUOTE]

Verification