Create database from XML file; Web Front End for searching and data manipulation

完了済み 投稿 Jan 24, 2014 着払い
完了済み 着払い

There is a state provided XML document that has all the registered business' in the state of Washington that is published every week on Monday.

View Information regarding XML contents here

[login to view URL]

We would like the data to be downloaded automatically and then imported into a database every week.

We have setup a MySQL server for this project.

Requirements for data manipulation.

1. Sort by / Search by all fields

2. Sort by / Search by distance (From Our Office / location that we can enter for global searches)

3. Have address / map show of address using Google Maps

4. Ability to save Searches / Email reports in Excel or CSV format

5. Ability to recall old search and re-run / schedule to run automatically

5. Tie company / Business from above search to a Google Search (Make company name clickable in search results - brings up Google search in new window)

a. Verify Address; by clicking on address listed - brings up Google Maps in New window

The following is an explanation of the elements/fields found within the files. You can also view the XML Schema.

[login to view URL]

UBI - Washington State Unified Business Identifier

Business Name - Legal name as record with OSOS

Category - Three letter abbreviation for the entity structure. View the category definitions by code.

[login to view URL]

State Of Incorporation - The state of origination

Date Of Incorporation - The date the entity filed with OSOS

Expiration Date - The date the most recent annual report is/was due

Dissolution Date - The date the entity was dissolved if applicable

Duration - Duration of corporation, specified in years. perpetual or unspecified

Active - Indicates that the entity has not been dissolved, Inactive means the entity is dissolved

Type - Indicates whether the entity is a profit or non-profit

Registered Agent Name - The name of the registered agent i.e. contact person

Registered Agent Address - The physical address of the registered agent

Registered Agent City - The city in which the Agent Address is located

Registered Agent State - The state in which the Agent Address is located

Registered Agent Zip - The zip code for the Agent Address

Alternate Address - The agent mailing address if different from the Agent’s Address

Alternate City - The city in which the Alternate Address is located

Alternate State - The state in which the Alternate Address is located

Alternate Zip - The zip code for the Alternate Address

Governing Person Title - The title (president, vice-president, member, etc.) of the person listed as a Governing person

Governing Person First Name - The first name of the Governing Person

Governing Person Middle Name - The middle name of the Governing Person

Governing Person Last Name - The last name of the Governing Person

Governing Person Address - The address for the Governing Person

Governing Person City - The city in which the Governing Person Address is located

Governing Person State - The state in which the Governing Person Address is located

Governing Person Zip - The zip code for the Governing Person Address

データベース管理 MySQL PHP ソフトウェアアーキテクチャ XML

プロジェクトID: #5356081

プロジェクトについて

32個の提案 リモートプロジェクト アクティブ Jan 27, 2014

アワード:

andybeal

The solution for this project will include: 1. PHP website capable of searching and displaying data from MySQL. 1a. Search all fields case insensitive including partial matches (searching for bellingh will return もっと

$138 USD 7日以内
(4レビュー)
2.9

32人のフリーランサーが、平均$296 で、この仕事に入札しています。

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro もっと

$463 USD 2日以内
(967件のレビュー)
8.7
rsen75

hi, i'm 14+ experienced with strong knowledge of API integration for many CMS and e-Com see my few portfolio **WooCommerce Payment Plugins ccavenue wolrd / paypal pro /SEYLAN bank/libertyreserve/perfectmo もっと

$210 USD 5日以内
(188件のレビュー)
7.1
ajaxdevman

Hi, I can do this with guaranteed results, User experience will also be top grade, ready to discuss details. Best regards, Nader Moussa.

$400 USD 10日以内
(44件のレビュー)
7.0
Meagan26

Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. I have been working in the field of web もっと

$257 USD 3日以内
(228件のレビュー)
7.3
goswamiarpit475

Hi Sir, I am ready to work for you.I have 4 years of experience in mysql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please vi もっと

$155 USD 7日以内
(38件のレビュー)
5.6
Beacon09

Hi I just fully read the detailed requirements. I am going to check the current XML data now. I am quite interested in this project. I am a recent BS(CS) qualified individual with expertise in web development, I am Mic もっと

$250 USD 15日以内
(32件のレビュー)
5.3
workbeezcom

Hi, I can build a software either web software or desktop software, that manipulate XML file and offer to you a friendly interface to seek any data you need including your requirements. let me know if you are i もっと

$555 USD 3日以内
(14件のレビュー)
5.4
elboukharimu

Aucune proposition n'a encore été fournie.

$200 USD 7日以内
(35件のレビュー)
5.3
Aehandasa

Hello, I can do that manipulation for you, I know that 15 days may be long period. We need your trust only :) Regards

$355 USD 15日以内
(30件のレビュー)
4.7
corpotec1993

Hello Dear Deata, I have worked on this type data saving from xml to mysql - give me 24 hours, I will provide you the demo-I am interested in assisting you in completing your project as I have the experience that is ne もっと

$250 USD 5日以内
(37件のレビュー)
4.7
kushanx

Hi I am an expert PHP/mySQL developer with more than 14 years of experience. I can develop a PHP solution that would automatically download and upload records to a mySQL database in a designated frequency. Then mani もっと

$250 USD 5日以内
(50件のレビュー)
4.7
balamuralip

hi there...we are expert programmer we can work with you as per requirements and we can work with ease in xml..so please consider me thank you

$222 USD 3日以内
(17件のレビュー)
4.3
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, もっと

$277 USD 5日以内
(5件のレビュー)
4.3
codeteam

We can do this in quick time. We are a team of expert web developers with lots of experience in web development.

$277 USD 7日以内
(10件のレビュー)
4.4
brahmaniinfoline

Hello sir, I am Prashant. I have a 3.6 years Experience as a PHP Web developer(Drupal,Wordpress, Prestashop,core php,smarty). I can do this project. I am waiting for your reply. Thank you.

$244 USD 7日以内
(11件のレビュー)
4.0
decodeworld

We are interested in assisting you in completing your project as we have the experience that is needed. Thank you for reviewing our bid.

$83 USD 4日以内
(10件のレビュー)
3.8
sunnylove

It's is simple with me ! I think I can do it ! Please hire me :), I'm a new member in freelancer, but I have 7 year of experience about website designer and website developer ! My experience shows that I can help もっと

$120 USD 3日以内
(2件のレビュー)
2.4
ilamvazhuthicare

I am an Expert in Web Design PHP web development Content Management Systems (CMS) E commerce solutions

$222 USD 3日以内
(0件のレビュー)
0.0
mdierc

Er is nog geen voorstel voorzien

$222 USD 5日以内
(0件のレビュー)
0.0