- This topic has 13 replies, 3 voices, and was last updated 9 years, 11 months ago by
.
-
Posts
-
How can I import members directly from a formatted CSV file? I have 725 to import and they are NOT users. I want to import all the information including FN, LN, Address, Phone etc.
PS: after 3 months of testing – we choose Simple Membership for flexibility and overall usefulness – GOOD JOB!
Hi, unfortunately at present there is not add-on that allows you to import members from an external CSV file. You could try the following plugin. But I have not tested importing members from an external CSV file into Simple Membership plugin yet.
@johnsentgeorge, you are not alone! I also want this feature or plugin. That CSV plugin should work, but it is overkill and still requires a good deal of technical skill to use. Importing users from a spreadsheet/csv is surely a relatively common need, and thus a market.
So, is there anyone who could do the import for me? As mentioned, there are 725 members and the CSV file is already formatted. I am willing to pay for this service as the deadline in this Thursday. My client would be very impressed if we could accomplish this task on schedule.
I have already tried “Import users from CSV with meta” plugin with only limited success.
I am a PHP developer and very comfortable with MySQL (the database) and importing data from CSV. The only variable I am missing is familiarity with the WordPress tables and what tables must be touched to add a user. It may be as simple as a single users table, but it could be more complicated.
According to this article, it looks like 2 tables are involved:
wp_users
wp_usermeta…and it may not even be necessary to create the wp_usermeta row up-front. Easy to test this.
If I knew anything about writing WordPress plugins, I’d create an “Import Users from CSV” plugin for all of us.
@johnsentgeorge, if you don’t figure out a solution, I am confident I can import your users. Email me at troy at troywolf dot com. I have about 100 users I’ll need to import for another project, so I want to figure this out anyway.@johnsentgeorge, I just realized you referenced a plugin designed to do exactly what we want.
https://wordpress.org/plugins/import-users-from-csv-with-meta/You say you had “limited success”. What was this issue? The author offers, “Ask anything in support forum, we try to give the best support”
Import users from CSV with meta — is a good plugin
BUT
for Simple Membership the information needs imported into the membership table using EXISTING fields.
My experience is that it ADDS fields in the USER table making then inaccessible to the membership table during a Simple Membership import.
—
I am an end user not a programmer so … perhaps it is just my ignorance of the how to.AHA! Then you almost have your problem solved! SimpleMembership has a plugin that makes it super easy to turn your WordPress users into members in SimpleMembership! It’s a free plugin, too!
https://simple-membership-plugin.com/import-existing-wordpress-users-simple-membership-plugin/
This also means you have solved my user import problem. 🙂
YUP you are correct
BUT
the custom fields that “Import users from CSV with meta” creates are not accessible to the Simple Membership import plugin.
Again, unless I am not understanding the how to…Hmmmm…I THINK you are wanting your membership specific profile fields to get copied from the WP user’s meta data. Is this what you are hoping for?
I have not tested much, but I believe you are correct–none of the custom user data get’s copied into your member’s profile. From a technical perspective, without actually looking at the nitty-gritty details, I assume it would be difficult to know how to properly map the fields. Somebody could create a fancy plugin that lets you list all the custom fields for a WP user, then one-by-one map them to a SM profile field where it makes sense. Then copy.
Unencumbered by facts, if WP user records support custom fields (meta), why doesn’t SM just store user profile data there in the first place? I’m sure there’s a good reason–as I said, I don’t really know WP under the covers.
Do I understand the problem correctly?
“Import users from CSV with meta” plugin did a smooth error free job of importing generally
again BUT
even FN and LN did not map properly.
Client wants the address, etc imported as well
BUT
the key information is all contained in the generic USER table and I could live with just that importing correctly.
Having the additional meta information – address, job site, etc – import would be very nice but they are not making it a requirement for our contract.
SO
bottom line is I think your analysis and reply is correct.
THANKS for the interaction – thesis quite a ways beyond me…I am at a client’s office today, so I can’t test this until this evening, but I want to understand what exactly the SM user import plugin does–which fields does it try to copy?
I remain confident that I can figure this out and import your users, but we’ll need to communicate quite a few details, and I’ll need access to your database. Just getting that access may require me to walk you through quite a bit–depending on your technical understanding of these things and the access you currently have. (Some folks don’t even have command-line access to their server.)
To do this safely, I’d like to copy your wordpress files and your database to create a duplicate of your system to test importing. This allows me to mess things up, then restore the database to try again. Once we are confident the result is exactly what you want, we can run the import in your real system.
I could share what we learn with SM to potentially help them develop a richer user import plugin.
here is DB info
17. wpew_swpm_members_tbl TABLE OPTIMIZED MyISAM 8 58.6 KB
18. wpew_swpm_membership_meta_tbl Table is already up to date MyISAM 5 6.4 KB
19. wpew_swpm_membership_tbl Table is already up to date MyISAM 4 3.3 KB
20. wpew_swpm_payments_tbl Table is already up to date MyISAM 0 1 KB
21. wpew_term_relationships Table is already up to date MyISAM 56 6.1 KB
22. wpew_term_taxonomy Table is already up to date MyISAM 18 4.9 KB
23. wpew_termmeta Table is already up to date MyISAM 0 4 KB
24. wpew_terms Table is already up to date MyISAM 18 13.6 KB
25. wpew_usermeta TABLE OPTIMIZED MyISAM 175 28.9 KB
26. wpew_users TABLE OPTIMIZED MyISAM 9 9.2 KB@johnsentgeorge, the table names you posted don’t really help. You and I will need to take this offline to share details that you do not want to share in a public forum. That is why I provided my email address to you earlier: troy at troywolf dot com
In order to help you I will need at a minimum your definition of user data to import. The easiest way is to share your user data CSV. I can understand if you don’t want to share your real user data with me, and I don’t need your real data. I just need the same CSV structure (same fields) with at least 2 rows of data (real or fake) to play with.
If the fields are not obvious, I may need additional explanation of what WP fields you expect the CSV fields to map into. We can figure that out when I see your test CSV file.
On my own systems, I can install a fresh WP instance and install the SM plugin to test the import. If, however, we find that part of what you need imported depends on other plugins you are using, things will get a bit more complicated. We can worry about that if/when we have to.
Once I think I have an import solution that works, we will back up your database as a precaution, then run the real import against your system.
- You must be logged in to reply to this topic.