tcmacadmind

The issue has still not been resolved so I don’t see why you would close the case. It would be better to fix the problem I would think.

Hi Jamie, thanks for your response however all of you suggestions did not work. I also tried deactivating all of my plugins to see if one of those was causing the problem but that did not change the issue. I noticed that some people having JSON errors were advised to use the classic editor. I tried this and it did work but going back to the old classic editor is not ideal.

Any other suggestions?

Dave

Hi, I am still having this issue and no one has responded. Does anyone have a fix for this issue??

Hi missveronica, thanks for this, I added the plugin but the Role column is still not sortable. The instructions say any custom column added will be sortable but not the default columns. I guess I can add a custom column of Role but I don’t know where to find the meta data for the role so I can’t. Can you advise me how to get a sortable field for my roles in Ultimate Member please.

Hi, I figured out what was happening. Even though I had created the fields they did not have any data in them and they didn’t show up. Once I put data into the fields both the field and their data was available to view.

Hi again missveronica, I am just having a small issue with what we did with the calculated field in that when I export my data to an excel or csv file, the option to select the calculated field that we created is not there. When I queried this with the plugin developer for the export plugin (WP Smart Export) he replied with the following message;

Does ‘UM profile’ store fields as post or user meta fields? If the fields are stored on a custom table, they will not show up.

WP Smart Export can only list fields that are stored as native WP user or post meta fields.

Are you able to shed any light on this please, I am not sure how the data is stored.

Thanks again
Dave

Thanks again missveronica

Hi missveronica, I replaced the quote marks in the shortcode and it worked. All is great now. Thank-you so much for your patience with me and again I am very thankful for all of you assistance with this.
regards
Dave

Hi missveronica. I have started from scratch after loading a backup of the website from before I started this process. I re did everything that you have advised and it all works perfectly until I add the last update for the shortcode which added the label parameter. When I use this it no longer displays either the field or a label. The shortcode that is causing problems is

[my_human_time_diff meta_key=”date_joined″ label=”Membership since”]

The shortcode that works expect for showing a label is

[my_human_time_diff meta_key=”date_joined”]

the snippet I am using is

/*
*       [my_human_time_diff meta_key=" date_joined " label="MyLabelText"]
*/

add_shortcode( 'my_human_time_diff', 'my_human_time_diff' );

    function my_human_time_diff( $atts ) {

        if( is_array( $atts ) && isset( $atts['meta_key'] )) { 
            um_fetch_user( um_profile_id());

            if( is_numeric( um_user( $atts['meta_key'] ) )) {                
                $first_time = um_user( $atts['meta_key'] );
            } else {
                if( is_string( um_user( $atts['meta_key'] ) )) $first_time = strtotime( um_user( $atts['meta_key'] ));
                else $first_time = false;
            }
            if( $first_time ) {
                if( isset( $atts['label'] )) $label = $atts['label'] . ' ';
                else $label = ''; 
                return '<div>' . $label . human_time_diff( $first_time, strtotime( wp_date( 'Y-m-d H:i:s' ))) . '</div>';
            } else return '';
        } else return '<div>Shortcode parameter error</div>';
    }

Can you offer any advice please?
regards
Dave

Hi missveronica, I don’t know what happened but the field disappeared completely from the form, I tried to fix it but ended up losing other fields as well so I am currently installing a backup of the whole database to get back to where it was yesterday.

Hi missveronica, sure, my short code field is
[my_human_time_diff meta_key=”membership_year_28″]
with the membership_year_28 being the meta key for the field that the date is in, is that what you want? The other fields for the short code are just Title, Privacy,Select Member Roles and Visibility.

If you have a private way of emailing I can send a screen capture of the form field or even give you admin access so you can see it yourself if you think that would be helpful.

Hi missveronica, I did add my title name to the snippet but because the form field is a shortcode field it does not give me a Label name or a meta Key name to use and the title name advises that it is for the backend only and won’t appear on the front end so Im guessing that it won’t work for me. Anyway, thank you again for all of your assistance with this project I very much appreciate your help.

Regards Dave

Hi missveronica, thanks for the new update. I replaced the old one with this new one but it still did not display the label name, do I need to do anything else as well?

Dave

Hi again missveronica. Thank you so much for your assistance with this it works well and does what I needed.

The only issue is that the returned amount does not show the field label name so it just sits out where the field is without a name.

Apart from that all is great.

Thanks again for your help, it is people like yourself that make the whole Word Press family feel welcome and included. I hope to one day be knowledgeable enough to also assist others with issues.

Thanks again
Dave
Admin for The Twin Cities Model Aircraft Club
tcmac.com.au

Hi again missveronica, the latest version of the snippet works well. Thank you again for your help with this. The only issue now is it displays an error if the [my_human_time_diff meta_key=”meta_key_time_name”] field is empty. I hate to ask again but is it possible to get it to do nothing if the cell is empty but display the result if a date is in the [my_human_time_diff meta_key=”meta_key_time_name”]. field.

thanks’
Dave