Deleting Bad Records in Database

  • Status Closed
  • Budget $30 - $100 USD
  • Total Bids 63

Project Description

Need someone to create a solution for extracting/deleting bad entries in a CiviCRM database. CiviCRM is a database module that is tied into drupal. 90% of it is MySQL and PHP based. You can look into the more detailed summary for how it works. Open to suggestions on how you would suggest to correct this along with any fair bid.

## Deliverables

Need someone to create a solution for extracting bad entries in CiviCRM. If you want to look at what this product looks like you can see an example of it at [url removed, login to view]

The system was opened up (now corrected) to allow users to sign themselves up. While it was open there was some sort of exploit that it was hit with and several 'user' accounts were created in Drupal; and of course for every Drupal user created there is a corresponding CiviCRM record that is created as well.

It's not too bad to go through and manually select Drupal accounts that look bogus. But the problem comes in trying to manually select the corresponding CiviCRM record for every bogus Drupal user. We're talking about **four to five hundred records** I think.

Am open to suggestions for the best solution to implement for cleaning up the day. Don't know if that would be a module, or a script. In any case I'm open to suggestions on the way you propose to clean it up along with your bid. Thank you.

* * *This broadcast message was sent to all bidders on Friday Mar 18, 2011 4:51:51 AM:

Based on some good questions from a few of the bidders I've had so far I am providing the following information to all of the bidders:

1) Yes I have access to the MySQL tables.

2) Since this is a decently complex relational database there should be plenty of fields to distinguish the "bogus" entries from the valid ones.

3) The documentation is wildly publicized since CiviCRM is an open-source project

4) you can join the CiviCRM forum to ask questions that will give you more detailed tech information if you need to.

The ideal candidate for this project would be someone that has a LAMP, WAMP, XAMP or other test server installed on their personal machine (desktop system is fine).

For those of you that are familiar with this kind of work you will know this is both common and ordinary. So setting up the test environment should take just a few minutes where you will import the data onto your test machine and then prove your script or other solution will work in that test environment that you've set up. You will need to have a web server running on your station. If you don't have a domain name then logging in by IP is fine. Alternatively I can provide an online test server for you to do your work on.

As this is a typically complex relational database I am looking into the tables that need to be identified for this script to work optimally. You'll win points with me if you identify the best fields before I do (I am not a programmer). Again since this is an open-source project all of the resources for this project are easily accessible online.

And for one last emphasis, you will need demonstrate to me on the test server (either mine or yours) that your script will work before I am ready to try it on the LIVE data.

Thank you for your interest in bidding on this project.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online