therock003
Board Regular
- Joined
- Jan 9, 2008
- Messages
- 183
Plist is a kind of an xml format used by apple to store information inside its database. I tried importing the file as an .xml data source but it wont budge. I'm looking for a way to interpret the data so i can get them inside excel into a table format.
Its format is the following:
It starts twith the following header (which is irrelevant)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
and then the data come as entries
So this was one entry. Then inside another <dict></dict> comes the second entry
As you can in its entry theres <key> which should be the tables column name and <string> or <integer> where its value
So can some please help me into offering some kind of way that i can get my data into excel having such a file?
Its format is the following:
It starts twith the following header (which is irrelevant)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
and then the data come as entries
XML:
<dict>
<key>1.2</key>
<dict>
<key>BKBookmark</key>
<array>
<dict>
<key>annotationAssetID</key>
<string>21B8B42286D791898D90F97E6C9AF669</string>
<key>annotationCreationDate</key>
<integer>1374477130</integer>
<key>annotationCreatorIdentifier</key>
<string>com~apple~iBooks</string>
<key>annotationDeleted</key>
<integer>0</integer>
<key>annotationIsUnderline</key>
<integer>0</integer>
<key>annotationLocation</key>
<string>epubcfi(/6/16[id124]!/4/52/10/1)</string>
<key>annotationModificationDate</key>
<integer>1374477132</integer>
<key>annotationStyle</key>
<integer>3</integer>
<key>annotationType</key>
<integer>1</integer>
<key>annotationUuid</key>
<string>D7809B1F-21F7-4C8A-AE58-7C0C9EEAEC69</string>
<key>futureProofing5</key>
<string>2. The Revoker</string>
<key>futureProofing6</key>
<string>396169932.000000</string>
<key>plAbsolutePhysicalLocation</key>
<integer>0</integer>
<key>plLocationRangeEnd</key>
<integer>0</integer>
<key>plLocationRangeStart</key>
<integer>7</integer>
<key>plUserData</key>
</dict>
So this was one entry. Then inside another <dict></dict> comes the second entry
As you can in its entry theres <key> which should be the tables column name and <string> or <integer> where its value
So can some please help me into offering some kind of way that i can get my data into excel having such a file?