UPDATE  `jos_cw_ripper_map` SET row_offset=2,col_offset=4 WHERE customer_id=1 AND field_name='cust_job_id';
UPDATE  `jos_cw_ripper_map` SET row_offset=2,col_offset=2 WHERE customer_id=1 AND field_name='order_id';
UPDATE  `jos_cw_ripper_map` SET row_offset=10,col_offset=4 WHERE customer_id=1 AND field_name='c_o';
UPDATE  `jos_cw_ripper_map` SET row_offset=4,col_offset=4 WHERE customer_id=1 AND field_name='disp_date_time';
UPDATE  `jos_cw_ripper_map` SET row_offset=4,col_offset=2 WHERE customer_id=1 AND field_name='jc_address1';
UPDATE  `jos_cw_ripper_map` SET row_offset=5,col_offset=2 WHERE customer_id=1 AND field_name='jc_address2';
UPDATE  `jos_cw_ripper_map` SET row_offset=6,col_offset=2 WHERE customer_id=1 AND field_name='jc_city';
UPDATE  `jos_cw_ripper_map` SET row_offset=7,col_offset=2 WHERE customer_id=1 AND field_name='jc_state';
UPDATE  `jos_cw_ripper_map` SET row_offset=8,col_offset=2 WHERE customer_id=1 AND field_name='jc_zip';

INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'MasterOrderNum', 'varchar', 20, 3, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'jc_name', 'varchar', 50, 3, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'Commitment', 'varchar', 25, 5, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'CanBeReached', 'varchar', 25, 7, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'BTN', 'varchar', 25, 8, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'CircuitID', 'varchar', 25, 9, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'WorkCenter', 'varchar', 10, 10, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'WireCenterCode', 'varchar', 25, 11, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'WireCenterNum', 'varchar', 25, 11, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'Remarks', 'text', 511, 13, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropTermAddress', 'varchar', 50, 16, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropTermName', 'varchar', 25, 16, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'RelatedTermAddress', 'varchar', 25, 17, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'SplitterHubName', 'varchar', 25, 18, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DistFiberStrand', 'int', 11, 18, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropTermPort', 'int', 11, 19, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropFiberType', 'varchar', 25, 19, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'SplitterHubGPSLat/Long', 'varchar', 25, 20, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropTerminalGPSLat/Long', 'varchar', 25, 20, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'ONTAction', 'varchar', 25, 22, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'ONTType', 'varchar', 25, 22, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'ONTMake', 'varchar', 25, 23, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'ONTModel', 'varchar', 25, 23, 4);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'ONTGPSLat/Long', 'varchar', 25, 24, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'DropType', 'varchar', 25, 36, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'Drop_Terminated', 'varchar', 25, 44, 2);
INSERT INTO `jos_cw_ripper_map` VALUES ('', 1, 'Sub_Location', 'varchar', 50, 9, 2);