Export User Tool from codection. – Phone Number

Are you viewing the CSV file in Excel or Notepad? Excel sometimes misformats columns, causing them to appear as dates or equations. To prevent this, select the column and choose the ‘number’ format type from the dropdown menu at the top of the sheet.

Thank you so much for getting back to me. I was hoping someone would step up to help. I am primarily a libreoffice user, but have no problem with excel, number, sheets or anything else. You gave me a tip and I looked at the file in a raw text file and the mobile phone field is gibberish. Here is a user record as text. The phone number from the css file is in bold.

“Coker University”,”Abbie McCants”,McCants,Abbie,Abbie,[email protected],0303-2929-37373737,”a:1:{i:0;s:6:””Female””;}”,Junior

From her user profile, her input was – 8433259652.

So, somehow when I do the export the 8433259652 turns into 0303-2929-37373737.

I also do not know where the “” marks are coming from in some strings or while the string female comes out as a:1:{i:0;s:6:””Female””;}”

Bottom line, I do not thing the issue is when I open the csv file and do the mapping of the column formats. Rather, I think it has something to do with the plugin or how I have the meta tag field formatted or something.

Thanks for any insight at all.

What form builder plugin are you using?

ultimate member

Have you tried using the form builder from Elementor itself, or perhaps WPForms? Create a test page with a form built using one of these other plugins, and then register a test user for this purpose. Afterward, export the CSV again and check if the test user’s cellphone number is correctly exported.

The ‘Female’ part looks weird because WordPress uses PHP to serialize information and record it, and then unserialize it before exporting (or at least that’s how it’s supposed to work).

If you’re also using another plugin to export user data, please let me know.