• Is it possible, with macOS/iOS to do what Windows/Android does?

    From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 01:41:04 2026
    From Newsgroup: misc.phone.mobile.iphone

    How do you generate a list of every app you've put in every folder
    on your iOS home screen (similar to how I just did it on Android)?

    Is it possible, with macOS/iOS to do what Windows/Android does?

    =================================================================
    folder "time"
    package_name app_title
    ------------ ---------
    com.better.alarm Alarms
    ws.xsoh.etar Etar
    com.keuwl.sandtimer Sand Timer
    com.twiegold.atomictime Atomic Time
    com.simplemobiletools.clock smtClock
    com.kodarkooperativet.notificationstopwatch Stopwatch
    com.bnyro.clock Clock You
    com.simplemobiletools.calendar.pro smtCalendar
    org.sufficientlysecure.localcalendar Offline Calendar
    com.mta.countdown Timesolutely lite
    com.keuwl.stopwatch Stopwatch
    com.geekyouup.android.ustopwatch Ultimate Stopwatch
    com.samsung.android.calendar Calendar
    com.joykraft.frenchpresstimer French Press Timer
    com.terarisu.limited_timer010 010 Minutes Timer
    com.terarisu.limited_timer015 015 Minutes Timer
    com.terarisu.limited_timer020 020 Minutes Timer
    com.terarisu.limited_timer030 030 Minutes Timer
    com.terarisu.limited_timer045 045 Minutes Timer
    com.terarisu.limited_timer060 060 Minutes Timer
    com.terarisu.limited_timer090 090 Minutes Timer
    com.terarisu.limited_timer120 120 Minutes Timer
    com.terarisu.limited_timer180 180 Minutes Timer
    com.slydroid.watch Timer
    com.deslomator.complextimer Complex Timer
    com.bostbi.dev.countdown Countdown Timer
    at.cwiesner.android.visualtimer Visual Timer
    spinninghead.talkingstopwatchlite Ultrachron Lite
    com.hg.SpeechTimer SpeechTimer
    com.validconcept.Timer4TM Timer4TM
    com.geekyouup.android.ustopwatch Ultimate Stopwatch
    me.tsukanov.counter Counter
    com.starikov.datecalc Days Counter
    com.keuwl.eggtimer Egg Timer
    org.sufficientlysecure.ical Calendar Import-Export
    =================================================================
    folder "comms"
    package_name app_title
    ------------ ---------
    com.applaudsoft.wabi.wad WA Dialer
    com.whatsapp WhatsApp
    com.samsung.android.dialer Phone
    com.samsung.android.dialer Phone
    ml.bluelinestudio.privatecontact Phonebook
    com.integralblue.callerid CallerID
    me.billdietrich.fake_contacts Fake Contacts
    com.google.android.contacts GoogleContacts
    com.samsung.android.app.contacts origContacts
    opencontacts.open.com.opencontacts OpenContacts
    de.ritscher.simplemobiletools.contacts.pro Contacts
    com.simplemobiletools.contacts.pro smtContacts
    cz.psencik.com.android.contacts Contacts
    am.ed.importcontacts Import Contacts
    am.ed.exportcontacts Export Contacts
    de.hskl.contacts Contact Book
    de.dieterthiess.contactdiary2 Contact Diary
    net.stargw.contactsimport Contacts Import
    hazar.studio.privatecontacts Private Contacts
    ch.abwesend.privatecontacts Private Contacts
    cx.vmx.sdcontacts SD Contacts
    eu.stargw.contactsimport Contacts Import
    com.compelson.optimizer Contacts Optimizer
    com.ihubin.contactsmanager ContactsManager
    com.orgware.contactsmerge Contacts Merge
    com.simplemobiletools.contacts Contacts
    eu.stargw.contactsimport Contacts Import
    dummydomain.yetanothercallblocker Yet Another Call Blocker
    com.github.tmo1.sms_ie SMS Import / Export
    com.samsung.android.messaging Messages
    com.fsck.k9 K-9 Mail
    mobi.firedepartment PulsePoint
    de.tutao.tutanota Tutanota
    org.dystopia.email Email
    com.ninefolders.hd3 Nine
    com.deependhulla.opemail Open Mail
    ch.protonmail.android Proton Mail
    cz.psencik.smsforwarder.direct SMS Forwarder
    com.tmobile.services.nameid Scam Shield
    com.tmobile.services.nameid Scam Shield
    us.zoom.videomeetings Zoom
    contacteraser.mobile.mypapit.net.contacteraser Contact Eraser
    com.microsoft.office.outlook Outlook
    gr.alterora.apps.contacts 123 Contacts Backup And Transfer
    com.linkedin.android LinkedIn
    com.google.android.talk Hangouts
    com.google.android.apps.hangoutsdialer Hangouts Dialer
    com.google.android.apps.googlevoice Voice
    com.google.android.apps.meetings Meet
    com.healthappy.smsalert SMS Alert
    io.github.ilisevic.SOSbasic SOS Beacon and Locator
    com.simplemobiletools.smsmessenger SMS Messenger
    com.google.android.apps.messaging Messages
    com.gogii.textplus textPlus
    com.gogii.textplus textPlus
    app.fedilab.nitterizeme UntrackMe
    com.chooloo.www.koler Koler
    com.riteshsahu.SMSBackupRestore SMS Backup & Restore
    com.offlinechatapp.android OfflineChat
    com.raxis.signalapp Signal
    com.glodanif.bluetoothchat Bluetooth Chat
    me.bridgefy.main Bridgefy
    org.disrupted.rumble Rumble
    com.zegoggles.smssync SMS Backup+
    com.riteshsahu.SMSBackupRestore SMS Backup & Restore
    cz.psencik.smsforwarder.direct SMS Forwarder
    ru.perm.trubnikov.gps2sms GPS to SMS
    it.rignanese.leo.slimfacebook SlimSocial
    org.thoughtcrime.securesms Signal
    com.enflick.android.tn2ndLine 2ndLine
    com.hanan.android.ramkol Auto Speaker
    com.giga_recorderapp.callrecording Call Recorder
    com.geeksville.mesh Meshtastic
    ai.chat.gpt.app AI Chat
    eu.faircode.email FairEmail
    ch.protonmail.android Proton Mail
    com.nextcloud.client Nextcloud
    com.simplemobiletools.dialer smtDialer
    com.messages.chat Messages
    com.beeper.chat Beeper
    com.nll.cb ACR Phone
    com.nll.store NLL Store
    com.nll.helper APH
    com.applaudsoft.wabi.virtual_number Wabi
    com.trianguloy.openInWhatsapp Click to chat
    com.applaudsoft.wabi.virtual_number Wabi
    com.trianguloy.openInWhatsapp Click to chat
    com.simplemobiletools.smsmessenger SMS Messenger
    org.consumerreports.permissionslip.production PermissionSlip
    com.sideline.phone.number Sideline
    me.number.app.im 2nd Line
    kik.android Kik
    mod.piaohong.newsgroup NewsGroup
    de.ritscher.simplemobiletools.contacts.pro Contacts
    network.loki.messenger Session
    me.number.app.im 2nd Line
    =================================================================
    folder "buy"
    package_name app_title
    ------------ ---------
    com.simplemobiletools.calculator smtCalculator
    uno.platform.calculator Uno Calc
    org.solovyev.android.calculator Calculator++
    com.atharok.barcodescanner Barcode Scanner
    com.manateeworks.barcodescanners Barcode Scanner
    com.secuso.privacyFriendlyCodeScanner QR Scanner
    krow.dev.qrcode QR Code Reader
    com.adrianmejia.calculator Clean Calculator
    com.adrianmejia.calculator Clean Calculator
    com.google.zxing.client.android Barcode Scanner
    com.cardsapp.android Cards
    com.srowen.bs.android Barcode Scanner+
    com.scanteam.qrcodereader QR Code Scanner
    barcodescanner.qrscanner QR Code Scanner - Scan Barcode
    com.loves.finder Love's
    =================================================================
    folder "files"
    package_name app_title
    ------------ ---------
    com.folderv.file FV File Explorer
    ru.zdevs.zarchiver ZArchiver
    com.mixplorer MiX
    de.felixnuesse.extract Round Sync
    com.ghostsq.commander Ghost Commander
    com.simplemobiletools.filemanager.pro smtFile Manager
    pl.mkexplorer.kormateusz MK Explorer
    nextapp.fx FX
    com.amaze.filemanager Amaze
    com.amaze.fileutilities Amaze Utilities
    com.lonelycatgames.Xplore X-plore
    org.openintents.filemanager OI File Manager
    me.zhanghai.android.files Material Files
    com.skyjos.apps.fileexplorerfree Owlfiles
    com.cxinventor.file.explorer Cx File Explorer
    com.ghisler.android.TotalCommander Total Commander
    com.sec.android.app.myfiles My Files
    net.micode.fileexplorer File Explorer
    com.speedsoftware.explorer Explorer
    com.marc.files Files.marc
    com.dnielfe.manager Simple Explorer
    com.google.android.apps.nbu.files Files.nbu
    pl.solidexplorer2 Solid Explorer
    com.veniosg.dir Dir
    com.sovworks.edslite EDS Lite
    com.blackspruce.lpd LPD
    com.blackspruce.mupdf LPP
    keepass2android.keepass2android Keepass2Android
    com.owncloud.android ownCloud
    com.simplemobiletools.draw.pro smtDraw
    org.secuso.privacyfriendlysketching Sketches
    com.samsung.android.app.notes Samsung Notes
    com.microsoft.office.officehubrow Office
    com.nutomic.syncthingandroid Syncthing
    com.atr.tedit TEdit
    com.theolivetree.webdavserver WebDAV server
    org.korosoft.simplenotepad.android Notepad
    info.informationsea.apps.largetext Large Text
    com.google.android.diskusage DiskUsage
    ru.androidtools.texteditor Text Editor
    dev.leonlatsch.photok Photok
    com.google.android.diskusage DiskUsage
    me.kuder.diskinfo DiskInfo
    sa.storagetruth Storage Truth
    eu.thedarken.sdm SD Maid
    com.tengu.sharetoclipboard Share to Clipboard
    com.gsnathan.pdfviewer Pdf Viewer Plus
    com.artifex.mupdf.viewer.app MuPDF viewer
    com.gmail.anubhavdas54.whatsdeleted WhatsDeleted
    com.juthawong.android.mimechecker Ampare MIME Checker
    com.koushikdutta.backup Helium
    com.riteshsahu.SMSBackupRestore SMS Backup & Restore
    com.resilio.sync Sync
    com.bv.wifisync SyncMe
    com.genonbeta.TrebleShot TrebleShot
    com.tachibana.downloader Download Navi
    com.cgogolin.penandpdf Pen&PDF
    com.pspdfkit.viewer PDF Viewer
    com.avrapps.pdfviewer PDF Viewer Lite
    io.github.droidapps.pdfreader PDF Reader
    org.ninthfloor.copperpdf CuprumPDF
    swati4star.createpdf PDF Converter
    com.xodo.pdf.reader Xodo
    com.foxit.mobile.pdf.lite Foxit PDF
    com.kmo.pdf.converter PDF Converter
    com.reneph.passwordsafe Password Safe
    com.sec.android.easyMover Smart Switch
    org.mightyfrog.android.simplenotepad Simple Notepad
    keepass2android.keepass2android Keepass2Android
    com.orgzly Orgzly
    org.dmfs.tasks Tasks
    com.simplemobiletools.keyboard Keyboard
    com.simplemobiletools.notes.pro Notes
    org.coolreader Cool Reader
    com.isaiasmatewos.texpand Texpand
    com.checkboxtasksapp.android Checkbox
    com.runitrut.dailytodoapp Daily todo app
    com.ctoad.android.DoBe2 DoBeList
    com.Naina.Inc.getDone Get-done
    com.mayaal.todo My ToDo
    rakta.tech.todotasklist.doitnow To Do task List - Do it Now
    ch.martinstoeckli.silentnotes SilentNotes
    com.ghisler.tcplugins.LAN TotalCmd-LAN (Windows shares)
    com.syndoc.merlin Syndoc
    com.nutomic.syncthingandroid Syncthing
    com.legalimpurity.rsync Rsync
    org.amoradi.syncopoli Syncopoli
    com.droidvim DroidVim
    com.fiistudio.fiinote FiiNote
    net.gsantner.markor Markor
    sushi.hardcore.droidfs DroidFS
    dk.tacit.android.foldersync.lite FolderSync
    com.rk.xededitor Xed-Editor
    org.koreader.launcher KOReader
    com.ghisler.android.TotalCommander Total Commander
    com.ghisler.tcplugins.LAN TotalCmd-LAN (Windows shares)
    =================================================================
    folder "net"
    package_name app_title
    ------------ ---------
    eu.faircode.netguard NetGuard
    moe.shizuku.privileged.api Shizuku
    be.casperverswijvelt.unifiedinternetqs Better Internet Tiles
    net.openvpn.openvpn OpenVPN Connect
    de.blinkt.openvpn OpenVPN for Android
    com.theolivetree.webdavserver WebDAV server
    com.zq.webdav.app_free BestDAV Server (Free)
    com.smestorage WebDAV Xplorer
    com.celzero.bravedns Rethink
    com.celzero.bravedns Rethink
    net.stargw.fok Karma FW
    com.quad9.aegis Quad9 Connect
    cz.mroczis.netmonster cell NetMonster
    com.tts.imnos_mobile cell Mobile Trace
    com.novvia.fispy cell Signal Spy
    net.simplyadvanced.ltediscovery LTE Discovery (ads)
    com.ubnt.usurvey ubnt WiFiman
    make.more.r2d2.cellular_z Cellular-Z (ads)
    com.vrem.wifianalyzer FOSS WiFiAnalyzer
    com.manageengine.wifimonitor WiFi Analyzer and Surveyor
    ru.andr7e.wifimonitor efremov Wi-Fi Monitor
    com.keuwl.wifi Wifi Analyser (ads)
    com.etwok.netspotapp NetSpot
    com.blueline.signalchecklite SignalCheck Lite
    com.tools.netgel.netx NetX
    aws.apps.networkInfoIi Network Info II (ads)
    de.avm.android.wlanapp WLAN
    at.bitfire.davdroid DAVx|o-U-|
    de.maza.zpush ZPush
    tiar.ua.slf HTTP FS
    org.secuso.privacyfriendlywifimanager WiFi Manager
    be.ppareit.swiftp_free FTP Server (Free)
    org.primftpd primitive ftpd
    net.openvpn.openvpn OpenVPN Connect
    com.deependhulla.opensync OpenSync
    com.nutomic.syncthingandroid Syncthing
    org.zwanoo.android.speedtest Speedtest
    org.bitbatzen.wlanscanner WLANScanner
    com.helgekeck.wifitool WiFi Tool
    nu.firetech.android.wifiwarning WiFi Warning
    com.roysolberg.android.datacounter Data counter widget
    com.gordienoye.cellulardatanotifier Cellular Data Notifier
    com.mobidia.android.mdm My Data Manager
    de.dieterthiess.ipwidget IP Widget
    pan.alexander.tordnscrypt.gp InviZible Pro
    com.parsed.securitywall Puffer
    org.galexander.sshd SimpleSSHD
    com.arachnoid.sshelper SSHelper
    com.termux Termux
    com.agence3pp.euroconsumers euroconsumers
    org.localsend.localsend_app LocalSend
    net.nitroshare.android NitroShare
    com.liveradio.fmradio.radiotuner.radiostation.amradio FM Radio
    fm.a2d.sf SpiritF
    com.yuriy.openradio Open Radio
    com.cbfs.cbfscellidtracker CBFS Cell-Id Tracker
    com.syndoc.merlin Syndoc
    shareit.lite SHAREit Lite
    de.srlabs.snoopsnitch SnoopSnitch
    com.stoutner.privacycell Cell
    com.skibapps.cellspycatcher Cell Spy Catcher
    com.overlook.android.fing Fing
    com.fmsys.snapdrop Snapdrop
    com.neure.anddrop AndDrop
    com.heleron.wifiroamingfix Wifi Roaming Fix
    net.nirsoft.wificollector Wifi Collector
    com.beemdevelopment.aegis Aegis
    =============================================================================
    folder "web"
    package_name app_title
    ------------ ---------
    at.cmg.android.phonews PhoNews
    org.cromite.cromite Cromite
    org.bromite.bromite Bromite
    org.bromite.chromium Chromium
    com.duckduckgo.mobile.android DuckDuckGo
    com.epic.browser Epic
    org.torproject.torbrowser Tor Browser
    org.mozilla.focus Firefox Focus
    org.mozilla.firefox Firefox
    com.ghostery.android.ghostery Ghostery
    com.brave.browser Brave
    com.alohamobile.browser.lite Aloha Lite
    com.opera.browser Opera
    info.guardianproject.orfox OrfoxRIP
    org.torproject.torservices TorServices
    com.duns.padiapp PADI
    com.tasomaniac.openwith Open Link With
    cz.lsrom.webviewtest WebView Test
    com.deltacdev.websiteshortcut Website Shortcut
    =============================================================================
    folder "weather"
    package_name app_title
    ------------ ---------
    com.accuweather.android AccuWeather
    co.windyapp.android Windy.app
    aerow.us.aerowind AeroWind
    com.airvisual AirVisual
    org.asdtm.goodweather Good Weather
    com.macca895.sunriise Hey Sunrise
    com.lholman.hiweather hiweather
    com.neverads.just_weather just weather
    org.androworks.klara Klara
    uk.co.openweather OpenWeather
    org.woheller69.weather RadarWeather
    com.yoshi.rain Rain
    org.breezyweather Weather
    wangdaye.com.geometricweather Weather
    com.alexplas.weathernew Weather
    info.vazquezsoftware.weatheralarms Weather Alerts
    com.la.local.weather.forecast.app Weather Forecast
    com.windhub.marine.weather WindHub
    com.windyty.android Windy
    no.nrk.yr Yr
    =============================================================================
    folder "nature"
    package_name app_title
    ------------ ---------
    net.osmand.plus OsmAnd~
    ru.perm.trubnikov.gps2sms GPS to SMS
    com.app.compass.finddirection.digitalcompass.gpsutils.gpscompass Compass Direction
    com.vonglasow.michael.satstat SatStat
    org.ssandon.altimeter Altimeter
    ro.overwrite.azimuthcompass Azimuth Compass
    com.mirfatif.mylocation My Location
    eu.basicairdata.graziano.gpslogger GPS Logger
    net.psyberia.offlinemaps OfflineMaps
    com.emacberry.gpslogger GPSLogger II
    net.osmtracker OSMTracker for Android|orCR-o
    de.dennisguse.opentracks OpenTracks
    com.kylecorry.trail_sense Trail Sense
    com.keuwl.compass Compass
    org.primeit.compass Compass
    com.agnibho.android.solarcompass Solar Compass
    com.android.gpstest.osmdroid GPSTest
    org.efalk.altimeter Pressure Altimeter
    com.hoehenmesser.cjp Altimeter Plus
    com.Avenza Avenza Maps
    ca.abbro.androidmap Paper Maps
    com.trailheadlabs.outerspatial OuterSpatial
    com.keuwl.gpswaypoints GPS Waypoint Finder
    com.idle.sunboard Sun Board
    com.generalmagic.magicearth Magic Earth
    mobi.maptrek Trekarta
    mobi.maptrek.lite Trekarta Lite
    com.custommapsapp.android Custom Maps
    com.google.earth Earth
    com.gpspleinair.sunmoontime SunMoonTime
    com.noctuasoftware.stellarium_free Stellarium
    com.google.android.stardroid Sky Map
    com.sharpitor.nightsky20 Sextant Stars
    com.lavadip.skeye SkEye
    de.alcyone.livestarchart Live Star Chart
    com.phg.constellations Constellations
    mobile.application.forfree.earth Earth Viewer
    com.davidgrossapps.wildfire Wildfire Info
    com.myuniportal.android.apps.airwildfirelocationsnow Wildfire Locations Now
    ca.cmetcalfe.locationshare Location Share
    com.forrestguice.suntimeswidget Suntimes
    com.forrestguice.suntimescalendars Suntimes Calendars
    com.forrestguice.suntimeswidget Suntimes Alarms
    fm.a2d.sf SpiritF
    com.yuriy.openradio Open Radio
    com.liveradio.fmradio.radiotuner.radiostation.amradio FM Radio
    com.device_context.stepsmagic_free Best step counter
    com.bikegpx BikeGPX
    com.vecturagames.android.app.gpxviewer GPX Viewer
    com.rungo RunGo
    OziExplorer.Main OziExplorer
    com.syncitgroup.android.iamhere I'm Here!
    com.main.contacts.smsmanager SOS Alert
    ru.gavrikov.mocklocations Mock Locations
    com.sigseg.android.worldmap WorldMap
    de.topobyte.apps.bms.atlas TB Atlas
    com.momo.fakegps.locationchanger Fake GPS - Location Change
    com.app.compass.finddirection.digitalcompass.gpsutils.gpscompass Compass Direction
    com.iboism.gpxrecorder GPX Recorder
    com.mschloapps.basicgps basicGPS
    com.bundle.anchor anchor
    com.ratana.sunsurveyorlite Sun Surveyor Lite
    de.th.suncalcorg SunCalc org
    de.th.mooncalcorg MoonCalc org
    org.woheller69.whobird whoBIRD
    =============================================================================
    folder "auto"
    package_name app_title
    ------------ ---------
    com.lexa.fakegps Fake GPS
    com.mock.cartage Cartage
    com.generalmagic.magicearth Magic Earth
    app.vela Vela Maps
    com.google.android.apps.maps Maps
    com.waze Waze
    com.zoffcc.applications.zanavi ZANavi
    app.organicmaps Organic Maps
    com.sigseg.android.worldmap WorldMap
    gov.caltrans.quickmap QuickMap
    org.openorienteering.mapper Mapper
    com.adamsappls.carc CARR
    ru.perm.trubnikov.gps2sms GPS to SMS
    ca.cmetcalfe.locationshare Location Share
    com.syncitgroup.android.iamhere I'm Here!
    com.safetyapp.b.safe.emergencyapp SOS Alert
    com.github.ruleant.getback_gps GetBack GPS
    com.amtrak.rider Amtrak
    com.discipleskies.aaafindmycar Find My Car
    com.unagit.parkedcar Parked Car
    com.mapfactor.navigator Navigator
    com.gpstrip Gpstrip
    crc.carsapp.sacog Sac 511
    com.sgr_b2.compass Compass
    gbis.gbandroid GasBuddy
    com.borneq.heregpslocation Here GPS Location
    com.xintimex.emiliano.worldmap WorldMap
    nl.sogeti.android.gpstracker OpenGpsTracker
    de.mediaz.mxapp.hpbgeodefree World atlas MxGeo
    org.tengel.planisphere Planisphere
    com.underwood.route_optimiser Circuit
    com.wesaphzt.privatelocation Private Location
    org.y20k.trackbook Trackbook
    com.augmentra.viewranger.android ViewRanger
    me.danielbarnett.addresstogps AddressToGPS
    info.guardianproject.locationprivacy LocationPrivacy
    com.ionicbyrequest.sharemylocation shitn
    com.discipleskies.aaafindmycar Find My Car
    =============================================================================
    folder "pic"
    package_name app_title
    ------------ ---------
    com.simplemobiletools.gallery.pro smtGallery
    ru.tech.imageresizershrinker Image Toolbox
    deckers.thibault.aves Aves
    app.grapheneos.camera Camera
    net.sourceforge.opencamera Open Camera
    com.google.android.apps.cameralite GC night
    com.simplemobiletools.camera smtCamera
    pl.waskysoft.screenshotassistant Screenshot Assistant
    com.motorola.camera2 Camera
    com.dsphotoeditor.demoapp DS Photo Editor
    com.simplemobiletools.draw.pro smtDraw
    com.niksoftware.snapseed Snapseed
    co.inker Inker
    org.catrobat.paintroid Pocket Paint
    net.braincake.pixl.pixl Pixl
    com.gmail.anubhavdas54.whatsdeleted WhatsDeleted
    com.google.android.GoogleCamera PGCam
    audioscreenshot.awesomeapps.com.audioscreenshot Audio Screenshot
    us.koller.cameraroll Camera Roll
    com.nikon.wu.wmau wmu
    com.jarsilio.android.scrambledeggsif Scrambled Exif
    com.dozingcatsoftware.vectorcamera Vector Camera
    org.Gallery.App Gallery
    com.adfree.Gallery Gallery
    adfree.gallery Gallery
    de.k3b.android.lossless_jpg_crop LLCrop (lossless)
    org.Gallery.Pro Gallery
    de.kaffeemitkoffein.imagepipe Imagepipe
    com.moblynx.galleryicsold Gallery ICS
    com.arunsoft.icon Material Icon Maker
    de.k3b.android.androFotoFinder A Photo Manager
    com.sybu.simplegallery Gallery
    com.alienpants.leafpicrevived LeafPic Revived
    la.daube.photochiotte PhotoChiotte
    com.donnnno.arcticons Arcticons
    com.perracolabs.cpd Cameringo Lite
    com.intermedia.hd.camera.professional ProCam X Lite
    com.perracolabs.cpd Cameringo Lite
    com.intermedia.hd.camera.professional ProCam X Lite
    com.google.android.GoogleCamera penguin
    com.google.android.apps.cameralite Camera Go
    com.google.android.apps.cameralite wichaya
    pinguin2001.penguingcam Camera
    net.sourceforge.opencamera Open Camera
    de.stoehr.loviapps.wezoom weZoom
    dev.leonlatsch.photok Photok
    com.sixcarrots.peephole Peephole
    com.remoteguard.phototrap PhotoTrap
    com.sjm.camera PRO Motion Detector Camera
    com.d136.smbsecuritycamera Smb Security Camera
    pl.waskysoft.screenshotassistant Screenshot Assistant
    com.momocode.shortcuts Awesome Icons
    com.jndapp.lux.free.iconpack LuX Free
    com.whicons.iconpack Whicons
    scadica.prcl Precision Color
    com.aminbeheshti.exifviewer Exif Viewer
    com.srjuen.exifviewer Exif Viewer
    com.none.tom.exiferaser ExifEraser
    com.photograph.editexifphoto Exif Editor
    com.jarsilio.android.scrambledeggsif Exif adhoc del
    com.airbeat.device.inspector Camera2 Probe
    com.sybu.imageresizer Photo/Video Compressor
    ru.tech.imageresizershrinker Image Toolbox
    com.yuanfang2345.passport Nova ID Photo
    com.passportphoto.visaid.photomaker Passport Size Photo
    com.darkgalaxy.client.app_id_photo ID Photos Maker
    com.sec.android.app.camera Camera
    =============================================================================
    folder "audio"
    package_name app_title
    ------------ ---------
    com.simplemobiletools.dialer smtDialer
    com.simplycomplexapps.ASTellme Tell Me
    com.rom1v.sndcpy sndcpy
    com.google.android.apps.recorder GRecorder
    com.github.axet.audiorecorder Audio Recorder
    com.simplemobiletools.voicerecorder smtVoice Recorder
    com.simplemobiletools.musicplayer smtMusic Player
    com.danielkim.soundrecorder Sound Recorder
    com.tmobile.vvm.application Visual Voicemail
    com.motorola.fmplayer FM Radio
    com.catalinagroup.callrecorder Cube ACR
    org.y20k.transistor Transistor
    com.einmalfel.podlisten PodListen
    com.nll.acr ACR
    com.hitrolab.audioeditor AudioLab
    com.hudun.androidrecorder Voice to Text
    de.danoeh.antennapod AntennaPod
    com.sayhi.android.sayhitranslate SayHi
    com.herman.ringpod Ringpod
    com.google.android.apps.recorder Recorder
    com.herman.ringtone Ringtone Maker
    com.reallybadapps.podcastguru PodcastGuru
    com.kabouzeid.gramophone Phonograph
    com.nassiansoft.minipod Mini Pod
    com.rannsoft.soundoff SoundOff
    com.dc7.SilentModeToggle Silent Mode Toggle
    muter.muter Mute
    com.iven.musicplayergo Music Player GO
    com.aimp.player AIMP
    com.sqr5.android.player_jb Maple JB
    com.jrtstudio.AnotherMusicPlayer Rocket Player
    io.github.muntashirakon.Music Metro
    com.github.cythara Cythara
    com.geecko.QuickLyric QuickLyric
    com.piyush.newu.texttovoice PDF To Voice
    com.nll.acr ACR
    com.sayhi.android.sayhitranslate SayHi
    com.github.axet.audiorecorder Audio Recorder
    com.dimowner.audiorecorder Audio Recorder
    com.hanan.android.ramkol Auto Speaker
    com.danielkim.soundrecorder Sound Recorder
    com.richardtozer.dashcam DashCam
    com.google.android.apps.recorder Recorder
    com.nll.asr ASR
    com.iboism.dictate Dictate Everything
    ai.chat.gpt.app AI Chat
    com.tiptop.ai.chat.gpt AI Chat
    com.yuriy.openradio Open Radio
    com.liveradio.fmradio.radiotuner.radiostation.amradio FM Radio
    hesoft.T2S T2S
    com.ktix007.talk Talk FREE
    ak.alizandro.smartaudiobookplayer Smart AudioBook Player
    de.ph1b.audiobook Voice
    =============================================================================
    folder "vid"
    package_name app_title
    ------------ ---------
    org.schabi.newpipe NewPipe
    com.github.libretube LibreTube
    org.videolan.vlc VLC
    InfinityLoop1309.NewPipeEnhanced PipePipe
    com.junkfood.seal Seal
    is.xyz.mpv mpv
    jp.nalab.tomcam TomCam
    com.shallwaystudio.nodevideo NodeVideo
    com.mobivio.android.cutecut Cute CUT
    org.courville.nova Nova Video Player
    com.richardtozer.dashcam DashCam
    com.cbs.tve CBS
    com.cbs.app Paramount+
    com.nbcnews.msnbc.mobile MSNBC
    com.fadcam FadCam
    =============================================================================
    folder "todo"
    package_name app_title
    ------------ ---------
    org.secuso.privacyfriendlytodolist To-Do List
    com.maxistar.textpad Simple Text Editor
    com.sec.android.app.popupcalculator Calculator
    jakiganicsystems.simplestchecklist local cklst
    org.dmfs.tasks Tasks
    privacyfriendlyshoppinglist.secuso.org.privacyfriendlyshoppinglist Shopping List
    com.simplemobiletools.notes.pro Notes
    com.flt.checklist Check List
    com.github.andremiras.qrscan QRCode & Barcode scanner
    com.kenzap.checklist costco
    com.atr.tedit TEdit
    name.obrien.dave.lister Check Off
    com.samsung.android.app.notes Samsung Notes
    com.checklist.android Checklist
    com.secuso.privacyFriendlyCodeScanner QR Scanner
    name.soulayrol.rhaa.sholi ShoLi
    pallob.loop.com.notepad Notepad
    org.spectralsoft.textedit Text Edit
    com.lolo.io.onelist 1List
    org.aplicacion.jesuspc.pruebabarra Industrial Utility
    com.duy.calculator.free NCalc+
    org.openintents.shopping OI Shopping List
    com.woefe.shoppinglist Shopping List
    kdk.android.simplydo Simply Do
    org.tasks Tasks
    nl.mpcjanssen.simpletask Simpletask
    com.google.zxing.client.android Barcode Scanner
    me.scan.android.client QR Code Reader
    de.markusfisch.android.binaryeye Binary Eye
    info.aario.snotepad local
    org.billthefarmer.diary datedtodo
    com.alaskalinuxuser.justnotes parts
    click.dummer.textthing dollarstore
    com.aa.mynotes webbuy
    com.bijoysingh.quicknote notes
    com.simplemobiletools.notes Notes
    org.isoron.uhabits Habits
    de.reimardoeffinger.quickdic QuickDic
    com.rhmsoft.edit QuickEdit
    net.cozic.joplin Joplin
    org.billthefarmer.editor Editor
    nextapp.fx FX
    com.rhmsoft.edit QuickEdit
    click.dummer.textthing Retro Text Editor
    org.dmfs.tasks Tasks
    ch.martinstoeckli.silentnotes SilentNotes
    md.obsidian Obsidian
    =============================================================================
    folder "sensor"
    package_name app_title
    ------------ ---------
    com.elitecrest.orenda Orenda
    maderski.chargingindicator Charging Indicator
    de.rwth_aachen.phyphox phyphox
    com.sonova.phonak.dsapp myPhonak
    com.unitconverterpro.ucplite Unit Converter Pro
    com.solarpanelcalculator.ZishanAdThandar solarCalculator
    com.finalwire.aida64 AIDA64
    flar2.devcheck DevCheck
    com.toralabs.deviceinfo Device Info
    com.ytheekshana.deviceinfo Device Info
    ru.andr7e.deviceinfohw Device Info HW
    tk.hack5.treblecheck Treble Info
    com.evilscan.deviceinfo Device Info
    com.evo.inware Inware
    com.kgurgul.cpuinfo CPU Info
    com.cpuid.cpu_z CPU-Z
    com.pixplicity.devcheck Introspect
    com.trixels.deviceinfo System & Device Info: CPU, RAM
    org.uguess.android.sysinfo.pro Quick System Info PRO
    org.uguess.android.sysinfo Quick System Info
    com.darshancomputing.BatteryIndicatorPro BatteryBot Pro
    com.darshancomputing.BatteryIndicator BatteryBot
    com.gsamlabs.bbm GSam Battery Monitor
    com.asksven.betterbatterystats BetterBatteryStats
    org.secuso.privacyfriendlyactivitytracker Pedometer
    org.secuso.privacyfriendlyfoodtracker Food Tracker
    org.secuso.privacyfriendlyweather Weather
    com.llamalab.automate Automate
    ro.overwrite.azimuthcompass Azimuth Compass
    org.aplicacion.jesuspc.pruebabarra Industrial Utility
    com.keuwl.protractor Protractor
    com.keuwl.ruler Ruler
    com.nitish.privacyindicator Privacy Indicators
    com.trelleborg.tss.avc AreaVolumeCalculator
    com.krengr.wpc Water Project Calculator
    com.sumeet.areavolumecalculator Area & Volume Calculator
    cisterna.promo Calcolo Volume Cisterne
    com.gsamlabs.bbm GSam Battery Monitor
    com.keuwl.spiritlevel Spirit Level
    com.keuwl.ruler Ruler
    com.keuwl.protractor Protractor
    com.android.settings Settings
    org.asdtm.goodweather Good Weather
    org.vosk.demo Vosk Demo
    com.aitorguascone.myamsler My Amsler
    io.github.sds100.keymapper Key Mapper
    flar2.homebutton Button Mapper
    com.simplemobiletools.flashlight Flashlight
    com.urbandroid.inline PowerLine
    no.nordicsemi.android.mcp nRF Connect
    com.apple.trackerdetect Tracker Detect
    de.seemoo.at_tracking_detection.release AirGuard
    f.cking.software BLE Radar
    de.quantumphysique.trale trale
    org.woheller69.audiometry hEARtest
    com.keuwl.spiritlevel Spirit Level
    =============================================================================
    folder "apk"
    package_name app_title
    ------------ ---------
    io.github.muntashirakon.AppManager App Manager
    com.aurora.warden Warden
    scadica.aq App Finder
    checkapp.appinallcountries.available.showingcorrectly AppLens
    com.aurora.store Aurora Store
    app.accrescent.client Accrescent
    org.fdroid.basic F-Droid Basic
    com.looker.droidify Droid-ify
    com.aurora.adroid Aurora Droid
    org.fdroid.fdroid F-Droid
    com.github.yeriomin.yalpstore Yalp Store
    dev.imranr.obtainium Obtainium
    app.pwhs.universalinstaller Universal Installer
    com.aefyr.sai SAI
    moe.shizuku.privileged.api Shizuku
    com.noxinfinity.shell ShizuShell
    com.apkupdater APKUpdater
    pratham.bkm.appupdatechecker App Update Checker - Update Software
    com.update.software.updateallapps App Updater (ads)
    com.mirfatif.permissionmanagerx Permission Manager X
    in.yourstreet.permissionmanager Permission Manager
    superfreeze.tool.android SuperFreezZ
    tuple.me.dtools Doodly
    com.oasisfeng.island.fdroid Insular
    com.oasisfeng.island.fdroid Island Settings
    com.javiersantos.mlmanager ML Manager
    sk.styk.martin.apkanalyzer Apk Analyzer
    com.apk.editor APK Explorer & Editor
    com.ubqsoft.sec01 Application Inspector
    com.topjohnwu.magisk Magisk
    com.csdroid.pkg Package Names
    cz.seeq.prog.android.packageviewer Package Viewer
    com.oF2pks.applicationsinfo apps_Packages Info
    com.smartpack.packagemanager Package Manager
    com.frankygoes.myapks My APKs
    com.ses.app.apkexport APK Export
    net.muik.myappfinder My App Finder
    se.brokenbrain.drawer Organized Drawer
    net.ebt.appswitch App Swap
    com.google.android.diskusage DiskUsage
    org.malwarebytes.antimalware Malwarebytes
    mobi.infolife.appbackup App Backup & Restore
    com.oF2pks.classyshark3xodus ClassyShark3xodus
    com.ses.app.apkexport APK Export
    com.oF2pks.classyshark3xodus ClassyShark3xodus
    jp.gr.java_conf.hdak.drawer Draweroid
    com.oF2pks.chairlock Chairlock
    com.projectsexception.myapplist My App List
    com.oF2pks.chairlock Chairlock
    com.spencerstudios.applist My Apps
    de.onyxbits.listmyapps List My Apps
    au.radsoft.appdrawer App Drawer
    bg.projectoria.appinspector App Inspector
    umairayub.appmanager AppManager
    com.deltacdev.websiteshortcut Website Shortcut
    com.roysolberg.android.datacounter Data counter widget
    com.lolem.simpleappmanager Simple App Manager
    krow.dev.extractor ApkExtractor
    com.easwareapps.baria BARIA
    krow.dev.addetector Ad Detector
    axp.tool.apkextractor Apk Extractor
    mobi.usage.appbackup App Backup & Restore
    com.ruet_cse_1503050.ragib.appbackup.lite App Backup Lite
    com.oasisfeng.greenify Greenify
    com.morrison.applocklite Perfect AppLock
    io.github.subhamtyagi.privacyapplock App Lock
    com.whicons.iconpack Whicons
    com.dkanada.icecons Frost
    com.android.settings Settings
    com.elsdoerfer.android.autostarts Autostarts
    com.momocode.shortcuts Awesome Icons
    com.blankicon blankiconwidget
    com.android.settings Settings
    ussr.razar.inspector Inspector
    com.atolphadev.quikshort Quikshort
    com.cemique.shortcutwidgets Shortcut Widgets
    rk.android.app.shortcutmaker Shortcut Maker
    com.alextern.shortcuthelper Create Shortcut
    jp.miotti.ShortcutToURL Shortcut To URL
    com.casraq.android.apksignaturechecker APK signature checker
    com.app.detail App Detail
    org.codedrink.app_killer App Killer: Close Apps
    me.piebridge.brevent Brevent
    com.urbandroid.dontkillmyapp DontKillMyApp
    com.app.detail App Detail
    com.redsoft.zerocleaner Zero Cleaner
    com.github.bmx666.appcachecleaner.googleplay Cache Cleaner
    com.symantec.cleansweep Norton Clean
    jp.miotti.AndroidViewer Resource Viewer
    sarangal.packagemanager Package Manager
    com.aefyr.sai SAI
    net.kollnig.missioncontrol.fdroid TC
    gr.nikolasspyr.integritycheck Integrity Checker
    com.apkupdater APKUpdater
    =============================================================================
    folder "sys"
    package_name app_title
    ------------ ---------
    com.teslacoilsw.launcher Nova Settings
    com.f0x1d.logfox LogFox
    com.mirfatif.permissionmanagerx Permission Manager X
    com.llamalab.automate Automate
    ryey.easer Easer
    rikka.appops App Ops
    ninja.sesame.app.edge Sesame
    com.draco.ladb LADB
    moe.shizuku.privileged.api Shizuku
    com.noxinfinity.shell ShizuShell
    com.termux Termux
    org.connectbot ConnectBot
    by4a.setedit22 SetEdit
    com.android.systemui System UI demo mode
    com.jarsilio.android.autoautorotate Auto Auto-Rotate
    com.sovworks.edslite EDS Lite
    keepass2android.keepass2android Keepass2Android
    org.androidsoft.app.permission Permission Friendly Apps
    com.roysolberg.android.developertools Developer Tools
    jackpal.androidterm Terminal Emulator
    com.zzzmode.appopsx AppOpsX
    org.microg.nlp UnifiedNlp
    com.dp.logcatapp Logcat Reader
    moe.zhs.caffeine Caffeine
    com.motorola.moto Moto
    com.cpuid.cpu_z CPU-Z
    org.billthefarmer.editor android
    org.jessies.dalvikexplorer Dalvik Explorer
    com.aboutmycode.betteropenwith Better Open With
    jp.susatthi.ManifestViewer ManifestViewer
    de.jl.notificationlog NotificationLog
    ru.seva.finder Finder
    android.jonas.fakestandby FakeStandby
    com.seven.adclear AdClear
    com.tengu.sharetoclipboard Share to Clipboard
    com.voicetyping.alllanguages.speechtotext.englishconverter Easy Voice Typing in All Languages
    eu.faircode.netguard NetGuard
    flar2.homebutton Button Mapper
    com.irishin.buttonsremapper Buttons remapper
    io.github.sds100.keymapper Key Mapper
    you.in.spark.access.dots Access Dots
    com.elsdoerfer.android.autostarts Autostarts
    com.rs.autorun Autorun Manager
    com.autostart Auto Start
    in.blogspot.anselmbros.torchie Torchie
    org.dslul.openboard.inputmethod.latin OpenBoard
    com.llamalab.automate Automate
    eu.faircode.netguard NetGuard
    com.draco.ladb LADB
    de.halfreal.clipboardactions Clipboard Actions
    com.cemique.shortcutwidgets Shortcut Widgets
    rk.android.app.shortcutmaker Shortcut Maker
    com.alextern.shortcuthelper Create Shortcut
    com.deltacdev.websiteshortcut Website Shortcut
    ussr.razar.inspector Inspector
    com.softwarevalencia.openboard.inputmethod.latin OpenBoard valenci|a-a
    com.simplemobiletools.keyboard Keyboard
    com.simplemobiletools.flashlight Flashlight
    tuple.me.dtools Doodly
    com.illusion.checkfirm CheckFirm
    com.maforn.timedshutdown Timed Shutdown
    com.beemdevelopment.aegis Aegis
    helium314.keyboard HeliBoard
    com.teamviewer.teamviewer.market.mobile TeamViewer
    org.woheller69.whisperplus Whisper+
    dev.soupslurpr.transcribro Transcribro
    com.menny.android.anysoftkeyboard AnySoftKeyboard
    net.kollnig.missioncontrol TC
    moe.shizuku.privileged.api Shizuku
    com.machiav3lli.backup Neo Backup
    net.typeblog.shelter Shelter
    com.pluscubed.matlog MatLog
    =============================================================================
    folder "dock"
    package_name app_title
    ------------ ---------
    xyz.klinker.messenger Pulse
    opencontacts.open.com.opencontacts.debug OpenContacts
    com.whatsapp WhatsApp
    com.android.settings Settings
    shortcuts
    com.sec.android.app.voicenote SRecorder
    com.sec.android.app.camera Camera
    com.teslacoilsw.launcher Apps
    com.teslacoilsw.launcher Apps
    com.teslacoilsw.launcher Apps
    com.teslacoilsw.launcher Apps
    =============================================================================
    folder "shortcuts"
    package_name app_title
    ------------ ---------
    com.pw.wifishortcut WiFi Shortcut
    com.bundle.anchor anchor
    com.apps.settings Settings App
    com.netvor.settings.database.editor Settings Database Editor
    com.apple.trackerdetect Tracker Detect
    com.sec.android.app.myfiles Trash
    io.github.muntashirakon.AppManager Interceptor
    =============================================================================

    Note there was another pane for the apps that I don't use frequently,
    which is not indicated in this listing (e.g., plant identification).
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Lawrence =?iso-8859-13?q?D=FFOliveiro?=@ldo@nz.invalid to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 06:24:24 2026
    From Newsgroup: misc.phone.mobile.iphone

    On Sat, 21 Nov 2026 01:41:04 -0400, Maria Sophia wrote:

    Is it possible, with macOS/iOS to do what Windows/Android does?

    You would need an actual rCLcomputerrCY to be able to do that, and if you remember, Apple dropped the rCLComputerrCY part from its name decades ago.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Alan@nuh-uh@nope.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 00:14:03 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 2026-11-20 22:41, Maria Sophia wrote:
    How do you generate a list of every app you've put in every folder on
    your iOS home screen (similar to how I just did it on Android)?

    Is it possible, with macOS/iOS to do what Windows/Android does?

    The correct answer is:

    Who the hell cares?
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Alan@nuh-uh@nope.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 00:14:26 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 2026-11-20 23:24, Lawrence DrCOOliveiro wrote:
    On Sat, 21 Nov 2026 01:41:04 -0400, Maria Sophia wrote:

    Is it possible, with macOS/iOS to do what Windows/Android does?

    You would need an actual rCLcomputerrCY to be able to do that, and if you remember, Apple dropped the rCLComputerrCY part from its name decades ago.

    <yawn>
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From CrudeSausage@crude@sausa.ge to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 07:58:18 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 2026-11-21 2:14 a.m., Alan wrote:
    On 2026-11-20 22:41, Maria Sophia wrote:
    How do you generate a list of every app you've put in every folder on
    your iOS home screen (similar to how I just did it on Android)?

    Is it possible, with macOS/iOS to do what Windows/Android does?

    The correct answer is:

    Who the hell cares?

    +1

    Maria Sophia searches on the Internet for "things that nobody does that
    can be accomplished in Android but not iOS" and then asks us how to do it.
    --
    CrudeSausage
    MacBook Air M4 Sky Blue
    iPhone 13
    Friendly Apple zealot
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Brock McNuggets@brock.mcnuggets@gmail.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 08:55:37 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 21 Nov 2026, CrudeSausage wrote in <6b01956a$1$20$882e4bbb@reader.netnews.com>:
    On 2026-11-21 2:14 a.m., Alan wrote:
    On 2026-11-20 22:41, Maria Sophia wrote:
    How do you generate a list of every app you've put in every
    folder on your iOS home screen (similar to how I just did it on
    Android)?

    Is it possible, with macOS/iOS to do what Windows/Android does?

    The correct answer is:

    Who the hell cares?

    +1

    Maria Sophia searches on the Internet for "things that nobody does
    that can be accomplished in Android but not iOS" and then asks us
    how to do it.

    And it took about 2 minutes to find a way. The way is a bit
    convoluted and silly, but the task is uncommon... so it is what it
    is.
    --
    You can't find peace with someone at war with themselves.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 12:38:52 2026
    From Newsgroup: misc.phone.mobile.iphone

    Lawrence D Oliveiro wrote:
    Is it possible, with macOS/iOS to do what Windows/Android does?

    You would need an actual |computeri to be able to do that, and if you remember, Apple dropped the |Computeri part from its name decades ago.

    That's not only presciently funny in that iOS was designed, from the very start, to be so crippled as to keep people inside the Apple ecosystem.

    But I'm being serious in that I'm likely going to port my script to Python. That means it will run on all desktops and can work with any Android phone.

    Although, I could choose powershell7, go, node.js, bash or even C#/.NET10.

    The desktop part of Apple's ecosystem, I don't think, is as debilitatingly crippled as the mobile part of Apple's ecosystem was designed to be.

    Fact is, I have plenty of iOS devices where there's no reason I shouldn't desire to list apps and their folders into a file, just as with Android.

    That's not a difficult job... listing apps... and folders... to a file.
    But can the Apple ecosystem do something even that incredibly simple?

    It's a serious question because every time I do something on Android,
    I try to do it on iOS, and I find, that half the time, iOS is too crippled.

    But macOS isn't crippled like iOS is crippled, so I "think" the issue is
    iOS would be the limiting factor, as macOS should be reasonably adept.

    That is, if I port my scripts to python or to bash, they'll 'run' on macOS.
    So all I need is a program on iOS that is powerful enough to list apps.

    The question here is valid, and it pertains mostly to iOS at this point:
    Q: Is there a way to list all apps in each homescreen folder or not?
    A: ?

    Is there even a way to list all iOS apps to something as simple as a file?
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Brock McNuggets@brock.mcnuggets@gmail.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 09:41:27 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 21 Nov 2026, Maria Sophia wrote in <11dsher$307b$1@nnrp.usenet.blueworldhosting.com>:
    Lawrence D|+Oliveiro wrote:
    Is it possible, with macOS/iOS to do what Windows/Android does?

    You would need an actual -|computer-i to be able to do that, and if
    you remember, Apple dropped the -|Computer-i part from its name
    decades ago.

    That's not only presciently funny in that iOS was designed, from
    the very start, to be so crippled as to keep people inside the
    Apple ecosystem.

    It is made to be easy and usable -- hence why it is so popular. Your
    issue is jealousy. You are deeply insecure about your choices so you
    come here to try to get reassurance.

    <snip>

    Is there even a way to list all iOS apps to something as simple as
    a file?

    Yes.
    --
    You can't find peace with someone at war with themselves.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 16:48:44 2026
    From Newsgroup: misc.phone.mobile.iphone

    CrudeSausage wrote:
    "things that nobody does

    The question here is valid, as it's useful for inventory audits & archival.

    Q: Is there a way to list all apps in each homescreen folder or not?
    A: ?

    Is there even a way to list all iOS apps to something as simple as a file?

    NOTE:
    I'm well aware that Apple zealots typically respond "yes" (like we counted nospam as having done over a hundred times in a 3-year span), but just
    saying "yes" without showing some indication of how, is more telling than
    it appears to be, because what it really means is the respondent hates that Apple products are so crippled that they can't do the simplest of things
    that every other common consumer operating system has no problem doing.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Alan@nuh-uh@nope.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 14:18:20 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 2026-11-21 13:48, Maria Sophia wrote:
    CrudeSausage wrote:
    "things that nobody does

    The question here is valid, as it's useful for inventory audits & archival.

    Q: Is there a way to list all apps in each homescreen folder or not?
    A: ?

    Is there even a way to list all iOS apps to something as simple as a file?

    NOTE:
    I'm well aware that Apple zealots typically respond "yes" (like we counted nospam as having done over a hundred times in a 3-year span), but just
    saying "yes" without showing some indication of how, is more telling than
    it appears to be, because what it really means is the respondent hates that Apple products are so crippled that they can't do the simplest of things
    that every other common consumer operating system has no problem doing.

    1. Download "Apple Configurator" from the Mac App Store and launch it.

    2. Connect your iOS device to your Mac and select it in Apple Configurator.

    3. Choose "Export" > "Info..." from the "Actions" menu.

    4. Select "Device Information" and "Installed Apps".

    5. Click "Export"

    6. Choose the name and save location for the CSV file.

    Done.


    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Lawrence =?iso-8859-13?q?D=FFOliveiro?=@ldo@nz.invalid to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 21:40:26 2026
    From Newsgroup: misc.phone.mobile.iphone

    On Sat, 21 Nov 2026 16:48:44 -0400, Maria Sophia wrote:

    I'm well aware that Apple zealots typically respond "yes" ...

    But if the answer is rCLnorCY, they tend not to respond at all ...
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Brock McNuggets@brock.mcnuggets@gmail.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 14:41:53 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 21 Nov 2026, Maria Sophia wrote in <11dt03c$16nr$1@nnrp.usenet.blueworldhosting.com>:
    CrudeSausage wrote:
    "things that nobody does

    The question here is valid, as it's useful for inventory audits &
    archival.

    Q: Is there a way to list all apps in each homescreen folder or
    not? A: ?

    Yes.

    Is there even a way to list all iOS apps to something as simple as
    a file?

    Yes.

    NOTE:
    I'm well aware that Apple zealots typically respond "yes" (like we
    counted nospam as having done over a hundred times in a 3-year
    span), but just saying "yes" without showing some indication of
    how, is more telling than it appears to be, because what it really
    means is the respondent hates that Apple products are so crippled
    that they can't do the simplest of things that every other common
    consumer operating system has no problem doing.

    No.

    You leave out how you are a troll and how these questions are
    designed as "gotchas" AND have been answered.
    --
    You can't find peace with someone at war with themselves.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 18:23:32 2026
    From Newsgroup: misc.phone.mobile.iphone

    Lawrence DoOliveiro wrote:
    I'm well aware that Apple zealots typically respond "yes" ...

    But if the answer is no, they tend not to respond at all ...

    Hi Lawrence,

    Thanks for that succinct and honest-to-the-core bit of sagacious insight.

    One time, oh, I can't count the years, I asked the iOS newsgroups how to graphically display in real time the signal strength of all the nearby
    wi-fi access points, as this is something every other OS easily does.
    a. The immediate answer came back as "yes", but with no explanation.
    b. Hmmm..., well, it seems like a proper answer, right?
    c. I mean, how can iOS be so brain dead as to not be able to do that?

    And yet, it can't.

    Snit (Michael Glasser, Brock McNuggets, et al.) pasted, over 200 times!
    during that time that of course iOS could do something "even that simple".

    To "prove it", Snit proudly created this video showing that iOS was
    capable of something as trivially easy as graphing signal strength over
    time for all the nearby Wi-Fi (and cellular, by the way) access points.
    <https://youtu.be/7QaABa6DFIo> iKooks can't even see the fatal flaw!

    And yet, iOS can't do something even that simple.
    REFERENCE: Oct 10, 2017, 8:50:05 AM
    *It's a fact iOS devices can't even graph Wi-Fi signal strength over time*
    <https://groups.google.com/g/misc.phone.mobile.iphone/c/PZuec56EWB0>
    <https://groups.google.com/forum/#!topic/misc.phone.mobile.iphone/PZuec56EWB0>

    So why do the Apple religious zealots 'proudly' proclaim that their beloved product can do even these trivially simple things that every other OS does?

    The question I ask here is a valid question of how to reproduce what I can
    do on Android to get the panes, folders, apps and names into a file.

    You know more about the ecosystem than I do, so I appreciate your balanced
    view of things, which helps me learn what can and can not be done with iOS.

    Yours is a fair observation that a "no" (or no response) is, by omission, a tacit agreement, while a "yes" (sans explanation) cuts the other way. The
    "yes" crowd shows up fast when there's a win to claim and instantly
    vanishes when there isn't, which is kind'a sort'a what happened here.

    We all already know of the Apple Configurator which exports a flat list of installed apps, but the issue, clearly, was to gather folder associations.

    Hell, if all we wanted was a list of installed apps, adb works just fine:
    adb shell pm list packages -3

    Since there should be someone here knows the Apple ecosystem better than I
    do, how do we get the folder associations for every user-installed app?

    Notice that the Android output below has a folder name at the top and then
    the packages and titles of every app inside it. Given that it's a known
    issue that the Apple Configurator cannot produce that, the point remains
    that we need a way for iOS to expose home screen folder layout for export.

    So the question "how do you list every app in every folder", while I solved
    it for Android yesterday, it's still unanswered for the Apple ecosystem.

    If someone has a general (i.e., free so anyone can test it) method that
    returns iOS homescreen-pane to app-to-folder to position membership, I'll accept it and say thank you. Until then, "yes" followed by no explanation
    is even worse than yes followed by a procedure that doesn't do the thing.

    Here, for the record, is what that capability with Android can tell us.

    :: -------------------------------------------------------------------------
    :: adbfolder.bat
    :: -------------------------------------------------------------------------
    :: Outputs a perfect textual inventory, with debug capability, of an Android
    :: homescreen, including location of all panes, folders, packages and titles.
    ::
    :: Intended to assist in debugging, inventory, archival, backup and restore.
    :: Runs on Windows over Wi-Fi/USB, but can be ported to other platforms.
    ::
    :: Will pull a backup from android via adb or read an existing nova db or
    :: nova backup archive on windows needing only adb and sql dependencies
    ::
    :: List order is top to bottom, left to right, meaning the leftmost pane
    :: is 1st, the topleft folder is 1st, then the next folder to the right.
    ::
    :: Likewise, packages and titles inside of folders are listed in top to
    :: bottom order, left to right, providing an exact textual description.
    ::
    :: Bare icons, not inside folders, are listed separately as a line item.
    ::
    :: This script not only provides a textual inventory of the name and
    :: homescreen location of every folder name, package name and display
    :: name ever added to the homescreen, but it optionally will 'diff'
    :: against packages which were manually installed by the user but
    :: which have no current homescreen icon (i.e., "headless" apps).
    ::
    :: Note the display_name is the current icon title for a given app icon,
    :: which can be changed by the user, so it's not always the original.
    :: However, for apps installed by the user but without homescreen icons,
    :: the optional lookup pulls the app's original defined Android app_label.
    ::
    :: Output is appended to a timestamped running log file for traceability.
    :: Unless the user wipes out the running log, this becomes an automatic
    :: audit of all the physical changes a user has made to the homescreen.
    :: -------------------------------------------------------------------------
    :: v6p0 20261121 WIP...
    :: v5p9 20261121 Reformatted folder and pane output with a descriptive
    :: heading and two-space indentation, and added a timestamped
    :: running log file that accumulates formatted exports
    :: v5p8 20261121 Renamed app_title output column to display_name to
    :: distinguish the current homescreen icon title from the
    :: original Android application label and reformatted output
    :: v5p7 20261121 Moved the restore option to the local-file-path section
    :: v5p6 20261121 Improved comments and explanations and user prompts
    :: v5p5 20261120 Added option to open Nova Launcher settings on the device
    :: to create a fresh homescreen backup before listing/pulling
    :: v5p4 20261120 Appended a step-by-step flow description at the bottom
    :: v5p3 20261120 Moved per-pane scanning into a :scan_pane subroutine and
    :: cleaned up SQL/batch parsing in the pane loop so menu
    :: scanning runs without cmd.exe syntax errors
    :: v5p2 20261120 Fixed too many individual syntax problems to count between
    :: the last dozen versions, which were Windows CLI issues
    :: v4p5 20261119 Fixed loose apps package_name extraction in :run_query
    :: when component= has no slash or uses package=
    :: v4p4 20261119 Improved comments regarding filtering of the output data
    :: v4p3 20261119 Kept loose apps with all item types except itemType != 2 and
    :: removed parentheses from comment lines across the script
    :: v4p2 20261119 Removed extra iconPackage/component= check on loose apps
    :: so all non-folder items itemType != 2 on a pane are
    :: included without dropping rows
    :: v4p1 20261119 Restricted loose apps count and query to items that have a
    :: non-empty iconPackage or component= in intent while keeping
    :: all existing behavior, comments, and formatting intact
    :: v4p0 20261119 Gave up on trying to eliminate empty lines from PowerShell
    :: in the optional orphan-packages-with-no-launch icon listing
    :: so v4p0 is an exact duplicate of v3p6 which has blank lines
    :: v3p9 20261119 Moved menu scanning, SQLite querying, table formatting,
    :: and unplaced -3 package diffing into a dedicated PowerShell
    :: engine script so cmd.exe never hits block/caret/quote errors
    :: and fixed looseapps condition to itemType <> 2 and set DEBUG=0
    :: v3p8 20261119 Formatted unplaced user app table directly in PS_DIFF_3P
    :: instead of Format-Table to remove blank lines between rows
    :: v3p7 20261119 Fixed missing package_name in :run_query by replacing !=
    :: with LENGTH/TRIM checks and guarding SUBSTR against missing
    :: slashes and fixed pane loose apps SQL_WHERE to f.itemType <> 2
    :: v3p6 20261119 Added optional prompt before resolving Nova f.title names
    :: in check_missing_3p and printed periodic progress while
    :: resolving labels so quick checks finish immediately
    :: v3p5 20261119 Removed stray caret escaping before closing parentheses on
    :: standalone PS_DIFF_3P echo lines so PowerShell parses the
    :: generated script cleanly, and kept DEBUG=1 enabled
    :: v3p4 20261119 Added app label lookup via adb dumpsys and optional aapt/aapt2
    :: for unplaced user apps in check_missing_3p and set DEBUG=0
    :: as the default flag
    :: v3p3 20261119 Replaced != with LENGTH/TRIM checks in Nova package SQL
    :: query so cmd delayed expansion does not strip negation
    :: and handled component= values without a slash safely
    :: v3p2 20261119 Wrote Nova package SQL query to a temp .sql file to avoid
    :: cmd parsing syntax errors and wrote PS_DIFF_3P line-by-line
    :: instead of using an outer parenthesized block
    :: v3p1 20261119 Insrumented the orphan section as it was throwing errors
    :: v3p0 20261119 Fixed command syntax error when generating the PowerShell
    :: diff script in check_missing_3p and wrapped the Nova
    :: package query in a subquery so package_name matches cleanly
    :: v2p9 20261119 Added a final sanity check before quitting to compare
    :: the list of packages that have icons on the homescreen
    :: against all the user-installed packages on the phone
    :: to create an orphan-packages file that have no icons
    :: v2p8 20261119 Added quit option at folder selection prompt and loop back
    :: prompt at end to export another folder or pane
    :: v2p7 20261119 Replaced fragile DISTINCT screen loop with explicit pane
    :: index pass 0 to 9 using CAST screen AS INTEGER so panes
    :: with folders or loose apps always appear in order
    :: v2p6 20261119 Fixed pane screen query so folders on pane 0, pane 1 and
    :: pane 2 display properly along with loose pane apps and other
    :: v2p5 20261119 Grouped folders by screen number across panes and kept
    :: unmatched folders under other at the bottom
    :: v2p4 20261119 Added loose apps choice at the end of each pane with
    :: non-folder items and kept other catch-all at the bottom
    :: v2p3 20261119 Listed folders under dock and each pane with no default
    :: and skipped empty sections
    :: v2p2 20261119 Added full-layout option outputting dock and pane headers
    :: with package_name and app_title lines
    :: v2p1 20261119 Replaced backtick for /f calls on DOCK_TOTAL and PANE_TOTAL
    :: with temp file redirects so cmd reliably captures counts
    :: v2p0 20261119 Removed ampersand and parenthesis inside comment labels
    :: as labels are not comments even though they act like them
    :: v1p9 20261119 Removed item_type column from output and grouped folders
    :: by their homescreen pane eg, "Pane 0 Folder: weather"
    :: v1p8 20261119 Dynamically lists dock, eg, container = -101, and lists
    :: homescreen panes by screen number, eg, container = -100,
    :: and by named folders eg, itemType = 2, from nova db
    :: and includes item_type in output
    :: v1p7 20261119 Searches android storage for novabackup files when none
    :: are found in ANDROID_BCK_DIR, storing full remote paths so
    :: backups in any folder can be pulled cleanly
    :: v1p6 20261119 Set DEBUG=0 by default for clean normal output while keeping
    :: the toggle available for troubleshooting
    :: v1p5 20261119 Reversed output columns to package_name first, app_title
    :: second and added startup dependency check for adb and
    :: sqlite3 dependency checking configured paths and PATH
    :: v1p4 20261119 Moved powershell commands into %TEMP%\* ps1 scripts run via
    :: "-File" instead of backticks so cmd never parses "<" or ">"
    :: v1p3 20261119 Added DEBUG=1 instrumentation
    :: v1p2 20261119 Replaced cmd FOR sanitizer with powershell
    :: v1p1 20261119 Numbered selection menu for novabackup files, lists folders
    :: by name with numbered selection instead of raw container IDs
    :: v1p0 20261119 Initial version to pull backup or use local nova db, query
    :: sql via sqlite3 exe, select columns with powershell
    :: -------------------------------------------------------------------------
    ... snip code intended to be ported to macOS/Linux to help others...
    :: -------------------------------------------------------------------------
    :: end of adbfolder.bat
    :: -------------------------------------------------------------------------
    :: Step by step description of what this script does
    :: 1. Environment & Configuration Setup
    :: A. Command environment
    :: a. Disables command echoing and enables delayed expansion
    :: b. Sets the working directory to the script's path
    :: B. Configuration variables
    :: a. Sets default configuration paths for ADB, SQLite
    :: and work directories
    :: b. Defines the DEBUG toggle flag
    :: 2. Dependency Verification
    :: A. Executable checks
    :: a. Locates adb.exe and checks system PATH or configured fallback path
    :: b. Locates sqlite3.exe and exits with an error if missing
    :: B. Directory setup
    :: a. Creates the local working directory if it does not exist
    :: 3. Source Selection Menu
    :: A. Choice [1]: Pull from Android via ADB
    :: a. Detects connected ADB device target
    :: b. Lists .novabackup files in the remote backup directory
    :: with fallback search
    :: c. Prompts user to select or enter a backup filename/path
    :: d. Pulls the selected .novabackup file to the Windows workspace
    :: e. Renames the pulled file to backup.zip and extracts it
    :: into backup_extracted to retrieve nova.db
    :: B. Choice [2]: Use Local Database / Archive
    :: a. Prompts user for a custom path to nova.db .novabackup or .zip
    :: with a retry loop
    :: b. Validates file existence
    :: c. Automatically extracts archives if .novabackup or .zip file
    :: 4. Database Verification & Target Enumeration
    :: A. Database validation
    :: a. Verifies that nova.db exists at the target path
    :: B. Section 1 [Dock]
    :: a. Scans dock apps [container = -101]
    :: b. Scans and lists any dock folders
    :: C. Section 2 [Panes 0-14]
    :: a. Iterates through home screen panes 0 to 14
    :: via the scan_pane subroutine
    :: b. Queries pane folders [itemType = 2, container = -100]
    :: c. Checks for loose non-folder apps [itemType <> 2] on the pane
    :: D. Section 3 [Other Folders]
    :: a. Searches for orphaned folders not categorized under dock or panes
    :: b. Lists and registers valid other folders
    :: 5. User Selection & Query Execution [run_query]
    :: A. Selection & Sanity
    :: a. Prompts user to select a target number or quit [q or 0]
    :: b. Sanitizes the selected label using a temporary PowerShell
    :: script to generate a safe filename
    :: B. Query Generation & Execution
    :: a. Writes a dynamic SQLite query script to a temp file
    :: [.sql] extracting item ID, app title, package name and raw intent
    :: b. Executes the query against nova.db using sqlite3.exe
    :: C. Output & Formatting
    :: a. Formats output columns [package_name first, display_name second]
    :: into an auto-sized table via PowerShell
    :: b. Adds a descriptive pane/folder heading and indents the table
    :: by two spaces for easier reading and future concatenation
    :: c. Saves raw results [output.txt] and formatted results
    :: [target_apps.txt] to the work directory
    :: d. Appends each formatted export with a timestamp to
    :: [adbfolder_log.txt] without overwriting previous exports
    :: e. Prompts user to loop back to scan another folder/pane or proceed
    :: 6. Optional Unplaced Third-Party Package Check [check_missing_3p]
    :: A. Pre-check Validation
    :: a. Prompts user whether to check for user-installed packages
    :: [-3] missing from the Nova layout
    :: b. Verifies ADB device connectivity and database availability
    :: c. Optionally prompts user to resolve app labels via adb dumpsys
    :: and aapt/aapt2
    :: B. Data Collection
    :: a. Queries installed third-party packages from device
    :: [adb shell pm list packages -3]
    :: b. Queries all referenced packages inside nova.db
    :: C. Diff Analysis & Cleanup
    :: a. Generates and executes a PowerShell diff script to find
    :: installed packages with no home screen icon
    :: b. Outputs a formatted table of unplaced apps to
    :: unplaced_user_apps.txt
    :: c. Cleans up temporary script and text files
    :: [unless DEBUG=1] and exits cleanly
    :: -------------------------------------------------------------------------
    :: Not only is there a question of how to port this for more general use,
    :: but there's also a question of which common launchers will it work with.
    ::
    :: It may be that the native Android launcher may provide a 'parsable
    :: homescreen, so I looked up which might work in addition to Nova Launcher.
    ::
    :: So far, I "think" [tentatively] these will export/import a homescreen.
    :: a. Nova [SQL, .novabackup/nova.db restore]
    :: b. Lawnchair [.lawnchairbackup/restore]
    :: c. Mink [JSON backup/restore]
    :: d. Total Launcher [zip? backup/restore]
    :: e. Niagra [nlb backup/restore]
    :: d. Others? [SQLite, JSON, XML, etc.]
    :: -------------------------------------------------------------------------

    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Brock McNuggets@brock.mcnuggets@gmail.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 15:35:05 2026
    From Newsgroup: misc.phone.mobile.iphone

    On 21 Nov 2026, Maria Sophia wrote in <11dt5l4$r8b$1@nnrp.usenet.blueworldhosting.com>:
    Lawrence D-oOliveiro wrote:
    I'm well aware that Apple zealots typically respond "yes" ...

    But if the answer is no, they tend not to respond at all ...

    Hi Lawrence,

    Thanks for that succinct and honest-to-the-core bit of sagacious
    insight.

    One time, oh, I can't count the years, I asked the iOS newsgroups
    how to graphically display in real time the signal strength of all
    the nearby wi-fi access points, as this is something every other
    OS easily does. a. The immediate answer came back as "yes", but
    with no explanation. b. Hmmm..., well, it seems like a proper
    answer, right?
    c. I mean, how can iOS be so brain dead as to not be able to do
    that?

    And yet, it can't.

    Snit (Michael Glasser, Brock McNuggets, et al.) pasted, over 200
    times! during that time that of course iOS could do something
    "even that simple".

    To "prove it", Snit proudly created this video showing that iOS
    was capable of something as trivially easy as graphing signal
    strength over time for all the nearby Wi-Fi (and cellular, by the
    way) access points. <https://youtu.be/7QaABa6DFIo> iKooks can't
    even see the fatal flaw!

    You misrepresent the video. Do you even understand it?

    <snip>
    --
    You can't find peace with someone at war with themselves.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 21:53:55 2026
    From Newsgroup: misc.phone.mobile.iphone

    For the record, here is the Windows batch script I wrote yesterday that is what we'd like to accomplish with iOS over Wi-Fi/USB to any common desktop.

    This only works with Windows, but I'm almost done porting it to Python,
    which means it should work on macOS/Linux also (but I can't test them).

    On my 64GB Android, it found about a thousand packages which it listed in
    two panes, one dock, and a few dozen folders, by package name and by label.

    In addition, it found 65 headless packages, some of which I simply installed but forgot to place the launch icon while others are headless (like keyboards).

    I'll post the python equivalent separately, which can be run on macOS & Linux in addition to Windows (although I was only able to test it on Windows).

    :: -------------------------------------------------------------------------
    :: adbfolder.bat
    :: -------------------------------------------------------------------------
    :: Outputs a perfect textual inventory, with debug capability, of an Android
    :: homescreen, including location of all panes, folders, packages and titles.
    ::
    :: Intended to assist in debugging, inventory, archival, backup and restore.
    :: Runs on Windows over Wi-Fi/USB, but can be ported to other platforms.
    ::
    :: Will pull a backup from android via adb or read an existing nova db or
    :: nova backup archive on windows needing only adb and sql dependencies
    ::
    :: List order is top to bottom, left to right, meaning the leftmost pane
    :: is 1st, then subsequent panes, from 0 to 1 to 2 and so on to the right.
    ::
    :: Similarly, the topleft folder is 1st, then the next folder to the right.
    ::
    :: Likewise, packages and titles inside of folders are listed in top to
    :: bottom order, left to right, providing an exact textual description.
    ::
    :: Bare icons, not inside folders, are listed separately as a line item.
    :: The dock and folders in the dock are treated much like the panes are.
    ::
    :: This script not only provides a textual inventory of the name and
    :: homescreen location of every folder name, package name and display
    :: name ever added to the homescreen, but it optionally will 'diff'
    :: against packages which were manually installed by the user but
    :: which have no current homescreen icon (i.e., "headless" apps).
    ::
    :: Note the display_name is the current icon title for a given app icon,
    :: which can be changed by the user, so it's not always the original.
    :: However, for apps installed by the user but without homescreen icons,
    :: the optional lookup pulls the app's original defined Android app_label.
    ::
    :: Output is appended to a timestamped running log file for traceability.
    :: Unless the user wipes out the running log, this becomes an automatic
    :: audit of all the physical changes a user has made to the homescreen.
    :: -------------------------------------------------------------------------
    :: Q: Why is saying YES to "Resolve app titles via adb/aapt" very slow?
    :: A: For each of the unplaced packages, the script does:
    :: a. adb shell dumpsys package <pkg> to look for nonLocalizedLabel=
    :: b. If that fails: adb shell pm path <pkg> to find the APK location
    :: c. adb pull <apk> to download the APK to the PC
    :: d. aapt dump badging <apk> to read the app label from the APK
    :: Which is up to 4 ADB commands + 65 apps = 260 round-trips.
    :: Over USB, each round-trip is fast (milliseconds).
    :: But, over Wi-Fi, each one has wireless handshake latency,
    :: so the total time adds up just waiting on ADB to return results.
    :: -------------------------------------------------------------------------
    :: v6p1 20261121 WIP
    :: v6p0 20261121 Fixed ADB shell ls wildcard expansion by moving the closing
    :: quote after %ANDROID_BCK_DIR% so *.novabackup is not treated
    :: as a literal filename (which had forced a global search)
    :: v5p9 20261121 Reformatted folder and pane output with a descriptive
    :: heading and two-space indentation, and added a timestamped
    :: running log file that accumulates formatted exports
    :: v5p8 20261121 Renamed app_title output column to display_name to
    :: distinguish the current homescreen icon title from the
    :: original Android application label and reformatted output
    :: v5p7 20261121 Moved the restore option to the local-file-path section
    :: v5p6 20261121 Improved comments and explanations and user prompts
    :: v5p5 20261120 Added option to open Nova Launcher settings on the device
    :: to create a fresh homescreen backup before listing/pulling
    :: v5p4 20261120 Appended a step-by-step flow description at the bottom
    :: v5p3 20261120 Moved per-pane scanning into a :scan_pane subroutine and
    :: cleaned up SQL/batch parsing in the pane loop so menu
    :: scanning runs without cmd.exe syntax errors
    :: v5p2 20261120 Fixed too many individual syntax problems to count between
    :: the last dozen versions, which were Windows CLI issues
    :: v4p5 20261119 Fixed loose apps package_name extraction in :run_query
    :: when component= has no slash or uses package=
    :: v4p4 20261119 Improved comments regarding filtering of the output data
    :: v4p3 20261119 Kept loose apps with all item types except itemType != 2 and
    :: removed parentheses from comment lines across the script
    :: v4p2 20261119 Removed extra iconPackage/component= check on loose apps
    :: so all non-folder items itemType != 2 on a pane are
    :: included without dropping rows
    :: v4p1 20261119 Restricted loose apps count and query to items that have a
    :: non-empty iconPackage or component= in intent while keeping
    :: all existing behavior, comments, and formatting intact
    :: v4p0 20261119 Gave up on trying to eliminate empty lines from PowerShell
    :: in the optional orphan-packages-with-no-launch icon listing
    :: so v4p0 is an exact duplicate of v3p6 which has blank lines
    :: v3p9 20261119 Moved menu scanning, SQLite querying, table formatting,
    :: and unplaced -3 package diffing into a dedicated PowerShell
    :: engine script so cmd.exe never hits block/caret/quote errors
    :: and fixed looseapps condition to itemType <> 2 and set DEBUG=0
    :: v3p8 20261119 Formatted unplaced user app table directly in PS_DIFF_3P
    :: instead of Format-Table to remove blank lines between rows
    :: v3p7 20261119 Fixed missing package_name in :run_query by replacing !=
    :: with LENGTH/TRIM checks and guarding SUBSTR against missing
    :: slashes and fixed pane loose apps SQL_WHERE to f.itemType <> 2
    :: v3p6 20261119 Added optional prompt before resolving Nova f.title names
    :: in check_missing_3p and printed periodic progress while
    :: resolving labels so quick checks finish immediately
    :: v3p5 20261119 Removed stray caret escaping before closing parentheses on
    :: standalone PS_DIFF_3P echo lines so PowerShell parses the
    :: generated script cleanly, and kept DEBUG=1 enabled
    :: v3p4 20261119 Added app label lookup via adb dumpsys and optional aapt/aapt2
    :: for unplaced user apps in check_missing_3p and set DEBUG=0
    :: as the default flag
    :: v3p3 20261119 Replaced != with LENGTH/TRIM checks in Nova package SQL
    :: query so cmd delayed expansion does not strip negation
    :: and handled component= values without a slash safely
    :: v3p2 20261119 Wrote Nova package SQL query to a temp .sql file to avoid
    :: cmd parsing syntax errors and wrote PS_DIFF_3P line-by-line
    :: instead of using an outer parenthesized block
    :: v3p1 20261119 Insrumented the orphan section as it was throwing errors
    :: v3p0 20261119 Fixed command syntax error when generating the PowerShell
    :: diff script in check_missing_3p and wrapped the Nova
    :: package query in a subquery so package_name matches cleanly
    :: v2p9 20261119 Added a final sanity check before quitting to compare
    :: the list of packages that have icons on the homescreen
    :: against all the user-installed packages on the phone
    :: to create an orphan-packages file that have no icons
    :: v2p8 20261119 Added quit option at folder selection prompt and loop back
    :: prompt at end to export another folder or pane
    :: v2p7 20261119 Replaced fragile DISTINCT screen loop with explicit pane
    :: index pass 0 to 9 using CAST screen AS INTEGER so panes
    :: with folders or loose apps always appear in order
    :: v2p6 20261119 Fixed pane screen query so folders on pane 0, pane 1 and
    :: pane 2 display properly along with loose pane apps and other
    :: v2p5 20261119 Grouped folders by screen number across panes and kept
    :: unmatched folders under other at the bottom
    :: v2p4 20261119 Added loose apps choice at the end of each pane with
    :: non-folder items and kept other catch-all at the bottom
    :: v2p3 20261119 Listed folders under dock and each pane with no default
    :: and skipped empty sections
    :: v2p2 20261119 Added full-layout option outputting dock and pane headers
    :: with package_name and app_title lines
    :: v2p1 20261119 Replaced backtick for /f calls on DOCK_TOTAL and PANE_TOTAL
    :: with temp file redirects so cmd reliably captures counts
    :: v2p0 20261119 Removed ampersand and parenthesis inside comment labels
    :: as labels are not comments even though they act like them
    :: v1p9 20261119 Removed item_type column from output and grouped folders
    :: by their homescreen pane eg, "Pane 0 Folder: weather"
    :: v1p8 20261119 Dynamically lists dock, eg, container = -101, and lists
    :: homescreen panes by screen number, eg, container = -100,
    :: and by named folders eg, itemType = 2, from nova db
    :: and includes item_type in output
    :: v1p7 20261119 Searches android storage for novabackup files when none
    :: are found in ANDROID_BCK_DIR, storing full remote paths so
    :: backups in any folder can be pulled cleanly
    :: v1p6 20261119 Set DEBUG=0 by default for clean normal output while keeping
    :: the toggle available for troubleshooting
    :: v1p5 20261119 Reversed output columns to package_name first, app_title
    :: second and added startup dependency check for adb and
    :: sqlite3 dependency checking configured paths and PATH
    :: v1p4 20261119 Moved powershell commands into %TEMP%\* ps1 scripts run via
    :: "-File" instead of backticks so cmd never parses "<" or ">"
    :: v1p3 20261119 Added DEBUG=1 instrumentation
    :: v1p2 20261119 Replaced cmd FOR sanitizer with powershell
    :: v1p1 20261119 Numbered selection menu for novabackup files, lists folders
    :: by name with numbered selection instead of raw container IDs
    :: v1p0 20261119 Initial version to pull backup or use local nova db, query
    :: sql via sqlite3 exe, select columns with powershell
    :: -------------------------------------------------------------------------
    @echo off
    setlocal enabledelayedexpansion
    cd /d "%~dp0"

    :: --- Debug flag 1 = verbose DEBUG traces, 0 = quiet ---
    set "DEBUG=0"
    :: set "DEBUG=1"

    :: --- Configurable paths ---
    set "ADB_EXE=C:\app\editor\android\scrcpy\adb.exe"
    set "SQLITE_EXE=C:\app\editor\android\sdk\platform-tools\sqlite3.exe"
    set "WORK_DIR=C:\app\editor\android\scrcpy\nova"
    set "ANDROID_BCK_DIR=/storage/emulated/0/0000/bck/nova_backup"
    set "DEFAULT_CONTAINER=2921"

    if "%DEBUG%"=="1" (
    echo [DEBUG] SCRIPT_DIR="%~dp0"
    echo [DEBUG] CD="%CD%"
    echo [DEBUG] ADB_EXE="%ADB_EXE%"
    echo [DEBUG] SQLITE_EXE="%SQLITE_EXE%"
    echo [DEBUG] WORK_DIR="%WORK_DIR%"
    )

    :: -------------------------------------------------------------------------
    :: Startup dependency and PATH check for adb exe and sqlite3 exe
    :: -------------------------------------------------------------------------
    echo Checking required tools (adb and sqlite3) ...

    set "PATH_ADB="
    for /f "usebackq delims=" %%W in (`where adb 2^>nul`) do (
    if "!PATH_ADB!"=="" set "PATH_ADB=%%W"
    )

    set "PATH_SQLITE="
    for /f "usebackq delims=" %%W in (`where sqlite3 2^>nul`) do (
    if "!PATH_SQLITE!"=="" set "PATH_SQLITE=%%W"
    )

    if "%DEBUG%"=="1" (
    echo [DEBUG] PATH_ADB="!PATH_ADB!"
    echo [DEBUG] PATH_SQLITE="!PATH_SQLITE!"
    )

    :: Prefer configured path if it exists, otherwise fall back to PATH
    if not exist "%ADB_EXE%" (
    if not "!PATH_ADB!"=="" (
    echo [INFO] Configured ADB_EXE not found; using PATH: "!PATH_ADB!"
    set "ADB_EXE=!PATH_ADB!"
    ) else (
    echo [WARN] adb.exe not found at "%ADB_EXE%" and not in PATH.
    )
    ) else if "!PATH_ADB!"=="" (
    echo [INFO] adb.exe found at configured path, though not in PATH.
    )

    if not exist "%SQLITE_EXE%" (
    if not "!PATH_SQLITE!"=="" (
    echo [INFO] Configured SQLITE_EXE not found; using PATH: "!PATH_SQLITE!"
    set "SQLITE_EXE=!PATH_SQLITE!"
    ) else (
    echo [ERROR] sqlite3.exe not found at "%SQLITE_EXE%" and not in PATH.
    pause
    exit /b 1
    )
    ) else if "!PATH_SQLITE!"=="" (
    echo [INFO] sqlite3.exe found at configured path, though not in PATH.
    )

    if not exist "%WORK_DIR%" mkdir "%WORK_DIR%"

    echo Working directory: "%CD%"
    echo Nova work directory: "%WORK_DIR%"
    echo ----------------
    echo.
    echo Select source for Nova Launcher database:
    echo [1] Pull .novabackup from Android via ADB and extract nova.db [Default]
    echo [2] Use an existing nova.db or .novabackup or .zip already on Windows
    echo.
    set "SRC_CHOICE=1"
    set /p "SRC_CHOICE=Enter choice [1 or 2]: "
    if "%DEBUG%"=="1" echo [DEBUG] SRC_CHOICE="!SRC_CHOICE!"

    if "%SRC_CHOICE%"=="2" goto :use_local_source
    if "%SRC_CHOICE%"=="1" goto :pull_from_android
    goto :pull_from_android

    :: -------------------------------------------------------------------------
    :: Option 1: Pull backup from android via adb
    :: -------------------------------------------------------------------------
    :pull_from_android
    echo.
    echo --- Pull Nova Backup from Android ---

    if not exist "%ADB_EXE%" (
    echo [ERROR] adb.exe not found at: "%ADB_EXE%"
    pause
    exit /b 1
    )

    set "ADB_TARGET="
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!ADB_TARGET!"=="" set "ADB_TARGET=%%g"
    )
    )

    if "%DEBUG%"=="1" echo [DEBUG] ADB_TARGET="!ADB_TARGET!"

    if "!ADB_TARGET!"=="" (
    echo [ERROR] No connected ADB devices found.
    pause
    exit /b 1
    )

    :: beginning of changes in v5p5
    echo Targeting device: %ADB_TARGET%

    set "MAKE_BCK="
    set /p "MAKE_BCK=Open Nova Launcher settings on device to create a new backup first? [y/N]: "
    if /i "!MAKE_BCK!"=="y" (
    echo Launching Nova Launcher settings on %ADB_TARGET% ...
    echo "Tap Backup & restore > Backup > Save to save to your device"
    "%ADB_EXE%" -s %ADB_TARGET% shell am start -n com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity
    echo Create your backup in Nova Launcher on the device, then press ENTER to list backups.
    pause
    )

    echo Listing backups in %ANDROID_BCK_DIR% ...
    echo.

    "%ADB_EXE%" -s %ADB_TARGET% shell ls -1t "%ANDROID_BCK_DIR%"/*.novabackup 2>nul > "%TEMP%\nova_backups.txt"

    if "%DEBUG%"=="1" (
    echo [DEBUG] ls exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %TEMP%\nova_backups.txt contents:
    type "%TEMP%\nova_backups.txt" 2>nul
    )

    set "BCK_COUNT=0"
    for /f "usebackq delims=" %%B in ("%TEMP%\nova_backups.txt") do (
    set "LINE=%%B"
    if not "!LINE!"=="" (
    set "LINE=!LINE:^M=!"
    for %%F in ("!LINE!") do set "FNAME=%%~nxF"
    set /a BCK_COUNT+=1
    set "BCK_ITEM_!BCK_COUNT!=!FNAME!"
    set "BCK_PATH_!BCK_COUNT!=!LINE!"
    echo [!BCK_COUNT!] !FNAME!
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_ITEM_!BCK_COUNT!="!FNAME!"
    echo [DEBUG] BCK_PATH_!BCK_COUNT!="!LINE!"
    )
    )
    )
    del "%TEMP%\nova_backups.txt" >nul 2>&1

    if %BCK_COUNT% EQU 0 (
    echo [INFO] No .novabackup files found in %ANDROID_BCK_DIR%.
    echo Searching Android storage for *.novabackup files ...
    echo.

    "%ADB_EXE%" -s %ADB_TARGET% shell "for d in /storage/emulated/0 /storage/*; do [ -d \"\$d\" ] && [ \"\$d\" != \"/storage/emulated\" ] && find \"\$d\" -maxdepth 5 -name '*.novabackup' 2>/dev/null; done" 2>nul > "%TEMP%\nova_backups_search.txt"

    if "%DEBUG%"=="1" (
    echo [DEBUG] Search exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %TEMP%\nova_backups_search.txt contents:
    type "%TEMP%\nova_backups_search.txt" 2>nul
    )

    for /f "usebackq delims=" %%S in ("%TEMP%\nova_backups_search.txt") do (
    set "LINE=%%S"
    if not "!LINE!"=="" (
    set "LINE=!LINE:^M=!"
    for %%F in ("!LINE!") do set "FNAME=%%~nxF"
    set /a BCK_COUNT+=1
    set "BCK_ITEM_!BCK_COUNT!=!FNAME!"
    set "BCK_PATH_!BCK_COUNT!=!LINE!"
    echo [!BCK_COUNT!] !LINE!
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_ITEM_!BCK_COUNT!="!FNAME!"
    echo [DEBUG] BCK_PATH_!BCK_COUNT!="!LINE!"
    )
    )
    )
    del "%TEMP%\nova_backups_search.txt" >nul 2>&1
    )

    if %BCK_COUNT% EQU 0 (
    echo [WARN] No .novabackup files found in %ANDROID_BCK_DIR% or Android storage.
    :manual_bck
    set "BCK_FILE="
    set /p "BCK_FILE=Enter backup filename or full Android path e.g. 2026-11-19_12-57.novabackup: "
    if "!BCK_FILE!"=="" (
    echo [ERROR] No backup filename provided.
    pause
    exit /b 1
    )
    set "BCK_FILE=!BCK_FILE:"=!"
    set "REMOTE_BCK=!BCK_FILE!"
    if not "!REMOTE_BCK:~0,1!"=="/" set "REMOTE_BCK=%ANDROID_BCK_DIR%/!BCK_FILE!"
    for %%F in ("!REMOTE_BCK!") do set "BCK_FILE=%%~nxF"
    goto :pull_selected_backup
    )

    echo.
    set "BCK_PICK=1"
    set /p "BCK_PICK=Select backup number [1-%BCK_COUNT%, Default: 1]: "
    if "!BCK_PICK!"=="" set "BCK_PICK=1"
    if "%DEBUG%"=="1" echo [DEBUG] BCK_PICK="!BCK_PICK!"

    set "BCK_FILE="
    set "REMOTE_BCK="
    for /l %%N in (1,1,%BCK_COUNT%) do (
    if "!BCK_PICK!"=="%%N" (
    set "BCK_FILE=!BCK_ITEM_%%N!"
    set "REMOTE_BCK=!BCK_PATH_%%N!"
    )
    )

    if "!BCK_FILE!"=="" (
    set "CANDIDATE=!BCK_PICK:"=!"
    set "REMOTE_BCK=!CANDIDATE!"
    if not "!REMOTE_BCK:~0,1!"=="/" set "REMOTE_BCK=%ANDROID_BCK_DIR%/!CANDIDATE!"
    for %%F in ("!REMOTE_BCK!") do set "BCK_FILE=%%~nxF"
    )
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_FILE="!BCK_FILE!"
    echo [DEBUG] REMOTE_BCK="!REMOTE_BCK!"
    )

    :pull_selected_backup
    set "LOCAL_BCK=%WORK_DIR%\%BCK_FILE%"
    set "LOCAL_ZIP=%WORK_DIR%\backup.zip"
    set "EXTRACT_DIR=%WORK_DIR%\backup_extracted"

    echo.
    echo Pulling "%REMOTE_BCK%" to "%LOCAL_BCK%" ...
    "%ADB_EXE%" -s %ADB_TARGET% pull "%REMOTE_BCK%" "%LOCAL_BCK%"
    if errorlevel 1 (
    echo [ERROR] Failed to pull backup from Android.
    pause
    exit /b 1
    )

    if exist "%LOCAL_ZIP%" del /f /q "%LOCAL_ZIP%"
    ren "%LOCAL_BCK%" "backup.zip"
    if errorlevel 1 (
    echo [ERROR] Failed to rename "%LOCAL_BCK%" to backup.zip.
    pause
    exit /b 1
    )

    if exist "%EXTRACT_DIR%" rmdir /s /q "%EXTRACT_DIR%"
    echo Extracting backup.zip to "%EXTRACT_DIR%" ...
    powershell -NoProfile -Command "Expand-Archive -LiteralPath '%LOCAL_ZIP%' -DestinationPath '%EXTRACT_DIR%' -Force"
    if errorlevel 1 (
    echo [ERROR] Failed to extract backup.zip.
    pause
    exit /b 1
    )

    set "DB_PATH=%EXTRACT_DIR%\nova.db"

    goto :verify_db

    :: -------------------------------------------------------------------------
    :: Option 2: Use local nova db or novabackup or zip
    :: -------------------------------------------------------------------------
    :use_local_source
    echo.
    echo --- Local Database Selection ---
    echo Enter the path to nova.db or a .novabackup or .zip file.
    echo Default: "%WORK_DIR%\backup_extracted\nova.db"
    echo.

    :ask_local_db
    set "USER_DB="
    set /p "USER_DB=Path to database or backup file [Enter for default]: "

    if "!USER_DB!"=="" (
    set "DB_PATH=%WORK_DIR%\backup_extracted\nova.db"
    ) else (
    set "USER_DB=!USER_DB:"=!"
    for %%A in ("!USER_DB!") do set "DB_PATH=%%~fA"
    )

    if not exist "%DB_PATH%" (
    echo [ERROR] File not found: "%DB_PATH%"
    set "RETRY="
    set /p "RETRY=Try again? [Y/n]: "
    if /i "!RETRY!"=="n" exit /b 1
    goto :ask_local_db
    )

    for %%E in ("%DB_PATH%") do set "EXT=%%~xE"
    if /i "!EXT!"==".novabackup" goto :local_novabackup
    if /i "!EXT!"==".zip" goto :extract_local_archive
    goto :verify_db

    :local_novabackup
    echo.
    set "RESTORE_LOCAL="
    set /p "RESTORE_LOCAL=Restore this backup in Nova on the connected device? [y/N]: "
    if /i not "!RESTORE_LOCAL!"=="y" goto :extract_local_archive

    if not exist "%ADB_EXE%" (
    echo [ERROR] adb.exe not found at "%ADB_EXE%"; cannot send the backup to the device.
    pause
    exit /b 1
    )

    set "RESTORE_TARGET="
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!RESTORE_TARGET!"=="" set "RESTORE_TARGET=%%g"
    )
    )

    if "!RESTORE_TARGET!"=="" (
    echo [ERROR] No connected ADB device found; cannot restore the backup.
    pause
    exit /b 1
    )

    set "NOVA_BACKUP_DIR=/storage/emulated/0/Android/data/com.teslacoilsw.launcher/files/Backup"
    echo Copying "%DB_PATH%" to Nova's backup folder on !RESTORE_TARGET! ...
    "%ADB_EXE%" -s !RESTORE_TARGET! shell mkdir -p "%NOVA_BACKUP_DIR%"
    if errorlevel 1 (
    echo [ERROR] Could not create Nova's backup folder on the device.
    pause
    exit /b 1
    )

    "%ADB_EXE%" -s !RESTORE_TARGET! push "%DB_PATH%" "%NOVA_BACKUP_DIR%/"
    if errorlevel 1 (
    echo [ERROR] Failed to copy the backup to the device.
    pause
    exit /b 1
    )

    echo Launching Nova Launcher settings on !RESTORE_TARGET! ...
    "%ADB_EXE%" -s !RESTORE_TARGET! shell am start -n com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity
    echo In Nova, choose Backup & restore and restore the backup you copied.
    goto :extract_local_archive

    :extract_local_archive
    set "EXTRACT_DIR=%WORK_DIR%\backup_extracted"
    if exist "%EXTRACT_DIR%" rmdir /s /q "%EXTRACT_DIR%"
    echo Extracting "%DB_PATH%" to "%EXTRACT_DIR%" ...
    powershell -NoProfile -Command "Expand-Archive -LiteralPath '%DB_PATH%' -DestinationPath '%EXTRACT_DIR%' -Force"
    if errorlevel 1 (
    echo [ERROR] Failed to extract archive.
    pause
    exit /b 1
    )
    set "DB_PATH=%EXTRACT_DIR%\nova.db"

    :: -------------------------------------------------------------------------
    :: Verify database and list dock, panes, folders and other
    :: -------------------------------------------------------------------------
    :verify_db
    if not exist "%DB_PATH%" (
    echo [ERROR] nova.db not found at: "%DB_PATH%"
    pause
    exit /b 1
    )

    echo.
    echo Using database: "%DB_PATH%"
    echo Scanning Nova Launcher dock, panes and folders ...
    echo.

    set "TGT_COUNT=0"
    set "LISTED_FOLDER_IDS=,"

    :: 1 Dock section first as [1] dock apps plus dock folders if any
    echo dock
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=dock apps"
    set "TGT_WHERE_!TGT_COUNT!=f.container = -101"
    set "TGT_ORDER_!TGT_COUNT!=f.screen, f.cellY, f.cellX, f.rank, f._id"
    echo [!TGT_COUNT!] dock apps

    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 AND container = -101 ORDER BY cellY, cellX, rank, _id;" > "%TEMP%\nova_dock_folders.txt" 2>nul
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_dock_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=dock - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    set "LISTED_FOLDER_IDS=!LISTED_FOLDER_IDS!!FID!,"
    echo [!TGT_COUNT!] !FNAME!
    )
    )
    del "%TEMP%\nova_dock_folders.txt" >nul 2>&1

    :: 2 Panes 0 to 14 with folders and loose apps via :scan_pane subroutine
    for /l %%P in (0,1,14) do (
    call :scan_pane %%P
    )

    :: 3 Other folders not already listed under dock or a pane
    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 ORDER BY LOWER(title), _id;" > "%TEMP%\nova_other_folders.txt" 2>nul
    set "OTHER_HAS_FOLDERS=0"
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_other_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    echo !LISTED_FOLDER_IDS! | findstr /c:",!FID!," >nul
    if errorlevel 1 (
    if "!OTHER_HAS_FOLDERS!"=="0" (
    echo other
    set "OTHER_HAS_FOLDERS=1"
    )
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=other - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    echo [!TGT_COUNT!] !FNAME!
    )
    )
    )
    del "%TEMP%\nova_other_folders.txt" >nul 2>&1

    echo.
    set "TGT_PICK="
    :: Allow q or 0 to quit cleanly without running a query
    set /p "TGT_PICK=Select number [1-%TGT_COUNT%, q to quit]: "
    if "%DEBUG%"=="1" echo [DEBUG] TGT_PICK="!TGT_PICK!"

    if /i "!TGT_PICK!"=="q" goto :check_missing_3p
    if "!TGT_PICK!"=="0" goto :check_missing_3p

    set "SELECTED_LABEL="
    set "SQL_WHERE="
    set "SQL_ORDER="
    for /l %%N in (1,1,%TGT_COUNT%) do (
    if "!TGT_PICK!"=="%%N" (
    set "SELECTED_LABEL=!TGT_LABEL_%%N!"
    set "SQL_WHERE=!TGT_WHERE_%%N!"
    set "SQL_ORDER=!TGT_ORDER_%%N!"
    )
    )

    if "%DEBUG%"=="1" (
    echo [DEBUG] SELECTED_LABEL="!SELECTED_LABEL!"
    echo [DEBUG] SQL_WHERE="!SQL_WHERE!"
    echo [DEBUG] SQL_ORDER="!SQL_ORDER!"
    )

    if "!SQL_WHERE!"=="" (
    echo [ERROR] Invalid selection: "!TGT_PICK!"
    pause
    exit /b 1
    )

    :run_query
    if "%DEBUG%"=="1" echo [DEBUG] Entering :run_query

    :: Write label character replacer ps1 to %TEMP% so cmd never parses regex characters
    set "PS_SANITIZE=%TEMP%\adbfolder_sanitize.ps1"
    set "SAFE_NAME_FILE=%TEMP%\adbfolder_safename.txt"

    "%PS_SANITIZE%" echo $raw = $env:SELECTED_LABEL
    "%PS_SANITIZE%" echo $s = [regex]::Replace($raw, '[\\/:*?"<>|() ]+', '_')
    "%PS_SANITIZE%" echo $s = $s.Trim('_')
    "%PS_SANITIZE%" echo if ([string]::IsNullOrWhiteSpace($s)) { $s = "nova_target" }
    "%PS_SANITIZE%" echo [System.IO.File]::WriteAllText($env:SAFE_NAME_FILE, $s, (New-Object System.Text.UTF8Encoding($false)))

    if "%DEBUG%"=="1" (
    echo [DEBUG] Wrote "%PS_SANITIZE%"
    echo [DEBUG] Running character replacer PowerShell script...
    )

    powershell -NoProfile -ExecutionPolicy Bypass -File "%PS_SANITIZE%"
    if "%DEBUG%"=="1" echo [DEBUG] Character replacer exit errorlevel=!errorlevel!

    set "SAFE_NAME="
    if exist "%SAFE_NAME_FILE%" (
    for /f "usebackq delims=" %%S in ("%SAFE_NAME_FILE%") do set "SAFE_NAME=%%S"
    )
    if "!SAFE_NAME!"=="" set "SAFE_NAME=nova_target"

    del "%PS_SANITIZE%" >nul 2>&1
    del "%SAFE_NAME_FILE%" >nul 2>&1

    if "%DEBUG%"=="1" echo [DEBUG] SAFE_NAME="!SAFE_NAME!"

    set "RAW_OUT=%WORK_DIR%\output.txt"
    set "CLEAN_OUT=%WORK_DIR%\%SAFE_NAME%_apps.txt"
    set "LOG_OUT=%WORK_DIR%\adbfolder_log.txt"
    set "SQL_QUERY_FILE=%TEMP%\adbfolder_query.sql"

    if "%DEBUG%"=="1" (
    echo [DEBUG] RAW_OUT="%RAW_OUT%"
    echo [DEBUG] CLEAN_OUT="%CLEAN_OUT%"
    echo [DEBUG] SQL_QUERY_FILE="%SQL_QUERY_FILE%"
    )

    echo.
    echo Querying "!SELECTED_LABEL!" ...

    "%SQL_QUERY_FILE%" echo .header on
    "%SQL_QUERY_FILE%" echo .mode tabs
    "%SQL_QUERY_FILE%" echo SELECT f._id AS item_id,
    "%SQL_QUERY_FILE%" echo f.title AS display_name,
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN f.iconPackage IS NOT NULL AND LENGTH(TRIM(f.iconPackage^)^) ^> 0 THEN TRIM(f.iconPackage^)
    "%SQL_QUERY_FILE%" echo WHEN INSTR(f.intent, 'component='^) ^> 0 THEN
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), '/'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), '/'^) - 1^)
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), ';'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), ';'^) - 1^)
    "%SQL_QUERY_FILE%" echo ELSE SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^)
    "%SQL_QUERY_FILE%" echo END
    "%SQL_QUERY_FILE%" echo WHEN INSTR(f.intent, 'package='^) ^> 0 THEN
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), ';'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), ';'^) - 1^)
    "%SQL_QUERY_FILE%" echo ELSE SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^)
    "%SQL_QUERY_FILE%" echo END
    "%SQL_QUERY_FILE%" echo ELSE ''
    "%SQL_QUERY_FILE%" echo END AS package_name,
    "%SQL_QUERY_FILE%" echo f.intent
    "%SQL_QUERY_FILE%" echo FROM favorites f
    "%SQL_QUERY_FILE%" echo WHERE !SQL_WHERE!
    "%SQL_QUERY_FILE%" echo ORDER BY !SQL_ORDER!;

    "%SQLITE_EXE%" "%DB_PATH%" < "%SQL_QUERY_FILE%" > "%RAW_OUT%"

    if "%DEBUG%"=="1" (
    echo [DEBUG] sqlite3 query exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %RAW_OUT% line count:
    find /c /v "" "%RAW_OUT%" 2>nul
    )

    del "%SQL_QUERY_FILE%" >nul 2>&1

    if errorlevel 1 (
    echo [ERROR] SQLite query failed.
    pause
    exit /b 1
    )

    :: Write column formatter ps1 to %TEMP%
    :: Add pane/folder heading, indent spaces and append to log
    set "PS_FORMAT=%TEMP%\adbfolder_format.ps1"

    if exist "%PS_FORMAT%" del /f /q "%PS_FORMAT%" >nul 2>&1

    "%PS_FORMAT%" echo $rawFile = $env:RAW_OUT
    "%PS_FORMAT%" echo $cleanFile = $env:CLEAN_OUT
    "%PS_FORMAT%" echo $logFile = $env:LOG_OUT
    "%PS_FORMAT%" echo $label = $env:SELECTED_LABEL
    "%PS_FORMAT%" echo $rows = Import-Csv -LiteralPath $rawFile -Delimiter "`t"
    "%PS_FORMAT%" echo $lines = $rows ^| Select-Object package_name, display_name ^| Format-Table -AutoSize ^| Out-String -Width 4096
    "%PS_FORMAT%" echo $tableLines = @($lines -split "`r?`n" ^| ForEach-Object { $_.TrimEnd() } ^| Where-Object { $_ -ne '' })
    "%PS_FORMAT%" echo $header = " $label"
    "%PS_FORMAT%" echo if ($label -match '^pane\s+(\d+)\s+-\s+(.+)$') { $header = (' pane {0} folder "{1}"' -f $Matches[1], $Matches[2]) }
    "%PS_FORMAT%" echo $body = ($tableLines ^| ForEach-Object { ' ' + $_ }) -join "`r`n"
    "%PS_FORMAT%" echo $clean = $header + "`r`n" + $body + "`r`n"
    "%PS_FORMAT%" echo $utf8 = New-Object System.Text.UTF8Encoding($false)
    "%PS_FORMAT%" echo [System.IO.File]::WriteAllText($cleanFile, $clean, $utf8)
    "%PS_FORMAT%" echo $timestamp = Get-Date -Format 'yyyy-MM-dd HH:mm:ss'
    "%PS_FORMAT%" echo $entry = "`r`n============================================================`r`nExport: $timestamp`r`n$clean"
    "%PS_FORMAT%" echo [System.IO.File]::AppendAllText($logFile, $entry, $utf8)

    if "%DEBUG%"=="1" echo [DEBUG] Running formatter PowerShell script "%PS_FORMAT%"...
    powershell -NoProfile -ExecutionPolicy Bypass -File "%PS_FORMAT%"
    if "%DEBUG%"=="1" echo [DEBUG] PowerShell formatter exit errorlevel=!errorlevel!

    del "%PS_FORMAT%" >nul 2>&1

    if errorlevel 1 (
    echo [ERROR] Failed to format output columns or append running log.
    pause
    exit /b 1
    )

    echo.
    echo --- Result (%CLEAN_OUT%) ---
    echo.
    type "%CLEAN_OUT%"
    echo.
    echo Raw tab-delimited output saved to: "%RAW_OUT%"
    echo Formatted app list saved to: "%CLEAN_OUT%"
    echo Running export log saved to: "%LOG_OUT%"
    echo.

    :: Loop back to menu so user can export another folder or pane
    set "LOOP_MORE="
    set /p "LOOP_MORE=Export another folder or pane? [y/N]: "
    if /i "!LOOP_MORE!"=="y" goto :verify_db

    :: -------------------------------------------------------------------------
    :: End-of-run check for third-party packages -3 missing from nova.db
    :: -------------------------------------------------------------------------
    :check_missing_3p
    echo.
    set "CHECK_3P="
    set /p "CHECK_3P=Check user apps -3 with no icon in Nova before quitting? [y/N]: "
    if /i not "!CHECK_3P!"=="y" goto :quit_script

    if "%DEBUG%"=="1" (
    echo [DEBUG] Entering :check_missing_3p
    echo [DEBUG] ADB_EXE="%ADB_EXE%"
    echo [DEBUG] SQLITE_EXE="%SQLITE_EXE%"
    echo [DEBUG] DB_PATH="%DB_PATH%"
    echo [DEBUG] ADB_TARGET="%ADB_TARGET%"
    )

    if not exist "%ADB_EXE%" (
    echo [INFO] adb.exe not found at "%ADB_EXE%"; skipping device package check.
    goto :quit_script
    )

    set "RUN_ADB_TARGET=%ADB_TARGET%"
    if "!RUN_ADB_TARGET!"=="" (
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!RUN_ADB_TARGET!"=="" set "RUN_ADB_TARGET=%%g"
    )
    )
    )

    if "%DEBUG%"=="1" echo [DEBUG] RUN_ADB_TARGET="!RUN_ADB_TARGET!"

    if "!RUN_ADB_TARGET!"=="" (
    echo [INFO] No connected ADB device found; skipping device package check.
    goto :quit_script
    )

    if not exist "%DB_PATH%" (
    echo [INFO] Nova database not available at "%DB_PATH%"; skipping device package check.
    goto :quit_script
    )

    set "RESOLVE_LABELS="
    set /p "RESOLVE_LABELS=Resolve app titles via adb/aapt slower over Wi-Fi? [y/N]: "
    set "DO_RESOLVE_LABELS=0"
    if /i "!RESOLVE_LABELS!"=="y" set "DO_RESOLVE_LABELS=1"
    if "%DEBUG%"=="1" echo [DEBUG] DO_RESOLVE_LABELS="!DO_RESOLVE_LABELS!"

    set "PM_3P_FILE=%TEMP%\adbfolder_pm3.txt"
    set "NOVA_PKGS_FILE=%TEMP%\adbfolder_nova_pkgs.txt"
    set "UNPLACED_OUT=%WORK_DIR%\unplaced_user_apps.txt"
    set "PS_DIFF_3P=%TEMP%\adbfolder_diff_3p.ps1"
    :: v3p2: Write SQL to a temp .sql file so cmd does not parse SQL operators/quotes
    set "SQL_NOVA_PKGS=%TEMP%\adbfolder_nova_pkgs.sql"

    if "%DEBUG%"=="1" (
    echo [DEBUG] PM_3P_FILE="!PM_3P_FILE!"
    echo [DEBUG] NOVA_PKGS_FILE="!NOVA_PKGS_FILE!"
    echo [DEBUG] UNPLACED_OUT="!UNPLACED_OUT!"
    echo [DEBUG] PS_DIFF_3P="!PS_DIFF_3P!"
    echo [DEBUG] SQL_NOVA_PKGS="!SQL_NOVA_PKGS!"
    )

    echo Querying third-party packages from device !RUN_ADB_TARGET! ...
    if "%DEBUG%"=="1" echo [DEBUG] Running adb pm list packages -3...
    "%ADB_EXE%" -s !RUN_ADB_TARGET! shell pm list packages -3 2>nul > "!PM_3P_FILE!"
    if "%DEBUG%"=="1" (
    echo [DEBUG] adb pm exit errorlevel=!errorlevel!
    echo [DEBUG] PM_3P_FILE line count:
    find /c /v "" "!PM_3P_FILE!" 2>nul
    )

    echo Querying packages referenced anywhere in nova.db ...
    if "%DEBUG%"=="1" echo [DEBUG] Writing and running sqlite3 Nova package query from .sql file...
    :: v3p3: Use LENGTH/TRIM checks instead of != so delayed expansion cannot drop negation
    "!SQL_NOVA_PKGS!" echo SELECT DISTINCT package_name
    "!SQL_NOVA_PKGS!" echo FROM (
    "!SQL_NOVA_PKGS!" echo SELECT CASE
    "!SQL_NOVA_PKGS!" echo WHEN iconPackage IS NOT NULL AND LENGTH(TRIM(iconPackage^)^) ^> 0 THEN TRIM(iconPackage^)
    "!SQL_NOVA_PKGS!" echo WHEN INSTR(intent, 'component='^) ^> 0 THEN
    "!SQL_NOVA_PKGS!" echo CASE
    "!SQL_NOVA_PKGS!" echo WHEN INSTR(SUBSTR(intent, INSTR(intent, 'component='^) + 10^), '/'^) ^> 0 THEN SUBSTR(
    "!SQL_NOVA_PKGS!" echo SUBSTR(intent, INSTR(intent, 'component='^) + 10^),
    "!SQL_NOVA_PKGS!" echo 1,
    "!SQL_NOVA_PKGS!" echo INSTR(SUBSTR(intent, INSTR(intent, 'component='^) + 10^), '/'^) - 1
    "!SQL_NOVA_PKGS!" echo ^)
    "!SQL_NOVA_PKGS!" echo ELSE SUBSTR(intent, INSTR(intent, 'component='^) + 10^)
    "!SQL_NOVA_PKGS!" echo END
    "!SQL_NOVA_PKGS!" echo ELSE ''
    "!SQL_NOVA_PKGS!" echo END AS package_name
    "!SQL_NOVA_PKGS!" echo FROM favorites
    "!SQL_NOVA_PKGS!" echo )
    "!SQL_NOVA_PKGS!" echo WHERE LENGTH(package_name^) ^> 0;

    "%SQLITE_EXE%" "%DB_PATH%" < "!SQL_NOVA_PKGS!" > "!NOVA_PKGS_FILE!"
    if "%DEBUG%"=="1" (
    echo [DEBUG] sqlite3 Nova pkgs exit errorlevel=!errorlevel!
    echo [DEBUG] NOVA_PKGS_FILE line count:
    find /c /v "" "!NOVA_PKGS_FILE!" 2>nul
    echo [DEBUG] Writing PS_DIFF_3P script...
    )

    :: v3p2: Write PS_DIFF_3P line-by-line instead of an outer parenthesized block
    :: v3p4: Resolve app labels for unplaced packages via adb dumpsys and aapt/aapt2 if available
    :: v3p5: Remove stray caret escaping before closing paren on standalone echo lines
    :: v3p6: Prompt whether to resolve app titles and print periodic progress during lookup
    if exist "!PS_DIFF_3P!" del /f /q "!PS_DIFF_3P!" >nul 2>&1
    "!PS_DIFF_3P!" echo $adbExe = $env:ADB_EXE
    "!PS_DIFF_3P!" echo $adbTarget = $env:RUN_ADB_TARGET
    "!PS_DIFF_3P!" echo $resolveLabels = ($env:DO_RESOLVE_LABELS -eq '1')
    "!PS_DIFF_3P!" echo $pm3Lines = Get-Content -LiteralPath $env:PM_3P_FILE -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo $installed3 = [System.Collections.Generic.HashSet[string]]::new([System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo foreach ($line in $pm3Lines) {
    "!PS_DIFF_3P!" echo $p = ($line -replace '\r', '').Trim()
    "!PS_DIFF_3P!" echo if ($p.StartsWith('package:')) { $p = $p.Substring(8).Trim() }
    "!PS_DIFF_3P!" echo if (-not [string]::IsNullOrWhiteSpace($p)) { [void]$installed3.Add($p) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $novaLines = Get-Content -LiteralPath $env:NOVA_PKGS_FILE -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo $inNova = [System.Collections.Generic.HashSet[string]]::new([System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo foreach ($n in $novaLines) {
    "!PS_DIFF_3P!" echo $pkg = ($n -replace '\r', '').Trim()
    "!PS_DIFF_3P!" echo if (-not [string]::IsNullOrWhiteSpace($pkg)) { [void]$inNova.Add($pkg) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $missingList = [System.Collections.Generic.List[string]]::new()
    "!PS_DIFF_3P!" echo foreach ($pkg in $installed3) {
    "!PS_DIFF_3P!" echo if (-not $inNova.Contains($pkg)) { [void]$missingList.Add($pkg) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $missing = @($missingList.ToArray())
    "!PS_DIFF_3P!" echo [System.Array]::Sort($missing, [System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo $aaptCmd = if ($resolveLabels) { Get-Command aapt -ErrorAction SilentlyContinue } else { $null }
    "!PS_DIFF_3P!" echo $idx = 0
    "!PS_DIFF_3P!" echo $results = foreach ($pkg in $missing) {
    "!PS_DIFF_3P!" echo $idx++
    "!PS_DIFF_3P!" echo $label = ''
    "!PS_DIFF_3P!" echo if ($resolveLabels) {
    "!PS_DIFF_3P!" echo if (($idx %% 10) -eq 1 -or $idx -eq $missing.Count) {
    "!PS_DIFF_3P!" echo Write-Host ("Resolving titles: {0}/{1} ({2})..." -f $idx, $missing.Count, $pkg)
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $dumpLines = ^& $adbExe -s $adbTarget shell dumpsys package $pkg 2^>$null
    "!PS_DIFF_3P!" echo foreach ($dl in $dumpLines) {
    "!PS_DIFF_3P!" echo if ($dl -match 'nonLocalizedLabel="([^"]+)"') { $label = $Matches[1].Trim() }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo if ([string]::IsNullOrWhiteSpace($label) -and $aaptCmd) {
    "!PS_DIFF_3P!" echo $apkPathLine = (^& $adbExe -s $adbTarget shell pm path $pkg 2^>$null ^| Select-Object -First 1)
    "!PS_DIFF_3P!" echo if ($apkPathLine -and $apkPathLine.Trim().StartsWith('package:')) {
    "!PS_DIFF_3P!" echo $apkRemote = $apkPathLine.Trim().Substring(8).Trim()
    "!PS_DIFF_3P!" echo $apkLocal = Join-Path $env:TEMP "adbfolder_probe.apk"
    "!PS_DIFF_3P!" echo ^& $adbExe -s $adbTarget pull $apkRemote $apkLocal ^>$null 2^>^&1
    "!PS_DIFF_3P!" echo if (Test-Path -LiteralPath $apkLocal) {
    "!PS_DIFF_3P!" echo $badging = ^& $aaptCmd.Source dump badging $apkLocal 2^>$null
    "!PS_DIFF_3P!" echo foreach ($bl in $badging) {
    "!PS_DIFF_3P!" echo if ($bl -match "^application-label:'([^']+)'") { $label = $Matches[1].Trim(); break }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo Remove-Item -LiteralPath $apkLocal -Force -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo [PSCustomObject]@{ package_name = $pkg; app_title = $label }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $tableText = if (@($results).Count -gt 0) {
    "!PS_DIFF_3P!" echo ((@($results) ^| Format-Table -AutoSize ^| Out-String -Width 4096) -split "`r?`n" ^| ForEach-Object { $_.TrimEnd() } ^| Where-Object { $_ -ne '' }) -join "`r`n" + "`r`n"
    "!PS_DIFF_3P!" echo } else { "" }
    "!PS_DIFF_3P!" echo [System.IO.File]::WriteAllText($env:UNPLACED_OUT, $tableText, (New-Object System.Text.UTF8Encoding($false)))
    "!PS_DIFF_3P!" echo Write-Host ("User packages (-3): {0} | In Nova layout: {1} | No icon in Nova: {2}" -f $installed3.Count, $inNova.Count, $missing.Count)
    "!PS_DIFF_3P!" echo if (@($results).Count -gt 0) { Write-Host ""; Write-Output $tableText.TrimEnd() }

    if "%DEBUG%"=="1" (
    echo [DEBUG] PS_DIFF_3P write exit errorlevel=!errorlevel!
    echo [DEBUG] Generated PS_DIFF_3P contents:
    type "!PS_DIFF_3P!" 2>nul
    echo [DEBUG] Executing PS_DIFF_3P...
    )

    powershell -NoProfile -ExecutionPolicy Bypass -File "!PS_DIFF_3P!"
    if "%DEBUG%"=="1" echo [DEBUG] PS_DIFF_3P execution exit errorlevel=!errorlevel!

    echo Saved unplaced user app list to: "!UNPLACED_OUT!"
    echo.

    if not "%DEBUG%"=="1" (
    del "!PM_3P_FILE!" >nul 2>&1
    del "!NOVA_PKGS_FILE!" >nul 2>&1
    del "!PS_DIFF_3P!" >nul 2>&1
    del "!SQL_NOVA_PKGS!" >nul 2>&1
    ) else (
    echo [DEBUG] Keeping temp files because DEBUG=1:
    echo [DEBUG] "!PM_3P_FILE!"
    echo [DEBUG] "!NOVA_PKGS_FILE!"
    echo [DEBUG] "!PS_DIFF_3P!"
    echo [DEBUG] "!SQL_NOVA_PKGS!"
    )

    :quit_script
    pause
    exit /b 0

    :: -------------------------------------------------------------------------
    :: Subroutine: scan_pane <pane_number>
    :: -------------------------------------------------------------------------
    :scan_pane
    set "SCR=%~1"

    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 AND container = -100 AND CAST(screen AS INTEGER) = %SCR% ORDER BY cellY, cellX, rank, _id;" > "%TEMP%\nova_pane_folders.txt" 2>nul

    set "LOOSE_CNT=0"
    "%SQLITE_EXE%" "%DB_PATH%" "SELECT COUNT(*) FROM favorites WHERE container = -100 AND CAST(screen AS INTEGER) = %SCR% AND itemType <> 2;" > "%TEMP%\nova_pane_loose_cnt.txt" 2>nul

    for /f "usebackq delims=" %%C in ("%TEMP%\nova_pane_loose_cnt.txt") do (
    if not "%%C"=="" set "LOOSE_CNT=%%C"
    )
    del "%TEMP%\nova_pane_loose_cnt.txt" >nul 2>&1

    set "HAS_PANE_FOLDERS=0"
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_pane_folders.txt") do (
    set "FID=%%A"
    if not "!FID!"=="" set "HAS_PANE_FOLDERS=1"
    )

    set "PRINT_HEADER=0"
    if !HAS_PANE_FOLDERS! GTR 0 set "PRINT_HEADER=1"
    if !LOOSE_CNT! GTR 0 set "PRINT_HEADER=1"

    if "!PRINT_HEADER!"=="1" echo pane %SCR%

    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_pane_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=pane %SCR% - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    set "LISTED_FOLDER_IDS=!LISTED_FOLDER_IDS!!FID!,"
    echo [!TGT_COUNT!] !FNAME!
    )
    )

    if !LOOSE_CNT! GTR 0 (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=pane %SCR% loose apps"
    set "TGT_WHERE_!TGT_COUNT!=f.container = -100 AND CAST(f.screen AS INTEGER) = %SCR% AND f.itemType <> 2"
    set "TGT_ORDER_!TGT_COUNT!=f.cellY, f.cellX, f.rank, f._id"
    echo [!TGT_COUNT!] pane %SCR% loose apps
    )

    del "%TEMP%\nova_pane_folders.txt" >nul 2>&1
    goto :eof
    :: -------------------------------------------------------------------------
    :: end of adbfolder.bat
    :: -------------------------------------------------------------------------
    :: Step by step description of what this script does
    :: 1. Environment & Configuration Setup
    :: A. Command environment
    :: a. Disables command echoing and enables delayed expansion
    :: b. Sets the working directory to the script's path
    :: B. Configuration variables
    :: a. Sets default configuration paths for ADB, SQLite
    :: and work directories
    :: b. Defines the DEBUG toggle flag
    :: 2. Dependency Verification
    :: A. Executable checks
    :: a. Locates adb.exe and checks system PATH or configured fallback path
    :: b. Locates sqlite3.exe and exits with an error if missing
    :: B. Directory setup
    :: a. Creates the local working directory if it does not exist
    :: 3. Source Selection Menu
    :: A. Choice [1]: Pull from Android via ADB
    :: a. Detects connected ADB device target
    :: b. Lists .novabackup files in the remote backup directory
    :: with fallback search
    :: c. Prompts user to select or enter a backup filename/path
    :: d. Pulls the selected .novabackup file to the Windows workspace
    :: e. Renames the pulled file to backup.zip and extracts it
    :: into backup_extracted to retrieve nova.db
    :: B. Choice [2]: Use Local Database / Archive
    :: a. Prompts user for a custom path to nova.db .novabackup or .zip
    :: with a retry loop
    :: b. Validates file existence
    :: c. Automatically extracts archives if .novabackup or .zip file
    :: 4. Database Verification & Target Enumeration
    :: A. Database validation
    :: a. Verifies that nova.db exists at the target path
    :: B. Section 1 [Dock]
    :: a. Scans dock apps [container = -101]
    :: b. Scans and lists any dock folders
    :: C. Section 2 [Panes 0-14]
    :: a. Iterates through home screen panes 0 to 14
    :: via the scan_pane subroutine
    :: b. Queries pane folders [itemType = 2, container = -100]
    :: c. Checks for loose non-folder apps [itemType <> 2] on the pane
    :: D. Section 3 [Other Folders]
    :: a. Searches for orphaned folders not categorized under dock or panes
    :: b. Lists and registers valid other folders
    :: 5. User Selection & Query Execution [run_query]
    :: A. Selection & Sanity
    :: a. Prompts user to select a target number or quit [q or 0]
    :: b. Sanitizes the selected label using a temporary PowerShell
    :: script to generate a safe filename
    :: B. Query Generation & Execution
    :: a. Writes a dynamic SQLite query script to a temp file
    :: [.sql] extracting item ID, app title, package name and raw intent
    :: b. Executes the query against nova.db using sqlite3.exe
    :: C. Output & Formatting
    :: a. Formats output columns [package_name first, display_name second]
    :: into an auto-sized table via PowerShell
    :: b. Adds a descriptive pane/folder heading and indents the table
    :: by two spaces for easier reading and future concatenation
    :: c. Saves raw results [output.txt] and formatted results
    :: [target_apps.txt] to the work directory
    :: d. Appends each formatted export with a timestamp to
    :: [adbfolder_log.txt] without overwriting previous exports
    :: e. Prompts user to loop back to scan another folder/pane or proceed
    :: 6. Optional Unplaced Third-Party Package Check [check_missing_3p]
    :: A. Pre-check Validation
    :: a. Prompts user whether to check for user-installed packages
    :: [-3] missing from the Nova layout
    :: b. Verifies ADB device connectivity and database availability
    :: c. Optionally prompts user to resolve app labels via adb dumpsys
    :: and aapt/aapt2
    :: B. Data Collection
    :: a. Queries installed third-party packages from device
    :: [adb shell pm list packages -3]
    :: b. Queries all referenced packages inside nova.db
    :: C. Diff Analysis & Cleanup
    :: a. Generates and executes a PowerShell diff script to find
    :: installed packages with no home screen icon
    :: b. Outputs a formatted table of unplaced apps to
    :: unplaced_user_apps.txt
    :: c. Cleans up temporary script and text files
    :: [unless DEBUG=1] and exits cleanly
    :: -------------------------------------------------------------------------
    :: Not only is there a question of how to port this for more general use,
    :: but there's also a question of which common launchers will it work with.
    ::
    :: It may be that the native Android launcher may provide a 'parsable
    :: homescreen, so I looked up which might work in addition to Nova Launcher.
    ::
    :: So far, I "think" [tentatively] these will export/import a homescreen.
    :: a. Nova [SQL, .novabackup/nova.db restore]
    :: b. Lawnchair [.lawnchairbackup/restore]
    :: c. Mink [JSON backup/restore]
    :: d. Total Launcher [zip? backup/restore]
    :: e. Niagra [nlb backup/restore]
    :: d. Others? [SQLite, JSON, XML, etc.]
    :: ------------------------------------------------------------------------- --
    We don't just share knowledge here, we make each other's knowledge better.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 22:01:52 2026
    From Newsgroup: misc.phone.mobile.iphone

    For the record, here is the python script I wrote today based on the
    Windows batch script I had written yesterday that is an example of
    what we'd like to accomplish with iOS over Wi-Fi/USB to any common desktop.

    This should work on Windows/macOS/Linux (but I can only test on Windows).

    On my 64GB Android, it found about a thousand packages which it listed in
    two panes, one dock, and a few dozen folders, by package name and by label.

    In addition, it found 65 headless packages, some of which I simply
    installed but forgot to place the launch icon while others are typically headless as they're for keyboards and other packages that aren't launched.

    I posted the Windows script separately in this thread, where I wrote it yesterday because I was too lazy to manually write down the homescreen
    pane number, folder name, package name and icon label, so I wrote this.

    :: -------------------------------------------------------------------------
    :: adbfolder.bat
    :: -------------------------------------------------------------------------
    :: v1p6 20261121 Ported adbfolder.bat from Windows for desktop portability.
    :: Versions v1p0 to v1p5 were testing steps to get it to work.
    :: -------------------------------------------------------------------------
    :: Outputs a perfect textual inventory, with debug capability, of an Android
    :: homescreen, including location of all panes, folders, packages and titles.
    ::
    :: Intended to assist in debugging, inventory, archival, backup and restore.
    :: Runs on Windows over Wi-Fi/USB, but can be ported to other platforms.
    ::
    :: Will pull a backup from android via adb or read an existing nova db or
    :: nova backup archive on windows needing only adb and sql dependencies
    ::
    :: List order is top to bottom, left to right, meaning the leftmost pane
    :: is 1st, then subsequent panes, from 0 to 1 to 2 and so on to the right.
    ::
    :: Similarly, the topleft folder is 1st, then the next folder to the right.
    ::
    :: Likewise, packages and titles inside of folders are listed in top to
    :: bottom order, left to right, providing an exact textual description.
    ::
    :: Bare icons, not inside folders, are listed separately as a line item.
    :: The dock and folders in the dock are treated much like the panes are.
    ::
    :: This script not only provides a textual inventory of the name and
    :: homescreen location of every folder name, package name and display
    :: name ever added to the homescreen, but it optionally will 'diff'
    :: against packages which were manually installed by the user but
    :: which have no current homescreen icon (i.e., "headless" apps).
    ::
    :: Note the display_name is the current icon title for a given app icon,
    :: which can be changed by the user, so it's not always the original.
    :: However, for apps installed by the user but without homescreen icons,
    :: the optional lookup pulls the app's original defined Android app_label.
    ::
    :: Output is appended to a timestamped running log file for traceability.
    :: Unless the user wipes out the running log, this becomes an automatic
    :: audit of all the physical changes a user has made to the homescreen.
    :: -------------------------------------------------------------------------
    :: Q: Why is saying YES to "Resolve app titles via adb/aapt" very slow?
    :: A: For each of the unplaced packages, the script does:
    :: a. adb shell dumpsys package <pkg> to look for nonLocalizedLabel=
    :: b. If that fails: adb shell pm path <pkg> to find the APK location
    :: c. adb pull <apk> to download the APK to the PC
    :: d. aapt dump badging <apk> to read the app label from the APK
    :: Which is up to 4 ADB commands times N orphan apps = 4N round-trips.
    :: Over USB, each round-trip is fast (milliseconds).
    :: But, over Wi-Fi, each one has wireless handshake latency,
    :: so the total time adds up just waiting on ADB to return results.
    :: -------------------------------------------------------------------------
    :: v6p1 20261121 WIP
    :: v6p0 20261121 Fixed ADB shell ls wildcard expansion by moving the closing
    :: quote after %ANDROID_BCK_DIR% so *.novabackup is not treated
    :: as a literal filename (which had forced a global search)
    :: v5p9 20261121 Reformatted folder and pane output with a descriptive
    :: heading and two-space indentation, and added a timestamped
    :: running log file that accumulates formatted exports
    :: v5p8 20261121 Renamed app_title output column to display_name to
    :: distinguish the current homescreen icon title from the
    :: original Android application label and reformatted output
    :: v5p7 20261121 Moved the restore option to the local-file-path section
    :: v5p6 20261121 Improved comments and explanations and user prompts
    :: v5p5 20261120 Added option to open Nova Launcher settings on the device
    :: to create a fresh homescreen backup before listing/pulling
    :: v5p4 20261120 Appended a step-by-step flow description at the bottom
    :: v5p3 20261120 Moved per-pane scanning into a :scan_pane subroutine and
    :: cleaned up SQL/batch parsing in the pane loop so menu
    :: scanning runs without cmd.exe syntax errors
    :: v5p2 20261120 Fixed too many individual syntax problems to count between
    :: the last dozen versions, which were Windows CLI issues
    :: v4p5 20261119 Fixed loose apps package_name extraction in :run_query
    :: when component= has no slash or uses package=
    :: v4p4 20261119 Improved comments regarding filtering of the output data
    :: v4p3 20261119 Kept loose apps with all item types except itemType != 2 and
    :: removed parentheses from comment lines across the script
    :: v4p2 20261119 Removed extra iconPackage/component= check on loose apps
    :: so all non-folder items itemType != 2 on a pane are
    :: included without dropping rows
    :: v4p1 20261119 Restricted loose apps count and query to items that have a
    :: non-empty iconPackage or component= in intent while keeping
    :: all existing behavior, comments, and formatting intact
    :: v4p0 20261119 Gave up on trying to eliminate empty lines from PowerShell
    :: in the optional orphan-packages-with-no-launch icon listing
    :: so v4p0 is an exact duplicate of v3p6 which has blank lines
    :: v3p9 20261119 Moved menu scanning, SQLite querying, table formatting,
    :: and unplaced -3 package diffing into a dedicated PowerShell
    :: engine script so cmd.exe never hits block/caret/quote errors
    :: and fixed looseapps condition to itemType <> 2 and set DEBUG=0
    :: v3p8 20261119 Formatted unplaced user app table directly in PS_DIFF_3P
    :: instead of Format-Table to remove blank lines between rows
    :: v3p7 20261119 Fixed missing package_name in :run_query by replacing !=
    :: with LENGTH/TRIM checks and guarding SUBSTR against missing
    :: slashes and fixed pane loose apps SQL_WHERE to f.itemType <> 2
    :: v3p6 20261119 Added optional prompt before resolving Nova f.title names
    :: in check_missing_3p and printed periodic progress while
    :: resolving labels so quick checks finish immediately
    :: v3p5 20261119 Removed stray caret escaping before closing parentheses on
    :: standalone PS_DIFF_3P echo lines so PowerShell parses the
    :: generated script cleanly, and kept DEBUG=1 enabled
    :: v3p4 20261119 Added app label lookup via adb dumpsys and optional aapt/aapt2
    :: for unplaced user apps in check_missing_3p and set DEBUG=0
    :: as the default flag
    :: v3p3 20261119 Replaced != with LENGTH/TRIM checks in Nova package SQL
    :: query so cmd delayed expansion does not strip negation
    :: and handled component= values without a slash safely
    :: v3p2 20261119 Wrote Nova package SQL query to a temp .sql file to avoid
    :: cmd parsing syntax errors and wrote PS_DIFF_3P line-by-line
    :: instead of using an outer parenthesized block
    :: v3p1 20261119 Insrumented the orphan section as it was throwing errors
    :: v3p0 20261119 Fixed command syntax error when generating the PowerShell
    :: diff script in check_missing_3p and wrapped the Nova
    :: package query in a subquery so package_name matches cleanly
    :: v2p9 20261119 Added a final sanity check before quitting to compare
    :: the list of packages that have icons on the homescreen
    :: against all the user-installed packages on the phone
    :: to create an orphan-packages file that have no icons
    :: v2p8 20261119 Added quit option at folder selection prompt and loop back
    :: prompt at end to export another folder or pane
    :: v2p7 20261119 Replaced fragile DISTINCT screen loop with explicit pane
    :: index pass 0 to 9 using CAST screen AS INTEGER so panes
    :: with folders or loose apps always appear in order
    :: v2p6 20261119 Fixed pane screen query so folders on pane 0, pane 1 and
    :: pane 2 display properly along with loose pane apps and other
    :: v2p5 20261119 Grouped folders by screen number across panes and kept
    :: unmatched folders under other at the bottom
    :: v2p4 20261119 Added loose apps choice at the end of each pane with
    :: non-folder items and kept other catch-all at the bottom
    :: v2p3 20261119 Listed folders under dock and each pane with no default
    :: and skipped empty sections
    :: v2p2 20261119 Added full-layout option outputting dock and pane headers
    :: with package_name and app_title lines
    :: v2p1 20261119 Replaced backtick for /f calls on DOCK_TOTAL and PANE_TOTAL
    :: with temp file redirects so cmd reliably captures counts
    :: v2p0 20261119 Removed ampersand and parenthesis inside comment labels
    :: as labels are not comments even though they act like them
    :: v1p9 20261119 Removed item_type column from output and grouped folders
    :: by their homescreen pane eg, "Pane 0 Folder: weather"
    :: v1p8 20261119 Dynamically lists dock, eg, container = -101, and lists
    :: homescreen panes by screen number, eg, container = -100,
    :: and by named folders eg, itemType = 2, from nova db
    :: and includes item_type in output
    :: v1p7 20261119 Searches android storage for novabackup files when none
    :: are found in ANDROID_BCK_DIR, storing full remote paths so
    :: backups in any folder can be pulled cleanly
    :: v1p6 20261119 Set DEBUG=0 by default for clean normal output while keeping
    :: the toggle available for troubleshooting
    :: v1p5 20261119 Reversed output columns to package_name first, app_title
    :: second and added startup dependency check for adb and
    :: sqlite3 dependency checking configured paths and PATH
    :: v1p4 20261119 Moved powershell commands into %TEMP%\* ps1 scripts run via
    :: "-File" instead of backticks so cmd never parses "<" or ">"
    :: v1p3 20261119 Added DEBUG=1 instrumentation
    :: v1p2 20261119 Replaced cmd FOR sanitizer with powershell
    :: v1p1 20261119 Numbered selection menu for novabackup files, lists folders
    :: by name with numbered selection instead of raw container IDs
    :: v1p0 20261119 Initial version to pull backup or use local nova db, query
    :: sql via sqlite3 exe, select columns with powershell
    :: -------------------------------------------------------------------------
    @echo off
    setlocal enabledelayedexpansion
    cd /d "%~dp0"

    :: --- Debug flag 1 = verbose DEBUG traces, 0 = quiet ---
    set "DEBUG=0"
    :: set "DEBUG=1"

    :: --- Configurable paths ---
    set "ADB_EXE=C:\app\editor\android\scrcpy\adb.exe"
    set "SQLITE_EXE=C:\app\editor\android\sdk\platform-tools\sqlite3.exe"
    set "WORK_DIR=C:\app\editor\android\scrcpy\nova"
    set "ANDROID_BCK_DIR=/storage/emulated/0/0000/bck/nova_backup"
    set "DEFAULT_CONTAINER=2921"

    if "%DEBUG%"=="1" (
    echo [DEBUG] SCRIPT_DIR="%~dp0"
    echo [DEBUG] CD="%CD%"
    echo [DEBUG] ADB_EXE="%ADB_EXE%"
    echo [DEBUG] SQLITE_EXE="%SQLITE_EXE%"
    echo [DEBUG] WORK_DIR="%WORK_DIR%"
    )

    :: -------------------------------------------------------------------------
    :: Startup dependency and PATH check for adb exe and sqlite3 exe
    :: -------------------------------------------------------------------------
    echo Checking required tools (adb and sqlite3) ...

    set "PATH_ADB="
    for /f "usebackq delims=" %%W in (`where adb 2^>nul`) do (
    if "!PATH_ADB!"=="" set "PATH_ADB=%%W"
    )

    set "PATH_SQLITE="
    for /f "usebackq delims=" %%W in (`where sqlite3 2^>nul`) do (
    if "!PATH_SQLITE!"=="" set "PATH_SQLITE=%%W"
    )

    if "%DEBUG%"=="1" (
    echo [DEBUG] PATH_ADB="!PATH_ADB!"
    echo [DEBUG] PATH_SQLITE="!PATH_SQLITE!"
    )

    :: Prefer configured path if it exists, otherwise fall back to PATH
    if not exist "%ADB_EXE%" (
    if not "!PATH_ADB!"=="" (
    echo [INFO] Configured ADB_EXE not found; using PATH: "!PATH_ADB!"
    set "ADB_EXE=!PATH_ADB!"
    ) else (
    echo [WARN] adb.exe not found at "%ADB_EXE%" and not in PATH.
    )
    ) else if "!PATH_ADB!"=="" (
    echo [INFO] adb.exe found at configured path, though not in PATH.
    )

    if not exist "%SQLITE_EXE%" (
    if not "!PATH_SQLITE!"=="" (
    echo [INFO] Configured SQLITE_EXE not found; using PATH: "!PATH_SQLITE!"
    set "SQLITE_EXE=!PATH_SQLITE!"
    ) else (
    echo [ERROR] sqlite3.exe not found at "%SQLITE_EXE%" and not in PATH.
    pause
    exit /b 1
    )
    ) else if "!PATH_SQLITE!"=="" (
    echo [INFO] sqlite3.exe found at configured path, though not in PATH.
    )

    if not exist "%WORK_DIR%" mkdir "%WORK_DIR%"

    echo Working directory: "%CD%"
    echo Nova work directory: "%WORK_DIR%"
    echo ----------------
    echo.
    echo Select source for Nova Launcher database:
    echo [1] Pull .novabackup from Android via ADB and extract nova.db [Default]
    echo [2] Use an existing nova.db or .novabackup or .zip already on Windows
    echo.
    set "SRC_CHOICE=1"
    set /p "SRC_CHOICE=Enter choice [1 or 2]: "
    if "%DEBUG%"=="1" echo [DEBUG] SRC_CHOICE="!SRC_CHOICE!"

    if "%SRC_CHOICE%"=="2" goto :use_local_source
    if "%SRC_CHOICE%"=="1" goto :pull_from_android
    goto :pull_from_android

    :: -------------------------------------------------------------------------
    :: Option 1: Pull backup from android via adb
    :: -------------------------------------------------------------------------
    :pull_from_android
    echo.
    echo --- Pull Nova Backup from Android ---

    if not exist "%ADB_EXE%" (
    echo [ERROR] adb.exe not found at: "%ADB_EXE%"
    pause
    exit /b 1
    )

    set "ADB_TARGET="
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!ADB_TARGET!"=="" set "ADB_TARGET=%%g"
    )
    )

    if "%DEBUG%"=="1" echo [DEBUG] ADB_TARGET="!ADB_TARGET!"

    if "!ADB_TARGET!"=="" (
    echo [ERROR] No connected ADB devices found.
    pause
    exit /b 1
    )

    :: beginning of changes in v5p5
    echo Targeting device: %ADB_TARGET%

    set "MAKE_BCK="
    set /p "MAKE_BCK=Open Nova Launcher settings on device to create a new backup first? [y/N]: "
    if /i "!MAKE_BCK!"=="y" (
    echo Launching Nova Launcher settings on %ADB_TARGET% ...
    echo "Tap Backup & restore > Backup > Save to save to your device"
    "%ADB_EXE%" -s %ADB_TARGET% shell am start -n com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity
    echo Create your backup in Nova Launcher on the device, then press ENTER to list backups.
    pause
    )

    echo Listing backups in %ANDROID_BCK_DIR% ...
    echo.

    "%ADB_EXE%" -s %ADB_TARGET% shell ls -1t "%ANDROID_BCK_DIR%"/*.novabackup 2>nul > "%TEMP%\nova_backups.txt"

    if "%DEBUG%"=="1" (
    echo [DEBUG] ls exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %TEMP%\nova_backups.txt contents:
    type "%TEMP%\nova_backups.txt" 2>nul
    )

    set "BCK_COUNT=0"
    for /f "usebackq delims=" %%B in ("%TEMP%\nova_backups.txt") do (
    set "LINE=%%B"
    if not "!LINE!"=="" (
    set "LINE=!LINE:^M=!"
    for %%F in ("!LINE!") do set "FNAME=%%~nxF"
    set /a BCK_COUNT+=1
    set "BCK_ITEM_!BCK_COUNT!=!FNAME!"
    set "BCK_PATH_!BCK_COUNT!=!LINE!"
    echo [!BCK_COUNT!] !FNAME!
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_ITEM_!BCK_COUNT!="!FNAME!"
    echo [DEBUG] BCK_PATH_!BCK_COUNT!="!LINE!"
    )
    )
    )
    del "%TEMP%\nova_backups.txt" >nul 2>&1

    if %BCK_COUNT% EQU 0 (
    echo [INFO] No .novabackup files found in %ANDROID_BCK_DIR%.
    echo Searching Android storage for *.novabackup files ...
    echo.

    "%ADB_EXE%" -s %ADB_TARGET% shell "for d in /storage/emulated/0 /storage/*; do [ -d \"\$d\" ] && [ \"\$d\" != \"/storage/emulated\" ] && find \"\$d\" -maxdepth 5 -name '*.novabackup' 2>/dev/null; done" 2>nul > "%TEMP%\nova_backups_search.txt"

    if "%DEBUG%"=="1" (
    echo [DEBUG] Search exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %TEMP%\nova_backups_search.txt contents:
    type "%TEMP%\nova_backups_search.txt" 2>nul
    )

    for /f "usebackq delims=" %%S in ("%TEMP%\nova_backups_search.txt") do (
    set "LINE=%%S"
    if not "!LINE!"=="" (
    set "LINE=!LINE:^M=!"
    for %%F in ("!LINE!") do set "FNAME=%%~nxF"
    set /a BCK_COUNT+=1
    set "BCK_ITEM_!BCK_COUNT!=!FNAME!"
    set "BCK_PATH_!BCK_COUNT!=!LINE!"
    echo [!BCK_COUNT!] !LINE!
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_ITEM_!BCK_COUNT!="!FNAME!"
    echo [DEBUG] BCK_PATH_!BCK_COUNT!="!LINE!"
    )
    )
    )
    del "%TEMP%\nova_backups_search.txt" >nul 2>&1
    )

    if %BCK_COUNT% EQU 0 (
    echo [WARN] No .novabackup files found in %ANDROID_BCK_DIR% or Android storage.
    :manual_bck
    set "BCK_FILE="
    set /p "BCK_FILE=Enter backup filename or full Android path e.g. 2026-11-19_12-57.novabackup: "
    if "!BCK_FILE!"=="" (
    echo [ERROR] No backup filename provided.
    pause
    exit /b 1
    )
    set "BCK_FILE=!BCK_FILE:"=!"
    set "REMOTE_BCK=!BCK_FILE!"
    if not "!REMOTE_BCK:~0,1!"=="/" set "REMOTE_BCK=%ANDROID_BCK_DIR%/!BCK_FILE!"
    for %%F in ("!REMOTE_BCK!") do set "BCK_FILE=%%~nxF"
    goto :pull_selected_backup
    )

    echo.
    set "BCK_PICK=1"
    set /p "BCK_PICK=Select backup number [1-%BCK_COUNT%, Default: 1]: "
    if "!BCK_PICK!"=="" set "BCK_PICK=1"
    if "%DEBUG%"=="1" echo [DEBUG] BCK_PICK="!BCK_PICK!"

    set "BCK_FILE="
    set "REMOTE_BCK="
    for /l %%N in (1,1,%BCK_COUNT%) do (
    if "!BCK_PICK!"=="%%N" (
    set "BCK_FILE=!BCK_ITEM_%%N!"
    set "REMOTE_BCK=!BCK_PATH_%%N!"
    )
    )

    if "!BCK_FILE!"=="" (
    set "CANDIDATE=!BCK_PICK:"=!"
    set "REMOTE_BCK=!CANDIDATE!"
    if not "!REMOTE_BCK:~0,1!"=="/" set "REMOTE_BCK=%ANDROID_BCK_DIR%/!CANDIDATE!"
    for %%F in ("!REMOTE_BCK!") do set "BCK_FILE=%%~nxF"
    )
    if "%DEBUG%"=="1" (
    echo [DEBUG] BCK_FILE="!BCK_FILE!"
    echo [DEBUG] REMOTE_BCK="!REMOTE_BCK!"
    )

    :pull_selected_backup
    set "LOCAL_BCK=%WORK_DIR%\%BCK_FILE%"
    set "LOCAL_ZIP=%WORK_DIR%\backup.zip"
    set "EXTRACT_DIR=%WORK_DIR%\backup_extracted"

    echo.
    echo Pulling "%REMOTE_BCK%" to "%LOCAL_BCK%" ...
    "%ADB_EXE%" -s %ADB_TARGET% pull "%REMOTE_BCK%" "%LOCAL_BCK%"
    if errorlevel 1 (
    echo [ERROR] Failed to pull backup from Android.
    pause
    exit /b 1
    )

    if exist "%LOCAL_ZIP%" del /f /q "%LOCAL_ZIP%"
    ren "%LOCAL_BCK%" "backup.zip"
    if errorlevel 1 (
    echo [ERROR] Failed to rename "%LOCAL_BCK%" to backup.zip.
    pause
    exit /b 1
    )

    if exist "%EXTRACT_DIR%" rmdir /s /q "%EXTRACT_DIR%"
    echo Extracting backup.zip to "%EXTRACT_DIR%" ...
    powershell -NoProfile -Command "Expand-Archive -LiteralPath '%LOCAL_ZIP%' -DestinationPath '%EXTRACT_DIR%' -Force"
    if errorlevel 1 (
    echo [ERROR] Failed to extract backup.zip.
    pause
    exit /b 1
    )

    set "DB_PATH=%EXTRACT_DIR%\nova.db"

    goto :verify_db

    :: -------------------------------------------------------------------------
    :: Option 2: Use local nova db or novabackup or zip
    :: -------------------------------------------------------------------------
    :use_local_source
    echo.
    echo --- Local Database Selection ---
    echo Enter the path to nova.db or a .novabackup or .zip file.
    echo Default: "%WORK_DIR%\backup_extracted\nova.db"
    echo.

    :ask_local_db
    set "USER_DB="
    set /p "USER_DB=Path to database or backup file [Enter for default]: "

    if "!USER_DB!"=="" (
    set "DB_PATH=%WORK_DIR%\backup_extracted\nova.db"
    ) else (
    set "USER_DB=!USER_DB:"=!"
    for %%A in ("!USER_DB!") do set "DB_PATH=%%~fA"
    )

    if not exist "%DB_PATH%" (
    echo [ERROR] File not found: "%DB_PATH%"
    set "RETRY="
    set /p "RETRY=Try again? [Y/n]: "
    if /i "!RETRY!"=="n" exit /b 1
    goto :ask_local_db
    )

    for %%E in ("%DB_PATH%") do set "EXT=%%~xE"
    if /i "!EXT!"==".novabackup" goto :local_novabackup
    if /i "!EXT!"==".zip" goto :extract_local_archive
    goto :verify_db

    :local_novabackup
    echo.
    set "RESTORE_LOCAL="
    set /p "RESTORE_LOCAL=Restore this backup in Nova on the connected device? [y/N]: "
    if /i not "!RESTORE_LOCAL!"=="y" goto :extract_local_archive

    if not exist "%ADB_EXE%" (
    echo [ERROR] adb.exe not found at "%ADB_EXE%"; cannot send the backup to the device.
    pause
    exit /b 1
    )

    set "RESTORE_TARGET="
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!RESTORE_TARGET!"=="" set "RESTORE_TARGET=%%g"
    )
    )

    if "!RESTORE_TARGET!"=="" (
    echo [ERROR] No connected ADB device found; cannot restore the backup.
    pause
    exit /b 1
    )

    set "NOVA_BACKUP_DIR=/storage/emulated/0/Android/data/com.teslacoilsw.launcher/files/Backup"
    echo Copying "%DB_PATH%" to Nova's backup folder on !RESTORE_TARGET! ...
    "%ADB_EXE%" -s !RESTORE_TARGET! shell mkdir -p "%NOVA_BACKUP_DIR%"
    if errorlevel 1 (
    echo [ERROR] Could not create Nova's backup folder on the device.
    pause
    exit /b 1
    )

    "%ADB_EXE%" -s !RESTORE_TARGET! push "%DB_PATH%" "%NOVA_BACKUP_DIR%/"
    if errorlevel 1 (
    echo [ERROR] Failed to copy the backup to the device.
    pause
    exit /b 1
    )

    echo Launching Nova Launcher settings on !RESTORE_TARGET! ...
    "%ADB_EXE%" -s !RESTORE_TARGET! shell am start -n com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity
    echo In Nova, choose Backup & restore and restore the backup you copied.
    goto :extract_local_archive

    :extract_local_archive
    set "EXTRACT_DIR=%WORK_DIR%\backup_extracted"
    if exist "%EXTRACT_DIR%" rmdir /s /q "%EXTRACT_DIR%"
    echo Extracting "%DB_PATH%" to "%EXTRACT_DIR%" ...
    powershell -NoProfile -Command "Expand-Archive -LiteralPath '%DB_PATH%' -DestinationPath '%EXTRACT_DIR%' -Force"
    if errorlevel 1 (
    echo [ERROR] Failed to extract archive.
    pause
    exit /b 1
    )
    set "DB_PATH=%EXTRACT_DIR%\nova.db"

    :: -------------------------------------------------------------------------
    :: Verify database and list dock, panes, folders and other
    :: -------------------------------------------------------------------------
    :verify_db
    if not exist "%DB_PATH%" (
    echo [ERROR] nova.db not found at: "%DB_PATH%"
    pause
    exit /b 1
    )

    echo.
    echo Using database: "%DB_PATH%"
    echo Scanning Nova Launcher dock, panes and folders ...
    echo.

    set "TGT_COUNT=0"
    set "LISTED_FOLDER_IDS=,"

    :: 1 Dock section first as [1] dock apps plus dock folders if any
    echo dock
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=dock apps"
    set "TGT_WHERE_!TGT_COUNT!=f.container = -101"
    set "TGT_ORDER_!TGT_COUNT!=f.screen, f.cellY, f.cellX, f.rank, f._id"
    echo [!TGT_COUNT!] dock apps

    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 AND container = -101 ORDER BY cellY, cellX, rank, _id;" > "%TEMP%\nova_dock_folders.txt" 2>nul
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_dock_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=dock - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    set "LISTED_FOLDER_IDS=!LISTED_FOLDER_IDS!!FID!,"
    echo [!TGT_COUNT!] !FNAME!
    )
    )
    del "%TEMP%\nova_dock_folders.txt" >nul 2>&1

    :: 2 Panes 0 to 14 with folders and loose apps via :scan_pane subroutine
    for /l %%P in (0,1,14) do (
    call :scan_pane %%P
    )

    :: 3 Other folders not already listed under dock or a pane
    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 ORDER BY LOWER(title), _id;" > "%TEMP%\nova_other_folders.txt" 2>nul
    set "OTHER_HAS_FOLDERS=0"
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_other_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    echo !LISTED_FOLDER_IDS! | findstr /c:",!FID!," >nul
    if errorlevel 1 (
    if "!OTHER_HAS_FOLDERS!"=="0" (
    echo other
    set "OTHER_HAS_FOLDERS=1"
    )
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=other - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    echo [!TGT_COUNT!] !FNAME!
    )
    )
    )
    del "%TEMP%\nova_other_folders.txt" >nul 2>&1

    echo.
    set "TGT_PICK="
    :: Allow q or 0 to quit cleanly without running a query
    set /p "TGT_PICK=Select number [1-%TGT_COUNT%, q to quit]: "
    if "%DEBUG%"=="1" echo [DEBUG] TGT_PICK="!TGT_PICK!"

    if /i "!TGT_PICK!"=="q" goto :check_missing_3p
    if "!TGT_PICK!"=="0" goto :check_missing_3p

    set "SELECTED_LABEL="
    set "SQL_WHERE="
    set "SQL_ORDER="
    for /l %%N in (1,1,%TGT_COUNT%) do (
    if "!TGT_PICK!"=="%%N" (
    set "SELECTED_LABEL=!TGT_LABEL_%%N!"
    set "SQL_WHERE=!TGT_WHERE_%%N!"
    set "SQL_ORDER=!TGT_ORDER_%%N!"
    )
    )

    if "%DEBUG%"=="1" (
    echo [DEBUG] SELECTED_LABEL="!SELECTED_LABEL!"
    echo [DEBUG] SQL_WHERE="!SQL_WHERE!"
    echo [DEBUG] SQL_ORDER="!SQL_ORDER!"
    )

    if "!SQL_WHERE!"=="" (
    echo [ERROR] Invalid selection: "!TGT_PICK!"
    pause
    exit /b 1
    )

    :run_query
    if "%DEBUG%"=="1" echo [DEBUG] Entering :run_query

    :: Write label character replacer ps1 to %TEMP% so cmd never parses regex characters
    set "PS_SANITIZE=%TEMP%\adbfolder_sanitize.ps1"
    set "SAFE_NAME_FILE=%TEMP%\adbfolder_safename.txt"

    "%PS_SANITIZE%" echo $raw = $env:SELECTED_LABEL
    "%PS_SANITIZE%" echo $s = [regex]::Replace($raw, '[\\/:*?"<>|() ]+', '_')
    "%PS_SANITIZE%" echo $s = $s.Trim('_')
    "%PS_SANITIZE%" echo if ([string]::IsNullOrWhiteSpace($s)) { $s = "nova_target" }
    "%PS_SANITIZE%" echo [System.IO.File]::WriteAllText($env:SAFE_NAME_FILE, $s, (New-Object System.Text.UTF8Encoding($false)))

    if "%DEBUG%"=="1" (
    echo [DEBUG] Wrote "%PS_SANITIZE%"
    echo [DEBUG] Running character replacer PowerShell script...
    )

    powershell -NoProfile -ExecutionPolicy Bypass -File "%PS_SANITIZE%"
    if "%DEBUG%"=="1" echo [DEBUG] Character replacer exit errorlevel=!errorlevel!

    set "SAFE_NAME="
    if exist "%SAFE_NAME_FILE%" (
    for /f "usebackq delims=" %%S in ("%SAFE_NAME_FILE%") do set "SAFE_NAME=%%S"
    )
    if "!SAFE_NAME!"=="" set "SAFE_NAME=nova_target"

    del "%PS_SANITIZE%" >nul 2>&1
    del "%SAFE_NAME_FILE%" >nul 2>&1

    if "%DEBUG%"=="1" echo [DEBUG] SAFE_NAME="!SAFE_NAME!"

    set "RAW_OUT=%WORK_DIR%\output.txt"
    set "CLEAN_OUT=%WORK_DIR%\%SAFE_NAME%_apps.txt"
    set "LOG_OUT=%WORK_DIR%\adbfolder_log.txt"
    set "SQL_QUERY_FILE=%TEMP%\adbfolder_query.sql"

    if "%DEBUG%"=="1" (
    echo [DEBUG] RAW_OUT="%RAW_OUT%"
    echo [DEBUG] CLEAN_OUT="%CLEAN_OUT%"
    echo [DEBUG] SQL_QUERY_FILE="%SQL_QUERY_FILE%"
    )

    echo.
    echo Querying "!SELECTED_LABEL!" ...

    "%SQL_QUERY_FILE%" echo .header on
    "%SQL_QUERY_FILE%" echo .mode tabs
    "%SQL_QUERY_FILE%" echo SELECT f._id AS item_id,
    "%SQL_QUERY_FILE%" echo f.title AS display_name,
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN f.iconPackage IS NOT NULL AND LENGTH(TRIM(f.iconPackage^)^) ^> 0 THEN TRIM(f.iconPackage^)
    "%SQL_QUERY_FILE%" echo WHEN INSTR(f.intent, 'component='^) ^> 0 THEN
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), '/'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), '/'^) - 1^)
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), ';'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^), ';'^) - 1^)
    "%SQL_QUERY_FILE%" echo ELSE SUBSTR(f.intent, INSTR(f.intent, 'component='^) + 10^)
    "%SQL_QUERY_FILE%" echo END
    "%SQL_QUERY_FILE%" echo WHEN INSTR(f.intent, 'package='^) ^> 0 THEN
    "%SQL_QUERY_FILE%" echo CASE
    "%SQL_QUERY_FILE%" echo WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), ';'^) ^> 0 THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), 1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^), ';'^) - 1^)
    "%SQL_QUERY_FILE%" echo ELSE SUBSTR(f.intent, INSTR(f.intent, 'package='^) + 8^)
    "%SQL_QUERY_FILE%" echo END
    "%SQL_QUERY_FILE%" echo ELSE ''
    "%SQL_QUERY_FILE%" echo END AS package_name,
    "%SQL_QUERY_FILE%" echo f.intent
    "%SQL_QUERY_FILE%" echo FROM favorites f
    "%SQL_QUERY_FILE%" echo WHERE !SQL_WHERE!
    "%SQL_QUERY_FILE%" echo ORDER BY !SQL_ORDER!;

    "%SQLITE_EXE%" "%DB_PATH%" < "%SQL_QUERY_FILE%" > "%RAW_OUT%"

    if "%DEBUG%"=="1" (
    echo [DEBUG] sqlite3 query exit errorlevel=!errorlevel!
    echo [DEBUG] Raw %RAW_OUT% line count:
    find /c /v "" "%RAW_OUT%" 2>nul
    )

    del "%SQL_QUERY_FILE%" >nul 2>&1

    if errorlevel 1 (
    echo [ERROR] SQLite query failed.
    pause
    exit /b 1
    )

    :: Write column formatter ps1 to %TEMP%
    :: Add pane/folder heading, indent spaces and append to log
    set "PS_FORMAT=%TEMP%\adbfolder_format.ps1"

    if exist "%PS_FORMAT%" del /f /q "%PS_FORMAT%" >nul 2>&1

    "%PS_FORMAT%" echo $rawFile = $env:RAW_OUT
    "%PS_FORMAT%" echo $cleanFile = $env:CLEAN_OUT
    "%PS_FORMAT%" echo $logFile = $env:LOG_OUT
    "%PS_FORMAT%" echo $label = $env:SELECTED_LABEL
    "%PS_FORMAT%" echo $rows = Import-Csv -LiteralPath $rawFile -Delimiter "`t"
    "%PS_FORMAT%" echo $lines = $rows ^| Select-Object package_name, display_name ^| Format-Table -AutoSize ^| Out-String -Width 4096
    "%PS_FORMAT%" echo $tableLines = @($lines -split "`r?`n" ^| ForEach-Object { $_.TrimEnd() } ^| Where-Object { $_ -ne '' })
    "%PS_FORMAT%" echo $header = " $label"
    "%PS_FORMAT%" echo if ($label -match '^pane\s+(\d+)\s+-\s+(.+)$') { $header = (' pane {0} folder "{1}"' -f $Matches[1], $Matches[2]) }
    "%PS_FORMAT%" echo $body = ($tableLines ^| ForEach-Object { ' ' + $_ }) -join "`r`n"
    "%PS_FORMAT%" echo $clean = $header + "`r`n" + $body + "`r`n"
    "%PS_FORMAT%" echo $utf8 = New-Object System.Text.UTF8Encoding($false)
    "%PS_FORMAT%" echo [System.IO.File]::WriteAllText($cleanFile, $clean, $utf8)
    "%PS_FORMAT%" echo $timestamp = Get-Date -Format 'yyyy-MM-dd HH:mm:ss'
    "%PS_FORMAT%" echo $entry = "`r`n============================================================`r`nExport: $timestamp`r`n$clean"
    "%PS_FORMAT%" echo [System.IO.File]::AppendAllText($logFile, $entry, $utf8)

    if "%DEBUG%"=="1" echo [DEBUG] Running formatter PowerShell script "%PS_FORMAT%"...
    powershell -NoProfile -ExecutionPolicy Bypass -File "%PS_FORMAT%"
    if "%DEBUG%"=="1" echo [DEBUG] PowerShell formatter exit errorlevel=!errorlevel!

    del "%PS_FORMAT%" >nul 2>&1

    if errorlevel 1 (
    echo [ERROR] Failed to format output columns or append running log.
    pause
    exit /b 1
    )

    echo.
    echo --- Result (%CLEAN_OUT%) ---
    echo.
    type "%CLEAN_OUT%"
    echo.
    echo Raw tab-delimited output saved to: "%RAW_OUT%"
    echo Formatted app list saved to: "%CLEAN_OUT%"
    echo Running export log saved to: "%LOG_OUT%"
    echo.

    :: Loop back to menu so user can export another folder or pane
    set "LOOP_MORE="
    set /p "LOOP_MORE=Export another folder or pane? [y/N]: "
    if /i "!LOOP_MORE!"=="y" goto :verify_db

    :: -------------------------------------------------------------------------
    :: End-of-run check for third-party packages -3 missing from nova.db
    :: -------------------------------------------------------------------------
    :check_missing_3p
    echo.
    set "CHECK_3P="
    set /p "CHECK_3P=Check user apps -3 with no icon in Nova before quitting? [y/N]: "
    if /i not "!CHECK_3P!"=="y" goto :quit_script

    if "%DEBUG%"=="1" (
    echo [DEBUG] Entering :check_missing_3p
    echo [DEBUG] ADB_EXE="%ADB_EXE%"
    echo [DEBUG] SQLITE_EXE="%SQLITE_EXE%"
    echo [DEBUG] DB_PATH="%DB_PATH%"
    echo [DEBUG] ADB_TARGET="%ADB_TARGET%"
    )

    if not exist "%ADB_EXE%" (
    echo [INFO] adb.exe not found at "%ADB_EXE%"; skipping device package check.
    goto :quit_script
    )

    set "RUN_ADB_TARGET=%ADB_TARGET%"
    if "!RUN_ADB_TARGET!"=="" (
    for /f "skip=1 tokens=1" %%g in ('"%ADB_EXE%" devices') do (
    if not "%%g"=="" (
    if "!RUN_ADB_TARGET!"=="" set "RUN_ADB_TARGET=%%g"
    )
    )
    )

    if "%DEBUG%"=="1" echo [DEBUG] RUN_ADB_TARGET="!RUN_ADB_TARGET!"

    if "!RUN_ADB_TARGET!"=="" (
    echo [INFO] No connected ADB device found; skipping device package check.
    goto :quit_script
    )

    if not exist "%DB_PATH%" (
    echo [INFO] Nova database not available at "%DB_PATH%"; skipping device package check.
    goto :quit_script
    )

    set "RESOLVE_LABELS="
    set /p "RESOLVE_LABELS=Resolve app titles via adb/aapt slower over Wi-Fi? [y/N]: "
    set "DO_RESOLVE_LABELS=0"
    if /i "!RESOLVE_LABELS!"=="y" set "DO_RESOLVE_LABELS=1"
    if "%DEBUG%"=="1" echo [DEBUG] DO_RESOLVE_LABELS="!DO_RESOLVE_LABELS!"

    set "PM_3P_FILE=%TEMP%\adbfolder_pm3.txt"
    set "NOVA_PKGS_FILE=%TEMP%\adbfolder_nova_pkgs.txt"
    set "UNPLACED_OUT=%WORK_DIR%\unplaced_user_apps.txt"
    set "PS_DIFF_3P=%TEMP%\adbfolder_diff_3p.ps1"
    :: v3p2: Write SQL to a temp .sql file so cmd does not parse SQL operators/quotes
    set "SQL_NOVA_PKGS=%TEMP%\adbfolder_nova_pkgs.sql"

    if "%DEBUG%"=="1" (
    echo [DEBUG] PM_3P_FILE="!PM_3P_FILE!"
    echo [DEBUG] NOVA_PKGS_FILE="!NOVA_PKGS_FILE!"
    echo [DEBUG] UNPLACED_OUT="!UNPLACED_OUT!"
    echo [DEBUG] PS_DIFF_3P="!PS_DIFF_3P!"
    echo [DEBUG] SQL_NOVA_PKGS="!SQL_NOVA_PKGS!"
    )

    echo Querying third-party packages from device !RUN_ADB_TARGET! ...
    if "%DEBUG%"=="1" echo [DEBUG] Running adb pm list packages -3...
    "%ADB_EXE%" -s !RUN_ADB_TARGET! shell pm list packages -3 2>nul > "!PM_3P_FILE!"
    if "%DEBUG%"=="1" (
    echo [DEBUG] adb pm exit errorlevel=!errorlevel!
    echo [DEBUG] PM_3P_FILE line count:
    find /c /v "" "!PM_3P_FILE!" 2>nul
    )

    echo Querying packages referenced anywhere in nova.db ...
    if "%DEBUG%"=="1" echo [DEBUG] Writing and running sqlite3 Nova package query from .sql file...
    :: v3p3: Use LENGTH/TRIM checks instead of != so delayed expansion cannot drop negation
    "!SQL_NOVA_PKGS!" echo SELECT DISTINCT package_name
    "!SQL_NOVA_PKGS!" echo FROM (
    "!SQL_NOVA_PKGS!" echo SELECT CASE
    "!SQL_NOVA_PKGS!" echo WHEN iconPackage IS NOT NULL AND LENGTH(TRIM(iconPackage^)^) ^> 0 THEN TRIM(iconPackage^)
    "!SQL_NOVA_PKGS!" echo WHEN INSTR(intent, 'component='^) ^> 0 THEN
    "!SQL_NOVA_PKGS!" echo CASE
    "!SQL_NOVA_PKGS!" echo WHEN INSTR(SUBSTR(intent, INSTR(intent, 'component='^) + 10^), '/'^) ^> 0 THEN SUBSTR(
    "!SQL_NOVA_PKGS!" echo SUBSTR(intent, INSTR(intent, 'component='^) + 10^),
    "!SQL_NOVA_PKGS!" echo 1,
    "!SQL_NOVA_PKGS!" echo INSTR(SUBSTR(intent, INSTR(intent, 'component='^) + 10^), '/'^) - 1
    "!SQL_NOVA_PKGS!" echo ^)
    "!SQL_NOVA_PKGS!" echo ELSE SUBSTR(intent, INSTR(intent, 'component='^) + 10^)
    "!SQL_NOVA_PKGS!" echo END
    "!SQL_NOVA_PKGS!" echo ELSE ''
    "!SQL_NOVA_PKGS!" echo END AS package_name
    "!SQL_NOVA_PKGS!" echo FROM favorites
    "!SQL_NOVA_PKGS!" echo )
    "!SQL_NOVA_PKGS!" echo WHERE LENGTH(package_name^) ^> 0;

    "%SQLITE_EXE%" "%DB_PATH%" < "!SQL_NOVA_PKGS!" > "!NOVA_PKGS_FILE!"
    if "%DEBUG%"=="1" (
    echo [DEBUG] sqlite3 Nova pkgs exit errorlevel=!errorlevel!
    echo [DEBUG] NOVA_PKGS_FILE line count:
    find /c /v "" "!NOVA_PKGS_FILE!" 2>nul
    echo [DEBUG] Writing PS_DIFF_3P script...
    )

    :: v3p2: Write PS_DIFF_3P line-by-line instead of an outer parenthesized block
    :: v3p4: Resolve app labels for unplaced packages via adb dumpsys and aapt/aapt2 if available
    :: v3p5: Remove stray caret escaping before closing paren on standalone echo lines
    :: v3p6: Prompt whether to resolve app titles and print periodic progress during lookup
    if exist "!PS_DIFF_3P!" del /f /q "!PS_DIFF_3P!" >nul 2>&1
    "!PS_DIFF_3P!" echo $adbExe = $env:ADB_EXE
    "!PS_DIFF_3P!" echo $adbTarget = $env:RUN_ADB_TARGET
    "!PS_DIFF_3P!" echo $resolveLabels = ($env:DO_RESOLVE_LABELS -eq '1')
    "!PS_DIFF_3P!" echo $pm3Lines = Get-Content -LiteralPath $env:PM_3P_FILE -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo $installed3 = [System.Collections.Generic.HashSet[string]]::new([System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo foreach ($line in $pm3Lines) {
    "!PS_DIFF_3P!" echo $p = ($line -replace '\r', '').Trim()
    "!PS_DIFF_3P!" echo if ($p.StartsWith('package:')) { $p = $p.Substring(8).Trim() }
    "!PS_DIFF_3P!" echo if (-not [string]::IsNullOrWhiteSpace($p)) { [void]$installed3.Add($p) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $novaLines = Get-Content -LiteralPath $env:NOVA_PKGS_FILE -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo $inNova = [System.Collections.Generic.HashSet[string]]::new([System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo foreach ($n in $novaLines) {
    "!PS_DIFF_3P!" echo $pkg = ($n -replace '\r', '').Trim()
    "!PS_DIFF_3P!" echo if (-not [string]::IsNullOrWhiteSpace($pkg)) { [void]$inNova.Add($pkg) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $missingList = [System.Collections.Generic.List[string]]::new()
    "!PS_DIFF_3P!" echo foreach ($pkg in $installed3) {
    "!PS_DIFF_3P!" echo if (-not $inNova.Contains($pkg)) { [void]$missingList.Add($pkg) }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $missing = @($missingList.ToArray())
    "!PS_DIFF_3P!" echo [System.Array]::Sort($missing, [System.StringComparer]::OrdinalIgnoreCase)
    "!PS_DIFF_3P!" echo $aaptCmd = if ($resolveLabels) { Get-Command aapt -ErrorAction SilentlyContinue } else { $null }
    "!PS_DIFF_3P!" echo $idx = 0
    "!PS_DIFF_3P!" echo $results = foreach ($pkg in $missing) {
    "!PS_DIFF_3P!" echo $idx++
    "!PS_DIFF_3P!" echo $label = ''
    "!PS_DIFF_3P!" echo if ($resolveLabels) {
    "!PS_DIFF_3P!" echo if (($idx %% 10) -eq 1 -or $idx -eq $missing.Count) {
    "!PS_DIFF_3P!" echo Write-Host ("Resolving titles: {0}/{1} ({2})..." -f $idx, $missing.Count, $pkg)
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $dumpLines = ^& $adbExe -s $adbTarget shell dumpsys package $pkg 2^>$null
    "!PS_DIFF_3P!" echo foreach ($dl in $dumpLines) {
    "!PS_DIFF_3P!" echo if ($dl -match 'nonLocalizedLabel="([^"]+)"') { $label = $Matches[1].Trim() }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo if ([string]::IsNullOrWhiteSpace($label) -and $aaptCmd) {
    "!PS_DIFF_3P!" echo $apkPathLine = (^& $adbExe -s $adbTarget shell pm path $pkg 2^>$null ^| Select-Object -First 1)
    "!PS_DIFF_3P!" echo if ($apkPathLine -and $apkPathLine.Trim().StartsWith('package:')) {
    "!PS_DIFF_3P!" echo $apkRemote = $apkPathLine.Trim().Substring(8).Trim()
    "!PS_DIFF_3P!" echo $apkLocal = Join-Path $env:TEMP "adbfolder_probe.apk"
    "!PS_DIFF_3P!" echo ^& $adbExe -s $adbTarget pull $apkRemote $apkLocal ^>$null 2^>^&1
    "!PS_DIFF_3P!" echo if (Test-Path -LiteralPath $apkLocal) {
    "!PS_DIFF_3P!" echo $badging = ^& $aaptCmd.Source dump badging $apkLocal 2^>$null
    "!PS_DIFF_3P!" echo foreach ($bl in $badging) {
    "!PS_DIFF_3P!" echo if ($bl -match "^application-label:'([^']+)'") { $label = $Matches[1].Trim(); break }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo Remove-Item -LiteralPath $apkLocal -Force -ErrorAction SilentlyContinue
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo [PSCustomObject]@{ package_name = $pkg; app_title = $label }
    "!PS_DIFF_3P!" echo }
    "!PS_DIFF_3P!" echo $tableText = if (@($results).Count -gt 0) {
    "!PS_DIFF_3P!" echo ((@($results) ^| Format-Table -AutoSize ^| Out-String -Width 4096) -split "`r?`n" ^| ForEach-Object { $_.TrimEnd() } ^| Where-Object { $_ -ne '' }) -join "`r`n" + "`r`n"
    "!PS_DIFF_3P!" echo } else { "" }
    "!PS_DIFF_3P!" echo [System.IO.File]::WriteAllText($env:UNPLACED_OUT, $tableText, (New-Object System.Text.UTF8Encoding($false)))
    "!PS_DIFF_3P!" echo Write-Host ("User packages (-3): {0} | In Nova layout: {1} | No icon in Nova: {2}" -f $installed3.Count, $inNova.Count, $missing.Count)
    "!PS_DIFF_3P!" echo if (@($results).Count -gt 0) { Write-Host ""; Write-Output $tableText.TrimEnd() }

    if "%DEBUG%"=="1" (
    echo [DEBUG] PS_DIFF_3P write exit errorlevel=!errorlevel!
    echo [DEBUG] Generated PS_DIFF_3P contents:
    type "!PS_DIFF_3P!" 2>nul
    echo [DEBUG] Executing PS_DIFF_3P...
    )

    powershell -NoProfile -ExecutionPolicy Bypass -File "!PS_DIFF_3P!"
    if "%DEBUG%"=="1" echo [DEBUG] PS_DIFF_3P execution exit errorlevel=!errorlevel!

    echo Saved unplaced user app list to: "!UNPLACED_OUT!"
    echo.

    if not "%DEBUG%"=="1" (
    del "!PM_3P_FILE!" >nul 2>&1
    del "!NOVA_PKGS_FILE!" >nul 2>&1
    del "!PS_DIFF_3P!" >nul 2>&1
    del "!SQL_NOVA_PKGS!" >nul 2>&1
    ) else (
    echo [DEBUG] Keeping temp files because DEBUG=1:
    echo [DEBUG] "!PM_3P_FILE!"
    echo [DEBUG] "!NOVA_PKGS_FILE!"
    echo [DEBUG] "!PS_DIFF_3P!"
    echo [DEBUG] "!SQL_NOVA_PKGS!"
    )

    :quit_script
    pause
    exit /b 0

    :: -------------------------------------------------------------------------
    :: Subroutine: scan_pane <pane_number>
    :: -------------------------------------------------------------------------
    :scan_pane
    set "SCR=%~1"

    "%SQLITE_EXE%" -cmd ".separator |" "%DB_PATH%" "SELECT _id, CASE WHEN title IS NULL OR TRIM(title) = '' THEN '(Untitled Folder)' ELSE title END FROM favorites WHERE itemType = 2 AND container = -100 AND CAST(screen AS INTEGER) = %SCR% ORDER BY cellY, cellX, rank, _id;" > "%TEMP%\nova_pane_folders.txt" 2>nul

    set "LOOSE_CNT=0"
    "%SQLITE_EXE%" "%DB_PATH%" "SELECT COUNT(*) FROM favorites WHERE container = -100 AND CAST(screen AS INTEGER) = %SCR% AND itemType <> 2;" > "%TEMP%\nova_pane_loose_cnt.txt" 2>nul

    for /f "usebackq delims=" %%C in ("%TEMP%\nova_pane_loose_cnt.txt") do (
    if not "%%C"=="" set "LOOSE_CNT=%%C"
    )
    del "%TEMP%\nova_pane_loose_cnt.txt" >nul 2>&1

    set "HAS_PANE_FOLDERS=0"
    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_pane_folders.txt") do (
    set "FID=%%A"
    if not "!FID!"=="" set "HAS_PANE_FOLDERS=1"
    )

    set "PRINT_HEADER=0"
    if !HAS_PANE_FOLDERS! GTR 0 set "PRINT_HEADER=1"
    if !LOOSE_CNT! GTR 0 set "PRINT_HEADER=1"

    if "!PRINT_HEADER!"=="1" echo pane %SCR%

    for /f "usebackq tokens=1* delims=|" %%A in ("%TEMP%\nova_pane_folders.txt") do (
    set "FID=%%A"
    set "FNAME=%%B"
    set "FNAME=!FNAME:^M=!"
    if not "!FID!"=="" (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=pane %SCR% - !FNAME!"
    set "TGT_WHERE_!TGT_COUNT!=f.container = !FID!"
    set "TGT_ORDER_!TGT_COUNT!=f.rank, f._id"
    set "LISTED_FOLDER_IDS=!LISTED_FOLDER_IDS!!FID!,"
    echo [!TGT_COUNT!] !FNAME!
    )
    )

    if !LOOSE_CNT! GTR 0 (
    set /a TGT_COUNT+=1
    set "TGT_LABEL_!TGT_COUNT!=pane %SCR% loose apps"
    set "TGT_WHERE_!TGT_COUNT!=f.container = -100 AND CAST(f.screen AS INTEGER) = %SCR% AND f.itemType <> 2"
    set "TGT_ORDER_!TGT_COUNT!=f.cellY, f.cellX, f.rank, f._id"
    echo [!TGT_COUNT!] pane %SCR% loose apps
    )

    del "%TEMP%\nova_pane_folders.txt" >nul 2>&1
    goto :eof
    :: -------------------------------------------------------------------------
    :: end of adbfolder.bat
    :: -------------------------------------------------------------------------
    :: Step by step description of what this script does
    :: 1. Environment & Configuration Setup
    :: A. Command environment
    :: a. Disables command echoing and enables delayed expansion
    :: b. Sets the working directory to the script's path
    :: B. Configuration variables
    :: a. Sets default configuration paths for ADB, SQLite
    :: and work directories
    :: b. Defines the DEBUG toggle flag
    :: 2. Dependency Verification
    :: A. Executable checks
    :: a. Locates adb.exe and checks system PATH or configured fallback path
    :: b. Locates sqlite3.exe and exits with an error if missing
    :: B. Directory setup
    :: a. Creates the local working directory if it does not exist
    :: 3. Source Selection Menu
    :: A. Choice [1]: Pull from Android via ADB
    :: a. Detects connected ADB device target
    :: b. Lists .novabackup files in the remote backup directory
    :: with fallback search
    :: c. Prompts user to select or enter a backup filename/path
    :: d. Pulls the selected .novabackup file to the Windows workspace
    :: e. Renames the pulled file to backup.zip and extracts it
    :: into backup_extracted to retrieve nova.db
    :: B. Choice [2]: Use Local Database / Archive
    :: a. Prompts user for a custom path to nova.db .novabackup or .zip
    :: with a retry loop
    :: b. Validates file existence
    :: c. Automatically extracts archives if .novabackup or .zip file
    :: 4. Database Verification & Target Enumeration
    :: A. Database validation
    :: a. Verifies that nova.db exists at the target path
    :: B. Section 1 [Dock]
    :: a. Scans dock apps [container = -101]
    :: b. Scans and lists any dock folders
    :: C. Section 2 [Panes 0-14]
    :: a. Iterates through home screen panes 0 to 14
    :: via the scan_pane subroutine
    :: b. Queries pane folders [itemType = 2, container = -100]
    :: c. Checks for loose non-folder apps [itemType <> 2] on the pane
    :: D. Section 3 [Other Folders]
    :: a. Searches for orphaned folders not categorized under dock or panes
    :: b. Lists and registers valid other folders
    :: 5. User Selection & Query Execution [run_query]
    :: A. Selection & Sanity
    :: a. Prompts user to select a target number or quit [q or 0]
    :: b. Sanitizes the selected label using a temporary PowerShell
    :: script to generate a safe filename
    :: B. Query Generation & Execution
    :: a. Writes a dynamic SQLite query script to a temp file
    :: [.sql] extracting item ID, app title, package name and raw intent
    :: b. Executes the query against nova.db using sqlite3.exe
    :: C. Output & Formatting
    :: a. Formats output columns [package_name first, display_name second]
    :: into an auto-sized table via PowerShell
    :: b. Adds a descriptive pane/folder heading and indents the table
    :: by two spaces for easier reading and future concatenation
    :: c. Saves raw results [output.txt] and formatted results
    :: [target_apps.txt] to the work directory
    :: d. Appends each formatted export with a timestamp to
    :: [adbfolder_log.txt] without overwriting previous exports
    :: e. Prompts user to loop back to scan another folder/pane or proceed
    :: 6. Optional Unplaced Third-Party Package Check [check_missing_3p]
    :: A. Pre-check Validation
    :: a. Prompts user whether to check for user-installed packages
    :: [-3] missing from the Nova layout
    :: b. Verifies ADB device connectivity and database availability
    :: c. Optionally prompts user to resolve app labels via adb dumpsys
    :: and aapt/aapt2
    :: B. Data Collection
    :: a. Queries installed third-party packages from device
    :: [adb shell pm list packages -3]
    :: b. Queries all referenced packages inside nova.db
    :: C. Diff Analysis & Cleanup
    :: a. Generates and executes a PowerShell diff script to find
    :: installed packages with no home screen icon
    :: b. Outputs a formatted table of unplaced apps to
    :: unplaced_user_apps.txt
    :: c. Cleans up temporary script and text files
    :: [unless DEBUG=1] and exits cleanly
    :: -------------------------------------------------------------------------
    :: Not only is there a question of how to port this for more general use,
    :: but there's also a question of which common launchers will it work with.
    ::
    :: It may be that the native Android launcher may provide a 'parsable
    :: homescreen, so I looked up which might work in addition to Nova Launcher.
    ::
    :: So far, I "think" [tentatively] these will export/import a homescreen.
    :: a. Nova [SQL, .novabackup/nova.db restore]
    :: b. Lawnchair [.lawnchairbackup/restore]
    :: c. Mink [JSON backup/restore]
    :: d. Total Launcher [zip? backup/restore]
    :: e. Niagra [nlb backup/restore]
    :: d. Others? [SQLite, JSON, XML, etc.]
    :: ------------------------------------------------------------------------- --
    The best thing about Usenet is learning something useful from someone else.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sat Nov 21 22:25:22 2026
    From Newsgroup: misc.phone.mobile.iphone

    Maria Sophia wrote:
    For the record, here is the python script I wrote today based on the
    Windows batch script I had written yesterday that is an example of
    what we'd like to accomplish with iOS over Wi-Fi/USB to any common desktop.

    Actually, that was the batch script. This is the X-platform python script.
    I tested them side by side (found some bugs) and now they work the same.

    #!/usr/bin/env python3
    # -------------------------------------------------------------------------
    # adbfolder.py
    # Usage: python adbfolder.py
    # -------------------------------------------------------------------------
    # Outputs a perfect textual inventory, with debug capability, of an Android
    # homescreen, including location of all panes, folders, packages and titles.
    #
    # Requires adb, sqlite3, tabulate and optionally aapt/aapt2
    #
    # Intended to assist in debugging, inventory, archival, backup and restore.
    # Runs on Windows over Wi-Fi/USB, but can be ported to other platforms.
    #
    # Will pull a backup from android via adb or read an existing nova db or
    # nova backup archive on windows needing only adb and sql dependencies
    #
    # List order is top to bottom, left to right, meaning the leftmost pane
    # is 1st, then subsequent panes, from 0 to 1 to 2 and so on to the right.
    #
    # Similarly, the topleft folder is 1st, then the next folder to the right.
    #
    # Likewise, packages and titles inside of folders are listed in top to
    # bottom order, left to right, providing an exact textual description.
    #
    # Bare icons, not inside folders, are listed separately as a line item.
    # The dock and folders in the dock are treated much like the panes are.
    #
    # This script not only provides a textual inventory of the name and
    # homescreen location of every folder name, package name and display
    # name ever added to the homescreen, but it optionally will 'diff'
    # against packages which were manually installed by the user but
    # which have no current homescreen icon (i.e., "headless" apps).
    #
    # Note the display_name is the current icon title for a given app icon,
    # which can be changed by the user, so it's not always the original.
    # However, for apps installed by the user but without homescreen icons,
    # the optional lookup pulls the app's original defined Android app_label.
    #
    # Output is appended to a timestamped running log file for traceability.
    # Unless the user wipes out the running log, this becomes an automatic
    # audit of all the physical changes a user has made to the homescreen.
    # -------------------------------------------------------------------------
    # Q: Why is saying YES to "Resolve app titles via adb/aapt" very slow?
    # A: For each of the unplaced packages, the script does:
    # a. adb shell dumpsys package <pkg> to look for nonLocalizedLabel=
    # b. If that fails: adb shell pm path <pkg> to find the APK location
    # c. adb pull <apk> to download the APK to the PC
    # d. aapt dump badging <apk> to read the app label from the APK
    # Which is up to 4 ADB commands times N apps = 4N round-trips.
    # Over USB, each round-trip is fast (milliseconds).
    # But, over Wi-Fi, each one has wireless handshake latency,
    # so the total time adds up just waiting on ADB to return results.
    # -------------------------------------------------------------------------
    # v1p6 20261121 Matched output of abfolder.bat v6p1 with adbfolder.py v1p6
    # v1p0 20261121 First attempt at porting adbfolder.bat to adbfolder.py
    # -------------------------------------------------------------------------

    import os
    import sys
    import re
    import subprocess
    import shutil
    import sqlite3
    import zipfile
    import logging
    from pathlib import Path
    from datetime import datetime
    from tabulate import tabulate

    # ---------------------------------------------------------------------------
    # Configuration
    # ---------------------------------------------------------------------------
    DEBUG = False # set True for verbose traces

    ADB_EXE = Path(r"C:\app\editor\android\scrcpy\adb.exe")
    SQLITE_EXE = Path(r"C:\app\editor\android\sdk\platform-tools\sqlite3.exe")
    WORK_DIR = Path(r"C:\app\editor\android\scrcpy\nova")
    ANDROID_BCK_DIR = "/storage/emulated/0/0000/bck/nova_backup"
    DEFAULT_CONTAINER = 2921

    TEMP = Path(os.environ.get("TEMP", Path.home() / "tmp"))


    def debug(msg):
    if DEBUG:
    print(f"[DEBUG] {msg}")


    # ---------------------------------------------------------------------------
    # Helpers
    # ---------------------------------------------------------------------------
    def run(cmd, **kwargs):
    """Run a command and return CompletedProcess."""
    debug(f"Running: {' '.join(map(str, cmd))}")
    return subprocess.run(cmd, capture_output=True, text=True, **kwargs)


    def which(exe_name):
    """Return path to executable if found in PATH or configured paths."""
    found = shutil.which(exe_name)
    return found


    def ensure_dir(path: Path):
    path.mkdir(parents=True, exist_ok=True)


    def prompt(msg, default=None):
    if default is not None:
    msg = f"{msg} [Default: {default}]: "
    else:
    msg = f"{msg}: "
    val = input(msg).strip()
    return val if val else (default or "")


    def yes_no(msg, default="n"):
    val = prompt(f"{msg} [y/N]" if default != "y" else f"{msg} [Y/n]", default)
    return val.lower().startswith("y")


    # ---------------------------------------------------------------------------
    # Dependency check
    # ---------------------------------------------------------------------------
    def check_dependencies():
    print("Checking required tools (adb and sqlite3) ...")

    # ADB
    global ADB_EXE
    path_adb = which("adb")
    if not ADB_EXE.exists():
    if path_adb:
    print(f"[INFO] Configured ADB_EXE not found; using PATH: {path_adb}")
    ADB_EXE = Path(path_adb)
    else:
    print(f"[WARN] adb.exe not found at '{ADB_EXE}' and not in PATH.")
    else:
    if not path_adb:
    print(f"[INFO] adb.exe found at configured path, though not in PATH.")

    # SQLite
    global SQLITE_EXE
    path_sqlite = which("sqlite3")
    if not SQLITE_EXE.exists():
    if path_sqlite:
    print(f"[INFO] Configured SQLITE_EXE not found; using PATH: {path_sqlite}")
    SQLITE_EXE = Path(path_sqlite)
    else:
    print(f"[ERROR] sqlite3.exe not found at '{SQLITE_EXE}' and not in PATH.")
    input("Press Enter to exit...")
    sys.exit(1)
    else:
    if not path_sqlite:
    print(f"[INFO] sqlite3.exe found at configured path, though not in PATH.")

    ensure_dir(WORK_DIR)

    print(f"Working directory: {Path.cwd()}")
    print(f"Nova work directory: {WORK_DIR}")
    print("----------------")
    print()


    # ---------------------------------------------------------------------------
    # ADB helpers
    # ---------------------------------------------------------------------------
    def adb_devices():
    """Return list of connected device serials."""
    res = run([str(ADB_EXE), "devices"])
    devices = []
    for line in res.stdout.strip().splitlines()[1:]:
    parts = line.split()
    if parts and "\t" in line or len(parts) >= 2:
    serial = parts[0]
    state = parts[1] if len(parts) > 1 else ""
    if state == "device":
    devices.append(serial)
    return devices


    def adb_shell(serial, cmd):
    return run([str(ADB_EXE), "-s", serial, "shell", cmd])


    def adb_pull(serial, remote, local):
    return run([str(ADB_EXE), "-s", serial, "pull", remote, str(local)])


    def adb_push(serial, local, remote):
    return run([str(ADB_EXE), "-s", serial, "push", str(local), remote])


    # ---------------------------------------------------------------------------
    # Backup pull from Android
    # ---------------------------------------------------------------------------
    def pull_from_android():
    print("--- Pull Nova Backup from Android ---")

    if not ADB_EXE.exists():
    print(f"[ERROR] adb.exe not found at: '{ADB_EXE}'")
    input("Press Enter to exit...")
    sys.exit(1)

    devices = adb_devices()
    if not devices:
    print("[ERROR] No connected ADB devices found.")
    input("Press Enter to exit...")
    sys.exit(1)

    serial = devices[0]
    debug(f"ADB_TARGET={serial}")
    print(f"Targeting device: {serial}")

    make_bck = yes_no("Open Nova Launcher settings on device to create a new backup first?")
    if make_bck:
    print("Launching Nova Launcher settings on device ...")
    print("Tap Backup & restore > Backup > Save to save to your device")
    run([
    str(ADB_EXE), "-s", serial, "shell",
    "am", "start",
    "-n",
    "com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity"
    ])
    input("Create your backup in Nova Launcher on the device, then press ENTER to list backups.")

    print(f"Listing backups in {ANDROID_BCK_DIR} ...")
    print()

    # List backups in default dir
    res = adb_shell(serial, f"ls -1t '{ANDROID_BCK_DIR}'/*.novabackup 2>/dev/null")

    backups = parse_adb_lines(res.stdout)

    if not backups:
    print(f"[INFO] No .novabackup files found in {ANDROID_BCK_DIR}.")
    print("Searching Android storage for *.novabackup files ...")
    print()

    search_cmd = (
    "for d in /storage/emulated/0 /storage/*; "
    "do [ -d \"$d\" ] && [ \"$d\" != \"/storage/emulated\" ] && "
    "find \"$d\" -maxdepth 5 -name '*.novabackup' 2>/dev/null; done"
    )
    res = adb_shell(serial, search_cmd)
    backups = parse_adb_lines(res.stdout)

    if not backups:
    print(f"[WARN] No .novabackup files found in {ANDROID_BCK_DIR} or Android storage.")
    remote_bck = manual_backup_path()
    else:
    print()
    for i, (fname, fpath) in enumerate(backups, 1):
    print(f" [{i}] {fname}")
    pick = prompt(f"Select backup number [1-{len(backups)}, Default: 1]", "1")
    try:
    idx = int(pick) - 1
    if not (0 <= idx < len(backups)):
    raise ValueError
    except ValueError:
    # Treat as manual path
    remote_bck = manual_backup_path(pick)
    else:
    fname, fpath = backups[idx]
    remote_bck = fpath

    return download_and_extract(serial, remote_bck)


    def parse_adb_lines(text):
    """Parse ADB output into list of (filename, fullpath)."""
    results = []
    for line in text.splitlines():
    line = line.strip().replace("\r", "")
    if not line:
    continue
    path = Path(line)
    fname = path.name
    results.append((fname, line))
    # Newest first, matching `ls -1t`
    results.sort(key=lambda x: x[0], reverse=True)
    return results

    def manual_backup_path(prefill=""):
    if prefill:
    bck_file = prefill.strip().strip('"')
    else:
    bck_file = prompt(
    "Enter backup filename or full Android path "
    "e.g. 2026-11-19_12-57.novabackup"
    )
    if not bck_file:
    print("[ERROR] No backup filename provided.")
    input("Press Enter to exit...")
    sys.exit(1)

    remote_bck = bck_file
    if not remote_bck.startswith("/"):
    remote_bck = f"{ANDROID_BCK_DIR}/{remote_bck}"
    fname = Path(remote_bck).name
    return remote_bck


    def download_and_extract(serial, remote_bck):
    local_bck = WORK_DIR / Path(remote_bck).name
    local_zip = WORK_DIR / "backup.zip"
    extract_dir = WORK_DIR / "backup_extracted"

    print()
    print(f'Pulling "{remote_bck}" to "{local_bck}" ...')
    res = adb_pull(serial, remote_bck, local_bck)
    if res.returncode != 0:
    print("[ERROR] Failed to pull backup from Android.")
    input("Press Enter to exit...")
    sys.exit(1)

    if local_zip.exists():
    local_zip.unlink()

    # Rename pulled file to backup.zip
    shutil.move(str(local_bck), str(local_zip))

    if extract_dir.exists():
    shutil.rmtree(extract_dir)

    print(f"Extracting backup.zip to '{extract_dir}' ...")
    try:
    with zipfile.ZipFile(local_zip, "r") as zf:
    zf.extractall(extract_dir)
    except Exception as e:
    print(f"[ERROR] Failed to extract backup.zip: {e}")
    input("Press Enter to exit...")
    sys.exit(1)

    db_path = extract_dir / "nova.db"
    return db_path


    # ---------------------------------------------------------------------------
    # Local source selection
    # ---------------------------------------------------------------------------
    def use_local_source():
    print("--- Local Database Selection ---")
    print(f'Enter the path to nova.db or a .novabackup or .zip file.')
    print(f'Default: {WORK_DIR / "backup_extracted" / "nova.db"}')
    print()

    while True:
    user_db = prompt("Path to database or backup file [Enter for default]")
    if not user_db:
    db_path = WORK_DIR / "backup_extracted" / "nova.db"
    else:
    user_db = user_db.strip().strip('"')
    db_path = Path(user_db).resolve()

    if not db_path.exists():
    print(f"[ERROR] File not found: '{db_path}'")
    retry = prompt("Try again? [Y/n]", "y")
    if retry.lower().startswith("n"):
    sys.exit(1)
    continue

    ext = db_path.suffix.lower()
    if ext == ".novabackup":
    return extract_local_archive(db_path, restore_prompt=True)
    elif ext == ".zip":
    return extract_local_archive(db_path, restore_prompt=False)
    else:
    return db_path


    def extract_local_archive(archive_path, restore_prompt=False):
    extract_dir = WORK_DIR / "backup_extracted"
    if extract_dir.exists():
    shutil.rmtree(extract_dir)

    print(f'Extracting "{archive_path}" to "{extract_dir}" ...')
    try:
    with zipfile.ZipFile(archive_path, "r") as zf:
    zf.extractall(extract_dir)
    except Exception as e:
    print(f"[ERROR] Failed to extract archive: {e}")
    input("Press Enter to exit...")
    sys.exit(1)

    db_path = extract_dir / "nova.db"

    if restore_prompt and yes_no("Restore this backup in Nova on the connected device?"):
    restore_backup_to_device(db_path)

    return db_path


    def restore_backup_to_device(db_path):
    if not ADB_EXE.exists():
    print(f"[ERROR] adb.exe not found at '{ADB_EXE}'; cannot send backup to device.")
    input("Press Enter to exit...")
    sys.exit(1)

    devices = adb_devices()
    if not devices:
    print("[ERROR] No connected ADB device found; cannot restore the backup.")
    input("Press Enter to exit...")
    sys.exit(1)

    serial = devices[0]
    nova_backup_dir = "/storage/emulated/0/Android/data/com.teslacoilsw.launcher/files/Backup"

    print(f'Copying "{db_path}" to Nova backup folder on {serial} ...')
    adb_shell(serial, f"mkdir -p '{nova_backup_dir}'")
    res = adb_push(serial, db_path, nova_backup_dir + "/")
    if res.returncode != 0:
    print("[ERROR] Failed to copy the backup to the device.")
    input("Press Enter to exit...")
    sys.exit(1)

    print(f"Launching Nova Launcher settings on {serial} ...")
    run([
    str(ADB_EXE), "-s", serial, "shell",
    "am", "start",
    "-n",
    "com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity"
    ])
    print("In Nova, choose Backup & restore and restore the backup you copied.")


    # ---------------------------------------------------------------------------
    # SQLite helpers (use Python sqlite3 module, fall back to CLI)
    # ---------------------------------------------------------------------------
    def sqlite_query(db_path, sql, params=()):
    """Execute a SELECT query using Python sqlite3. Returns list of tuples."""
    try:
    conn = sqlite3.connect(str(db_path))
    cur = conn.execute(sql, params)
    rows = cur.fetchall()
    conn.close()
    return rows
    except sqlite3.Error as e:
    print(f"[ERROR] SQLite query failed: {e}")
    input("Press Enter to exit...")
    sys.exit(1)


    def sqlite_query_cli(db_path, sql, params=()):
    """Fallback: write SQL to temp file and run sqlite3 CLI."""
    sql_file = TEMP / "adbfolder_query.sql"
    sql_file.write_text(sql, encoding="utf-8")
    res = run([str(SQLITE_EXE), str(db_path)], input=sql, text=True)
    if res.returncode != 0:
    print(f"[ERROR] sqlite3 CLI failed: {res.stderr}")
    input("Press Enter to exit...")
    sys.exit(1)
    rows = []
    for line in res.stdout.strip().splitlines():
    rows.append(tuple(line.split("\t")))
    return rows


    # ---------------------------------------------------------------------------
    # Target enumeration
    # ---------------------------------------------------------------------------
    class Target:
    def __init__(self, num, label, where, order):
    self.num = num
    self.label = label
    self.where = where
    self.order = order


    def enumerate_targets(db_path):
    targets = []
    tgt_count = 0
    listed_folder_ids = set()

    # 1. Dock
    print("dock")
    tgt_count += 1
    targets.append(Target(tgt_count, "dock apps", "f.container = -101",
    "f.screen, f.cellY, f.cellX, f.rank, f._id"))
    print(f" [{tgt_count}] dock apps")

    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 AND container = -101 "
    "ORDER BY cellY, cellX, rank, _id")
    for fid, fname in rows:
    tgt_count += 1
    label = f"dock - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    listed_folder_ids.add(str(fid))
    print(f" [{tgt_count}] {fname}")

    # 2. Panes 0-14
    for pane in range(15):
    tgt_count = scan_pane(db_path, pane, targets, tgt_count, listed_folder_ids)

    # 3. Other folders (orphaned folders not under dock or a pane)
    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 "
    "ORDER BY LOWER(title), _id")
    other_has_folders = False
    for fid, fname in rows:
    if str(fid) in listed_folder_ids:
    continue
    if not other_has_folders:
    print("other")
    other_has_folders = True
    tgt_count += 1
    label = f"other - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    print(f" [{tgt_count}] {fname}")

    return targets, tgt_count


    def scan_pane(db_path, pane, targets, tgt_count, listed_folder_ids):
    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 AND container = -100 "
    "AND CAST(screen AS INTEGER) = ? "
    "ORDER BY cellY, cellX, rank, _id", (pane,))

    loose_cnt = sqlite_query(db_path,
    "SELECT COUNT(*) FROM favorites WHERE container = -100 "
    "AND CAST(screen AS INTEGER) = ? AND itemType <> 2", (pane,))[0][0]

    has_pane_folders = len(rows) > 0
    print_header = has_pane_folders or loose_cnt > 0

    if print_header:
    print(f"pane {pane}")

    for fid, fname in rows:
    tgt_count += 1
    label = f"pane {pane} - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    listed_folder_ids.add(str(fid))
    print(f" [{tgt_count}] {fname}")

    if loose_cnt > 0:
    tgt_count += 1
    label = f"pane {pane} loose apps"
    where = (f"f.container = -100 AND CAST(f.screen AS INTEGER) = {pane} "
    f"AND f.itemType <> 2")
    order = "f.cellY, f.cellX, f.rank, f._id"
    targets.append(Target(tgt_count, label, where, order))
    print(f" [{tgt_count}] pane {pane} loose apps")

    return tgt_count

    # ---------------------------------------------------------------------------
    # Sanitize label -> safe filename
    # ---------------------------------------------------------------------------
    def sanitize_label(label):
    safe = re.sub(r'[\\/:*?"<>|() ]+', '_', label).strip('_')
    if not safe:
    safe = "nova_target"
    return safe


    # ---------------------------------------------------------------------------
    # Run query and format output
    # ---------------------------------------------------------------------------
    def run_query(db_path, target, work_dir):
    safe_name = sanitize_label(target.label)
    raw_out = work_dir / "output.txt"
    clean_out = work_dir / f"{safe_name}_apps.txt"
    log_out = work_dir / "adbfolder_log.txt"

    sql = f"""
    SELECT f._id AS item_id,
    f.title AS display_name,
    CASE
    WHEN f.iconPackage IS NOT NULL AND LENGTH(TRIM(f.iconPackage)) > 0
    THEN TRIM(f.iconPackage)
    WHEN INSTR(f.intent, 'component=') > 0 THEN
    CASE
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), '/') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), '/') - 1)
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), ';') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), ';') - 1)
    ELSE SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10)
    END
    WHEN INSTR(f.intent, 'package=') > 0 THEN
    CASE
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8), ';') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8), ';') - 1)
    ELSE SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8)
    END
    ELSE ''
    END AS package_name,
    f.intent
    FROM favorites f
    WHERE {target.where}
    ORDER BY {target.order};
    """

    print()
    print(f'Querying "{target.label}" ...')

    try:
    rows = sqlite_query(db_path, sql)
    except SystemExit:
    rows = sqlite_query_cli(db_path, sql)

    # Write raw tab-delimited output (all columns)
    with open(raw_out, "w", encoding="utf-8") as f:
    f.write("item_id\tdisplay_name\tpackage_name\tintent\n")
    for row in rows:
    f.write("\t".join(str(c) if c is not None else "" for c in row) + "\n")

    # Format only package_name and display_name, in that order
    display_rows = [(row[2], row[1]) for row in rows] # (package_name, display_name)

    table_text = ""
    if display_rows:
    table_text = tabulate(
    display_rows,
    headers=["package_name", "display_name"],
    tablefmt="plain"
    )

    indented = [" " + line for line in table_text.splitlines()]

    # Header matching batch format
    if target.label.startswith("pane ") and " - " in target.label:
    parts = target.label.split(" - ", 1)
    pane_num = parts[0].replace("pane ", "").strip()
    folder_name = parts[1]
    header = f' pane {pane_num} folder "{folder_name}"'
    else:
    header = f" {target.label}"

    clean_text = header + "\n" + "\n".join(indented) + "\n"

    # Write clean output
    clean_out.write_text(clean_text, encoding="utf-8")

    # Append to running log
    timestamp = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    entry = (
    "\n============================================================\n"
    f"Export: {timestamp}\n"
    f"{clean_text}"
    )
    with open(log_out, "a", encoding="utf-8") as f:
    f.write(entry)

    print()
    print(f"--- Result ({clean_out}) ---")
    print()
    print(clean_text)
    print(f"Raw tab-delimited output saved to: {raw_out}")
    print(f"Formatted app list saved to: {clean_out}")
    print(f"Running export log saved to: {log_out}")
    print()

    return clean_out

    # ---------------------------------------------------------------------------
    # Optional: check missing third-party packages
    # ---------------------------------------------------------------------------
    def check_missing_3p(serial, db_path, work_dir):
    print()
    if not yes_no("Check user apps -3 with no icon in Nova before quitting?"):
    return

    if not ADB_EXE.exists():
    print(f"[INFO] adb.exe not found at '{ADB_EXE}'; skipping device package check.")
    return

    devices = adb_devices()
    if not devices:
    print("[INFO] No connected ADB device found; skipping device package check.")
    return
    target_serial = devices[0]
    debug(f"RUN_ADB_TARGET={target_serial}")

    if not db_path or not db_path.exists():
    print("[INFO] Nova database not available; skipping device package check.")
    return

    resolve_labels = yes_no("Resolve app titles via adb/aapt slower over Wi-Fi?", default="n")
    do_resolve = resolve_labels

    pm_3p_file = TEMP / "adbfolder_pm3.txt"
    nova_pkgs_file = TEMP / "adbfolder_nova_pkgs.txt"
    unplaced_out = work_dir / "unplaced_user_apps.txt"

    print(f"Querying third-party packages from device {target_serial} ...")
    res = adb_shell(target_serial, "pm list packages -3 2>/dev/null")
    pm_3p_file.write_text(res.stdout, encoding="utf-8")

    installed3 = set()
    for line in pm_3p_file.read_text(encoding="utf-8").splitlines():
    p = line.replace("\r", "").strip()
    if p.startswith("package:"):
    p = p[8:].strip()
    if p:
    installed3.add(p)

    print("Querying packages referenced anywhere in nova.db ...")
    rows = sqlite_query(db_path,
    "SELECT DISTINCT package_name FROM ("
    " SELECT CASE"
    " WHEN iconPackage IS NOT NULL AND LENGTH(TRIM(iconPackage)) > 0"
    " THEN TRIM(iconPackage)"
    " WHEN INSTR(intent, 'component=') > 0 THEN"
    " CASE"
    " WHEN INSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10), '/') > 0"
    " THEN SUBSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10),"
    " 1, INSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10), '/') - 1)"
    " ELSE SUBSTR(intent, INSTR(intent, 'component=') + 10)"
    " END"
    " ELSE ''"
    " END AS package_name"
    " FROM favorites"
    ")"
    "WHERE LENGTH(package_name) > 0")

    in_nova = set()
    for (pkg,) in rows:
    if pkg:
    in_nova.add(pkg)

    missing = sorted(installed3 - in_nova, key=str.lower)

    results = []
    for i, pkg in enumerate(missing, 1):
    label = ""
    if do_resolve:
    if i % 10 == 1 or i == len(missing):
    print(f"Resolving titles: {i}/{len(missing)} ({pkg})...")
    dump = adb_shell(target_serial, f"dumpsys package {pkg} 2>/dev/null")
    for dl in dump.stdout.splitlines():
    m = re.search(r'nonLocalizedLabel="([^"]+)"', dl)
    if m:
    label = m.group(1).strip()
    if not label:
    # Try aapt path
    apk_path = shutil.which("aapt") or shutil.which("aapt2")
    if apk_path:
    path_res = adb_shell(target_serial, f"pm path {pkg} 2>/dev/null")
    for pl in path_res.stdout.splitlines():
    pl = pl.strip()
    if pl.startswith("package:"):
    apk_remote = pl[8:].strip()
    apk_local = TEMP / "adbfolder_probe.apk"
    pull_res = adb_pull(target_serial, apk_remote, apk_local)
    if pull_res.returncode == 0 and apk_local.exists():
    badging = run([apk_path, "dump", "badging", str(apk_local)],
    capture_output=True, text=True)
    for bl in badging.stdout.splitlines():
    m = re.match(r"^application-label:'([^']+)'", bl)
    if m:
    label = m.group(1).strip()
    break
    try:
    apk_local.unlink()
    except Exception:
    pass
    break
    results.append((pkg, label))

    # Write output
    lines = []
    if results:
    lines.append(tabulate(results, headers=["package_name", "app_title"],
    tablefmt="plain").splitlines())
    flat = []
    for group in lines:
    flat.extend(group)
    table_text = "\n".join(flat) + ("\n" if flat else "")
    unplaced_out.write_text(table_text, encoding="utf-8")

    print()
    print(f"User packages (-3): {len(installed3)} | "
    f"In Nova layout: {len(in_nova)} | "
    f"No icon in Nova: {len(missing)}")
    if results:
    print()
    print(table_text.rstrip())
    print(f"Saved unplaced user app list to: {unplaced_out}")
    print()

    # Cleanup temp files unless debug
    if not DEBUG:
    for f in [pm_3p_file, nova_pkgs_file]:
    try:
    f.unlink()
    except Exception:
    pass


    # ---------------------------------------------------------------------------
    # Main
    # ---------------------------------------------------------------------------
    def main():
    global DEBUG
    # Allow env override
    if os.environ.get("ADBFOLDER_DEBUG", "0") == "1":
    DEBUG = True

    check_dependencies()

    print("Select source for Nova Launcher database:")
    print("[1] Pull .novabackup from Android via ADB and extract nova.db [Default]")
    print("[2] Use an existing nova.db or .novabackup or .zip already on Windows")
    print()

    src_choice = prompt("Enter choice [1 or 2]", "1")

    if src_choice == "2":
    db_path = use_local_source()
    else:
    db_path = pull_from_android()

    if not db_path or not db_path.exists():
    print(f"[ERROR] nova.db not found at: '{db_path}'")
    input("Press Enter to exit...")
    sys.exit(1)

    print()
    print(f"Using database: {db_path}")
    print("Scanning Nova Launcher dock, panes and folders ...")
    print()

    targets, tgt_count = enumerate_targets(db_path)

    print()
    pick = prompt(f"Select number [1-{tgt_count}, q to quit]")
    if pick.lower() == "q" or pick == "0":
    check_missing_3p(None, db_path, WORK_DIR)
    print("Bye.")
    return

    try:
    idx = int(pick) - 1
    if not (0 <= idx < tgt_count):
    raise ValueError
    except ValueError:
    print(f"[ERROR] Invalid selection: '{pick}'")
    input("Press Enter to exit...")
    sys.exit(1)

    target = targets[idx]

    debug(f"SELECTED_LABEL={target.label}")
    debug(f"SQL_WHERE={target.where}")
    debug(f"SQL_ORDER={target.order}")

    run_query(db_path, target, WORK_DIR)

    while True:
    loop_more = yes_no("Export another folder or pane?", default="n")
    if not loop_more:
    break
    # Re-enumerate (in case something changed) and pick again
    targets, tgt_count = enumerate_targets(db_path)
    print()
    pick = prompt(f"Select number [1-{tgt_count}, q to quit]")
    if pick.lower() == "q" or pick == "0":
    break
    try:
    idx = int(pick) - 1
    if not (0 <= idx < tgt_count):
    raise ValueError
    except ValueError:
    print(f"[ERROR] Invalid selection: '{pick}'")
    break
    target = targets[idx]
    run_query(db_path, target, WORK_DIR)

    check_missing_3p(None, db_path, WORK_DIR)
    input("Press Enter to exit...")


    if __name__ == "__main__":
    main()


    # -------------------------------------------------------------------------
    # end of adbfolder.py
    # ------------------------------------------------------------------------- --
    Some people are on Usenet for their amusement but I'm here to get things done. --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Lawrence =?iso-8859-13?q?D=FFOliveiro?=@ldo@nz.invalid to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sun Nov 22 02:41:15 2026
    From Newsgroup: misc.phone.mobile.iphone

    On Sat, 21 Nov 2026 22:25:22 -0400, Maria Sophia wrote:

    def which(exe_name):
    """Return path to executable if found in PATH or configured paths."""
    found = shutil.which(exe_name)
    return found

    from shutil import which
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sun Nov 22 05:37:37 2026
    From Newsgroup: misc.phone.mobile.iphone

    Lawrence D'Oliveiro wrote:
    def which(exe_name):
    """Return path to executable if found in PATH or configured paths.""" >> found = shutil.which(exe_name)
    return found

    from shutil import which

    Hi Lawrence,
    Ah, Fewer lines of code, no redundant wrapper function to read past, and consistent which(...) calls across the whole file. Indeed! It's smoother.

    Thanks for that suggestion to replace the redundant which() wrapper with
    'from shutil import which' (and then using which(...) consistently in check_missing_3p()...

    1. I added this to the imports section
    from shutil import which

    2. I completely removed def which(exe_name) from the helpers section

    3. In check_missing_3p(), I used which() instead of calling shutil.which()

    4. Then, to document the changes, I added an explanatory comment
    # v1p9 20261122 Replaced redundant which() wrapper with a direct
    # shutil.which import so that which("adb"), which("sqlite3"),
    # which("aapt") and which("aapt2") all work out of the box.

    Now which("adb"), which("sqlite3"), which("aapt"), and which("aapt2") all
    work out of the box. Thanks for the helpful advice.

    #!/usr/bin/env python3
    # ----------------------------------------------------------------------
    # adbfolder.py
    # Usage: python adbfolder.py
    # ----------------------------------------------------------------------
    # Outputs a perfect textual inventory, with debug capability, of an Android
    # homescreen, including location of all panes, folders, packages and titles.
    #
    # Requires adb, sqlite3, tabulate and optionally aapt/aapt2
    #
    # Intended to assist in debugging, inventory, archival, backup and restore.
    # Runs on Windows over Wi-Fi/USB, but can be ported to other platforms.
    #
    # Will pull a backup from android via adb or read an existing nova db or
    # nova backup archive on windows needing only adb and sql dependencies
    #
    # List order is top to bottom, left to right, meaning the leftmost pane
    # is 1st, then subsequent panes, from 0 to 1 to 2 and so on to the right.
    #
    # Similarly, the topleft folder is 1st, then the next folder to the right.
    #
    # Likewise, packages and titles inside of folders are listed in top to
    # bottom order, left to right, providing an exact textual description.
    #
    # Bare icons, not inside folders, are listed separately as a line item.
    # The dock and folders in the dock are treated much like the panes are.
    #
    # This script not only provides a textual inventory of the name and
    # homescreen location of every folder name, package name and display
    # name ever added to the homescreen, but it optionally will 'diff'
    # against packages which were manually installed by the user but
    # which have no current homescreen icon (i.e., "headless" apps).
    #
    # Note the display_name is the current icon title for a given app icon,
    # which can be changed by the user, so it's not always the original.
    # However, for apps installed by the user but without homescreen icons,
    # the optional lookup pulls the app's original defined Android app_label.
    #
    # Output is appended to a timestamped running log file for traceability.
    # Unless the user wipes out the running log, this becomes an automatic
    # audit of all the physical changes a user has made to the homescreen.
    # ----------------------------------------------------------------------
    # Q: Why is saying YES to "Resolve app titles via adb/aapt" very slow?
    # A: For each of the unplaced packages, the script does:
    # a. adb shell dumpsys package <pkg> to look for nonLocalizedLabel=
    # b. If that fails: adb shell pm path <pkg> to find the APK location
    # c. adb pull <apk> to download the APK to the PC
    # d. aapt dump badging <apk> to read the app label from the APK
    # Which is up to 4 ADB commands times N apps = 4N round-trips.
    # Over USB, each round-trip is fast (milliseconds).
    # But, over Wi-Fi, each one has wireless handshake latency,
    # so the total time adds up just waiting on ADB to return results.
    # ----------------------------------------------------------------------
    # v1p9 20261122 Replaced redundant which() wrapper with a direct
    # shutil.which import so that which("adb"), which("sqlite3"),
    # which("aapt") and which("aapt2") all work out of the box.
    # v1p8 20261121 Fixed bugs in the optional search for orphan packages
    # v1p7 20261121 Modified the closing comments to reflect the python flow
    # Fixed passing of capture_output=True and text=True twice by
    # mistake in the helper section.
    # v1p6 20261121 Ported to adbfolder.py v1p6 (took a half-dozen iterations)
    # Matched output of abfolder.bat v6p1 with adbfolder.py v1p6
    # v1p0 20261121 First attempt at porting adbfolder.bat to adbfolder.py
    # What's different between the batch and python is mostly:
    # a. SQLite queries primarily use Python's built-in sqlite3 module.
    # b. Output tables use the third-party tabulate module.
    # c. Archive extraction uses Python's zipfile.
    # d. Filename sanitization uses Python regular expressions.
    # e. There are no generated PowerShell scripts or BAT subroutines.
    # f. The optional missing-package check uses Python sets to
    # compare installed packages against Nova database packages.
    # g. Debugging is enabled with DEBUG = True or the ADBFOLDER_DEBUG=1
    # environment variable.
    # ----------------------------------------------------------------------
    # ----------------------------------------------------------------------

    import os
    import sys
    import re
    import subprocess
    import shutil
    import sqlite3
    import zipfile
    import logging
    from shutil import which
    from pathlib import Path
    from datetime import datetime
    from tabulate import tabulate

    # ------------------------------------------------------------------------
    # Configuration
    # ------------------------------------------------------------------------
    DEBUG = False # set True for verbose traces

    ADB_EXE = Path(r"C:\app\editor\android\scrcpy\adb.exe")
    SQLITE_EXE = Path(r"C:\app\editor\android\sdk\platform-tools\sqlite3.exe")
    WORK_DIR = Path(r"C:\app\editor\android\scrcpy\nova")
    ANDROID_BCK_DIR = "/storage/emulated/0/0000/bck/nova_backup"
    DEFAULT_CONTAINER = 2921

    TEMP = Path(os.environ.get("TEMP", Path.home() / "tmp"))


    def debug(msg):
    if DEBUG:
    print(f"[DEBUG] {msg}")


    # ------------------------------------------------------------------------
    # Helpers
    # ------------------------------------------------------------------------
    def run(cmd, **kwargs):
    """Run a command and return CompletedProcess."""
    debug(f"Running: {' '.join(map(str, cmd))}")

    kwargs.setdefault("capture_output", True)
    kwargs.setdefault("text", True)
    kwargs.setdefault("encoding", "utf-8")
    kwargs.setdefault("errors", "replace")
    kwargs.setdefault("timeout", 60)

    return subprocess.run(cmd, **kwargs)

    def ensure_dir(path: Path):
    path.mkdir(parents=True, exist_ok=True)


    def prompt(msg, default=None):
    if default is not None:
    msg = f"{msg} [Default: {default}]: "
    else:
    msg = f"{msg}: "
    val = input(msg).strip()
    return val if val else (default or "")


    def yes_no(msg, default="n"):
    val = prompt(f"{msg} [y/N]" if default != "y" else f"{msg} [Y/n]", default)
    return val.lower().startswith("y")

    # ------------------------------------------------------------------------
    # Dependency check
    # ------------------------------------------------------------------------
    def check_dependencies():
    print("Checking required tools (adb and sqlite3) ...")

    # ADB
    global ADB_EXE
    path_adb = which("adb")
    if not ADB_EXE.exists():
    if path_adb:
    print(f"[INFO] Configured ADB_EXE not found; using PATH: {path_adb}")
    ADB_EXE = Path(path_adb)
    else:
    print(f"[WARN] adb.exe not found at '{ADB_EXE}' and not in PATH.")
    else:
    if not path_adb:
    print(f"[INFO] adb.exe found at configured path, though not in PATH.")

    # SQLite
    global SQLITE_EXE
    path_sqlite = which("sqlite3")
    if not SQLITE_EXE.exists():
    if path_sqlite:
    print(f"[INFO] Configured SQLITE_EXE not found; using PATH: {path_sqlite}")
    SQLITE_EXE = Path(path_sqlite)
    else:
    print(f"[ERROR] sqlite3.exe not found at '{SQLITE_EXE}' and not in PATH.")
    input("Press Enter to exit...")
    sys.exit(1)
    else:
    if not path_sqlite:
    print(f"[INFO] sqlite3.exe found at configured path, though not in PATH.")

    ensure_dir(WORK_DIR)

    print(f"Working directory: {Path.cwd()}")
    print(f"Nova work directory: {WORK_DIR}")
    print("----------------")
    print()


    # ------------------------------------------------------------------------
    # ADB helpers
    # ------------------------------------------------------------------------
    def adb_devices():
    """Return list of connected device serials."""
    res = run([str(ADB_EXE), "devices"])
    devices = []
    for line in res.stdout.strip().splitlines()[1:]:
    parts = line.split()
    if parts and "\t" in line or len(parts) >= 2:
    serial = parts[0]
    state = parts[1] if len(parts) > 1 else ""
    if state == "device":
    devices.append(serial)
    return devices


    def adb_shell(serial, cmd):
    return run([str(ADB_EXE), "-s", serial, "shell", cmd])


    def adb_pull(serial, remote, local):
    return run([str(ADB_EXE), "-s", serial, "pull", remote, str(local)])


    def adb_push(serial, local, remote):
    return run([str(ADB_EXE), "-s", serial, "push", str(local), remote])


    # ------------------------------------------------------------------------
    # Backup pull from Android
    # ------------------------------------------------------------------------
    def pull_from_android():
    print("--- Pull Nova Backup from Android ---")

    if not ADB_EXE.exists():
    print(f"[ERROR] adb.exe not found at: '{ADB_EXE}'")
    input("Press Enter to exit...")
    sys.exit(1)

    devices = adb_devices()
    if not devices:
    print("[ERROR] No connected ADB devices found.")
    input("Press Enter to exit...")
    sys.exit(1)

    serial = devices[0]
    debug(f"ADB_TARGET={serial}")
    print(f"Targeting device: {serial}")

    make_bck = yes_no("Open Nova Launcher settings on device to create a new backup first?")
    if make_bck:
    print("Launching Nova Launcher settings on device ...")
    print("Tap Backup & restore > Backup > Save to save to your device")
    run([
    str(ADB_EXE), "-s", serial, "shell",
    "am", "start",
    "-n",
    "com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity"
    ])
    input("Create your backup in Nova Launcher on the device, then press ENTER to list backups.")

    print(f"Listing backups in {ANDROID_BCK_DIR} ...")
    print()

    # List backups in default dir
    res = adb_shell(serial, f"ls -1t '{ANDROID_BCK_DIR}'/*.novabackup 2>/dev/null")

    backups = parse_adb_lines(res.stdout)

    if not backups:
    print(f"[INFO] No .novabackup files found in {ANDROID_BCK_DIR}.")
    print("Searching Android storage for *.novabackup files ...")
    print()

    search_cmd = (
    "for d in /storage/emulated/0 /storage/*; "
    "do [ -d \"$d\" ] && [ \"$d\" != \"/storage/emulated\" ] && "
    "find \"$d\" -maxdepth 5 -name '*.novabackup' 2>/dev/null; done"
    )
    res = adb_shell(serial, search_cmd)
    backups = parse_adb_lines(res.stdout)

    if not backups:
    print(f"[WARN] No .novabackup files found in {ANDROID_BCK_DIR} or Android storage.")
    remote_bck = manual_backup_path()
    else:
    print()
    for i, (fname, fpath) in enumerate(backups, 1):
    print(f" [{i}] {fname}")
    pick = prompt(f"Select backup number [1-{len(backups)}, Default: 1]", "1")
    try:
    idx = int(pick) - 1
    if not (0 <= idx < len(backups)):
    raise ValueError
    except ValueError:
    # Treat as manual path
    remote_bck = manual_backup_path(pick)
    else:
    fname, fpath = backups[idx]
    remote_bck = fpath

    return download_and_extract(serial, remote_bck)


    def parse_adb_lines(text):
    """Parse ADB output into list of (filename, fullpath)."""
    results = []
    for line in text.splitlines():
    line = line.strip().replace("\r", "")
    if not line:
    continue
    path = Path(line)
    fname = path.name
    results.append((fname, line))
    # Newest first, matching `ls -1t`
    results.sort(key=lambda x: x[0], reverse=True)
    return results

    def manual_backup_path(prefill=""):
    if prefill:
    bck_file = prefill.strip().strip('"')
    else:
    bck_file = prompt(
    "Enter backup filename or full Android path "
    "e.g. 2026-11-19_12-57.novabackup"
    )
    if not bck_file:
    print("[ERROR] No backup filename provided.")
    input("Press Enter to exit...")
    sys.exit(1)

    remote_bck = bck_file
    if not remote_bck.startswith("/"):
    remote_bck = f"{ANDROID_BCK_DIR}/{remote_bck}"
    fname = Path(remote_bck).name
    return remote_bck


    def download_and_extract(serial, remote_bck):
    local_bck = WORK_DIR / Path(remote_bck).name
    local_zip = WORK_DIR / "backup.zip"
    extract_dir = WORK_DIR / "backup_extracted"

    print()
    print(f'Pulling "{remote_bck}" to "{local_bck}" ...')
    res = adb_pull(serial, remote_bck, local_bck)
    if res.returncode != 0:
    print("[ERROR] Failed to pull backup from Android.")
    input("Press Enter to exit...")
    sys.exit(1)

    if local_zip.exists():
    local_zip.unlink()

    # Rename pulled file to backup.zip
    shutil.move(str(local_bck), str(local_zip))

    if extract_dir.exists():
    shutil.rmtree(extract_dir)

    print(f"Extracting backup.zip to '{extract_dir}' ...")
    try:
    with zipfile.ZipFile(local_zip, "r") as zf:
    zf.extractall(extract_dir)
    except Exception as e:
    print(f"[ERROR] Failed to extract backup.zip: {e}")
    input("Press Enter to exit...")
    sys.exit(1)

    db_path = extract_dir / "nova.db"
    return db_path


    # ------------------------------------------------------------------------
    # Local source selection
    # ------------------------------------------------------------------------
    def use_local_source():
    print("--- Local Database Selection ---")
    print(f'Enter the path to nova.db or a .novabackup or .zip file.')
    print(f'Default: {WORK_DIR / "backup_extracted" / "nova.db"}')
    print()

    while True:
    user_db = prompt("Path to database or backup file [Enter for default]")
    if not user_db:
    db_path = WORK_DIR / "backup_extracted" / "nova.db"
    else:
    user_db = user_db.strip().strip('"')
    db_path = Path(user_db).resolve()

    if not db_path.exists():
    print(f"[ERROR] File not found: '{db_path}'")
    retry = prompt("Try again? [Y/n]", "y")
    if retry.lower().startswith("n"):
    sys.exit(1)
    continue

    ext = db_path.suffix.lower()
    if ext == ".novabackup":
    return extract_local_archive(db_path, restore_prompt=True)
    elif ext == ".zip":
    return extract_local_archive(db_path, restore_prompt=False)
    else:
    return db_path


    def extract_local_archive(archive_path, restore_prompt=False):
    extract_dir = WORK_DIR / "backup_extracted"
    if extract_dir.exists():
    shutil.rmtree(extract_dir)

    print(f'Extracting "{archive_path}" to "{extract_dir}" ...')
    try:
    with zipfile.ZipFile(archive_path, "r") as zf:
    zf.extractall(extract_dir)
    except Exception as e:
    print(f"[ERROR] Failed to extract archive: {e}")
    input("Press Enter to exit...")
    sys.exit(1)

    db_path = extract_dir / "nova.db"

    if restore_prompt and yes_no("Restore this backup in Nova on the connected device?"):
    restore_backup_to_device(db_path)

    return db_path


    def restore_backup_to_device(db_path):
    if not ADB_EXE.exists():
    print(f"[ERROR] adb.exe not found at '{ADB_EXE}'; cannot send backup to device.")
    input("Press Enter to exit...")
    sys.exit(1)

    devices = adb_devices()
    if not devices:
    print("[ERROR] No connected ADB device found; cannot restore the backup.")
    input("Press Enter to exit...")
    sys.exit(1)

    serial = devices[0]
    nova_backup_dir = "/storage/emulated/0/Android/data/com.teslacoilsw.launcher/files/Backup"

    print(f'Copying "{db_path}" to Nova backup folder on {serial} ...')
    adb_shell(serial, f"mkdir -p '{nova_backup_dir}'")
    res = adb_push(serial, db_path, nova_backup_dir + "/")
    if res.returncode != 0:
    print("[ERROR] Failed to copy the backup to the device.")
    input("Press Enter to exit...")
    sys.exit(1)

    print(f"Launching Nova Launcher settings on {serial} ...")
    run([
    str(ADB_EXE), "-s", serial, "shell",
    "am", "start",
    "-n",
    "com.teslacoilsw.launcher/com.teslacoilsw.launcher.preferences.SettingsActivity"
    ])
    print("In Nova, choose Backup & restore and restore the backup you copied.")


    # ------------------------------------------------------------------------
    # SQLite helpers (use Python sqlite3 module, fall back to CLI)
    # ------------------------------------------------------------------------
    def sqlite_query(db_path, sql, params=()):
    """Execute a SELECT query using Python sqlite3. Returns list of tuples."""
    try:
    conn = sqlite3.connect(str(db_path))
    cur = conn.execute(sql, params)
    rows = cur.fetchall()
    conn.close()
    return rows
    except sqlite3.Error as e:
    print(f"[ERROR] SQLite query failed: {e}")
    input("Press Enter to exit...")
    sys.exit(1)


    def sqlite_query_cli(db_path, sql, params=()):
    """Fallback: write SQL to temp file and run sqlite3 CLI."""
    sql_file = TEMP / "adbfolder_query.sql"
    sql_file.write_text(sql, encoding="utf-8")
    res = run([str(SQLITE_EXE), str(db_path)], input=sql, text=True)
    if res.returncode != 0:
    print(f"[ERROR] sqlite3 CLI failed: {res.stderr}")
    input("Press Enter to exit...")
    sys.exit(1)
    rows = []
    for line in res.stdout.strip().splitlines():
    rows.append(tuple(line.split("\t")))
    return rows


    # ------------------------------------------------------------------------
    # Target enumeration
    # ------------------------------------------------------------------------
    class Target:
    def __init__(self, num, label, where, order):
    self.num = num
    self.label = label
    self.where = where
    self.order = order


    def enumerate_targets(db_path):
    targets = []
    tgt_count = 0
    listed_folder_ids = set()

    # 1. Dock
    print("dock")
    tgt_count += 1
    targets.append(Target(tgt_count, "dock apps", "f.container = -101",
    "f.screen, f.cellY, f.cellX, f.rank, f._id"))
    print(f" [{tgt_count}] dock apps")

    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 AND container = -101 "
    "ORDER BY cellY, cellX, rank, _id")
    for fid, fname in rows:
    tgt_count += 1
    label = f"dock - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    listed_folder_ids.add(str(fid))
    print(f" [{tgt_count}] {fname}")

    # 2. Panes 0-14
    for pane in range(15):
    tgt_count = scan_pane(db_path, pane, targets, tgt_count, listed_folder_ids)

    # 3. Other folders (orphaned folders not under dock or a pane)
    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 "
    "ORDER BY LOWER(title), _id")
    other_has_folders = False
    for fid, fname in rows:
    if str(fid) in listed_folder_ids:
    continue
    if not other_has_folders:
    print("other")
    other_has_folders = True
    tgt_count += 1
    label = f"other - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    print(f" [{tgt_count}] {fname}")

    return targets, tgt_count


    def scan_pane(db_path, pane, targets, tgt_count, listed_folder_ids):
    rows = sqlite_query(db_path,
    "SELECT _id, COALESCE(NULLIF(TRIM(title), ''), '(Untitled Folder)') "
    "FROM favorites WHERE itemType = 2 AND container = -100 "
    "AND CAST(screen AS INTEGER) = ? "
    "ORDER BY cellY, cellX, rank, _id", (pane,))

    loose_cnt = sqlite_query(db_path,
    "SELECT COUNT(*) FROM favorites WHERE container = -100 "
    "AND CAST(screen AS INTEGER) = ? AND itemType <> 2", (pane,))[0][0]

    has_pane_folders = len(rows) > 0
    print_header = has_pane_folders or loose_cnt > 0

    if print_header:
    print(f"pane {pane}")

    for fid, fname in rows:
    tgt_count += 1
    label = f"pane {pane} - {fname}"
    targets.append(Target(tgt_count, label, f"f.container = {fid}",
    "f.rank, f._id"))
    listed_folder_ids.add(str(fid))
    print(f" [{tgt_count}] {fname}")

    if loose_cnt > 0:
    tgt_count += 1
    label = f"pane {pane} loose apps"
    where = (f"f.container = -100 AND CAST(f.screen AS INTEGER) = {pane} "
    f"AND f.itemType <> 2")
    order = "f.cellY, f.cellX, f.rank, f._id"
    targets.append(Target(tgt_count, label, where, order))
    print(f" [{tgt_count}] pane {pane} loose apps")

    return tgt_count

    # ------------------------------------------------------------------------
    # Sanitize label -> safe filename
    # ------------------------------------------------------------------------
    def sanitize_label(label):
    safe = re.sub(r'[\\/:*?"<>|() ]+', '_', label).strip('_')
    if not safe:
    safe = "nova_target"
    return safe


    # ------------------------------------------------------------------------
    # Run query and format output
    # ------------------------------------------------------------------------
    def run_query(db_path, target, work_dir):
    safe_name = sanitize_label(target.label)
    raw_out = work_dir / "output.txt"
    clean_out = work_dir / f"{safe_name}_apps.txt"
    log_out = work_dir / "adbfolder_log.txt"

    sql = f"""
    SELECT f._id AS item_id,
    f.title AS display_name,
    CASE
    WHEN f.iconPackage IS NOT NULL AND LENGTH(TRIM(f.iconPackage)) > 0
    THEN TRIM(f.iconPackage)
    WHEN INSTR(f.intent, 'component=') > 0 THEN
    CASE
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), '/') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), '/') - 1)
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), ';') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10), ';') - 1)
    ELSE SUBSTR(f.intent, INSTR(f.intent, 'component=') + 10)
    END
    WHEN INSTR(f.intent, 'package=') > 0 THEN
    CASE
    WHEN INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8), ';') > 0
    THEN SUBSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8),
    1, INSTR(SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8), ';') - 1)
    ELSE SUBSTR(f.intent, INSTR(f.intent, 'package=') + 8)
    END
    ELSE ''
    END AS package_name,
    f.intent
    FROM favorites f
    WHERE {target.where}
    ORDER BY {target.order};
    """

    print()
    print(f'Querying "{target.label}" ...')

    try:
    rows = sqlite_query(db_path, sql)
    except SystemExit:
    rows = sqlite_query_cli(db_path, sql)

    # Write raw tab-delimited output (all columns)
    with open(raw_out, "w", encoding="utf-8") as f:
    f.write("item_id\tdisplay_name\tpackage_name\tintent\n")
    for row in rows:
    f.write("\t".join(str(c) if c is not None else "" for c in row) + "\n")

    # Format only package_name and display_name, in that order
    display_rows = [(row[2], row[1]) for row in rows] # (package_name, display_name)

    table_text = ""
    if display_rows:
    table_text = tabulate(
    display_rows,
    headers=["package_name", "display_name"],
    tablefmt="plain"
    )

    indented = [" " + line for line in table_text.splitlines()]

    # Header matching batch format
    if target.label.startswith("pane ") and " - " in target.label:
    parts = target.label.split(" - ", 1)
    pane_num = parts[0].replace("pane ", "").strip()
    folder_name = parts[1]
    header = f' pane {pane_num} folder "{folder_name}"'
    else:
    header = f" {target.label}"

    clean_text = header + "\n" + "\n".join(indented) + "\n"

    # Write clean output
    clean_out.write_text(clean_text, encoding="utf-8")

    # Append to running log
    timestamp = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    entry = (
    "\n============================================================\n"
    f"Export: {timestamp}\n"
    f"{clean_text}"
    )
    with open(log_out, "a", encoding="utf-8") as f:
    f.write(entry)

    print()
    print(f"--- Result ({clean_out}) ---")
    print()
    print(clean_text)
    print(f"Raw tab-delimited output saved to: {raw_out}")
    print(f"Formatted app list saved to: {clean_out}")
    print(f"Running export log saved to: {log_out}")
    print()

    return clean_out

    # ------------------------------------------------------------------------
    # Optional: check missing third-party packages
    # ------------------------------------------------------------------------

    def check_missing_3p(serial, db_path, work_dir):
    print()
    if not yes_no("Check user apps -3 with no icon in Nova before quitting?"):
    return

    if not ADB_EXE.exists():
    print(f"[INFO] adb.exe not found at '{ADB_EXE}'; skipping device package check.")
    return

    devices = adb_devices()
    if not devices:
    print("[INFO] No connected ADB device found; skipping device package check.")
    return

    target_serial = devices[0]
    debug(f"RUN_ADB_TARGET={target_serial}")

    if not db_path or not db_path.exists():
    print("[INFO] Nova database not available; skipping device package check.")
    return

    resolve_labels = yes_no(
    "Resolve app titles via adb/aapt slower over Wi-Fi?",
    default="n"
    )
    do_resolve = resolve_labels

    pm_3p_file = TEMP / "adbfolder_pm3.txt"
    nova_pkgs_file = TEMP / "adbfolder_nova_pkgs.txt"
    unplaced_out = work_dir / "unplaced_user_apps.txt"

    print(f"Querying third-party packages from device {target_serial} ...")
    res = adb_shell(target_serial, "pm list packages -3 2>/dev/null")
    pm_3p_file.write_text(res.stdout, encoding="utf-8")

    installed3 = set()
    for line in pm_3p_file.read_text(encoding="utf-8").splitlines():
    p = line.replace("\r", "").strip()
    if p.startswith("package:"):
    p = p[8:].strip()
    if p:
    installed3.add(p)

    print("Querying packages referenced anywhere in nova.db ...")
    rows = sqlite_query(db_path,
    "SELECT DISTINCT package_name FROM ("
    " SELECT CASE"
    " WHEN iconPackage IS NOT NULL AND LENGTH(TRIM(iconPackage)) > 0"
    " THEN TRIM(iconPackage)"
    " WHEN INSTR(intent, 'component=') > 0 THEN"
    " CASE"
    " WHEN INSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10), '/') > 0"
    " THEN SUBSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10),"
    " 1, INSTR(SUBSTR(intent, INSTR(intent, 'component=') + 10), '/') - 1)"
    " ELSE SUBSTR(intent, INSTR(intent, 'component=') + 10)"
    " END"
    " ELSE ''"
    " END AS package_name"
    " FROM favorites"
    ")"
    "WHERE LENGTH(package_name) > 0")

    in_nova = set()
    for (pkg,) in rows:
    if pkg:
    in_nova.add(pkg)

    missing = sorted(installed3 - in_nova, key=str.lower)

    results = []
    for i, pkg in enumerate(missing, 1):
    label = ""

    if do_resolve:
    if i % 10 == 1 or i == len(missing):
    print(f"Resolving titles: {i}/{len(missing)} ({pkg})...")

    dump = adb_shell(
    target_serial,
    f"dumpsys package {pkg} 2>/dev/null"
    )

    for dl in dump.stdout.splitlines():
    m = re.search(r'nonLocalizedLabel="([^"]+)"', dl)
    if m:
    label = m.group(1).strip()

    if not label:
    # Try aapt path
    # apk_path = shutil.which("aapt") or shutil.which("aapt2")
    apk_path = which("aapt") or which("aapt2")

    if apk_path:
    path_res = adb_shell(
    target_serial,
    f"pm path {pkg} 2>/dev/null"
    )

    for pl in path_res.stdout.splitlines():
    pl = pl.strip()

    if pl.startswith("package:"):
    apk_remote = pl[8:].strip()
    apk_local = TEMP / "adbfolder_probe.apk"

    pull_res = adb_pull(
    target_serial,
    apk_remote,
    apk_local
    )

    if pull_res.returncode == 0 and apk_local.exists():
    badging = run([
    apk_path,
    "dump",
    "badging",
    str(apk_local)
    ])

    if badging.stdout:
    for bl in badging.stdout.splitlines():
    m = re.match(
    r"^application-label:'([^']+)'",
    bl
    )
    if m:
    label = m.group(1).strip()
    break

    if badging.returncode != 0:
    debug(
    f"AAPT failed for {pkg}: {badging.stderr}"
    )

    try:
    apk_local.unlink()
    except Exception:
    pass

    break

    results.append((pkg, label))

    # Write output
    lines = []
    if results:
    lines.append(
    tabulate(
    results,
    headers=["package_name", "app_title"],
    tablefmt="plain"
    ).splitlines()
    )

    flat = []
    for group in lines:
    flat.extend(group)

    table_text = "\n".join(flat) + ("\n" if flat else "")
    unplaced_out.write_text(table_text, encoding="utf-8")

    print()
    print(
    f"User packages (-3): {len(installed3)} | "
    f"In Nova layout: {len(in_nova)} | "
    f"No icon in Nova: {len(missing)}"
    )

    if results:
    print()
    print(table_text.rstrip())

    print(f"Saved unplaced user app list to: {unplaced_out}")
    print()

    # Cleanup temp files unless debug
    if not DEBUG:
    for f in [pm_3p_file, nova_pkgs_file]:
    try:
    f.unlink()
    except Exception:
    pass
    # ------------------------------------------------------------------------
    # Main
    # ------------------------------------------------------------------------
    def main():
    global DEBUG
    # Allow env override
    if os.environ.get("ADBFOLDER_DEBUG", "0") == "1":
    DEBUG = True

    check_dependencies()

    print("Select source for Nova Launcher database:")
    print("[1] Pull .novabackup from Android via ADB and extract nova.db [Default]")
    print("[2] Use an existing nova.db or .novabackup or .zip already on Windows")
    print()

    src_choice = prompt("Enter choice [1 or 2]", "1")

    if src_choice == "2":
    db_path = use_local_source()
    else:
    db_path = pull_from_android()

    if not db_path or not db_path.exists():
    print(f"[ERROR] nova.db not found at: '{db_path}'")
    input("Press Enter to exit...")
    sys.exit(1)

    print()
    print(f"Using database: {db_path}")
    print("Scanning Nova Launcher dock, panes and folders ...")
    print()

    targets, tgt_count = enumerate_targets(db_path)

    print()
    pick = prompt(f"Select number [1-{tgt_count}, q to quit]")
    if pick.lower() == "q" or pick == "0":
    check_missing_3p(None, db_path, WORK_DIR)
    print("Bye.")
    return

    try:
    idx = int(pick) - 1
    if not (0 <= idx < tgt_count):
    raise ValueError
    except ValueError:
    print(f"[ERROR] Invalid selection: '{pick}'")
    input("Press Enter to exit...")
    sys.exit(1)

    target = targets[idx]

    debug(f"SELECTED_LABEL={target.label}")
    debug(f"SQL_WHERE={target.where}")
    debug(f"SQL_ORDER={target.order}")

    run_query(db_path, target, WORK_DIR)

    while True:
    loop_more = yes_no("Export another folder or pane?", default="n")
    if not loop_more:
    break
    # Re-enumerate (in case something changed) and pick again
    targets, tgt_count = enumerate_targets(db_path)
    print()
    pick = prompt(f"Select number [1-{tgt_count}, q to quit]")
    if pick.lower() == "q" or pick == "0":
    break
    try:
    idx = int(pick) - 1
    if not (0 <= idx < tgt_count):
    raise ValueError
    except ValueError:
    print(f"[ERROR] Invalid selection: '{pick}'")
    break
    target = targets[idx]
    run_query(db_path, target, WORK_DIR)

    check_missing_3p(None, db_path, WORK_DIR)
    input("Press Enter to exit...")


    if __name__ == "__main__":
    main()

    # ----------------------------------------------------------------------
    # end of adbfolder.py
    # ----------------------------------------------------------------------
    # ----------------------------------------------------------------------
    # Step by step description of what this script does
    # ----------------------------------------------------------------------
    # 1. Environment & Configuration Setup
    # A. Command environment
    # a. Initializes Python execution environment
    # b. Imports required Python modules and dependencies
    # B. Configuration variables
    # a. Sets default configuration paths for ADB, SQLite
    # and work directories
    # b. Defines the DEBUG toggle flag
    # c. Defines temporary and Android backup directories
    #
    # 2. Dependency Verification
    # A. Executable checks
    # a. Locates adb.exe and checks system PATH
    # or configured fallback path
    # b. Locates sqlite3.exe and exits with an error if missing
    # B. Directory setup
    # a. Creates the Nova work directory if it does not exist
    #
    # 3. Source Selection Menu
    # A. Choice [1]: Pull from Android via ADB
    # a. Detects connected ADB device target
    # b. Optionally launches Nova Launcher settings to create a backup
    # c. Lists .novabackup files in the remote backup directory
    # with fallback search of Android storage
    # d. Prompts user to select or enter a backup filename/path
    # e. Pulls the selected .novabackup file to the Windows workspace
    # f. Renames the pulled file to backup.zip and extracts it
    # into backup_extracted to retrieve nova.db
    # B. Choice [2]: Use Local Database / Archive
    # a. Prompts user for a custom path to nova.db, .novabackup or .zip
    # with a retry loop
    # b. Validates file existence
    # c. Automatically extracts archives when necessary
    # d. Optionally offers to restore a .novabackup database
    # to the device
    #
    # 4. Database Verification & Target Enumeration
    # A. Database validation
    # a. Verifies that nova.db exists at the target path
    # B. Section 1 [Dock]
    # a. Scans dock apps [container = -101]
    # b. Scans and lists any dock folders
    # C. Section 2 [Panes 0-14]
    # a. Iterates through home screen panes 0 to 14
    # via the scan_pane function
    # b. Queries pane folders [itemType = 2, container = -100]
    # c. Checks for loose non-folder apps [itemType <> 2] on each pane
    # D. Section 3 [Other Folders]
    # a. Searches for orphaned folders not categorized under dock
    # or panes
    # b. Lists and registers remaining folders
    #
    # 5. User Selection & Query Execution [run_query]
    # A. Selection & Sanity
    # a. Prompts user to select a target number or quit [q or 0]
    # b. Sanitizes the selected label to generate a safe filename
    # B. Query Generation & Execution
    # a. Builds a dynamic SQLite query extracting:
    # - Item ID
    # - Display name
    # - Package name
    # - Raw intent
    # b. Executes the query against nova.db using Python sqlite3
    # c. Falls back to the sqlite3 command-line executable if necessary
    # C. Output & Formatting
    # a. Writes raw tab-delimited results to output.txt
    # b. Formats output columns [package_name, display_name]
    # into an aligned table via tabulate
    # c. Adds a descriptive pane/folder heading and indents the table
    # by two spaces for easier reading and future concatenation
    # d. Saves formatted results to [target]_apps.txt
    # e. Appends each formatted export with a timestamp to
    # adbfolder_log.txt without overwriting previous exports
    # f. Displays the formatted results and output file locations
    # D. Repeat Export
    # a. Prompts user to export another folder or pane
    # b. Re-enumerates targets in case the database layout has changed
    # c. Repeats the selection and export process as requested
    #
    # 6. Optional Unplaced Third-Party Package Check [check_missing_3p]
    # A. Pre-check Validation
    # a. Prompts user whether to check for user-installed packages
    # [-3] missing from the Nova layout
    # b. Verifies ADB device connectivity and database availability
    # c. Optionally prompts to resolve app titles via adb/aapt
    # B. Data Collection
    # a. Queries installed third-party packages from device
    # [adb shell pm list packages -3]
    # b. Queries all referenced packages inside nova.db
    # c. Compares installed packages against packages referenced in Nova
    # C. Optional App Title Resolution
    # a. Runs adb shell dumpsys package for each unplaced package
    # b. Searches for nonLocalizedLabel in the package information
    # c. If unavailable, uses adb shell pm path to locate the APK
    # d. Pulls the APK to the PC and uses aapt/aapt2 to read its label
    # D. Diff Analysis & Output
    # a. Identifies installed third-party packages with no Nova icon
    # b. Generates a formatted package_name / app_title table
    # c. Saves results to unplaced_user_apps.txt
    # d. Displays package counts and the resulting unplaced app list
    # E. Cleanup
    # a. Removes temporary package-list files unless DEBUG=1
    # b. Exits cleanly
    # -------------------------------------------------------------------
    # -------------------------------------------------------------------
    --
    Usenet allows purposefully helpful people to pool their experiences.
    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Chris@ithinkiam@gmail.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sun Nov 22 14:17:54 2026
    From Newsgroup: misc.phone.mobile.iphone

    Maria Sophia <mariasophia@comprehension.com> wrote:
    Maria Sophia wrote:
    For the record, here is the python script I wrote today based on the
    Windows batch script I had written yesterday that is an example of
    what we'd like to accomplish with iOS over Wi-Fi/USB to any common desktop.

    Actually, that was the batch script. This is the X-platform python script.

    It demonstrably isn't x-platform. You've specified paths which assume
    Windows and only work on your own idiosyncratic system setup.

    And *yet again * you've posted useless python code that is guaranteed to
    fail. Why will you never learn?

    I tested them side by side (found some bugs) and now they work the same.

    #!/usr/bin/env python3
    # -------------------------------------------------------------------------
    # adbfolder.py
    # Usage: python adbfolder.py

    By setting the environment above this usage is superfluous. You can run the script directly.


    --- Synchronet 3.22a-Linux NewsLink 1.2
  • From Maria Sophia@mariasophia@comprehension.com to misc.phone.mobile.iphone,comp.sys.mac.apps,comp.sys.mac.advocacy on Sun Nov 22 15:16:27 2026
    From Newsgroup: misc.phone.mobile.iphone

    Chris wrote:
    Maria Sophia <mariasophia@comprehension.com> wrote:
    Maria Sophia wrote:
    For the record, here is the python script I wrote today based on the
    Windows batch script I had written yesterday that is an example of
    what we'd like to accomplish with iOS over Wi-Fi/USB to any common desktop. >>
    Actually, that was the batch script. This is the X-platform python script.

    It demonstrably isn't x-platform. You've specified paths which assume
    Windows and only work on your own idiosyncratic system setup.

    And *yet again * you've posted useless python code that is guaranteed to fail. Why will you never learn?

    I tested them side by side (found some bugs) and now they work the same.

    #!/usr/bin/env python3
    # -------------------------------------------------------------------------
    # adbfolder.py
    # Usage: python adbfolder.py

    By setting the environment above this usage is superfluous. You can run the script directly.

    Hi Chris,

    Thanks for your useful input, as I'm taking all the suggestions into consideration, as you can see I already included some of Lawrence's
    suggestions (some of which were the same as yours, in fact).

    I've been testing software and writing code on Usenet for decades.
    However, I have NOT been using Python for more than, oh, a year or so.

    I wrote it in batch first, so it was posted first to the Windows 10 ng.
    But then I ported it to allow those on other platforms to benefit.

    That's a lot of work for something that is already working, and for which nobody is paying me to do for them.

    One thing I try to do more than most people do it seems, is SHARE the
    actual work rather than simply discuss what somebody else ought to do.

    I have both iOS and Android devices, but I don't have macOS or Linux
    machines. Consequently, I can develop and test the Windows implementation,
    but I cannot personally verify the macOS/Linux implementations.

    However, there's a distinction in effort:value you may be overlooking.

    I wrote it in my "native" language of Windows batch, and the code worked.
    So I didn't need to port it to Python so that others could benefit.

    Keep that in mind.
    I already had working Windows batch code.

    I did the Python port for people like you.
    Because the Python code itself is largely platform-independent.

    I'm using Python's built-in sqlite3, pathlib, zipfile, subprocess and other standard modules. The database queries, enumeration logic, comparisons,
    archive handling and output generation aren't inherently Windows-specific.

    Yes, I've specified some Windows-specific executable and working-directory paths. Those need to be adjusted for other environments. That's
    configuration, not a wholesale rewrite of the program. And I've already included PATH-based executable discovery using shutil.which (which Lawrence
    had kindly suggested), so the groundwork for accommodating different installations is there in the latest revision (thanks to Lawrence!).

    What matters is the thought and energy put into the algorithms, Chris.

    My thinking is that it's considerably easier for a macOS or Linux user to
    take an existing working implementation, adjust the environment-specific
    paths and test it, than to start from scratch and independently recreate
    all the functionality.

    All the real effort is in the algorithm. Not the formatting.

    I can't disagree Usenet isn't exactly an ideal medium for distributing
    source code which is why I opened the XDA Developer's thread.

    On Usenet, line wrapping, quoting and newsreader formatting can sometimes damage the presentation of posted code. I understand that someone might
    have to unwrap lines, restore indentation or make minor formatting
    corrections before running it.

    But let's put that 'effort' in perspective.

    Correcting wrapped lines and adjusting indentation is trivial compared with writing the underlying program. We're talking about an enormous difference
    in effort. The hard part is developing the logic, figuring out the database structure, writing the SQL, handling the ADB communication, designing the enumeration and comparison routines, and making all the pieces work
    together.

    Then porting it.

    In other words, even if someone has to spend a little time cleaning up the code, they're starting with the benefit of all that algorithmic work
    already having been done, and proven to be working.

    All they need to do is tweak the paths.

    Bear in mind I never claimed to have tested it on operating systems I don't own. I said it should work on macOS/Linux, and I made the code available so that others could try it, identify the necessary adjustments and improve
    it.

    That's the point of sharing code on Usenet.

    If you see something specifically that will fail on macOS or Linux beyond
    the obvious Windows-specific configuration, by all means identify it.
    That's constructive technical criticism, and I'd welcome it.

    But saying the entire contribution is useless because a few paths need changing, or because posted source code might need some formatting cleanup, seems rather disproportionate to the amount of work already done.

    I'd rather share a working starting point and invite improvements than
    withhold the code until I can personally test every possible environment.

    That's what contributing to a technical community means to me.
    --- Synchronet 3.22a-Linux NewsLink 1.2