Importing data from Fitnotes

[djorna]

It would be nice to be able to import data from FitNotes for users wanting to transition. It probably isn't possible to parse .fitnotes files (which appear to be SQL DBS), but kt might be possible with FitNotes's "Export Spreadsheet" feature.

[MakisChristou]

Hey! There is a CSV import feature and it should be compatible with Fitnotes CSVs

[RoyS122]

Hello, that's currently doesn't work on my side, I will check différences between the save and maybe create a converter 😁

[djorna]

Yeah it doesn't seem to be working for me either

Here are the columns in FitNotes for reference:
Date, Exercise, Category, Weight, Weight Unit, Reps, Distance, Distance Unit, Time, Comment

[RoyS122]

Maybe you can try that, I haven't tried for the moment but it can work

https://github.com/abdualdeen/fitnotes-verifit-data-conversion

[RoyS122]

This script (i've made some modification between this and the link i sent to you) work on my side

Another thing, @MakisChristou on your exports files there's float types on repetitions field, i think it should be only integer values 🤔

usage: python3 converter.py "fitnotes_path.csv"

import argparse
from pathlib import Path
import csv

VERIFIT_COLUMNS = 'Date,Exercise,Category,Weight (kg),Reps,Comment\n'

def main():
    parser = argparse.ArgumentParser(prog='convert', description='Converts FitNotes backup to a format verifit can import.')
    parser.add_argument('fitNotesFilePath', help='FitNotes CSV backup file path.')
    parser.add_argument('veriFitFilePath', help='Verifit txt backup file path.', default=None, nargs='?')
    
    args = parser.parse_args()

    # input validation
    print(args.fitNotesFilePath)
    if not Path(args.fitNotesFilePath).is_file():
        print(args.fitNotesFilePath, ' is not a file')
        return

    if not args.fitNotesFilePath.endswith('.csv'):
        print(args.fitNotesFilePath, ' is not a csv file')
        return
    
    
    if args.veriFitFilePath is not None:
        if not Path(args.veriFitFilePath).is_file():
            print(args.veriFitFilePath, ' is not a file')
            return
            
        if not args.veriFitFilePath.endswith('.txt'):
            print(args.veriFitFilePath, ' is not a csv file')
            return
        
    # open fitNotes CSV file and read the data
    with open(args.fitNotesFilePath, 'r', encoding="utf-8") as fitNotesFile:
        
        next(fitNotesFile) # skip the header
        csvReader = csv.reader(fitNotesFile)
        with open('newVeriFitBackup.txt', 'w', encoding="utf-8") as newFile:
            # write the data from the FitNotes file to be in the format for VeriFit
            newFile.write(VERIFIT_COLUMNS)
            for row in csvReader:
                date_splitted = row[0].split("/")
                v0 = f"{date_splitted[2]}-{date_splitted[0].zfill(2)}-{date_splitted[1].zfill(2)}"

                v3 = ''
                if(len(row[3]) > 0):
                    v3 = float(row[3])
                else: 
                    continue
                
                v5 = ''
                if(len(row[5]) > 0):
                    v5 = float(row[5])
                else:
                    continue

                newRow = f"{v0},{row[1]},{row[2]},{v3},{v5},\n"
                #print(newRow)
                newFile.write(newRow)
            
    # merge the verifit backup data if it exists.    
    if args.veriFitFilePath is not None:
        with open(args.veriFitFilePath, 'r', encoding="utf-8") as veriFitFile:
            
            next(veriFitFile)# skip the header
            lines = veriFitFile.readlines()
            with open('newVeriFitBackup.txt', 'a', encoding="utf-8") as newFile:
                for line in lines:
                    newFile.write(line)
                    
    print("\033[92mOperation Completed!")
            

if __name__=="__main__":
    main()