CSV Import 0.1 Alpha

57 replies [Last post]

Mon, 09/24/2007 - 13:16

CpILL

Offline

Joined: 08/08/2007

Juice: 549

OK,

So hit it on the weekend and have managed to get this CSV->XML thing going. Its in ALPHA so is not ready for anything really, but was hoping to get some feedback on the _code_ and the way I have got hooks for various modules setup (uc_product, uc_attributes and ... thats it) at the end of the file.

To use the interface go to /admin/store/products/import/csv and fill in the form. Its multistep so the second step asks you to map from your CSV file columns to UC product fields/attributes/taxonomys etc

At the moment whats not supported/working (because my current job doesn't require it):
- Manufacturers
- Categories
- Product images

but these are one (hook) function away (which someone might like to write). I'll end the last one myself so it will be coming.

What I would need on the Importer end is for Taxonomys to be imported via the XML interface or at least a hook to allow taxonomy's to define a way, as well as contributed modules like Inventory API which need to expand the XML definition themselves.

There is still a lot of work that needs to be done to get this "client ready" and I could use some help if anyone also needs this for a client...?

Preview	Attachment	Size
	uc_import_csv_alpha1.zip	6.51 KB

Uberdevelopment www.tsd.net.au/blog

Mon, 09/24/2007 - 22:44

#1 View page

jimijamesi

Offline

Joined: 08/19/2007

Juice: 75

Re: CSV Import 0.1 Alpha

fantastic effort, this is a a great contribution, I will be happy to test with my 8,000 product list or at least part of it.... Okay.. Initial test results with 1400 products timed out, second attempt with 500 was processed but lots of errors repeated.... I included the errors in the attachment... only half dozen errors but lots of repeats

So without categories, each product goes in with no taxonomy applied? I noticed that the drop downs included my taxonomy top level vocabularies under "category" one of them being Product Catalog. Maybe this is close to being able to at least get the products into a high level cat??

The orphan product page in store admin does not offer a method to apply taxonomy to a group of items it only links to the edit screen for that item. The move products allows you to move or copy items between categories, but does not let you move from orphaned to category XYZ

So that being aid the products did import ( they showed up in "recent posts" all 500 but the type -1st column on recent posts- was not "product" the type is blank) when I went to view a product it did not display anything except title & description and when I clicked to edit the product i got the following error message:
warning: call_user_func_array() [function.call-user-func-array]: First argument is expected to be a valid callback, '_node_form' was given in /var/www/sandbox_bj/html/includes/form.inc on line 218.

I will try some more tests (perhaps this time specifying a class in stage 1... one of the error messages spoke of required class setting, and my import is not using classes)

Once again thanks for a great start to a much needed functionality... ill keep on testing

Attachment	Size
csv.html	277.66 KB

Mon, 09/24/2007 - 23:18

#2 View page

jimijamesi

Offline

Joined: 08/19/2007

Juice: 75

Re: Re: CSV Import 0.1 Alpha

okay I set up a class, then selected that class from the drop down in step one. The products imported and the type (new class) was identified in the first column on the recent posts page. Each product displays properly and can be edited using the normal process.

However the csv did return some errors
# warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: namespace error : Namespace prefix xsi for schemaLocation on store is not defined in /var/www/sandbox_bj/html/modules/uc_import_csv/uc_import_csv.module on line 490.
# warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: in /var/www/sandbox_bj/html/modules/uc_import_csv/uc_import_csv.module on line 490.
# warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: ^ in /var/www/sandbox_bj/html/modules/uc_import_csv/uc_import_csv.module on line 490.
# warning: Invalid argument supplied for foreach() in /var/www/sandbox_bj/html/modules/ubercart/uc_importer/uc_importer.module on line 837.
# warning: Invalid argument supplied for foreach() in /var/www/sandbox_bj/html/modules/ubercart/uc_importer/uc_importer.module on line 901.
# warning: Invalid argument supplied for foreach() in /var/www/sandbox_bj/html/modules/ubercart/uc_importer/uc_importer.module on line 942.

with the last 3 repeating again and again

Also the question I have is when I created a new class it shows up as a new node type (in create content) and I can assign it in csv step 1, but i cannot assign it as a basic "classless" product node.

wish list
clean url field
taxonomy at least into a first level term (so we can use the move products for multiples)
function without classes
image path / image name / image alt/title tags

Great work CpILL I like the interface for step 2 very intuitive and quick to map colums -thanks

Tue, 09/25/2007 - 06:17

#3 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Re: CSV Import 0.1 Alpha

Thanks jimijamesi, there is a namespace problem but should be fixed now. The last three errors above are actually in Lyle's uc_impoter module and seem to relate to my importer not generating any category info.

Actually the code isn't ready for testing, I as hoping to find developers who might need this and would be willing to help with the uc_importer side of things...?

Uberdevelopment www.tsd.net.au/blog

Thu, 10/11/2007 - 09:41

#4 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Re: Re: CSV Import 0.1 Alpha

Heres another release of the CSV Importer I've been working on. Again it doesn't directly support the Catalog and Manufacturers modules, but these are just Taxonomys which it does support and is the same thing really.

I have images importing and have a tricky option which lest you
* 1st define a path to look for images in
* 2nd define a column in the CSV for the image name OR a naming pattern based on one or more columns in the CSV file.
NOTE: when using the file-name-pattern it normalises all the file names by making them all lower case. So you file names have to be all lower case for this to work. If there is a filename in the image column then this overrides the file-name-pattern option. It will do a check for the existence of the file before writing it to the XML.

To make the image import work for me I had to rework the whole import code in the Importer module, which I have attached. Lyle says it works anyway so maybe give it a try as is before replacing the uc_impoter.module file with the attached one here. Basiclly I've just made it a hook call instead of inline code and insert directly into all the relevant tables myself.

Give it a go

Attachment	Size
uc_import_csv_v0.3.zip	8.62 KB
uc_importer_cpill-hack.zip	33.25 KB

Uberdevelopment www.tsd.net.au/blog

Thu, 10/11/2007 - 10:13

#5 View page

psynaptic

Offline

Joined: 08/28/2007

Juice: 731

Re: Re: Re: Re: Re: CSV Import 0.1 Alpha

Nice one! Many thanks for your efforts. Is this PHP5 only?

Drupal Contrib API
Freestyle Systems

Thu, 10/11/2007 - 10:49

#6 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Re: Re: Re: Re: CSV Import 0.1 Alpha

Ya, afraid so.

Uberdevelopment www.tsd.net.au/blog

Thu, 10/11/2007 - 11:05

#7 View page

psynaptic

Offline

Joined: 08/28/2007

Juice: 731

Re: Re: Re: Re: Re: Re: Re: CSV Import 0.1 Alpha

I'll ask my host to upgrade me then. Cheers for the heads-up.

Drupal Contrib API
Freestyle Systems

Sat, 11/10/2007 - 16:25

#8 View page

Zsigmon

Offline

Joined: 11/09/2007

Juice: 64

Hey, it works fine! Will it

Hey,

it works fine!
Will it be included in the next release of the module?
Great work! Thanks!

Wed, 12/12/2007 - 01:51

#9 View page

crunchyinmilk

Offline

Joined: 12/12/2007

Juice: 7

Time out error and fatal memory error

"Initial test results with 1400 products timed out, second attempt with 500 was processed"

We changed that in php.ini so it would stop timing out and getting memory errors. Had to import 11,000 items with a dozen or so columns. Totally new at this - brutal.

Always dive in head first.

Fri, 10/19/2007 - 05:12

#10 View page

stormer

Offline

Joined: 09/16/2007

Juice: 110

Re: CSV Import 0.1 Alpha

Is there a way that I can modify this module to include the fields that I have manually added to the product content type?

many thanks

Ole

Tue, 10/23/2007 - 12:42

#11 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Yes actually, You just have

Yes actually,

You just have to write a hook function for the CCK module. The hooks that are used by this module are:

hook_uc_import_csv_row() - Called for every row in the CSV thats is processed

hook_uc_import_csv_fields_list() - Provide an array($data_key => 'Display name') to add options to the select lists on Step 2

hook_uc_import_csv_filename_tokens() - Provide tokens that can be used when building an image file name on Step 2

YOu just need the first 2. hook_uc_import_csv_fields_list() to add your fields (or any CCK fields for the chosen content type) to the drop downs on step 2 and then hook_uc_import_csv_row() to generate the XML as per the documentation that Lyle provided for custom fields. If you were defining your own XML structures completely you'd also have to define a hook for reading in the XML and updating the DB.

Uberdevelopment www.tsd.net.au/blog

Tue, 10/23/2007 - 16:17

#12 View page

stormer

Offline

Joined: 09/16/2007

Juice: 110

Re: Yes actually, You just have

Brilliant CpILL, I'll give that a shot. I owe you one.

Tue, 11/06/2007 - 09:20

#13 View page

quaoar

Offline

Joined: 08/08/2007

Juice: 179

Re: Re: Yes actually, You just have

stormer, did you go any further with this?
We are going to try and import data to custom content type.

Only partially tried out your module CpILL, but it looks great.
Will be back here later with an update.

Erlend StrÃ¸msvik
Ny Media AS
erlend@nymedia.no

Thu, 11/08/2007 - 05:09

#14 View page

quaoar

Offline

Joined: 08/08/2007

Juice: 179

Re: Re: Re: Yes actually,

CpILL your module worked great after I made some additions and one change to the module.

Had to add some form of "input control" on the data in the CSV file.
Changed this line:
$row[$form_values['column_'.$i]] = $csv_row[$i];
To this:
$row[$form_values['column_'.$i]] = str_replace('&', '&',$csv_row[$i]);

Added these functions (based heavily on your product attributes functions):

/**
 * Implements hook_uc_import_csv_fields_list()
 *
 * returns an array of the fields available for the selected product class
 */
function content_uc_import_csv_fields_list($values) {
    if(!empty($values['class'])) {
        $fields = content_fields(null,$values['class']);
        if(count($fields)) {
            $fields = array_keys($fields);
            sort($fields);
            $field_names = array();
            foreach($fields as $field) {
                $field_name['cck_'.$field] = $field;
            }
            return array('CCK fields' => $field_name);
        }
    }
}
/**
 * Implements hook_uc_import_csv_row()
 *
 * Adds the cck values to the xml object
 */
function content_uc_import_csv_row($product_xml, $data, $store_xml) {
    // Processing for each property individually
    $attribute_count = 0;
    foreach($data as $property => $value) {
        // Firstly: Is it one of ours? ...if it begins with 'cck_'
        if(!empty($value) && substr($property,0,4) == 'cck_') {
            $name = substr($property,4);
            if(!isset($product_xml->fields)) {
                $product_xml->addChild('fields');
            }
            $field = $product_xml->fields->addchild('field');
            $field->addchild('name',$name);
            $delta = $field->addchild('delta');
            $delta->addchild('value',$value);
        }
    }
}

Probably a lot of things which are not taken proper care of XML-wise, but it works (for us anyway)

We can now import csv-files (generated by NeoOffice) into custom product classes (with around 30 fields) in UberCart.

Erlend StrÃ¸msvik
Ny Media AS
erlend@nymedia.no

Fri, 11/09/2007 - 13:04

#15 View page

mcneelycorp

Offline

Joined: 10/26/2007

Juice: 72

Re: Re: Re: Re: Yes actually,

Thanks for the module. A few things I noticed:

1) No support for special characters (Â®, â„¢ etc). I want to respect the owners of the trademarks and copyright.
2) When using CpILL's modules and quaoar's addition for cck support, I get the following result. Notice that another node type "product" is created - odd. And I get a few duplicate entry errors, which the other products are using the same taxonomy terms (see attached .txt sample).

