ElkArte Community

General => OpenImporter => Topic started by: andy on April 06, 2016, 12:30:49 am

Title: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: andy on April 06, 2016, 12:30:49 am
I had a few problems getting the importer working (our fault for messing with some PM tables) but after getting the import done I checked several member subscription dates (profile>paid subscriptions) and there are none there.
Paid subscriptions is active and all the details on the set up page for subscriptions look ok. Even on that page it lists 0 subscriptions.
Title: Re: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: emanuele on April 06, 2016, 05:11:15 am
In the sense that subscriptions were not ported from SMF to Elk?
I don't think subscriptions are among the things imported.
It shouldn't be too difficult to have them, maybe TE has some trick for that. :P
Title: Re: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: andy on April 06, 2016, 08:34:52 am
I thought member subscriptions were imported. Ah ok.  :o
Title: Re: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: Spuds on April 06, 2016, 09:32:18 am
Looks like it should import the subscriptions table, but that may just be the subscriptions themselves not the members who have subscribed.  Something to investigate for sure.
Title: Re: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: TE on April 07, 2016, 02:20:29 pm
yep, user subscriptions are indeed missing..

I'll add this to the importer soon. The database strucure for both SMF and Elk is IIRC identically here, so this should work:
Code: [Select]
<step>
<title>Importing member subscriptions</title>
<detect>{$from_prefix}log_subscribed</detect>
<destination>{$to_prefix}log_subscribed</destination>
<presql>TRUNCATE {$to_prefix}log_subscribed;</presql>
<query>
SELECT
*
FROM {$from_prefix}log_subscribed;
</query>
</step>
Title: Re: SMF 2.011 to ElkArte 1.07: Subscriptions set up but none shown in profiles
Post by: Spuds on April 07, 2016, 02:35:25 pm
@TE cool!  

The master branch should be working these days as well and I think I added all of your previous xml updates to it as well.