Hi Neil,

I worked with Anders on some Teacommerce extensions years ago. Don't know if theses are still valid but you can find them here https://www.dropbox.com/s/xhuwizhqe27tmt2/CMSImport.TeaCommerce-source.rar?dl=0

The variants is in here and work as a seperate child import, so you basically have Categories -> Products (Child import of categories) -> Product variants (Child import of Products). Variants allows you to map to a variant and price

Nested content is not something CMSImport can handle since it's a definition of it's own.

Hope you can use the source code.

Best,

Richard

Hi Richard

Thanks, I'll take a look.

For things like Multi Media Pickers, Content Tree Pickers, Multi-Node Tree Pickers.

Is there a format that information needs adding to a cell? Then generate the CSV.

For instance, in a Multi-Media Picker, do we just list the file location of the images comma delimited?

e.g - C:\Documents\Pic1.png, C:\Documents\Pic2.png

And so on? Do they need to be in quotes? Is there a definitive guide on how we need to format cells in our spreadsheet so the CMS Import can map the values correctly to the corresponding property type?

For media Pickers use a relative path to the media item /images/pic1.png etc for link pickers use the title.

Best to watch the video import Content First https://soetemansoftware.nl/cmsimport/videos that explains how to map the things.

Best,

Richard

Hi Richard

Yes, I'm aware of how to map things in CMS Import, I select the corresponding item in the dropdown.

I Just want to know how it should be saved/formatted in the Excel Spreadsheet so CMS Import knows how to map the value entered into the cell of the spreadsheet to the corresponding property type.

Can it handle multiple images for the Multi-Image Picker? If I add the paths like this in a cell:

"/images/pic1.jpg", "/images/pic2.jpg"

will CMS Import know that it will import 2 images to that Property Type of Multi-Media Picker?

Do I need the quotes around the file path?

Also when you say relative path for images, is this relative to Umbraco?

So in the images folder add an image and reference in the Excel spreadsheet?

I have tried /images/product_images/pic1.png and this just fails, I get an error when opening the created product node, it can't find that URL.

Or do I need to upload the images to Umbraco's Media folder, and then add the relative path to the Excel spreadsheet?

Surely this should all be documented somewhere? I've spent the best part of a day testing paths, text, in the hope it will magically map what I've added, is there any reference documentation I can use to make sure what I'm adding to my cells in Excel can be mapped correctly on import?

Hi Neil,

The images need to be relative to the root folder. Did you set the advanced settings on the mapping?

Below the sheet and the images folder I used in the video.

https://www.dropbox.com/s/3mtrz9ljw2yhx54/Products.xlsx?dl=0 https://www.dropbox.com/s/ji759gehh6wkltf/productimages.zip?dl=0

HI Richard

Thanks, I'll take a look at the Excel sheets.

I guess it's all going to be nested with Keys to determine what each nestable options which rely on its parent.

Hopefully, I can get this code to work for Tea Commerce Variants and the client can build up their Excel sheets accordingly.

Where do I set up advanced settings on the mapping?

Do I need to purchase a license to see those options. We're using the default one at the min to test we can import before committing and buying a license, but if we need it to set these options, we'll buy the license

Hi Neil,

Ah that explains. The free version doesn't support media import If you email [email protected] I'll reply with a Trial license. And then you should see a settings icon after the Image property mapping.

Hope this helps,

Richard

HI Richard

Brilliant, email sent.

HI Richard

I'm trying to implement this - https://www.dropbox.com/s/xhuwizhqe27tmt2/CMSImport.TeaCommerce-source.rar?dl=0

I've got it compiling into a DLL, added it to my bin folder, and referenced it in Visual Studio.

I'm running a 'Create Child Definition' from the imported Products. Setting a ParentId and Id of the Variant, however it doesn't seem to map the Variants correctly?

As you can see it just creates them as Child Nodes of Type Variant. It's mapping some of the Properties Ok, so think I'm nearly there with it.

When I Map the Property Types, There doesn't seem to be mapping for Colour and Sizes.

Any pointers on how to get this working correctly?

Hi Neil,

Did you use the TeacommerceVariant Import provider in that child import? I think you've used the standard one?

Best,

Richard

is working on a reply...