Hello everyone!
I am new here and hopefully my question/problem haven't been asked yet (and I just failed to find them with the search function).
I am running dadabik 4.2 and php 5.3
The first one is a problem with the "select single" feature.
I have a table with a "field1" (in phpmyadmin defined as varchar(25) - of course I have other fields, too, for id as primary key, but they make no problem).
In dadabik admin after installing the table I switched the field type for 'field1' to 'select_single' and "other choices allowed" to 'y'. All other values I kept as default (content type = alphanumeric, options separator = '~' and so on).
When I now in the user area try to insert a new data set, I open the dropdown of field one, select "other" and in the text field next to it I type "www1" and save the data set successfully.
Now I insert a second data set. But when I open the dropdown for 'field1', the value of the first data set ("www1") is not displayed. And having a look in the admin area, in the field configuration of 'field1' "www1" appears not in "option to include".
Only when I edit the first dataset and enter the value "www1" for a second time and save it, it afterwards appears for new datasets in the dropdown menu.
But if it is the very first value for this field, afterwards the first letter of the value is missing because in the admin area I see that the first option separator"~" that has to be before the first value in "options to include" is there.
Any Idea what goes wrong?
The second one is a question concerning dates.
I have a field 'date1' (date type, format YYYY-MM-DD in sql). Now I have some german users who are not very familiar with working with computers and I want to try the following:
The user can insert the date in the german way (DD.MM.YYYY), but it is inserted in the sql way (YYYY-MM-DD).
I know a little php and so how to switch in php between the two formats.
But I really don't know where in the dadabik code to change what php code to make this possible.
Has anyone ever tried out this or has any idea how to manage this problem?
Hopefully this was not too much (and too often asked) and everybody understands what I am talking about as my "computer english" is not the best.
I am new here and hopefully my question/problem haven't been asked yet (and I just failed to find them with the search function).
I am running dadabik 4.2 and php 5.3
The first one is a problem with the "select single" feature.
I have a table with a "field1" (in phpmyadmin defined as varchar(25) - of course I have other fields, too, for id as primary key, but they make no problem).
In dadabik admin after installing the table I switched the field type for 'field1' to 'select_single' and "other choices allowed" to 'y'. All other values I kept as default (content type = alphanumeric, options separator = '~' and so on).
When I now in the user area try to insert a new data set, I open the dropdown of field one, select "other" and in the text field next to it I type "www1" and save the data set successfully.
Now I insert a second data set. But when I open the dropdown for 'field1', the value of the first data set ("www1") is not displayed. And having a look in the admin area, in the field configuration of 'field1' "www1" appears not in "option to include".
Only when I edit the first dataset and enter the value "www1" for a second time and save it, it afterwards appears for new datasets in the dropdown menu.
But if it is the very first value for this field, afterwards the first letter of the value is missing because in the admin area I see that the first option separator"~" that has to be before the first value in "options to include" is there.
Any Idea what goes wrong?
The second one is a question concerning dates.
I have a field 'date1' (date type, format YYYY-MM-DD in sql). Now I have some german users who are not very familiar with working with computers and I want to try the following:
The user can insert the date in the german way (DD.MM.YYYY), but it is inserted in the sql way (YYYY-MM-DD).
I know a little php and so how to switch in php between the two formats.
But I really don't know where in the dadabik code to change what php code to make this possible.
Has anyone ever tried out this or has any idea how to manage this problem?
Hopefully this was not too much (and too often asked) and everybody understands what I am talking about as my "computer english" is not the best.