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 …
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" ] } ] }
Copyright © Cloud Software Group, Inc. All rights reserved.