Active
Project:
Node import
Version:
6.x-1.1
Component:
User interface
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
23 May 2010 at 08:21 UTC
Updated:
25 Jan 2012 at 12:46 UTC
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
Comment #1
ch_masson commentedI have exactly the same problem...
Comment #2
paoloteo commentedconfirming I have now same exact problem.
Comment #3
Marco Palmero commentedI 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
Comment #4
ch_masson commented@#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.
Comment #5
myregistration commentedScenerio: 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 :)
Comment #6
myregistration commentedComment #7
myregistration commentedIf 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.
Comment #8
tomnoble commentedSetting the hierarchy value to 1 works a treat. See Comment 7. THANKYOU
Comment #9
deedeedum commentedI followed this and got it to work: http://drupal.org/node/437834#comment-1728792
Comment #10
stinky commentedMy hierarchy value is set to 1, but I still don't get the prompt in step 5. http://drupal.org/node/993782
Comment #11
delboud commentedI have mine set to 1 and now it just added the different terms separately... any ideas?
Comment #12
maen commentedI 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!