Customer import help!

Discussion in 'Optigold ISP' started by steve35, Nov 17, 2005.

  1. #1
    Hello, I accidentaly deleted a customers record, I do however have a backup of yesterdays customer database that I can restore it from. I loaded yesterdays dbase and exported the customer data for my found set (the lost customer) When I exported selected all fields. However, When I try to reimport the customer into the current dbase it does not import properly? Barely any of the data shows up for the customer.

    I just need to export all the info for one customer from my backup dbase and import it into my live database. Can this be easily done?

    Thanks
     
    steve35, Nov 17, 2005 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
    There's not an "easy" way to do it because of all the related data from other tables. The best option would be to insert records at a lower level (via XML for example) directly into the tables you need to insert data into.
     
    digitalpoint, Nov 17, 2005 IP
  3. kclair

    kclair Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Is there a good resource with instructions for how to insert records via XML? From the forums and the list archives, all I've been able to determine is that it is possible.

    Thanks!
     
    kclair, Mar 23, 2006 IP