Member Import Doesn't Included "Company" section

[Ozan]

Hi,

I’ve exported my member list, refined its column heads as in the skeleton given here, and imported it using “member bulk import” plugin.

Every information imported properly, so I assume the format of the csv file was correct, but the “company” column didn’t imported to the new installation. Did the prefix for that one changed or is there any other problem?

Thanks a lot for the answers.

[Ozan]

In the example file, the column head was only “company”, may it the true one “company_name” or something like that?

[wzp]

It’s: company_name

All headers should match the columns in the wp_eMember_members_tbl of your database.

[Ozan]

Hi,

In the example file given in this address: https://www.tipsandtricks-hq.com/wordpress-membership/bulk-member-data-importer-addon-853 it rights only “company”.

The “subscription starts”, “last login” and “expiry date” are wrong for some of them. It writes “1 January 1970” default for most of them.

What are the correct headers for those, I’ll try to re-import and share the results.

Thanks.

[Ozan]

I realized now that the example file provided above wasn’t including the password section. I imported my list according to that and now none of the passwords for users working. And I moved to a new server.

I need “password” header and informations obviously. Is the sequencing of headers important? Can I add a password header to the end of the list, and is that ok and good to go? I use e-mail’s as password. If ok, I’ll just copy the email section to the “password” header if that’s ok.

Waiting your urgent reply on this because all none of my old members can login to the site now.

Thanks.

[wzp]

In the plugin directory, for the addon, open the classes/class.emember-member-bulk-import.php file. You will see a hard coded list of the recognized fields:

• user_name
• first_name
• last_name
• member_since
• membership_level
• account_state
• last_accessed
• last_accessed_from_ip
• email
• address_street
• address_city
• address_state
• address_zipcode
• country
• gender
• referrer
• extra_info
• reg_code
• subscription_starts
• txn_id
• subscr_id
• company_name
• phone
• more_membership_levels
• initial_membership_level
• home_page
• notes
• profile_image
• expiry_1st
• expiry_2nd

[admin]

After you import the users, You will need to ask the users to use the reset password functionality once to get their password.

Passwords are kept in the DB using a one way encryption (it is not plain text). So it is not something you can set when importing it. We follow the security standards for how passwords should be kept in the DB for maximum security.

[Ozan]

Hi,

Thanks for the replies. If we use this database method; https://www.tipsandtricks-hq.com/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116

Can we import the e’mail’s as passwords by adding a “password” header into the csv file? Is there any other way to import the emails as passwords.

My members aren’t the most tech-oriented people and I’m trying to find a way to make them to be able to use their old passwords, which is their e-mails.

[wzp]

There is no way to do this, because every eMember system uses a different random seed. The only way to preset the passwords, and it may be painful for you, is to use the eMember –> Members panel to manually edit and set each user password; after the import, to whatever the desired value is.

Yes, it probably could be automated, but it would be a custom coding job:

https://support.tipsandtricks-hq.com/need-custom-work-done

[Ozan]

I’ve done it the hard way.

Here are the problems I’ve faced while importing and my feature requests:

1) My first import didn’t include the “company” section, because in the example file in the column head it only writes “company”, not “company_name”. And it’s still the same. I think that example file should be fixed.

2) The dates in the list I exported from version 8.8.6 was in the “MM/DD/YYYY” format, but in the latest 8.9.4 version the format was “DD/MM/YYYY”. So when I imported my list, the numbers that are greater than 12 in the DD section, totally blowed in the new format and set the date “1 January 1970” for most of the users. After recognizing this I’ve changed the dates manually.

3) Sending members random passwords is a real PAIN. I’ve searched the forum and a lot of people are wondering a way to stop it. In import settings an option for “not send random passwords to members” would be a HUGE help. Becuase you make at least a few import try to set everything correctly and it totally blows sending email to hunderds of members in each time. I would highly request this feature if possible.

4) Another request I would like to ask is “Password import add-on”, just like the member importer. With that we can handle the migration process with less pain I believe.

Thanks again for your helps and providing good plugins and solutions.

[Author]

Posts