Capture info from Website
$30-100 USD
Dibayar saat pengiriman
PHP or Perl Script to Capture info from a website and insert into mySQL database.
## Deliverables
Screen scrape capture the Companies and other registrations from this website and page:
<[url removed, login to view]>
This is open and Public Domain information.
Table fields should be as follows:
1. Date:? [DATE] {date and time of capture (now)}
2. Source: [VARCHAR 40] {[url removed, login to view] registrations}
3. Enterprise_name: [VARCHAR 100] {long names possible and extended ASCII Characters must be allowed} Typical long name and sometimes longer: "**OCEAN BLUE INFORMATION MANAGEMENT SOLUTIONS"**
4. Enterprise_number: [VARCHAR 20] {} Typically "2010/091030/23"
5. Enterprise_activity: [TEXT] {} Typically "SALE MAINTENANCE AND REPAIR OFMOTOR VEHICLES AND MOTOR R CYCLES;RETAIL TRADE IN AUTOMOTIVE FUEL"
6. Enterprise_region: [VARCHAR 40]{Province} Typically "Kwa-Zulu Natal"
7. Enterprise Postal Addres: {This cell containes FIVE lines of which the last one is always Postal Code - To be split in FIVE Fields}
[Each Field VARCHAR 50]
7a. address_1
7b. address_2
7c. address_3
7d. address_4
7e. Postal_Code
Note:?
Duplicates not allowed. Can be tested on Enterprise Registration number. Could be done by making this field Unique.
ID Proyek: #3517688