Editing CSV in LibreOffice
While the overall plan is to make app listings editable directly (such as this page is by its link on the button), for maintenance purposes this has not been enabled yet. We also want third parties to build upon data MGLapps, LINMOBapps and now LinuxPhoneApps.org contributors have amassed, and for that the .csv lists have to stay.
Opening the file in LibreOffice
CSV are a bit underspecified, therefore import options matter.
Just set them as they are set in the following screenshot:
In theory, you can start editing now. However, it's way easier if you follow two more steps:
First, click into the B2 field and then go into the "View" menu and select the "Freeze Rows and Columns" field.
If you just want to add apps, you can add it into the first empty row at the bottom of the list for apps.csv (or add it in where it would go alphabetically for games.csv).
If you want to edit apps, finding the correct row can be annoying. Filters can help here.
Turn on auto-filters by clicking the icon or, going to the "Data" menu and select "Auto Filter" (or hit Shift+Ctrl+L if your LibreOffice is set up the way mine is).
If you hit one of the little arrows in the top columns a menu will come up that allows you to search the content of that column. With the A column that means you're filtering through app names: E.g. if you type Amberol, and hit OK, you'll be editing the Amberol entry and only that one.
You can also scroll through the filter list and select a few apps if you e.g want to edit a few similar apps at once. After you've selected what you want to edit and hit done, you'll only see the app(s) you've selected and can now edit them without accidentally drive-by editing the wrong column.
There's one issue left: Typographic Quotes. We need non-typographic quotes for quotations in the summary and description fiels. If you rarely edit for LinuxPhoneApps, just copy paste a non-typographic quote and paste it four times in these two fields. Otherwise, you can go to "Tools" and select "AutoCorrect Options". Then select "Localized options" and uncheck the checkboxes below "Single Quotes" and "Double Quotes". Hit OK, and you're done :)
Alternatively: Add apps with Vim
You can also edit with Vim. While in normal mode and on the first line, hit
yy to copy the line that specifies the contents of each column.
After that, navigate to the bottom of the file by hitting
L, (or the navigate to the alphabetical position for games.csv), and then paste the line once or twice by hitting
p. Now you just need to replace the words by the appropriate contents for the app you want to add with vim. Depending on whether you pasted a helper line, delete that again before saving (:w) by hitting
Fields and contents
No matter whether you edit with LibreOffice or not, here's what kind of contents is supposed to go into the different columns:
|field||value / form||note|
|name||name||try to write it as it's written on its project page|
|bugtracker||URL||only fill if not Gitea/GitHub/GitLab issues|
|donations||URL||optional, link to donations|
|translations||URL||optional, link to translation project|
|more information||URLs||helpful links seperated by space|
|license||identifier||SPDX 3 identifier,mandatory|
|metadata license||identifier||SPDX 3 identifier, optional|
|category||value||check existing values, if multiple seperate by comma|
|summary||text||mandatory, keep it short|
|summary source||url or no quotation||mandatory|
|descritption||usually a quote, markdown||should explain the app well|
|descritption source||url or no quotation||mandatory if description is filled|
|screenshots||url||if multiple seperate by space|
|mobile compatibility||number||check existing values, mandatory|
|status||value||check existing values, if multiple seperate by comma|
|notice||text, markdown||additional facts regarding the app, explaining shortcomings or features|
|framework||value||check existing values, if multiple seperate by comma|
|backend||value||check existing values, if multiple seperate by comma|
|service||value||check existing values, if multiple seperate by comma|
|scale-to-fit||value||often the app id, details|
|flatpak||URL||flatpak URL, often flathub URL|
|repology||package term||find on repology.org, if multiple seperate by space|
|aur||package name(s)||if multiple seperate by space|
|postmarketos||package name(s)||if multiple seperate by space|
|debian||package name(s)||if multiple seperate by space|
|appstream link||appstream://appid||only fill when there's an appid|
|appdata.xml or metainfo.xml url||URL||choose the raw/plain-text option|
|freedesktop categories||value,value||see 1, 2 for values|
|main languages||value||comma separated for multiple|
|build system||value||comma separated for multiple|
|original reporter||your (nick)name||mandatory|
|updated||yyyy-mm-dd||only fill when updating|
|updated by||your (nick)name||only fill when updating|