Title: Python & Libre Calc todo list flat-file manager
Summary Description: Looking to manipulate a single text file in both python and libre Calc. I am learning python and want a base program that I can learn from and further tailor to my needs. The application in this case is a “Todo list”.
General application description (More specifics in the examples)
-This is a poor man’s Personal Information Manager (PIM). I’m keeping a basic todo list version of this today in Calc. This application is an enhancement to what I’m doing now.
-When the PIM flat file is in Libre Calc, the fields are:
1. ID # (up to 5 digits...0-99,999)
2. Task (Size: I have some tasks that are up to 5,000 characters)
3. Date (standard date field). This is not required to be used. Preferably this field is not even used.
4. T1 (30 characters)
5. T2 (30 characters)
6. T3 (30 characters)
(Tags T1-T3 are placeholders primarily for the future)
-The number of rows/Tasks could get as high as 5,000
-”Tags” describing the task are embedded in the task field. (Yes, there are tags t1-3 but those are for possible use in the future. I want to keep this simple for now). An example of the a task might be “Buy milk at the store ddstore”. The tag added here is “ddstore”. I’m using “dd” as control characters. Why “dd’? I might create a task on my cell phone and “dd” is easy to add to prepend to a tag on the smartphone keyboard. Later, before I go to the store, I can do a keyword search (Ctrl-F) on “ddstore” in calc and see that “Buy milk…” is listed as well as any other items I’m supposed to buy at the store. Oftentimes instead of searching on “DD” I might search for a keyword like “milk” that does not necessarily have “dd” in front of it. For the purpose of the program the “dd” is probably irrelevant but I often do use it if it matters.
-I’d like to add some query fields to the first few rows of the calc. For example, when I enter “ddstore” in a field, I would then be able to click a macro button that would send the query terms (“ddstore” in this case) to the python app. Python would then find any row with a “ddstore” in it and display the ENTIRE file back to calc with the “ddstore” results on top. Why not just return the results? I often will do a simple “Control-F” for keywords. If I only have the results displaying, my “control-F” will likely not find a different quick query that I’m hoping to run.
-I don’t think it’s relevant but these tasks might also have entries that are not action oriented. They might include “ideas” (e.g., “What if invest money into General Electric stock instead of Microsoft?”, mini-logs (e.g, “Last time I gave allowance to my daughter was Jan 18th, Feb 1, Feb 14..”), or other non-task entries.
-the query format is modeled after the MS Excel Advanced Filter. The difference is that instead `of the syntax being so detail oriented. I’m looking for key word basics only. More explanation will be shown in the example.
Please see text file "Pim_python_projectdescription" file uploaded for more details.
8 freelanceria on tarjonnut keskimäärin 185 $ tähän työhön
I have 10+ experience in Python development and I just enjoy to develop a different algorithms in Python. I use different online tools for project management and for collaboration as well.