| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | This sheet is meant to help you create a custom systems sorting file for ES-DE so you don't have to write the XML yourself | ||||||||
2 | Details on custom systems sorting can be found at https://gitlab.com/es-de/emulationstation-de/-/blob/master/INSTALL.md?ref_type=heads#es_systems_sortingxml | ||||||||
3 | |||||||||
4 | Instructions: | ||||||||
5 | |||||||||
6 | 1. Make a copy of this document | ||||||||
7 | Go to: File > Make a copy | ||||||||
8 | |||||||||
9 | |||||||||
10 | |||||||||
11 | |||||||||
12 | |||||||||
13 | |||||||||
14 | |||||||||
15 | |||||||||
16 | |||||||||
17 | |||||||||
18 | |||||||||
19 | 2. On the "Source" sheet; add your custom sort values for each system you want in the "systemsortname" column | ||||||||
20 | You only need to populate the systems you care about, the output sheet will automatically output only the systems you have added a value for | ||||||||
21 | |||||||||
22 | |||||||||
23 | |||||||||
24 | |||||||||
25 | |||||||||
26 | |||||||||
27 | |||||||||
28 | |||||||||
29 | |||||||||
30 | |||||||||
31 | |||||||||
32 | |||||||||
33 | |||||||||
34 | |||||||||
35 | |||||||||
36 | |||||||||
37 | |||||||||
38 | 3. After you have added your sort values go to the "Output" sheet and then export that sheet as a .csv file | ||||||||
39 | Open the "Output" sheet and then select "File > Download > Comma Seperated Values". | ||||||||
40 | Do not make any manual changes on the "Output" sheet; its already set up to automaticaly update from changes on the Source sheet. | ||||||||
41 | |||||||||
42 | 4. Go to https://www.convertcsv.com/csv-to-xml.htm and upload your .csv file in Step 1 | ||||||||
43 | |||||||||
44 | |||||||||
45 | |||||||||
46 | |||||||||
47 | |||||||||
48 | |||||||||
49 | |||||||||
50 | |||||||||
51 | 5. In Step 5 add the following values and then press "Convert CSV to XML" | ||||||||
52 | Top-level Root Name: | systemList | |||||||
53 | Each Record XML Name: | system | |||||||
54 | |||||||||
55 | |||||||||
56 | |||||||||
57 | |||||||||
58 | |||||||||
59 | |||||||||
60 | |||||||||
61 | 6. Press "Download Result" and then rename the downloaded xml file: es_systems_sorting.xml | ||||||||
62 | |||||||||
63 | 7. Place your final es_systems_sorting.xml file in /ES-DE/custom_systems/ | ||||||||
64 | |||||||||
65 | 8. Open the main menu in ES-DE then "UI Settings"; make sure that Systems Sorting is set to "Full Names or Custom" | ||||||||
66 |