Why doers import import certain csv files wihout a problem and some it just doesn't want to.
battlingnewbie - June 7, 2009 - 16:21
| Project: | Node import |
| Version: | 6.x-1.0-rc4 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
I get the following error warning: mb_strlen() expects parameter 1 to be string, array given in C:\xampp\htdocs\shop\includes\unicode.inc on line 404. How do I fix this please?
Also it says a field is required but the file dis there and it is mentioned and selected so why does it say is required? How can I disable the requirement for certain fields?
#1
#2
In step 5 of 8 it says catalog hierarchy is spciofied by >>. What does that mean and if I leave it in there I get an error. How do you specify the hierarchy in the csv file? How do I create a category and then a sub category in the file so that node_import creates the categories in the catalog?
#3
why keep assigining yourself the issue if you aren't providing a patch for it?
#4
You have to add the names of your columns in your csv file; ParentColumn>>ChildColumn
#5
#6
Example File Please. I see, I learn.
Z
#7
I'm having the same issue. An example file would be quite useful.
For example, vocabularly of "animals" --
Term 1 (parent) Term2 (child)
Canines wolf
Canines dog
Marsupials kangaroo
Marsupials koala
Marsupials wombats
Bugs Flea
Bugs Cockroaches
Bugs Volkswagen Beetle
...how would we structure a file? Would it be this:
Col1: term , col2: parent
Canines ,
wolf , Canines
dog , Canines
Marsupials ,
kangaroo , Marsupials
koala , Marsupials
wombats, Marsupials
...etc. or
Col1: term , col2: parent
Canines ,
wolf , Canines>>wolf
dog , Canines>>dog
Marsupials ,
kangaroo , Marsupials>>kangaroo
koala , Marsupials>>koala
wombats, Marsupials>>wombats
...or none of the above? I've tried iterations of both, and tried having the terms inclusive of the heirarchy but they got loaded directly as whole terms, unparsed.
Col 1: Term
Canines
Canines>>wolf
Canines>>dog
Marsupials
Marsupials>>kangaroo
Marsupials>>koala
Marsupials>>wombats
...so, it's confusing. An example would help.
#8
Here's a simple template that works with the latest dev version. At least, it works for me...
This is for importing taxonomy terms. So first, you should set up the name of the taxonomy, then when you hoover everything into the taxonomy you'll want to select that type. For instance, if your tax is named 'Widgets', then in the import wizard you'll want to select 'Terms for Widgets'.
Good luck.
#9
Thank you -- will test it and update. :)
#10
Didn't work.
I'll remove the module and reinstall, ensuring that the latest dev version is installed, then try again.
#11
Worked beautifully.
Had to make sure it was the latest dev module. That appears to have done it.
Thank you.
#12
Why is node import cutting off some text in one of the fields. It only allows a certain amount of text and the fields are text area fields. The text I am importing also don't have funny characters in it. It just cuts half the text of. Doesn't matter if I put it in the body of the node or create a seperate text field.
#13
Does it always allow the same amount of text to be imported (say, 255 characters) or is it a random number?
#14
Every time it just allows 208 characters and that includes the spaces
#15
Sorry here is a sample file
#16
How do I know what to look for in the csv file that make node import refuse to import certain rows and makes the whole screen blank. I am using Microsoft Excel and so should I use something else to create the csv files cause who knows what gets written to a file produced by anything Microsoft. Please someone help me I urgently nee to import these products and node import works but the files are wrong and I don't know where to start looking. Anybody?
#17
If you are getting a WSOD (white screen of death) then there is an error causing PHP to just quit. You will need to look at the PHP error output, which is disabled by default. Take a look at your php.ini configuration file to turn them on.
I am using OpenOffice calc (http://www.openoffice.org/product/calc.html) to save to CSV, it does a very nice job and is OSS. It uses quotes and escapes correctly. If you have non-ASCII symbols or characters, when saving to CSV change the character set to 'Unicode (UTF-8)' and they will be properly imported. There are no other options you need to change, and you should use the default CSV import options in node_import.
#18
Thank you very much for the help. I am going to try it and will post the result here. Thx
#19
The problem was the memory limit and the size of the image files. Thanks for the help