Some feedback on this process on Windows (see the post here), following Inukshuk’s post, being a complete beginner with SQLite…
Here are some complementary tips (vs. errors I made at first…):
- the command line shell (available here, among “Precompiled Binaries for Windows”) does everything needed
- to avoid any complication with paths on your computer, place the *.exe file in the same folder as your project
- as it is written when the program starts, to open your project, use this line
.open MyTropyProject.tpy - beware that subfolders in Windows are indicated with / while in the project database \ is used (you cannot simply copy-paste the path to be changed as it is in Windows)
- if your project has too many photos in it, you will not be able to see the changes simply using
select path from photos;. Use first:.exceland thenselect path from photos;it will open a spreadsheet where to control that everything went well - if the name of the pictures in the moved folder is built on the folder’s initial name the pictures’ name in the database might be changed during the path change. If so, rename your pictures in the folder.
I had pictures named gorgeous-archives.jpg in a /gorgeous-archives folder. Using this commandupdate photos set path = replace(path, 'gorgeous-archives', 'gorgeous_archives');I changed both the folder’s name and the pictures’ name in gorgeous_archives in the database. Tropy recognised the path but still not the pictures… A little batch naming on the pictures and everything was fine.