1

Duplicate data (Read 280 times)


Bottle Opener

    I just went to look at some year of year reports and noticed that starting about 1 year ago all my workouts are logged twice.  I'm sure this is something that happened when I moved all my data over from the RW log.  Maybe a year ago I imported my data and did it again just a few weeks ago and didn't remember doing it the first time a year ago?

     

    Is there anyway to remove the dupilcates manually or would I have to delete them one at a time?  I suppose I could also just wipe out everything (is that possible?) and reimport everything from runners world then manually add the last 2 weeks of runs since I made the switch.

    Racing for Beer & Glory

    http://www.roadkillracing.com

     

    eric :)


      The duplicates started at around July last year.  I tried to delete them but the process is too complicated and I rather not risk any errors.  If you have the original data files, I can delete all workouts within the duplicated date range and then you can re-import the data.  How does that sound?


      Bottle Opener

        Yes I can get all the files still from RW, but I don't think I can export a date range from them.  I imagine I'll have to go into the .xml file and the tab file and delete out all the more recent data so that doesn't duplicate as well?

        Racing for Beer & Glory

        http://www.roadkillracing.com

         

        eric :)


          Here's how we can do it. 

          1. I'll delete the duplicated range.
          2. You'll import your data from RW
          3. DO NOT save them to your log (leave them in the import area)
          4. Let me know you've imported the data
          5. I'll delete the imported workouts that are duplicate of the workouts in your log, which should leave workouts in the duplicated range
          6. When you save them, that should produce a log without duplicates

          Make sense?


          Bottle Opener

            OK sounds good.

            Racing for Beer & Glory

            http://www.roadkillracing.com

             

            eric :)


              Can you verify that the duplicates started from Jan 24, 2003 to July 22, 2011 before I go deleting?  Thanks!


              Bottle Opener

                That looks right althought here is a lot of blank space from 2003 until 2008... but it is actually nonrunning blank space.

                Racing for Beer & Glory

                http://www.roadkillracing.com

                 

                eric :)


                  Ok.  Go ahead and import your data.


                  Bottle Opener

                    why can't things ever be easy... trying to upload both the zip files but everytime I hit upload it just deletes the path to the xml zip file and leaves that field blank.  I had a problem the first time I imported it but then I was getting an error message.

                    Racing for Beer & Glory

                    http://www.roadkillracing.com

                     

                    eric :)


                      I've imported your data.  Double check that the date ranges do not overlap to produce duplicates.  You can then click the "Save All" to move them into your log.