Posted by Tom
2014-04-16
>the data appears in this "S1001" format.
That's by design. It allows you to change the labels without editing the values in the database. For example, you can change February to Feb in config/config.selection.inc.php and the change takes place on the interface instantly. Certainly, it's not sutable for exproting data, though. You should try the "View" feature in MySQL. ( You can create view in phpMyAdmin ) Views allows you to map a format to another in the database. This page will show you an example of view feature, http://www.skyontech.com/blog/create-MySQL-view-in-phpMyAdmin
That's by design. It allows you to change the labels without editing the values in the database. For example, you can change February to Feb in config/config.selection.inc.php and the change takes place on the interface instantly. Certainly, it's not sutable for exproting data, though. You should try the "View" feature in MySQL. ( You can create view in phpMyAdmin ) Views allows you to map a format to another in the database. This page will show you an example of view feature, http://www.skyontech.com/blog/create-MySQL-view-in-phpMyAdmin
→ Form2DB
I understand re: your answer on my previous post. Another issue I'm wondering if you might help with, if it falls within your scope of support:
I've got a form where one of the fields is a dropdown selector for Month. In the script's backend, these months display correctly, but when I do an export to CSV directly from the database (using phpMyAdmin), these Month values appear like "S1001" for January, "S1002" for February, etc. In the database itself, in phpMyAdmin, the data appears in this "S1001" format.
Any ideas as to why the data is formatted this way, but appears OK in the script's backend interface? And how I can get it in an intelligible format for exporting?
Thanks