Anyone have a solution for these problems?

Thanks

Attachment	Size
csv_errors.JPG	150.29 KB
Book1.txt	4.26 KB

===
Elvis McNeely
Blogging about Drupal: http://www.elvisblogs.org/drupal

Fri, 11/09/2007 - 15:45

#16 View page

quaoar

Offline

Joined: 08/08/2007

Juice: 179

Re: Re: Re: Re: Re: Yes actually,

Actually, the "duplicate entry" for table term_node is a warning we get too. But only a few warnings for around 2000 products imported. After the import I checked out the number of records in the different tables and the count for uc_products, term_node, content_type_custom, node, and a few more were correct so I just disregarded the "warnings".
If you find out why these warnings happens please post back though

This is how we used the csv import:
-First I create a custom product class
-Add all the necessary fields to the new node type (this includes the image field)
-Upload product images to a place on the server accessible to apache (the webserver)
-Go to the import csv url and select the csv file for upload, select the class for the products I'm about to import, and limited the module to -only- generate the xml-file for import. We don't have a column in the csv file which specifies the product class (might have something to do with the message you are seeing)
-Save the generated XML file to disk
-Use the ordinary import module to import the XML file

The only messages I get from the modules are number of csv lines processed, number of products created (written to the xml file), and some of the same warnings you got.

