CSV File and JSON Config File Samples for Oracle Database
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
Copy
{
{
"oracleDirectoryName" : "PSI_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" ]
} ]
}