Sample CSV Format for Uploading Products

The following table lists the products that you want to create using the CSV format:
Product	Related to...	Relationship Type
Pensioners Savings Bank Account	-	-
Mortgage Loan Waiver	-	-
Locker Rental Waiver	-	-
Prime Credit Card	-	-
Platinum Debit Card	Prime Credit Card	Child
Sr. Citizen Privilege Saving Account	Pensioners Savings Bank Account	Child

Note that the system will create the above products when the required product types, characteristic types, predefined characteristic values, divisions, relationship types are defined in the application. In addition, the file request type which is used for uploading the product file in the CSV format must contain the following field transformation details:

The following table lists the field transformation details that you need to specify in the file request type using which you want to upload products in the system:
Sequence	Field Name	Map Field XPath
1	Product	C1_PRODUCT_BO/productCode
2	Description	C1_PRODUCT_BO/description
3	Product Type	C1_PRODUCT_BO/productTypeFlg
4	Product Category	C1_PRODUCT_BO/productCategoryFlg
5	Start Date	C1_PRODUCT_BO/startDate
6	End Date	C1_PRODUCT_BO/endDate
7	Compliance Number	C1_PRODUCT_BO/complianceNumber
8	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
9	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
10	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
11	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
12	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
13	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
14	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
15	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
16	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
17	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
18	Division	C1_PRODUCT_BO/0/productDivision/division
19	Division	C1_PRODUCT_BO/1/productDivision/division
20	Product	C1_PRODUCT_BO/0/productRel/productChildCd
21	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
22	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
23	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate
24	Product	C1_PRODUCT_BO/productCode
25	Description	C1_PRODUCT_BO/description
26	Product Type	C1_PRODUCT_BO/productTypeFlg
27	Product Category	C1_PRODUCT_BO/productCategoryFlg
28	Start Date	C1_PRODUCT_BO/startDate
29	End Date	C1_PRODUCT_BO/endDate
30	Compliance Number	C1_PRODUCT_BO/complianceNumber
31	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
32	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
33	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
34	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
35	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
36	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
37	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
38	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
39	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
40	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
41	Division	C1_PRODUCT_BO/0/productDivision/division
42	Division	C1_PRODUCT_BO/1/productDivision/division
43	Product	C1_PRODUCT_BO/0/productRel/productChildCd
44	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
45	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
46	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate
47	Product	C1_PRODUCT_BO/productCode
48	Description	C1_PRODUCT_BO/description
49	Product Type	C1_PRODUCT_BO/productTypeFlg
50	Product Category	C1_PRODUCT_BO/productCategoryFlg
51	Start Date	C1_PRODUCT_BO/startDate
52	End Date	C1_PRODUCT_BO/endDate
53	Compliance Number	C1_PRODUCT_BO/complianceNumber
54	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
55	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
56	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
57	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
58	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
59	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
60	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
61	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
62	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
63	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
64	Division	C1_PRODUCT_BO/0/productDivision/division
65	Division	C1_PRODUCT_BO/1/productDivision/division
66	Product	C1_PRODUCT_BO/0/productRel/productChildCd
67	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
68	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
69	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate
70	Product	C1_PRODUCT_BO/productCode
71	Description	C1_PRODUCT_BO/description
72	Product Type	C1_PRODUCT_BO/productTypeFlg
73	Product Category	C1_PRODUCT_BO/productCategoryFlg
74	Start Date	C1_PRODUCT_BO/startDate
75	End Date	C1_PRODUCT_BO/endDate
76	Compliance Number	C1_PRODUCT_BO/complianceNumber
77	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
78	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
79	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
80	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
81	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
82	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
83	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
84	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
85	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
86	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
87	Division	C1_PRODUCT_BO/0/productDivision/division
88	Division	C1_PRODUCT_BO/1/productDivision/division
89	Product	C1_PRODUCT_BO/0/productRel/productChildCd
90	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
91	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
92	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate
93	Product	C1_PRODUCT_BO/productCode
94	Description	C1_PRODUCT_BO/description
95	Product Type	C1_PRODUCT_BO/productTypeFlg
96	Product Category	C1_PRODUCT_BO/productCategoryFlg
97	Start Date	C1_PRODUCT_BO/startDate
98	End Date	C1_PRODUCT_BO/endDate
99	Compliance Number	C1_PRODUCT_BO/complianceNumber
100	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
101	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
102	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
103	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
104	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
105	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
106	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
107	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
108	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
109	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
110	Division	C1_PRODUCT_BO/0/productDivision/division
111	Division	C1_PRODUCT_BO/1/productDivision/division
112	Product	C1_PRODUCT_BO/0/productRel/productChildCd
113	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
114	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
115	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate
116	Product	C1_PRODUCT_BO/productCode
117	Description	C1_PRODUCT_BO/description
118	Product Type	C1_PRODUCT_BO/productTypeFlg
119	Product Category	C1_PRODUCT_BO/productCategoryFlg
120	Start Date	C1_PRODUCT_BO/startDate
121	End Date	C1_PRODUCT_BO/endDate
122	Compliance Number	C1_PRODUCT_BO/complianceNumber
123	Product Manager's To Do Role	C1_PRODUCT_BO/productManagerToDoRole
124	Characteristic Type	C1_PRODUCT_BO/0/productCharacteristic/characteristicType
125	Effective Date	C1_PRODUCT_BO/0/productCharacteristic/effectiveDate
126	Characteristic Value	C1_PRODUCT_BO/0/productCharacteristic/characteristicValue
127	Characteristic Type	C1_PRODUCT_BO/1/productCharacteristic/characteristicType
128	Effective Date	C1_PRODUCT_BO/1/productCharacteristic/effectiveDate
129	Characteristic Value	C1_PRODUCT_BO/1/productCharacteristic/characteristicValue
130	Characteristic Type	C1_PRODUCT_BO/2/productCharacteristic/characteristicType
131	Effective Date	C1_PRODUCT_BO/2/productCharacteristic/effectiveDate
132	Characteristic Value	C1_PRODUCT_BO/2/productCharacteristic/characteristicValue
133	Division	C1_PRODUCT_BO/0/productDivision/division
134	Division	C1_PRODUCT_BO/1/productDivision/division
135	Product	C1_PRODUCT_BO/0/productRel/productChildCd
136	Relationship Type	C1_PRODUCT_BO/0/productRel/productRelType
137	Start Date	C1_PRODUCT_BO/0/productRel/productRelStartDate
138	End Date	C1_PRODUCT_BO/0/productRel/productRelEndDate

