[Phpmyadmin-devel] Suggestion for the table export page

In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me. What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure) Here's a demo of the tabs: http://jqueryui.com/demos/tabs/ Also, all the pma demos on the server seem to have troubles: Warning in ./libraries/dbi/mysqli.dbi.lib.php#111 mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO)

Now the demos seem to work again. On Mon, May 2, 2011 at 4:31 PM, Tyron Madlener <tyronx@gmail.com> wrote:
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
Also, all the pma demos on the server seem to have troubles: Warning in ./libraries/dbi/mysqli.dbi.lib.php#111 mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO)

Hi Dne Mon, 2 May 2011 16:41:49 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
Now the demos seem to work again.
Yes, people do break the demo, there is no way to prohibit this since it is giving full control over the MySQL server. The database is checked every 10 minutes and should recover automatically. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

Tyron Madlener a écrit :
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me.
Tyron, what do you mean "export the table structure"? Do you mean "export _just_ the table structure" ? In 3.4, most of the time I leave it in Quick mode and am happy with the results. This panel in 3.4 was built this way by a GSoC 2010 student, based on the results of usability testings.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
Also, all the pma demos on the server seem to have troubles: Warning in ./libraries/dbi/mysqli.dbi.lib.php#111 mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO)
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info

On Mon, May 2, 2011 at 4:44 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me.
Tyron, what do you mean "export the table structure"? Do you mean "export _just_ the table structure" ?
Yes, just the table structure without data.
In 3.4, most of the time I leave it in Quick mode and am happy with the results.
This panel in 3.4 was built this way by a GSoC 2010 student, based on the results of usability testings.
Oh, I see. Still seems unintuitive for me.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
Also, all the pma demos on the server seem to have troubles: Warning in ./libraries/dbi/mysqli.dbi.lib.php#111 mysqli_real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO)
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Tyron Madlener a écrit :
On Mon, May 2, 2011 at 4:44 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me. Tyron, what do you mean "export the table structure"? Do you mean "export _just_ the table structure" ?
Yes, just the table structure without data.
In 3.4, most of the time I leave it in Quick mode and am happy with the results.
This panel in 3.4 was built this way by a GSoC 2010 student, based on the results of usability testings.
Oh, I see. Still seems unintuitive for me.
It can be improved but I feel that it's too late to change this in 3.4.x. About jQuery tabs, I'm not sure because the options vary, depending on the chosen format. Feel free to further discuss by explaining how many tabs there would be and their names.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
-- Marc Delisle http://infomarc.info

2011/5/2 Marc Delisle <marc@infomarc.info>:
Tyron Madlener a écrit :
On Mon, May 2, 2011 at 4:44 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me. Tyron, what do you mean "export the table structure"? Do you mean "export _just_ the table structure" ?
Yes, just the table structure without data.
In 3.4, most of the time I leave it in Quick mode and am happy with the results.
This panel in 3.4 was built this way by a GSoC 2010 student, based on the results of usability testings.
Oh, I see. Still seems unintuitive for me.
It can be improved but I feel that it's too late to change this in 3.4.x.
About jQuery tabs, I'm not sure because the options vary, depending on the chosen format. Feel free to further discuss by explaining how many tabs there would be and their names.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
I think that using jQuery UI Tabs is an overkill. It's nice in applications built completely on top of this UI library, but it has a lot of options that we don't really need. Simple custom made tabs take around 25 lines of JavaScript and the code is already in PMA (js/config.js, setTab). -- Regards, Piotr Przybylski

