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.


Importing Product Database

Login / Search

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

Honoured member

So, I have a product database exported in excell by another shopping cart system. I have gone through and matched the fields of the feilds that are matchable, AND put them in the correct order (double checked) of the way OCPortal lists them.

I would like confirmation that the words can have spaces, and arent supposed to have underscore between the words. It says to make them human readable, so I am assuming spaces are OK.

Anyway, I also added to the end, 2 new fields so that I can use them as search terms. I added them to the catalog set up, and the CSV file.

It tosses this message when I try to upload it:

An error has occurred

PHP NOTICE [8] Undefined offset: 10 in /home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php on line 628 (version: 6.0 RC2, PHP version: 5.2.9, URL: /cms/cms_catalogues/_import.htm?old_type=import&catalogue_name=products)

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'/home1/aipman3/public_html/sources/failure.php'
Line'658'
Function'get_html_trace'
Args 

File'/home1/aipman3/public_html/sources/global2.php'
Line'921'
Function'_fatal_exit'
Args'PHP NOTICE [8] Undefined offset: 10 in /home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php on line 628'


File'/home1/aipman3/public_html/sources/failure.php'
Line'209'
Function'fatal_exit'
Args'PHP NOTICE [8] Undefined offset: 10 in /home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php on line 628'


File'/home1/aipman3/public_html/sources/global2.php'
Line'795'
Function'_ocportal_error_handler'
Args'notice'

8

'Undefined offset: 10'

'/home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php'

628


File'/home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php'
Line'628'
Function'ocportal_error_handler'
Args...

File'/home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php'
Line'564'
Function'import_csv_lines'
Class'Module_cms_catalogues'
ObjectModule_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', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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' => '', '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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type'->'
Args...array ( 'products' => 14, 'Currently Available' => 6, 'Products' => 13, )

array ( 'Product title' => 0, 'Product code' => 1, 'Net price' => 2, 'Stock level' => 3, 'Stock level warn-threshold' => 4, 'Stock maintained' => 5, 'Product tax rate' => 6, 'Product image' => 7, 'Product weight' => 8, 'Product description' => 9, 'Sort publisher' => 10, 'Sort type' => 11, )

NULL


File'/home1/aipman3/public_html/cms/pages/modules/cms_catalogues.php'
Line'89'
Function'_import_catalogue'
Class'Module_cms_catalogues'
ObjectModule_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', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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' => '', '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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type'->'
Args 

File'/home1/aipman3/public_html/sources/aed_module.php'
Line'188'
Function'run_start'
Class'Module_cms_catalogues'
ObjectModule_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', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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' => '', '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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type'->'
Args'_import'


File'/home1/aipman3/public_html/sources/zones.php'
Line'383'
Function'run'
Class'standard_aed_module'
ObjectModule_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', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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' => '', '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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type'->'
Args 

File'/home1/aipman3/public_html/sources/site.php'
Line'981'
Function'load_module_page'
Args'cms/pages/modules/cms_catalogues.php'

'cms_catalogues'


File'/home1/aipman3/public_html/sources/site.php'
Line'773'
Function'request_page'
Args'cms_catalogues'

true


File'/home1/aipman3/public_html/cms/index.php'
Line'50'
Function'do_site'
Args 

Parameters

MAX_FILE_SIZE
8388608
label_for__file_novalidate
Upload
require__file_novalidate
1
hidFileID_file_novalidate
7
Back to the top
 
Posted
Rating:
#66992
Avatar

We got an automated error email about this too, and I think it is because the CSV export you have leaves out empty right-most cells. The attached file should hopefully fix it.

Attachment
cms/pages/modules/cms_catalogues.php
» Download: cms_catalogues.php (61 Kb, 139 downloads so far)


ocPortal only uses SKU's for output, nothing internal, so they can be whatever you want.


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

Honoured member

That got the import to load successfully, not finding the products though, will do some digging find out where they went.
Back to the top
 
Posted
Rating:
#66997
Avatar

Honoured member

Well, I now have 8 catagories called Products, but I cannot find any of the products and the products catagories do not show when looking for products to edit, just the catagory I named Currently Available shows in that view, and, it is still empty. Going into the database for a look see now......
Back to the top
 
Posted
Rating:
#66999
Avatar

Honoured member

Catalogue_entries has my 4000+ entries, Catalogue_efv_short seems to have bits and peices of the data in it, however, they are from different actual columns in the CSV file, so doesnt seem to have loaded right.

Not sure where a lot of the entries data is stored cause, decription fields, prices, weights, dont see them anywhere, nor my added sort fields one of which is all the publisher names.

