Hi Aly,

For the benefit of others who may read this thread too...

Once you have done the comparison you will need to remove the columns from jos-users as CB Juice will not be expecting them and will abort.

Passwords is an issue with CB Juice. I always delete the password contents as they get exported as encrypted from the database but CB Juice imports them as text. So to avoid password issues either delete the contents or column; alternatively enter passwords in clear text. I would opt to delete.

I found that the recent site I did with 2000+ users kept breaking because there was a comments field and it had lots of double quote marks " and commas , both of which caused me some real headaches.

The other 'glitch' was the fact that the client database was stored in western format so the £ (GBP sign) truncated every comment at the sign and then moved all the data to the wrong fields. I solved this by doing advanced export with Access and changed style to utf8 for export and used the tilde (~) sign as the field delimiter.

I was using an external database though.

Aly - I have sent you a private message.

Regards

David

Post edited by: 3cellhosting, at: 2009/06/21 10:53

After much trial and error and many many hours, I aborted plan A and opted to migrate the original site and upgrade to Joomla 1.5. This kept all of my CB users intact.

So I think I am going to work with this (my 4th development install for this one project! ) and RE-install CBSubs (again), re-configure, etc.

Question:
If I import all my users to the CBSubs I created, can I then go through each and manually set as expired the ones who are not currently paid up?

After much trial and error and many many hours, I aborted plan A and opted to migrate the original site and upgrade to Joomla 1.5. This kept all of my CB users intact.

So I think I am going to work with this (my 4th development install for this one project! ) and RE-install CBSubs (again), re-configure, etc.

Post edited by: Aly, at: 2009/06/22 20:36