Skip to content

auberginehill/list-my-apps-template-xml-plain

Repository files navigation

List My Apps Template - XML plain

OS: Android
Type: A template for an Android app called 'List My Apps'
Language: XML (with custom variables)
Description: This template (when run in an Android app called 'List My Apps') creates a .xml-file of the apps installed on an Android device. The resulted XML-file can be imported into Microsoft Excel (as described in the Tutorial Step 12 below). The Import to Excel -procedure automagically arranges the data into a column style format based on the headers, makes the columns sortable with a click and applies some styling to the data.
Homepage: https://github.com/auberginehill/list-my-apps-template-xml-plain
Version: 1.3
Sources:
Emojis: https://api.github.com/emojis
Descriptions of the variables: http://www.onyxbits.de/faq-page/22#t22n48
Downloads: For instance all_in_one.txt or the same file in three separate parts. Or everything as a .zip-file.

Screenshot

screenshot

Remarks

⚠️
  • List My Apps custom templates consist of three fields ("List header", "Item format" and "List footer"). The template code in this project is divided into three parts, which correspond the fields found in List My Apps' Template Editor as described below:

      Filename Field in List My Apps' Template Editor
      file_header.txt "List header, may be blank"
      body.txt "Item format, may not be blank"
      file_footer.txt "List footer, may be blank"
      all_in_one.txt Contains all the above mentioned three parts in one file.

  • Please include one empty row after "File Header" and "Body" in the List My Apps template (so that the script will write each data row on its own row).
  • After the app data has been pasted from 'List My Apps' to a XML-editor, please search for the character & and replace every occurence with the word and (since XML-files don't work that well with extra ampersands or with extra < characters).
  • The resulted XML-file needs to be further processed in order to create a human readable file (Tutorial Step 12).

Tutorial

📖 To open this code with an Android device, for instance:

  1. Create a new template in 'List My Apps' -app's Template Editor by clicking Options (three dots) → Template Editor → Add. [Screenshot]
  2. Type in a name for the template.

      screenshot
  3. Paste all the appropriate template data (the three sections as specified below) to 'List My Apps'. Please include one empty row after "File Header" and "Body" (so that the script will write each data row on its own row) and save the template.

  4. After saving the template go back to the 'List My Apps' -app's home screen and select the name that was created in Step 2 from the 'Copy/Share as:' -dropdown menu. Please also select the apps that you'd like to be included in the list. [Screenshot]
  5. 'Run' the 'List My Apps' -app with the new template by copying the app data to Clipboard [Copy] (since direct sharing may not work, if a lot of applications has been installed).
    • There seems to be some kind of a limit, how much data the Android Clipboard can contain. With verbose templates ~200 apps might be the upper limit, but with a simple template, the Android Clipboard clearly is capable of containing considerably more app data.
  6. Open a XML-editor, such as DroidEdit Free.
  7. Paste the app data (source code generated by 'List My Apps' in Step 5) from Clipboard to the XML-editor.
    • If nothing happens (no data is pasted to a XML-editor after a few seconds), try selecting fewer apps in 'List My Apps' and go back to Step 5.
      • Depending on the device some lagging may occur when trying to paste, say ~10000 lines of code.
    • If "old data" gets pasted to a XML-editor (i.e. "the data that was in the Clipboard before List My Apps' 'Copy to Clipboard' -button was clicked"), try selecting fewer apps in 'List My Apps' and go back to Step 5.
  8. After pasting the app data to the XML-editor, please search for the character & and replace every occurence with the word and (since XML-files don't work that well with extra ampersands or with extra < characters).
  9. Save the file as a .xml-file, for example as 'Installed_Apps.xml', for example in 'Home/Documents' folder (a filename without any spaces is recommended).
  10. Firefox for Android renders also .xml-files, but since the plain XML-format is quite unlegible without any styling applied, one might want to open it in Excel instead. So...
  11. Copy the .xml-file to, for instance, C:\Temp\ -directory in Windows.
  12. Microsoft Excel
    • On the Data tab of the Ribbon bar, in the Get External Data group, click From Another Source and choose XML. Then, in the Import Data dialog box, double-click the Installed_Apps.xml file.
    • Click OK on the error message.
    • Select where the imported cells are placed and click OK.

Contributing

Find a bug? Have a feature request? Here is how you can contribute to this project:

contributing Bugs: Submit bugs and help us verify fixes.
Feature Requests: Feature request can be submitted by creating an Issue.
Edit Source Files: Submit pull requests for bug fixes and features and discuss existing proposals.

www

www Template Homepage
List My Apps (Google Play)
List My Apps' homepage
List My Apps' application thread at xda-developers.com
DroidEdit Free (free code editor)
Axel (XML Editor / Viewer)
Firefox for Android
Gitskarios for Github
Github Markdown Previewer
HTMLHint
Text Compare
XML Escape
ASCII Art: http://www.figlet.org/ and ASCII Art Text Generator

Related scripts

www List My Apps Template - Table
List My Apps Template - List
List My Apps Template - Pro
List My Apps Template - Data
List My Apps Template - XML style
List My Apps Template - JSON

N.B.

  • Please include one empty row after "File Header" and "Body" in the List My Apps template (so that the script will write each data row on its own row).
  • After the app data has been pasted from 'List My Apps' to a XML-editor, please search for the character & and replace every occurence with the word and (since XML-files don't work that well with extra ampersands or with extra < characters).