Anyway, let me know everything to erase to wipe ALL catalog entries (cause this is a clean, unused database, only hooked to the rest of my websites through the forum part) and then, let me know if I helped identify anything else wrong or anything else I need to look for elsewhere so we can make sure this works for anyone that needs it.
Back to the top
 
Posted
Rating:
#67000
Avatar

You shouldn't try too hard to understand, or manipulate, ocPortal catalogue database structure. It's highly abstract, and each entry consists of probably a dozen rows across different tables.

Could you send a copy of a CSV that doesn't work to chris@ocportal.com and I'll try it when I can.

Thanks
Chris


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

Honoured member

Sent, but I would like to clean out the damaged products, so they can be added correctly when I can....
Back to the top
 
Posted
Rating:
#67006
Avatar

Honoured member

Ok, if I try to delete the empty ghost Product catagories, I get this:

An error has occurred

Unfortunately a query has failed [UPDATE ocp6_catalogue_entries SET cc_id=NULL WHERE (cc_id=13) ] [Column 'cc_id' cannot be null] (version: 6.0 RC2, PHP version: 5.2.9, URL: /cms/cms_catalogues/__ec/13.htm?catalogue_name=products&uplo
ading=1)

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    '/home1/aipman3/public_html/sources/failure.php'
Line    '658'
Function    'get_html_trace'
Args   

File    '/home1/aipman3/public_html/sources/global2.php'
Line    '921'
Function    '_fatal_exit'
Args   
object


File    '/home1/aipman3/public_html/sources/database/mysql.php'
Line    '240'
Function    'fatal_exit'
Args   
object


File    '/home1/aipman3/public_html/sources/database.php'
Line    '1,063'
Function    'db_query'
Class    'Database_Static_mysql'
Object    Database_Static_mysql::__set_state(array( ))
Type    '->'
Args   
'UPDATE ocp6_catalogue_entries SET cc_id=NULL WHERE (cc_id=13) '

array ( 0 => NULL, 1 => 'aipman3_DistroX', )

NULL

NULL

false

false

false

false


File    '/home1/aipman3/public_html/sources/database.php'
Line    '750'
Function    '_query'
Class    'database_driver'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp6_', 'connection_read' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'connection_write' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'text_lookup_original_cache' => array ( 274 => 'Products', ), 'text_lookup_cache' => array ( 274 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type    '->'
Args   
'UPDATE ocp6_catalogue_entries SET cc_id=NULL WHERE (cc_id=13) '

NULL

NULL

false

false


File    '/home1/aipman3/public_html/sources/catalogues2.php'
Line    '575'
Function    'query_update'
Class    'database_driver'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp6_', 'connection_read' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'connection_write' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'text_lookup_original_cache' => array ( 274 => 'Products', ), 'text_lookup_cache' => array ( 274 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type    '->'
Args   
'catalogue_entries'

array ( 'cc_id' => NULL, )

array ( 'cc_id' => 13, )


File    '/home1/aipman3/public_html/cms/pages/modules/cms_catalogues
.php'
Line    '841'
Function    'actual_delete_catalogue_category'
Args   
13


