generated_bulkloader.yaml

# 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: Account
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: createdAt
      external_name: createdAt
      # Type: Date/Time Stats: 57 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: email
      external_name: email
      # Type: String Stats: 57 properties of this type in this kind.

    - property: institute
      external_name: institute
      # Type: String Stats: 57 properties of this type in this kind.

    - property: isInstructor
      external_name: isInstructor
      # Type: Boolean Stats: 57 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: name
      external_name: name
      # Type: String Stats: 57 properties of this type in this kind.


- kind: Comment
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: commentText
      external_name: commentText
      # Type: Text Stats: 17 properties of this type in this kind.
      import_transform: db.Text

    - property: courseId
      external_name: courseId
      # Type: String Stats: 17 properties of this type in this kind.

    - property: createdAt
      external_name: createdAt
      # Type: Date/Time Stats: 17 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: giverEmail
      external_name: giverEmail
      # Type: String Stats: 17 properties of this type in this kind.

    - property: receiverEmail
      external_name: receiverEmail
      # Type: String Stats: 17 properties of this type in this kind.


- kind: Course
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: archiveStatus
      external_name: archiveStatus
      # Type: Boolean Stats: 71 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: createdAt
      external_name: createdAt
      # Type: Date/Time Stats: 71 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: name
      external_name: name
      # Type: String Stats: 71 properties of this type in this kind.


- kind: Evaluation
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: activated
      external_name: activated
      # Type: Boolean Stats: 57 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: commentsEnabled
      external_name: commentsEnabled
      # Type: Boolean Stats: 57 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: courseID
      external_name: courseID
      # Type: String Stats: 57 properties of this type in this kind.

    - property: endTime
      external_name: endTime
      # Type: Date/Time Stats: 57 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: gracePeriod
      external_name: gracePeriod
      # Type: Integer Stats: 57 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: longInstructions
      external_name: longInstructions
      # Type: Text Stats: 57 properties of this type in this kind.
      import_transform: db.Text

    - property: name
      external_name: name
      # Type: String Stats: 57 properties of this type in this kind.

    - property: published
      external_name: published
      # Type: Boolean Stats: 57 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: startTime
      external_name: startTime
      # Type: Date/Time Stats: 57 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: timeZone
      external_name: timeZone
      # Type: Float Stats: 57 properties of this type in this kind.
      import_transform: transform.none_if_empty(float)


- kind: FeedbackQuestion
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: courseId
      external_name: courseId
      # Type: String Stats: 210 properties of this type in this kind.

    - property: creatorEmail
      external_name: creatorEmail
      # Type: String Stats: 210 properties of this type in this kind.

    - property: feedbackSessionName
      external_name: feedbackSessionName
      # Type: String Stats: 210 properties of this type in this kind.

    - property: giverType
      external_name: giverType
      # Type: String Stats: 210 properties of this type in this kind.

    - property: numberOfEntitiesToGiveFeedbackTo
      external_name: numberOfEntitiesToGiveFeedbackTo
      # Type: Integer Stats: 210 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: questionNumber
      external_name: questionNumber
      # Type: Integer Stats: 210 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: questionText
      external_name: questionText
      # Type: Text Stats: 210 properties of this type in this kind.
      import_transform: db.Text

    - property: questionType
      external_name: questionType
      # Type: String Stats: 210 properties of this type in this kind.

    - property: recipientType
      external_name: recipientType
      # Type: String Stats: 210 properties of this type in this kind.

    - property: showGiverNameTo
      external_name: showGiverNameTo
      # Type: String Stats: 271 properties of this type in this kind.

    - property: showRecipientNameTo
      external_name: showRecipientNameTo
      # Type: String Stats: 296 properties of this type in this kind.

    - property: showResponsesTo
      external_name: showResponsesTo
      # Type: String Stats: 399 properties of this type in this kind.


- kind: FeedbackResponseComment
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: commentText
      external_name: commentText
      # Type: Text Stats: 25 properties of this type in this kind.
      import_transform: db.Text

    - property: courseId
      external_name: courseId
      # Type: String Stats: 25 properties of this type in this kind.

    - property: createdAt
      external_name: createdAt
      # Type: Date/Time Stats: 25 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: feedbackQuestionId
      external_name: feedbackQuestionId
      # Type: String Stats: 25 properties of this type in this kind.

    - property: feedbackResponseId
      external_name: feedbackResponseId
      # Type: String Stats: 25 properties of this type in this kind.

    - property: feedbackSessionName
      external_name: feedbackSessionName
      # Type: String Stats: 25 properties of this type in this kind.

    - property: giverEmail
      external_name: giverEmail
      # Type: String Stats: 25 properties of this type in this kind.


