Importing members from Ghost

Clay Gordon
Clay Gordon
@claygordon
2 weeks ago
740 posts
I have been working on SSO from Ghost and running into lots of problems making it work.

In the meantime, I want to import a subset of members. I used to host this community on Jamroom and want to import members that signed up since I made the switch to Ghost.

I can export members from Ghost no problem but I have been looking around for an import feature that was not associated with Ning3 imports. There is no obvious entry in the documentation and I searched for posts on this topic in this forum.

I also want to make sure that the import function:

* will dedupe the imports based on email addresses already in the database
* will send an email to the new members asking them to create a password and complete their profile

Finally, that I know the correct order of columns for the import.

TIA,
Clay
michael
@michael
2 weeks ago
7,746 posts
I've not used it, but we have a module "user Import"
https://www.jamroom.net/the-jamroom-network/networkmarket/606/user-import

Is that what you're after?
Clay Gordon
Clay Gordon
@claygordon
2 weeks ago
740 posts
Michael – That does appear to be the solution, but the link to the documentation generates an "OOPS... PAGE NOT FOUND" error for me with or without my VPN active.
Clay Gordon
Clay Gordon
@claygordon
2 weeks ago
740 posts
One more issue – I am self-hosting and this module does not appear to be in the marketplace.
paul
@paul
2 weeks ago
4,332 posts
There are two modules that can be used in conjunction that will likely achieve what you want, jrExporter and jrImporter. They are still in beta so not in the regular Marketplace.
Its a long time since I developed and used them so I'll refamilerise myself with them and get back later with how they might be able to help.
Paul


--
Paul Asher - JR Developer and System Import Specialist
Clay Gordon
Clay Gordon
@claygordon
2 weeks ago
740 posts
Paul:

Thanks!
paul
@paul
one week ago
4,332 posts
Hi Clay, this is what you need to do...

1) Install both the jrExporter and jrImporter modules from the marketplace beta channel.

2) In the Exporter module's plugins/CSV/samples folder there is a sample_members file. Use this to create a csv file with all the exported Ghost members.

3) Configure the Exporter module selecting the CSV plugin and pointing it to your file.

4) Run the Exporter. This will create 'intermediate' JSON files for the Importer module to use.

5) Run the Importer module. This will use the intermedite JSON files to import your members as Jamroom Profiles and Users into your Jamroom site.

hth


--
Paul Asher - JR Developer and System Import Specialist
Clay Gordon
Clay Gordon
@claygordon
one week ago
740 posts
Paul:

Thanks.

I have installed both modules and will FTP to my site to find the sample .CSV file.

I want to confirm:

1) the importer module will dedupe email addresses already in the database
2) whether or not the imported members will be notified by email or if that is a manual process for me
paul
@paul
one week ago
4,332 posts
Hi Clay

1) The importer module does check for duplicate email addresses and will not import a new user with the same address.

2) No. What I suggest is that you temporarily clone the quota(s) that you want to import profiles to and instead import them to the clone quota. You can then send emails just to that quota using another module (jrNewsletter I think - need to check that). At some point later you can then move all imported profiles from their clone quota to the original.

As the Importer and Exporter modules are still in beta, can I suggest that when you have created the CSV file you first send it to me so that I can run it on one of my test sites to see if things work ok, before trying it on your live site?

Thanks


--
Paul Asher - JR Developer and System Import Specialist
Clay Gordon
Clay Gordon
@claygordon
one week ago
740 posts
Paul:

I am not sure I know how to clone a quota but I was planning on creating a new quota. If I can clone an existing quota with all its attributes – that would be great. I searched the documentation but found no reference to that capability.

I checked and jrNewsletter does allow me to send to specified quotas.

I will be happy to send you a test CSV for you to run.
paul
@paul
one week ago
4,332 posts
Quote: I am not sure I know how to clone a quota

ACP=>Profiles=>Profiles=>Quota Browser

hth


--
Paul Asher - JR Developer and System Import Specialist

Tags