Product Export Problems

-- HikaShop version -- : 1.5.7
-- Joomla version -- : 1.7

Hi,

I just tried to do a full export of my products.

It exported a CSV file which is semi-colon delimited.

I imported that into Excel on my Mac.

However the first line should contain the column headers and all looks good upto a point where suddenly product names start appearing.

Here is the first line in the file:

"product_id";"product_parent_id";"product_name";"product_description";"product_quantity";"product_code";"product_published";"product_hit";"product_created";"product_sale_start";"product_sale_end";"product_delay_id";"product_tax_id";"product_type";"product_vendor_id";"product_manufacturer_id";"product_url";"product_weight";"product_keywords";"product_weight_unit";"product_modified";"product_meta_description";"product_dimension_unit";"product_width";"product_length";"product_height";"product_max_per_order";"product_access";"product_group_after_purchase";"product_min_per_order";"product_contact";"product_last_seen_date";"product_sales";"product_waitlist";"product_layout";"product_average_score";"product_total_vote";"stock_shelf";"parent_category";"categories_image";"categories";"price_value";"price_currency_id";"price_min_quantity";"price_access";"files";"images";"related";"options";"Colour";"Weight";"Size";"Range";"Strength";"Length";"Waggler Floats - Unloaded";"Waggler Floats - Loaded";"Sizes";"Stonfo bait holders";"Wychavon carp rod";"Okuma Razor";"Specialist Freespin";"Big Pit Freespin";"Okuma Carbonite";"Okuma Electron";"Rapide RD";"Okuma Compressa RD";"Okuma Octana";"WB Clarke XTS Pellet";"Carbon Pellet Waggler";"Fox FX Spin";"XTS poles";"Carborex carbon pushover pole";"Mini Fat Plugbait";"Shallow running lure";"Deep Diving Lure";"Fat Plugbait";"Hand Sanitizer";"B/S";"Colours";"Gardner Fleece";"Gardner Sweat Jacket";"Gardner Beenie";"Covert Tackle";"Covert Arrow Beads";"Covert swivel kwik lok";"Covert maggot clips";"Cover Rig rings";"Covert Rolling & Mini Swivels";"colour";"weight";"Hook Type";"Hook Size";"Hook Sizes";"Shirt sizes";"Mirage size / B/S";"Line B/S";"Diameter";"B/S & length";"B/S & Colour";"Bait Drills";"Hair Needles";"Gate Latch Needle";"Braided Hair Needle";"Stringer needles";"Size ";"Slinga Catapults & accessories";"Bait";"Colour/Flavour";"flavour / Size";"Type";"Size/Colour";"Type / Flavour";"Flavours";"Colou / Flavour";"Colour / Size";"Size/colour";"Colour / type";"Flavour";"Size / Qty";"size/flavour";"Flavour/colour";"Flavour / colour";"Flavour / weight";"Pack size";"Length/kit/ extension";"Pole/kit/extension";"Section No";"Chair & Accessories";"Test Curve";"Model";"Set or individuals";"Gardner Casting Glove";"Banshee 12'";"Reel & Guard";"Middy PTFE Bushes";"Middy Pole Connectors";"Middy Shock Core Internal Bushes";"Middy Shock Core winder bung";"Middy Low-Viz Flourocrystal";"LB's B/S";"model";"Size & Weight";"Jungle";"Crave";"Winter Almond"

From that point on none of the data loads into the correct columns.

What am I doing wrong? Why does the first line not just show the proper hikashop product list?

Thanks,

Tony

Hi,

Where do you have tried to export the products ? from the products listing ?
If it is, how many products do you try to export at the same time ? Thanks to try to export thanks to the mass actions.

Yes I am doing from the Products page.

All sub elements selected.

Trying to export all products but just tried it with a single product with the same result.

There are about 600 products.

Even stranger is that when I change the filter options an export download is triggered without me pressing the export button. (EDIT: If I go out and then back into the page the filter options work again)

This used to work.

Tony

It's not that. The semi colon delimiters are recognised.

It seems to be including lots of strange fields in the header line.

I think the problem is in the export.

Ah that's normal? Characteristics maybe. No custom fields.

The first four products look OK but then it goes wrong.

"704","0","Pkangling Rig Kit","<h3>These kits are fantastic value. Enough to make 6 UK rigs or 3 continental rigs with spare clips, cones and swivels. available in 6 colours.</h3>
<h4><strong>Kit contains</strong></h4>
<ul>
<li><strong>1 x 2 mtr length of rig tube.</strong></li>
<li><strong>10 lead clips.</strong></li>
<li><strong>10 tail cones.</strong></li>
<li><strong>10 swivels.</strong></li>

Product 704 is where it goes wrong but later corrects itself but goes wrong again a bit later. So the columns have data in them that should relate to a different column.

All very strange as the text delimiter (") is set correctly on import.

Hello, I am experiencing the same issue.
It seems to do with HTML code that contains "" - is there a solution?

Any help appreciated!

*** UPDATE ****

I see a difference in the data between the Export Button on the Products page vs Exporting from Mass Actions.

When exporting data from Product screen the HTML code can break the CSV import to XL
When exporting data from MASS ACTIONS - the data can be opened in XL without issue.

- Tony