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

EstimatesPackageData 

EstimatesComponentDetails 

FundingPackageDetail 

FundingPackageDetailAutoNumber 

TransactionsActuals 

TransactionsCommitments 

TransactionsEstimatesToComplete 

TransactionsFundingActions 

TransactionsFundingActions version =2.0 

TransactionsInvoiceDetails 

TransactionsPaymentDetails 

TransactionsPlannedContractValues 

TransactionsPurchaseRequests 

TransactionsTimePhasedBaselinePlans 

TransactionsTravelInProcess 

TransactionsUnpostedLabor 

LookupsAccounts 

LookupsBurdens 

LookupsBurdenRates 

LookupsDeliverableCategories 

LookupsEmployees 

LookupsEmployeeDetails 

LookupsEmployeeLaborRates 

LookupsFinancialMonths 

LookupsLaborClasses 

LookupsLaborClassRates 

LookupsLaborSubclasses 

LookupsLaborSubclassRates 

LookupsLocations 

LookupsTaskGroupCategories version=1.0 

LookupsTeammates 

LookupsVendors 

LookupsWBSCodes 

PerformanceEvalSurvey 

TaskManagementCLINs 

TaskManagementTasks 

TaskManagementSubTasks 

TaskPlanPackages 

TaskPlanResponseStatus 

RiskPackages 

RiskResponses 

TimekeepingJobs 

TimekeepingUserJobAssignments 

UtilitiesQueryGroupDefinitions 

UtilitiesQueryGroupDetails 

UtilitiesTaskGroupDefinitions version=1.0 

UtilitiesTaskGroups version=1.0 

UtilitiesVirtualAccounts 

UtilitiesVirtualAccountDetails 

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