- Posts: 25
- Thank you received: 0
Exported database has 124 rows of errors
- LordSatori
-
Topic Author
- Offline
Less
More
15 years 1 month ago #22531
by LordSatori
Exported database has 124 rows of errors was created by LordSatori
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.
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.
15 years 1 month ago #22540
by nicolas
Replied by nicolas on topic Re: Exported database has 124 rows of errors
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.
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.
- LordSatori
-
Topic Author
- Offline
Less
More
- Posts: 25
- Thank you received: 0
15 years 1 month ago #22685
by LordSatori
Replied by LordSatori on topic Re: Exported database has 124 rows of errors
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?
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.
15 years 1 month ago #22686
by nicolas
Replied by nicolas on topic Re: Exported database has 124 rows of errors
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.
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.285 seconds