#304 Abbreviated Month Name Import Dropdown Option needed

[Steve Keen]

In trying to import this coffee shop data with Months as a time dimension, I used %b as a format (which worked) but the display of month names ... left something to be desired.

We need %b as an option in the format dropdown, and we need to translate that into abbreviated month names, rather than the "1400-01-01-T00:00:00" we generate at present

[Steve Keen]

We need day of the week too, in abbreviated and full name format, both as data import format options to time, and as display options on the canvas.

[High Performance Coder]

Abbreviated month format is there on the dropdown list (%b), but not
day of week (%a) I had to look that up.

Note - I got an import error on reading the time of day field
(%H:%M:%S), so I had to set that column to ignore.

It is slow to import, though. That is probably the unusual time format
imports - %b and %a.

What we need are time field splitting operations, and import just the
full timestamp of each transaction. In this case, that would require
merging date and time of day fields. Features that have long been planned, but never the time to implement :P.

On Sat, Aug 24, 2024 at 07:28:31PM -0000, Steve Keen wrote:

We need day of the week too, in abbreviated and full name format, both as data
import format options to time, and as display options on the canvas.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

[ravel:#633] Abbreviated Month Name Import Dropdown Option needed

Status: open
Milestone: Babbage
Created: Sat Aug 24, 2024 07:27 PM UTC by Steve Keen
Last Updated: Sat Aug 24, 2024 07:27 PM UTC
Owner: nobody
Attachments:

• AbbreviatedMonthOptionImportDropdown20240824.png (274.2 kB; image/png)
• AbbreviatedMonthOptionImportDropdown20240824.rvl (1.3 MB; application/
octet-stream)

In trying to import this coffee shop data with Months as a time dimension, I
used %b as a format (which worked) but the display of month names ... left
something to be desired.

We need %b as an option in the format dropdown, and we need to translate that
into abbreviated month names, rather than the "1400-01-01-T00:00:00" we
generate at present

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Sent from sourceforge.net because you indicated interest in https://
sourceforge.net/p/minsky/ravel/633/

To unsubscribe from further messages, please visit https://sourceforge.net/auth
/subscriptions/

--

---

Dr Russell Standish Phone 0425 253119 (mobile)
Principal, High Performance Coders hpcoder@hpcoders.com.au
http://www.hpcoders.com.au

---

[High Performance Coder]

Ticket moved from /p/minsky/ravel/633/