Categories
View Replies (9)

Resolved XML Import-update [SOLVED]

  1. levelcom
    levelcom
  2. RO CSVI
  3. Friday, 27 February 2015
  4.  Subscribe via email
Hi my installation is:
Joomla 3.3.6
VirtueMart 3.0.4
PHP 5.6.3
MySQL 5.6.21
Magic Quotes Off.
I have already loaded the required products from this vendor via csv files.
This vendor is giving xml files for update purpose e.g.: price and availability.
The product_sku in my site is the same as the field <code> from the xml file and
The product_price is the same as the field <timi> from the xml file.
The issue I’m facing is that (I guess) the xml file is not recognized correctly, I get “No product SKU found” messages.
I need to add here that I don’t want the total of the records to be included, only the SKUs that exist in my site.
What might be wrong?
Thank you, Dennis
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

You have set in your template to use the file for configuration but that is not possible because your XML file does not contain the CSVI fieldnames. So you will have to add the fields to your template first. I see you already have the XML record name set, so that is good.

The product_sku in my site is the same as the field <code> from the xml file and
The product_price is the same as the field <timi> from the xml file.
Exactly this you will need to put in the fields page. The field name is the product_sku and the XML node is code. The same you do for the price field. That should get you going.
Kind regards,

RolandD

=========================
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
levelcom
levelcom
Accepted Answer Pending Moderation
Thank you so much for the quick reply. Karma +++
Please find attached my fields set-up.
What I'm trying to achieve is:
XML File >> CSVI field
code >> product_sku
timi >> product_price
availability >> product_in_stock
Skip all the rest XML fields.
Especially for "availability" I need a "replacement" because "if availability=1 then product_in_stock = 50 etc... but this is in step 2.
Lets stick at product_sku and product_price witch need no transformations.

Do you see something wrong at my field set-up?
-*Dennis
Attachments (1)
Fields.jpg Fields.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Dennis,

The Template field name field needs to be empty, it is used for something different. You already have the field names in the first column. Other than that, all looks good to me.
Kind regards,

RolandD

=========================
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
levelcom
levelcom
Accepted Answer Pending Moderation
Hi
I have changed the field settings, unfortunately with no change to the result.
Just to make clear, the xml contains about 3k products but I only need about 1.2k of them. The rest SKUs do not exist in my shop, so expect them to be rejected as I set "Skip new items [YES]".
I do verify that SKUs that do exist in xml and shop are not updated so it seems to me that everything is rejected because of "No product SKU found" error.

Any clues?
-*Dennis
Attachments (6)
com_csvi.log.1425286773.zip
fields.jpg fields.jpg
file.jpg file.jpg
image.jpg image.jpg
Limit.jpg Limit.jpg
options.jpg options.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Dennis,

so expect them to be rejected as I set "Skip new items [YES]".
Correct.

You need to set the option Use column headers as configuration to No because your XML file doesn't contain the CSVI fieldnames but your fields tab does.

That is why it can't find the SKU.
Kind regards,

RolandD

=========================
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
levelcom
levelcom
Accepted Answer Pending Moderation
Hi again
This looks a lot better.. What a tool...
Proceeding with my updates I have this issue:
As mention earlier I need to use some Replacements in order to import eg product_in_stock in the following manner:
availability=1 then then product_in_stock=50
availability=2 then then product_in_stock=5
availability=3 or 4 or 5 or 6 then then product_in_stock=0
The one to one relations works fine, on the other hand the third case does not.
Please find attached how I set the third case replacement, also note that I have used moth
3,4,5,6 or
3
4
5
6

What am I doing wrong?
-*Dennis
Attachments (4)
field_replacements.jpg field_replacements.jpg
replacement.jpg replacement.jpg
replacements.jpg replacements.jpg
com_csvi.log.1425301815.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You need to change the comma to a |-symbol. That should do it.
Kind regards,

RolandD

=========================
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
levelcom
levelcom
Accepted Answer Pending Moderation
Hi in-deed, pipe did the trick...
I've hit an other issue though.
I have a field in my xml called "availability", I need to use it in order to fill values in product_availability according to the following manner:
xml>>>product_availability
6 >>>>not_available.gif
5 >>>>on-order.gif
4|3|2|1>>7d.gif
The issue is that none of them work, product_availability always remain empty.
I have tested single or double quotes (" or ') around the filling values, furthermore I have tested both the "regular text" and the /Regular expression/ methods, all with no luck.
Any suggestions on that issue?
-*Dennis
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I've hit an other issue though.
That is your cue you need another topic. I am not a fan of posting all issues in one topic as it makes it near to impossible to find anything back.

The issue is that none of them work, product_availability always remain empty.
Check if you have assigned the replacement rules to the product_availability field in your template. You would only need regular text for this.

If you still have issues with this, please start a new topic.
Kind regards,

RolandD

=========================
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
  • Page :
  • 1


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