MySQL Forums
Forum List  »  MySQL Workbench

Load Data... Workbench
Posted by: Karen Reynolds
Date: November 09, 2015 10:59AM

My old thread got closed. I am still getting an error message even when I take out my "local" word.

# -*- coding: utf-8 -*-
# MySQL Workbench Python script
# <description>
# Written in MySQL Workbench 6.3.4

LOAD DATA LOW_PRIORITY 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 (`ProjectTitle`, PeopleSoftLocationCode`, GeoPlanSiteAddress`, GeoPlanSiteCity`, GeoPlanSiteCounty`, GeoPlanSiteState`, SiteZipCode`, SiteName`, NetworkMarket`, ProjectType`, Priority`, PeopleSoftProjectNumber`, PeopleSoftProjectType`, VZWProjectManager`, BuildPlanYear`, StartDate`, ProjectStatus`, CellName`, CellNumber`, eNodeBID`, LatitudeDegreesNAD83`, LongitudeDegreesNAD83`, OnAirDate`, XNGWorkOrderNumber`, 850MHzOnAirDate`, 700MHzOnAirDate`, 1900MHzOnAirDate`, 2100MHzOnAirDate`, 2100MHzOnAirDate`, 850MHzActivationNoticeDate`, 700MHzActivationNoticeDate`, 1900MHzActivationNoticeDate`, 2100MHzActivationNoticeDate`, SARFLatitude`, SARFLongitude`, SiteAcquisitionRequestActualEndDate`, SiteAcquisitionRequestIndividualAssigned`, AssignREtasksActualEndDate`, AssignREtasksIndividualAssigned`, InitiateProjectActualEndDate`, InitiateProjectIndividualAssigned`, OrderCandidateSearchActualEndDate`, OrderCandidateSearchIndividualAssigned`, SubmitCandidateSitesActualEndDate`, SubmitCandidateSitesIndividualAssigned`, ApproveSearchCandidatesActualEndDate`, ApproveSearchCandidatesIndividualAssigned`, SelectPrimaryCandidateActualEndDate`, SelectPrimaryCandidateIndividualAssigned`, AssignCEEEtasksActualEndDate`, AssignCEEEtasksIndividualAssigned`, PerformSiteVisitwCEandRFActualEndDate`, PerformSiteVisitwCEandRFIndividualAssigned`, PerformSiteVisitwithCEandRFActualEndDate`, PerformSiteVisitwithCEandRFIndividualAssigned`, AcceptRejectCandidateActualEndDate`, AcceptRejectCandidateIndividualAssigned`, AntennaSelectionsActualEndDate`, AntennaSelectionsIndividualAssigned`, SubmitDealMemoforApprovalActualEndDate`, SubmitDealMemoforApprovalIndividualAssigned`, ConfirmDealMemoApprovalActualEndDate`, ConfirmDealMemoApprovalIndividualAssigned`, OrdercommercialpowerActualEndDate`, OrdercommercialpowerIndividualAssigned`, PerformPowerSiteWalkActualEndDate`, PerformPowerSiteWalkIndividualAssigned`, UploadTowerOwnersFAAandASRActualEndDate`, UploadTowerOwnersFAAandASRIndividualAssigned`, SubmitSurveyandFinalCLtoRFActualEndDate`, SubmitSurveyandfinalCLtoRFIndividualAssigned`, AssignTransportEngrtasksActualEndDate`, AssignTransportEngrtasksIndividualAssigned`, TransportFiberInquiryActualEndDate`, TransportFiberInquiryIndividualAssigned`, PerformTelcositewalkActualEndDate`, PerformTelcositewalkIndividualAssigned`, SignedserviceorderfromtelcoActualEndDate`, SignedserviceorderfromtelcoIndividualAssigned`, OrderNEPASection106ReportActualEndDate`, OrderNEPASection106ReportIndividualAssigned`, ProvideE911addressActualEndDate`, ProvideE911addressIndividualAssigned`, UpdateE911addressinGeoplanActualEndDate`, UpdateE911addressinGeoplanIndividualAssigned`, ReleaseprojectforRegulatoryfilingActualEndDate`, ReleaseprojectforRegulatoryfilingIndividualAssigned`, SelectPrimaryCandidateVersionActualEndDate`, SelectPrimaryCandidateVersionIndividualAssigned`, EnterEMISSiteActualEndDate`, EnterEMISSiteIndividualAssigned`, ExecuteLeaseActualEndDate`, ExecuteLeaseIndividualAssigned`, GetAntennaDesignActualEndDate`, GetAntennaDesignIndividualAssigned`, SubmitZoningDocsActualEndDate`, SubmitZoningDocsIndividualAssigned`, ZoningApprovedActualEndDate`, ZoningApprovedIndividualAssigned`, UpdateE911addressinNetSitesandXNGActualEndDate`, UpdateE911addressinNetSitesandXNGIndividualAssigned`, SubmitPreliminaryCDsforreviewActualEndDate`, SubmitPreliminaryCDsforreviewIndividualAssigned`, ProvideGeotechReportActualEndDate`, ProvideGeotechReportIndividualAssigned`, ReviewPreliminaryCDsConstructionActualEndDate`, ReviewPreliminaryCDsConstructionIndividualAssigned`, ReviewPreliminaryCDsEEActualEndDate`, ReviewPreliminaryCDsEEIndividualAssigned`, ReviewPreliminaryCDsRFActualEndDate`, ReviewPreliminaryCDsRFIndividualAssigned`, ReviewPreliminaryCDsRealEstateActualEndDate`, ReviewPreliminaryCDsRealEstateIndividualAssigned`, SubmitStructureFormActualEndDate`, SubmitStructureFormIndividualAssigned`, ReviewStructureFormActualEndDate`, ReviewStructureFormIndividualAssigned`, SubmitInServiceRequirementsActualEndDate`, SubmitInServiceRequirementsIndividualAssigned`, ConfirmSpectrumClearanceCertificateActualEndDate`, ConfirmSpectrumClearanceCertificateIndividualAssigned`, SubmitREConstructionDocsActualEndDate`, SubmitREConstructionDocsIndividualAssigned`, SubmitRFConstructionDocsActualEndDate`, SubmitRFConstructionDocsIndividualAssigned`, ReviewConstructionDocumentsActualEndDate`, ReviewConstructionDocumentsIndividualAssigned`, ConstructionClearancePendingGovernmentalAgencyActualEndDate`, ConstructionClearancePendingGovernmentalAgencyIndividualAssigned`, IssueRegulatoryConstructionClearanceActualEndDate`, IssueRegulatoryConstructionClearanceIndividualAssigned`, ReviewInServiceRequirementsActualEndDate`, ReviewInServiceRequirementsIndividuaLAssigned`, In_Service_ClearancePendingGovernmentalAgencyActualEndDate`, In_ServiceClearancePendingGovernmentalAgencyIndividualAssigned`, Issue_Regulatory_In_ServiceClearanceActualEndDate`, Issue_Regulatory_In_ServiceClearanceIndividualAssigned`, Submit_95_pct_CDs_Actual_End_Date`, Submit_95_pct_CDs_Individual_Assigned`, Release_project_to_file_BP_Actual_End_Date`, Release_project_to_file_BP_Individual_Assigned`, Review_95_pct_CDs_ConstructionActualEndDate`, Review_95_pct_CDs_ConstructionIndividualAssigned`, Review95pctCDsEEActualEndDate`, Review95pctCDsEEIndividualAssigned`, Review95pctCDsRFActualEndDate`, Review95pctCDsRFIndividualAssigned`, Review95pctCDsRealEstateActualEndDate`, Review95pctCDsRealEstateIndividualAssigned`, AwardExpressBidActualEndDate`, AwardExpressBidIndividualAssigned`, ObtainBuildingPermitActualEndDate`, ObtainBuildingPermitIndividualAssigned`, SubmitFinalCDsActualEndDate`, SubmitFinalCDsIndividualAssigned`, ReviewFinalCDsConstructionActualEndDate`, ReviewFinalCDsConstructionIndividualAssigned`, ReviewFinalCDsEEActualEndDate`, ReviewFinalCDsEEIndividualAssigned`, ReviewFinalCDsRFActualEndDate`, ReviewFinalCDsRFIndividualAssigned`, ReviewFinalCDsRealEstateActualEndDate`, ReviewFinalCDsRealEstateIndividualAssigned`, IssueNTPtoConstructionActualEndDate`, IssueNTPtoConstructionIndividualAssigned`, FundforBuildPlanConstructionActualEndDate`, FundforBuildPlanConstructionIndividualAssigned`, ConfirmE911UpdatesActualEndDate`, ConfirmE911UpdatesIndividualAssigned`, 911TVWReceivedActualEndDate`, 911TVWReceivedIndividualAssigned`, EnterEMISBatteryActualEndDate`, EnterEMISBatteryIndividualAssigned`, EnterEMISFuelTankandGeneratorActualEndDate`, EnterEMISFuelTankandGeneratorIndividualAssigned`, IssueWorkOrderActualEndDate`, IssueWorkOrderIndividualAssigned`, AwardContractActualEndDate`, AwardContractIndividualAssigned`, CompleteTowerPreConstructionNotificationActualEndDate`, CompleteTowerPreConstructionNotificationIndividualAssigned`, NotifyRevenueAssuranceActualEndDate`, NotifyRevenueAssuranceIndividualAssigned`, RFTranslationsActualEndDate`, RFTranslationsIndividualAssigned`, TowerFoundationDesignCompleteActualEndDate`, TowerFoundationDesignCompleteIndividualAssigned`, OrdertowerfromvendorActualEndDate`, OrdertowerfromvendorIndividualAssigned`, ConstructionStartsActualEndDate`, ConstructionStartsIndividualAssigned`, RFCloseoutpackagesubmittedActualEndDate`, RFCloseoutpackagesubmittedIndividualAssigned`, VisualMonitoringTicketActualEndDate`, VisualMonitoringTicketIndividualAssigned`, CompleteTowerPostConstructionNotificationActualEndDate`, CompleteTowerPostConstructionNotificationIndividualAssigned`, ConstructionEndsActualEndDate`, ConstructionEndsIndividualAssigned`, ConfirmConstructionEndsActualEndDate`, ConfirmConstructionEndsIndividualAssigned`, FinalCloseoutpackagesubmittedActualEndDate`, FinalCloseoutpackagesubmittedIndividualAssigned`, ClosepkgereviewedandacceptedbyConstructionActualEndDate`, ClosepkgereviewedandacceptedbyConstructionIndividualAssigned`, ProvideSweepsActualEndDate`, ProvideSweepsIndividualAssigned`, ReviewSweepsActualEndDate`, ReviewSweepsIndividualAssigned`, ResubmittoOperationsActualEndDate`, ResubmittoOperationsIndividualAssigned`, OpsAcceptRejectActualEndDate`, OpsAcceptRejectIndividualAssigned`, ConfirmOpsAcceptsActualEndDate`, ConfirmOpsAcceptsIndividualAssigned`, NOCTicketActualEndDate`, NOCTicketIndividualAssigned`, SiteTestCompletionActualEndDate`, SiteTestCompletionIndividualAssigned`, SubmitActivationNoticeActualEndDate`, SubmitActivationNoticeIndividualAssigned`, AttachCloseoutDocumentsActualEndDate`, AttachCloseoutDocumentsIndividualAssigned`, CloseoutAcceptRejectActualEndDate`, CloseoutAcceptRejectIndividualAssigned`, PerformSiteWalkActualEndDate`, PerformSiteWalkIndividualAssigned)SHOW WARNINGS;

Options: ReplyQuote


Subject
Views
Written By
Posted
Load Data... Workbench
1386
November 09, 2015 10:59AM
488
November 09, 2015 11:31AM
679
November 09, 2015 01:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.