Erlend StrÃ¸msvik
Ny Media AS
erlend@nymedia.no

Fri, 11/09/2007 - 19:10

#17 View page

mcneelycorp

Offline

Joined: 10/26/2007

Juice: 72

hi quaoar, can I see your

hi quaoar,

can I see your site? I have never found a use for the product classes.

Thanks

===
Elvis McNeely
Blogging about Drupal: http://www.elvisblogs.org/drupal

Fri, 11/09/2007 - 19:52

#18 View page

quaoar

Offline

Joined: 08/08/2007

Juice: 179

Re: hi quaoar, can I see your

Well, we haven't used product classes per se earlier -we just added cck-fields to the default product class "product".
As both butikk.tapirforlag.no and www.ametrine.no are examples of (those are live sites).
The latest shop we are working on, is not yet out of testing and is only accessible on our internal development server.

Erlend StrÃ¸msvik
Ny Media AS
erlend@nymedia.no

Sat, 11/10/2007 - 16:50

#19 View page

quaoar

Offline

Joined: 08/08/2007

Juice: 179

Re: Re: hi quaoar,

I think this line:
if(count($properies_list) == $attribute_count) // 1st case only for now.
needs to be change into this:
if($attrbitute_count > 0 && count($properies_list) == $attribute_count) // 1st case only for now.

