Customer records without a "Customer ID"

Discussion in 'Optigold ISP' started by jkleensang, Sep 29, 2004.

  1. #1
    Recently, we had some random data loss from our Optigold database - for whatever reason, one day the DB server stopped responding and had to be rebooted. Since then we have run across customer records that are missing various information: usage, invoices, invoice line items, contact info, etc... No big deal, it happens - unfortunately we didn't have a recent enough backup that we wanted to use, so we had to deal.

    The main problem is that there are customer records that do not have a "customer ID" associated with them, and therefore all of the other information that was on their account is now orphaned. I could go through and delete their email accounts and other info, but some of them are active and I would rather re-associate it. Also, the main customer info cannot be deleted, so I cant really recreate the record.

    Big question: Can I get into the data tables (how) and reassign the customer ID back to the record so all of the associated info gets back "on the account"?

    Thanks,
    Josh
     
    jkleensang, Sep 29, 2004 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    The only way to do it would be to manipulate the tables directly via XML.
     
    digitalpoint, Sep 29, 2004 IP