How to add a custom attribute to an existing .kml file

Question

I have a proof-of-concept I'm trying to put together but am flailing a bit. Here's what I want to achieve: * Input tool: reading an existing .kml file * Formula tool: add attribute * Formula tool: set color to green * Output tool: save as .kml I've created a .kml file with the following schema: TestLocations ABC123 123 MAIN AVE ABC123 123 MAIN AVE NEW YORK NY 45.4133 -74.0794 -74.0794,45.4133,0 I recognize there needs to be a green attribute added after the . Before I get to this step, I've tried to read the file using a .csv format but get an error saying there are too many fields. So here's where I'm flailing. How do I read it, edit it, then save it? My end goal is a .kml file which will be used in ESRI's ArcExplorer. For reference, this is a sample Google .kml file: The Great Sphinx of Egypt The Great Sphinx of Egypt 31.1376421035748 29.97531730109229 197.0202883013975 27.35354524205621 -140.3945943869927 #WhateverYouWantHere root://styleMaps#default+nicon=0x307+hicon=0x317 31.13764210357481,29.97531730109229,0 Thanks for the input in advance! Todd

patrick_digan · Accepted Answer

Hi @TR! I would try several things (in no particular order):

1) For the delimiters, use \0 (\0 means no delimiters)

2) For the field length, use a really big number (In case things are getting truncated)

3) Check the treat errors as warnings box (to at least try to read in as much as possible and allow debugging if there are still issues)

Once you get the data in, you could use a formula tool to add in the color attribute. For your output, you would use the same setup as the input. I'd be happy to help more, but I think you're on the right track!

Patrick Digan