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

Get details about your iOS apps in a .csv file iOS devices
Since iTunes does not give you a lot of information via print or export of your apps, I wrote a little shell script to retrieve information from the app files themselves.

The script creates and opens a .csv file. To correctly display the columns, choose 'semicolons' as the column delimiter in your csv viewer (e.g. OpenOffice Calc).

You can choose what information to retrieve by commenting/uncommenting them in the Attributes definition at the beginning of the script.

To run the script do the following: [crarko adds: Note that the path to the Mobile Applications folder may be different depending on your previous upgrade path(s), for example mine was located at ~/Music/iTunes/iTunes Music/Mobile Applications. Just be sure to put the script in the same folder as the app (.ipa) files.]
  • Save it as getproperties.sh in your Mobile Applications Folder at ~/Music/iTunes/Mobile Applications.
  • Open that folder in Terminal and run chmod u+x getproperties.sh.
  • Run the script via the command ./getproperties.sh.
Since there have been issues with copy/paste, download the script from here

[crarko adds: I tested this, and it works as described. It can take a while to run if you have a lot of apps. The script source is mirrored here.]
    •    
  • Currently 2.38 / 5
  You rated: 3 / 5 (13 votes cast)
 
[5,242 views]  

Get details about your iOS apps in a .csv file | 7 comments | Create New Account
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 | # ]
Get details about your iOS apps in a .csv file
Authored by: loren_ryter on Sep 01, '10 11:05:33PM

Looks as if this site needs to work on its code formatting. For a site like this, posting code should not be a problem, I would expect.

In the meantime, anyone who has a working version of this script could post a link to a zipped file. Or to a site like pastebin.com that should format code text properly.



[ Reply to This | # ]
Get details about your iOS apps in a .csv file
Authored by: crarko on Sep 02, '10 04:25:26AM

There's a link to the zipped source file, so I have pulled the inline code block here because of the copy/paste problems, and you can go ahead and download the script.



[ Reply to This | # ]
Get details about your iOS apps in a .csv file
Authored by: loren_ryter on Sep 02, '10 07:03:54AM

Thanks for the file download. At first I thought it didn't work but I failed to read the directions about where it has to be located. Moved it and now it ran just fine. But I didn't get any results, just the headers:

Filename;itemName;appleId;kind;purchaseDate;releaseDate;

I got a lot of messages like this:

Yelp 4.4.0.ipa.info.plist does not exist
tar: This does not look like a tar archive
tar: Skipping to next header
tar: iTunesMetadata.plist: Not found in archive
tar: Error exit delayed from previous errors

Edited on Sep 02, '10 07:10:19AM by loren_ryter



[ Reply to This | # ]
Get details about your iOS apps in a .csv file
Authored by: crarko on Sep 02, '10 07:52:50AM

I just downloaded the script and re-verified it.

What I get when I run it is shell feedback that looks like this:

...
LinkedIn 3.2.ipa.info.plist exists
x iTunesMetadata.plist
...

for each app in the Mobile Applications folder. When it's done it launches OpenOffice and displays the AppInfo.csv file with the metadata in rows by app.

Be sure the script is in the Mobile Applications folder, and that you run it from there. If you don't have OpenOffice you should be able to read this in Excel, Numbers, FileMaker or even AppleWorks. Anything that can handle a delimited text file properly.



[ Reply to This | # ]