# Autogenerated bulkloader.yaml file.
# You must edit this file before using it. TODO: Remove this line when done.
# At a minimum address the items marked with TODO:
#  * Fill in connector and connector_options
#  * Review the property_map.
#    - Ensure the 'external_name' matches the name of your CSV column,
#      XML tag, etc.
#    - Check that __key__ property is what you want. Its value will become
#      the key name on import, and on export the value will be the Key
#      object.  If you would like automatic key generation on import and
#      omitting the key on export, you can remove the entire __key__
#      property from the property map.

# If you have module(s) with your model classes, add them here. Also
# change the kind properties to model_class.
python_preamble:
- import: base64
- import: re
- import: google.appengine.ext.bulkload.transform
- import: google.appengine.ext.bulkload.bulkloader_wizard
- import: google.appengine.ext.db
- import: google.appengine.api.datastore
- import: google.appengine.api.users

transformers:

- kind: Session
  connector: csv
  connector_options:
    # TODO: Add connector options here--these are specific to each connector.
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: SessionID
      external_name: fldScheduleID
      # Type: STRING Stats: 0 properties of this type in this kind.

    - property: CustomerID
      external_name: fldScheduleContactID
      # Type: String Stats: 1 properties of this type in this kind.

    - property: EmployeeID
      external_name: fldScheduleEmployeeID
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Date
      external_name: fldScheduleDate
      import_transform: transform.import_date_time('%m/%d/%Y T%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
      # Type: STRING Stats: 0 properties of this type in this kind.

    - property: Time
      external_name: fldScheduleTime
      import_transform: transform.import_date_time('%m/%d/%Y T%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Notes
      external_name: fldScheduleNotes
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Duration
      external_name: fldScheduleDuration
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Completed
      external_name: fldScheduleCompleted
      # Type: String Stats: 1 properties of this type in this kind.

    - property: CompletedDate
      external_name: fldScheduleCompletedDate
      import_transform: transform.import_date_time('%m/%d/%Y T%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Name
      external_name: fldDisplayAs
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Cancelled
      external_name: fldScheduleCancelled
      # Type: String Stats: 1 properties of this type in this kind.

    - property: WorkCodeID
      external_name: fldWorkCodeID
      # Type: Date/Time Stats: 1 properties of this type in this kind.

    - property: StatusID
      external_name: fldStatusCodeID
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Location
      external_name: fldLocation
      # Type: String Stats: 1 properties of this type in this kind.

    - property: Timestamp
      external_name: fldOutlookLastModified
      import_transform: transform.import_date_time('%m/%d/%Y T%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')
