modify profile export csv

srx
@srx
5 years ago
18 posts
When in the profile browser, we can see profile name and User Name,User Email (screenshot attached).
But when exporting csv from the same location, it lacks User Names/User Emails.
Anyway to add these to the Profile csv export?
updated by @srx: 08/14/19 07:10:52AM
paul
@paul
5 years ago
4,331 posts
In Jamroom, profiles and users are seperate item sets (though they are linked by their _profile_id and _user_id fields) so the short answer is no, sorry.
You would need to export both the profile and user CSVs and try to link them outside of Jamroom. Maybe Excel could do this? Not sure. Otherwise, a custom module would need to be developed to do it.

Alternatively, checkout our Exporter module. This can export linked profiles and users (as 'members') to a JSON file.

https://www.jamroom.net/the-jamroom-network/documentation/importing-merging-sites-to-jamroom/4727/about-the-exporter

Note that the Exporter module is still in beta so you would need to enable the beta channel in your site's marketplace module in order to install it directly.

hth


--
Paul Asher - JR Developer and System Import Specialist

updated by @paul: 04/16/19 12:04:50PM
srx
@srx
5 years ago
18 posts
OK thanks Paul
srx
@srx
5 years ago
18 posts
Hey Paul, working nicely! so one thing i cant figure out is that the parsed json file has 972 records, but in the tunetrax dashboard I see 1703 profiles.
So the exporter >
Export a Jamroom (5 onwards) site contents JSON files for import to another Jamroom site
> Export Members
Whats the difference between members and profiles?
Thanks
andy
paul
@paul
5 years ago
4,331 posts
Quote: Whats the difference between members and profiles?

Both Jamroom profiles and their paired user are exported as a single json record so the term 'member' is just the name for this. This is because the Importer/Exporter modules are really designed to allow content from other CMS systems (Ning, Wordpress etc.) to be imported to Jamroom, and unlike Jamroom, most of them only have the concept of 'members' and not profiles and users.

Quote: so one thing i cant figure out is that the parsed json file has 972 records, but in the tunetrax dashboard I see 1703 profiles.

The only thing I can think of is that the quota mapping for the plugin isn't configured correctly so some profile/user pairs are not being exported. Check that first.

hth


--
Paul Asher - JR Developer and System Import Specialist
srx
@srx
5 years ago
18 posts
All the profiles are mapped. I can see where one user might have more than one profile, but thats maybe 50 max profiles... any other ideas?
If i were to go the api route, can i use Bridge to get profiles tied to users, just like Members in Exporter?
thanks
paul
@paul
5 years ago
4,331 posts
Can you send the site url and admin login as a ticket so that I can check this out?
The Exporter module is still in beta so would like to see if this is an issue or not.
Thanks


--
Paul Asher - JR Developer and System Import Specialist

Tags