1. webstar
  2. RO CSVI
  3. Thursday, 09 May 2019
  4.  Subscribe via email
Hi, I wonder if you can help, Id like to export a list of products that have a custom field value.

out of about 300,000 products we have about 1000 products that have a custom group assigned to them (with 4 fields) Id like to export the SKUs and Category paths of Just these 1000 products.

Can this be done?

Many thanks
Accepted Answer Pending Moderation
Hello,
Glad to know your issue is solved. Please leave us a review on Joomla Extension Directory.
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
Accepted Answer Pending Moderation
Hi there - Yes the Cron job worked - Many thanks - this is great.

Incremental Exports will be great when implemented.

Many thanks for your help
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Is there no way to export in increments like you can do on import overrides?

As of now batch exports is not possible but this is a feature which is in our todo list and will be included in future.

Or Can you advise of what to set the system override settings to?

Overriding system limits will work only when you have a VPS or Dedicated server. One other option is to run the export as a cron job using command line. Can you try Setting the export as a cron job and check if it works?
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
Accepted Answer Pending Moderation
Ive tried - 1-1000 and this is fine - but anything over 50,000 and Im running into trouble.

Is there no way to export in increments like you can do on import overrides?

Or Can you advise of what to set the system override settings to?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Status error: 500
Status message: Internal Server Error

It is possible that your server has hit its limits when doing the export of 300,000 products. Can you try the export with 1000 products and check how it goes? To set the export limit, in your export template on File tab set From and To values to range from 1 to 1000 and run the export. Check if export works without any errors.
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. # 5
Accepted Answer Pending Moderation
yes as I feared - I'm gettign

Status error: 500
Status message: Internal Server Error

can you think of any way to get round this?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Yes its a field, Thats a good pointer I'll give it a go. how well do you think it will work with 300,000 products tho?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
What is the type of custom field you have? If it is a String custom field what you can do is add this custom field as a export field and using CSVI Skip rule create a rule which will skip the rows for which the custom field value is empty. Apply this rule on your custom field and run the export.

Let me know if it helps.
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. # 8
  • Page :
  • 1


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