starx

Yes, the xml file comes from retropie. Good detailed database. I had to convert it myself Here is python code that reads the xml file and convert it to a csv file. delimeter is | (pipe) and strings are quoted with ~ You can import this csv to a sqllite db using this tool: https://sqlitebrowser.org/ from xml.etree import cElementTree as ET tree = ET.parse("gamelist.xml") root = tree.getroot() a=1 file = open('gamelist.csv','w',encoding='utf-8') for page in root.findall('game'): desc = page.find('desc') name = page.find('name') filename = page.find('path') developer = page.find('developer') publisher = page.find('publisher') genre = page.find('genre') releasedate = page.find('releasedate') rating = page.find('rating') #if desc is not None: filename = filename.text.replace('./','').replace('.zip','') print("desc: ", filename) file.write(str(a)+'|') file.write(name.text+'|') file.write('|') #cloneof file.write('|') #no clone file.write('|') #mame file.write(filename + '|') #gamebase file.write('|') #hyperlist file.write('|') #goodname file.write('|') #nointro file.write('|') #tosec file.write('|') #redump tmp = '' if publisher is not None: tmp = publisher.text file.write(tmp +'|') #publisher tmp = '' if developer is not None: tmp = developer.text file.write(tmp+'|') #publisher file.write('|') #developercloneof tmp = '' if releasedate is not None and releasedate.text is not None: tmp = releasedate.text if tmp != '': year = tmp[0:4] month = tmp[4:6] day = tmp[6:8] file.write(year+'-'+month+'-'+day+'|') else: file.write('|')#date file.write('|')#esrb tmp = '' if genre is not None and genre.text is not None: tmp=genre.text file.write(tmp+'|') file.write(rating.text+'|') #file.write('tating.text|') file.write('|') #score file.write('|') #numplay file.write('|') #flags file.write('|') file.write('|') file.write('|') file.write('|') file.write('|') #flags tmp = '' if desc is not None and desc.text is not None: tmp=desc.text file.write('~' + tmp+'~|') #description #file.write('|') #data file.write('\n') a +=1 print("done") file.close Just another question: is it possible to sort the displayed list of roms by anything else than by name?

Hello, i got for all acrade roms a gamelist.xml with all infos like: game id="39876" source="ScreenScraper.fr"> <path>./1943kai.zip</path> <name>1943 Kai: Midway Kaisen</name> <desc>An update of 1943 with tweaked weapons, fewer levels, and a new soundtrack.</desc> <rating>0.7</rating> <releasedate>19870101T000000</releasedate> <developer>Capcom</developer> <publisher>Capcom</publisher> <genre>Shoot'em up / Vertical-Shoot'em Up</genre> <players>1-2</players> <image>./mixart/1943kai.png</image> <marquee>./wheel/1943kai.png</marquee> <video>./snap/1943kai.mp4</video> <hidden>false</hidden> <favorite>false</favorite> </game> Is there a tool or how could i convert this xml to a GameEx database? I'm only interested on description, date, rating etc

Hello, im new to this. It is possible to switch sorting of the rom list?