A simple python program that help you convert Arknights raw story data into other readable format like Excel or csv.
Access the webpage application of ASTR here!
You can find raw story data in Kengxxiao/ArknightsGameData
CN/JP/EN/KR server files tested
Only support story. Guides, tutorial and pop-up msg in battle are not supported yet.
Read the tutorial about the script here: Tutorial
py xlsxconvert.py [-h] [-c] [-L Langcode] [-E] [-e Eventid] [path]
Convert arknights story raw data into xlsx file.
positional arguments:
path
The file path or folder path. If no -E or -e option provided, convert all file in path or selected path to xlsx file.
optional arguments:
-h
, --help
show this help message and exit
-c
, --comment
Show Code Comment in raw story file
-L Langcode
, --Lang Langcode
Config the language of the following command, default is zh_CN
-E
, --EventList
Show available index: eventid in corresponding language, config the path to change the ArknightsGameData path from default (./ArknightsGameData)
-e Eventid
, --event Eventid
Export all stories in corresponding index or eventid, config the path to change the ArknightsGameData path from default (./ArknightsGameData). You can get available index or eventid from --EventList command.
-i
, --info
Show story info in menu
Require openpyxl module, if you haven't installed openpyxl, run the following command first
pip install openpyxl
====
py csvconvert.py path [path ...]
Convert arknights story raw data into csv file.
positional arguments:
path
The filepaths or folder of raw story file, separate with space, if the path is folder path, it will try to convert all .txt files into csv
config the path
in the relic.py
and the properties you want to export and run the program directly
- rewrite code for amiya promotion
- add offline mode for
jsonconvert.py
- Changes EN/JP/KR server data source
- Fix the property regex
- Add ability to find the figure art to corresponding character name.
- Add ability to load extra/hidden stories
- Add
multiline
property support in EP10 - Fix a bug that fail to export file
- Add
Sticker
property support in EP10
- Test the auto updater
- Fixed some issues
- Add disable tracing option feature when exception occured to handle those story file that don't have a "correct" option predicate.
- Fixed some issues
- Fixed some issues
- Enable pytest for
xlsxconvert.py
to prevent from making stupid mistake and pushing buggy code again
- Fixed some issues
- Add Converting into Json Feature (under development) in
jsonconvert.py
- Rewrote the code of
xlsxconvert.py
based on the new json feature, completely get rid of a bunch of shitty regular expressions - Add a column of line index before each line, the index column is hidden in sheets
Replace all backslash in program with slash to allow code work on Linux system
Add square bracket in option text to match the ingame log style
Fix the incorrect cells merging in menu of storyset
Fix the issue that missing heading or ending lines
Fix the issue that can't recognize storyset event in event list
Update tutorial and CN version README
Fix the hyperlink properties (credit: VaDiM#5824)
Remove unnecessary codes
Some minor bug fixes
Add an option to export all mainline stories at once
Add an option to show story info in menu
Add new feature to export story with given eventid and sorted in ingame order.
Add new option to switch to different language server
Automatically generate menu (didn't work for googlesheet currently)
Automatically apply text warpping and column width adjustment
Fix an issue of single file mode
Now support Subtitle
type text in ch8, presented as bold text with blank rows around in sheet
Add news.py
to export rawtext of Rosebud News in Maria Nearl event
Add colored font in command line output (Based on Powershell scheme on Windows 10)
Fix the issue that the regex can't match line without space
Add command line output to help user locate the problem
Add a new python program relic.py
to export the info about the relics in Integrated Strategies
Fix the issue that the regex can't match other Character syntax
Change the CG source of csvconvert.py to aceship toolbox
Fix the issue that the regex misread BackgroundTween
as an image type (Credit: Biscuits#4183)
Add single file support to xlsxconvert.py
Add optional args to show Character CG file names or Code Comment in raw story files (Some comments in CN chapter 7 are very interesting you know)
Fix the issue that a syntax error in raw story txt cause an unhandled exception
Now automatically record all characters' name appear in the whole textsheet and append them to the end of the textsheet named "Characters" (Method 1 only)
New command to convert all raw story files into one xlsx file.
Now automatically link the image and background to the Aceship Toolbox CG Gallery
Now automatically link the image and background to the mooncell wiki (doesn't support for earlier event like Grani)
Now support folder path, which will convert all .txt file in the folder
Fix some issues
Now support multiple arguments
Fix the encoding issue, now will force encode with utf-8 if UnicodeEncodeError orrured, so there may have some decoding problem when open the csv files with Microsoft Excel.
Fix the regex to fully match the image in EN server
initial release
To-do list: (maybe never)
- Prettify the output into html or anything looks better.