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.


creating a new catalog 4.1.6

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#48287 (In Topic #10558)

Honoured member

create a new catalogue and import data

Hello,I have a tab delimited file I'd like to build a catalogue from. Is it possible, after create the catalgue to just import the data in to it? I read in the tutorial wwhere you can create bulk catagories by using a pipe, and that's as much as it mentions. thanks.
Back to the top
 
Posted
Rating:
#48288
Avatar

Hi,

Sorry that's not currently a feature.


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:
#48525

Honoured member

Hi,  can the caracter limit in the (Add New Catalogue / Autofill) edit box be increased?  When I try to create a list:

Code

U.S. Government\Senate|U.S. Government\House of Representatives|States\Alabama|States|Alaska|etc.

There's only enough room for the two U.S. Government and thirteen of the States categories.

I know a simular list was used for the example in the tutorial, and it had all the states, and providences of Canada.  So I assumed it wouldn't be nothing but a thing.
Back to the top
 
Posted
Rating:
#48552
Avatar

Hi,

Yes, we'll get that fixed. As the fix involves changes to 3 files, I think it's best you use a temporary workaround.

Could you edit the FORM_SCREEN_INPUT_LINE template, so that 255 is set to something larger like 10000.

This isn't an ideal fix because it allows you to put really long text in everywhere - but I don't think you're going to do accidentally go over the 255 limit in any normal situation.


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:
#48557

Honoured member

As usual Chris, You de man!
Back to the top
 
Posted
Rating:
#48610

Honoured member

I assume the answer to this is obvious, but one never knows.  I'm assuming that after creating my databases, I can lower that number back down to 255, and it not interfere with anything.  Correct?


Last edit: by chipster
Back to the top
 
Posted
Rating:
#48614
Avatar

Yes.


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:
#48630

Honoured member

Well I've done it now.

Hi Chris,
Well I can tell you that the system doesn't like you placing very large amounts of text in the catalogue autofill edit box.  I raised the number to 15000, and input 14793 characters, and all heck broke loose.  It created the catalogue alright, but none of the categories are there, and what's worse when I try to edit it, so I can delete it, I get the follow message.  btw: none of the other catalogues seem to be corrupted.  Is there any way of deleted this entry?

Code

A source code file is missing: hooks/modules/catalogue_fields/ (or an overridden
equivalent to this path) (version: 4.1.6, PHP version: 5.2.6, URL: /cms/index.php?zone=cms&wide_high=1&page=cms_catalogues&type=_edit_catalogue&label_for__id=Catalogue&id=algov&require__id=0)
Here is the stack trace:
Below is a stack trace revealing the state the software was in when the error occurred.
If this represents a bug in the unmodified software, you may want to check ocPortal
website for a fix, and if there isn't one, report this as a bug. Please note that
merely posting a stack trace is not sufficient for us to solve your problem; the
stack trace is just an aid that presents us with additional information. We still
need to know the error message, what you tried to do, how you tried to do it, version
numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so
that we can fix it for you promptly.
File
'/home/fsfa/public_html/sources/failure.php'
Line
'220'
Function
'get_html_trace'
Args
File
'/home/fsfa/public_html/sources/global2.php'
Line
'825'
Function
'_fatal_exit'
Args
object
File
'/home/fsfa/public_html/sources/global.php'
Line
'152'
Function
'fatal_exit'
Args
object
File
'/home/fsfa/public_html/cms/pages/modules/cms_catalogues.php'
Line
'775'
Function
'require_code'
Args
'hooks/modules/catalogue_fields/'
File
'/home/fsfa/public_html/sources/aed_module.php'
Line
'835'
Function
'get_field_fields'
Class
'Module_cms_catalogues_alt'
Object
Module_cms_catalogues_alt::__set_state(array( 'lang_type' => 'CATALOGUE', 'select_name'
=> 'CATALOGUE', 'select_name_description' => 'DESCRIPTION_CATALOGUE', 'permissions_require'
=> 'cat_high', 'permission_module' => 'catalogues_catalogue', 'non_integer_id' =>
true, 'award_type' => 'catalogue', 'is_tree_catalogue' => false, 'menu_label' =>
'CATALOGUES', 'javascript' => 'var fn=document.getElementById(\'title\'); if (fn)
{ var form=fn.form; fn.onchange=function() { if ((form.elements[\'name\']) && (form.elements[\'name\'].value==\'\'))
form.elements[\'name\'].value=fn.value.toLowerCase().replace(/[^\\w\\d\\.\\-]/g,\'_\').replace(/\\_+$/,\'\');
}; }', 'module_type' => NULL, 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require'
=> NULL, 'skip_validation' => false, 'default_type' => NULL, 'author' => 'Chris Graham',
'organisation' => 'ocProducts', 'user_facing' => false, 'send_validation_request'
=> true, 'check_validation' => true, 'archive_entry_point' => NULL, 'archive_label'
=> NULL, 'view_entry_point' => NULL, 'protect_first' => 0, 'permission_page' => NULL,
'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b'
=> NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => ocp_tempcode::__set_state(array(
'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array
( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output'
=> NULL, )), 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever'
=> NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false,
'special_edit_frontend' => false, 'upload' => NULL, 'possibly_some_kind_of_upload'
=> false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL,
'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed'
=> NULL, 'type_code' => 'v', 'catalogue' => false, 'output_of_action_is_confirmation'
=> false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name'
=> NULL, 'do_preview' => true, 'add_one_label' => NULL, 'add_one_cat_label' => NULL,
'edit_this_label' => NULL, 'edit_one_label' => NULL, 'edit_this_cat_label' => NULL,
'edit_one_cat_label' => NULL, 'do_next_description' => NULL, 'appended_actions_already'
=> false, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true,
'orderer' => NULL, 'table' => NULL, ))
Type
'->'
Args
false
16
'existing_field_39_'
5
'Zip'
'Contacts Zipcode'
''
1
1
1
''
1
1
1
File
'/home/fsfa/public_html/sources/aed_module.php'
Line
'217'
Function
'_ed'
Class
'standard_aed_module'
Object
Module_cms_catalogues_alt::__set_state(array( 'lang_type' => 'CATALOGUE', 'select_name'
=> 'CATALOGUE', 'select_name_description' => 'DESCRIPTION_CATALOGUE', 'permissions_require'
=> 'cat_high', 'permission_module' => 'catalogues_catalogue', 'non_integer_id' =>
true, 'award_type' => 'catalogue', 'is_tree_catalogue' => false, 'menu_label' =>
'CATALOGUES', 'javascript' => 'var fn=document.getElementById(\'title\'); if (fn)
{ var form=fn.form; fn.onchange=function() { if ((form.elements[\'name\']) && (form.elements[\'name\'].value==\'\'))
form.elements[\'name\'].value=fn.value.toLowerCase().replace(/[^\\w\\d\\.\\-]/g,\'_\').replace(/\\_+$/,\'\');
}; }', 'module_type' => NULL, 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require'
=> NULL, 'skip_validation' => false, 'default_type' => NULL, 'author' => 'Chris Graham',
'organisation' => 'ocProducts', 'user_facing' => false, 'send_validation_request'
=> true, 'check_validation' => true, 'archive_entry_point' => NULL, 'archive_label'
=> NULL, 'view_entry_point' => NULL, 'protect_first' => 0, 'permission_page' => NULL,
'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b'
=> NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => ocp_tempcode::__set_state(array(
'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array
( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output'
=> NULL, )), 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever'
=> NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false,
'special_edit_frontend' => false, 'upload' => NULL, 'possibly_some_kind_of_upload'
=> false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL,
'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed'
=> NULL, 'type_code' => 'v', 'catalogue' => false, 'output_of_action_is_confirmation'
=> false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name'
=> NULL, 'do_preview' => true, 'add_one_label' => NULL, 'add_one_cat_label' => NULL,
'edit_this_label' => NULL, 'edit_one_label' => NULL, 'edit_this_cat_label' => NULL,
'edit_one_cat_label' => NULL, 'do_next_description' => NULL, 'appended_actions_already'
=> false, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true,
'orderer' => NULL, 'table' => NULL, ))
Type
'->'
Args
File
'/home/fsfa/public_html/sources/zones.php'
Line
'308'
Function
'run'
Class
'standard_aed_module'
Object
Module_cms_catalogues::__set_state(array( 'lang_type' => 'CATALOGUE_ENTRY', 'select_name'
=> 'ENTRY', 'permissions_require' => 'mid', 'permissions_cat_require' => 'catalogues_catalogue',
'permissions_cat_name' => 'catalogue_name', 'permissions_cat_require_b' => 'catalogues_category',
'permissions_cat_name_b' => 'category_id', 'user_facing' => true, 'seo_type' => 'catalogue_entry',
'catalogue' => true, 'award_type' => 'catalogue_entry', 'possibly_some_kind_of_upload'
=> true, 'do_preview' => NULL, 'menu_label' => 'CATALOGUES', 'donext_category_id'
=> NULL, 'donext_catalogue_name' => NULL, 'module_type' => 'catalogues', 'redirect_type'
=> NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation'
=> false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' =>
'ocProducts', 'send_validation_request' => true, 'check_validation' => true, 'archive_entry_point'
=> NULL, 'archive_label' => NULL, 'view_entry_point' => NULL, 'protect_first' =>
0, 'permission_page' => NULL, 'permission_module' => NULL, 'add_text' => '', 'edit_text'
=> '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever'
=> NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false,
'special_edit_frontend' => false, 'upload' => NULL, 'cat_aed_module' => Module_cms_catalogues_cat::__set_state(array(
'lang_type' => 'CATALOGUE_CATEGORY', 'select_name' => 'NAME', 'permissions_require'
=> 'cat_mid', 'permission_module' => 'catalogues_category', 'seo_type' => 'catalogue_category',
'catalogue' => true, 'award_type' => 'catalogue_category', 'upload' => 'image', 'javascript'
=> 'var mt=document.getElementById(\'move_target\'); var form=mt.form; var crf=function()
{ var s=mt.selectedIndex==0; form.elements[\'move_days_lower\'].disabled=s; form.elements[\'move_days_higher\'].disabled=s;
}; crf(); mt.onclick=crf;', 'menu_label' => 'CATALOGUES', 'donext_catalogue_name'
=> NULL, 'module_type' => NULL, 'redirect_type' => NULL, 'code_require' => NULL,
'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => NULL,
'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'user_facing' => false,
'send_validation_request' => true, 'check_validation' => true, 'archive_entry_point'
=> NULL, 'archive_label' => NULL, 'view_entry_point' => NULL, 'protect_first' =>
0, 'permission_page' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name'
=> NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text'
=> '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories'
=> NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL,
'do_next_editing_categories' => false, 'special_edit_frontend' => false, 'possibly_some_kind_of_upload'
=> false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'posting_form_title'
=> NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code'
=> 'c', 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview'
=> false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' =>
true, 'add_one_label' => NULL, 'add_one_cat_label' => NULL, 'edit_this_label' =>
NULL, 'edit_one_label' => NULL, 'edit_this_cat_label' => NULL, 'edit_one_cat_label'
=> NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description'
=> NULL, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true,
'orderer' => NULL, 'table' => NULL, )), 'alt_aed_module' => Module_cms_catalogues_alt::__set_state(array(
'lang_type' => 'CATALOGUE', 'select_name' => 'CATALOGUE', 'select_name_description'
=> 'DESCRIPTION_CATALOGUE', 'permissions_require' => 'cat_high', 'permission_module'
=> 'catalogues_catalogue', 'non_integer_id' => true, 'award_type' => 'catalogue',
'is_tree_catalogue' => false, 'menu_label' => 'CATALOGUES', 'javascript' => 'var
fn=document.getElementById(\'title\'); if (fn) { var form=fn.form; fn.onchange=function()
{ if ((form.elements[\'name\']) && (form.elements[\'name\'].value==\'\')) form.elements[\'name\'].value=fn.value.toLowerCase().replace(/[^\\w\\d\\.\\-]/g,\'_\').replace(/\\_+$/,\'\');
}; }', 'module_type' => NULL, 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require'
=> NULL, 'skip_validation' => false, 'default_type' => NULL, 'author' => 'Chris Graham',
'organisation' => 'ocProducts', 'user_facing' => false, 'send_validation_request'
=> true, 'check_validation' => true, 'archive_entry_point' => NULL, 'archive_label'
=> NULL, 'view_entry_point' => NULL, 'protect_first' => 0, 'permission_page' => NULL,
'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b'
=> NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => ocp_tempcode::__set_state(array(
'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array
( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output'
=> NULL, )), 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever'
=> NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false,
'special_edit_frontend' => false, 'upload' => NULL, 'possibly_some_kind_of_upload'
=> false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL,
'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed'
=> NULL, 'type_code' => 'v', 'catalogue' => false, 'output_of_action_is_confirmation'
=> false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name'
=> NULL, 'do_preview' => true, 'add_one_label' => NULL, 'add_one_cat_label' => NULL,
'edit_this_label' => NULL, 'edit_one_label' => NULL, 'edit_this_cat_label' => NULL,
'edit_one_cat_label' => NULL, 'do_next_description' => NULL, 'appended_actions_already'
=> false, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true,
'orderer' => NULL, 'table' => NULL, )), 'posting_form_title' => NULL, 'posting_form_text'
=> '', 'posting_form_text_parsed' => NULL, 'javascript' => NULL, 'type_code' => 'd',
'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview'
=> false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'add_one_label'
=> NULL, 'add_one_cat_label' => NULL, 'edit_this_label' => NULL, 'edit_one_label'
=> NULL, 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'do_next_description'
=> NULL, 'appended_actions_already' => false, 'select_name_description' => NULL,
'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer'
=> NULL, 'table' => NULL, ))
Type
'->'
Args
File
'/home/fsfa/public_html/sources/site.php'
Line
'802'
Function
'load_module_page'
Args
'cms/pages/modules/cms_catalogues.php'
'cms_catalogues'
File
'/home/fsfa/public_html/sources/site.php'
Line
'635'
Function
'request_page'
Args
'cms_catalogues'
true
File
'/home/fsfa/public_html/cms/index.php'
Line
'50'
Function
'do_site'
Args
Back to the top
 
Posted
Rating:
#48638

Honoured member

Oops!

Ok.  I don't think it was the amount of characters so much as the structure I was using.  I was able to create a catalogue, and use 2500 characters in the autofill box, and it did fine.  However, when I create a different catalogue using the same data, but trying to create sub-categories is when it all goes south.  I thought, from the example in the tutorial, I could go at least one branch level deep, but must not be the case.  Now I have two databases that I can't edit  nor delete.  Lord I hope there's a way of fixing this.  I really don't look forward to starting all over.  I have around 400 CEDi pages and hours of other work that I'd hate to lose.
Back to the top
 
Posted
Rating:
#48639
Avatar

Hi,

We'll get it fixed for you.

I'm really stacked with work at the moment, but I'll get back to you.

In the mean time it would help me if you could paste in the auto-fill you're trying to use to a post here.


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:
#48646

Honoured member

Nothing but a thing.

Hi Chris,
No problem, I know you're a busy guy.  In the meantime, I've been trying to isolate the issue as best I can.  Here's what I've been able to determine thus far.

It doesn't seem to be an issue with the autofill box after all.  I currently have the character limit, in FORM_SCREEN_INPUT_LINE.tpl, set to 4500, and created two different databases using the same autofill text, which is posted below.  In one database I kept it very simple, and added only one feild, while in the other I populated all ten fields.  The database where I started with only one field created just fine, and all sub-categories were in their proper places.  On the other hand, the database I created with all ten feields populated corrupted.

The common factor in all this seems to be the number of feilds and not amount of autofill text. All the other catalogues that corrupted were created with all ten fields populated, but when I create a catalogue with only a couple or so
fields seem to do fine.

On the datebase that I originally created using only one entry field, i have now successfully edited and added a total of eleven fields.  (strange)

Here's the autofill text I used:

Code

Alabama U.S Congress|Alabama State Legislators|Alabama State Officials|Alabama State Departments and Agencies|Alabama Resources by County/City|Alabama Resources by County/City\Autauga County Alabama|Alabama Resources by County/City\Baldwin County Alabama|Alabama Resources by County/City\Barbour County Alabama|Alabama Resources by County/City\Bibb County Alabama|Alabama Resources by County/City\Blount County Alabama|Alabama Resources by County/City\Bullock County Alabama|Alabama Resources by County/City\Butler County Alabama|Alabama Resources by County/City\Calhoun County Alabama|Alabama Resources by County/City\Chambers County Alabama|Alabama Resources by County/City\Cherokee County Alabama|Alabama Resources by County/City\Chilton County Alabama|Alabama Resources by County/City\Choctaw County Alabama|Alabama Resources by County/City\Clarke County Alabama|Alabama Resources by County/City\Clay County Alabama|Alabama Resources by County/City\Cleburne County Alabama|Alabama Resources by County/City\Coffee County Alabama|Alabama Resources by County/City\Colbert County Alabama|Alabama Resources by County/City\Conecuh County Alabama|Alabama Resources by County/City\Coosa County Alabama|Alabama Resources by County/City\Covington County Alabama|Alabama Resources by County/City\Crenshaw County Alabama|Alabama Resources by County/City\Cullman County Alabama|Alabama Resources by County/City\Dale County Alabama|Alabama Resources by County/City\Dallas County Alabama|Alabama Resources by County/City\DeKalb County Alabama|Alabama Resources by County/City\Elmore County Alabama|Alabama Resources by County/City\Escambia County Alabama|Alabama Resources by County/City\Etowah County Alabama|Alabama Resources by County/City\Fayette County Alabama|Alabama Resources by County/City\Franklin County Alabama|Alabama Resources by County/City\Geneva County Alabama|Alabama Resources by County/City\Greene County Alabama|Alabama Resources by County/City\Hale County Alabama|Alabama Resources by County/City\Henry County Alabama|Alabama Resources by County/City\Houston County Alabama|Alabama Resources by County/City\Jackson County Alabama|Alabama Resources by County/City\Jefferson County Alabama|Alabama Resources by County/City\Lamar County Alabama|Alabama Resources by County/City\Lauderdale County Alabama|Alabama Resources by County/City\Lawrence County Alabama|Alabama Resources by County/City\Lee County Alabama|Alabama Resources by County/City\Limestone County Alabama|Alabama Resources by County/City\Lowndes County Alabama|Alabama Resources by County/City\Macon County Alabama|Alabama Resources by County/City\Madison County Alabama|Alabama Resources by County/City\Marengo County Alabama|Alabama Resources by County/City\Marion County Alabama|Alabama Resources by County/City\Marshall County Alabama|Alabama Resources by County/City\Mobile County Alabama|Alabama Resources by County/City\Monroe County Alabama|Alabama Resources by County/City\Montgomery County Alabama|Alabama Resources by County/City\Morgan County Alabama|Alabama Resources by County/City\Perry County Alabama|Alabama Resources by County/City\Pickens County Alabama|Alabama Resources by County/City\Pike County Alabama|Alabama Resources by County/City\Randolph County Alabama|Alabama Resources by County/City\Russell County Alabama|Alabama Resources by County/City\Shelby County Alabama|Alabama Resources by County/City\St. Clair County Alabama|Alabama Resources by County/City\Sumter County Alabama|Alabama Resources by County/City\Talladega County Alabama|Alabama Resources by County/City\Tallapoosa County Alabama|Alabama Resources by County/City\Tuscaloosa County Alabama|Alabama Resources by County/City\Walker County Alabama|Alabama Resources by County/City\Washington County Alabama|Alabama Resources by County/City\Wilcox County Alabama|Alabama Resources by County/City\Winston County


Last edit: by chipster
Back to the top
 
Posted
Rating:
#48670

Honoured member

I belived I've found it.

Hi Chris,  I believe I have found the colperate.  it appears it would be an issue with, Window EYES, my screen reader  and accessibility, and not so much OCP.  When I arrow down through the list of "Types" my screen reader is reading an entry for every line, when in reality there are blank lines, and category headers in that list, and my screen reader doesn't seem to be tracking those differences.  If I am not careful I end on on a line where there is no"Type" actually defined, and I believe that is what is corrupting my catalogues.

I've created several catalogues now, and as long as I make sure that there is an actual value selected in the "Type" list box, I haven't had any more corrupted catalogues.  To test this theory I created a simple test catalogue, and arrow down through the "Type" list, and made a selection.  Although my screen reader reported that I had a selection chosen, My wife, which is sighted said, in reality there was nothing selected at all.  When I went a head and clicked on "Save," sure enough, the Catalogue went belly up.  While I'm not a programmer, closely looking at the error message, and from what I can tell from the stack trace, that this seem to be the source of my issue.


The catalogues that ended up corrupted, I deleted from the database using PHPMyAdmin, and everything seems ok.  They no longer appear on my "Catalogues" page, and the category count seems to have drop accordingly, so I assume that was an ok move.  




Last edit: by chipster
Back to the top
 
Posted
Rating:
#48741

Honoured member

Is this a bug, or am I missing something?

I'm having a problem with the catalogue / Field / "Type / "A value chosen from a list" function.  Everytime I try to use it I get an error.  For example I created a field, we'll call fruit,  and in the "Default Value" I placed "Apples|Bananas|Oranges|Other" and in the "Type" chose "A value chosen from a list."
Now, while entering an entry the list works fine, but when you view the entry is shows,
 "Fruit
Internal error"

  Am I miss reading how this function works, or is this a bug?
Back to the top
 
Posted
Rating:
#48754
Avatar

Hi,

You'll need to cleanup manually. Are you ok to go into the ocp4_catalogues table and delete any records there for catalogues that you know to be corrupt?

There are records in various other tables but it probably won't matter if you leave them there.
– ah good, I see that already worked for you.

Hi Chris,  I believe I have found the colperate.  it appears it would be an issue with, Window EYES, my screen reader  and accessibility, and not so much OCP.  When I arrow down through the list of "Types" my screen reader is reading an entry for every line, when in reality there are blank lines, and category headers in that list, and my screen reader doesn't seem to be tracking those differences.  If I am not careful I end on on a line where there is no"Type" actually defined, and I believe that is what is corrupting my catalogues.

Ah, well done for working it out.

It is kind of a bug. The server-side is not validating the data properly. It shouldn't be relying on client-side Javascript validation to avoid corruption. We'll get this fixed.

You might want to report a bug to the Windows EYES people. They shouldn't allow you to select a "disabled" option (which the headers and spacer lines in the list are), it should just read them out.


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

chipster said

I'm having a problem with the catalogue / Field / "Type / "A value chosen from a list" function.  Everytime I try to use it I get an error.  For example I created a field, we'll call fruit,  and in the "Default Value" I placed "Apples|Bananas|Oranges|Other" and in the "Type" chose "A value chosen from a list."
Now, while entering an entry the list works fine, but when you view the entry is shows,
 "Fruit
Internal error"

  Am I miss reading how this function works, or is this a bug?

Our fault. The attached sources/catalogues.php will fix this problem.

Attachment
» Download: catalogues.php (35 Kb, 142 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
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: