bugSVORI - Bugs: bug #19051, Import failed

 
 

bug #19051: Import failed

Submitted by:  Bruce Dawson <jbd>
Submitted on:  Tue 13 Feb 2007 02:57:17 PM UTC  
 
Category: DatabaseSeverity: 4 - Important
Item Group: NoneStatus: Fixed
Privacy: PublicAssigned to: Bruce Dawson <jbd>
Open/Closed: ClosedRelease: 134

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Tue 27 Feb 2007 03:09:22 AM UTC, comment #2:

I rewrote the import logic and ported it to the other modules that do importing. This version allows the headers to dictate what DB fields the data goes in.

Bruce Dawson <jbd>
Project AdministratorIn charge of this item.
Tue 13 Feb 2007 03:02:24 PM UTC, comment #1:

Turns out the old DB didn't have an Aliases field in the Offender table, which is before the key field in the new DB. When I imported data to the new DB, it "misplaced" the key field, resulting in the status being interpreted as the BOC # (and the key). Since the table can only have unique keys, subsequent records with the same status//key information were discarded.

Because the new database has several new fields, a number of the field values appear out-of-order.

This may require a re-write of the import logic to fix.

Bruce Dawson <jbd>
Project AdministratorIn charge of this item.
Tue 13 Feb 2007 02:57:17 PM UTC, original submission:

Import of old DB data into new DB failed; resulting DB was corrupted.

Bruce Dawson <jbd>
Project AdministratorIn charge of this item.

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by jbd (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 6 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Tue 27 Feb 2007 03:09:22 AM UTCjbdStatusIn Progress=>Fixed
      Open/ClosedOpen=>Closed
    Tue 13 Feb 2007 03:02:24 PM UTCjbdStatusInitial Report=>In Progress
    Tue 13 Feb 2007 02:57:17 PM UTCjbdCarbon-Copy-=>Added -unavailable-
      Carbon-Copy-=>Added -unavailable-
      Carbon-Copy-=>Added -unavailable-

    Back to the top


    Powered by Savane 3.1-cleanup1