Pie-register date field doesn't show

Hi dolf

That plugin has rather strangely represented the date as a multi-level nested array. It appears to be allowing for other fields beyond just date to be stored in the same meta field. S2member unfortunatey does a similar thing. This choice makes it very hard to ever query/sort users efficiently by that data.

The converted dates are stored much more sensibly – HOWEVER
I’m wondering whether if you have checked how your ‘converted’ data is being handled by pie ? eg: in user profile fields or whatever reporting they offer ? Quite possibly not well at all – plugins normally expect the data to be stored the same way that they stored it when they query and display the data.

This plugin does try to dig down a bit but even that would not help with this structure without some custom coding. eg: if one removes the top level and just has a pie-date meta record with value a:3:{s:2:"dd";s:2:"30";s:2:"yy";s:4:"1690";s:2:"mm";s:2:"11";}
then the plugin would do it’s best and extract 3 fields out of that, as a quick test shows here:

Created name Pie Date Dd for pie_date-dd
Created name Pie Date Yy for pie_date-yy
Created name Pie Date Mm for pie_date-mm

If this date is important to your reporting, then I’d suggest bringing it up with the Pie support people and seeing if there is a way to rather store the data in a way that makes it more useful for querying – for example the way wordpress stores the ‘user_registered’ date eg: 2015-11-17 03:18:25

Failing that, an add-on could be written to create a more useful meta date field from the pie date every time it is save or updated and then use that new field in the listing rather (ugly)

Or use a different registration plugin. Hope that helps – good luck.

Hi Genetech, dolf is posting in amr-users support forum so I assume they talking about the user lists amr-users generates. It digs into user meta and allows folks to grab fields for reporting. I gather dolf may have done his own import of old data.