Categories
View Replies (2)

Resolved Extract XML AttributeID's during import

  1. cyberspyder
    cyberspyder
  2. RO CSVI
  3. Wednesday, 16 May 2018
  4.  Subscribe via email
Is there a way to seperate out AttributeID into its own field when doing an import? i havnt worked with xml much. ideally putting each as its own field(Pitch 1/2in.) but 1 big list would be ok if not.

here is some sample code that i am working with
<AvailableDate>2009-01-01</AvailableDate>
<UNSPSC>25173817</UNSPSC>
<ProductAttributes>
<ProductAttribute MaintenanceType="A" PADBAttribute="N" AttributeID="Link Quantity">84</ProductAttribute>
<ProductAttribute MaintenanceType="A" PADBAttribute="N" AttributeID="Pitch">1/2 In.</ProductAttribute>
<ProductAttribute MaintenanceType="A" PADBAttribute="N" AttributeID="Plates">21</ProductAttribute>
0
Accepted Answer
cyberspyder
cyberspyder
Accepted Answer Pending Moderation
This worked! Thank you for the fast reply!
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You can set ProductAttributes/ProductAttribute/AttributeID in Your field section in template fields to read the AttributeID value. And since you are looking at reading both Pitch and 1/2in. values you need to have two template fields, one will be to read the value of ProductAttributes/ProductAttribute and other to read ProductAttributes/ProductAttribute/AttributeID. You can then use CSVI combine rule to combine these values. Hope it is clear.
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
  • Page :
  • 1


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