File    '/home1/aipman3/public_html/sources/aed_module.php'
Line    '1,013'
Function    'delete_actualisation'
Class    'Module_cms_catalogues_cat'
Object    Module_cms_catalogues_cat::__set_state(array( 'lang_type' => 'CATALOGUE_CATEGORY', 'select_name' => 'NAME', 'permissions_require' => 'cat_mid', 'permission_module' => 'catalogues_category', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type    '->'
Args   
'13'


File    '/home1/aipman3/public_html/sources/aed_module.php'
Line    '205'
Function    '__ed'
Class    'standard_aed_module'
Object    Module_cms_catalogues_cat::__set_state(array( 'lang_type' => 'CATALOGUE_CATEGORY', 'select_name' => 'NAME', 'permissions_require' => 'cat_mid', 'permission_module' => 'catalogues_category', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type    '->'
Args   

File    '/home1/aipman3/public_html/sources/zones.php'
Line    '383'
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', 'permissions_cat_require' => 'catalogues_catalogue', 'permissions_cat_name' => 'catalogue_name', '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_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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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' => '', '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' => 'd', '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, '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, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, 'table' => NULL, ))
Type    '->'
Args   

File    '/home1/aipman3/public_html/sources/site.php'
Line    '981'
Function    'load_module_page'
Args   
'cms/pages/modules/cms_catalogues.php'

'cms_catalogues'


File    '/home1/aipman3/public_html/sources/site.php'
Line    '773'
Function    'request_page'
Args   
'cms_catalogues'

true


File    '/home1/aipman3/public_html/cms/index.php'
Line    '50'
Function    'do_site'
Args   

Parameters

catalogue_name   
products
MAX_FILE_SIZE   
8388608
label_for__title   
Title
title   
Products
require__title   
1
comcode__description   
1
label_for__description   
Description
description   
Products
description_parsed   
Products
label_for__notes   
Notes
notes   
274
pre_f_notes   
1
require__notes   
0
label_for__rep_image   
Representative image
require__rep_image   
0
hidFileID_rep_image   
-1
label_for__move_target   
Expiry move-target
move_target   
-1
require__move_target   
1
label_for__move_days_lower   
Expiry-time
require__move_days_lower   
1
label_for__move_days_higher   
Expiry-time (higher)
require__move_days_higher   
1
access_1_presets   
-1
access_28_presets   
-1
access_3_presets   
-1
access_4_presets   
-1
access_9_presets   
-1
access_10_presets   
-1
access_11_presets   
-1
access_12_presets   
-1
access_13_presets   
-1
access_14_presets   
-1
access_15_presets   
-1
access_16_presets   
-1
access_18_presets   
-1
access_20_presets   
-1
access_21_presets   
-1
access_22_presets   
-1
access_23_presets   
-1
access_24_presets   
-1
access_25_presets   
-1
access_26_presets   
-1
access_27_presets   
-1
label_for__meta_keywords   
Keywords
meta_keywords   
require__meta_keywords   
0
label_for__meta_description   
Concise description
meta_description   
require__meta_description   
0
label_for__delete   
Delete
delete   
1
tick_on_form__delete   
0
require__delete   
0
http_referer   
http://www.dimestoredistro.com/cms/cms_catalogues/_ec/13.htm?zone=cms&wide_high=1&opens_below=1&catalogue_name=products
description__is_wysiwyg   
1
Back to the top
 
Posted
Rating:
#67089
Avatar

Hi,

I got the CSV thanks. Regarding this, it is a bug, but the bug is that it allowed you to try to delete a root category in a tree-based catalogue, which should not be possible. However I think a workaround would be to edit the catalogue to be non-tree, delete all the categories, then edit it back to be tree again.


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

Honoured member

I will try to take out of tree mode. They are not showing as related to each other in list, they are more like…each a root. But I will see what I can do to get rid of the ghosts and report for anyone that ends up with such.

and hope you can make a corrected CSV out of the one I sent. Or correct the uploader, or whatever will make this work.
Back to the top
 
Posted
Rating:
#67092
Avatar

Yes, I found the cause of the double-root thing, which is why also they're not showing. I'm just running some final tests of my fix 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:
#67093
Avatar

Fix attached.

Attachment
cms/pages/modules/cms_catalogues.php
» Download: cms_catalogues.php (62 Kb, 105 downloads so far)


This fixes:
  • Creation of new category, when it should just have defaulted to the root products category
  • Messing up of tree catalogues by creating any new category (as specified by a 'CATEGORY' field) as a root category (for a tree catalogue it will now put these as sub-categories of the root catalogue)
  • 'Noimage' now results as a blank picture, rather than a broken link
  • Filenames for picture fields are now altered to URLs under 'uploads/catalogues'

I also have identified and fixed 2 ocPortal bugs/usability-issues for the next release (not included here):
  • The prices imported without trailing zeros (e.g. 6.3 instead of 6.30). Now ocPortal's templates will clean that up.
  • The root products category had {1} in the name.


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

Honoured member

Bringing out of tree mode magically brought all the products into life, split into the many catagories all named Products. Deleteing ONE of those, made then all to be names N/A…but it is letting me delete them.

I will wait till you have a bit of advice on the CSV file before I upload it again.
Back to the top
 
Posted
Rating:
#67096
Avatar

Honoured member

hey look what was posted while I was writing! lol

will try it out and report
Back to the top
 
Posted
Rating:
#67111
Avatar

Honoured member

Ok, here is my report after much testing.

I can delete ALL categories. I am pretty sure this does not erase all the products that were in those categories, and theres no easy way to move them.

It says successful when you try to upload products into the system when no categories are created. And, it does not seem to put those products anywhere.

if you then add one category named the default products…then that category seems to have SOME of the products in it.

If you try to upload the rest of the products with that as the only category that exists…there is no change in what is in that category.

So, hope this helps on the uploading bug hunting, and I'm glad to help, I'm in no rush to reopen my store, and I can do whatever needed to test in a multisite setup as well.
Back to the top
 
Posted
Rating:
#67112
Avatar

Yeah, sorry for the haphazard instructions, I now realise deleting categories isn't going to work so well. If you don't have any catalogues you need to keep you can reinstall the catalogues module.
Look in Admin Zone > Structure > Addons > Module Management (at bottom) > Site zone.


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

Honoured member

well, I looked, Site zone did not exist, perhaps cause I have it so welcome zone is same.

but that had nothing for catalogue management.

I saw the catalogue in the addons though, so though uninstalling that, then reinstalling it, would do the trick.

uninstalling sounded great…till I went to reinstall and it gave this error:

Home > Admin Zone > Structure > Install / Uninstall selected addons
An error has occurred

Unfortunately a query has failed [SELECT c_name,c_title,c_description,c_ecommerce FROM ocp6_catalogues LIMIT 10] [Table 'aipman3_DistroX.ocp6_catalogues' doesn't exist] (version: 6.0 RC2, PHP version: 5.2.9, URL: /adminzone/admin_addons/_multi_action.htm)

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    '/home1/aipman3/public_html/sources/failure.php'
Line    '658'
Function    'get_html_trace'
Args   

File    '/home1/aipman3/public_html/sources/global2.php'
Line    '921'
Function    '_fatal_exit'
Args   
object


File    '/home1/aipman3/public_html/sources/database/mysql.php'
Line    '240'
Function    'fatal_exit'
Args   
object


File    '/home1/aipman3/public_html/sources/database.php'
Line    '1,063'
Function    'db_query'
Class    'Database_Static_mysql'
Object    Database_Static_mysql::__set_state(array( ))
Type    '->'
Args   
'SELECT c_name,c_title,c_description,c_ecommerce FROM ocp6_catalogues '

array ( 0 => NULL, 1 => 'aipman3_DistroX', )

10

NULL

false

false

false

false


File    '/home1/aipman3/public_html/sources/database.php'
Line    '913'
Function    '_query'
Class    'database_driver'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp6_', 'connection_read' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'connection_write' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'text_lookup_original_cache' => array ( 107628 => '', 107627 => '

', 107630 => '', ), 'text_lookup_cache' => array ( 107628 => '', 107627 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:34:\"do_runtime_4d
6ef1c03625a2.01828582\";i:1;a:3:{i:0;s:17:\"param=_management
\";i:1;s:13:\"type=dropdown\";i:2;s:22:\"block=side_stored_me
nu\";}i:2;i:0;i:3;s:5:\"BLOCK\";i:4;N;}}i:1;a:1:{i:0;a:4:{i:0
;a:0:{}i:1;i:0;i:2;s:5:\"BLOCK\";i:3;a:3:{i:0;s:17:\"param=_m
anagement\";i:1;s:13:\"type=dropdown\";i:2;s:22:\"block=side_
stored_menu\";}}}i:2;s:7:\"(mixed)\";i:3;s:10:\":container\";
i:4;N;i:5;s:138:\"\$TPL_FUNCS[\'do_runtime_4d6ef1c03625a2.018
28582\']=\"echo evaluate_conventional_variable(\\\$current_lang,array(),0,\\
\"BLOCK\\\",\\\$parameters);\";\n\";}"); ', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type    '->'
Args   
'SELECT c_name,c_title,c_description,c_ecommerce FROM ocp6_catalogues '

10

NULL

false

false

array ( )

''


File    '/home1/aipman3/public_html/sources/menus.php(160) : eval()\'d code'
Line    '33'
Function    'query_select'
Class    'database_driver'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp6_', 'connection_read' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'connection_write' => array ( 0 => NULL, 1 => 'aipman3_DistroX', ), 'text_lookup_original_cache' => array ( 107628 => '', 107627 => '

', 107630 => '', ), 'text_lookup_cache' => array ( 107628 => '', 107627 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:34:\"do_runtime_4d
6ef1c03625a2.01828582\";i:1;a:3:{i:0;s:17:\"param=_management
\";i:1;s:13:\"type=dropdown\";i:2;s:22:\"block=side_stored_me
nu\";}i:2;i:0;i:3;s:5:\"BLOCK\";i:4;N;}}i:1;a:1:{i:0;a:4:{i:0
;a:0:{}i:1;i:0;i:2;s:5:\"BLOCK\";i:3;a:3:{i:0;s:17:\"param=_m
anagement\";i:1;s:13:\"type=dropdown\";i:2;s:22:\"block=side_
stored_menu\";}}}i:2;s:7:\"(mixed)\";i:3;s:10:\":container\";
i:4;N;i:5;s:138:\"\$TPL_FUNCS[\'do_runtime_4d6ef1c03625a2.018
28582\']=\"echo evaluate_conventional_variable(\\\$current_lang,array(),0,\\
\"BLOCK\\\",\\\$parameters);\";\n\";}"); ', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type    '->'
Args   
'catalogues'

array ( 0 => 'c_name', 1 => 'c_title', 2 => 'c_description', 3 => 'c_ecommerce', )

NULL

''

10


File    '/home1/aipman3/public_html/sources/menus.php(160) : eval()\'d code'
Line    '47'
Function    'runcatalogues72378_90'
Args   
true


File    '/home1/aipman3/public_html/sources/menus.php'
Line    '160'
Function    'eval'

File    '/home1/aipman3/public_html/sources/menus.php'
Line    '294'
Function    'build_management_menu'
Args   

File    '/home1/aipman3/public_html/sources/blocks/side_stored_menu.
php'
Line    '86'
Function    'build_stored_menu'
Args   
'dropdown'

'_management'

false


File    '/home1/aipman3/public_html/sources/zones.php'
Line    '640'
Function    'run'
Class    'Block_side_stored_menu'
Object    Block_side_stored_menu::__set_state(array( ))
Type    '->'
Args   
array ( 'param' => '_management', 'type' => 'dropdown', 'block' => 'side_stored_menu', )


File    '/home1/aipman3/public_html/sources/tempcode.php'
Line    '690'
Function    'do_block'
Args   
'side_stored_menu'

array ( 'param' => '_management', 'type' => 'dropdown', 'block' => 'side_stored_menu', )


File    '/home1/aipman3/public_html/sources/tempcode.php'
Line    '962'
Function    'handle_symbol_preprocessing'
Args   
array ( 0 => array ( ), 1 => 0, 2 => 'BLOCK', 3 => array ( 0 => 'param=_management', 1 => 'type=dropdown', 2 => 'block=side_stored_menu', ), )

NULL


File    '/home1/aipman3/public_html/sources/tempcode.php'
Line    '775'
Function    'handle_symbol_preprocessing'
Class    'ocp_tempcode'
Object    object
Type    '->'
Args   

File    '/home1/aipman3/public_html/sources/tempcode.php'
Line    '962'
Function    'handle_symbol_preprocessing'
Args    …
NULL


File    '/home1/aipman3/public_html/sources/site.php'
Line    '820'
Function    'handle_symbol_preprocessing'
Class    'ocp_tempcode'
Object    object
Type    '->'
Args   

File    '/home1/aipman3/public_html/adminzone/index.php'
Line    '51'
Function    'do_site'
Args   

Parameters

install_catalogues   
catalogues.tar
Back to the top
 
Posted
Rating:
#67123
Avatar

Honoured member

There is a good chance, it might be best to erase this whole site and database, and start over with the fixed upload file, in the morning…….good thing I'm in no hurry on this store, lol.

Let this be a warning to anyone who strays from Chris' words, not best thing to do.

I can get back into the module installed and such list, though many admin pages are dead now looking for the catalogue database bits

it SAYS the catalogue module WAS reinstalled, but, it obviously is not done right.

Gonna sleep on this, see what the new day brings.
Back to the top
 
Posted
Rating:
#67149
Avatar

Hi,

Ok, not to worry too much. I can see what's happened here, it's easy to fix.

Temporarily delete sources/hooks/systems/do_next_menus/catalogues.php.

That should stop the errors enough for you to reinstall catalogues.

I think it probably asked for abstract file manager details and you selected not to use them, and it failed to delete some catalogue files after it had removed the addon's DB stuff. That caused an inconsistant state.
I'm altering the code for the next release to not die so badly in that state (the code that is failing is in the admin menus, looking at what catalogues to put on the Content menu).

Regarding my advice, I forgot about our new merged zones feature. It would have been the welcome zone for you. But I tested this and got a stack trace due to a bug in it, lol. I guess you did too. That will be fixed.


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

Honoured member

Well, I went ahead and did the complete reinstall, because, I wanted to be sure all bad stuff was gone. So I did, then uploaded the new catalogue uploader file, and uploaded the CSV. It said successful.

However.

It loaded only as many products as I had on last nights efforts. I know cause I wrote down the start and end products. They are the same. There are half or so still missing. there are over 2000 products, and there arent that many in what I am getting.

EVERYTHING was default, I changed nothing before the test upload, but to fix the uploading file with what you sent.

so that's where I'm at.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand