Menu

#2720 (ok 2.11.8) Data loss on import resubmit

2.11.7
fixed
1
2013-06-11
2008-07-15
No

If a file is to big to upload via the import page and thus times out the page allows users to resubmit the same file and continue the import where it left off.

There is a small bug in this process (or at least there needs to be more documentation on the page). If the user enters a value other than zro in the "Number of records(queries) to skip from start" field then upon resubmission this value is still set and causes that many records to be skipped on the resubmit (which is results in an inadvertent loss of data).

Suggested fix - ignore the value in that field on the resubmit.

Discussion

  • Marc Delisle

    Marc Delisle - 2008-07-15
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2008-07-15

    Logged In: YES
    user_id=210714
    Originator: NO

    What about replacing the message
    Script timeout passed, if you want to finish import, please resubmit same file and import will resume.
    with
    Script timeout passed, if you want to finish import, please resubmit same file and import will resume. Do not use the "Number of records to skip" dialog.

     
  • Marc Delisle

    Marc Delisle - 2008-07-16

    Logged In: YES
    user_id=210714
    Originator: NO

    Better: when this happens, remove the input field in the "Number of records to skip" dialog and show instead how many will skipped.

     
  • Marc Delisle

    Marc Delisle - 2008-07-17
    • priority: 5 --> 1
    • summary: Data loss on import resubmit --> (ok 2.11.8) Data loss on import resubmit
    • status: open --> open-fixed
     
  • Stuart Chalk

    Stuart Chalk - 2008-07-22

    Logged In: YES
    user_id=1472046
    Originator: YES

    Having tested this more I realize that the issue I am seeing is not due to the "Number of records" skipped, but to missing the last record in a file if there is not "line terminating character" at the end of the file. It might be useful to indicate that on the import page...

     
  • Marc Delisle

    Marc Delisle - 2008-07-22

    Logged In: YES
    user_id=210714
    Originator: NO

    I'll open a new bug entry.

     
  • Marc Delisle

    Marc Delisle - 2008-07-28
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed