Find Jobs
Hire Freelancers

Write script for loading xml file into mysql; manually sync unique ids between this xml sourced data and another database.

$30-5000 USD

Lukket
Slået op over 16 år siden

$30-5000 USD

Betales ved levering
Import xml feed into MySQL. Specs are long so that we may be as specific as possible. **Part 1**: We have saved a database in an .xml format, and wish to parse the xml file as described below and to save it into a MySQL database. Attached to this request is a sample .xml file with a few records for you to view. The developer we choose will be given a complete .xml file with a several thousand records. This is a simple test project for us to evaluate RentACoder and individual service providers. We last used RAC in 2003 and am willing to give is another try as we have dozens of projects that have recently backed up. We could have easily done it ourselves. The script should be able to import data from the xml format, update records that are already in the database, and add any ones that are missing. **Part 2:** Match up the records that just got imported from the xml feed against video games listed at K L O V .com. ## Deliverables _INSTALLATION_ Coder will deliver (a) code, (b) mysql databases. Deliveries should be done after before too much work on Part 2 commences so client may be able to check work and bring attention to any small issues before they turn into larger ones. **Part 1 Notes:** On a regular basis we will have a new version of the .xml file and will have to rerun the importer. We are adding fields in the new database that do not come from the xml file. As such, we can’t simply truncate the data and re-import. For each .xml record, a lookup needs to be done in mysql. If the mysql record already exists, replace xml sourced fields found and change modification date field ‘date\_mod’. If the record doesn’t exist, insert it into mysql and add the current date as ‘date\_added’. (dates can be stored in unix time code format). Fields added to mysql should be everything found in the xml field (most of which is seen in the attachments), and a couple of new fields including ‘date\_added’ (unix time code), ‘date\_mod’ (blank on a new insert), and ‘k_id’ (blank until manually added in step 2 below. Unless we approve otherwise, ‘update upon duplicate key insert’ may be the most efficient way to proceed. The unique field from the .xml field is an ascii string, ‘name’ (“< P> Unsure how many tables need to be created, as this depends on an analysis of the full xml file. We do know there needs to be a ‘main’ table, as well as ‘roms’, ‘dips’ (for dipswitch settings), chips (types of cpu processors etc). There may have to be a few more tables too. Dipswitch is tricky??"separate table Field lengths should have room for everything in total xml file now plus a little buffer, especially for text fields. **Part 2 Notes:** In this database created, there was a field called k_id. This is going to be the game id field from the URL line at K L O V . COM. If you look at the sample xml files, there are a number of ‘Frogger’ related roms. One is called Frogger and has no ‘cloneof’ or ‘romof’ attribute. This is the main entry. Visit the URL and search for Frogger. Click on the entry and the new URL includes ‘game\_id=7857’. This 7857 id needs to be entered into ‘k\_id’ on every record in the database from Part 1 above where ‘Description’ in the database includes the name Frogger or for any record that is a clone of or romof the same game name as the main entry in the database above, which in this case is also ‘Frogger’. (Description=’Frogger’, look at game name, which also happens to be ‘Frogger’, then lookup ‘Frogger’ in database under cloneof and romof fields to see what other records need to be updated. This second part can probably be done partially by script and then partially by hand, as a number of entries won’t match automatically because of missing/extra words in the title or punctuation. For example, on the web site there is a title called “Act-Fancer: Cybernetick Hyper Weapon??. In the XML file there are 3 entries, all of which can be matched up: “Act-Fancer Cybernetick Hyper Weapon (World revision 1)?? for example. The differences here are a few words and a colon “:??. In a database entry can’t be found on the web site, enter k_id = 99999. If more than one entry appears on the web site with the same name, where ‘Class’ shows something normal, not ‘hack’ or ‘bootleg’. Update: web site contains 4424 game_ids. Not sure how many xml entries there are, probably a similar number, though the xml entries probably match up to only about 2500 web site ids. That is, for example... several 'Frogger' entries all map to the same web site id number. _DETAILS_ 1. Please do not bid on this project unless you have completed at least 5 projects on RAC and/or a similar leading site. 2. No easter eggs, spyware, unauthorized code. 3. Secure code. Validate input (and output as applicable). Should be secure against x-scripting, sql injection, etc (as applicable) 4. No charge for bug fixes within the first 120 days after delivery of final code, databases, and documentation. 5. No visible/invisible display of name/copyright other than ours. 6. Anonymous project: Don’t list us as a client on your website. If work is being done for one of our clients or individual sites, don’t list them either. 7. If work is done for one of our portfolio sites or clients, do not contact them directly unless we ask you to. 8. If applicable, please let us know if you are able to give us a URL where we may test the application while it is being developed. _DUE DATE:_ Once awarded, PART 1 product & deliverables due w/in 7 days. PART 2 completed, and all reported bugs from PART 1 and 2 fixed due by project due date. Be careful not to introduce new bugs while fixing old ones ??" TEST YOUR WORK. Please do not wait until the last minute as in our experience bug-fixing and application tuning always takes many more days than most developers realize. How to get a good rating: We will try to be very clear with our requirements. Let us know if we left something out or if you don’t understand something. Please take initiative. Let us know how we can make the project better. Good quality code is the most important thing to us. We get VERY UNHAPPY WITH BUGS that you should have found and fixed before we did! Our experience with outsourcing has been mixed, and we will no longer pay when our time is wasted doing too much quality checking and bug reporting! We are very picky. If that means you have to bid a little higher for a successful project, please do so. If this project is below your experience, please pick someone else who is less demanding??"otherwise it will be an unpleasant experience for both of us. If you like to finish 95% of a project and then don’t finish it because you get bored??"please do not bid. \---| Standard RAC deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform LAMP. Mysql 5.x, PHP 5.x The importer must be written in PHP, and be tested by a developer on a Linux system. We support PHP 5.x so 5.x functions may be used. Built-in PHP XML functions should be used so that future changes to the xml file format can be updated by us in minutes instead of hours. Code should be clean , easily readable, secure (validate I/O), and be internally documented as appropriate.
Projekt-ID: 2676839

Om projektet

3 forslag
Projekt på afstand
Aktiv 16 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
3 freelancere byder i gennemsnit $298 USD på dette job
Brug Avatar.
See private message.
$85 USD på 21 dage
4,9 (161 anmeldelser)
5,2
5,2
Brug Avatar.
See private message.
$170 USD på 21 dage
5,0 (25 anmeldelser)
4,3
4,3
Brug Avatar.
See private message.
$637,50 USD på 21 dage
0,0 (14 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
United States
5,0
9
Medlem siden jun. 2, 2003

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.