Oracle Data Loader On Demand Guide > Sample Files >

Sample Data File

The following sample comma-separated value (CSV) data file is for account objects:

Account Name,Location,Main Phone #,Main Fax #,Web Site,Account Currency,Account Type,Priority,Industry,Public Company,Region,Annual Revenues,Number of Employees,Primary_Contact,Description,Billing Address,Shipping Address,Indexed Short Text 1,Indexed Long Text,Indexed Picklist 1,Custom Checkbox 0,Custom Currency 0,Custom Date 0,Custom Date/Time 0,Custom Integer 0,Custom Multi-Select Picklist 0,Custom Number 0,Custom Percent 0,Custom Phone 0,Custom Picklist 0,Custom Text (Long) 0,Custom Text (Short) 0,# Physicians,Indexed Checkbox,Indexed Currency,Indexed Number,Modified by Email Address,Owner_Full_Name,Row Id,Status

Accnt_1000001,Toronto,416-123-4567,905-123-4567,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1234,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000001,Active

Accnt_1000002,Toronto,416-123-4568,905-123-4568,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1235,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000002,Active

Accnt_1000003,Toronto,416-123-4569,905-123-4569,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1236,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000003,Active

Accnt_1000004,Toronto,416-123-4570,905-123-4570,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1237,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000004,Active

Accnt_1000005,Toronto,416-123-4571,905-123-4571,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1238,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000005,Active

Accnt_1000006,Toronto,416-123-4572,905-123-4572,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1239,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000006,Active

Accnt_1000007,Toronto,416-123-4573,905-123-4573,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1240,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000007,Active

Accnt_1000008,Toronto,416-123-4574,905-123-4574,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1241,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000008,Active

Accnt_1000009,Toronto,416-123-4575,905-123-4575,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1242,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000009,Active

Accnt_1000010,Toronto,416-123-4576,905-123-4576,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1243,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000010,Active

Accnt_1000011,Toronto,416-123-4577,905-123-4577,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1244,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000011,Active

Accnt_1000012,Toronto,416-123-4578,905-123-4578,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1245,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000012,Active

Accnt_1000013,Toronto,416-123-4579,905-123-4579,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1246,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000013,Active

Accnt_1000014,Toronto,416-123-4580,905-123-4580,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1247,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000014,Active

Accnt_1000015,Toronto,416-123-4581,905-123-4581,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1248,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000015,Active

Accnt_1000016,Toronto,416-123-4582,905-123-4582,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1249,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000016,Active

Accnt_1000017,Toronto,416-123-4583,905-123-4583,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1250,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000017,Active

Accnt_1000018,Toronto,416-123-4584,905-123-4584,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1251,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000018,Active

Accnt_1000019,Toronto,416-123-4585,905-123-4585,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1252,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000019,Active

Accnt_1000020,Toronto,416-123-4586,905-123-4586,http://crmondemand.com,USD,Customer,Medium,Energy,Y,East,"10,000.00",100,Mass,description,123 Ontario St,123 Ontario St,Short Text,Long Text,High,Y,100,11/14/08,5/30/08 12:00,1,"High,Low",1,1,416-555-1253,High,C Long Text,C Short Text,10,Y,150,111,first.last@company.com,company/user_sign_in,AAA_21000020,Active