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