Because if not, it will start creating attributes elements in the XML file even though no attributes exists for that class.

Edit:
And while I am at it, I removed the check for products of the same name in the function uc_import_csv_multiform_submit. For us every CSV line is a new product and a lot of products have the same name.

Erlend StrÃ¸msvik
Ny Media AS
erlend@nymedia.no

Sun, 11/11/2007 - 14:56

#20 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Ha yes, good point. I

Ha yes,

good point. I haven't really tested this on products without attributes but I will make the fix.

The thing is at the moment, it uses the product name to figure out how to group products with attributes together as really there should be something like "Parent SKU" which would be all the sub-products. Perhaps an option on step.1 to disable it would help, but then why do you have attributes enabled if your not using them?

But these are the little things that make it not really suitable for the general public so I guess I won't be making it a contribution just yet.

Uberdevelopment www.tsd.net.au/blog

Mon, 11/12/2007 - 11:12

#21 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Ha yes, good point. I

I just noticed that the current uc_impoter module has changed a lot of things to the point I couldn't use it. It also removed support for associating products with any taxonomy term(s) so I have reverted to the previous one I've tested on which is attached here. This means its PHP5 only but them the breaks.

Attachment	Size
cpill-uc_importer.zip	33.25 KB

Uberdevelopment www.tsd.net.au/blog

Mon, 11/12/2007 - 12:26

#22 View page

Lyle

Offline

Joined: 08/07/2007

Juice: 6841

Re: Re: Ha yes, good point. I

Bwuh? You can't put products into any taxonomy terms? I changed a lot, but I didn't mean to do that. Might it be that your vocabularies didn't allow products in them?

Looks like I'm going to be working on it some more anyway.

Sun, 11/18/2007 - 11:29

#23 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Re: Ha yes, good point. I

Oh, I didn't see that you've added the:
'/store/vocabularies/vocabulary'
to the impoters XML spec.

good show!

Uberdevelopment www.tsd.net.au/blog

Thu, 11/22/2007 - 15:14

#24 View page

kcoworks

Offline

Joined: 11/22/2007

Juice: 103

some help maybe?

The CSV import isn't working for me, I just get a blank screen, allthough I used the above optimalisations. Is there a way to track what's going on?

More in detail:
- when I use the "just show me the xml", the file gets uploaded, but I don't get to the next screen.
- when using "import immediately", I get to the second screen, and after assigning the fields and hitting it, I get the blank screen.

