Posted by johnking on May 23, 2010 at 8:21am
10 followers
Jump to:
| Project: | Node import |
| Version: | 6.x-1.1 |
| Component: | User interface |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
I'm trying to import the following
"name","description","price","catalog"
"car","car is good","1000","parent1 >> value1 || parent2 >> value2"
But at step 5/8
Only the "Multiple values are separated by": box show up for selection but not the ""Hierarchy is specified by" box did not show. It is like Node_import did not detect any Hierarchy in the catalog column. I tried to convert the upload file to many type of format, but none is work.
Apache 2.2.14 (IPV6 enabled)
MySQL 5.1.41 (Community Server) with PBXT engine 1.0.09-rc
PHP 5.3.1 (PEAR, Mail_Mime, MDB2, Zend)
Comments
#1
I have exactly the same problem...
#2
confirming I have now same exact problem.
#3
I had a similar problem here.
I solved my own problem by following some suggestions in this thread:
http://drupal.org/node/770318
And using the > character as the separator
#4
@#3,
The problem is NOT solved by following http://drupal.org/node/770318.
I posted http://drupal.org/node/770318 and am asking how to solve the same problem in it.
#5
Scenerio: I have have a hierarchial vocabulary and it's terms can have multiple parents. I use "parent>>term" format when importing via Node Import and the term is added to term_node
Table: node
nid=774
Table: term_node
nid=774, vid=774, tid=186
Table: term_hierarchy
tid=186, parent=7
tid=186, parent=8
tid=186, parent=9
tid=186, parent=10
tid=186, parent=65
How are these hierarchial relationships saved when using multiple parents per child? How does Drupal know which parent category the product belongs to in the Catalog since only the child term id is stored in the term_node table?
For example,
I have a child category named "Fairytale" which is available to "Men", "Women", "Girls" and "Boys" parent categories. I uploaded a product with hierarchy "Men=>Fairytale". I don' have any other producst that are in Fairytale category. I can see the term_node is storing the product node id along with the Fairytale term id. But how does it know it should be under Men, not any other Fairytale parent categories? Where does it store the product's relationship to Men? When I click on the Catalog menu option for "Girls" it lists "Fairytale" as an option, yet there are no products added to that term. And when I click on the Girls -> Fairytale option the Mens Fairytale product is displayed. This happens for all Fairytale parents.
I open the product editor and see there all Fairytale categories are selected in Catalog select menu. So I selected a single Fairytale subcategory, under the Mens category, but when I submit it re-selects the parents again. I can't choose just one, it won't let me change it.
I see that the products node id is stored in the term_node table, so the product is relative to Fairytale, but how does it know that it's supposed to be relative to Men as well? Where is this hierarchy relationship stored? Why are the categories listed when they don't contain products? Why are they displaying products that aren't in their categories?
I have relations, multiple and hierarchy set to 1 for the vocabulary. Are there any required modules besides the core Taxonomy module?
Any insight would be appreciated. Hopefully someone is not too confused to help :)
#6
#7
If you are not prompted to enter the character used to separate hierarchies during node import and have access to the database, look at the vocabulary table and make sure the hierarchy value is set to 1. Then you should see the prompt.
#8
Setting the hierarchy value to 1 works a treat. See Comment 7. THANKYOU
#9
I followed this and got it to work: http://drupal.org/node/437834#comment-1728792
#10
My hierarchy value is set to 1, but I still don't get the prompt in step 5. http://drupal.org/node/993782
#11
I have mine set to 1 and now it just added the different terms separately... any ideas?
#12
I have the same result as John King, but with another starting point:
Taxonomy with hierarchical select and multiple select is chosen:
So I have: branch>>group>>product, which is recognized and is imported.
Then I wrote successfully Product||Product1 in my csv file. Same result: recognized and imported.
Then I wrote branch>>group>>product||branch>>group>>product1. The prompt in 5/8 recognized it, but it was not imported!
So I made about 20 different tests with spaces and without, but always the same: The prompt is correct, the import shows nothing! So what could be the problem?
I know that this issue is quiet old but I never saw a solution until now.
So was anybody able to solve these issues?
Thx in advance!