bilmel
Forum Replies Created
-
Forum: Plugins
In reply to: [Participants Database] Records with multiple email addressesOK, I found my problem, I think. I didn’t choose to “Show Related Record List” for either Parent or Child, so I couldn’t see the field to edit. You might want to consider making the default showing this information.
Forum: Plugins
In reply to: [Participants Database] Records with multiple email addressesWith my currently flat database, I have field groups set up for “property information” and “personal information”. Assigning each field group to the type “property” or “resident” is easy enough. However, I’m not understanding how on a per record basis there is a connection between specific “property” records, the parent type, and “residents”, the child. I’m sure I’m missing something important.
As I migrate to this system, I’ll want to display and search for records based on their type, with “property” searches showing the property information field group, and all related “residents”, each showing the data contained in the “personal information” field group. Ideally, I’d also like to see all related parent “property” records shown when searching for a “resident” child record.
I’ve tried to read the guide multiple times, but this has eluded me.
Forum: Plugins
In reply to: [Participants Database] Records with multiple email addressesI’m getting ready to implement this, and am a little confused.
I have a dataset of properties, each of which has one or more owners, and owners, each of which can own one or more properties. My initial thought is properties should be parent records, pointing to a series of children that represent owners, occupants, and property managers. Some of these child records could be children of multiple property records, and I can see that the result could be confusing, and might just run afoul of the patent-child relationship supported by the plugin.
Am I thinking about this wrong? The primary attribute of a property is its history of paying dues, which are paid by one of the types of children, while the primary data of the children is capturing people’s names, mailing addresses, and emails.
I’m thinking I’ll want to export my current flat database, move fields into different records, and then import them back into PDB with the plugin. Is that the best way to migrate several hundred records?
Mahalo as always!
Forum: Plugins
In reply to: [Participants Database] Another problem with dropdownsI removed all of the :: followed by number fields, and found a couple of places where the data describing the dropdown field was either incomplete, unused, or shown as lower case while the database text field was upper case. After doing this, I found one record that displayed “0” for its value, and changed it to a valid status.
Now everything seems to be working!
Forum: Plugins
In reply to: [Participants Database] Another problem with dropdownsI tried removing the ::1 from the fields, and it didn’t make a difference with this problem.
Forum: Plugins
In reply to: [Participants Database] Another problem with dropdownsI just re-read the documentation, and perhaps I shouldn’t have a “::1” listed in the database fields, since that seems to be the method for creating Option Labels, while what I want is just the specific fields offered by the dropdown.
Forum: Plugins
In reply to: [Participants Database] Another problem with dropdownsI just looked at the database via phpmyadmin, and in each record the dropdown value appears to have the string, for example “Alaweo St” that belongs in the record.
Likewise, the database fields table has all of the strings for each dropdown, with the same index values that were entered into the database fields portion of the plugin, ie Alaweo St::1
The change I made previously to the database fields, at your suggestion, was from 1::Alaweo St to Alaweo St::1, etc for each field.
If the value was stored in the record, and then mapped to the field name in the database field, I’d understand the confusion, but since the record contains the string corresponding to the chosen dropdown, I don’t understand why it displays correctly when viewing the record, but does not in the dropdown when editing the record.
I can set you up with access to the database if you need it.
Mahalo.
Forum: Plugins
In reply to: [Participants Database] Another problem with dropdownsI wasn’t clear; when you select a record for editing, with either the front or backend, instead of displaying the value already present in the drop down, it displays a blank field, and if you subsequently save the record, the blank selection overwrites the original value. Once you actually select the correct dropdown value and save it, it works normally.
Mahalo
Forum: Plugins
In reply to: [Participants Database] date entry issueOK, I read the blog on this topic; for me, changing the WP timezone to “Honolulu” versus “UTC-10” seems to have fixed PDB’s issue.It seems very strange that this would make a difference.
Forum: Plugins
In reply to: [Participants Database] date entry issueMy current server uses UTC as its base time. Setting the WordPress timezone to UTC-10 seems to work fine for other plug ins, such as The Events Calendar. Whether I set the “Sync PHP Timezone” or not, I still see the date recorded in PDB as being off by ~10 hours.