ImportFile Entity Metadata

  • 项目

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the import file entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is ImportFile.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the import file entity.

Entity metadata property Value

OTC

4412

EntityLogicalName

importfile

DisplayName

Import Source File

OwnershipType

UserOwned

IsCustomizable

False

Description

File name of file used for import.

IsAvailableOffline

False

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

False

CanBePrimaryEntityInRelationship

False

CanBeRelatedEntityInRelationship

False

CanCreateAttributes

False

CanCreateCharts

False

CanCreateForms

False

CanCreateViews

False

CanModifyAdditionalSettings

False

CanTriggerWorkflow

False

IsActivity

False

IsActivityParty

False

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

False

IsImportable

False

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

False

IsReadingPaneEnabled

True

IsRenameable

False

IsValidForAdvancedFind

False

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

importfileid

PrimaryNameAttribute

name

ReportViewName

FilteredImportFile

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Imports

Privilege Metadata

The following table shows the privilege metadata for the import file entity.

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendImportFile

f8e6d056-0fc6-4562-9293-e2acea5e2fb4

Append

True

True

True

True

prvAppendToImportFile

2bbccee3-eea8-418d-8543-22cd66554dd7

AppendTo

True

True

True

True

prvAssignImportFile

bf70dc31-6132-4ac0-8c9d-2a741657c6f0

Assign

True

True

True

True

prvCreateImportFile

8e345875-f67b-40f7-9aa6-2a35de1bf224

Create

True

True

True

True

prvDeleteImportFile

bdd834d8-8b0b-430c-a1d8-add2fcebd854

Delete

True

True

True

True

prvReadImportFile

fe46d775-ca5c-4a09-af93-99a133455306

Read

True

True

True

True

prvShareImportFile

b9bcae9f-c539-4739-b894-363796cdfceb

Share

True

True

True

True

prvWriteImportFile

ff22fd34-e58b-455f-988b-2909c28e7e18

Write

True

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the import file entity.

LogicalName Description Type SchemaName IsCustomAttribute IsCustomizable RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion

additionalheaderrow

System generated heading row used for processing transformations.

String

AdditionalHeaderRow

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Additional Header

completedon

Date and time when the import was completed for this import file.

DateTime

CompletedOn

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Completed On

content

Content of the import file.

String

Content

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

False

createdby

Unique identifier of the user who created the import file record.

Lookup

CreatedBy

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Created By

createdon

Date and time when the import file was created.

DateTime

CreatedOn

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

True

Created On

createdonbehalfby

Unique identifier of the delegate user who created the importfile.

Lookup

CreatedOnBehalfBy

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Created By (Delegate)

datadelimitercode

Single character data delimiter used in the import file.

Picklist

DataDelimiterCode

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Data Delimiter

enableduplicatedetection

Information about whether duplicate detection is enabled.

Boolean

EnableDuplicateDetection

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Enable Duplicate Detection

failurecount

Number of records in this file that could not be imported.

Integer

FailureCount

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Errors

fielddelimitercode

Single character field delimiter used in the import file.

Picklist

FieldDelimiterCode

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Field Delimiter

filetypecode

File type of the uploaded source file

Picklist

FileTypeCode

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

File Type

headerrow

Header row of the import file.

String

HeaderRow

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Header

importfileid

Unique identifier of the import file.

Uniqueidentifier

ImportFileId

False

False

SystemRequired

True

True

False

False

False

False

False

True

True

False

False

False

False

Import

importid

Unique identifier of the import job for this import file.

Lookup

ImportId

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Import Job ID

importmapid

Unique identifier of the associated data map.

Lookup

ImportMapId

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Data Map

isfirstrowheader

Information about whether the first row contains column headings.

Boolean

IsFirstRowHeader

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Is First Row Header

modifiedby

Unique identifier of the user who last modified the import file.

Lookup

ModifiedBy

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Modified By

modifiedon

Date and time when the import file was last modified.

DateTime

ModifiedOn

False

False

SystemRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Modified On

modifiedonbehalfby

Unique identifier of the delegate user who last modified the importfile.

