Latest Contributions by HåvardMoe

You should be able to set a precondition in the model that certain parts of it should run before the rest. Have a look at e.g. A quick tour of using preconditions from ArcGIS help. Alternatively, if you want to try python export your model to a script (in MB: Model -> Export -> To Python Script) and make sure the commands are execuded in the correct order. ... View more

I'm glad our data could be of any assistance. Also many thanks for explaining the cause. It is also good to know what the problem was, and as a temporary fix we can do a check on null values before uploading data. That would be easy enough in a script. ... View more

Thanks for looking into it, Mike. As I understand, the issue is with AGOL loading the data?  Is it possible at this point to say what kind of data may trigger this kind of behaviour? I'm planning on a series of related data for publishing to our organization in January and may have to do a "laundry script" on the data to get them through... ... View more

Sure - anything to find out what this is... I attach two zips: One with the full table that isn't working properly (I get a few hundred features) and the other with the edited version that is working... ... View more

I'll try explainig a bit further: Are you publishing directly from ArcMap? What version of ArcMap? I've been publishing directly from Arcmap 10.1 (standard), sharing as a feature access service with upload to My Hosted Services at AGOL. Did you analyze your map before publishing and resolve any problems? When analyzing I get a three warnings, no errors: - Layer's source is z-aware and no default z-value is defined - Layer's source is m-aware - Map is being published with data copied to the server using data frame full extent The first two should only be an issue if I'm editing - which I'm not planning to allow anyway - and the last one is exactly what I want to do. Do you see any error messages in ArcMap, you may need to look at the GP tool results. I don't see any error messages. The GP results show successful exectution of the Stage Service and the Upload Service Definition operations... Have you tried creating a local SD file, then uploading it directly to your My Content, then publishing? Not before, but tried today with the same result. That said, I have (sort of) managed to get it to work: The dataset has a lot of table fields with attribute data (54), and not all of them are needed for what I am doing now. I deleted some of the fields (to 24), and all of a sudden it works! I can't see any pattern as to why some features are copied from the source data and others not, and more important: There are no warnings or message that some of the data haven't been copied. The only reason I noticed was because so much was missing... ... View more

The error messag eshould tell you which line of the code it crashes on - that should give you a hint to where the culprit character comes into the picture. ... View more

