- This topic has 7 replies, 4 voices, and was last updated 10 years, 7 months ago by
.
-
Posts
-
I see that v1.4 has the ability to do this, but the online help files say nothing about how to create the CSV file. Am I missing something?
What info do we need to provide? In the CSV, what order do we use for the info? What formats can we use for the latitude/longitude info? Etc. etc.
Thanks!
Any advice from experienced users would also be appreciated.
Your right, we have been lagging at publishing such information. You can try the CSV Export function for an example of our CSV format.
Basically the first row of the file is a header line describing the columns/fields. They are matched by name and so should appear exactly as in the Export, however they may be in any order, and most are optional. The only required field is one called “Location” which accepts any common coordinate string (See the Coordinates section of our Help Manual for specific coordinate formats and examples). Alternately, you can provide 2 fields “Lat” & “Long” instead of the one “Location” field for giving separated latlon coordinates.All other fields are technically optional and may be omitted: “Name”, “Notes”, “Icon”, “Color”, “Address”. “Name” and “Notes” should be pretty obvious. “Address” is the street address. If not provided the address will be reverse-geocoded by PocketEarth automatically next time you are online. “Color” should be a 6 letter HTML color code (such as FF0000 for red) and “Icon” is an identifier for the pin icon. Available values for the “Icon” field are: marker-pin, marker-pin-small, marker-pin-flag, marker-pin-home, marker-pin-contact, marker-pin-camera, marker-pin-sleep, marker-pin-food, marker-pin-footprint, marker-pin-star. These can be omitted and the usual pin defaults will be used.PocketEarth supports standard ASCII and UTF-8 encoded, “comma delimited, quote padded” CSV files. Some versions of Excel have a problem with this format when used with international accented letters in it. We recommend using one of the latest versions of Excel, or better yet OpenOffice, or a simpler CSV or Text editor.Be careful when importing data. If you import a CSV file twice, you will have duplicates of the items in My Pins! Similarly if you do a CSV Export, then Import it again, you will find all of your pins have been duplicated and could be annoying to delete all of the duplicates. Our next update PocketEarth v1.5 will have the option to import a file into its own group directly, so it can be more easily managed, and easily deleted if imported twice.Wow! Wow, wow wow! Incredible.
One other question, please? Is there a limit to the amount of text we can put in the Notes?
There is no limit on the length of the notes field, and it may include phone numbers and website URLs (starting with http:// for example) which become clickable links within PocketEarth. The notes text is treated as “plain text”, and thus should not contain html nor any other rich formatting or images.
Notes appear in PocketEarth only on the Pin Detail screen in the scrolling Notes text area. The search field on the My Pins list searches in the notes field too, even though the notes do not appear directly in this view.Is there any changes or new fields for import format in current release, description above is for older version
The supported CSV format described above hasn’t changed since v1.4. We will try to keep you “posted” when / if format changes happen.
How/where do I put a csv file in order to import it? Under Import, Choose File, I only see an archive file.
The files listed in Import are files that are put there either by PocketEarth during an Export, or put there by iTunes.
You can use iTunes to put the CSV file there (choose the device > Apps > File Sharing > Pocket Earth).The other way to import files is to email them to yourself as an attachment and then tap on the attachment on your device (it will give option to Open in Pocket Earth), or to put it in Dropbox, and tap on it in the Dropbox App on your device.
- You must be logged in to reply to this topic.