Please wait...
×

Error

Posted Mon, 24 Aug 2015 13:24:26 GMT by jecaor_1
I must admit, was not elegant way, but fix the problem.
With arcgis 10.1 could delete MUID column, and them with import/export tool MUID has been created anew.
if anyone knows other way, please......." let me know".

I have worked with MikeUrban 2012.

Best regards.
Posted Mon, 24 Aug 2015 19:24:52 GMT by Ricardo Machado Student
Hello jecaor_1,

Did you try using the field calculator tool?

Best regards,
Ricardo Machado
Posted Tue, 25 Aug 2015 11:29:55 GMT by jecaor_1
my knowledge to use this tool are limited, but I tried.
I could use " autoincrement()". but for me it was impossible to appear the text in the MUID,
you know, "wLink and wNode", so, I had to use that ugly way. delete a MUID column.

Best Regards, RMachado.

Right know I`m working with a main water network, and i will design some scenarios...
Posted Thu, 10 Sep 2015 15:44:54 GMT by Brian Brenhaug Enterprise Water Systems Team Manager
I've also conducted this in Microsoft Access with action queries or find/replace, but the nice part about using the built-in field calculator is that some of the related tables will also change the MUIDs (not all of them).
Posted Thu, 26 Nov 2015 09:08:22 GMT by JakubVajda
We tend to do it more clear way..

MS Access - Update query SET MUID = Prefix & OBJECTID (or just OBJECTID)
since object ID is already an autoincrement...

We tried under MU 2014 SP3 without any problems what so ever (junctions, pipes)
There is also a way how to directly update the field with autoincrement function (access VBA)
[url=http://vbahowto.com/2013/09/02/ms-access-running-counter-in-query/]http://vbahowto.com/2013/09/02/ms-access-running-counter-in-query/[/url]
but it's a kind of magic....

but generally we try to do most of the changes within the MDB geodatabase using MS Access...

You must be signed in to post in this forum.