An other question, how come it's impossible to use node_import to import csv directly? The product fields just aren't listed on that one.

(Don't get me wrong, I'm just coming over from the other eC module and ubercart seems a lot better allready.)

Fri, 11/23/2007 - 07:52

#25 View page

kcoworks

Offline

Joined: 11/22/2007

Juice: 103

node_import add-on

Here it is then... the node_import add-on for ubercart products.
just add it under the node_import/supported/ like CCK and ecommerce do.

just to import CSV directly, not passing through XML.

should work fine

Attachment	Size
ubercart.zip	1.15 KB

Sun, 11/25/2007 - 13:31

#26 View page

nicozulu

Offline

Joined: 11/25/2007

Juice: 10

Hy! I saw that you get a

Hy!
I saw that you get a blank screen too, if importing csv..
Than you the node_import add-on for ubercart products. I have a question: How do i insert the uc_product.inc ?
Please help. Hope u can
Cheers

Sun, 11/25/2007 - 14:01

#27 View page

kcoworks

Offline

Joined: 11/22/2007

Juice: 103

Re: Hy! I saw that you get a

Let me get this from the top. For the file I posted, you need the node_import module, you can get it from http://drupal.org/project/node_import

when you extract it in your modules folder, go to
/modules/node_import/supported/ and create a dir ubercart in it, place the .inc file in that dir, you get
modules/node_import/supported/ubercart/uc_product.inc

the node_import module includes all stuff under the supported dir, so no other actions should be required.

If you want to import images, have a look at http://drupal.org/node/143471
unfortunately, that solution is not yet generic, so you might have to do some manual adjustments (like the name of the image field you want to import to)

Sun, 11/25/2007 - 14:11

#28 View page

nicozulu

Offline

Joined: 11/25/2007

Juice: 10

Re: Re: Hy! I saw that you get a

Thanks for the reply

Sun, 11/25/2007 - 14:49

#29 View page

nicozulu

Offline

Joined: 11/25/2007

Juice: 10

Another point

Hi!
So my problem is, that i want to display different prices according to the user's permission.. Is it possible? If u know, please help me.. THX
cheers

Sun, 11/25/2007 - 17:04

#30 View page

kcoworks

Offline

Joined: 11/22/2007

Juice: 103

Re: Another point

First of all, you should open a new topic for tis, since it has nothing to do with CSV import. (Maybe an admin could move this topic?)
Second... How much different prices do you want? I'm in a simular situation, and I'm making use of the "list price" and "sell price" field available in UberCart, as I only need 2 standards.

I edited the function uc_cart_get_contents(), so the price returned gets switched based on a condition. As you can see in my test here below, I tried it with the user id of the admin and an anonymous user. The admin gets sell_price, others get list_price. of course, the if statement could also contain a role id or something else. I haven't yet continued on this code to make it descent and reusable. I'm open to any hints on how to do this the proper way I'll be coding on this in a few days.

$item->cost = $product->cost;
/* COWORKS EDIT */
global $user;
if($user->uid == 1){
$item->price = $product->sell_price;
}else{
$item->price = $product->list_price;
}
//$item->price = $product->sell_price; // this was the original line there
$item->weight = $product->weight;
$item->data = unserialize($item->data);

As this is sort of the "root" function for the prices mentioned in the cart and checkout, the switch here is taken all the way in to the order process.
I hope this kind of helps, if you need more then 2 prices, I don't think there's a module available for that right now. A lot also depends on the fact if you want different prices without any key between them or let's say a vast discount of x % or y $. In the latter, you might find results in the discounts module (which I have no experience with.)

Sun, 11/25/2007 - 17:53

#31 View page

nicozulu

Offline

Joined: 11/25/2007

Juice: 10

Re: Re: Another point

Yes, a new topic will be better...

I want to have 3 or more different prices, see how i mean it:

if($user->uid == 1){
  $item->price = $product->sell_price;
}else if($user->uid == 4){
  $item->price = ($product->sell_price)*0.75;
}else if($user->uid == 5){
  $item->price = ($product->sell_price)*1.25;
}else{
....
}

