Re: Load Data... Workbench

[Karen Reynolds]

It is only loading the first three columns. )?) better than before, it wasnt loading squat.

LOAD DATA LOW_PRIORITY LOCAL INFILE `C:\\NWFFiles\\antennadump.csv` IGNORE INTO TABLE `protrack`.`antenna_tracker_import` CHARACTER SET latin1 FIELDS TERMINATED BY `,` OPTIONALLY ENCLOSED BY `"` ESCAPED BY `"` LINES TERMINATED BY `\r\n` IGNORE 1 LINES (`Project_Title`, `NWF_Location_Id`, `Network_Region`, `Network_Market`, `Project_Type`, `Expected_Completion_Date`, `Project_Status`, `Priority`, `PeopleSoft_Location_Code`, `PeopleSoft_Project_Number`, `PeopleSoft_Project_Type`, `BTA_Name`, `BTA_Number`, `GeoPlan_Site_Address`, `GeoPlan_Site_City`, `GeoPlan_Site_County`, `GeoPlan_Site_State`, `Site_Zip_Code`, `VZW_Project_Manager`, `Build_Plan_Year`, `Start_Date`, `Cell_Name`, `Cell_Number`, `Market_SID_Switch_Number`, `eNodeB_ID`, `Latitude_Degrees_NAD83`, `Longitude_Degrees_NAD83`, `LTE_Modification_Change_Order`, `LTE_Modification_Change_Order_Individual_Assigned`, `Assign_CE_and_EE_tasks`, `Assign_CE_and_EE_tasks_Individual_Assigned`, `Site_survey_completion`, `Site_survey_completion_Individual_Assigned`, `Assign_RE_tasks`, `Assign_RE_tasks_Individual_Assigned`, `Assign_site_acquisition_firm`, `Assign_site_acquisition_firm_Individual_Assigned`, `Site_acquisition_verified_start_date`, `Site_acquisition_verified_start_date_Individual_Assigned`, `Assign_transport_tasks`, `Assign_transport_tasks_Individual_Assigned`, `Bandwidth_Validation_Complete`, `Bandwidth_Validation_Complete_Individual_Assigned`, `Initiate_Project`, `Initiate_Project_Individual_Assigned`, `Confirm_E911_Updates`, `Confirm_E911_Updates_Individual_Assigned`, `ENode_B_Equipment_Ordered`, `ENode_B_Equipment_Ordered_Individual_Assigned`, `Systems_CQ_Complete`, `Systems_CQ_Complete_Individual_Assigned`, `RF_CQ_Complete`, `RF_CQ_Complete_Individual_Assigned`, `Systems_Configs_Complete`, `Systems_Configs_Complete_Individual_Assigned`, `Evaluate_Lease_Requirement`, `Evaluate_Lease_Requirement_Individual_Assigned`, `Upload_antenna_config`, `Upload_antenna_config_Individual_Assigned`, `Hybriflex_and_OVP_ordered`,`Hybriflex_and_OVP_ordered_Individual_Assigned`,`Structural`,`Structural_Individual_Assigned`,`Confirm_tower_mod_quote_mod_drawings`,`Confirm_tower_mod_quote_Individual_Assigned`,`Provide_mod_drawings_to_Construction_Tower_Mod_Quote_Approved`,`Award_ExpressBid_for_tower_mods_Confirm_Tower_Mod_PO_Issued`,`Award_ExpressBid_Individual_Assigned`,`Confirm_PO_issued_for_tower_mods`,`Confirm_PO_issued_for_tower_mods_Individual_Assigned`,`Tower_mod_work_started`,`Tower_mod_work_started_Individual_Assigned`,`Tower_mod_work_complete`,`Tower_mod_work_complete_Individual_Assigned`,`Tower_mod_inspection_complete`,`Tower_mod_inspection_complete_Individual_Assigned`,`Modify_Tower_Complete`,`Modify_Tower_Complete_Individual_Assigned`,`Submit_Deal_Memo_for_approval`,`Submit_Deal_Memo_for_approval_Individual_Assigned`,`Confirm_Deal_Memo_approval`,`Confirm_Deal_Memo_approval_Individual_Assigned`,`Accept_antenna_design_Ready_for_reg_filing_and_work_order`, `Accept_antenna_design_Ready_for_reg_filing_Individual_Assigned`,`All_Equipment_Received`,`All_Equipment_Received_Individual_Assigned`,`Material_Release_issued_for_all_equipment`,`Material_Release_issued_for_all_equipment_Individual_Assigned`,`ENode_B_Equipment_Installed`,`ENode_B_Equipment_Installed_Individual_Assigned`,`Issue_work_order`,`Issue_work_order_Individual_Assigned`,`Submit_Minor_Mod_Analysis`,`Submit_Minor_Mod_Analysis_Individual_Assigned`,`Review_MMOD_InService_Acceptance_For_700C`,`Review_MMOD_InService_Acceptance_For_Cellular`,`Review_MMOD_InService_Acceptance_Individual_Assigned`, `Review_MMOD_InService_Acceptance_For_PCS`,`Review_MMOD_InService_Acceptance_For_PCS_Individual_Assigned`,`Submit_Structure_Form`,`Submit_Structure_Form_Individual_Assigned`,`Review_Structure_Form`, `Review_Structure_Form_Individual_Assigned`, `Submit_InService_Requirements`,`Submit_InService_Requirements_Individual_Assigned`,`Confirm_Spectrum_Clearance_Certificate`,`Confirm_Spectrum_Clearance_Certificate_Individual_Assigned`,`Review_MMOD_InService_Acceptance_For_AWS_Individual_Assigned`,`Submit_RE_Construction_Docs`, `Submit_RE_Construction_Docs_Individual_Assigned`,`Submit_RF_Construction_Docs`, `Submit_RF_Construction_Docs_Individual_Assigned`,`Review_Construction_Documents`,`Review_Construction_Documents_Individual_Assigned`,`Issue_Regulatory_Construction_Clearance`,`Issue_Regulatory_Construction_Clearance_Individual_Assigned`,`Review_InService_Requirements`,`Review_InService_Requirements_Individual_Assigned`, `Issue_Regulatory_InService_Clearance`,`Issue_Regulatory_InService_Clearance_Individual_Assigned`,`Award_ExpressBid_to_contractor_for_installation`,`Verify_Regulatory_Approval`,`Verify_Regulatory_Approval_Individual_Assigned`,`Lease_Complete_Before_Construction`,`Lease_Complete_Before_Construction_Individual_Assigned`,`Lease_Complete_Not_Before_Construction`,`Lease_Complete_Not_Before_Construction_Individual_Assigned`,`Award_ExpressBid_installation_Individual_Assigned`, `PO_created_for_General_Contractor`,`PO_created_for_General_Contractor_Individual_Assigned`,`Verify_power_plant_status`,`Verify_power_plant_status_Individual_Assigned`,`Submit_preliminary_CDs`, `Verify_power_plant_status_Individual_Assigned`, `Submit_preliminary_CDs`,`Submit_preliminary_CDs_Individual_Assigned`,`Review_preliminary_CDs_Construction`,`Review_preliminary_CDs_Construction_Individual_Assigned`,`Review_preliminary_CDs_EE`, `Review_preliminary_CDs_EE_Individual_Assigned`, `Review_preliminary_CDs_RF`,`Review_preliminary_CDs_RF_Individual_Assigned`, `Review_preliminary_CDs_RE`,`Review_preliminary_CDs_RE_Individual_Assigned`,`Submit_Final_CDs`,`Submit_Final_CDs_Individual_Assigned`,`Review_final_CDs_Construction`,`Review_final_CDs_Construction_Individual_Assigned`,`Review_final_CDs_EE`,`Review_final_CDs_EE_Individual_Assigned`,`Review_final_CDs_RF`,`Review_final_CDs_RF_Individual_Assigned`,`Review_final_CDs_RE`,`Review_final_CDs_RE_Individual_Assigned`,`Zoning`,`Zoning_Individual_Assigned`,`Building_Permit`,`Building_Permit_Individual_Assigned`,`Issue_Notice_to_Proceed_to_Construction`,`Issue_Notice_to_Proceed_to_Construction_Individual_Assigned`,`Confirm_project_is_funded_for_construction`,`Confirm_project_is_funded_for_construction_Individual_Assigned`,`Construction_Starts`,`Construction_Starts_Individual_Assigned`,`Complete_Antenna_Changes`,`Complete_Antenna_Changes_Individual_Assigned`,`Closeout_Package_Provided_to_RF`,`Closeout_Package_Provided_to_RF_Individual_Assigned`,`Closeout_Package_Reviewed_and_Accepted_by_Construction`,`Closeout_Package_Construction_Individual_Assigned`,`Closeout_Package_Reviewed_and_Accepted_by_RF`,`Closeout_Package_Reviewed_and_Accepted_by_RF_Individual_Assigned`,`EndtoEnd_Integration_Complete`,`EndtoEnd_Integration_Complete_Individual_Assigned`,`Optimization_Complete`,`Optimization_Complete_Individual_Assigned`,`Submit_Activation_Notice`, `Submit_Activation_Notice_Individual_Assigned`,`Attach_Closeout_Documents`,`Attach_Closeout_Documents_Individual_Assigned`,`Closeout_Accept_Reject`,`Closeout_Accept_Reject_Individual_Assigned`,`Submit_reduced_design_to_structural_engineer`, `Submit_reduced_design_to_structural_engineer_Individual_Assigned`, `Reduced_design_fails_structural`,`Reduced_design_fails_structural_Individual_Assigned`,`Reduced_design_passes_structural`,`Reduced_design_passes_structural_Individual_Assigned`,`Reduced_RF_design_provided_by_RF`,`Reduced_RF_design_provided_by_RF_Individual_Assigned`,`Confirm_that_contractor_on_BP_matches_winning_bidder`,`Confirm_that_contractor_matches_bidder_Individual_Assigned`,`CQ_requested_by_Systems`,`CQ_requested_by_Systems_Individual_Assigned`,`CQ_complete_by_Systems`,`CQ_complete_by_Systems_Individual_Assigned`,`Antennas_Ordered`,`Antennas_Ordered_Individual_Assigned`,`Shelter_Equipment_Received`,`Shelter_Equipment_Received_Individual_Assigned`,`CQ_confirmed_built_and_loaded`,`CQ_confirmed_built_and_loaded_Individual_Assigned`,`CQ_complete_by_RF`,`CQ_complete_by_RF_Individual_Assigned`,`Award_ExpressBid_to_contractor_for_shelter_work`,`Award_ExpressBid_to_contractor_for_shelter_Individual_Assigned`,`Material_Release_issued_for_tower_equipment`,`Material_Release_issued_for_tower_equipment_Individual_Assigned`, `Tower_equipment_install_scheduled_Individual_Assigned`, `Shelter_equipment_install_scheduled`,`Tower_equipment_install_scheduled`) SHOW WARNINGS;