-
Notifications
You must be signed in to change notification settings - Fork 7
Creating sorting order file from converted data using Excel
Prerequisites:
- you read and got familiar with "Sorting Order" feature
- you have converted weidu.log data or converted BWS data
Step 1:
Open Excel and use "Import Text" feature, import converted data, choose 'space' as text quantifier
You should now have long list of ModID ComponentNumber like this
| ModID | ComponentNumber |
--------------------------------
| DlcMerger | 1 |
| dsotscBGEE | 0 |
| . | . |
Step 2: for each line you should do the following:
- if there is a single ModID with single ComponentNumber and there is no other line with the same ModID, replace ComponentNumber with *
Example for mods which have single row entry/only single component:
| Before | After |
|------------|-----------------|------------|-----------------|
| ModID | ComponentNumber | ModID | ComponentNumber |
| DlcMerger | 1 | DlcMerger | * |
| dsotscBGEE | 0 | dsotscBGEE | * |
- if there are few lines with the same ModID but different components, and there is no other line with the same ModID at any row below, replace all lines which contain the same ModID with ModID *. You must make sure by searching particular ModID that there aren't any other lines with this ModID, below the initial group!
Example for NTotSC and drizztsaga: Those two mods do not have their components anywhere else so * can be used.
| ModID | ComponentNumber | ModID | ComponentNumber |
|------------|-----------------|------------|-----------------|
| NTotSC | 0 | NTotSC | * |
| NTotSC | 1 | | |
| NTotSC | 2 | | |
| NTotSC | 3 | | |
| NTotSC | 4 | | |
| NTotSC | 5 | | |
| NTotSC | 6 | | |
| drizztsaga | 0 | drizztsaga | * |
| drizztsaga | 1 | | |
| drizztsaga | 2 | | |
| drizztsaga | 3 | | |
- If mod components are spited across lines and there are other mods between them you cannot use * everywhere because there are two places where RR exist (separated by other mods). You can put ComponentNumber into the same row inside Excel (columns C, D, E...)
Example for RR mod before conversion:
| ModID | ComponentNumber | | |
|---------------------|-----------------|---|---|
| RR | 0 | | |
| RR | 1 | | |
| RR | 3 | | |
| RR | 4 | | |
| RR | 6 | | |
| RR | 7 | | |
| WSR | 100 | | |
| . | . | | |
| (OtherMod) | x | | |
| . | . | | |
| RelieveWizardSlayer | 0 | | |
| RR | 9 | | |
| RR | 10 | | |
| RR | 999 | | |
Example for RR after conversion:
| ModID | CN | CN | CN | CN | CN | CN |
|---------------------|----|----|-----|----|----|----|
| RR | 0 | 1 | 3 | 4 | 6 | 7 |
| WSR | * | | | | | |
| . | . | | | | | |
| . | . | | | | | |
| . | . | | | | | |
| RelieveWizardSlayer | * | | | | | |
| RR | 9 | 10 | 999 | | | |
Step 3: when you are done with all rows, simply save the file as SortingOrder.csv without header
Step 4: run PI, point to SortingOrder.csv file using dedicated field
Step 5: after you have picked all desired mods, click "Set-InstallSequence" and then click "Apply-SortingOrder" button
All mods should be now sorted according to list.