clone_items.py

"""
-------------------------------------------------------------------------------
 | Copyright 2017 Esri
 |
 | Licensed under the Apache License, Version 2.0 (the "License");
 | you may not use this file except in compliance with the License.
 | You may obtain a copy of the License at
 |
 |    http://www.apache.org/licenses/LICENSE-2.0
 |
 | Unless required by applicable law or agreed to in writing, software
 | distributed under the License is distributed on an "AS IS" BASIS,
 | WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 | See the License for the specific language governing permissions and
 | limitations under the License.
 ------------------------------------------------------------------------------
 """
import json, uuid, re, tempfile, os, copy, zipfile, shutil
from functools import reduce
from urllib.parse import urlparse
from arcgis import gis
from arcgis.features import FeatureLayerCollection
from arcgis.features import FeatureLayer

COPY_DATA = False
USE_DEFAULT_BASEMAP = False
ADD_GPS_METADATA_FIELDS = False
SEARCH_ORG_FOR_EXISTING_ITEMS = True
ITEM_EXTENT = None
SPATIAL_REFERENCE = None
ADD_TAGS = []
REMOVE_TAGS = []

#region Group and Item Definition Classes

class _GroupDefinition(object):
    """
    Represents the definition of a group within ArcGIS Online or Portal.
    """

    def __init__(self, info, thumbnail=None, portal_group=None):
        self.info = info
        self.thumbnail = thumbnail
        self.portal_group = portal_group

    def clone(self, target):
        """Clone the group in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to group to."""
    
        try:
            new_group = None
            original_group = self.info
            
            title = original_group['title']
            tags = original_group['tags']
            for tag in list(tags):
                if tag.startswith("source-") or tag.startswith("sourcefolder-"):
                    tags.remove(tag)
         
            original_group['tags'].append("source-{0}".format(original_group['id']))
            tags = ','.join(original_group['tags'])
            
            #Find a unique name for the group
            i = 1    
            while True:
                search_query = 'title:"{0}" AND owner:{1}'.format(title, target.users.me.username)
                groups = [group for group in target.groups.search(search_query, outside_org=False) if group['title'] == title]
                if len(groups) == 0:
                    break
                i += 1
                title = "{0} {1}".format(original_group['title'], i)
        
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_group:
                    thumbnail = self.portal_group.download_thumbnail(temp_dir)

                new_group = target.groups.create(title, tags, original_group['description'], original_group['snippet'],
                                                 'private', thumbnail, True, original_group['sortField'], original_group['sortOrder'], True)
            return new_group
        except Exception as ex:
            raise _ItemCreateException("Failed to create group '{0}': {1}".format(original_group['title'], str(ex)), new_group)

