Legend
Forum
Unread topics or posts
Topic
Unread posts
Locked
Announcement
Forum
Unread topics or posts
Topic
Unread posts
Locked
Announcement
Search
Search results for "Posted by sandro.krumbein"
| Author | Message |
|---|---|
|
sandro.krumbein |
Posted: Oct 21, 2012
From Topic: Alarm feature
Final feedback: that did indeed do the trick! No clue why it had worked before and who (probably me) disabled those settings ;-) |
|
sandro.krumbein |
Posted: Jul 20, 2012
From Topic: Alarm feature
Sorry for the late reply... Does the watchlist feature actually work or had I not ticked the box? Here is what it looks like: http://d.pr/i/EjNe When I click the "Setup customizable alarms/reminders" link, I am taken to the settings screen. I am a pro subscriber and have been all this time (just in case that matters) |
|
sandro.krumbein |
Posted: Jul 13, 2012
From Topic: Alarm feature
Recently, for a few weeks, I had an alarm checkbox and a combobox to select how much time in advance I wanted to be alarmed in my Due Date/Time pop up. Where is it gone now? Sandro |
|
sandro.krumbein |
Posted: May 30, 2011
From Topic: Tasks missing
No, unfortunately that isn't the problem. As I said the only criteria is a particular folder and they are all in there. Just checked again |
|
sandro.krumbein |
Posted: May 27, 2011
From Topic: Tasks missing
Hello I have done a search, the only criteria was a particular folder. All subtasks in the folder are completed, should that be of relevance. Now when I show the subtasks flattened, they are all there (compared to the CSV export). When I show them indented, some are missing. There are tasks missing, that have a later due date, than some of those, that are shown. Any ideas? |
|
sandro.krumbein |
Posted: May 11, 2011
From Topic: Import CSV to Excel
Have the 2007 version of Excel. And I have tried either: just double clicking, opening from the inside or import from text... None works Here might be the kicker though and please don't hate me for mentioning it so late. I am German. The Office version is actually English (showing the English menu and stuff), but the operating System (Windows 7) is German. Might that be it? For example there is a difference in the decimal mark between the German and the English version. It's the comma for us and the dot for you, isn't it? Anyway, thanks for all the effort! I have finally found a solution I am happy with. Here goes: software is called Exportizer, which is able to import and export all kinds of table data. CSV and XLS are amonst them. Now I have created a batch file, which does this for me (part was done by the software). Now the conversion is done by simply dragging the downloaded CSV onto my batch file. Voila, there is my CSV file, which is now compatible with my Excel version Here is the batch code, for those, who would wonder how to get the drag and drop going: "C:\Program Files (x86)\Exportizer\exptizer.exe" /ado /export /ExportType=CSV /ExportMode=CREATE_OR_REPLACE+INSERT /separator=; /textSchema=0 /IncludeColNames /DelimitAllFields /CloseWhenDone /minimize /OpenDestination /LineTerminator=WINDOWS /IncludeMemo %1 C:\Users\Administrator\Documents\Lokalim\Auswertung\Zeit\toodledo_completed.csv The %1 is the placeholder for the name of the dropped file Thank you! Sandro |
|
sandro.krumbein |
Posted: May 10, 2011
From Topic: Import CSV to Excel
I liked that idea... But I have checked that again and it's still the same issue. Doesn't recognize what is in quotation marks as one column Thank you! Sandro |
|
sandro.krumbein |
Posted: May 10, 2011
From Topic: Import CSV to Excel
Hey guys and thanks for your replies! True, by definition, you are doing it right and Microsoft is wrong. I know I can change the separator to a comma during the import process. But Excel ignores the quotation marks around the values of the columns and then tries to separate those, that contain commas, into columns as well For the same reason the replace wouldn't work either. The semicolons would be considered separators as well and Excel would try to split the text into columns The actual problem is, that Excel ignores the quoation marks, I guess... Sandro |
|
sandro.krumbein |
Posted: May 09, 2011
From Topic: Import CSV to Excel
Hello! I use the CSV export do get my completed tasks into Excel to analyse them. The problem is that Excel doesn't naturally use a comma as a separator, but rather the semicolon. Long story short: I have tried all different ways, but when I have a task, that contains a multiline note, it gets all messed up, because Excel seems to ignore the quotation marks. My current workaround is to convert the CSV file to an XLS file via zamzar.com and use that one Could it maybe implemented to actually export as a CSV file with ;-separated columns? Or does anyone know the trick to make Excel do what I want it to do? Or does anyone at least know of a freeware CSV-2-ExcelCSV or CSV-2-XLS converter I could use? Thank you very much! Sandro |
|
sandro.krumbein |
Posted: Mar 09, 2011
From Topic: POST to API via cURL
Okay, this is what the cURL website says about the -d option: Sends the specified data in a POST request to the HTTP server, in the same way that a browser does when a user has filled in an HTML form and presses the submit button. This will cause curl to pass the data to the server using the content-type application/x-www-form-urlencoded Sounds reasonable to me. Or does the API insist on the application/json content-type? I have tried leaving the message un-encoded and using the --data-urlencoded option, which is supposed to encode it itself, but to no avail either curl http://api.toodledo.com/2/tasks/edit.php?key=myKey;f=xml --data-urlencode tasks=[{"id":"4384388","title":"Task 1 changed"}] But maybe we can shortcut this discussion: what I am trying to do is to change the completed date of some of my tasks, which I forgot to tick off on the right day (a well known problem I guess). If you now tell me, that this isn't even possible via the API, then it's all pointless :-) If it is possible, I still want to find a way to do it. I don't insist on cURL. I might try libCURL via C# then or something... Thanks, Sandro |
|
sandro.krumbein |
Posted: Mar 05, 2011
From Topic: POST to API via cURL
Alright, despite believing to have done this before I checked this again. The task I used back then has already been deleted, but with the task #4384394 I have the same problem. Here is the entire output (almost) straight from the command line window. First retrieving details of the task and then trying to edit it C:\Users\Administrator\Desktop\Curl + Toodledo>curl http://api.toodledo.com/2/tasks/get.php?key=myKey;fields=folder,star,priority;f=xml;id=4384394 <?xml version="1.0" encoding="UTF-8"?><tasks num='1' total='1'><task>4384394<title>Task 4</title><modified>1299318739</modified><completed>0</completed><folder>275306< /folder><priority>0</priority><star>0</star></task></tasks> C:\Users\Administrator\Desktop\Curl + Toodledo>curl http://api.toodledo.com/2/tasks/edit.php?key=myKey;f=xml -d tasks=[{"id"%3A"4384394"%2C"title"%3A"Test task 2"}] <?xml version="1.0" encoding="UTF-8"?><tasks><error id='7'>Invalid task ID</error></tasks> So, yeah I believe it is there :-) This message was edited Mar 05, 2011. |
|
sandro.krumbein |
Posted: Mar 03, 2011
From Topic: POST to API via cURL
Hello, I am trying to do a simple update of tasks by using cURL. I have come to the point that I can retrieve tasks, but now I want to edit them by doing a post Here is my line of code from the windows commandline: >curl http://api.toodledo.com/2/tasks/edit.php?key=myKey;f=xml -d tasks=[{"id"%3A"3917814"%2C"title"%3A"Test task 2"}] And this is the answer: <?xml version="1.0" encoding="UTF-8"?><tasks><error id='7'>Invalid task ID</error></tasks> It seems that I am not completely off, but can anyone shed light on this? Thanks, Sandro |
|
sandro.krumbein |
Posted: Feb 22, 2011
From Topic: iCal Import / CSV export
Another update: Have you guys at ToodleDo changed anything? Now that I did it at home Excel 2007 still couldn't handle it right, but the import of the ICS file from RTM to ToodleDo even got the estimates and tags right. That didn't work yesterday Now it's pretty much all good Thx, Sandro |
|
sandro.krumbein |
Posted: Feb 22, 2011
From Topic: iCal Import / CSV export
Found another way, haven't tried Excel 2007, yet. Google Docs seems more capable at handling these things. Even got the Umlaute right. HowTo: open a spreadsheet there, then File/Import..., Pick the csv file from harddrive, choose create new spreadsheet. If the right delimiter isn't automatically detected, pick it at the bottom. Click import and then a link appears by which you can open it. This online spreadsheet is then downloadable to the harddrive as an Excel file. Done Best, Sandro |
|
sandro.krumbein |
Posted: Feb 22, 2011
From Topic: iCal Import / CSV export
Thx for the answer 2) That's a good hint. Did some research and found exactly what you said. It should work. But I have tried every conceivable way on Excel 2003 now and have found now way to do it, though. I'll try again on Excel 2007 at home 1) I guess I will import the tasks from RTM then, export them to CSV (hopefully), do some Excel formula magic to separate the entries in the notes to filter out the estimates and tags and then reimport it to ToodleDo Best, Sandro |
|
sandro.krumbein |
Posted: Feb 21, 2011
From Topic: iCal Import / CSV export
Hello, I also am considering the switch from Remember The Milk. I have a few problems though 1. When importing the ical file from my RTM account, the tags don't show up properly. They are only stored in the description of the tasks. Same with the locations. Does anyone know how to work around this? I guess the iCal format doesn't support tags? The same with the estimated length of the task. Also only available in the description. So the question is how to import the tasks and loose as little info as possible and also how to have as little as possible manual work to do for the transition? 2. When exporting my tasks to a CSV file I have two problems. The first is that my notes might contain commas, which will lead to incorrect recognition of columns by excel. The other is that the notes might contain line breaks, either incorrectly or correctly. For the first I would suggest to give the user the option to choose their own separation characters. For the latter, I can at the moment only come up with letting the user select which columns he wants to export Thanks, Sandro This message was edited Feb 21, 2011. |