To Create the External Data Files
You can either create the spreadsheet and delimited text file or you can download the files from http://www.esnips.com/web/DataMashupSandraUseCaseFiles. Note that the name of the XLS file that is available to download has been changed from sandra-data.xls to company-data.xls for this exercise.
-
Create an Excel spreadsheet named company-data.xls that contains the following information:
EQ162
Funnel
Shelly glass and labs
LC05647
EQ763
Spirit
Torry Harris Equipment
LC23456
EQ785
Beaker
Torry Harris Equipment
LC23456
EQ232
Wire mesh
Angels Enterprises
LC34267
EQ892
Stirrer
Angels Enterprises
LC34267
EQ232
Wire mesh
Kittens Inc.
LC45634
EQ763
Asbestos sheets
Labkron Instruments
LC56473
EQ785
Beaker
Labkron Instruments
LC56473
EQ162
Funnel
Labtech Inc.
LC56743
EQ763
Asbestos sheets
Labtech Inc.
LC56743
EQ763
Spirit
Peter Labs and Instruments
LC63234
EQ563
Test tube
Peter Labs and Instruments
LC63234
EQ092
Pipette
Patel Lab Exports
LC67384
EQ243
Bunsen burner
Alaska Lab Equipment
LC76483
EQ892
Stirrer
Alaska Lab Equipment
LC76483
EQ162
Funnel
Safe Labs Inc.
LC87635
EQ563
Test tube
Davidson Equipment Exports
LC87645
EQ092
Pipette
Andrew Instruments
LC97627
EQ243
Bunsen burner
Andrew Instruments
LC97627
EQ162
Funnel
Andrew Instruments
LC97627
-
Create a delimited text file named supplier-address.txt that contains the following information:
LC76434|Yahoo Labs and Instruments|1285, 1st Avenue 69th and 70th, New York, NY 10021 LC76323|Isabel Instruments|330 SUNRISE HIGHWAY, ROCKVILLE CTR, NY 11570 LC76483|Alaska Lab Equipment|275 SOUTH STREET, OYSTER BAY, NY 11771 LC63234|Peter Labs and Instruments|430 E MAIN ST, BAY SHORE, NY 11706 LC34267|Angels Enterprises|2950 AVENTURA BLVD, AVENTURA, FL 33180 LC45634|Kittens Inc.|South Town Center, 10450 S State St, Sandy, UT 84070 LC87635|Safe Labs Inc.|Guadalupe Center, 333 Montezuma Ave, Santa Fe, NM 87501 LC56473|Labkron Instruments|Casis Village, 2700 Exposition, Austin, TX 78703 LC56743|Labtech Inc.|Midtown, 911 W 38th St, Austin, TX 78705 LC67384|Patel Lab Exports|3 University Dr, Augusta, ME 04330 LC05647|Shelly glass and labs|633 W 5th St Los Angeles, CA 90071 LC87645|Davidson Equipment Exports|South Town Center, 10450 S State St, Sandy, UT 84070 LC23456|Torry Harris Equipment|Fairlawn Drive Up, 5325 Sw 21st St, Topeka, KS 66604 LC97627|Andrew Instruments|Valero 4550, 115 N Greeley Hwy, Cheyenne, WY 82001
- © 2010, Oracle Corporation and/or its affiliates