Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Get details about your iOS apps in a .csv file' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Get details about your iOS apps in a .csv file
Authored by: PolarDan on Sep 01, '10 06:26:03PM

Didn't work for me.

I tried the script, it took about 10 minutes to run, then opened a blank spreadsheet.

All my apps showed up in the Terminal like this:

Twitterrific.ipa.info.plist exists
x iTunesMetadata.plist

and the last line in the terminal before it quit was "sed: first RE may not be empty"



[ Reply to This | # ]
Get details about your iOS apps in a .csv file
Authored by: gabester on Sep 01, '10 08:34:13PM

I had the same problem. RE is Regular Expression... I'm no shell scripting expert, but I'm guessing something got munged in formatting this hint.

I found changing code from this:


#replace " ; "
perl -pi -e 's/ ; /;/g' AppInfos.txt

more -f AppInfos.txt | sed -e 's// /g' | sed -e 's/<\/string>/ /g' | 
                       sed -e 's// /g' | sed -e 's/<\/date>/ /g' | 
                       sed -e 's// /g' | sed -e 's/<\/string>/ /g' | 
                       sed -e 's// /g' | sed -e 's/<\/date>/ /g' | 
                       sed -e 's// /g' | sed -e 's/<\/key>/ /g'
    > AppInfos.csv
rm AppInfos.txt

with this:


#replace " ; "
perl -pi -e 's/;/,/g' AppInfos.txt

more -f AppInfos.txt | sed -e 's/<string>/ /g' | sed -e 's/<date>/ /g' | 
                       sed -e 's/<key>/ /g' | sed -e 's/<\/string>/ /g' | 
                       sed -e 's/<\/date>/ /g' | sed -e 's/<\/key>/ /g' 
    > AppInfos.csv

#rm AppInfos.txt
#commented out rm command to assist with troubleshooting.

...seems to make it work well enough. However, be aware that uncommenting or modifying other attributes will require changing the more | sed command line to filter out the tags. It almost might be easier to format the resulting document into xml than csv.

Unfortunately, what I am most in need of is a way to capture the MAC addresses of iDevices connected to a computer (and possibly not a Mac, so it's out of the question to use the iPhone Configuration Utility.)
g=

Edited on Sep 01, '10 08:46:43PM by gabester


[ Reply to This | # ]
formatting...
Authored by: gabester on Sep 01, '10 08:54:19PM

I don't want to edit my last comment for fear of munging the formatting yet again... but the lines that begin more -f should continue as one line through to > AppInfos.csv as one continuous line.

while I didn't read crarko's instructions this script ran just fine from my home folder... and it seemed to get the expected results - once I got the more/sed commands and semicolon properly replaced.

Also, the devices connected to your Mac (and probably a similar file on the PC) are stored in ~/Library/Preferences/com.apple.iPod.plist with useful keys like Serial Number, Device Class, et cetera. Unfortunately, MAC address is not one of them - and this would be useful for tracking devices connected to a network after they have initially been configured on a particular computer.
g=

Edited on Sep 01, '10 08:56:39PM by gabester



[ Reply to This | # ]