100,Pensioners Savings Bank Account,TECH,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-TRANSBLE,2019-01-01,Y,C1-JOINTOP,2019-01-01,N,C1-STOPE,2019-01-01,N,DIV01,DIV10,,,,,111,Mortgage Loan Waiver,TECH,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-IMMPROPT,2019-01-01,Y,C1-STOPE,2019-01-01,N,,,,DIV01,DIV10,,,,,112,Locker Rental Waiver,TECH,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-FDMAND,2019-01-01,Y,C1-STOPE,2019-01-01,N,,,,DIV01,DIV10,,,,,113,Prime Credit Card,TECH,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-WECMGIFT,2019-01-01,Y,C1-STOPE,2019-01-01,N,,,,DIV01,DIV10,,,,,114,Platinum Debit Card,TECH,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-COMINSUR,2019-01-01,N,C1-STOPE,2019-01-01,N,,,,DIV01,DIV10,113,Child,2019-01-01,2019-12-31,101,Sr. Citizen Privilege Saving Account,BUSS,SAVG,2019-01-01,2019-12-31,,BANKMANG,C1-MERDIS,2019-01-01,Y,C1-STOPE,2019-01-01,Y,,,,DIV01,DIV10,100,Child,2019-01-01,2019-06-30

Related Topics

For more information on...	See...
CSV File Format for Uploading Products	CSV File Format for Uploading Products