CSV File and JSON Config File Samples

The following are samples of the CSV files for items and item characteristics and the bulk load JSON configuration file:

items.csv File Sample

ID_0,ItemType,Active,owner,creator,01-JAN-2014 05.40.12 PM,0,0, PARTY_ID_0, PRODUCT_ID_0,01-JAN-2014 05.40.12 PM
ID_1,ItemType,Active,owner,creator,01-JAN-2014 05.40.12 PM,1,0, PARTY_ID_1, PRODUCT_ID_1,01-JAN-2014 05.40.12 PM
…

items_characs.csv File Sample

Charac_ID_0_0,ID_0,Name1,Value1
Charac_ID_0_1,ID_0,Name2,Value2
…

JSON Config File Sample

{  
	"oracleDirectoryName" : "FSI_BULK_DIR",  
	"timeStampFormat" : "DD-MON-YYYY HH12.MI.SS PM",  
	"commitSize" : 100,  
	"entities" : [ {
		 "type" : "PARTY",    
			"dataSourceName" : "party.csv",    
			"dataSourceColumnList" : [ "ID", "PARTY_REF", "NAME", "PARTY_TYPE", "SUB_TYPE", "STATUS", "PARENT_PARTY_ID", "OWNED_BY", "CREATED_BY", "CREATED_ON", "UPDATED_BY", "UPDATED_ON", "VERSION", "DELETED" ]  
	}, {
   "type" : "PARTY_CHARACTERISTIC",    
			"dataSourceName" : "party_characs.csv",    
			"dataSourceColumnList" : [ "ID", "PARTY_ID", "CHARACTERISTIC_NAME", "CHARACTERISTIC_VALUE" ]  
	}, {
   "type" : "ITEM",    
			"dataSourceName" : "items.csv",    
			"dataSourceColumnList" : [ "ID", "ITEM_REF", "PRODUCT_ID", "PRODUCT_VERSION", "NAME", "ITEM_TYPE", "SUB_TYPE", "STATUS", "PARTY_ID", "START_DATE", "END_DATE", "OWNED_BY", "CREATED_BY", "CREATED_ON", "UPDATED_BY", "UPDATED_ON", "VERSION", "DELETED" ]  
	}, {
   "type" : "ITEM_CHARACTERISTIC",    
			"dataSourceName" : "item_characs.csv",    
			"dataSourceColumnList" : [ "ID", "ITEM_ID", "CHARACTERISTIC_NAME", "CHARACTERISTIC_VALUE" ]  
	}, {
   "type" : "ITEM_RELATIONSHIP",    
			"dataSourceName" : "item_relationships.csv",    
			"dataSourceColumnList" : [ "ID", "ITEM_ID", "FORWARD_TYPE", "REVERSE_TYPE", "CHILD_ITEM_ID" ]  
	}, {
   "type" : "ITEM_ORDER",    
			"dataSourceName" : "item_orders.csv",    
			"dataSourceColumnList" : [ "ITEM_ID", "ID", "ORDER_REF", "ORDER_DATE", "LINE_NUMBER", "LINE_ACTION", "LINE_ACTION_MODE", "PLAN_ITEM_ID", "PLAN_ITEM_ACTION" ]  
	}, {
   "type" : "ITEM_ORDER_COMMENTS",    
			"dataSourceName" : "item_order_comments.csv",    
			"dataSourceColumnList" : [ "ORDER_ID", "COMMENT_DETAIL" ]  
	} ]
}