Exported database has 124 rows of errors

  • Posts: 25
  • Thank you received: 0
11 years 1 week ago #22531

Joomla 1.7.0
Hikashop 1.5.3

Added a tax category and figured be quicker to export my Hika product db and put the data in there then import it then go though item by item.

Exported the database and inserted in the first 124 rows is the following:
<b>Notice</b>: Undefined property: stdClass::$category_ordering in <b>/home/content/86/7988486/html/ts16/administrator/components/com_hikashop/classes/product.php</b> on line <b>254</b><br />

the normal database starts at row 125 and only about half of my products are in the table.

Please Log in or Create an account to join the conversation.

  • Posts: 76114
  • Thank you received: 11912
  • MODERATOR
11 years 1 week ago #22540

Exporting/importing is not as easy as that yet as there are things that are not exported by the system. For example, the images of categories are not exported.
You should export and just import a CSV with two columns:
product_tax_id and product_code
That way, the system will just update the tax_id and not touch everything else which is already working.

That line 254 of that file should be:
$all_products[$category->product_id]->categories_ordering[]=$category->ordering;
instead of:
$all_products[$category->product_id]->categories_ordering[]=$category->category_ordering;
We'll change that on our end.

Please Log in or Create an account to join the conversation.

  • Posts: 25
  • Thank you received: 0
11 years 1 week ago #22685

Up till installing the 08-02-2011 HS build I've never had a problem exporting the table using the export button/icon on the product back end page.

Is there a way to change the parameters of that button to only export certain columns?

Please Log in or Create an account to join the conversation.

  • Posts: 76114
  • Thank you received: 11912
  • MODERATOR
11 years 1 week ago #22686

You can edit the file export of the view product via the menu Display->Views but the modification is not so easy to do as a lot of things are dynamic like the characteristics, the custom fields, etc.
The easiest is to just remove the columns you don't need after opening the CSV in excel. That can be done really easily compared to changing the code in the view file.

Please Log in or Create an account to join the conversation.

Time to create page: 0.060 seconds
Powered by Kunena Forum