It will be good to list diff. prices at the catalog too.. The "target" is that users don't recognizes the difference between the prices..
What's your tip about?

Tue, 12/18/2007 - 00:41

#32 View page

bowwowadmin

Offline

Joined: 12/09/2007

Juice: 69

puplicate nodes

I thought my duplicating products was my fault but it seems to be something else.
I import just one product with all my fields and the confirmation says just added one node but I go to products and it shows 2, each with different paths and that is the only difference between the two. look at the screen shots for settings and url stuff.

help

Attachment	Size
importconfermation.png	69.76 KB
product1.png	87.89 KB
product2.png	83.2 KB
productimportsettings.png	100.18 KB
01up.zip this is the csv	331 bytes

Thu, 06/19/2008 - 02:48

#33 View page

oliver coleman

Offline

Joined: 01/09/2008

Juice: 210

Attribute support for node_import add-on

Here's a version with support for attributes: http://www.ubercart.org/contrib/5221

Thu, 06/19/2008 - 18:28

#34 View page

Leo

Offline

Joined: 01/27/2008

Juice: 17

Re: Attribute support for node_import add-on

Is it mandatory for a product to have atributes? I'm literally pulling my hair on this one, since nothing seems to work out right with node_import. If it's something I'm doing wrong and it's my fault, I really would like to know. I mean, it has to be, if it's working for everyone else.

Already posted my situation here with the exception that for this version, the mapping page returns:

user warning: Table 'mydatabase.uc_attributes' doesn't exist query: SELECT aid FROM uc_attributes in C:\Site\includes\database.mysql.inc on line 172.

So I have this under /node_import/supported/ubercart (uc_product.inc, that is). And on the first page, after choosing the file, I selected Product as type.

What gives?

