New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

General: add timestamp column (xml/csv import + export and existing tables) and sorting function in backend #74

Closed
Theophilix opened this Issue Aug 8, 2017 · 1 comment

Comments

Projects
None yet
1 participant
@Theophilix
Owner

Theophilix commented Aug 8, 2017

This timestamp column is hidden, it appears only in mysql table. Every time a user edits a cell, the timestamp is updated. Each row has one assigned timestamp value (=one timestamp for all cells in a row).

If user
a) creates a new empty table or b) updates old version of ETE [we need a script that adds a timestamp column to mysql-db for all normal tables that user has!!] or c) imports CSV or d) imports XML then
add timestamp automatically this way: Get actual time and date, and add one second more for each row. If today is 08.08.2017 17:00:00, timestamp first row of csv/xml is 08.08.2017 17:00:01, second row: 08.08.2017 17:00:02 etc.)

CSV and XML export:
add check box "Export timestamp column" (ger: Zeitstempel-Spalte exportieren), standard value: yes.

CSV Import information text:
"If no timestamp column (must be first column, name "timestamp", format dd.mm.yyyy hh:mm:ss) is found in csv/xml or if the column has empty entries, timestamps are created automatically in the order of the given data".
German translation: "Wenn keine Zeitstempel-Spalte (muss erste Spalte sein, Name "Zeitstempel", Format dd.mm.yyyy hh:mm:ss) vorhanden ist oder leere Einträge hat, werden Zeitstempel in der Reihenfolge der Daten automatisch erstellt."

Frontend: Add sorting option

  • options: latest / oldest
@Theophilix

This comment has been minimized.

Owner

Theophilix commented Oct 16, 2017

Partly done in 4.5.5 version.

@Theophilix Theophilix closed this Oct 16, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment