Village Thing wrote:
Are there any documents that show how the CSV file is made up? I imported mine into a spreadsheet and have 14,500 lines of gibberish!
Do you have any comments on the other two issues that I mentioned please? Namely not being able to delete categories and categories not putting themselves in into correct alphabetical order.
Export the overlay as a CSV and then open in spreadsheet software.
You should see something like:
WP04, 53.88739722, -1.121425, 19, Acaster Malbis (eY/vN), , ,0, 0, Acaster Malbis, 1, 0, BHQs, 1
WP04, 51.82362321, -1.515346159, 19, Akeman Street (eU/vN), , ,0, 0, Akeman Street, 1, 0, BHQs, 1
That is two rows from a file I use.
14 columns, where we have: WP04,Lat,Lon,Symbol,Name,Comment,File,Radius,Display,Unique,Visible,Locked,Category,Circle
'comment' and 'file' are not required (empty in the example above). 'unique' may also be left blank.
'category' in the example above is the same for both entries. As you plan to use different categories within the file I'd suggest grouping all entries for the category together. When using large files I've had problems importing a csv that had quite a few categories and the entries mixed. Put your categories in the order you want them to appear (alphabetical or otherwise).
When you've got the csv as you want it, delete all overlays from MM and then import your new csv - with luck (a pre-requisite with MM for years now) all will be as you wanted/expect.