If you don’t have a Run eFTP, go to the Add Calendar Entry, then add a number from a date in the past. I set mine to 1 Jan 2018 and the problem in the API file goes away.
Shouldn’t be necessary anymore in v1.3
1 Like
“Help, need a little help.” ~Neo
- macOS + Excel for Mac (not 365)
- Error on launch (1)
- AthleteID inputted on Readme
- GetData: (2)
- Run Web Query wants to open a file
- From Database throws an error
- Import Text File has issues when pointing it to my downloaded CSV. (See following bullets.)
- CSV import thinks it’s a fixed width. Changed to comma delineated.
- What’s the column data format: General or Text?
- Prompt for location to put the imported data. Excel just throws it in that location and not into existing columns. (3)
(1)
(2)
(3)
v1.3 with the AthleteID on the ReadMe tab is only for Office 365 on Windows. Unless @Gerald was able to fix it.
You should use @Gerald 's version and download the csv files first to your download folder.
I saved the link to the manual download in this discussion thread:
csv comes in comma delimited, all columns in text format, EN-US
Last screenshot shows that the AthleteID did not make it from the ReadMe tab to the connection settings. So you will for sure need to edit the connections with your ID.
The Query is saved in the file but it is a Power Query. If your Office version is not supporting Power Query, it isn’t recognized.
Just remember to download the file, and not open it in Google Sheets.
1 Like
The Google Sheets version, which is incomplete, due to the graphs being a little more difficult to recreate (in Google Sheets), can be opened here. This file was originally shared by @William_Barnes and the iThlete and ATP has been added to that file. It also needs to be saved to your own Google Drive location.
1 Like
That is not the MacOSv1.0 file, but the Windows version.
The MacOSv1.0 will only have a link to your downloads folder.
Edit:
As you are the OP on this discussion thread, would you be open to editing your original post to include the links to the latest version? This would need to be edited each time a new version is added. If you need help, let me know. It might make it easier to find the latest version among all the subsequent discussions.
I may be the OP but this is much bigger than me. I’m feeling a bit confused with multiple threads and links. Personally, I’d rather hand over all updates to you guys and have everything in one spot.
I’ll provide for this in the help section. As the updated versions are added, @MedTechCD and I can update the help section.
1 Like
I’ve edited all my posts with link to the Windows/Office365 version to point to the Google drive folder where my file can be downloaded. I will keep the folder shared and simply replace the file with a newer version. People clicking this link will always retrieve the latest version of it. Also added a text file pointing to @Gerald for MAC/Manual download version and @Daniel_Harris for Google sheets dev work.
https://drive.google.com/drive/folders/1WhIOf2XkGiZBEN_7tX2PSShmF-QXBnBF?usp=sharing
1 Like
I think you just need to confirm the entry of the athlete id by pressing ENTER or quiting the cell.
From what I can see, you typed the id but never quit the cell. Just dismiss the error and press Enter or navigate to another cell.
But it could also be a Type mismatch because this athlete id has no text in it and is considered a number. Does it work when you format the cell with the id to text?
I’m actually just adding text strings one to another, so should be a fairly simple fix if I convert the number to text.
I will let you know a bit later today.
EDIT: It’s fixed. Thanks for letting me know!
Get updated file here Intervals Api Tools Office365
2 Likes
Sorry but I have no idea where that comes from. It basically means that the file would already have a column named ‘weight’.
Are you starting with a clean copy of the file? No changes made?
it’s a clean copy, i don’t made any change
Is this for one specific athlete or for multiple athletes?
1 Like