(and no, if possible, I wouldn't want to rely on the xml way...)

Wed, 06/25/2008 - 19:35

#35 View page

Jmmb

Offline

Joined: 08/23/2007

Juice: 296

Blank Screen at Preview Stage

Hello,

I appreciate your add-on for the Node Import module. I have tried it now (a few times) and things work alright until I get to the preview stage. When I click "Preview" (at the mapping stage) it leads to a blank screen. And I can't get any farther from there....

Jim

EDIT - this is actually in response to: http://www.ubercart.org/comment/7642/node-import-add

(Drupal^Ubercart) * (Design^Development^Hosting) = Sundays Energy

Tue, 09/02/2008 - 12:59

#36 View page

giorgio79@drupal.org

Offline

Joined: 02/02/2008

Juice: 280

Re: Blank Screen at Preview Stage

Found this, worked for me
http://www.giantrobot.co.nz/content/importing-products-ubercart-csv

Review Critical
ClipGlobe - World Travel

Fri, 01/16/2009 - 08:37

#37 View page

ScottBaetz

Offline

Joined: 01/15/2009

Juice: 11

Re: Re: Blank Screen at Preview Stage

-- The Giant Robot Solution is an option....

Except that it's fairly limited in it's scope of fields to import. Leaving much of the ubercart data elements blank. It's a start - but I believe there are better solutions out there.

Scott Baetz
AdminInternet
sbaetz@admininternet.net

Tue, 03/03/2009 - 15:18

#38 View page

JackThompson

Offline

Joined: 02/28/2009

Juice: 110

Re: Re: Re: Blank Screen at Preview Stage

Any updates? Does anyone know if this works for Digital Goods?

Fri, 03/06/2009 - 11:04

#39 View page

JackThompson

Offline

Joined: 02/28/2009

Juice: 110

Re: Re: Re: Re: Blank Screen at Preview Stage

Anyone have any info here?

Tue, 03/24/2009 - 12:29

#40 View page

bloke_zero

Offline

Joined: 03/24/2009

Juice: 62

Node import

http://drupal.org/project/modules?text=nodeimport

Seems to work pretty well, just needs clean CSV files and to remember that when it imports the image it moves it so if you make a mistake and try to re-import the CSV file it will have moved the image and fail.

Oh yeah, it works with Drupal 6 and version 2.

------------------------------
http://zero-design.info

Fri, 01/09/2009 - 12:18

#41 View page

matteoraggi

Offline

Joined: 09/10/2008

Juice: 263

ubecart 2

It is compatible with ubecart 2? if not, when it will be?

Luxury Furniture
http://www.luxury-furniture.biz

http://www.hotelsupplies.us

Wed, 11/14/2007 - 21:09

#42 View page

stormer

Offline

Joined: 09/16/2007

Juice: 110

Re: Re: Re: Yes actually, You just have

Sorry for the delay. No, I've not yet had a chance to look into this. If I do figure it out or make progress I'll report back.

Wed, 12/19/2007 - 17:26

#43 View page

TimK

Offline

Joined: 08/18/2007

Juice: 147

Summary of Progress

Is this correct?

Current status

Most current version of the module: uc_import_csv_v0.3.zip

There is now support for Manufacturers, Categories, Product images

Can import attributes, and options (separated by comma, if more than 1 option)

uc_import_csv may conflict with current uc_import module, so use CpILL's hack

Still forthcoming

CCK support

Ability to import option adjustments to price and etc

Support for product features

Q. Will this module become part of the UC core?

Wed, 12/19/2007 - 18:01

#44 View page

TimK

Offline

Joined: 08/18/2007

Juice: 147

Re: Summary of Progress

Would it be possible to move this module to the Contributions directory? Then we could start an issue tracker thread. Cheers.

Thu, 01/03/2008 - 12:00

#45 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Summary of Progress

I never intended to support this as it would be far too much work. Ask Ryan or Lyle about what the future plans are for CSV import. I don't image they will use this as they tend to prefer to do everything themselves in core.

Try having a separate line for each attribute combo as I didn't test too hard with the comma separated option (but should just require some code tweaks by a keen developer).

Good luck

Uberdevelopment www.tsd.net.au/blog

Fri, 01/11/2008 - 17:13

#46 View page

TimK

Offline

Joined: 08/18/2007

Juice: 147

Re: Re: Re: Summary of Progress

Hi CpIll, thanks for the reply. It does not seem like there is much activity surrounding this topic at the moment. I certainly hope this module continues to be developed.

If you do get a moment, I have been getting the following error since the update to Beta 1:

Fatal error: Call to a member function data() on a non-object in /users/home/kolke/domains/kissandmakeupstore.com/web/public/sites/all/modules/ubercart/uc_importer/uc_importer.module on line 973

Any ideas?

Cheers.

Sat, 01/12/2008 - 14:14

#47 View page

CpILL

Offline

Joined: 08/08/2007

Juice: 549

Re: Re: Re: Re: Summary of Progress

I havn't tested this with the new Beta version and have stopped work on all UC related code. I don't know if CSV importing will become core at any point. Better ask Rtan or Lyle about it

Uberdevelopment www.tsd.net.au/blog

Thu, 02/14/2008 - 11:24

#48 View page

zptoth

Offline

Joined: 02/05/2008

Juice: 74

CSV import should be included

Hey,

I think CSV importer should be definitley included in the default Ubercart module!

It's 100 times more difficult to provide an XML than a CSV file, based on the pricelists, that a reseller recieves from the distributor. These lists are usually in XLS format and contain the weekly prices. It would be a very useful stuff for:

- first catalog uploads (1%)
- mass-updateing prices in the catalog (99%)

Who da hell is able to convert an XLS to the _required_ XML format? (coders only)
An what about XLS to CSV? (2 clicks)

What do you think?

XLS -> CSV -> catalog

Fri, 02/15/2008 - 16:54

#49 View page

psynaptic

Offline

Joined: 08/28/2007

Juice: 731

The editable fields module

The editable fields module that Lyle contributed to is super. You can create a view of say node title, sku and product price and make them editable. Then add an exposed filter to filter by taxonomy term and you're laughing.

Drupal Contrib API
Freestyle Systems

Thu, 03/06/2008 - 20:59

#50 View page

cstreit

Offline

Joined: 11/12/2007

Juice: 45

Hi Rich, Thanks for your

Hi Rich,

Thanks for your information. Did you managed to create a view which allows you to edit the node title as well?

-Chris

	Shopping cart
	View your shopping cart.

	User login
	Log in using OpenID: What is OpenID? Username or e-mail: * Password: * Remember me Log in using OpenID Cancel OpenID login Create new account Request new password

Ubercart

Navigation

Shopping cart

User login