I need a PHP script created to scrape these pages for event data:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
The script should parse through events from each state via this URL:
[login to view URL]
Make sure to grab URL for the event/organization logo.
The data will need to be pushed to a staging table initially (you'll need to create it), then to another table, structure below:
create table `events_copy` (
`ID` int (11),
`Title` varchar (600),
`ShortDescription` varchar (600),
`Description` text ,
`StartDate` date ,
`EndDate` date ,
`StartTime` time ,
`EndTime` time ,
`MinAge` int (3),
`MaxAge` int (3),
`Latitude` double ,
`Longitude` double ,
`Cost` Decimal (17),
`Address` varchar (600),
`City` varchar (300),
`State` varchar (300),
`Postalcode` varchar (60),
`Country` varchar (300),
`Duration` varchar (150),
`Days` varchar (150),
`URL` varchar (765),
`Status` char (24),
`Type` char (21),
`OrganizationName` varchar (300),
`Source` varchar (150),
`SourceID` int (11),
`CategoryID1` int (3),
`CategoryID2` int (3),
`CategoryID3` int (3),
`Gender` char (18),
`Image` varchar (765),
`created` timestamp
);
The script needs to pull all pages.
The fields you'll need to populate from this script are:
Title
Description
StartDate
EndDate
StartTime
EndTime
MinAge
MaxAge
Cost
Address fields
URL (this should point to the individual event)
OrganizationName (this will be from each URL that is searched in the URL table)
Image (Link to the Logo)
Final delivery should include:
Table structures in SQL for source data and URL table.
Scraping Script
ETL Script
Spreadsheet of Events for final review.
I will ignore anything without a timeline. My specs should be very clear, if not, please ask [login to view URL] project uses PHP.
Hi, I can do this project and provide
Table structures in SQL for source data and URL table.
Scraping Script
ETL Script
as per your requirements,
however I need you to raise budget and provide more details on how you wish "Spreadsheet of Events for final review" to be formated.
Thanks!
Hi sir,
I am scraping expert, I have did too many similar projects, please check my feedback then you will know.
Can you tell me more details? then I will provide demo data for you.
Thanks,
Kimi
Dear Client,
Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned .I have checked your requirements.i have right skills to work on this assignment
Here we would like to bring in your notice that
We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform.
We find our expertise, skills and capabilities are perfectly blends with your project requirements because we have already worked on many projects. For Quality Purpose we use : Testing of project in different stages” like module testing, integration testing and system testing. So there will be less probability of any error or issue".can u provide your email or sky-pe etc for further discussion about the project. plz add me to discus
I am ready to discuss with you Looking forward to hear from you.
with best Regards