HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


CSV File not uploading working passwords

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#79256 (In Topic #16147)
Avatar

Honoured member

Hello i have an issue after importing a members database to my website. The data imports fine, however none of the predefined passwords listed in the file work. I have since deleted the password field from the csv (backed it up of course) and re=uploaded it trying to use the default password field of the importer, it did not seem to overwrite or fix the current issue.

I do not want to send a newsletter out to the member base say "You can now log in, please use the forgot password feature to create a password for login." What is causing this issue, and how can it be resolved?

Note: i did have to upload the csv twice, as the first time it only made the custom fields and did not retain the data, the 2ed time the data was stored properly.

Thanks
Back to the top
 
Posted
Rating:
#79257
Avatar

Please upload the CSV so I can have a try. Send as a whisper to me or a free support ticket (bug report) if you'd like to keep private.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79264
Avatar

Hi,

Well, I did get your CPF creation issue. It gave a big fat stack trace after creating the CPF, until I refreshed.

So that's definitely a bug and can be fixed by removing this line:

Code


               $cpf['text_original']=get_translated_text($cpf['cf_name'],$GLOBALS['FORUM_DB']);
from adminzone/pages/modules/admin_ocf_join.php.

However, I had no issues with passwords.

A couple of notes:
  1. I was careful with my copying and pasting into the login form, as that often copies whitespace. It's better to just type it manually.
  2. If the site is closed it'll still knock you right back to the site closed screen even if you log in (without a message - usability issue there, will fix).
  3. A similar thing may happen if the user has no access to where they're trying to go, although it probably will be more explicit saying access is denied rather than not logged in.

Even if you have some access denied error, or stuck in a closed site, the default footer will have a logout link (with a tooltip of the current username). So that's a good way to test it if you're not sure.

So is it definitely not logging in, or is it just a permissions issue?


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79266
Avatar

Honoured member

It keeps saying invalid password. If the current passwords are corrupt, will reuploading the file replace them? I have tired it with no luck however.

The site is currently open, the log in simply dose not accept the password.
Back to the top
 
Posted
Rating:
#79267
Avatar

Ah, of course – yes I bet it is that it doesn't like changing the passwords for existing members to new plain-text passwords. Will get back to you soon.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79268
Avatar

Sorry I missed that. This code is rather complex as it has to juggle different ways passwords might be specified. Usually when replacing existing records, you're importing the encrypted passwords you previously
exported (i.e. they're already encrypted and thus just copied straight into the database), but in this case it has to recognise they're fresh passwords.
Of course, you ended up editing due to the other bug that forced you to do a refresh.

Fix:
Attachment
adminzone/pages/modules/admin_ocf_join.php
» Download: admin_ocf_join.php (44 Kb, 99 downloads so far)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#79300
Avatar

Honoured member

Sorry for the delayed response, the fix works great. Thank you again for your assistance.
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: