I have a multisite installation with several sub-sites. I created a separate csv file for each sub-site. The files are exactly the same except for the users of course. Some sub-site users belong to more than one sub-site. What I expected was: 1, the sub-site users would be added to the sub-sites as subscribers; 2, the sub-site users would also be added to the main site as subscribers, and 3, the duplicates would be ignored. My users log in using their email address as username. Here is an example line from one of the files: "staa,null,email@example.com,null,firstname.lastname@example.org,subscriber".
The first file seems to have gone fine - it all worked. After that the trouble began. The files ran only partially - it only took the first 15 or so. I handled that by deleting the ones accepted from the file and running it again. And again. And again until they were all accepted. Sometimes a few sometimes a bunch. Except for the first file never were all accepted without the deletions. In all cases I cleared the queue before trying again. The log file returns a 404 error so no help there.
Only the first file was added to the main site, none of the subsequent ones added more than a few from what I can tell.
In many cases, the names were added to the database with no sub-site or main site reference at all.
Any ideas on what went wrong? Any ideas about how I might automatically connect users to the main site and the sub-sites? How can I fix this mess?