Forums

English
Good morning all
I am surprised not to be able to visually sort in administration all the data created by ChronoConnectivity:
- Connections (Title / alias / Description / ...)
- Events (Name)
- Views (Name / Type of view)
- Functions (Name / Type of function)
It is indeed difficult to manage dozens of lines out of order ... 😉
For example with column headings on which we could click ... Or carry out a manual sorting by moving the lines relative to each other as for the menus or articles of Joomla ...
Is it possible and if so how?
Thank you
​
Français
Bonjour à tous
Je suis étonné de ne pas avoir la possibilité de trier visuellement en administration l'ensemble des données créées par ChronoConnectivity :
- Connexions (Title/alias/Description/...)
- Events (Name)
- Views (Name/Type of view)
- Functions (Name/Type of function)
C'est en effet difficile de gérer des dizaines de lignes dans le désordre... 😉
Par exemple avec des titre de colonne sur lesquels nous pourrions cliquer... Ou effectuer un tri manuel en déplaçant les lignes les unes par rapport aux autres comme pour les menus ou articles de Joomla...
Est-ce possible et si oui comment ?
Merci

Anglais
Thank you healyhatman for the address of this site to sort the information but ...
Generally speaking, I am wary of data transformations carried out by external sites, but I nevertheless carried out an example.
I have the impression that there are problems ... No? (see example)
- The first and last character "{" and "}" are replaced by "[" and "]" ... Why?
- The size of the original character string is longer than that transformed ... Why?
​
Français
Merci healyhatman pour l'adresse de ce site pour trier les informations mais...
D'une façon générale, je me méfie des transformations de données effectuées par des sites extérieurs, mais j'ai quand même effectué un exemple.
J'ai l'impression qu'il y a des problèmes ... Non ? (voir exemple)
- Le premier et dernier caractère "{" et "}" sont remplacés pas "[" et "]"... Pourquoi ?
- La taille de la chaine de caractères origine est plus longue que celle transformée... Pourquoi ?
​
Origin
{"1":{"type":"read_data","name":"albums_lire","model_name":"Albums","db_table":"mo_albums","select_type":"all","paging":"0","limit":"","offset":"","orders":{"1":{"name":"nom_album","action":"asc"}},"fields":{"list":"id\r\nnom_album\r\ncommentaire","extra":"","special":""},"group":"","sort":{"fields":""},"search":{"param_name":"keywords","fields":""},"db":{"enabled":"1","user":"XXXXXX","pass":"XXXXXXXXX","name":"XXX","type":"mysqli","host":"localhost","prefix":""},"eventsws":["notfound"]},"2":{"type":"read_data","name":"album_lire","model_name":"Albums","db_table":"mo_albums","select_type":"first","paging":"1","limit":"","offset":"","conditions":{"3":{"_type":"rule","name":"Albums.id","namep":"=","value":"{data:id}","valuep":""}},"fields":{"list":"id\r\nnom_album\r\ncommentaire","extra":"","special":""},"group":"","sort":{"fields":""},"search":{"param_name":"keywords","fields":""},"db":{"enabled":"1","user":"XXXXXX","pass":"XXXXXXXXX","name":"XXX","type":"mysqli","host":"localhost","prefix":""},"eventsws":["notfound"]},"3":{"type":"switch","name":"album_test_existe","data_provider":"{var\/empty:album_lire}","return":"","array":"","values":"true:{error:Album non trouvé.}{redirect:index}"}}

Transform
[{"type":"read_data","name":"album_lire","model_name":"Albums","db_table":"mo_albums","select_type":"first","paging":"1","limit":"","offset":"","conditions":{"3":{"_type":"rule","name":"Albums.id","namep":"=","value":"{data:id}","valuep":""}},"fields":{"list":"id\r\nnom_album\r\ncommentaire","extra":"","special":""},"group":"","sort":{"fields":""},"search":{"param_name":"keywords","fields":""},"db":{"enabled":"1","user":"XXXXXX","pass":"XXXXXXXXX","name":"XXX","type":"mysqli","host":"localhost","prefix":""},"eventsws":["notfound"]},{"type":"read_data","name":"albums_lire","model_name":"Albums","db_table":"mo_albums","select_type":"all","paging":"0","limit":"","offset":"","orders":{"1":{"name":"nom_album","action":"asc"}},"fields":{"list":"id\r\nnom_album\r\ncommentaire","extra":"","special":""},"group":"","sort":{"fields":""},"search":{"param_name":"keywords","fields":""},"db":{"enabled":"1","user":"XXXXXX","pass":"XXXXXXXXX","name":"XXX","type":"mysqli","host":"localhost","prefix":""},"eventsws":["notfound"]},{"type":"switch","name":"album_test_existe","data_provider":"{var\/empty:album_lire}","return":"","array":"","values":"true:{error:Album non trouv\u00e9.}{redirect:index}"}]

Doesn't matter, it's just json. Those square brackets means it's in an array.
I copied the "Transform" and put it in my database and got

If you want to do the code yourself [file=12650]sorter.php.txt[/file]
Just need to take off the .txt
​
What this is doing by the way, is organising it by TYPE and then by NAME. So all the read datas will be together, all the saves together, etc.

Anglais
Thank you very much healyhatman
I'll try but last question before I do ...
What should I insert in your program to keep special characters (accents)?
I use a MariaDB database coded in "utf8mb4_unicode_ci".
Thank you.
In a future version of ChronoConnectivity, it would be really great to be able to sort directly in administration ... (It's a simple idea but so practical ...) 😀
​
Français
Merci beaucoup healyhatman
Je vais essayer mais dernière question avant de le faire...
Que devrais-je insérer dans ton programme pour garder les caractères spéciaux (accents) ?
J'utilise une base de donnée MariaDB codée en "utf8mb4_unicode_ci".
Merci.
Dans une prochaine version de ChronoConnectivity, ce serait vraiment super de pouvoir trier directement en administration... (C'est une simple idée mais tellement pratique...) 😀

English
I tested the transformation solution by the site.
Everything seems OK, accents included.
Thanks a lot
​
Français
J'ai testé la solution de transformation par le site.
Tout semble OK, accents compris.
Merci beaucoup