- kind: FeedbackResponse
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: answer
      external_name: answer
      # Type: Text Stats: 216 properties of this type in this kind.
      import_transform: db.Text

    - property: courseId
      external_name: courseId
      # Type: String Stats: 216 properties of this type in this kind.

    - property: feedbackQuestionId
      external_name: feedbackQuestionId
      # Type: String Stats: 216 properties of this type in this kind.

    - property: feedbackQuestionType
      external_name: feedbackQuestionType
      # Type: String Stats: 216 properties of this type in this kind.

    - property: feedbackSessionName
      external_name: feedbackSessionName
      # Type: String Stats: 216 properties of this type in this kind.

    - property: giverEmail
      external_name: giverEmail
      # Type: String Stats: 216 properties of this type in this kind.

    - property: receiver
      external_name: receiver
      # Type: String Stats: 216 properties of this type in this kind.


- kind: FeedbackSession
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: courseId
      external_name: courseId
      # Type: String Stats: 83 properties of this type in this kind.

    - property: createdTime
      external_name: createdTime
      # Type: Date/Time Stats: 83 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: creatorEmail
      external_name: creatorEmail
      # Type: String Stats: 83 properties of this type in this kind.

    - property: endTime
      external_name: endTime
      # Type: Date/Time Stats: 77 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: feedbackSessionName
      external_name: feedbackSessionName
      # Type: String Stats: 83 properties of this type in this kind.

    - property: feedbackSessionType
      external_name: feedbackSessionType
      # Type: String Stats: 83 properties of this type in this kind.

    - property: gracePeriod
      external_name: gracePeriod
      # Type: Integer Stats: 83 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: instructions
      external_name: instructions
      # Type: Text Stats: 83 properties of this type in this kind.
      import_transform: db.Text

    - property: isClosingEmailEnabled
      external_name: isClosingEmailEnabled
      # Type: Boolean Stats: 83 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: isOpeningEmailEnabled
      external_name: isOpeningEmailEnabled
      # Type: Boolean Stats: 83 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: isPublishedEmailEnabled
      external_name: isPublishedEmailEnabled
      # Type: Boolean Stats: 83 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: resultsVisibleFromTime
      external_name: resultsVisibleFromTime
      # Type: Date/Time Stats: 83 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: sentOpenEmail
      external_name: sentOpenEmail
      # Type: Boolean Stats: 83 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: sentPublishedEmail
      external_name: sentPublishedEmail
      # Type: Boolean Stats: 83 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: sessionVisibleFromTime
      external_name: sessionVisibleFromTime
      # Type: Date/Time Stats: 83 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: startTime
      external_name: startTime
      # Type: Date/Time Stats: 83 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: timeZoneDouble
      external_name: timeZoneDouble
      # Type: Float Stats: 83 properties of this type in this kind.
      import_transform: transform.none_if_empty(float)

    - property: timeZone
      external_name: timeZone
      # Type: Integer Stats: 83 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)


- kind: Instructor
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: courseId
      external_name: courseId
      # Type: String Stats: 23 properties of this type in this kind.

    - property: email
      external_name: email
      # Type: String Stats: 23 properties of this type in this kind.

    - property: googleId
      external_name: googleId
      # Type: String Stats: 21 properties of this type in this kind.

    - property: name
      external_name: name
      # Type: String Stats: 23 properties of this type in this kind.

    - property: registrationKey
      external_name: registrationKey
      # Type: String Stats: 23 properties of this type in this kind.


- kind: Student
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: ID
      external_name: ID
      # Type: String Stats: 148 properties of this type in this kind.

    - property: comments
      external_name: comments
      # Type: String Stats: 156 properties of this type in this kind.

    - property: courseID
      external_name: courseID
      # Type: String Stats: 156 properties of this type in this kind.

    - property: email
      external_name: email
      # Type: String Stats: 156 properties of this type in this kind.

    - property: name
      external_name: name
      # Type: String Stats: 156 properties of this type in this kind.

    - property: teamName
      external_name: teamName
      # Type: String Stats: 156 properties of this type in this kind.


- kind: Submission
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: commentsToStudent
      external_name: commentsToStudent
      # Type: Text Stats: 864 properties of this type in this kind.
      import_transform: db.Text

    - property: courseID
      external_name: courseID
      # Type: String Stats: 864 properties of this type in this kind.

    - property: evaluationName
      external_name: evaluationName
      # Type: String Stats: 864 properties of this type in this kind.

    - property: fromStudent
      external_name: fromStudent
      # Type: String Stats: 864 properties of this type in this kind.

    - property: justification
      external_name: justification
      # Type: Text Stats: 864 properties of this type in this kind.
      import_transform: db.Text

    - property: points
      external_name: points
      # Type: Integer Stats: 864 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: teamName
      external_name: teamName
      # Type: String Stats: 864 properties of this type in this kind.

    - property: toStudent
      external_name: toStudent
      # Type: String Stats: 864 properties of this type in this kind.


- kind: _AE_Backup_Information_Kind_Files
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: files
      external_name: files
      # Type: String Stats: 143 properties of this type in this kind.


