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.


Mass Importing Members Question

Login / Search

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

Fan in action

Importing members

I have been testing and to set my site up, I import members from another registered site.
The importing site has about 65 profile criteria and I matched them 1 for 1 with my OC portal site.
When I attempt to import them, it fails and throws errors.

Is there a limit to the number of fields and number of accounts you can import ?


Back to the top
 
Posted
Rating:
#58334
Avatar

Hi,

Is this a CSV import, and what errors did you receive?

There are no particular limits coded in.


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:
#58339
Avatar

Fan in action

This is what I get.

Unfortunately a query has failed [ALTER TABLE ocp4_f_member_custom_fields ADD FULLTEXT mcf90 (field_90)] [Too many keys specified; max 64 keys allowed] (version: 4.3.0, PHP version: 5.2.3, URL: /adminzone/index.php?page=admin_ocf_join&type=_import_csv)
Back to the top
 
Posted
Rating:
#58340
Avatar

Oh I see, this is a limit MySQL is imposing that we weren't aware of. I'll see if we can get a workaround for it 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:
#58341
Avatar

Fan in action

The import im doing has about 60 user fields on it, and I will need to be able to import it.

Thanks
Back to the top
 
Posted
Rating:
#58350
Avatar

Hi,

In 4.3.1 ocPortal will sense when you get to this many CPFs and stop adding indexes for them. As a result it won't include the additional fields for individual search filtering in the search module. Unfortunately that's unavoidable, due to this limit in MySQL.

Here's what we're adding to the documentation:
If you have more than 60 textual CPFs (except Comcode ones), any ones created after the 60th will not be included for searching on the search module's member search form.


However, Comcode/translateable fields are not included in the limit, so you can add as many of these as you like and still have them searchable. When you import members from CSV files it will assume you are not importing Comcode, unless a field with the same name already exists and is set up as such a field. Therefore (and this will work right now) you can pre-create fields as Comcode/translateable fields, and the limit won't apply.


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:
#58351
Avatar

Fan in action

I will change them and let you know.
Back to the top
 
Posted
Rating:
#58360
Avatar

Fan in action

I changed a bunch of them, and then reduced my import file to about 25 fields and it still gives this error.
Back to the top
 
Posted
Rating:
#58439
Avatar

Hi,

Sorry for the delay in replying, I hope to reply very soon now.


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:
#58451
Avatar

Hi,

There were some problems with ocPortal not correctly removing indexes when editing fields. If you delete the CPFs and recreate with the intended type it should resolve the problem.
In 4.3.1 ocPortal will keep better track of what indexes to use.


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
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: