Buy Now
Sign in

Sort Connections Events Views Functions

jmgroud , February 07 2020, 06:03
jmgroud 140
February 07 2020, 06:03 #391066
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
Le peu que je sais est occulté par le trop que je ne sais pas...
(The little that I know is overshadowed by the too much that I don't know ...)
healyhatman 9
February 07 2020, 07:02 #391070
 Answer
Take a database backup of your website: it's not my problem if you do this wrong and ruin your site.
Go to skyspider.com.au/sorter.php
In your website's cPanel, go to your site's database and find #__ chronoengine_connections6
For the connection you want sorted, copy the text from the views or functions columns, paste it into the form, click "GET SORTED".
Copy and Paste the resulting text back into your database.
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
jmgroud 140
February 07 2020, 11:43 #391078
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}"}]
Le peu que je sais est occulté par le trop que je ne sais pas...
(The little that I know is overshadowed by the too much that I don't know ...)
healyhatman 9
February 07 2020, 12:46 #391081
 1
 Answer
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
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
healyhatman 9
February 07 2020, 12:47 #391082
 1
 Answer
If you want to do the code yourself
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.
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
jmgroud 140
February 07 2020, 13:16 #391084
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...)
Le peu que je sais est occulté par le trop que je ne sais pas...
(The little that I know is overshadowed by the too much that I don't know ...)
jmgroud 140
February 07 2020, 17:13 #391094
 Answer
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
Le peu que je sais est occulté par le trop que je ne sais pas...
(The little that I know is overshadowed by the too much that I don't know ...)