悦跑圈导出数据时存在记录缺失的情况

[xilinshuishi]

悦跑圈上有230条跑步记录，只导出了151条，大致检查了后发现2021年的数据全部缺失。 【2022-12-23】注：我搞混了，是230条动态，实际跑步记录为216次，户外跑了152次，跑步机上跑了64次，跑步机数据全部缺失。

[yihong0618]

删掉 data.db 重新跑一次试试？

[xilinshuishi]

删掉 data.db 重新跑一次试试？

删掉了重试了，这次同步了152条，因为我早上又跑了一次。2021年数据依旧丢失。一直打印++++++++limit++++++++

[yihong0618]

明白了，这么看很可能是你 2021 年没有地理位置数据。

[xilinshuishi]

明白了，这么看很可能是你 2021 年没有地理位置数据。

我好像知道原因了，2021 年我都是在跑步机上跑的，地理位置数据没变化

[yihong0618]

你把 gpx 导出后备份，再删掉 data.db. 可以试试不加 --gpx 跑步机跑的应该有距离数据。

[xilinshuishi]

你把 gpx 导出后备份，再删掉 data.db. 可以试试不加 --gpx 跑步机跑的应该有距离数据。 删掉了，好像导不出数据了，data.db变得很小。执行：python scripts/joyrun_sync.py 133XXXX1234 123456，结果如下：

[yihong0618]

不加 gpx 就没有数据了？

[xilinshuishi]

不加 gpx 就没有数据了？

是的，我试了很多次，只重复打印 ++++++++limit++++++++

[yihong0618]

好的我一会儿看看

[xilinshuishi]

好的我一会儿看看

好的，感谢

[yihong0618]

我确认下哈：

1. 加上 --gpx 是只有 2021 你跑步机跑的没有数据（both 前端 and 后端）
2. 不加 --gpx 都没有数据
3. 你每次都先删除了 data.db 重新跑的

@xilinshuishi

[xilinshuishi]

1、我刚才统计了所有跑步记录，总计216次，其中户外跑了152次，跑步机上跑了64次（2021年51次，2022年13次），跑步机数据全部缺失，户外跑的都在。注：加上 --gpx 只可以导出全部户外数据，不加--gpx，户外和跑步机数据都无法导出。 2、是的 3、是的 @yihong0618

[yihong0618]

@xilinshuishi 没找到原因，更新了下你试试

1. 需要拉一下最新代码
2. 需要把 GPX_OUT 里的文件备份到其它地方，删掉 data.db 试试
3. 还是不好用可以 tg 联系我，tg yihong0618 我们一起看看

[xilinshuishi]

拉取了最新代码，导出依旧是152条，不加 --gpx 无法导出，问题和之前一样。我tg联系你了。

[yihong0618]

没收到你的信息，你进这个群试试？ https://t.me/running_page

[xilinshuishi]

@xilinshuishi 没找到原因，更新了下你试试

1. 需要拉一下最新代码
2. 需要把 GPX_OUT 里的文件备份到其它地方，删掉 data.db 试试
3. 还是不好用可以 tg 联系我，tg yihong0618 我们一起看看

找到原因了，在跑步机上跑步的记录，详情接口没有返回经纬度数据，所以没有导出 1、跑步的总记录数据 = 户外跑步次数 + 跑步机跑步次数，这是对的，217条 2、某条跑步机记录，没有经纬度数据 3、某条户外跑步记录，有经纬度数据 4、pass the track no points

[yihong0618]

感谢，有兴趣提个 PR 么？

[xilinshuishi]

感谢，有兴趣提个 PR 么？ 目前好像没办法解决这个问题，跑步机数据没有经纬度，这是完整的某次跑步机跑步数据 { 'ret': '0', 'sid': 'ec91b39921afc42f48', 'runrecord': { 'endtime': 1636887059, 'uid': 17777158, 'fid': 62883635, 'fraudSubStatus': 0, 'sampleinterval': 5, 'second': 2030, 'altitude': '', 'nodeattach': [ ['0', '0', '66'], ['0', '0', '130'], ['0', '0', '193'], ['0', '0', '255'], ['0', '0', '316'], ['0', '0', '378'] ], 'fraud': 0, 'type': 7, 'city': '苏州', 'private': 0, 'pause': [], 'meter': 6447, 'wgs': 1, 'heartrate': '[]', 'province': '江苏', 'weather': '{"pm25":62,"quality":"良","temp":9,"weather":"晴","weatherCodeV4":"sunnyNight","wind":"西风0级"}', 'stepcontent': '[["8","8.4"],["10","10.5"],["13","13.65"],["14","14.7"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["14","14.7"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["16","16.8"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["14","14.7"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["18","18.9"],["13","13.65"],["16","16.8"],["14","14.7"],["16","16.8"],["18","18.9"],["13","13.65"],["16","16.8"],["18","18.9"],["12","12.6"],["18","18.9"],["16","16.8"],["13","13.65"],["18","18.9"],["15","15.75"],["16","16.8"],["15","15.75"],["12","12.6"],["16","16.8"],["18","18.9"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["0","0.3"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"],["16","16.8"],["15","15.75"],["15","15.75"]]', 'daka': 434, 'stepremark': '[]', 'starttime': 1636885014, 'status': 1, 'url': 'http://wap.thejoyrun.com/po_17777158_628836365.html', 'content': '', 'node': [ ['1000', '329'], ['2000', '648'], ['3000', '962'], ['4000', '1272'], ['5000', '1580'], ['6000', '1887'] ], 'source': '', 'totalsteps': 6140, 'postRunId': 586740665 }, 'lasttime': 1672045665, 'msg': '成功' }

[yihong0618]

明白了，我找时间看看