On Mon, May 2, 2011 at 6:34 PM, Piotr Przybylski <piotr.prz@gmail.com> wrote:
2011/5/2 Marc Delisle <marc@infomarc.info>:
Tyron Madlener a écrit :
On Mon, May 2, 2011 at 4:44 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me. Tyron, what do you mean "export the table structure"? Do you mean "export _just_ the table structure" ?
Yes, just the table structure without data.
In 3.4, most of the time I leave it in Quick mode and am happy with the results.
This panel in 3.4 was built this way by a GSoC 2010 student, based on the results of usability testings.
Oh, I see. Still seems unintuitive for me.
It can be improved but I feel that it's too late to change this in 3.4.x.
About jQuery tabs, I'm not sure because the options vary, depending on the chosen format. Feel free to further discuss by explaining how many tabs there would be and their names.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
Here's a demo of the tabs: http://jqueryui.com/demos/tabs/
I think that using jQuery UI Tabs is an overkill. It's nice in applications built completely on top of this UI library, but it has a lot of options that we don't really need. Simple custom made tabs take around 25 lines of JavaScript and the code is already in PMA (js/config.js, setTab).
jQuery UI Tabs is already included in phpMyAdmin. So we have no additional overhead. And the code will be easier to read using jquery ui tabs.
-- Regards, Piotr Przybylski
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Dne Mon, 2 May 2011 16:31:13 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
The current state is based on last year GSoC project and I usually hear positive feedback about it. Most people really don't need the options, so choosing the format is the only thing they want to care about. Of course advanced options could be hidden by some other mean, but I don't think tabs really fit this case, because you would have to change number of tabs based on selection of format and I think this would be unintuitive. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

On Tue, May 3, 2011 at 11:36 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Mon, 2 May 2011 16:31:13 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
In phpMyAdmin 3.3 most of the export settings were visible in one page without scrolling, hence requiring only very few clicks to export what you need. But in 3.4 when I try to export the table structure I first need to click '(o) custom' then scroll down and search through all the text where in order to find where I select '(o) structure'. It feels very unintuitive for me.
What about: a) We put all the settings in jquery tabs b) On the first tab will be the most used options: Format, Output type (File / as Text) and what to dump (2 checkboxes for each data and structure)
The current state is based on last year GSoC project and I usually hear positive feedback about it. Most people really don't need the options, so choosing the format is the only thing they want to care about.
Of course advanced options could be hidden by some other mean, but I don't think tabs really fit this case, because you would have to change number of tabs based on selection of format and I think this would be unintuitive.
Yes, indeed. I didn't see the format specific settings at first. However, the same applies to the current solution. Here we have regions of settings appearing and disappearing. Maybe alternatively to tabs the selection 'Quick - display only the minimal options' should show not only the format, but also 1-2 of the most commonly used settings (depending on the current format selection)? That way it would still be minimal, but covering a greater amount of export cases.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Dne Tue, 3 May 2011 12:41:56 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
Yes, indeed. I didn't see the format specific settings at first. However, the same applies to the current solution. Here we have regions of settings appearing and disappearing.
Maybe alternatively to tabs the selection 'Quick - display only the minimal options' should show not only the format, but also 1-2 of the most commonly used settings (depending on the current format selection)? That way it would still be minimal, but covering a greater amount of export cases.
I really don't see much of such options. What would you propose to show for SQL? -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

On Thu, May 5, 2011 at 8:51 AM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Tue, 3 May 2011 12:41:56 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
Yes, indeed. I didn't see the format specific settings at first. However, the same applies to the current solution. Here we have regions of settings appearing and disappearing.
Maybe alternatively to tabs the selection 'Quick - display only the minimal options' should show not only the format, but also 1-2 of the most commonly used settings (depending on the current format selection)? That way it would still be minimal, but covering a greater amount of export cases.
I really don't see much of such options. What would you propose to show for SQL?
My most used options are '( ) output as file / text' and whether to export data and or structure. I think it will be easier if I just build a mock-up to demonstrate, I'll do that this week.
-- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

Hi Dne Thu, 5 May 2011 09:35:22 +0200 Tyron Madlener <tyronx@gmail.com> napsal(a):
My most used options are '( ) output as file / text' and whether to export data and or structure.
I really don't think this is much used. In fact I use this only when debugging some export plugin.
I think it will be easier if I just build a mock-up to demonstrate, I'll do that this week.
Sure, that might help. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
participants (4)
-
Marc Delisle
-
Michal Čihař
-
Piotr Przybylski
-
Tyron Madlener