- kind: _AE_Backup_Information_Kind_Type_Info
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: entity_type_info
      external_name: entity_type_info
      # Type: Text Stats: 143 properties of this type in this kind.
      import_transform: db.Text

    - property: is_partial
      external_name: is_partial
      # Type: Boolean Stats: 143 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)


- kind: _AE_Backup_Information
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: complete_time
      external_name: complete_time
      # Type: Date/Time Stats: 12 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: completed_jobs
      external_name: completed_jobs
      # Type: String Stats: 56 properties of this type in this kind.

    - property: filesystem
      external_name: filesystem
      # Type: String Stats: 12 properties of this type in this kind.

    - property: kinds
      external_name: kinds
      # Type: String Stats: 56 properties of this type in this kind.

    - property: name
      external_name: name
      # Type: String Stats: 12 properties of this type in this kind.

    - property: start_time
      external_name: start_time
      # Type: Date/Time Stats: 12 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')


- kind: _AE_DatastoreAdmin_Operation
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

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

    - property: active_jobs
      external_name: active_jobs
      # Type: Integer Stats: 13 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: completed_jobs
      external_name: completed_jobs
      # Type: Integer Stats: 13 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: description
      external_name: description
      # Type: Text Stats: 13 properties of this type in this kind.
      import_transform: db.Text

    - property: last_updated
      external_name: last_updated
      # Type: Date/Time Stats: 13 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')

    - property: status
      external_name: status
      # Type: String Stats: 13 properties of this type in this kind.

    - property: status_info
      external_name: status_info
      # Type: String Stats: 13 properties of this type in this kind.


- kind: _GAE_MR_MapreduceState
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: aborted_shards
      external_name: aborted_shards
      # Type: Integer Stats: 1 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: active
      external_name: active
      # Type: Boolean Stats: 1 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: active_shards
      external_name: active_shards
      # Type: Integer Stats: 1 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: chart_url
      external_name: chart_url
      # Type: Text Stats: 1 properties of this type in this kind.
      import_transform: db.Text

    - property: chart_width
      external_name: chart_width
      # Type: Integer Stats: 1 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: counters_map
      external_name: counters_map
      # Type: Text Stats: 1 properties of this type in this kind.
      import_transform: db.Text

    - property: failed_shards
      external_name: failed_shards
      # Type: Integer Stats: 1 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

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

    - property: mapreduce_spec
      external_name: mapreduce_spec
      # Type: Text Stats: 1 properties of this type in this kind.
      import_transform: db.Text

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

    - property: sparkline_url
      external_name: sparkline_url
      # Type: Text Stats: 1 properties of this type in this kind.
      import_transform: db.Text

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


- kind: _GAE_MR_ShardState
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: acquired_once
      external_name: acquired_once
      # Type: Boolean Stats: 8 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: active
      external_name: active
      # Type: Boolean Stats: 8 properties of this type in this kind.
      import_transform: transform.regexp_bool('true', re.IGNORECASE)

    - property: counters_map
      external_name: counters_map
      # Type: Text Stats: 8 properties of this type in this kind.
      import_transform: db.Text

    - property: last_work_item
      external_name: last_work_item
      # Type: Text Stats: 8 properties of this type in this kind.
      import_transform: db.Text

    - property: mapreduce_id
      external_name: mapreduce_id
      # Type: String Stats: 8 properties of this type in this kind.

    - property: result_status
      external_name: result_status
      # Type: String Stats: 8 properties of this type in this kind.

    - property: retries
      external_name: retries
      # Type: Integer Stats: 8 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: shard_description
      external_name: shard_description
      # Type: Text Stats: 8 properties of this type in this kind.
      import_transform: db.Text

    - property: slice_id
      external_name: slice_id
      # Type: Integer Stats: 8 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: slice_retries
      external_name: slice_retries
      # Type: Integer Stats: 8 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: update_time
      external_name: update_time
      # Type: Date/Time Stats: 8 properties of this type in this kind.
      import_transform: transform.import_date_time('%Y-%m-%dT%H:%M:%S')
      export_transform: transform.export_date_time('%Y-%m-%dT%H:%M:%S')


- kind: _GAE_MR_TaskPayload
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: payload
      external_name: payload
      # Type: Blob Stats: 16 properties of this type in this kind.
      import_transform: transform.blobproperty_from_base64
      export_transform: base64.b64encode


- kind: _ah_SESSION
  connector: csv
  connector_options:
    encoding: utf-8
    columns: from_header
  property_map:
    - property: __key__
      external_name: key
      export_transform: transform.key_id_or_name_as_string

    - property: _expires
      external_name: _expires
      # Type: Integer Stats: 67 properties of this type in this kind.
      import_transform: transform.none_if_empty(int)

    - property: _values
      external_name: _values
      # Type: Blob Stats: 67 properties of this type in this kind.
      import_transform: transform.blobproperty_from_base64
      export_transform: base64.b64encode