import categories

Replied to your email on the same day, Did you receive it?

Hello,
Apologies for the delay, You'll get an update by tomorrow evening.

One week is gone.
Didn't find something?

Ok Daniel,
will send info for a testserver to you.

Please not only do some "magic", I want to understand how it works and what the problem is.
Thanks.

The problem arises just because the relation between category and subcategory ( the parentid column ) is not maintained correctly. Please share your backend & FTP login credentials via Contact us form along with the file you are trying to import, We'll look into it.

same problem on categories import: exception 'UnexpectedValueException' with message 'JTableCategory::_getNode(6, ) failed.' in ...

was there a solution to solve this?

Hello Carlos,
Please share your backend & FTP login credentials via Contact us form, We'll look into it.

I get this error:

exception 'UnexpectedValueException' with message 'JTableCategory::_getNode(6, ) failed.' in /home/nuestrop/public_html/web/libraries/joomla/table/nested.php:1532 Stack trace: #0 /home/nuestrop/public_html/web/libraries/joomla/table/nested.php(314): JTableNested->_getNode(6) #1 /home/nuestrop/public_html/web/libraries/joomla/table/nested.php(830): JTableNested->moveByReference('1', 'last-child', 6) #2 /home/nuestrop/public_html/web/libraries/legacy/table/category.php(238): JTableNested->store(false) #3 /home/nuestrop/public_html/web/plugins/vdata/custom/custom.php(3397): JTableCategory->store() #4 /home/nuestrop/public_html/web/plugins/vdata/custom/custom.php(2641): plgvdataCustom->batch_import_remote() #5 [internal function]: plgvdataCustom->batchImport() #6 /home/nuestrop/public_html/web/libraries/joomla/event/event.php(69): call_user_func_array(Array, Array) #7 /home/nuestrop/public_html/web/libraries/joomla/event/dispatcher.php(160): JEvent->update(Array) #8 /home/nuestrop/public_html/web/administrator/components/com_vdata/controllers/import.php(133): JEventDispatcher->trigger('batchImport') #9 /home/nuestrop/public_html/web/libraries/legacy/controller/legacy.php(728): VdataControllerImport->import_start() #10 /home/nuestrop/public_html/web/administrator/components/com_vdata/vdata.php(68): JControllerLegacy->execute('import_start') #11 /home/nuestrop/public_html/web/libraries/cms/component/helper.php(405): require_once('/home/nuestrop/...') #12 /home/nuestrop/public_html/web/libraries/cms/component/helper.php(380): JComponentHelper::executeComponent('/home/nuestrop/...') #13 /home/nuestrop/public_html/web/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent('com_vdata') #14 /home/nuestrop/public_html/web/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #15 /home/nuestrop/public_html/web/libraries/cms/application/cms.php(257): JApplicationAdministrator->doExecute() #16 /home/nuestrop/public_html/web/administrator/index.php(51): JApplicationCms->execute() #17 {main}

Import Failed

Hello,
Here is the correct message:

parent_id [Select Table] ---- #__categories
Column1 [Select Field] ---- id
Column2 [Select Field] ---- parent_id
extension [Select Field] ---- extension
title [Select Field] ---- title

created_user_id [Select Table] ---- #__users
Column1 [Select Field] ---- id
Column2 [Select Field] ---- created_user_id
email [Select Field] ---- email

Hi,

In this step:

created_user_id [Select Table] ---- #__users
Column1 [Select Field] ---- created_user_id (This option is not available, only is available id, name, username, email, password, usertype, block, sendEmail, registerDate, lasvisitdate, activation, params, lastResetTime, resetCount)
Column2 [Select Field] ---- id (Here is available id and created_user_id)
email [Select Field] ---- email

Can you check please?

Hello,
Here It is as per your screenshot:

parent_id [Select Table] ---- #__categories
Column1 [Select Field] ---- parent_id
Column2 [Select Field] ---- id
extension [Select Field] ---- extension
title [Select Field] ---- title

created_user_id [Select Table] ---- #__users
Column1 [Select Field] ---- created_user_id
Column2 [Select Field] ---- id
email [Select Field] ---- email

Please tell me what tables and fields need to select for these items:

parent_id [Select Table]
Column1 [Select Field]
Column2 [Select Field]
extension [Select Field]
title [Select Field]

created_user_id [Select Table]
Column1 [Select Field]
Column2 [Select Field]
email [Select Field]