Well, I can try... The arcmap tool snippet code looks like this: arcpy.Merge_management("C:/work/database1.gdb/ADLB;C:/work/database1.gdb/ALGB;C:/work/database1.gdb/ALLB;C:/work/database1.gdb/ALNB;C:/work/database1.gdb/ASRB;C:/work/database1.gdb/BRAB;C:/work/database1.gdb/BREB;C:/work/database1.gdb/BRGB;C:/work/database1.gdb/DOVB;C:/work/database1.gdb/DRMB;C:/work/database1.gdb/FILB;C:/work/database1.gdb/FLEB;C:/work/database1.gdb/FLMB;C:/work/database1.gdb/GARB;C:/work/database1.gdb/GJKB;C:/work/database1.gdb/HARB;C:/work/database1.gdb/HVDB;C:/work/database1.gdb/KRAB;C:/work/database1.gdb/KVGB;C:/work/database1.gdb/MERB;C:/work/database1.gdb/MIDB;C:/work/database1.gdb/MINB;C:/work/database1.gdb/NAMB;C:/work/database1.gdb/NORB;C:/work/database1.gdb/NSIB;C:/work/database1.gdb/NUMB;C:/work/database1.gdb/OBOL;C:/work/database1.gdb/OBVL;C:/work/database1.gdb/OFTB;C:/work/database1.gdb/OFTB_KAT;C:/work/database1.gdb/RANB;C:/work/database1.gdb/RAUB;C:/work/database1.gdb/ROAB;C:/work/database1.gdb/ROSB;C:/work/database1.gdb/SOLB;C:/work/database1.gdb/SORB;C:/work/database1.gdb/SORB_DNE;C:/work/database1.gdb/SPIB;C:/work/database1.gdb/STLB;C:/work/database1.gdb/STLB_SAV;C:/work/database1.gdb/TINB;C:/work/database1.gdb/TINB_NTD;C:/work/database1.gdb/URHB;C:/work/database1.gdb/VALB;C:/work/database1.gdb/VESB","C:/work/database2.gdb/Merged_data","""FIELD1 "FIELD1" true false false 254 Text 0 0 ,First,#,C:/work/database1.gdb/ADLB,FIELD1,-1,-1,C:/work/database1.gdb/ALGB,FIELD1,-1,-1,C:/work/database1.gdb/ALLB,FIELD1,-1,-1,C:/work/database1.gdb/ALNB,FIELD1,-1,-1,C:/work/database1.gdb/ASRB,FIELD1,-1,-1,C:/work/database1.gdb/BRAB,FIELD1,-1,-1,C:/work/database1.gdb/BREB,FIELD1,-1,-1,C:/work/database1.gdb/BRGB,FIELD1,-1,-1,C:/work/database1.gdb/DOVB,FIELD1,-1,-1,C:/work/database1.gdb/DRMB,FIELD1,-1,-1,C:/work/database1.gdb/FILB,FIELD1,-1,-1,C:/work/database1.gdb/FLEB,FIELD1,-1,-1,C:/work/database1.gdb/FLMB,FIELD1,-1,-1,C:/work/database1.gdb/GARB,FIELD1,-1,-1,C:/work/database1.gdb/GJKB,FIELD1,-1,-1,C:/work/database1.gdb/HARB,FIELD1,-1,-1,C:/work/database1.gdb/HVDB,FIELD1,-1,-1,C:/work/database1.gdb/KRAB,FIELD1,-1,-1,C:/work/database1.gdb/KVGB,FIELD1,-1,-1,C:/work/database1.gdb/MERB,FIELD1,-1,-1,C:/work/database1.gdb/MIDB,FIELD1,-1,-1,C:/work/database1.gdb/MINB,FIELD1,-1,-1,C:/work/database1.gdb/NAMB,FIELD1,-1,-1,C:/work/database1.gdb/NORB,FIELD1,-1,-1,C:/work/database1.gdb/NSIB,FIELD1,-1,-1,C:/work/database1.gdb/NUMB,FIELD1,-1,-1,C:/work/database1.gdb/OBOL,FIELD1,-1,-1,C:/work/database1.gdb/OBVL,FIELD1,-1,-1,C:/work/database1.gdb/OFTB,FIELD1,-1,-1,C:/work/database1.gdb/OFTB_KAT,FIELD1,-1,-1,C:/work/database1.gdb/RANB,FIELD1,-1,-1,C:/work/database1.gdb/RAUB,FIELD1,-1,-1,C:/work/database1.gdb/ROAB,FIELD1,-1,-1,C:/work/database1.gdb/ROSB,FIELD1,-1,-1,C:/work/database1.gdb/SOLB,FIELD1,-1,-1,C:/work/database1.gdb/SORB,FIELD1,-1,-1,C:/work/database1.gdb/SORB_DNE,FIELD1,-1,-1,C:/work/database1.gdb/SPIB,FIELD1,-1,-1,C:/work/database1.gdb/STLB,FIELD1,-1,-1,C:/work/database1.gdb/STLB_SAV,FIELD1,-1,-1,C:/work/database1.gdb/TINB,FIELD1,-1,-1,C:/work/database1.gdb/TINB_NTD,FIELD1,-1,-1,C:/work/database1.gdb/URHB,FIELD1,-1,-1,C:/work/database1.gdb/VALB,FIELD1,-1,-1,C:/work/database1.gdb/VESB,FIELD1,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,C:/work/database1.gdb/ADLB,Shape_Length,-1,-1,C:/work/database1.gdb/ALGB,Shape_Length,-1,-1,C:/work/database1.gdb/ALLB,Shape_Length,-1,-1,C:/work/database1.gdb/ALNB,Shape_Length,-1,-1,C:/work/database1.gdb/ASRB,Shape_Length,-1,-1,C:/work/database1.gdb/BRAB,Shape_Length,-1,-1,C:/work/database1.gdb/BREB,Shape_Length,-1,-1,C:/work/database1.gdb/BRGB,Shape_Length,-1,-1,C:/work/database1.gdb/DOVB,Shape_Length,-1,-1,C:/work/database1.gdb/DRMB,Shape_Length,-1,-1,C:/work/database1.gdb/FILB,Shape_Length,-1,-1,C:/work/database1.gdb/FLEB,Shape_Length,-1,-1,C:/work/database1.gdb/FLMB,Shape_Length,-1,-1,C:/work/database1.gdb/GARB,Shape_Length,-1,-1,C:/work/database1.gdb/GJKB,Shape_Length,-1,-1,C:/work/database1.gdb/HARB,Shape_Length,-1,-1,C:/work/database1.gdb/HVDB,Shape_Length,-1,-1,C:/work/database1.gdb/KRAB,Shape_Length,-1,-1,C:/work/database1.gdb/KVGB,Shape_Length,-1,-1,C:/work/database1.gdb/MERB,Shape_Length,-1,-1,C:/work/database1.gdb/MIDB,Shape_Length,-1,-1,C:/work/database1.gdb/MINB,Shape_Length,-1,-1,C:/work/database1.gdb/NAMB,Shape_Length,-1,-1,C:/work/database1.gdb/NORB,Shape_Length,-1,-1,C:/work/database1.gdb/NSIB,Shape_Length,-1,-1,C:/work/database1.gdb/NUMB,Shape_Length,-1,-1,C:/work/database1.gdb/OBOL,Shape_Length,-1,-1,C:/work/database1.gdb/OBVL,Shape_Length,-1,-1,C:/work/database1.gdb/OFTB,Shape_Length,-1,-1,C:/work/database1.gdb/OFTB_KAT,Shape_Length,-1,-1,C:/work/database1.gdb/RANB,Shape_Length,-1,-1,C:/work/database1.gdb/RAUB,Shape_Length,-1,-1,C:/work/database1.gdb/ROAB,Shape_Length,-1,-1,C:/work/database1.gdb/ROSB,Shape_Length,-1,-1,C:/work/database1.gdb/SOLB,Shape_Length,-1,-1,C:/work/database1.gdb/SORB,Shape_Length,-1,-1,C:/work/database1.gdb/SORB_DNE,Shape_Length,-1,-1,C:/work/database1.gdb/SPIB,Shape_Length,-1,-1,C:/work/database1.gdb/STLB,Shape_Length,-1,-1,C:/work/database1.gdb/STLB_SAV,Shape_Length,-1,-1,C:/work/database1.gdb/TINB,Shape_Length,-1,-1,C:/work/database1.gdb/TINB_NTD,Shape_Length,-1,-1,C:/work/database1.gdb/URHB,Shape_Length,-1,-1,C:/work/database1.gdb/VALB,Shape_Length,-1,-1,C:/work/database1.gdb/VESB,Shape_Length,-1,-1""") In the script I build the inputs into the tool by looping a list of the features I want: arcpy.Merge_management(fclist, fc_merged, fmlist) I print the content of the fclist and fmlist variables during the script, and it looks just like the above to me: fclist: "C:\work\database1.gdb\ALNB;C:\work\database1.gdb\ADLB;C:\work\database1.gdb\ASRB;C:\work\database1.gdb\BRGB;C:\work\database1.gdb\BRAB;C:\work\database1.gdb\BREB;C:\work\database1.gdb\DOVB;C:\work\database1.gdb\DRMB;C:\work\database1.gdb\FILB;C:\work\database1.gdb\FLEB;C:\work\database1.gdb\FLMB;C:\work\database1.gdb\GARB;C:\work\database1.gdb\GJKB;C:\work\database1.gdb\ALLB;C:\work\database1.gdb\MINB;C:\work\database1.gdb\HARB;C:\work\database1.gdb\HVDB;C:\work\database1.gdb\KVGB;C:\work\database1.gdb\KRAB;C:\work\database1.gdb\MERB;C:\work\database1.gdb\NAMB;C:\work\database1.gdb\NORB;C:\work\database1.gdb\NUMB;C:\work\database1.gdb\OFTB;C:\work\database1.gdb\OFTB_KAT;C:\work\database1.gdb\RANB;C:\work\database1.gdb\RAUB;C:\work\database1.gdb\ROAB;C:\work\database1.gdb\ROSB;C:\work\database1.gdb\MIDB;C:\work\database1.gdb\NSIB;C:\work\database1.gdb\SOLB;C:\work\database1.gdb\SPIB;C:\work\database1.gdb\STLB;C:\work\database1.gdb\STLB_SAV;C:\work\database1.gdb\SORB;C:\work\database1.gdb\SORB_DNE;C:\work\database1.gdb\TINB;C:\work\database1.gdb\TINB_NTD;C:\work\database1.gdb\URHB;C:\work\database1.gdb\VALB;C:\work\database1.gdb\VESB;C:\work\database1.gdb\OBVL;C:\work\database1.gdb\OBOL;C:\work\database1.gdb\ALGB" fmlist: "FIELD1 "FIELD1" True False False 254 Text 0 0 ,First,#,C:\work\database1.gdb\ALNB,FIELD1,-1,-1,C:\work\database1.gdb\ADLB,FIELD1,-1,-1,C:\work\database1.gdb\ASRB,FIELD1,-1,-1,C:\work\database1.gdb\BRGB,FIELD1,-1,-1,C:\work\database1.gdb\BRAB,FIELD1,-1,-1,C:\work\database1.gdb\BREB,FIELD1,-1,-1,C:\work\database1.gdb\DOVB,FIELD1,-1,-1,C:\work\database1.gdb\DRMB,FIELD1,-1,-1,C:\work\database1.gdb\FILB,FIELD1,-1,-1,C:\work\database1.gdb\FLEB,FIELD1,-1,-1,C:\work\database1.gdb\FLMB,FIELD1,-1,-1,C:\work\database1.gdb\GARB,FIELD1,-1,-1,C:\work\database1.gdb\GJKB,FIELD1,-1,-1,C:\work\database1.gdb\ALLB,FIELD1,-1,-1,C:\work\database1.gdb\MINB,FIELD1,-1,-1,C:\work\database1.gdb\HARB,FIELD1,-1,-1,C:\work\database1.gdb\HVDB,FIELD1,-1,-1,C:\work\database1.gdb\KVGB,FIELD1,-1,-1,C:\work\database1.gdb\KRAB,FIELD1,-1,-1,C:\work\database1.gdb\MERB,FIELD1,-1,-1,C:\work\database1.gdb\NAMB,FIELD1,-1,-1,C:\work\database1.gdb\NORB,FIELD1,-1,-1,C:\work\database1.gdb\NUMB,FIELD1,-1,-1,C:\work\database1.gdb\OFTB,FIELD1,-1,-1,C:\work\database1.gdb\OFTB_KAT,FIELD1,-1,-1,C:\work\database1.gdb\RANB,FIELD1,-1,-1,C:\work\database1.gdb\RAUB,FIELD1,-1,-1,C:\work\database1.gdb\ROAB,FIELD1,-1,-1,C:\work\database1.gdb\ROSB,FIELD1,-1,-1,C:\work\database1.gdb\MIDB,FIELD1,-1,-1,C:\work\database1.gdb\NSIB,FIELD1,-1,-1,C:\work\database1.gdb\SOLB,FIELD1,-1,-1,C:\work\database1.gdb\SPIB,FIELD1,-1,-1,C:\work\database1.gdb\STLB,FIELD1,-1,-1,C:\work\database1.gdb\STLB_SAV,FIELD1,-1,-1,C:\work\database1.gdb\SORB,FIELD1,-1,-1,C:\work\database1.gdb\SORB_DNE,FIELD1,-1,-1,C:\work\database1.gdb\TINB,FIELD1,-1,-1,C:\work\database1.gdb\TINB_NTD,FIELD1,-1,-1,C:\work\database1.gdb\URHB,FIELD1,-1,-1,C:\work\database1.gdb\VALB,FIELD1,-1,-1,C:\work\database1.gdb\VESB,FIELD1,-1,-1,C:\work\database1.gdb\OBVL,FIELD1,-1,-1,C:\work\database1.gdb\OBOL,FIELD1,-1,-1,C:\work\database1.gdb\ALGB,FIELD1,-1,-1;Shape_Length "Shape_Length" False True True 8 Double 0 0 ,First,#,C:\work\database1.gdb\ALNB,Shape_Length,-1,-1,C:\work\database1.gdb\ADLB,Shape_Length,-1,-1,C:\work\database1.gdb\ASRB,Shape_Length,-1,-1,C:\work\database1.gdb\BRGB,Shape_Length,-1,-1,C:\work\database1.gdb\BRAB,Shape_Length,-1,-1,C:\work\database1.gdb\BREB,Shape_Length,-1,-1,C:\work\database1.gdb\DOVB,Shape_Length,-1,-1,C:\work\database1.gdb\DRMB,Shape_Length,-1,-1,C:\work\database1.gdb\FILB,Shape_Length,-1,-1,C:\work\database1.gdb\FLEB,Shape_Length,-1,-1,C:\work\database1.gdb\FLMB,Shape_Length,-1,-1,C:\work\database1.gdb\GARB,Shape_Length,-1,-1,C:\work\database1.gdb\GJKB,Shape_Length,-1,-1,C:\work\database1.gdb\ALLB,Shape_Length,-1,-1,C:\work\database1.gdb\MINB,Shape_Length,-1,-1,C:\work\database1.gdb\HARB,Shape_Length,-1,-1,C:\work\database1.gdb\HVDB,Shape_Length,-1,-1,C:\work\database1.gdb\KVGB,Shape_Length,-1,-1,C:\work\database1.gdb\KRAB,Shape_Length,-1,-1,C:\work\database1.gdb\MERB,Shape_Length,-1,-1,C:\work\database1.gdb\NAMB,Shape_Length,-1,-1,C:\work\database1.gdb\NORB,Shape_Length,-1,-1,C:\work\database1.gdb\NUMB,Shape_Length,-1,-1,C:\work\database1.gdb\OFTB,Shape_Length,-1,-1,C:\work\database1.gdb\OFTB_KAT,Shape_Length,-1,-1,C:\work\database1.gdb\RANB,Shape_Length,-1,-1,C:\work\database1.gdb\RAUB,Shape_Length,-1,-1,C:\work\database1.gdb\ROAB,Shape_Length,-1,-1,C:\work\database1.gdb\ROSB,Shape_Length,-1,-1,C:\work\database1.gdb\MIDB,Shape_Length,-1,-1,C:\work\database1.gdb\NSIB,Shape_Length,-1,-1,C:\work\database1.gdb\SOLB,Shape_Length,-1,-1,C:\work\database1.gdb\SPIB,Shape_Length,-1,-1,C:\work\database1.gdb\STLB,Shape_Length,-1,-1,C:\work\database1.gdb\STLB_SAV,Shape_Length,-1,-1,C:\work\database1.gdb\SORB,Shape_Length,-1,-1,C:\work\database1.gdb\SORB_DNE,Shape_Length,-1,-1,C:\work\database1.gdb\TINB,Shape_Length,-1,-1,C:\work\database1.gdb\TINB_NTD,Shape_Length,-1,-1,C:\work\database1.gdb\URHB,Shape_Length,-1,-1,C:\work\database1.gdb\VALB,Shape_Length,-1,-1,C:\work\database1.gdb\VESB,Shape_Length,-1,-1,C:\work\database1.gdb\OBVL,Shape_Length,-1,-1,C:\work\database1.gdb\OBOL,Shape_Length,-1,-1,C:\work\database1.gdb\ALGB,Shape_Length,-1,-1" I thought the field mapping might be the cause, but I can't for the life of me see any differences between the two... ... View more

It means that you have some special characters in there somewhere (u'\xfc' is 'ü', I believe) that need to be handled as unicode. Standard string operators in python doesn't handle unicode. It's hard to be more specific without any code or data... ... View more

Wouldn't it be possible to just use CalculateField with a small script code block to replace the commas? Expression: "Recode(!FIELDNAME!) ExpressionType = "PYTHON_9.3" Code Block: def Recode(input):     output = input.replace(',', '_')     return output This could be wrapped in code to iterate feature classes and fields for an entire geodatabase if needed... ... View more

Ah, yes. I did not catch that the input was an excel file. I've had all kinds of cryptic errors on those, usually from bad field names (certain characters not allowed), data errors etc. What I have done in cases like this where I have an excel spread as input is to use xlrd for python to read the spreadsheet, add some data validation and then create a new table with the data I needed to use as input to create the event. Excel to table is a 10.2 function, I believe? ... View more

My guess is that it's because you are trying to copy the layer file (R20060102Lyr) and not the layer (R20060102Layer) to the new FC. I haven't done XY events, but I have a script saving LR events where I copy the event layer directly without saving a layer file. This uses the MakeRouteEventLayer_lr: [INDENT]MakeRouteEventLayer_lr (in_routes, route_id_field, in_table, in_event_properties, out_layer, {offset_field}, {add_error_field}, {add_angle_field}, {angle_type}, {complement_angle}, {offset_direction}, {point_event_type})[/INDENT] The "out_layer" above goes directly into the copy feature "in_features": [INDENT]CopyFeatures_management (in_features, out_feature_class, {config_keyword}, {spatial_grid_1}, {spatial_grid_2}, {spatial_grid_3})[/INDENT] ... View more