Create database from XML file; Web Front End for searching and data manipulation
$30-250 USD
着払い
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
プロジェクトID: #5356081
プロジェクトについて
32人のフリーランサーが、平均$296 で、この仕事に入札しています。
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 もっと
Hi, I can do this with guaranteed results, User experience will also be top grade, ready to discuss details. Best regards, Nader Moussa.
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 もっと
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 もっと
Hello, I can do that manipulation for you, I know that 15 days may be long period. We need your trust only :) Regards
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 もっと
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
We can do this in quick time. We are a team of expert web developers with lots of experience in web development.
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.
We are interested in assisting you in completing your project as we have the experience that is needed. Thank you for reviewing our bid.
I am an Expert in Web Design PHP web development Content Management Systems (CMS) E commerce solutions