class _ItemDefinition(object):
    """
    Represents the definition of an item within ArcGIS Online or Portal.
    """

    def __init__(self, info, data=None, sharing=None, thumbnail=None, portal_item=None):
        self.info = info
        self._data = data    
        self.sharing = sharing
        if not self.sharing:
            self.sharing = {"access": "private", "groups": []}
        self.thumbnail = thumbnail
        self._item_property_names = ['title', 'type', 'description', 
                                     'snippet', 'tags', 'culture',
                                     'accessInformation', 'licenseInfo', 'typeKeywords', 'extent']
        self.portal_item = portal_item

    @property
    def data(self):
        """Gets the data of the item"""
        return copy.deepcopy(self._data)

    def _get_item_properties(self):
        """Get a dictionary of item properties used in create and update operations."""

        item_properties = {}
        for property_name in self._item_property_names:
            item_properties[property_name] = self.info[property_name]

        type_keywords = item_properties['typeKeywords']
        for keyword in list(type_keywords):
            if keyword.startswith('source-'):
                type_keywords.remove(keyword)

        tags = item_properties['tags']

        tags.extend(ADD_TAGS)
        expressions = [re.compile(x) for x in REMOVE_TAGS]
        item_properties['tags'] = [t for t in tags if all(not ex.match(t) for ex in expressions)]

        type_keywords.append('source-{0}'.format(self.info['id']))
        item_properties['typeKeywords'] = ','.join(item_properties['typeKeywords'])
        item_properties['tags'] = ','.join(item_properties['tags'])

        if ITEM_EXTENT is not None:
            item_properties['extent'] = ITEM_EXTENT

        return item_properties

    def clone(self, target, folder, item_mapping):  
        """Clone the item in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the item to.
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.
        """
    
        try:
            new_item = None
            original_item = self.info
        
            # Get the item properties from the original item to be applied when the new item is created
            item_properties = self._get_item_properties()

            with tempfile.TemporaryDirectory() as temp_dir:
                data = self.data
                if not data and self.portal_item:
                    data = self.portal_item.download(temp_dir)
                
                # The item's name will default to the name of the data, if it already exists in the folder we need to rename it to something unique
                name = os.path.basename(data)
                item = next((item for item in target.users.me.items(folder=_deep_get(folder, 'title')) if item['name'] == name), None)
                if item:
                    new_name = "{0}_{1}{2}".format(os.path.splitext(name)[0], str(uuid.uuid4()).replace('-', ''), os.path.splitext(name)[1])
                    new_path = os.path.join(temp_dir, new_name)
                    os.rename(data, new_path)
                    data = new_path

                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)

                # Add the new item
                new_item = target.content.add(item_properties=item_properties, data=data, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _TextItemDefinition(_ItemDefinition):
    """
    Represents the definition of a text based item within ArcGIS Online or Portal.
    """

    def clone(self, target, folder, item_mapping):  
        """Clone the item in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the item to.
        folder- The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.
        """
    
        try:
            new_item = None
            original_item = self.info
        
            # Get the item properties from the original item to be applied when the new item is created
            item_properties = self._get_item_properties()
            data = self.data
            if data:
                item_properties['text'] = json.dumps(data)
            
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item = target.content.add(item_properties=item_properties, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _FeatureCollectionDefinition(_TextItemDefinition):
    """
    Represents the definition of a feature collection within ArcGIS Online or Portal.
    """   
     
    def clone(self, target, folder, item_mapping):  
        """Clone the item in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the item to.
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.
        """
    
        try:
            new_item = None
            original_item = self.info
        
            # Get the item properties from the original item to be applied when the new item is created
            item_properties = self._get_item_properties()
            data = self.data
            if data:
                if not COPY_DATA:
                    if 'layers' in data and data['layers'] is not None:
                        for layer in data['layers']:
                            if 'featureSet' in layer and layer['featureSet'] is not None:
                                layer['featureSet']['features'] = []
                item_properties['text'] = json.dumps(data)
            
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item = target.content.add(item_properties=item_properties, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _FeatureServiceDefinition(_TextItemDefinition):
    """
    Represents the definition of a hosted feature service within ArcGIS Online or Portal.
    """

    def __init__(self, info, service_definition, layers_definition, is_view=False, view_sources={}, view_source_fields={}, features=None, data=None, sharing=None, thumbnail=None, portal_item=None):
        self._service_definition = service_definition
        self._layers_definition = layers_definition
        self._features = features
        self._is_view = is_view
        self._view_sources = view_sources
        self._view_source_fields = view_source_fields
        super().__init__(info, data, sharing, thumbnail, portal_item)

    @property
    def service_definition(self):
        """Gets the definition of the service"""
        return copy.deepcopy(self._service_definition)

    @property
    def layers_definition(self):
        """Gets the layer and table definitions of the service"""
        return copy.deepcopy(self._layers_definition)

    @property
    def is_view(self):
        """Gets if the service is a view"""
        return self._is_view

    @property
    def view_sources(self):
        """Gets the sources for the view"""
        return self._view_sources

    @property
    def view_source_fields(self):
        """Gets the original fields for the source view"""
        return self._view_source_fields

    @property
    def features(self):
        """Gets the features for the service"""
        return copy.deepcopy(self._features)

    def _get_features(self, feature_layer, wkid=None):
        """Get the features for the given feature layer of a feature service. Returns a list of json features.
        Keyword arguments:
        feature_layer - The feature layer to return the features for
        wkid -  The wkid for the spatial reference to return the features in"""
        if wkid is None:
            wkid = 3857
      
        total_features = []
        record_count = feature_layer.query(return_count_only=True)
        max_record_count = feature_layer.properties['maxRecordCount']
        if max_record_count < 1:
            max_record_count = 1000
        offset = 0
        return_z = 'hasZ' in feature_layer.properties and feature_layer.properties['hasZ']
        return_m = 'hasM' in feature_layer.properties and feature_layer.properties['hasM']
        while offset < record_count:
            features = feature_layer.query(out_sr=wkid, result_offset=offset, result_record_count=max_record_count, return_z=return_z, return_m=return_m).features
            offset += len(features)
            total_features += [f.as_dict for f in features]
        return total_features

    def _add_features(self, layers, relationships, layer_field_mapping, wkid):
        """Add the features from the definition to the layers returned from the cloned item.
        Keyword arguments:
        layers - Dictionary containing the id of the layer and its corresponding arcgis.lyr.FeatureLayer
        relationships - Dictionary containing the id of the layer and its relationship definitions
        layer_field_mapping - field mapping if the case or name of field changed from the original service
        wkid -  The wkid for the spatial reference to create the features in"""

        # Get the features if they haven't already been queried
        features = self.features
        original_layers = []
        if not features and self.portal_item:
            svc = FeatureLayerCollection.fromitem(self.portal_item)    
            features = {}
            original_layers = svc.layers + svc.tables
            for layer in original_layers:
                features[str(layer.properties['id'])] = self._get_features(layer, wkid)
        else:
            return   

        # Update the feature attributes if field names have changed
        for layer_id in features:
            if int(layer_id) in layer_field_mapping:
                field_mapping = layer_field_mapping[int(layer_id)]
                for feature in features[layer_id]:
                    _update_feature_attributes(feature, field_mapping)

        # Add in chunks of 2000 features
        chunk_size = 2000
        layer_ids = [id for id in layers]
        object_id_mapping = {}

        # Find all the relates where the layer's role is the origin and the key field is the global id field
        # We want to process these first, get the new global ids that are created and update in related features before processing the relates
        for layer_id in relationships:
            if layer_id not in layer_ids or layer_id not in layers:
                continue

            properties = layers[layer_id].properties  
            if 'globalIdField' not in properties:  
                continue

            global_id_field = properties['globalIdField']
            object_id_field = properties['objectIdField']
            relates = [relate for relate in relationships[layer_id] if relate['role'] == 'esriRelRoleOrigin' and relate['keyField'] == global_id_field]
            if len(relates) == 0:
                continue

            layer = layers[layer_id]
            layer_features = features[str(layer_id)]
            if len(layer_features) == 0:
                layer_ids.remove(layer_id)
                continue

            # Add the features to the layer in chunks
            add_results = []
            for features_chunk in [layer_features[i:i+chunk_size] for i in range(0, len(layer_features), chunk_size)]:
                edits = layer.edit_features(adds=features_chunk)
                add_results += edits['addResults']
            layer_ids.remove(layer_id)

            # Create a mapping between the original global id and the new global id
            object_id_mapping[layer_id] = {layer_features[i]['attributes'][object_id_field] : add_results[i]['objectId'] for i in range(0, len(layer_features))}
            global_id_mapping = {layer_features[i]['attributes'][global_id_field] : add_results[i]['globalId'] for i in range(0, len(layer_features))}

            for relate in relates:
                related_layer_id = relate['relatedTableId']
                if related_layer_id not in layer_ids:
                    continue
                related_layer_features = features[str(related_layer_id)]
                if len(related_layer_features) == 0:
                    layer_ids.remove(related_layer_id)
                    continue

                # Get the definition of the definition relationship
                destination_relate = next((r for r in relationships[related_layer_id] if r['id'] == relate['id'] and r['role'] == 'esriRelRoleDestination'), None)
                if not destination_relate:
                    continue

                key_field = destination_relate['keyField']

                # Update the relate features keyfield to the new global id
                for feature in related_layer_features:
                    if key_field in feature['attributes']:
                        global_id = feature['attributes'][key_field]
                        if global_id in global_id_mapping:
                            feature['attributes'][key_field] = global_id_mapping[global_id]

                # Add the related features to the layer in chunks
                add_results = []
                for features_chunk in [related_layer_features[i:i+chunk_size] for i in range(0, len(layer_features), chunk_size)]:
                    edits = layers[related_layer_id].edit_features(adds=features_chunk)
                    add_results += edits['addResults']
                layer_ids.remove(related_layer_id)
                object_id_field = layers[related_layer_id].properties['objectIdField']
                object_id_mapping[related_layer_id] = {related_layer_features[i]['attributes'][object_id_field] : add_results[i]['objectId'] for i in range(0, len(related_layer_features))}
                      
        # Add features to all other layers and tables                           
        for layer_id in layer_ids:
            layer_features = features[str(layer_id)]
            if len(layer_features) == 0:
                continue
            add_results = []
            for features_chunk in [layer_features[i:i+chunk_size] for i in range(0, len(layer_features), chunk_size)]:
                edits = layers[layer_id].edit_features(adds=features_chunk)
                add_results += edits['addResults']
            object_id_field = layers[layer_id].properties['objectIdField']
            object_id_mapping[layer_id] = {layer_features[i]['attributes'][object_id_field] : add_results[i]['objectId'] for i in range(0, len(layer_features))}

        # Add attachments
        for original_layer in original_layers:
            properties = original_layer.properties
            layer_id = properties['id']
            if 'hasAttachments' in properties and properties['hasAttachments']:
                if str(layer_id) in features and features[str(layer_id)] is not None:
                    original_attachments = original_layer.attachments
                    attachments = layers[layer_id].attachments
                    object_id_field = layers[layer_id].properties['objectIdField']
                    layer_features = features[str(layer_id)]
                    if layer_id not in object_id_mapping:
                        continue
                    
                    for feature in layer_features:
                        original_oid = feature['attributes'][object_id_field]
                        if original_oid not in object_id_mapping[layer_id]:
                            continue
                        
                        oid = object_id_mapping[layer_id][original_oid]
                        attachment_infos = original_attachments.get_list(original_oid)
                        if len(attachment_infos) > 0:
                            with tempfile.TemporaryDirectory() as temp_dir:
                                for attachment_info in attachment_infos:
                                    attachment_file = original_attachments.download(original_oid, attachment_info['id'], temp_dir)
                                    attachments.add(oid, attachment_file)

    def _get_unique_name(self, target, name, item_mapping, force_add_guid_suffix):
        """Create a new unique name for the service.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the feature service to.
        name - The original name.
        item_mapping - Dictionary containing mapping between new and old items.
        force_add_guid_suffix - Indicates if a guid suffix should automatically be added to the end of the service name
        """

        if name[0].isdigit():
            name = '_' + name
        name = name.replace(' ', '_')

        if not force_add_guid_suffix:      
            guids = re.findall('[0-9A-F]{32}', name, re.IGNORECASE)
            for guid in guids:
                if guid in item_mapping['Group IDs']:
                    name = name.replace(guid, item_mapping['Group IDs'][guid])
                elif guid in item_mapping['Item IDs']:
                    name = name.replace(guid, item_mapping['Item IDs'][guid])
                else:
                    new_guid = str(uuid.uuid4()).replace('-', '')
                    name = name.replace(guid, new_guid)

            while True:
                if target.content.is_service_name_available(name, 'featureService'):
                    break

                guid = str(uuid.uuid4()).replace('-', '')
                ends_with_guid = re.findall('_[0-9A-F]{32}$', name, re.IGNORECASE)
                if len(ends_with_guid) > 0:
                    name = name[:len(name) - 32] + guid
                else:
                    name = "{0}_{1}".format(name, guid)      

        else:
            guid = str(uuid.uuid4()).replace('-', '')
            ends_with_guid = re.findall('_[0-9A-F]{32}$', name, re.IGNORECASE)
            if len(ends_with_guid) > 0:
                name = name[:len(name) - 32] + guid
            else:
                name = "{0}_{1}".format(name, guid)   

        return name

    def clone(self, target, folder, item_mapping):
        """Clone the feature service in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the feature service to.
        folder - The name of the folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.
        """

        try:
            new_item = None
            original_item = self.info

            # Get the definition of the original feature service
            service_definition = self.service_definition

            # Modify the definition before passing to create the new service             
            name = self._get_unique_name(target, original_item['name'], item_mapping, False)       
            service_definition['name'] = name
    
            for key in ['layers', 'tables', 'fullExtent']:
                if key in service_definition:
                    del service_definition[key]

            # Set the extent and spatial reference of the service
            extent = service_definition['initialExtent']
            extent = _get_extent_definition(extent)
            service_definition['initialExtent'] = extent
            service_definition['spatialReference'] = extent['spatialReference']

            if self.is_view:
                properties = ['name', 'isView', 'sourceSchemaChangesAllowed', 'isUpdatableView', 'capabilities']
                service_definition_copy = copy.deepcopy(service_definition)
                for key, value in service_definition_copy.items():
                    if key not in properties:
                        del service_definition[key]

            # Create a new feature service
            # In some cases isServiceNameAvailable returns true but fails to create the service with error that a service with the name already exists.
            # In these cases catch the error and try again with a unique name.
            try:
                new_item = _create_service(target, 'featureService', service_definition, self.is_view, _deep_get(folder, 'title'))
            except RuntimeError as ex: 
                if "already exists" in str(ex):
                    name = self._get_unique_name(target, name, item_mapping, True)  
                    service_definition['name'] = name
                    new_item = target.content.create_service(name, service_type='featureService', create_params=service_definition, folder=_deep_get(folder, 'title'))
                elif "managed database" in str(ex):
                    raise Exception("The target portal's managed database must be an ArcGIS Data Store.")
                else:
                    raise

            # Check if tool has been canceled, raise exception with new_item so it can be cleaned up
            _check_cancel_status(new_item)

            # Get the layer and table definitions from the original service and prepare them for the new service
            layers_definition = self.layers_definition
            gps_metadata = json.loads(_GPS_METADATA_FIELDS)
            relationships = {}
            for layer in layers_definition['layers'] + layers_definition['tables']:
                # Need to remove relationships first and add them back individually 
                # after all layers and tables have been added to the definition
                if 'relationships' in layer and layer['relationships'] is not None and len(layer['relationships']) != 0:
                    relationships[layer['id']] = layer['relationships']
                    layer['relationships'] = []

                # Need to remove all indexes duplicated for fields.
                # Services get into this state due to a bug in 10.4 and 1.2
                field_names = [f['name'].lower() for f in layer['fields']]

                unique_fields = []
                if 'indexes' in layer:
                    for index in list(layer['indexes']):
                        fields = index['fields'].lower()
                        if fields in unique_fields or fields not in field_names:
                            layer['indexes'].remove(index)
                        else:
                            unique_fields.append(fields)
                
                # Due to a bug at 10.5.1 any domains for a double field must explicitly have a float code rather than int
                for field in layer['fields']:
                    field_type = _deep_get(field, 'type')
                    if field_type == "esriFieldTypeDouble":
                        coded_values = _deep_get(field, 'domain', 'codedValues')
                        if coded_values is not None:
                            for coded_value in coded_values:
                                code = _deep_get(coded_value, 'code')
                                if code is not None:
                                    coded_value['code'] = float(code)

                # Add GPS Metadata fields to layer definition
                if ADD_GPS_METADATA_FIELDS:
                    if 'geometryType' in layer and layer['geometryType'] == 'esriGeometryPoint':
                        metadata_fields = gps_metadata['fields']
                        for metadata_field in metadata_fields:
                            if metadata_field['name'].lower() not in field_names:
                                if target.properties.isPortal:
                                    metadata_field['name'] = metadata_field['name'].lower()
                                layer['fields'].append(metadata_field)

                # Set the extent of the feature layer to the specified default extent
                if layer['type'] == 'Feature Layer':
                    layer['extent'] = extent

                # Update the view layer source properties
                if self.is_view:
                    url = self.view_sources[layer['id']]
                    original_feature_service = os.path.dirname(url)
                    original_id = os.path.basename(url)
                    admin_layer_info = {}
                    layer['adminLayerInfo'] = admin_layer_info

                    for key, value in item_mapping['Feature Services'].items():
                        if _compare_url(key, original_feature_service):
                            new_service = value
                            view_layer_definition = {}
                            view_layer_definition['sourceServiceName'] = os.path.basename(os.path.dirname(new_service['url']))
                            view_layer_definition['sourceLayerId'] = new_service['layer_id_mapping'][int(original_id)]
                            view_layer_definition['sourceLayerFields'] = '*'
                            admin_layer_info['viewLayerDefinition'] = view_layer_definition
                            break

            # Add the layer and table definitions to the service
            # Explicitly add layers first and then tables, otherwise sometimes json.dumps() reverses them and this effects the output service
            feature_service = FeatureLayerCollection.fromitem(new_item)
            feature_service_admin = feature_service.manager
            if len(layers_definition['layers']) > 0:
                add_to_definition = {'layers' : copy.deepcopy(layers_definition['layers'])}
                if self.is_view:
                    for layer in add_to_definition['layers']:
                        del layer['fields']
                feature_service_admin.add_to_definition(add_to_definition)
            if len(layers_definition['tables']) > 0:
                add_to_definition = {'tables' : copy.deepcopy(layers_definition['tables'])}
                if self.is_view:
                    for table in add_to_definition['tables']:
                        del table['fields']
                feature_service_admin.add_to_definition(add_to_definition)

            # Check if tool has been canceled, raise exception with new_item so it can be cleaned up
            _check_cancel_status(new_item)
            
            # Create a lookup between the new and old layer ids
            layer_id_mapping = {}
            layer_fields = {}
            original_layers = layers_definition['layers'] + layers_definition['tables']
            i = 0
            for layer in feature_service.layers + feature_service.tables:
                layer_id_mapping[original_layers[i]['id']] = layer.properties['id']
                layer_fields[layer.properties['id']] = layer.properties.fields
                i += 1

            # Create a lookup for the layers and tables using their id
            new_layers = {}
            for layer in feature_service.layers + feature_service.tables:
                for key, value in layer_id_mapping.items():
                    if value == layer.properties['id']:
                        new_layers[key] = layer
                        break

            # Create a field mapping object if the case or name of the field has changes  
            layer_field_mapping = {}
            for layer in layers_definition['layers'] + layers_definition['tables']:
                layer_id = layer['id']
                fields = layer['fields']
                if self.is_view:
                    fields = self.view_source_fields[layer_id]
                new_layer = new_layers[layer_id]
                field_mapping = {}
                if len(fields) <= len(new_layer.properties['fields']):
                    for i in range(0, len(fields)):
                        if fields[i]['name'] != new_layer.properties['fields'][i]['name']:
                            field_mapping[fields[i]['name']] = new_layer.properties['fields'][i]['name']
                    if len(field_mapping) > 0:
                        layer_field_mapping[layer_id] = field_mapping

                # If editor tracking fields changed from original layer we need to update the layer field mapping
                del_fields = []
                if 'editFieldsInfo' in layer and layer['editFieldsInfo'] is not None and 'editFieldsInfo' in new_layer.properties and new_layer.properties['editFieldsInfo'] is not None:
                    new_edit_fields_info = new_layer.properties['editFieldsInfo']
                    for key, old_field in layer['editFieldsInfo'].items():
                        if key in new_edit_fields_info:
                            new_field = new_edit_fields_info[key]
                            if old_field != new_field:
                                new_delete_field = old_field
                                if old_field in field_mapping:
                                    new_delete_field = field_mapping[old_field]
                                for field in new_layer.properties['fields']:
                                    if field['name'] == new_delete_field:
                                        del_fields.append(new_delete_field)
                                        break
                                if layer_id in layer_field_mapping:
                                    layer_field_mapping[layer_id][old_field] = new_field
                                else:
                                    field_mapping = {old_field : new_field}
                                    layer_field_mapping[layer_id] = field_mapping
                
                update_definition = {}
                delete_definition = {}

                if len(del_fields) > 0 or layer_id in layer_field_mapping:           
                    # Delete the old editor tracking fields from the layer
                    if len(del_fields) > 0:
                        layer_admin = new_layer.manager
                        delete_definition_fields = []
                        for field in del_fields:
                            delete_definition_fields.append({'name': field})
                        delete_definition['fields'] = delete_definition_fields
                        
                    # Update editing templates if field mapping is required
                    if layer_id in layer_field_mapping:
                        field_mapping = layer_field_mapping[layer_id]
                        
                        if 'templates' in new_layer.properties and new_layer.properties['templates'] is not None:
                            templates = new_layer.properties['templates']
                            for template in templates:
                                if 'prototype' in template and template['prototype'] is not None:
                                    _update_feature_attributes(template['prototype'], field_mapping)
                            update_definition['templates'] = templates

                        if 'types' in new_layer.properties and new_layer.properties['types'] is not None:
                            types = new_layer.properties['types']
                            for layer_type in types:
                                if 'templates' in layer_type and layer_type['templates'] is not None:                     
                                    for template in layer_type['templates']:
                                        if 'prototype' in template and template['prototype'] is not None:
                                            _update_feature_attributes(template['prototype'], field_mapping)
                            update_definition['types'] = types

                # Update field visibility for views
                if self.is_view:
                    field_visibility = []
                    need_update = False
                    for source_field in self.view_source_fields[layer_id]:
                        source_field_name = source_field['name']
                        view_field_names = [f['name'] for f in layer['fields']]
                        visible = source_field_name in view_field_names
                        if not visible:
                            need_update = True
                        field_name = source_field_name
                        if layer_id in layer_field_mapping:
                            if source_field_name in layer_field_mapping[layer_id]:
                                field_name = layer_field_mapping[layer_id][source_field_name]
                            if 'viewDefinitionQuery' in layer and layer['viewDefinitionQuery']:
                                update_definition['viewDefinitionQuery'] = _find_and_replace_fields(layer['viewDefinitionQuery'], layer_field_mapping[layer_id])
                            if 'definitionQuery' in layer and layer['definitionQuery']:
                                update_definition['definitionQuery'] = _find_and_replace_fields(layer['definitionQuery'], layer_field_mapping[layer_id])
                        field_visibility.append({'name' : field_name, 'visible' : visible})
                    if need_update:
                        update_definition['fields'] = field_visibility

                # Update the definition of the layer
                if len(update_definition) > 0 or len(delete_definition) > 0:
                    layer_admin = new_layer.manager
                    if len(update_definition) > 0:
                        layer_admin.update_definition(update_definition)
                    if len(delete_definition) > 0:
                        layer_admin.delete_from_definition(delete_definition)

            # Check if tool has been canceled, raise exception with new_item so it can be cleaned up
            _check_cancel_status(new_item)

            # Add the relationships back to the layers
            if len(relationships) > 0:
                for layer_id in relationships:
                    for relationship in relationships[layer_id]:
                        if layer_id in layer_field_mapping:
                            field_mapping = layer_field_mapping[layer_id]
                            if relationship['keyField'] in field_mapping:
                                relationship['keyField'] = field_mapping[relationship['keyField']]         

                relationships_copy = copy.deepcopy(relationships)
                for layer_id in relationships_copy:
                    for relationship in relationships_copy[layer_id]:
                        relationship['relatedTableId'] = layer_id_mapping[relationship['relatedTableId']]

                if target.properties.isPortal:
                    relationships_definition = {'layers' : []}
                    for layer_id in relationships_copy:
                        new_layer_id = layer_id_mapping[layer_id]
                        relationships_definition['layers'].append({'id' : new_layer_id, 'relationships' : relationships_copy[layer_id]})                
                    feature_service_admin.add_to_definition(relationships_definition)  
                else:
                    for layer_id in relationships_copy:
                        layer = new_layers[layer_id]
                        layer.manager.add_to_definition({'relationships' : relationships_copy[layer_id]})

            # Check if tool has been canceled, raise exception with new_item so it can be cleaned up
            _check_cancel_status(new_item)

            # Get the item properties from the original item
            item_properties = self._get_item_properties()
            
            # Merge type keywords from what is created by default for the new item and what was in the original item
            type_keywords = list(new_item['typeKeywords'])
            type_keywords.extend(item_properties['typeKeywords'].split(','))
            type_keywords = list(set(type_keywords))

            # Replace type keyword if it references an item id of cloned item, ex. Survey123
            for keyword in list(type_keywords):
                if keyword in item_mapping['Item IDs']:
                    type_keywords.remove(keyword)
                    type_keywords.append(item_mapping['Item IDs'][keyword])
            item_properties['typeKeywords'] = ','.join(type_keywords)
            
            # Get the collection of layers and tables from the item data
            data = self.data
            layers = []
            if data and 'layers' in data and data['layers'] is not None:
                layers += [layer for layer in data['layers']]
            if data and 'tables' in data and data['tables'] is not None:
                layers += [layer for layer in data['tables']]

            # Clear out any field mapping that may have been previously persisted on the item
            for layer in layers:
                if 'fieldMapping' in layer:
                    del layer['fieldMapping']

            # Update field names and persist field mapping if required
            if len(layer_field_mapping) > 0:
                if not data:
                    data = {}

                for layer_id in layer_field_mapping:
                    layer = next((layer for layer in layers if layer['id'] == layer_id), None)
                    if layer:
                        _update_layer_fields(layer, layer_field_mapping[layer_id]) 
                        layer['fieldMapping'] = layer_field_mapping[layer_id]
                    else:
                        layer = {'id' : layer_id, 'fieldMapping' : layer_field_mapping[layer_id]}
                        is_table = next((table for table in feature_service.tables if table.properties.id == layer_id), None) is not None
                        if is_table:
                            if 'tables' not in data or data['tables'] is None:
                                data['tables'] = []
                            data['tables'].append(layer)
                        else:
                            if 'layers' not in data or data['layers'] is None:
                                data['layers'] = []
                            data['layers'].append(layer)
            
            # Update the layer id
            layers = []
            if data and 'layers' in data and data['layers'] is not None:
                layers += [layer for layer in data['layers']]
            if data and 'tables' in data and data['tables'] is not None:
                layers += [layer for layer in data['tables']]
            for layer in layers:   
                layer['id'] = layer_id_mapping[layer['id']]

            # Add GPS Metadata field infos to the pop-up of the layer
            if ADD_GPS_METADATA_FIELDS:
                gps_metadata_field_infos = gps_metadata['popup']
                for layer in layers:
                    field_infos = _deep_get(layer, 'popupInfo', 'fieldInfos')
                    if field_infos is not None:
                        fields = layer_fields[layer['id']]
                        field_names = [f['name'].lower() for f in fields]
                        field_info_names = [_deep_get(f, 'fieldName').lower() for f in field_infos]
                        for gps_metadata_field_info in gps_metadata_field_infos:
                            gps_field_name = gps_metadata_field_info['fieldName'].lower()
                            if gps_field_name in field_names and gps_field_name not in field_info_names:
                                i = field_names.index(gps_field_name)
                                gps_metadata_field_info['fieldName'] = fields[i]['name']
                                field_infos.append(gps_metadata_field_info)

            # Set the data to the text properties of the item
            if data:
                item_properties['text'] = json.dumps(data)

            # If the item title has a guid, check if it is in the item_mapping and replace if it is.
            guids = re.findall('[0-9A-F]{32}', item_properties['title'], re.IGNORECASE)
            for guid in guids:
                if guid in item_mapping['Group IDs']:
                    item_properties['title'] = item_properties['title'].replace(guid, item_mapping['Group IDs'][guid])
                elif guid in item_mapping['Item IDs']:
                    item_properties['title'] = item_properties['title'].replace(guid, item_mapping['Item IDs'][guid])

            # Update the item definition of the service
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item.update(item_properties=item_properties, thumbnail=thumbnail)

            # Check if tool has been canceled, raise exception with new_item so it can be cleaned up
            _check_cancel_status(new_item)
    
            # Copy features from original item
            if COPY_DATA and not self.is_view:
                self._add_features(new_layers, relationships, layer_field_mapping, feature_service.properties['spatialReference']['wkid'])

            return [new_item, layer_field_mapping, layer_id_mapping, layer_fields]
        except _CustomCancelException as ex:
            raise ex
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _WebMapDefinition(_TextItemDefinition):
    """
    Represents the definition of a web map within ArcGIS Online or Portal.
    """

    def clone(self, target, folder, item_mapping):  
        """Clone the web map in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the web map to
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.   
        """
    
        try:
            new_item = None
            original_item = self.info
        
            # Get the item properties from the original web map which will be applied when the new item is created
            item_properties = self._get_item_properties()

            # Swizzle the item ids and URLs of the feature layers and tables in the web map
            webmap_json = self.data

            layers = []
            feature_collections = []
            if 'operationalLayers' in webmap_json:
                layers += [layer for layer in webmap_json['operationalLayers'] if 'layerType' in layer and layer['layerType'] == "ArcGISFeatureLayer" and 'url' in layer]
                feature_collections += [layer for layer in webmap_json['operationalLayers'] if 'layerType' in layer and layer['layerType'] == "ArcGISFeatureLayer" and 'type' in layer and layer['type'] == "Feature Collection"]
            if 'tables' in webmap_json:
                layers += [table for table in webmap_json['tables'] if 'url' in table]

            gps_metadata_field_infos = json.loads(_GPS_METADATA_FIELDS)['popup']

            for layer in layers:
                feature_service_url = os.path.dirname(layer['url'])
                for original_url in item_mapping['Feature Services']:
                    if _compare_url(feature_service_url, original_url):
                        new_service = item_mapping['Feature Services'][original_url]
                        layer_id = int(os.path.basename(layer['url']))
                        new_id = new_service['layer_id_mapping'][layer_id]
                        layer['url'] = "{0}/{1}".format(new_service['url'], new_id)
                        layer['itemId'] = new_service['id']
                        if layer_id in new_service['layer_field_mapping']:
                            _update_layer_fields(layer, new_service['layer_field_mapping'][layer_id])
                        
                        # If layer contains gps metadata fields, but are not in the popup definition add them
                        if ADD_GPS_METADATA_FIELDS and new_id in new_service['layer_fields']:
                            fields = new_service['layer_fields'][new_id]
                            field_names = [f['name'].lower() for f in fields]
                            field_infos = _deep_get(layer, 'popupInfo', 'fieldInfos')
                            if field_infos is not None:
                                field_info_names = [_deep_get(f, 'fieldName').lower() for f in field_infos]
                                for gps_metadata_field_info in gps_metadata_field_infos:
                                    gps_field_name = gps_metadata_field_info['fieldName'].lower()
                                    if gps_field_name in field_names and gps_field_name not in field_info_names:
                                        i = field_names.index(gps_field_name)
                                        gps_metadata_field_info['fieldName'] = fields[i]['name']
                                        field_infos.append(gps_metadata_field_info)
                        break                

            for feature_collection in feature_collections:
                if 'itemId' in feature_collection and feature_collection['itemId'] is not None and feature_collection['itemId'] in item_mapping['Item IDs']:
                    feature_collection['itemId'] = item_mapping['Item IDs'][feature_collection['itemId']]

            # Change the basemap to the default basemap defined in the target organization
            if USE_DEFAULT_BASEMAP:
                properties = target.properties
                if 'defaultBasemap' in properties and properties['defaultBasemap'] is not None:
                    default_basemap = properties['defaultBasemap']
                    if 'title' in default_basemap and 'baseMapLayers' in default_basemap and default_basemap['baseMapLayers'] is not None:
                        for key in [k for k in default_basemap]:
                            if key not in ['title', 'baseMapLayers']:
                                del default_basemap[key]
                        for basemap_layer in default_basemap['baseMapLayers']:
                            if 'resourceInfo' in basemap_layer:
                                del basemap_layer['resourceInfo']
                        webmap_json['baseMap'] = default_basemap

            # Add the web map to the target portal
            item_properties['text'] = json.dumps(webmap_json)
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item = target.content.add(item_properties=item_properties, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _ApplicationDefinition(_TextItemDefinition):
    """
    Represents the definition of an application within ArcGIS Online or Portal.
    """
    
    def __init__(self, info, source_app_title=None, update_url=True, data=None, sharing=None, thumbnail=None, portal_item=None):
        self._source_app_title = source_app_title
        self._update_url = update_url
        super().__init__(info, data, sharing, thumbnail, portal_item)

    @property
    def source_app_title(self):
        """Gets the title of the application"""
        return self._source_app_title

    @property
    def update_url(self):
        """Gets a value indicating if the application url should be updated"""
        return self._update_url

    def clone(self, target, folder, item_mapping):
        """Clone the application in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the web map to
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.     
        """  
    
        try:
            new_item = None
            original_item = self.info
            org_url = _get_org_url(target)

            # Get the item properties from the original application which will be applied when the new item is created
            item_properties = self._get_item_properties()

            # Swizzle the item ids of the web maps, groups and URLs of defined in the application's data
            app_json = self.data
            if app_json is not None:
                app_json_text = ''
                
                # If item is a story map don't swizzle any of the json references
                if 'Story Map' in original_item['typeKeywords'] or 'Story Maps' in original_item['typeKeywords']:
                    app_json_text = json.dumps(app_json)

                else:
                    if "Web AppBuilder" in original_item['typeKeywords']: #Web AppBuilder
                        if 'portalUrl' in app_json:
                            app_json['portalUrl'] = org_url
                        if 'map' in app_json:
                            if 'portalUrl' in app_json['map']:
                                app_json['map']['portalUrl'] = org_url
                            if 'itemId' in app_json['map']:
                                app_json['map']['itemId'] = item_mapping['Item IDs'][app_json['map']['itemId']]
                            if 'mapOptions' in app_json['map'] and app_json['map']['mapOptions'] is not None:
                                if 'extent' in app_json['map']['mapOptions']:
                                    del app_json['map']['mapOptions']['extent']
                        if 'httpProxy' in app_json:
                            if 'url' in app_json['httpProxy']:
                                app_json['httpProxy']['url'] = org_url + "sharing/proxy"
                        if 'geometryService' in app_json and 'geometry' in target.properties['helperServices']:
                            app_json['geometryService'] = target.properties['helperServices']['geometry']['url']

                    elif original_item['type'] == "Operation View": #Operations Dashboard
                        if 'widgets' in app_json:
                            for widget in app_json['widgets']:
                                if widget['type'] == 'mapWidget':
                                    widget['mapId'] = item_mapping['Item IDs'][widget['mapId']]
                                    break

                    else: #Configurable Application Template
                        if 'folderId' in app_json:
                            app_json['folderId'] = _deep_get(folder, 'id')
                        if 'values' in app_json:
                            if 'group' in app_json['values']:
                                app_json['values']['group'] = item_mapping['Group IDs'][app_json['values']['group']]
                            if 'webmap' in app_json['values']:
                                app_json['values']['webmap'] = item_mapping['Item IDs'][app_json['values']['webmap']]
                        if self.source_app_title is not None:
                            search_query = 'title:"{0}" AND owner:{1} AND type:Web Mapping Application'.format(self.source_app_title, "esri_en") 
                            search_items = target.content.search(search_query, max_items=100, outside_org=True)
                            if len(search_items) > 0:
                                existing_item = max(search_items, key=lambda x: x['created'])
                                app_json['source'] = existing_item['id']

                    app_json_text = json.dumps(app_json)        
                    for original_url in item_mapping['Feature Services']:
                        service = item_mapping['Feature Services'][original_url]
                        for key, value in service['layer_id_mapping'].items():
                            app_json_text = re.sub("{0}/{1}".format(original_url, key), 
                                                   "{0}/{1}".format(service['url'], value),
                                                   app_json_text, 0, re.IGNORECASE)
                        app_json_text = re.sub(original_url, service['url'], app_json_text, 0, re.IGNORECASE)
                    for original_id in item_mapping['Item IDs']:
                        app_json_text = re.sub(original_id, item_mapping['Item IDs'][original_id], app_json_text, 0, re.IGNORECASE)

                    # Replace any references to default print service
                    new_print_url = _deep_get(target.properties, 'helperServices', 'printTask', 'url')
                    if new_print_url is not None:
                        old_print_url = 'https://utility.arcgisonline.com/arcgis/rest/services/Utilities/PrintingTools/GPServer/Export%20Web%20Map%20Task'
                        if self.portal_item is not None and _deep_get(self.portal_item._gis.properties, 'helperServices', 'printTask', 'url') is not None:
                            old_print_url = _deep_get(self.portal_item._gis.properties, 'helperServices', 'printTask', 'url')

                        app_json_text = re.sub(old_print_url, new_print_url, app_json_text, 0, re.IGNORECASE)
                        if old_print_url.startswith('https://'):
                            app_json_text = re.sub('http://' + old_print_url[8:], new_print_url, app_json_text, 0, re.IGNORECASE)
                        elif old_print_url.startswith('http://'):
                            app_json_text = re.sub('https://' + old_print_url[7:], new_print_url, app_json_text, 0, re.IGNORECASE)

                    # Perform a general find and replace of field names if field mapping is required
                    for service in item_mapping['Feature Services']:
                        for layer_id in item_mapping['Feature Services'][service]['layer_field_mapping']:
                            field_mapping = item_mapping['Feature Services'][service]['layer_field_mapping'][layer_id]
                            app_json_text = _find_and_replace_fields(app_json_text, field_mapping)

                item_properties['text'] = app_json_text

            # Add the application to the target portal
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item = target.content.add(item_properties=item_properties, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            # Update the url of the item to point to the new portal and new id of the application if required
            if original_item['url'] is not None:
                url = original_item['url']
                if self.update_url:
                    find_string = "/apps/"
                    index = original_item['url'].find(find_string)
                    url = '{0}{1}'.format(org_url.rstrip('/'), original_item['url'][index:])
                    find_string = "id="
                    index = url.find(find_string)
                    url = '{0}{1}'.format(url[:index + len(find_string)], new_item.id)
                item_properties = {'url' : url}
                new_item.update(item_properties)

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _FormDefinition(_ItemDefinition):
    """
    Represents the definition of an form within ArcGIS Online or Portal.
    """
    def __init__(self, info, related_items, data=None, sharing=None, thumbnail=None, portal_item=None):
        self._related_items = related_items
        super().__init__(info, data, sharing, thumbnail, portal_item)

    @property
    def related_items(self):
        """Gets the related items for the survey"""
        return self._related_items

    def clone(self, target, folder, item_mapping):
        """Clone the form in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the form to
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.     
        """
        try: 
            new_item = None
            original_item = self.info

            # Get the item properties from the original item to be applied when the new item is created
            item_properties = self._get_item_properties()

            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)

                # Add the new item
                new_item = target.content.add(item_properties=item_properties, data=None, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))
            return [new_item]
            
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

    def update_form(self, target, new_item, item_mapping):
        """Update the form with form zip data in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to update the item
        new_item - The form item to update
        item_mapping - Dictionary containing mapping between new and old items.     
        """
        
        original_item = self.info
        with tempfile.TemporaryDirectory() as temp_dir:
            form_zip = self.portal_item.download(temp_dir)
            zip_file = zipfile.ZipFile(form_zip)

            try:
                # Extract the zip archive to a sub folder
                new_dir = os.path.join(temp_dir, 'extract')
                zip_dir = os.path.join(new_dir, 'esriinfo')
                
                zip_file.extractall(new_dir)
                zip_file.close()
                
                feature_service_url = None
                form_json = None

                # Loop through the files and update references to the feature service and item id
                for path in os.listdir(zip_dir):
                    if os.path.splitext(path)[1].lower() == '.info':
                        with open(os.path.join(zip_dir, path), 'r') as file:
                            data = json.loads(file.read())

                        original_url = data['serviceInfo']['url']
                        for key, value in item_mapping['Feature Services'].items():
                            if _compare_url(original_url, key):
                                data['serviceInfo']['itemId'] = value['id']
                                data['serviceInfo']['url'] = value['url']
                                feature_service_url = value['url']
                                break

                        with open(os.path.join(zip_dir, path), 'w') as file:
                            file.write(json.dumps(data))

                    elif os.path.splitext(path)[1].lower() == '.xml' or path.lower() == 'webform.json':
                        with open(os.path.join(zip_dir, path), 'r') as file:
                            data = file.read()

                        data = data.replace(original_item['id'], new_item['id'])
                        for key, value in item_mapping['Feature Services'].items():
                            data = re.sub(key, value['url'], data, 0, re.IGNORECASE)

                        with open(os.path.join(zip_dir, path), 'w') as file:
                            file.write(data)

                    elif os.path.splitext(path)[1].lower() == '.iteminfo':
                        with open(os.path.join(zip_dir, path), 'w') as file:
                            file.write(json.dumps(dict(new_item)))

                    elif path.lower() == 'form.json':
                        with open(os.path.join(zip_dir, path), 'r') as file:
                            form_json = file.read()

                    elif os.path.splitext(path)[1].lower() == '.xlsx':
                        xlsx = zipfile.ZipFile(os.path.join(zip_dir, path))
                        xlsx_dir = os.path.join(zip_dir, 'xlsx')
                        try:
                            xlsx.extractall(xlsx_dir)
                            xlsx.close()

                            with open(os.path.join(xlsx_dir, 'xl/sharedStrings.xml'), 'r') as file:
                                data = file.read()

                            for key, value in item_mapping['Feature Services'].items():
                                data = re.sub(key, value['url'], data, 0, re.IGNORECASE)

                            with open(os.path.join(xlsx_dir, 'xl/sharedStrings.xml'), 'w') as file:
                                file.write(data)

                            xlsx = zipfile.ZipFile(os.path.join(zip_dir, path), 'w', zipfile.ZIP_DEFLATED)
                            _zip_dir(xlsx_dir, xlsx, False)
                        except Exception:
                            continue
                        finally:         
                            xlsx.close()
                            if os.path.exists(xlsx_dir):
                                shutil.rmtree(xlsx_dir)

                # Add a relationship between the new survey and the service
                for related_item in self.related_items:
                    for key, value in item_mapping['Feature Services'].items():
                        if _compare_url(related_item['url'], key):
                            feature_service = target.content.get(value['id'])
                            _add_relationship(new_item, feature_service, 'Survey2Service')
                            break

                # If the survey was authored on the web add the web_json to the metadata table in the service
                if form_json is not None and feature_service_url is not None:
                    svc = FeatureLayerCollection(feature_service_url, target)
                    table = next((t for t in svc.tables if t.properties.name == 'metadata'), None)
                    if table is not None:
                        deletes = table.query(where="name = 'form'")
                        table.edit_features(adds=[{'attributes' : {'name' : 'form', 'value' : form_json}}], deletes=deletes)

                # Zip the directory
                zip_file = zipfile.ZipFile(form_zip, 'w', zipfile.ZIP_DEFLATED)
                _zip_dir(zip_dir, zip_file)
                zip_file.close()

                # Upload the zip to the item
                new_item.update(data=form_zip)
            except Exception as ex:
                raise Exception("Failed to update {0} {1}: {2}".format(new_item['type'], new_item['title'], str(ex)))
            finally:         
                zip_file.close()

class _WorkforceProjectDefinition(_TextItemDefinition):
    """
    Represents the definition of an workforce project within ArcGIS Online or Portal.
    """

    def clone(self, target, folder, item_mapping):
        """Clone the form in the target organization.
        Keyword arguments:
        target - The instance of arcgis.gis.GIS (the portal) to clone the workforce project to
        folder - The folder to create the item in
        item_mapping - Dictionary containing mapping between new and old items.     
        """  

        try:
            new_item = None
            original_item = self.info

            # Get the item properties from the original application which will be applied when the new item is created
            item_properties = self._get_item_properties()
            workforce_json = self.data
            
            # Update the webmap references
            webmaps = ['workerWebMapId', 'dispatcherWebMapId']
            for webmap in webmaps:
                original_id = _deep_get(workforce_json, webmap)
                if original_id is not None and original_id in item_mapping['Item IDs']:
                    workforce_json[webmap] = item_mapping['Item IDs'][original_id]

            # Update the service references
            services = ['dispatchers', 'assignments', 'workers', 'tracks']
            for service in services:
                service_definiton = _deep_get(workforce_json, service)
                if service_definiton is not None:
                    layer_url = _deep_get(service_definiton, 'url')
                    feature_service_url = os.path.dirname(layer_url)
                    for key, value in item_mapping['Feature Services'].items():
                        if _compare_url(feature_service_url, key):
                            layer_id = int(os.path.basename(layer_url))
                            new_id = value['layer_id_mapping'][layer_id]
                            service_definiton['url'] = "{0}/{1}".format(value['url'], new_id)
                            service_definiton['serviceItemId'] = value['id']

                            if service == 'dispatchers':
                                feature_layer = FeatureLayer(service_definiton['url'], target)
                                user = target.users.me
                                features = feature_layer.query("userId = '{0}'".format(user.username)).features
                                if len(features) == 0:
                                    features = [{"attributes" : {"name" : user.fullName, "userId" : user.username}}]
                                    feature_layer.edit_features(adds=features)
                            break

            # Update the group reference
            group_id = _deep_get(workforce_json, 'groupId')
            workforce_json['groupId'] = item_mapping['Group IDs'][group_id]

            # Update the folder reference
            workforce_json['folderId'] = folder['id']

            # Update the application integration references
            integrations = _deep_get(workforce_json, 'assignmentIntegrations')
            if integrations is not None:
                for integration in integrations:
                    url_template = _deep_get(integration, 'urlTemplate')
                    if url_template is not None:
                        item_references = re.findall('itemID=[0-9A-F]{32}', url_template, re.IGNORECASE)
                        for item_reference in item_references:
                            item_id = item_reference[7:]
                            if item_id in item_mapping['Item IDs']:
                                integration['urlTemplate'] = url_template.replace(item_id, item_mapping['Item IDs'][item_id])

            # Add the project to the target portal
            item_properties['text'] = json.dumps(workforce_json)
            with tempfile.TemporaryDirectory() as temp_dir:
                thumbnail = self.thumbnail
                if not thumbnail and self.portal_item:
                    thumbnail = self.portal_item.download_thumbnail(temp_dir)
                new_item = target.content.add(item_properties=item_properties, thumbnail=thumbnail, folder=_deep_get(folder, 'title'))

            return [new_item]
        except Exception as ex:
            raise _ItemCreateException("Failed to create {0} {1}: {2}".format(original_item['type'], original_item['title'], str(ex)), new_item)

class _ItemCreateException(Exception):
    """
    Exception raised during the creation of new items, used to clean-up any partially created items in the process.
    """
    pass

class _CustomCancelException(Exception):
    """Custom exception for geoprocessing tool cancellations"""
    pass

#endregion

#region Public API Functions

def clone(target, item, folder_name=None, existing_items=[]):
    """Clone an item to a portal. If a web map or application is passed in, all services and groups that support the application or web map will also be cloned.
    Keyword arguments:
    target - The instance of arcgis.gis.GIS (the organization) to clone the items to.
    item - The arcgis.GIS.Item to clone.
    folder_name - The name of the folder to clone the new items to. If the folder does not already exist it will be created.
    existing_items - A collection of items already cloned that should be reused rather than creating a new version of the item in the org. 
                     These items are used first before searching the org if the SEARCH_ORG_FOR_EXISTING_ITEMS variable is set to true.
    """  
    item_mapping = {'Item IDs' : {}, 'Group IDs' : {}, 'Feature Services' : {}}
    created_items = []

    try:
        # Check if the item has already been cloned into the target portal
        existing_item = _get_existing_item(existing_items, item)
        if SEARCH_ORG_FOR_EXISTING_ITEMS and existing_item is None:
            existing_item = _search_org_for_existing_item(target, item)
        
        if existing_item is not None:
            _add_message("{0} already exists in Organization".format(item['title']))
            _add_message("New item id: {0}".format(existing_item['id']))
            _add_message('------------------------')
            return created_items
        
        user = target.users.me
        folder = None
        if folder_name is not None:       
            folders = user.folders
            folder = next((f for f in folders if f['title'].lower() == folder_name.lower()), None)
            if folder is None:
                folder = target.content.create_folder(folder_name)

        # Check if the tool has been cancelled before fetching item definitions
        _check_cancel_status()

        # Get the definitions associated with the item
        item_definitions = []
        _get_item_definitions(item, item_definitions)      
        item_definitions = sorted(item_definitions, key=_sort_item_types)

        # Test if the user has the correct privileges to create the items requested
        if 'privileges' in user and user['privileges'] is not None:
            privileges = user.privileges
            for item_definition in item_definitions:
                if isinstance(item_definition, _ItemDefinition):
                    if 'portal:user:createItem' not in privileges:
                        raise Exception("To create this item you must have permission to create new content in the target organization.")

                if isinstance(item_definition, _GroupDefinition):
                    if 'portal:user:createGroup' not in privileges or 'portal:user:shareToGroup' not in privileges:
                        raise Exception("To create this item you must have permission to create new groups and share content to groups in the target organization.")

                if isinstance(item_definition, _FeatureServiceDefinition):
                    if 'portal:publisher:publishFeatures' not in privileges:
                        raise Exception("To create this item you must have permission to publish hosted feature layers in the target organization.")

        # Clone the groups
        for group in [g for g in item_definitions if isinstance(g, _GroupDefinition)]:
            _check_cancel_status()
            item_definitions.remove(group)
            original_group = group.info
            
            new_group = _get_existing_item(existing_items, original_group, "Group")
            if SEARCH_ORG_FOR_EXISTING_ITEMS and new_group is None:
                new_group = _search_for_existing_group(user, original_group)
            
            if not new_group:
                new_group = group.clone(target)
                created_items.append(new_group)
                _add_message("Created Group {0}".format(new_group['title']))
            else:
                _add_message("Existing Group {0} found in Organization".format(new_group['title']))
            item_mapping['Group IDs'][original_group['id']] = new_group['id']

        # Clone the items
        for item_definition in item_definitions:
            _check_cancel_status()
            original_item = item_definition.info
            new_item_created = False
            result = []

            new_item = _get_existing_item(existing_items, original_item)
            if SEARCH_ORG_FOR_EXISTING_ITEMS and new_item is None:
                new_item = _search_org_for_existing_item(target, original_item)

            if not new_item:                   
                result = item_definition.clone(target, folder, item_mapping)
                new_item = result[0]
                new_item_created = True
                created_items.append(new_item)
                _add_message("Created {0} {1}".format(new_item['type'], new_item['title']))   
            else:
                _add_message("Existing {0} {1} found in Organization".format(original_item['type'], original_item['title']))  
            if new_item['owner'] == user['username']:
                _share_item_with_groups(new_item, item_definition.sharing, item_mapping['Group IDs'])
            item_mapping['Item IDs'][original_item['id']] = new_item['id']   
            
            if isinstance(item_definition, _ApplicationDefinition):
                # With Portal sometimes after sharing the application the url is reset.
                # Check if the url is incorrect after sharing and set back to correct url.
                if 'url' in new_item and new_item['url'] is not None:
                    url = new_item['url']
                    new_item = target.content.get(new_item['id'])
                    if new_item['url'] != url:
                        new_item.update({'url' : url})
             
            if isinstance(item_definition, _FeatureServiceDefinition):
                # Need to handle Feature Services specially as their layer ids and fields names can
                # change during creation. Especially when going from Online to Portal
                layer_field_mapping = {}
                layer_id_mapping = {}
                layer_fields = {}

                if not new_item_created:
                    new_feature_service = FeatureLayerCollection.fromitem(new_item)    
                    new_layers = new_feature_service.layers + new_feature_service.tables
                    for new_layer in new_layers:
                        layer_fields[new_layer.properties.id] = new_layer.properties.fields
                                     
                    original_layers_definition = item_definition.layers_definition
                    original_layers = original_layers_definition['layers'] + original_layers_definition['tables']
                    if len(new_layers) == len(original_layers):
                        i = 0
                        for layer in original_layers:
                            layer_id_mapping[layer['id']] = new_layers[i].properties['id']
                            i += 1

                        # Get any layer field mapping saved with the feature service
                        data = new_item.get_data()
                        layers = []
                        if 'layers' in data and data['layers'] is not None:
                            layers += [layer for layer in data['layers']]
                        if 'tables' in data and data['tables'] is not None:
                            layers += [layer for layer in data['tables']]
                        for layer in layers:
                            if 'fieldMapping' in layer:
                                for key, value in layer_id_mapping.items():
                                    if value == layer['id']:
                                        layer_field_mapping[key] = layer['fieldMapping']
                                        break
                else:
                    layer_field_mapping = result[1]
                    layer_id_mapping = result[2]  
                    layer_fields = result[3]
                item_mapping['Feature Services'][original_item['url']] = {'id' : new_item['id'], 'url' : new_item['url'], 'layer_field_mapping' : layer_field_mapping, 'layer_id_mapping' : layer_id_mapping, 'layer_fields' : layer_fields}           

        # Update form data
        for form in [i for i in item_definitions if isinstance(i, _FormDefinition)]:
            _check_cancel_status()
            original_item = form.info
            new_item = _get_existing_item(created_items, original_item)           
            
            if new_item is not None:
                form.update_form(target, new_item, item_mapping)
                _add_message("Updated Form {0}".format(new_item['title']))

        existing_item = _search_org_for_existing_item(target, item)
        
        _add_message('Successfully added {0}'.format(item['title']))
        if existing_item:
            _add_message("New item id: {0}".format(existing_item['id']))
        _add_message('------------------------')
        return created_items

    except Exception as ex:
        if isinstance(ex, _ItemCreateException):
            _add_message(ex.args[0], 'Error')
            if isinstance(ex.args[1], (gis.Item, gis.Group)):
                created_items.append(ex.args[1])
        elif isinstance(ex, _CustomCancelException):
            if len(ex.args) > 0 and isinstance(ex.args[0], (gis.Item, gis.Group)):
                created_items.append(ex.args[0])
            _add_message("{0} canceled".format(item['title']), 'Error')
        else:
            _add_message(str(ex), 'Error')

        for created_item in reversed(created_items):
            try:
                if created_item is not None:
                    if created_item.delete():
                        if isinstance(created_item, gis.Group):
                            created_item['type'] = 'Group'
                        _add_message("Deleted {0} {1}".format(created_item['type'], created_item['title']))
            except Exception:
                continue
                
        _add_message('Failed to add {0}'.format(item['title']), 'Error')
        _add_message('------------------------')
        return []

#endregion

#region Private API Functions

def _get_item_definitions(item, item_definitions):
    """" Get a list of definitions for the specified item. 
    This method differs from get_item_definition in that it is run recursively to return the definitions of feature service items that make up a webmap and the groups and webmaps that make up an application.
    These definitions can be used to clone or download the items.
    Keyword arguments:
    item - The arcgis.GIS.Item to get the definition for
    item_definitions - A list of item and group definitions. When first called this should be an empty list that you hold a reference to and all definitions related to the item will be appended to the list.
    """  

    item_definition = None
    source = item._gis

    # Check if the item definition has already been added to the collection of item definitions
    item_definition = next((i for i in item_definitions if i.info['id'] == item.id), None)
    if item_definition:
        return item_definition

    # if the item is a group find all the web maps that are shared with the group
    if isinstance(item, gis.Group):
        item_definition = _get_group_definition(item)
        item_definitions.append(item_definition)
        group_id = item['id']
                    
        search_query = 'group:{0}'.format(group_id)
        group_items = source.content.search(search_query, max_items=1000)
        for group_item in group_items:
            item_definition = _get_item_definitions(group_item, item_definitions)
            if item_definition is not None:
                item_definition.sharing['groups'].append(group_id)

    # If the item is an application or dashboard find the web map or group that the application referencing
    elif item['type'] in ['Web Mapping Application', 'Operation View']:
        item_definition = _get_item_definition(item)
        item_definitions.append(item_definition)
   
        webmap_id = None
        app_json = item_definition.data 
        if app_json is not None:     
            if 'Story Map' in item['typeKeywords'] or 'Story Maps' in item['typeKeywords']:
                webmap_id = None

            elif item['type'].lower() == "operation view": #Operations Dashboard
                if 'widgets' in app_json:
                    for widget in app_json['widgets']:
                        if widget['type'] == 'mapWidget':
                            webmap_id = widget['mapId']
                            break

            elif "Web AppBuilder" in item['typeKeywords']: #Web AppBuilder
                if 'map' in app_json:
                    if 'itemId' in app_json['map']:
                        webmap_id = app_json['map']['itemId']

            else: #Configurable Application Template
                if 'values' in app_json:
                    if 'group' in app_json['values']:
                        group_id = app_json['values']['group']
                        try:
                            group = source.groups.get(group_id)
                        except RuntimeError:
                            _add_message("Failed to get group {0}".format(group_id), 'Error')
                            raise
                        _get_item_definitions(group, item_definitions)

                    if 'webmap' in app_json['values']:
                        webmap_id = app_json['values']['webmap']
        
        if webmap_id:
            try:
                webmap = source.content.get(webmap_id)
            except RuntimeError:
                _add_message("Failed to get web map {0}".format(webmap_id), 'Error')
                raise
            _get_item_definitions(webmap, item_definitions)

    # If the item is a web map find all the feature service layers and tables that make up the map
    elif item['type'] == 'Web Map':
        item_definition = _get_item_definition(item)
        item_definitions.append(item_definition)
        
        webmap_json = item_definition.data
        featurelayer_services = []
        feature_collections = []

        if 'operationalLayers' in webmap_json:
            featurelayer_services += [layer for layer in webmap_json['operationalLayers'] if 'layerType' in layer and layer['layerType'] == "ArcGISFeatureLayer" and 'url' in layer and layer['url'] is not None and ('type' not in layer or layer['type'] != "Feature Collection")]
            feature_collections += [layer for layer in webmap_json['operationalLayers'] if 'layerType' in layer and layer['layerType'] == "ArcGISFeatureLayer" and 'type' in layer and layer['type'] == "Feature Collection"]
        if 'tables' in webmap_json:
            featurelayer_services += [table for table in webmap_json['tables'] if 'url' in table]

        for layer in featurelayer_services:
            service_url = os.path.dirname(layer['url'])
            feature_service = next((definition for definition in item_definitions if 'url' in definition.info and definition.info['url'] == service_url), None)
            if not feature_service:
                try:
                    service = FeatureLayerCollection(service_url, source)               
                except Exception:
                    _add_message("Feature layer {0} is not a hosted feature service. It will not be cloned.".format(service_url), 'Warning')
                    continue

                if 'serviceItemId' not in service.properties or service.properties['serviceItemId'] is None:
                    _add_message("Feature layer {0} is not a hosted feature service. It will not be cloned.".format(service_url), 'Warning')
                    continue

                try:
                    item_id = service.properties['serviceItemId']
                    feature_service = source.content.get(item_id)
                except RuntimeError:
                    _add_message("Failed to get feature service item {0}".format(item_id), 'Error')
                    raise
                _get_item_definitions(feature_service, item_definitions)

        for feature_collection in feature_collections:
            if 'itemId' in feature_collection and feature_collection['itemId'] is not None:
                feature_collection = source.content.get(feature_collection['itemId'])
                _get_item_definitions(feature_collection, item_definitions)

    # If the item is a feature service determine if it is a view and if it is find all it's sources
    elif item['type'] == 'Feature Service':
        svc = FeatureLayerCollection.fromitem(item)
        service_definition = dict(svc.properties)

        is_view = False
        if "isView" in service_definition and service_definition["isView"] is not None:
            is_view = service_definition["isView"]

        # Get the definitions of the the layers and tables
        layers_definition = {'layers' : [], 'tables' : []}
        for layer in svc.layers:
            layers_definition['layers'].append(dict(layer.properties))
        for table in svc.tables:
            layers_definition['tables'].append(dict(table.properties))

        # Get the item data, for example any popup definition associated with the item
        data = item.get_data()

        # Process the feature service if it is a view
        view_sources = {}
        view_source_fields = {}
        if is_view:
            try:
                multiple_source_error = "Views based on multiple source layers are not supported."
                sources = source._portal.con.get(svc.url + '/sources')
                if len(sources['services']) != 1:
                    raise Exception(multiple_source_error)
                source_service = sources['services'][0]
                source_item = source.content.get(source_service['serviceItemId'])
                _get_item_definitions(source_item, item_definitions)

                for layer in svc.layers + svc.tables:
                    layer_sources = source._portal.con.get(svc.url + '/' + str(layer.properties['id']) + '/sources')
                    layer_source = None
                    if 'layers' in layer_sources and len(layer_sources['layers']) == 1:
                        layer_source = layer_sources['layers'][0]
                    elif 'tables' in layer_sources and len(layer_sources['tables']) == 1:
                        layer_source = layer_sources['tables'][0]
                    else:
                        raise Exception(multiple_source_error)
                    view_sources[layer.properties['id']] = layer_source['url']
                    view_source_fields[layer.properties['id']] = layer.properties.fields
            except RuntimeError:
                _add_message("Failed to get feature layer view and its sources {0}".format(item['id']), 'Error')
                raise

        item_definition = _FeatureServiceDefinition(dict(item), service_definition, layers_definition, is_view, view_sources, view_source_fields, features=None, data=data, thumbnail=None, portal_item=item)
        item_definitions.append(item_definition)

    # If the item is a workforce find the group, maps and services that support the project
    elif item['type'] == 'Workforce Project':
        workforce_json = item.get_data()
        
        # Workforce group
        group_id = _deep_get(workforce_json, 'groupId')
        group = source.groups.get(group_id)
        item_definition = _get_group_definition(group)
        item_definitions.append(item_definition)

        # Process the services
        services = ['dispatchers', 'assignments', 'workers', 'tracks']
        for service in services:
            item_id = _deep_get(workforce_json, service, 'serviceItemId')
            if item_id is not None:
                service_item = source.content.get(item_id)
                item_definition = _get_item_definitions(service_item, item_definitions)
                item_definition.sharing['groups'].append(group_id)

        # Process the web maps
        web_maps = ['workerWebMapId', 'dispatcherWebMapId']
        for web_map in web_maps:
            item_id = _deep_get(workforce_json, web_map)
            if item_id is not None:
                web_map_item = source.content.get(item_id)
                item_definition = _get_item_definitions(web_map_item, item_definitions)
                item_definition.sharing['groups'].append(group_id)

        # Handle any app integrations
        integrations = _deep_get(workforce_json, 'assignmentIntegrations')
        if integrations is not None:
            for integration in integrations:
                url_template = _deep_get(integration, 'urlTemplate')
                if url_template is not None:
                    item_ids = re.findall('itemID=[0-9A-F]{32}', url_template, re.IGNORECASE)
                    for item_id in item_ids:
                        integration_item = source.content.get(item_id[7:])
                        _get_item_definitions(integration_item, item_definitions)

        item_definition = _get_item_definition(item)
        item_definition.sharing['groups'].append(group_id)
        item_definitions.append(item_definition)

    # If the item is a form find the feature service that supports it
    elif item['type'] == 'Form':
        item_definition = _get_item_definition(item)
        item_definitions.append(item_definition)

        for related_item in item_definition.related_items:
            _get_item_definitions(source.content.get(related_item['id']), item_definitions)

    # All other types we no longer need to recursively look for related items
    else:
        item_definition = _get_item_definition(item)
        item_definitions.append(item_definition)

    return item_definition

def _get_group_definition(group):
    """Get an instance of the group definition for the specified item. This definition can be used to clone or download the group.
    Keyword arguments:
    group - The arcgis.GIS.Group to get the definition for.""" 
    return _GroupDefinition(dict(group), thumbnail=None, portal_group=group)

def _get_item_definition(item):
    """Get an instance of the corresponding definition class for the specified item. This definition can be used to clone or download the item.
    Keyword arguments:
    item - The arcgis.GIS.Item to get the definition for.
    """  
       
    # If the item is an application or dashboard get the ApplicationDefinition
    if item['type'] in ['Web Mapping Application', 'Operation View']:
        app_json = None
        source_app_title = None
        update_url = False
        
        try:
            app_json = item.get_data()
        except Exception:
            pass # item doesn't have json data

        if app_json is not None:
            update_url = True
            if "Web AppBuilder" not in item['typeKeywords'] and item['type'] != 'Operation View' and 'source' in app_json:
                try:
                    source = item._gis
                    source_id = app_json['source']
                    app_item = source.content.get(source_id)
                    if app_item is not None:
                        source_app_title = app_item['title']
                except Exception:
                    pass

        return _ApplicationDefinition(dict(item), source_app_title=source_app_title, update_url=update_url, data=app_json, thumbnail=None, portal_item=item)
      
    # If the item is a web map get the WebMapDefintion
    elif item['type'] == 'Web Map':
        webmap_json = item.get_data()
        return _WebMapDefinition(dict(item), data=webmap_json, thumbnail=None, portal_item=item)

    # If the item is a workforce project get the WorkforceProjectDefintion
    elif item['type'] == 'Workforce Project':
        workforce_json = item.get_data()
        return _WorkforceProjectDefinition(dict(item), data=workforce_json, thumbnail=None, portal_item=item)

    # If the item is a workforce project get the WorkforceProjectDefintion
    elif item['type'] == 'Form':
        related_items = _get_related_items(item, 'Survey2Service')
        return _FormDefinition(dict(item), related_items=related_items, data=None, thumbnail=None, portal_item=item)

    # If the item is a feature service get the FeatureServiceDefintion
    elif item['type'] == 'Feature Service':
        svc = FeatureLayerCollection.fromitem(item)
        service_definition = dict(svc.properties)

        # Get the definitions of the the layers and tables
        layers_definition = {'layers' : [], 'tables' : []}
        for layer in svc.layers:
            layers_definition['layers'].append(dict(layer.properties))
        for table in svc.tables:
            layers_definition['tables'].append(dict(table.properties))
        
        # Get the item data, for example any popup definition associated with the item
        data = item.get_data()

        return _FeatureServiceDefinition(dict(item), service_definition, layers_definition, features=None, data=data, thumbnail=None, portal_item=item)

    # If the item is a feature collection get the FeatureCollectionDefintion
    elif item['type'] == 'Feature Collection':
        return _FeatureCollectionDefinition(dict(item), data=item.get_data(), thumbnail=None, portal_item=item)

    # For all other types get the corresponding definition
    else:
        if item['type'] in _TEXT_BASED_ITEM_TYPES:
            return _TextItemDefinition(dict(item), data=item.get_data(), thumbnail=None, portal_item=item)
        return _ItemDefinition(dict(item), data=None, thumbnail=None, portal_item=item)

def _add_message(message, message_type='Info'):
    """Add a message to the output"""
    try:
        import arcpy
        if message_type == 'Info':
            arcpy.AddMessage(message)
        elif message_type == 'Warning':
            arcpy.AddWarning(message)
        elif message_type == 'Error':
            arcpy.AddError(message)
    except ImportError:
        print(message)

def _get_extent_definition(extent):
    """Get the extent definition for the feature service based on the user specified extent and spatial reference. 
    This function required the arcpy module to project the specified or default extent into the specified spatial reference.
    If the module is not availble or if neither the ITEM_EXTENT or SPATIAL_REFERENCE are specified the default service extent will be returned.
    extent - The json representation of an extent.""" 
    
    try:
        if ITEM_EXTENT is None and SPATIAL_REFERENCE is None:
            return extent

        import arcpy
        wkid = extent['spatialReference']['wkid']
        if SPATIAL_REFERENCE is not None:
            wkid = SPATIAL_REFERENCE

        if ITEM_EXTENT is not None:
            item_extent = ITEM_EXTENT.split(",")
            extent = {"xmin" : item_extent[0], "ymin" : item_extent[1], "xmax" : item_extent[2], "ymax" : item_extent[3], "spatialReference" : {'wkid': 4326}}

        coordinates = [[extent['xmin'], extent['ymin']], 
                       [extent['xmax'], extent['ymin']], 
                       [extent['xmax'], extent['ymax']], 
                       [extent['xmin'], extent['ymax']], 
                       [extent['xmin'], extent['ymin']]]
        polygon = arcpy.Polygon(arcpy.Array([arcpy.Point(*coords) for coords in coordinates]), arcpy.SpatialReference(extent['spatialReference']['wkid']))
        new_extent = polygon.extent.projectAs(arcpy.SpatialReference(wkid))
        extent = {"xmin" : new_extent.XMin, "ymin" : new_extent.YMin, "xmax" : new_extent.XMax, "ymax" : new_extent.YMax, "spatialReference" : {'wkid': wkid}}

    except ImportError:
        pass

    return extent

def _search_org_for_existing_item(target, item):
    """Test if an item with a given source tag already exists in the collection of items within a given folder. 
    This is used to determine if the item has already been cloned in the folder.
    Keyword arguments:
    target - The portal that items will be cloned to.
    item - The original item used to determine if it has already been cloned to the specified folder."""  
   
    search_query = 'typekeywords:source-{0}'.format(item['id']) 
    items = target.content.search(search_query, max_items=100, outside_org=False)
    existing_item = None
    if len(items) > 0:
        existing_item = max(items, key=lambda x: x['created'])
    return existing_item

def _search_for_existing_group(user, group):
    """Test if a group with a given source tag that the user is a member of already exists in the organization. 
    This is used to determine if the group has already been created and if new maps and apps that belong to the same group should be shared to the same group.
    Keyword arguments:
    user - The gis.User to search through their group membership.
    group - The original group used to determine if it has already been cloned in the organization.""" 
    
    existing_group = None
    if 'groups' in user and user['groups'] is not None:
        groups = [g for g in user['groups'] if "source-{0}".format(group['id']) in g['tags']]
        if len(groups) > 0:
            existing_group = max(groups, key=lambda x: x['created'])
    return existing_group

def _get_existing_item(existing_items, item, item_type="Item"):
    """Find the cloned item from a list of items.
    Keyword arguments:
    existing_items - The list of items to search through to find if the item has already been cloned.
    item - The original item to be cloned.
    type - The type of item being search, options are 'Item' or 'Group'"""

    if item_type == "Item":
        for existing_item in [i for i in existing_items if isinstance(i, gis.Item)]:
            if existing_item['type'] == item['type']:
                for keyword in existing_item['typeKeywords']:
                    if keyword == "source-{0}".format(item['id']):
                        return existing_item
    elif item_type == "Group":
        for existing_group in [i for i in existing_items if isinstance(i, gis.Group)]:
            for tag in existing_group['tags']:
                if tag == "source-{0}".format(item['id']):
                    return existing_group
    return None

def _share_item_with_groups(item, sharing, group_mapping):
    """Share the new item using the sharing properties of original item and group mapping.
    Keyword arguments:
    item - The item to share
    sharing - the sharing properties of the original item
    group_mapping - A dictionary containing the id of the original group and the id of the new group"""
    
    if sharing:
        groups = []
        for group in sharing['groups']:
            if group in group_mapping:
                groups.append(group_mapping[group])
        if len(groups) == 0:
            return
        
        everyone = False
        org = False
        if 'access' in item and item['access'] is not None:
            everyone = item['access'] == 'public'
            org = item['access'] == 'org'        
        item.share(everyone, org, ','.join(groups))

def _create_service(target, service_type, create_params, is_view, folder):
    """Create a new service.
    Keyword arguments:
    target - The instance of arcgis.gis.GIS (the portal) to create the service
    service_type - The type of service
    create_params - The service parameters
    is_view - Indicates if the service should be a view
    folder - the folder to create the service in"""
    
    portal = target._portal
    postdata = portal._postdata()
    owner = portal.logged_in_user()['username']

    # Setup the item path, including the folder, and post to it
    path = 'content/users/' + owner
    if folder and folder != '/':
        folder_id = portal.get_folder_id(owner, folder)
        path += '/' + folder_id
    path += '/createService'

    postdata['createParameters'] = json.dumps(create_params)
    postdata['outputType'] = service_type
    postdata['isView'] = is_view

    resp = portal.con.post(path, postdata)
    if resp and resp.get('success'):
        return target.content.get(resp['itemId'])
    return None

def _get_related_items(item, rel_type, direction="forward"):
    """Get the related items for a given item.
    Keyword arguments:
    item - The item to get the relates for
    rel_type - The relationship type
    direction - The direction of the relationship"""

    source = item._gis
    related_items = []

    postdata = {'f' : 'json'}
    postdata['relationshipType'] = rel_type
    postdata['direction'] = direction
    resp = source._portal.con.post('content/items/' + item.id + '/relatedItems', postdata)
    for related_item in resp['relatedItems']:
        related_items.append(source.content.get(related_item['id']))
    return related_items

def _add_relationship(origin_item, destination_item, rel_type):
    """Add a relationship to an item.
    Keyword arguments:
    origin_item - The origin item
    destination_item - The destination item
    rel_type - The relationship type"""

    postdata = {'f' : 'json'}
    postdata['originItemId'] = origin_item.id
    postdata['destinationItemId'] = destination_item.id
    postdata['relationshipType'] = rel_type
    path = 'content/users/' + origin_item.owner
    path += '/addRelationship'
    origin_item._gis._portal.con.post(path, postdata)

def _get_org_url(target):
    """Gets the url of the portal/org
    Keyword arguments:
    target - The portal/org to get the url for."""   
    
    org_url = target._portal.url
    properties = target.properties
    
    scheme = 'http'
    if 'allSSL' in properties and properties['allSSL']:
        scheme = 'https'
    if 'urlKey' in properties and 'customBaseUrl' in properties:
        org_url = "{0}://{1}.{2}/".format(scheme, properties['urlKey'], properties['customBaseUrl'])
    else:
        url = urlparse(org_url)
        org_url = org_url.replace(url.scheme, scheme)
    return org_url

def _compare_url(url1, url2):
    """Compare two URLs ignoring scheme
    Keyword arguments:
    url1 - The first url
    url2 - The second url"""   

    url_parse1 = urlparse(url1)
    url_parse2 = urlparse(url2)
    return "{0}{1}".format(url_parse1.netloc.lower(), url_parse1.path.lower()) == "{0}{1}".format(url_parse2.netloc.lower(), url_parse2.path.lower())

def _sort_item_types(item_definition):
    """Sort the item definitions in the order that items need to be cloned.
    Keyword arguments:
    item_definition - The item definition to determine its sort order"""
       
    order = 0
    if isinstance(item_definition, _FormDefinition):
        order = 0
    elif isinstance(item_definition, _FeatureServiceDefinition) and not item_definition.is_view:
        order = 1
    elif isinstance(item_definition, _FeatureServiceDefinition) and item_definition.is_view:
        order = 2
    elif isinstance(item_definition, _FeatureCollectionDefinition):
        order = 3
    elif isinstance(item_definition, _WebMapDefinition):
        order = 4
    elif isinstance(item_definition, _ApplicationDefinition):
        order = 5
    elif isinstance(item_definition, _WorkforceProjectDefinition):
        order = 6
    else:
        order = 7
    return order

def _check_cancel_status(item=None):
    """If the script is running as a GP tool check if it has been canceled.
    Keyword arguments:
    item - The new item that has been partially cloned"""

    try:
        import arcpy
        if arcpy.env.isCancelled:
            raise _CustomCancelException(item) 
    except ImportError:
        pass

def _find_and_replace_fields(text, field_mapping):
    """Perform a find and replace for field names in a json definition.
    Keyword arguments:
    text - The json to search and replace fields names
    field_mapping -  A dictionary containing the pairs of original field names and new field names"""
       
    for field in field_mapping:
        replace = field_mapping[field]

        results = set(re.findall('([{{("\[ ])({0})([}})"\] ])'.format(field), text))
        start = re.findall('(^{0})([}})"\] ])'.format(field), text)
        end = re.findall('([{{("\[ ])({0}$)'.format(field), text)
        for element in results:
            text = text.replace(''.join(element), ''.join([element[0], replace, element[2]]))

        if len(start) > 0:
            new_start = ''.join([replace, start[0][1]])
            text = new_start + text[len(new_start):]

        if len(end) > 0:
            new_end = ''.join([end[0][0], replace])
            text = text[:len(text) - len(new_end) + 1] + new_end
    return text

def _find_and_replace_fields_arcade(text, field_mapping):
    """Perform a find and replace for field names in an arcade expression.
    Keyword arguments:
    text - The arcade expression to search and replace fields names
    field_mapping -  A dictionary containing the pairs of original field names and new field names""" 
      
    for field in field_mapping:
        replace = field_mapping[field]
        text = text.replace('$feature.{0}'.format(field), '$feature.{0}'.format(replace))
        text = text.replace('$feature["{0}"]'.format(field), '$feature["{0}"]'.format(replace))
    return text

def _update_feature_attributes(feature, field_mapping):
    """Perform a find and replace for field names in a feature attribute definition.
    Keyword arguments:
    feature - The feature to search and replace fields names
    field_mapping -  A dictionary containing the pairs of original field names and new field names"""
     
    if 'attributes' in feature and feature['attributes'] is not None:
        for attribute in [att for att in feature['attributes']]:
            if attribute in field_mapping:
                if field_mapping[attribute] in feature['attributes']:
                    continue
                feature['attributes'][field_mapping[attribute]] = feature['attributes'][attribute]
                del feature['attributes'][attribute]

def _update_layer_fields(layer, field_mapping):
    """Perform a find and replace for field names in a layer definition.
    Keyword arguments:
    layer - The layer to search and replace fields names
    field_mapping -  A dictionary containing the pairs of original field names and new field names"""

    if 'layerDefinition' in layer and layer['layerDefinition'] is not None:
        layer_definition = layer['layerDefinition']
            
        if 'definitionExpression' in layer_definition and layer_definition['definitionExpression'] is not None:
            layer_definition['definitionExpression'] = _find_and_replace_fields(layer_definition['definitionExpression'], field_mapping)
                                        
        if 'drawingInfo' in layer_definition and layer_definition['drawingInfo'] is not None:
            if 'renderer' in layer_definition['drawingInfo'] and layer_definition['drawingInfo']['renderer'] is not None:
                renderer = layer_definition['drawingInfo']['renderer']
                if renderer['type'] == 'uniqueValue':
                    i = 0
                    while 'field{0}'.format(i) in renderer:
                        if renderer['field{0}'.format(i)] in field_mapping:
                            renderer['field{0}'.format(i)] = field_mapping[renderer['field{0}'.format(i)]]
                        i += 1
                elif renderer['type'] == 'classBreaks':
                    if 'field' in renderer:
                        if renderer['field'] in field_mapping:
                            renderer['field'] = field_mapping[renderer['field']]

                value_expression = _deep_get(renderer, "valueExpression")
                if value_expression is not None:
                    renderer['valueExpression'] = _find_and_replace_fields_arcade(str(value_expression), field_mapping)
            
            labeling_infos = _deep_get(layer_definition['drawingInfo'], 'labelingInfo')             
            if labeling_infos is not None:
                for label_info in labeling_infos:
                    label_expression = _deep_get(label_info, 'labelExpression')
                    if label_expression is not None:
                        results = re.findall("\[(.*?)\]", label_expression)
                        for result in results:
                            if result in field_mapping: 
                                label_info['labelExpression'] = str(label_expression).replace("[{0}]".format(result), "[{0}]".format(field_mapping[result]))
                        
                    value = _deep_get(label_info, 'labelExpressionInfo', 'value')
                    if value is not None:
                        results = re.findall("{(.*?)}", value)
                        for result in results:
                            if result in field_mapping: 
                                label_info['labelExpressionInfo']['value'] = str(value).replace("{{{0}}}".format(result), "{{{0}}}".format(field_mapping[result]))

                    expression = _deep_get(label_info, 'labelExpressionInfo', 'expression')
                    if expression is not None:
                        label_info['labelExpressionInfo']['expression'] = _find_and_replace_fields_arcade(str(expression), field_mapping)
    
    if 'popupInfo' in layer and layer['popupInfo'] is not None:
        if 'title' in layer['popupInfo'] and layer['popupInfo']['title'] is not None:
            results = re.findall("{(.*?)}", layer['popupInfo']['title'])
            for result in results:
                if result in field_mapping:
                    layer['popupInfo']['title'] = str(layer['popupInfo']['title']).replace("{{{0}}}".format(result), "{{{0}}}".format(field_mapping[result]))
                
        if 'description' in layer['popupInfo'] and layer['popupInfo']['description'] is not None:
            results = re.findall("{(.*?)}", layer['popupInfo']['description'])
            for result in results:
                if result in field_mapping:
                    layer['popupInfo']['description'] = str(layer['popupInfo']['description']).replace("{{{0}}}".format(result), "{{{0}}}".format(field_mapping[result]))

        if 'fieldInfos' in layer['popupInfo'] and layer['popupInfo']['fieldInfos'] is not None:
            for field in layer['popupInfo']['fieldInfos']:
                if field['fieldName'] in field_mapping:
                    field['fieldName'] = field_mapping[field['fieldName']]

        if 'expressionInfos' in layer['popupInfo'] and layer['popupInfo']['expressionInfos'] is not None:
            for expression_info in layer['popupInfo']['expressionInfos']:
                if 'expression' in expression_info and expression_info['expression'] is not None:
                    expression_info['expression'] = _find_and_replace_fields_arcade(str(expression_info['expression']), field_mapping)

        if 'mediaInfos' in layer['popupInfo'] and layer['popupInfo']['mediaInfos'] is not None:
            for media_info in layer['popupInfo']['mediaInfos']:
                if 'title' in media_info and media_info['title'] is not None:
                    results = re.findall("{(.*?)}", media_info['title'])
                    for result in results:
                        if result in field_mapping:
                            media_info['title'] = str(media_info['title']).replace("{{{0}}}".format(result), "{{{0}}}".format(field_mapping[result]))
                if 'caption' in media_info and media_info['caption'] is not None:
                    results = re.findall("{(.*?)}", media_info['caption'])
                    for result in results:
                        if result in field_mapping:
                            media_info['caption'] = str(media_info['caption']).replace("{{{0}}}".format(result), "{{{0}}}".format(field_mapping[result]))
                if 'normalizeField' in media_info and media_info['normalizeField'] is not None:
                    if media_info['normalizeField'] in field_mapping:
                        media_info['normalizeField'] = field_mapping[media_info['normalizeField']]
                if 'fields' in media_info and media_info['fields'] is not None:
                    for field in media_info['fields']:
                        fields = []
                        if field in field_mapping:
                            fields.append(field_mapping[field])
                        else:
                            fields.append(field)
                    media_info['fields'] = fields

    if 'definitionEditor' in layer and layer['definitionEditor'] is not None:
        if 'inputs' in layer['definitionEditor'] and layer['definitionEditor']['inputs'] is not None:
            for definition_input in layer['definitionEditor']['inputs']:
                if 'parameters' in definition_input and definition_input['parameters'] is not None:
                    for param in definition_input['parameters']:
                        if 'fieldName' in param and param['fieldName'] is not None:
                            if param['fieldName'] in field_mapping:
                                param['fieldName'] = field_mapping[param['fieldName']]
        if 'parameterizedExpression' in layer['definitionEditor'] and layer['definitionEditor']['parameterizedExpression'] is not None:
            layer['definitionEditor']['parameterizedExpression'] = _find_and_replace_fields(layer['definitionEditor']['parameterizedExpression'], field_mapping)

def _zip_dir(path, zip_file, include_root=True):
    """Zip a directory of files.
    Keyword arguments:
    path - The folder containing the files and subfolders to zip
    zip_file - The zip file that will store the compressed files
    include_root -  Indicates if the root folder should be included in the zip"""

    rel_path = ''
    if include_root:
        rel_path = '..'

    # Zip a directory of files
    for root, dirs, files in os.walk(path):
        for file in files:
            zip_file.write(os.path.join(root, file), os.path.relpath(os.path.join(root, file), os.path.join(path, rel_path)))

def _deep_get(dictionary, *keys):
    """Safely return a nested value from a dictionary. If at any point along the path the key doesn't exist the function will return None.
    Keyword arguments:
    dictionary - The dictionary to search for the value
    *keys - The keys used to fetch the desired value"""

    return reduce(lambda d, key: d.get(key) if d else None, keys, dictionary)

#endregion

_TEXT_BASED_ITEM_TYPES = ['Web Map', 'Feature Service', 'Map Service', 'Operation View',
                          'Image Service', 'Feature Collection', 'Feature Collection Template',
                          'Web Mapping Application', 'Mobile Application', 'Symbol Set', 'Color Set']

_GPS_METADATA_FIELDS = """{
	"fields" : [{
			"name" : "ESRIGNSS_RECEIVER",
			"type" : "esriFieldTypeString",
			"alias" : "Receiver Name",
			"sqlType" : "sqlTypeOther",
			"length" : 50,
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_H_RMS",
			"type" : "esriFieldTypeDouble",
			"alias" : "Horizontal Accuracy (m)",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_V_RMS",
			"type" : "esriFieldTypeDouble",
			"alias" : "Vertical Accuracy (m)",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_LATITUDE",
			"type" : "esriFieldTypeDouble",
			"alias" : "Latitude",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_LONGITUDE",
			"type" : "esriFieldTypeDouble",
			"alias" : "Longitude",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_ALTITUDE",
			"type" : "esriFieldTypeDouble",
			"alias" : "Altitude",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_PDOP",
			"type" : "esriFieldTypeDouble",
			"alias" : "PDOP",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_HDOP",
			"type" : "esriFieldTypeDouble",
			"alias" : "HDOP",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_VDOP",
			"type" : "esriFieldTypeDouble",
			"alias" : "VDOP",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_FIXTYPE",
			"type" : "esriFieldTypeSmallInteger",
			"alias" : "Fix Type",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : {
				"type" : "codedValue",
				"name" : "ESRI_FIX_TYPE_DOMAIN",
				"codedValues" : [{
						"name" : "Fix not valid",
						"code" : 0
					}, {
						"name" : "GPS",
						"code" : 1
					}, {
						"name" : "Differential GPS",
						"code" : 2
					}, {
						"name" : "RTK Fixed",
						"code" : 4
					}, {
						"name" : "RTK Float",
						"code" : 5
					}
				]
			},
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_CORRECTIONAGE",
			"type" : "esriFieldTypeDouble",
			"alias" : "Correction Age",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_STATIONID",
			"type" : "esriFieldTypeSmallInteger",
			"alias" : "Station ID",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : {
				"type" : "range",
				"name" : "ESRI_STATION_ID_DOMAIN",
				"range" : [
					0,
					1023
				]
			},
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_NUMSATS",
			"type" : "esriFieldTypeSmallInteger",
			"alias" : "Number of Satellites",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : {
				"type" : "range",
				"name" : "ESRI_NUM_SATS_DOMAIN",
				"range" : [
					0,
					99
				]
			},
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_FIXDATETIME",
			"type" : "esriFieldTypeDate",
			"alias" : "Fix Time",
			"sqlType" : "sqlTypeOther",
			"length" : 0,
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_AVG_H_RMS",
			"type" : "esriFieldTypeDouble",
			"alias" : "Average Horizontal Accuracy (m)",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_AVG_V_RMS",
			"type" : "esriFieldTypeDouble",
			"alias" : "Average Vertical Accuracy (m)",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_AVG_POSITIONS",
			"type" : "esriFieldTypeSmallInteger",
			"alias" : "Averaged Positions",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}, {
			"name" : "ESRIGNSS_H_STDDEV",
			"type" : "esriFieldTypeDouble",
			"alias" : "Standard Deviation (m)",
			"sqlType" : "sqlTypeOther",
			"nullable" : true,
			"editable" : true,
			"domain" : null,
			"defaultValue" : null
		}
	],

	"popup" : [{
			"fieldName" : "ESRIGNSS_RECEIVER",
			"label" : "Receiver Name",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"stringFieldOption" : "textbox"
		}, {
			"fieldName" : "ESRIGNSS_H_RMS",
			"label" : "Horizontal Accuracy (m)",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_V_RMS",
			"label" : "Vertical Accuracy (m)",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_LATITUDE",
			"label" : "Latitude",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 8,
				"digitSeparator" : false
			}
		}, {
			"fieldName" : "ESRIGNSS_LONGITUDE",
			"label" : "Longitude",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 8,
				"digitSeparator" : false
			}
		}, {
			"fieldName" : "ESRIGNSS_ALTITUDE",
			"label" : "Altitude",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_PDOP",
			"label" : "PDOP",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_HDOP",
			"label" : "HDOP",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_VDOP",
			"label" : "VDOP",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_FIXTYPE",
			"label" : "Fix Type",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"stringFieldOption" : "textbox"
		}, {
			"fieldName" : "ESRIGNSS_CORRECTIONAGE",
			"label" : "Correction Age",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 0,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_STATIONID",
			"label" : "Station ID",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 0,
				"digitSeparator" : false
			}
		}, {
			"fieldName" : "ESRIGNSS_NUMSATS",
			"label" : "Number of Satellites",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 0,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_FIXDATETIME",
			"label" : "Fix Time",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"dateFormat" : "shortDateShortTime",
				"timezone" : "utc"
			}
		}, {
			"fieldName" : "ESRIGNSS_AVG_H_RMS",
			"label" : "Average Horizontal Accuracy (m)",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_AVG_V_RMS",
			"label" : "Average Vertical Accuracy (m)",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 2,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_AVG_POSITIONS",
			"label" : "Averaged Positions",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 0,
				"digitSeparator" : true
			}
		}, {
			"fieldName" : "ESRIGNSS_H_STDDEV",
			"label" : "Standard Deviation (m)",
			"isEditable" : false,
			"isEditableOnLayer" : true,
			"visible" : false,
			"format" : {
				"places" : 3,
				"digitSeparator" : true
			}
		}
	]
}"""