Hi
I am trying to set up a xml import from a file on the server, I have followed everything acording to the instructions but it is not working
I have a xml file called courses.xml'
the format is as follows
<courses>
<course courseid="2058">
<name>PRINCE2 Foundation</name>
<type>1</type>
<summary/>
<description/>
<status>confirmed</status>
<date start_date="05/12/16" duration="3.0"/>
<price cost="795.00" special="625.00" lp_special="0.00" currency="£"/>
<seats capacity="" sold="" remaining="0"/>
<venue id="51" name="Southampton (Eastleigh)" long_name="Eastleigh - The Learning Centre " venue_url="http://www.bestpracticetraining.com/southampton-eastleigh.html"/>
</course>
there are 707 records
I have run the analyser and it look fine;
courseid
name
type
status
date/start_date
date/duration
price/cost
price/special
price/lp_special
price/currency
seats/capacity
seats/sold
seats/remaining
venue/id
venue/name
venue/long_name
venue/venue_url
Data
Top
If you see any unreadable characters in this table, your file is not UTF-8 encoded. Make sure your file is UTF-8 encoded so special characters like ë are imported correctly.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
courseid name type status date/start_date date/duration price/cost price/special price/lp_special price/currency seats/capacity seats/sold seats/remaining venue/id venue/name venue/long_name venue/venue_url
2058 PRINCE2 Foundation 1 confirmed 05/12/16 3.0 795.00 0.00 0.00 £ 0 51 Southampton (Eastleigh) Eastleigh - The Learning Centre http://www.bestpracticetraining.com/southampton-eastleigh.html
2059 PRINCE2 Practitioner 1 confirmed 08/12/16 2.0 595.00 0.00 0.00 £ 0 51 Southampton (Eastleigh) Eastleigh - The Learning Centre http://www.bestpracticetraining.com/southampton-eastleigh.html
2060 PRINCE2 Foundation and Practitioner 1 confirmed 05/12/16 5.0 1195.00 0.00 0.00 £ 0 51 Southampton (Eastleigh) Eastleigh - The Learning Centre http://www.bestpracticetraining.com/southampton-eastleigh.html
Ihave set up a template to import into Hikashop with the record name course
I have set up the template fields
Whern I do a import I only get the product codes for 707 records but nothing else
This preview shows how CSVI reads your file, not how the file is imported. The fields you see here are not validated yet, that will happen once you start the import. In case your file contains unsupported fields, CSVI will skip them during import as it will not know how to handle them.
Import file contains 707 lines
product_code product_name product_type price_with_tax product_url
2058
2059
2060
2061
2062
But If i change the record in the template to say courses, I get the fields displayed properly but only for 1 record
This preview shows how CSVI reads your file, not how the file is imported. The fields you see here are not validated yet, that will happen once you start the import. In case your file contains unsupported fields, CSVI will skip them during import as it will not know how to handle them.
Import file contains 1 lines
product_code product_name product_type price_with_tax product_url
2058 PRINCE2 Foundation 1 795.00 http://www.bestpracticetraining.com/southampton-eastleigh.html
I am stumped as to what I am doing wrong, can someone please help me out here.
Regards
Gerald
- greenlizzard
- RO CSVI
- Thursday, 01 December 2016
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!