Categories
View Replies (14)

Resolved No custom fields availible for export

  1. Lumiga
    Lumiga
  2. RO CSVI
  3. Thursday, 15 September 2016
  4.  Subscribe via email
Hi supportteam,

Ik hope you can help me.

When I follow these steps: https://csvimproved.com/support/tutorials/240-hikashop/1412-hikashop-custom-fields#export

I can't find my customfields. See my custom fields attached:

The only fields I can find are this:
allow
attribute
category_path
cols
combine
custom
errormessage
field_access
field_backend
field_backend_listing
field_categories
field_core
field_default
field_delete
field_display
field_frontcomp
field_id
field_item_backend_cart_details
field_item_checkout
field_item_edit_product_order
field_item_invoice
field_item_order
field_item_order_admin_notification
field_item_order_creation_notification
field_item_order_form
field_item_order_notification
field_item_order_status_notification
field_item_payment_notification
field_item_product_cart
field_item_product_listing
field_item_product_show
field_item_shipping_invoice
field_item_show_cart
field_namekey
field_options
field_ordering
field_order_admin_notification
field_order_checkout
field_order_creation_notification
field_order_edit_fields
field_order_form
field_order_invoice
field_order_listing
field_order_notification
field_order_payment_notification
field_order_shipping_invoice
field_order_show
field_order_status_notification
field_products
field_product_backend_cart_details
field_product_compare
field_product_form
field_product_frontend_cart_details
field_product_frontend_listing
field_product_invoice
field_product_listing
field_product_order_admin_notification
field_product_order_creation_notification
field_product_order_form
field_product_order_notification
field_product_order_status_notification
field_product_payment_notification
field_product_shipping_invoice
field_product_show
field_published
field_realname
field_required
field_table
field_type
field_value
field_with_sub_categories
filtering
format
limit_to_parent
maxlength
parent_value
placeholder
pleaseselect
product_code
product_id
product_value
readonly
regex
rows
size
skip
translatable
usergroup_name
zone_type
0
Responses (14)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you try to update your available fields and see if it helps? If not, can you send me your site administrator login details and database access details to check?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Lumiga
Lumiga
Accepted Answer Pending Moderation
Update didn't helped.

So how can I send you the admin login on a save way?
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You can send the details as an email to tharuna@csvimproved.com or can even send it as a private message.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for sending your site details. That really helped, the SQL error you were getting in product export is because of the field batch, if i add all other custom fields except batch to your product export template, it works.

So this should be the case, when adding custom fields, HikaShop alters the product table and adds a new column with the same custom field name to product table. I am thinking that once you have deleted the custom field batch, HikaShop has removed the custom field leaving behind the column in product table and that is what is causing the issue.

Since you have these custom fields in product table, i think you can use product import/export for your custom fields. Kindly ignore my previous post about using custom fields import/export routine. Let me know if you need any more help here.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Lumiga
Lumiga
Accepted Answer Pending Moderation
Hi Tharuna,

Sorry, but I don't understand your explanation. :(

In this issue I can't find custom fields to select for my export.

And if you look at my SQL export, there is now column batch inside.
Attachments (1)
msw73_hikashop_product-2.zip
  1. more than a month ago
  2. RO CSVI
  3. # 5
Lumiga
Lumiga
Accepted Answer Pending Moderation
Oké sorry, I think I understand you.

So I don't have to use the custom export methode: http://csvimproved.com/support/tutorials/240-hikashop/1412-hikashop-custom-fields#export
like you told me to use because custom field must be separated exported.
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So I don't have to use the custom export methode: http://csvimproved.com/support/tutorials/240-hikashop/1412-hikashop-custom-fields#export
like you told me to use because custom field must be separated exported.

Yes, i have added your custom fields except field batch to your "All product fields export from Hikashop" template and it works now. You can now directly use product import/export routine and ignore my idea of using custom fields import/export as linked in the document. Hope it is clear now.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Lumiga
Lumiga
Accepted Answer Pending Moderation
Hi Tharuna,

Thanks, the only thing I like to know is how can I delete this batch column?
If I look to the database (see attachement) I can't find a column in to the product table.

Do you know where CSVI looks for this coumn?

Kind regards,
Lumiga
Attachments (1)
msw73_hikashop_product-3.zip
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lumiga,

Do you know where CSVI looks for this coumn?

I looked into the SQL dump file you sent and there is no column called batch in it but at the same time whenever you do update to your available fields, CSVI clears all the current available fields and does a fresh insert so if the batch column is not in the product table, CSVI wont make any inserts for this. There is some trace of this field in your database. I wont be able to tell more unless i access your database.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Lumiga
Lumiga
Accepted Answer Pending Moderation
Hi Tharuna,

I have send you the database admin login. :)
Hope you can find something.

Kind regards,
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for sending the details. I had a look at your database and there is no reason i could say why the field batch has been seen. i tried removing this field from CSVI available fields table but updating available fields is getting this field back. This is not the case when i delete an HikaShop custom field from my test site and update available fields. The only other way i could think of is that the batch field has been added to the file administrator/components/com_csvi/addon/com_hikashop/install/availablefields.sql.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Lumiga
Lumiga
Accepted Answer Pending Moderation
Hi Tharuna,

I have checked the file availablefields.sql but there is no batch found in this file.
See attachment.
So you don't know where CSVI will get this field from?
As you say when you delete a custom field in Hikashop on your server it works fine.
We can say the same, because we deleted 8 fields, but the strange thing is that batch isn't deleted well. Based or the fact that it's still visible at CSVI.

We hope you'll ever find the reason why the field batch is displayed. For now we leave it, and hope it will not hurt in the future.
Attachments (1)
availablefields.zip
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes i agree to what you say, it is strange that the batch field is still visible and i don't see any reason why it shows up. CSVI updates available fields from two places, one from HikaShop table columns and other from the availablefields SQL file, if the field is not in these places then it should be something related to your site. I don't have any more options to think here.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I found the cause for batch field, you seem to have this as product characteristic in HikaShop, on your administrator if you go to HikaShop >> Products >> Characteristics, you can see an entry for batch field there and that is causing the issue. If you don't want it you can delete it and you wont see this field anymore.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!