Lookup

ModifiedOnBehalfBy

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Modified By (Delegate)

name

Name of the import file.

String

Name

False

False

None

True

True

True

False

False

False

True

True

False

True

False

False

True

Import Name

ownerid

Unique identifier of the user or team who owns the import file.

Owner

OwnerId

False

False

SystemRequired

True

True

False

False

False

False

True

True

False

False

False

False

True

Owner

owningbusinessunit

Business unit that owns the import file.

Lookup

OwningBusinessUnit

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

owningteam

Unique identifier of the team who owns the import file.

Lookup

OwningTeam

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Team

owninguser

Unique identifier of the user who owns the import file.

Lookup

OwningUser

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning User

parsedtablecolumnprefix

Prefix of the column in the parsed table.

String

ParsedTableColumnPrefix

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Parse Table Column Prefix

parsedtablecolumnsnumber

Total number of columns present in the parsed table.

Integer

ParsedTableColumnsNumber

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Parse Table Column Number

parsedtablename

Name of the table that contains the parsed data of the import file.

String

ParsedTableName

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Parse Table

partialfailurecount

Number of records in this file that had failures in updating.

Integer

PartialFailureCount

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Partial Failures

processcode

Information about whether the import file needs to be processed.

Picklist

ProcessCode

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Process Code

processingstatus

Detailed status showing how much the import file has been processed.

Picklist

ProcessingStatus

False

False

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Processing Status

progresscounter

Indicates how much of a particular operation has been completed. Used when resuming a paused import job.

Integer

ProgressCounter

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Progress Counter

recordsownerid

Unique identifier of the owner to whom records imported from this file are assigned.

Lookup

RecordsOwnerId

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Records Owner

relatedentitycolumns

Related Entity Columns

String

RelatedEntityColumns

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

False

size

Size of the import file.

String

Size

False

False

None

True

True

False

False

False

False

True

True

False

False

False

False

True

Size

source

Source of the import file.

String

Source

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Source

sourceentityname

Name of the source entity.

String

SourceEntityName

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Source Entity

statecode

Status of the import file.

State

StateCode

False

False

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

True

Status

statuscode

Reason for the status of the import file.

Status

StatusCode

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Status Reason

successcount

Number of records in this file that were imported successfully.

Integer

SuccessCount

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Successes

targetentityname

Name of the Microsoft Dynamics CRM entity.

String

TargetEntityName

False

False

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Target Entity

timezoneruleversionnumber

For internal use only.

Integer

TimeZoneRuleVersionNumber

False

False

None

True

True

True

False

False

False

False

True

False

False

False

False

False

totalcount

Number of records processed in this file.

Integer

TotalCount

False

False

None

False

True

False

False

False

False

True

True

False

False

False

False

True

Total Processed

usesystemmap

Information about whether to use the system map.

Boolean

UseSystemMap

False

False

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

True

Use System Map

utcconversiontimezonecode

Time zone code that was in use when the record was created.

Integer

UTCConversionTimeZoneCode

False

False

None

True

True

True

False

False

False

False

True

False

False

False

False

False

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the import file entity.

Relationship schema name Referencing Entity

ImportFile_AsyncOperations

asyncoperation

ImportFile_BulkDeleteFailures

bulkdeletefailure

ImportFile_ImportData

importdata

ImportLog_ImportFile

importlog

userentityinstancedata_importfile

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the import file entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the import file entity.

Relationship schema name Referenced entity

BusinessUnit_ImportFiles

businessunit

Import_ImportFile

import

ImportFile_SystemUser

systemuser

ImportFile_Team

team

ImportMap_ImportFile

importmap

lk_importfilebase_createdby

systemuser

lk_importfilebase_createdonbehalfby

systemuser

lk_importfilebase_modifiedby

systemuser

lk_importfilebase_modifiedonbehalfby

systemuser

owner_importfiles

owner

SystemUser_ImportFiles

systemuser

team_ImportFiles

team

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

ImportFile Entity Messages and Methods
ImportFile (Import Source File) Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.