Import Header Commands
Import Header Commands allow you to control how data is handled once the data has been imported. For instance, you may choose to overwrite all records in a table rather than append. Or, you may decide to replace a series of records with the data imported. These functions can be accomplished by adding Header Commands to the Import File.
An Import Header Command consists of one line at the beginning of your file that instructs the iSite File Processor what to do with the file. This line will precede the Header Column Names that are required for each File Import.
You may include multiple Header Commands (in certain instances) by separating the commands with a semi-colon (;).
+Required Headers+
tablename=<table name from table import spec>
version=<current version from table import spec>
Available Table Names
Table Name: EstimatesPackageData
Table Name: EstimatesComponentDetails
Table Name: FundingPackageDetail
Table Name: FundingPackageDetailAutoNumber
Table Name: TransactionsActuals
Table Name: TransactionsCommitments
Table Name: TransactionsEstimatesToComplete
Table Name: TransactionsFundingActions
Table Name: TransactionsFundingActions version =2.0
Table Name: TransactionsInvoiceDetails
Table Name: TransactionsPaymentDetails
Table Name: TransactionsPlannedContractValues
Table Name: TransactionsPurchaseRequests
Table Name: TransactionsTimePhasedBaselinePlans
Table Name: TransactionsTravelInProcess
Table Name: TransactionsUnpostedLabor
Table Name: LookupsAccounts
Table Name: LookupsBurdens
Table Name: LookupsBurdenRates
Table Name: LookupsDeliverableCategories
Table Name: LookupsEmployees
Table Name: LookupsEmployeeDetails
Table Name: LookupsEmployeeLaborRates
Table Name: LookupsFinancialMonths
Table Name: LookupsLaborClasses
Table Name: LookupsLaborClassRates
Table Name: LookupsLaborSubclasses
Table Name: LookupsLaborSubclassRates
Table Name: LookupsLocations
Table Name: LookupsTaskGroupCategories version=1.0
Table Name: LookupsTeammates
Table Name: LookupsVendors
Table Name: LookupsWBSCodes
Table Name: PerformanceEvalSurvey
Table Name: TaskManagementCLINs
Table Name: TaskManagementTasks
Table Name: TaskManagementSubTasks
Table Name: TaskPlanPackages
Table Name: TaskPlanResponseStatus
Table Name: RiskPackages
Table Name: RiskResponses
Table Name: TimekeepingJobs
Table Name: TimekeepingUserJobAssignments
Table Name: UtilitiesQueryGroupDefinitions
Table Name: UtilitiesQueryGroupDetails
Table Name: UtilitiesTaskGroupDefinitions version=1.0
Table Name: UtilitiesTaskGroups version=1.0
Table Name: UtilitiesVirtualAccounts
Table Name: UtilitiesVirtualAccountDetails
Table Name: SecurityUsers
Sample Header Command Line Formats
- options:overwrite=true;tablename=TransactionsFundingActions;version=1.0
- options:append=true;tablename=TransactionsFundingActions;version=1.0
- options:replacebykey=TaskCode,SubTaskCode;tablename=TransactionsFundingActions;version=1.0
- options:removebykey=SourceTransactionID;tablename=TransactionsFundingActions;version=1.0
- options:financialmonthmapping=TransactionDate;tablename=TransactionsFundingActions;version=1.0
- options:financialmonthmapping=FinancialMonthCode;financialmonthmapping=Custom1;tablename=TransactionsFundingActions;version=1.0
* Available Header Commands *
* Not all Header Commands are available for all Import Types. Refer to the specific Data Import File Specification to see what Header Commands are available.
+ If Required Import Header Commands are omitted from import file ,the imported file will subject to the latest required import specifications.
Page ID:2509-7179-3159