Import large CSV, including classification fields, to drupal 6.3
Hello,
I want to import a large data set (csv file or xml files) into drupal, have it converted to nodes including classification terms.
Several fields in my csv would contains serveral classes of tags. (such as "operating system" would be a field in the csv matching one vocabulary - with possible tags linux/linux64/win32/win64)
I am not shy of some php programming, but please advise the shortest route to success for this (by example?).
I looked at the import modules, but it looks like they don't yet support drupal 6.3.
Alternatively I assume I could write a small php script (external / command line executed?) that reads my complete csv and generates content for drupal_execute() and node_save().
--> someone had any success in doing either of this with 6.3 ? Please tell me your advice.
thank you.
S. Ontvang
also using 6.3
Looking for same thing --- but no luck yet.
Thought maybe could import via phpmyadmin as an option -- but haven't looked into it yet.
reverse engineer..
Maybe try a test website fill it with the node types you are trying to convert to,
then use mysql or phpmyadmin to extract some CVS files to see how it looks...
If you see a pattern you can use, then reverse it...
HOwever I suspect you really want something like the old "easy populate" used by oscommerce and also zencart... that makes one big CVS file (table) that is not relational but the "easy populate" queries it out to relational tables... If so, just a maybe, looking at how the easy populate module for oscommerce approaches it may help... sounds like a lot of work.