Importing to NB Store

Aug 2, 2009 at 1:31 PM

Hi,

I'm trying to setup an import process. I'm using the 1.1.7 Beta 5.

First step is just to work out how to do the import.

I exported an xml file.

Created a zip file with two products.

Imported the file I exported, with no changes.

I get the following error:

System.InvalidCastException: Unable to cast object of type 'NEvoWeb.Modules.NB_Store.NB_Store_ProductImageInfo' to type 'NEvoWeb.Modules.NB_Store.NB_Store_ProductDocInfo'. at NEvoWeb.Modules.NB_Store.Import.ImportProducts(PortalSettings PS, String ImportFile, Boolean UpdateExistingProductsFlg, Boolean CreateCategoriesFlg)
Imported Zip Items: 2


Coordinator
Aug 3, 2009 at 5:34 PM

Hi,

Looks like your trying to import the image file zip file as a document zip file.  Please check your selecting the correct files on import.  If you are let me know, it could be an issue with the beta, but I've not see it before.

When exporting products you should get 3 files (if your using documents linked to products). 

1 - Product information as an xml file

2 - Images as a zip file

3 - Documents as a zip file.

 

By the nature of the product structure Languages>Products>models>options, the import file tends to be a bit complicated.  But if you recreate the stucture exported it should work OK.

The zip files are simply the image/docs zipped up, and then unzipped on import.

On the road map is a feature to import a simple product as csv file,  but I'm unsure when this will be released.

Good luck,

Dave.

 

Aug 3, 2009 at 11:11 PM

Dave,

I'm definitely just importing the xml file I exported.

 

<!-- BODY{font:x-small 'Verdana';margin-right:1.5em} .c{cursor:hand} .b{color:red;font-family:'Courier New';font-weight:bold;text-decoration:none} .e{margin-left:1em;text-indent:-1em;margin-right:1em} .k{margin-left:1em;text-indent:-1em;margin-right:1em} .t{color:#990000} .xt{color:#990099} .ns{color:red} .dt{color:green} .m{color:blue} .tx{font-weight:bold} .db{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;border-left:1px solid #CCCCCC;font:small Courier} .di{font:small Courier} .d{color:blue} .pi{color:blue} .cb{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;font:small Courier;color:#888888} .ci{font:small Courier;color:#888888} PRE{margin:0px;display:inline} --> <script type="text/javascript">// <![CDATA[// <![CDATA[ function f(e){ if (e.className=="ci"){if (e.children(0).innerText.indexOf("\n")>0) fix(e,"cb");} if (e.className=="di"){if (e.children(0).innerText.indexOf("\n")>0) fix(e,"db");} e.id=""; } function fix(e,cl){ e.className=cl; e.style.display="block"; j=e.parentElement.children(0); j.className="c"; k=j.children(0); k.style.visibility="visible"; k.href="#"; } function ch(e){ mark=e.children(0).children(0); if (mark.innerText=="+"){ mark.innerText="-"; for (var i=1;i<e.children.length;i++) e.children(i).style.display="block"; } else if (mark.innerText=="-"){ mark.innerText="+"; for (var i=1;i<e.children.length;i++) e.children(i).style.display="none"; }} function ch2(e){ mark=e.children(0).children(0); contents=e.children(1); if (mark.innerText=="+"){ mark.innerText="-"; if (contents.className=="db"||contents.className=="cb") contents.style.display="block"; else contents.style.display="inline"; } else if (mark.innerText=="-"){ mark.innerText="+"; contents.style.display="none"; }} function cl(){ e=window.event.srcElement; if (e.className!="c"){e=e.parentElement;if (e.className!="c"){return;}} e=e.parentElement; if (e.className=="e") ch(e); if (e.className=="k") ch2(e); } function ex(){} function h(){window.status=" ";} document.onclick=cl; // ]]></script>

- <root version="1.0">
- <products>
- <en-AU>
- <P>
- <NB_Store_ProductsInfo>
  <ProductID>1</ProductID>
  <PortalID>0</PortalID>
  <TaxCategoryID>-1</TaxCategoryID>
  <Featured>false</Featured>
  <Archived>false</Archived>
  <CreatedByUser>1</CreatedByUser>
  <CreatedDate>2009-08-02T17:05:48.25</CreatedDate>
  <IsDeleted>false</IsDeleted>
  <ProductRef>NODAVN1Yr</ProductRef>
  <Lang>en-AU</Lang>
  <Summary>This is the summery</Summary>
  <Description>&lt;p&gt;&amp;#160;jhljhlkjh jhl;j ;jh lkjh&lt;/p&gt;</Description>
  <Manufacturer>ESET</Manufacturer>
  <ProductName>NOD32 AntiVirus New License One Year</ProductName>
  <XMLData />
  </NB_Store_ProductsInfo>
- <M>
- <NB_Store_ModelInfo>
  <ModelID>1</ModelID>
  <ProductID>1</ProductID>
  <ListOrder>1</ListOrder>
  <UnitCost>59.4000</UnitCost>
  <Barcode />
  <ModelRef>NODAVN1Yr</ModelRef>
  <Lang>en-AU</Lang>
  <ModelName>NOD32 AntiVirus New License One Year</ModelName>
  <QtyRemaining>-1</QtyRemaining>
  <QtyTrans>0</QtyTrans>
  <QtyTransDate>2009-07-26T22:46:15.61</QtyTransDate>
  <ProductName>NOD32 AntiVirus New License One Year</ProductName>
  <PortalID>0</PortalID>
  <Weight>0.00</Weight>
  <Height>0.00</Height>
  <Length>0.00</Length>
  <Width>0.00</Width>
  <Deleted>false</Deleted>
  <QtyStockSet>0</QtyStockSet>
  <DealerCost>0.0000</DealerCost>
  <PurchaseCost>0.0000</PurchaseCost>
  <XMLData />
  </NB_Store_ModelInfo>
- <NB_Store_ModelInfo>
  <ModelID>2</ModelID>
  <ProductID>1</ProductID>
  <ListOrder>1</ListOrder>
  <UnitCost>89.1000</UnitCost>
  <Barcode />
  <ModelRef>NODAVN2Yr</ModelRef>
  <Lang>en-AU</Lang>
  <ModelName>NOD32 AntiVirus New License Two Years</ModelName>
  <QtyRemaining>-1</QtyRemaining>
  <QtyTrans>0</QtyTrans>
  <QtyTransDate>2009-07-26T22:58:12.503</QtyTransDate>
  <ProductName>NOD32 AntiVirus New License One Year</ProductName>
  <PortalID>0</PortalID>
  <Weight>0.00</Weight>
  <Height>0.00</Height>
  <Length>0.00</Length>
  <Width>0.00</Width>
  <Deleted>false</Deleted>
  <QtyStockSet>0</QtyStockSet>
  <DealerCost>0.0000</DealerCost>
  <PurchaseCost>0.0000</PurchaseCost>
  <XMLData />
  </NB_Store_ModelInfo>
  </M>
- <I>
- <NB_Store_ProductImageInfo>
  <ImageID>3</ImageID>
  <ProductID>1</ProductID>
  <ImagePath>C:\inetpub\wwwroot\dotnetnuke\Portals\0\productimages\1_0381d.jpg</ImagePath>
  <ListOrder>1</ListOrder>
  <Hidden>false</Hidden>
  <Lang>en-AU</Lang>
  <ImageDesc>image description</ImageDesc>
  <ImageURL>/Portals/0/productimages/1_0381d.jpg</ImageURL>
  </NB_Store_ProductImageInfo>
- <NB_Store_ProductImageInfo>
  <ImageID>4</ImageID>
  <ProductID>1</ProductID>
  <ImagePath>C:\inetpub\wwwroot\dotnetnuke\Portals\0\productimages\1_12668.jpg</ImagePath>
  <ListOrder>1</ListOrder>
  <Hidden>false</Hidden>
  <Lang>en-AU</Lang>
  <ImageDesc>servers</ImageDesc>
  <ImageURL>/Portals/0/productimages/1_12668.jpg</ImageURL>
  </NB_Store_ProductImageInfo>
  </I>
- <D>
- <NB_Store_ProductDocInfo>
  <DocID>1</DocID>
  <ProductID>1</ProductID>
  <DocPath>C:\inetpub\wwwroot\dotnetnuke\Portals\0\productdocs\69af1f82-f572-4154-a112-ea5461b9bebc.pdf</DocPath>
  <ListOrder>1</ListOrder>
  <Hidden>false</Hidden>
  <FileName>ESET NOD32 Antivirus Business Edition _Product Bul</FileName>
  <FileExt>.pdf</FileExt>
  <Lang>en-AU</Lang>
  <DocDesc>PDF Spec Sheet</DocDesc>
  </NB_Store_ProductDocInfo>
  </D>
- <C>
- <NB_Store_ProductCategoryInfo>
  <ProductID>1</ProductID>
  <CategoryID>3</CategoryID>
  </NB_Store_ProductCategoryInfo>
  </C>
- <options>
- <O>
- <NB_Store_OptionInfo>
  <OptionID>1</OptionID>
  <ProductID>1</ProductID>
  <ListOrder>1</ListOrder>
  <Lang>en-AU</Lang>
  <OptionDesc>Select For Years/Computers</OptionDesc>
  <Attributes />
  </NB_Store_OptionInfo>
  <OV />
  </O>
  </options>
  </P>
  </en-AU>
  </products>
- <categories>
- <en-AU>
- <NB_Store_CategoriesInfo>
  <CategoryID>1</CategoryID>
  <PortalID>0</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>1</CreatedByUser>
  <CreatedDate>2009-07-26T22:28:06.28</CreatedDate>
  <ParentCategoryID>0</ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>en-AU</Lang>
  <CategoryName>Notebooks</CategoryName>
  <ParentName />
  <CategoryDesc />
  <Message>&lt;p&gt;&amp;#160;&lt;/p&gt;</Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
  </NB_Store_CategoriesInfo>
- <NB_Store_CategoriesInfo>
  <CategoryID>2</CategoryID>
  <PortalID>0</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>1</CreatedByUser>
  <CreatedDate>2009-07-26T22:28:34.947</CreatedDate>
  <ParentCategoryID>0</ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>en-AU</Lang>
  <CategoryName>Software</CategoryName>
  <ParentName />
  <CategoryDesc />
  <Message>&lt;p&gt;&amp;#160;&lt;/p&gt;</Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
  </NB_Store_CategoriesInfo>
- <NB_Store_CategoriesInfo>
  <CategoryID>3</CategoryID>
  <PortalID>0</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>1</CreatedByUser>
  <CreatedDate>2009-07-26T22:29:37.79</CreatedDate>
  <ParentCategoryID>2</ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>en-AU</Lang>
  <CategoryName>ESET/NOD32 Antivirus</CategoryName>
  <ParentName>Software</ParentName>
  <CategoryDesc />
  <Message>&lt;p&gt;&amp;#160;&lt;/p&gt;</Message>
  <ProductCount>1</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
  </NB_Store_CategoriesInfo>
  </en-AU>
  </categories>
- <shipping>
- <method>
- <NB_Store_ShippingMethodInfo>
  <ShipMethodID>1</ShipMethodID>
  <PortalID>0</PortalID>
  <MethodName>Standard</MethodName>
  <MethodDesc>Standard</MethodDesc>
  <SortOrder>1</SortOrder>
  <TemplateName />
  <Disabled>false</Disabled>
  <URLtracker />
  </NB_Store_ShippingMethodInfo>
  <rate />
  </method>
  </shipping>
- <tax>
- <NB_Store_TaxRatesInfo>
  <PortalID>0</PortalID>
  <ItemID>2</ItemID>
  <ObjectID>-1</ObjectID>
  <TaxPercent>10.00</TaxPercent>
  <TaxDesc>Ship Tax</TaxDesc>
  <TaxType>STX</TaxType>
  <Disable>false</Disable>
  </NB_Store_TaxRatesInfo>
- <NB_Store_TaxRatesInfo>
  <PortalID>0</PortalID>
  <ItemID>1</ItemID>
  <ObjectID>-1</ObjectID>
  <TaxPercent>10.00</TaxPercent>
  <TaxDesc>Tax Default</TaxDesc>
  <TaxType>DTX</TaxType>
  <Disable>false</Disable>
  </NB_Store_TaxRatesInfo>
- <NB_Store_TaxRatesInfo>
  <PortalID>0</PortalID>
  <ItemID>3</ItemID>
  <ObjectID>-1</ObjectID>
  <TaxPercent>2.00</TaxPercent>
  <TaxDesc>Tax Option</TaxDesc>
  <TaxType>OTX</TaxType>
  <Disable>false</Disable>
  </NB_Store_TaxRatesInfo>
  </tax>
  </root>
Sorry, the formatting drops off when I past it in. I emailed it to you as well.
Coordinator
Aug 4, 2009 at 8:40 AM

Hi JJ,

The first thing I notice is that your using the update existing products option, There is a known problem with updating products when options are invloced (http://nbstore.codeplex.com/WorkItem/View.aspx?WorkItemId=3423) I've not had time to look at this problem yet, but it could be that there is also a problem with product documents/images on importing existing product.

Could you try to import the products as new products and let me know how that goes.

Thanks,

Dave.

Aug 4, 2009 at 9:40 AM

Dave,

That works.

However the feature to be able to update existing items is critical to my implementation.

The main and in fact, only reason I am redeveloping my website is so I can integrate it with my quoting software.

If I remove the document from the xml it imports without error. However it doesn't change the image. In fact I had two images and it removed one.

Also it removed the catagories associated with the product.

What is your ETA for getting the import feature to work properly? I don't need it to work 100% right now, I've got lots to do, but I do need it to work within a reasonable time frame. Otherwise I need to look at something else, or write my own import that works.

Coordinator
Aug 5, 2009 at 4:59 PM

Hi,

I do have a client whos project is funding the simple import, my idea is to do this by converting the csv into the import xml, I'll be looking at the issues with updating through the import system then.  Hopefully this will be in the next couple of weeks.

If you do get chance to have a look what might be going wrong, I be glad of any feedback to point me in the right direction.

Regards,

Dave.

Coordinator
Sep 17, 2009 at 3:54 PM

Hi,

I'm unsure if it's too late now, but I've completed the changes to the NB_Store import.  You can get the beta from codeplex now.

Regards,

Dave.

 

Sep 18, 2009 at 9:28 AM

Dave,

Thanks, It's not too late. Been busy setting up my first DNN site for a client.

I need the format of the csv file though.

JJ.

Coordinator
Sep 18, 2009 at 11:38 AM

Hi JJ,

If you download the beta and look at the documentation.html you'll see a brief explaination of how it works.  The CSV format can be anything you want, you create a import mapping template which maps the columns to the fields in the xml import file.

It can get quite complicated, but you should be able to work it out.

Regards,

Dave.

 

Oct 4, 2009 at 1:45 AM

Dave,

Can you either post a link to or email me a sample csv file?

JJ.

Coordinator
Oct 5, 2009 at 9:11 AM

Hi JJ.

Here's an example that my client uses: -

--------------------------------------------------------------------------------
CSV file:
--------------------------------------------------------------------------------

VMC;Kit double flux;U600008;UNELVENT;KIT DBLE FLUX HR X2REPART SOUF 4PIQ;KIT VMC DOUBLE FLUX AKOR HAUT RENDEMENT AVEC 2 REPARTITEURS SOUFFLAGE 4 PIQUAGES;1;12;1 917,13;U600008.JPG
VMC;Kit double flux;U600007;UNELVENT;KIT DBLE FLUX HR REPART SOUF 10 PIQ;KIT VMC DOUBLE FLUX AKOR HAUT RENDEMENT AVEC REPARTITEUR SOUFFLAGE 10 PIQUAGES;1;12;1 844,99;U600007.JPG
VMC;Kit double flux;U813881;UNELVENT;GAINE SOUPLE PVC ISOLEE D80MM L6M;GAINE SOUPLE PVC ISOLEE D80MM LONGUEUR 6 M;1;2;18,42;U813881.JPG
VMC;Kit double flux;U813883;UNELVENT;GAINE SOUPLE PVC ISOLEE D125MM L6M;GAINE SOUPLE PVC ISOLEE D125MM LONGUEUR 6 M;1;2;25,03;U813883.JPG
VMC;Kit double flux;U813884;UNELVENT;GAINE SOUPLE PVC ISOLEE D150MM L6M;GAINE SOUPLE PVC ISOLEE D150MM LONGUEUR 6 M;1;2;31,83;U813884.JPG
VMC;Kit double flux;U607044;UNELVENT;KIT AKOR VMC DOUBLE FLUX T3 A T7;KIT AKOR VMC DOUBLE FLUX MAISON T3 A T7;1;12;703,47;U607044.JPG
VMC;Kit hydro/auto;U600610;UNELVENT;KIT VMC HYG B T3/4 ELEC+DP TB CONSO;KIT OZEO VMC HYGRO TYPE B T3/4 BOUCHE CUISINE ELEC BOUCHE WC DETEC PRESENCE TRES BASSE CONSOMMATION;1;8;346,88;U600610.JPG
VMC;Kit hydro/auto;U600611;UNELVENT;KIT VMC HYG B T5/7 ELEC+DP TB CONSO;KIT OZEO VMC HYGRO TYPE B T5/7 BOUCHE CUISINE ELEC BOUCHE WC DETEC PRESENCE TRES BASSE CONSOMMATION;1;8;346,88;U600611.JPG
VMC;Kit hydro/auto;U600710;UNELVENT;KIT VMC HYGRO TYPE B T3/4 ELEC+DP;KIT OZEO VMC HYGRO TYPE B T3/4 BOUCHE CUISINE ELEC BOUCHE WC DETEC PRESENCE;1;8;278,74;U600710.JPG
VMC;Kit hydro/auto;U600711;UNELVENT;KIT VMC HYGRO TYPE B T5/7 ELEC+DP;KIT OZEO VMC HYGRO TYPE B T5/7 BOUCHE CUISINE ELEC BOUCHE WC DETEC PRESENCE;1;8;278,74;U600711.JPG
VMC;Kit hydro/auto;U813881;UNELVENT;GAINE SOUPLE PVC ISOLEE D80MM L6M;GAINE SOUPLE PVC ISOLEE D80MM LONGUEUR 6 M;1;2;18,42;U813881.JPG
VMC;Kit hydro/auto;U813883;UNELVENT;GAINE SOUPLE PVC ISOLEE D125MM L6M;GAINE SOUPLE PVC ISOLEE D125MM LONGUEUR 6 M;1;2;25,02;U813883.JPG
VMC;Kit hydro/auto;U813884;UNELVENT;GAINE SOUPLE PVC ISOLEE D150MM L6M;GAINE SOUPLE PVC ISOLEE D150MM LONGUEUR 6 M;1;2;31,83;U813884.JPG

--------------------------------------------------------------------------------
categoryCSV.ImportMapping
--------------------------------------------------------------------------------

 

<NB_Store_CategoriesInfo>
  <CategoryID></CategoryID>
  <PortalID></PortalID>
  <Archived>false</Archived>
  <CreatedByUser>-1</CreatedByUser>
  <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
  <ParentCategoryID></ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>[LANG]</Lang>
  <CategoryName>[COL:2]</CategoryName>
  <ParentName>[COL:1]</ParentName>
  <CategoryDesc></CategoryDesc>
  <Message></Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
</NB_Store_CategoriesInfo>

--------------------------------------------------------------------------------
productCSV.ImportMapping
--------------------------------------------------------------------------------

<P>
  <NB_Store_ProductsInfo>
    <ProductID></ProductID>
    <PortalID>[PORTALID]</PortalID>
    <TaxCategoryID>-1</TaxCategoryID>
    <Featured>false</Featured>
    <Archived>false</Archived>
    <CreatedByUser>-1</CreatedByUser>
    <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
    <IsDeleted>false</IsDeleted>
    <ProductRef>[COL:3]</ProductRef>
    <Lang>[LANG]</Lang>
    <Summary>[COL:6]</Summary>
    <Description></Description>
    <Manufacturer>[COL:4]</Manufacturer>
    <ProductName>[COL:5]</ProductName>
    <XMLData>&lt;genxml&gt;&lt;textbox&gt;&lt;txtcolissage&gt;[COL:7]&lt;/txtcolissage&gt;&lt;/textbox&gt;&lt;checkbox /&gt;&lt;dropdownlist /&gt;&lt;checkboxlist /&gt;&lt;radiobuttonlist /&gt;&lt;/genxml&gt;</XMLData></NB_Store_ProductsInfo>
  <M>
    <NB_Store_ModelInfo>
      <ModelID></ModelID>
      <ProductID></ProductID>
      <ListOrder>1</ListOrder>
      <UnitCost>[COL:9]</UnitCost>
      <Barcode />
      <ModelRef>[COL:3]</ModelRef>
      <Lang>[LANG]</Lang>
      <ModelName>[COL:5]</ModelName>
      <QtyRemaining>-1</QtyRemaining>
      <QtyTrans>0</QtyTrans>
      <QtyTransDate></QtyTransDate>
      <ProductName>[COL:5]</ProductName>
      <PortalID>[PORTALID]</PortalID>
      <Weight>[COL:8]</Weight>
      <Height>0.00</Height>
      <Length>0.00</Length>
      <Width>0.00</Width>
      <Deleted>false</Deleted>
      <QtyStockSet>0</QtyStockSet>
      <DealerCost>0.0000</DealerCost>
      <PurchaseCost>0.0000</PurchaseCost>
      <XMLData /></NB_Store_ModelInfo></M>
  <I>
    <NB_Store_ProductImageInfo>
      <ImageID></ImageID>
      <ProductID></ProductID>
      <ImagePath>E:\Websites\NB_Store\v1.2.0\Website\Portals\0\productimages\[COL:10]</ImagePath>
      <ListOrder>1</ListOrder>
      <Hidden>false</Hidden>
      <Lang>[LANG]</Lang>
      <ImageDesc />
      <ImageURL>/Portals/0/productimages/[COL:10]</ImageURL></NB_Store_ProductImageInfo></I>
  <D></D>
  <C>
    <NB_Store_ProductCategoryInfo>
      <ProductID></ProductID>
      <CategoryID>[COL:2]</CategoryID></NB_Store_ProductCategoryInfo></C>
  <options></options></P>

--------------------------------------------------------------------------------
replaceCSV.ImportMapping
--------------------------------------------------------------------------------

<root>
<item col="8" str="," rpl="." substr="true"/>
<item col="9" str="," rpl="." substr="true"/>
<item col="8" str=" " rpl="" substr="true"/>
<item col="9" str=" " rpl="" substr="true"/>
</root>

 

Nov 28, 2009 at 6:31 AM

Dave,

I've gotten up to doing the imports.

To start with I just copied your example exactly, and tried to import it.

Got the following result:

System.NullReferenceException: Object reference not set to an instance of an object. at NEvoWeb.Modules.NB_Store.ImportCSV.addParentCategoriesToTop(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.SplitCSVdata(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.ImportCSVProducts(PortalSettings PS, String ImportFile, Boolean UpdateExistingProductsFlg, Boolean CreateCategoriesFlg, String RowDelimeter, String FieldDelimeter)

 

Coordinator
Nov 28, 2009 at 9:25 AM

Hi JJ,

I've changed the import class since I posted that format...can't remmeber what???.. but anyway I think it should still work, make sure you've got the lastest version of NB_Store and Try it with just the first line.

VMC;Kit double flux;U600008;UNELVENT;KIT DBLE FLUX HR X2REPART SOUF 4PIQ;KIT VMC DOUBLE FLUX AKOR HAUT RENDEMENT AVEC 2 REPARTITEURS SOUFFLAGE 4 PIQUAGES;1;12;1 917,13;U600008.JPG

I think is could be the "/" in the later lines causing your problem.

Let me know how you get on...I'll post the lastest format my client uses on Monday (not in the office now!)  if your still having problems.

Regards,

Dave.

Nov 30, 2009 at 10:32 AM

Dave,

Error slightly different.

System.NullReferenceException: Object reference not set to an instance of an object. at NEvoWeb.Modules.NB_Store.ImportCSV.addParentCategoriesToTop(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.SplitCSVdata(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.ImportCSVProducts(PortalSettings PS, String ImportFile, Boolean UpdateExistingProductsFlg, Boolean CreateCategoriesFlg, String RowDelimeter, String FieldDelimeter)

categoryCSV.ImportMapping is:

<NB_Store_CategoriesInfo>
  <CategoryID></CategoryID>
  <PortalID>2</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>-1</CreatedByUser>
  <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
  <ParentCategoryID></ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>[LANG]</Lang>
  <CategoryName>[COL:2]</CategoryName>
  <ParentName>[COL:1]</ParentName>
  <CategoryDesc></CategoryDesc>
  <Message></Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
</NB_Store_CategoriesInfo>

productCSV.ImportMapping is:

<P>
  <NB_Store_ProductsInfo>
    <ProductID></ProductID>
    <PortalID>[PORTALID]</PortalID>
    <TaxCategoryID>-1</TaxCategoryID>
    <Featured>false</Featured>
    <Archived>false</Archived>
    <CreatedByUser>-1</CreatedByUser>
    <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
    <IsDeleted>false</IsDeleted>
    <ProductRef>[COL:3]</ProductRef>
    <Lang>[LANG]</Lang>
    <Summary>[COL:6]</Summary>
    <Description></Description>
    <Manufacturer>[COL:4]</Manufacturer>
    <ProductName>[COL:5]</ProductName>
    <XMLData>&lt;genxml&gt;&lt;textbox&gt;&lt;txtcolissage&gt;[COL:7]&lt;/txtcolissage&gt;&lt;/textbox&gt;&lt;checkbox /&gt;&lt;dropdownlist /&gt;&lt;checkboxlist /&gt;&lt;radiobuttonlist /&gt;&lt;/genxml&gt;</XMLData>
  </NB_Store_ProductsInfo>
  <M>
    <NB_Store_ModelInfo>
      <ModelID></ModelID>
      <ProductID></ProductID>
      <ListOrder>1</ListOrder>
      <UnitCost>[COL:9]</UnitCost>
      <Barcode />
      <ModelRef>[COL:3]</ModelRef>
      <Lang>[LANG]</Lang>
      <ModelName>[COL:5]</ModelName>
      <QtyRemaining>-1</QtyRemaining>
      <QtyTrans>0</QtyTrans>
      <QtyTransDate></QtyTransDate>
      <ProductName>[COL:5]</ProductName>
      <PortalID>[PORTALID]</PortalID>
      <Weight>[COL:8]</Weight>
      <Height>0.00</Height>
      <Length>0.00</Length>
      <Width>0.00</Width>
      <Deleted>false</Deleted>
      <QtyStockSet>0</QtyStockSet>
      <DealerCost>0.0000</DealerCost>
      <PurchaseCost>0.0000</PurchaseCost>
      <XMLData />
    </NB_Store_ModelInfo>
  </M>
<I></I>
  <D></D>
  <C>
    <NB_Store_ProductCategoryInfo>
      <ProductID></ProductID>
      <CategoryID>[COL:2]</CategoryID>
    </NB_Store_ProductCategoryInfo>
  </C>
  <options></options>
</P>

 

I added the portal id in the category map, but suspect it's all still not correct.

I've removed the image import as I don't need that.

JJ.

 

 

 

Coordinator
Nov 30, 2009 at 11:24 AM

Hi.

Firstly, lets make sure we're all running on the same playingfield. (or battleground..which ever you prefer!)

This is what I have setup for these setting

----------------------------------

rowdelimeter.importmapping Row delimeter for CSV import
fielddelimeter.importmapping Field delimeter for CSV import
fieldqualifier.importmapping  Field qualifier for CSV import, defaults to double quote (")
fieldescapedqualifier.importmapping Field escaped qualifier for CSV import, default to 2 double quotes ("")

----------------------------------

fielddelimeter.importmapping = ;            (Semi-colon)

The rest I have as the defaults.

 

Is this what you have in these settings?

Nov 30, 2009 at 8:17 PM

Dave,

This illustrates the main frustration I have with NB Store. Poor documentation, which I'm afraid is typical of most developers, including and especially myself. This is the pot calling the kettle black.

Any way.

I don't have these settings setup at all. They just aren't there. Didn't know they existed or were required.

All I have is the ones in the previous post, and they are setup in the templates section.

So what is the format for these new settings. Can you be very explicit please? Ie, cut and past everything you have in each one. Are they configured under settings or templates?

So for example do I setup a new template, call it fielddelimeter.importmapping and then just have a ";" (without the quotes) sitting in the text box, or is there some xml syntax I need.

row delimeters are usually <CR><LF>. How do I represent these?

I assume a fieldescapedquailifier is if you want to have the field qualifier in the text.

JJ.

 

Coordinator
Dec 1, 2009 at 9:00 AM

Hi JJ,

I hear you!!, and feel your frustration...documentation is an essential part to any software, but unfortunatly the first thing to suffer from lack of time.

I do try and keep the documentation.html in-line with what NB_Store can do, but it tends to be a list of technical functions that you have to piece together like shirlock homes.  Ideally we'd have a set of step by step documents for setting up NB_Store, but time simply doesn't allow me to do this.  One thing I'm trying to look at doing is a set of templates that can be used to give basic setup of NB_Store for different situations....but I suppose the tweeking will still be a issue.

If you do make any notes yourself on setting up NB_Store, please feel free to pass them onto me so I can share them on codplex with everyone.

And yes in the settings just create a setting called "fielddelimeter.importmapping" with just a semi-colon in the textfield, nothing else.

Just leave the rowdelimeter blank (or don;t create it) in order to get the <CR> or use html decode to convert any special characters (e.g.: &#09; = horizontal tab; &#13;&#10; = vbCrLf)

Regards,

Dave.

 

Dec 5, 2009 at 7:04 AM

Dave,

Still struggling.  Trying to get it as simple as possible.

Getting the following error:

System.IndexOutOfRangeException: Index was outside the bounds of the array. at NEvoWeb.Modules.NB_Store.ImportCSV.addParentCategoriesToTop(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.SplitCSVdata(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.ImportCSVProducts(PortalSettings PS, String ImportFile, Boolean UpdateExistingProductsFlg, Boolean CreateCategoriesFlg, String RowDelimeter, String FieldDelimeter)

 

Problem is this message is not helpful at all...

This is the row I'm trying to import:

Vipre,P411IEX1P00,Vipre Consumer Competitive Upgrade Single User 1 Year,19,1 User,Vipre Consumer

categoryCSV.ImportMapping:

<NB_Store_CategoriesInfo>
  <CategoryID></CategoryID>
  <PortalID>2</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>-1</CreatedByUser>
  <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
  <ParentCategoryID></ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>[LANG]</Lang>
  <CategoryName>[COL:5]</CategoryName>
  <ParentName>[COL:5]</ParentName>
  <CategoryDesc></CategoryDesc>
  <Message></Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
</NB_Store_CategoriesInfo>

productCSV.ImportMapping:

<P>
  <NB_Store_ProductsInfo>
    <ProductID></ProductID>
    <PortalID>[PORTALID]</PortalID>
    <TaxCategoryID>-1</TaxCategoryID>
    <Featured>false</Featured>
    <Archived>false</Archived>
    <CreatedByUser>-1</CreatedByUser>
    <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
    <IsDeleted>false</IsDeleted>
    <ProductRef>[COL:2]</ProductRef>
    <Lang>[LANG]</Lang>
    <Summary></Summary>
    <Description></Description>
    <Manufacturer>[COL:1]</Manufacturer>
    <ProductName>[COL:3]</ProductName>
    <XMLData></XMLData>
  </NB_Store_ProductsInfo>
  <M>
    <NB_Store_ModelInfo>
      <ModelID></ModelID>
      <ProductID></ProductID>
      <ListOrder>1</ListOrder>
      <UnitCost>[COL:4]</UnitCost>
      <Barcode />
      <ModelRef>[COL:2]</ModelRef>
      <Lang>[LANG]</Lang>
      <ModelName>[COL:5]</ModelName>
      <QtyRemaining>-1</QtyRemaining>
      <QtyTrans>0</QtyTrans>
      <QtyTransDate></QtyTransDate>
      <ProductName>[COL:3]</ProductName>
      <PortalID>[PORTALID]</PortalID>
      <Weight>0.00</Weight>
      <Height>0.00</Height>
      <Length>0.00</Length>
      <Width>0.00</Width>
      <Deleted>false</Deleted>
      <QtyStockSet>0</QtyStockSet>
      <DealerCost>0.0000</DealerCost>
      <PurchaseCost>0.0000</PurchaseCost>
      <XMLData />
    </NB_Store_ModelInfo>
  </M>
<I></I>
  <D></D>
  <C></C>
  <options></options>
</P>

Left all the other stuff as defaults.

Error message is in module addParentCategoriesToTop

Yet I'm just trying to update an existing product. Not trying to add categories at all.

Coordinator
Dec 6, 2009 at 7:57 AM
Edited Dec 6, 2009 at 8:01 AM

Hi JJ,

The first thing I notice is that your category xml says:

<CategoryName>[COL:5]</CategoryName>
  <ParentName>[COL:5]</ParentName>

This is impossible,because your parent can't be the same category....try:

<CategoryName>[COL:5]</CategoryName>
  <ParentName></ParentName>

....However looking a bit closer I see in the products you've got :

<ModelName>[COL:5]</ModelName>

But you've already said column 5 is the category name in the category section??

**** scratch this bit ...I see your trying to import existing ones ******

Also I notice you not get any category specifiec in the product section (under the <C> section)...this doesn't really matter, because the product should simply end up in the defalt "Imported" category.

**********************************************************************

I suggest you do try and get the category mapping to match you import, even if you just remove column 5.

Regards,

Dave.

Dec 6, 2009 at 8:10 AM

Dave,

What I don't understand, is I am trying to update existing products with new prices. So what is it doing with category stuff at all.... I would have thought it would have just updated the products.

However does it use the product ID or the product reference to match the products to do the update.

My concern is that it uses the product ID, which is an NB store internal key. So if I have to update products I first need to determine what id matches the part number.

One of my suppliers has 20,000 product lines.... (not that I will do all of them, but managing this could be a headache.

JJ.

Dec 6, 2009 at 8:22 AM

Dave,

I had fixed the category thing after the post.

I correct the model name thing.

I really just dont' have enough information on how to get this to work.

Are all tags required. If not which ones are. If I'm not using models, then what do I use or not use.

If I do an import that is update existing products, what does it do if the product isn't found.

If I do an import that is import new products, what does it do if the product exists.

In reality, most cases will have both with price updates. Some products get dropped, some are new, but most are just price updates. How do I manage this?

Error is:

System.IndexOutOfRangeException: Index was outside the bounds of the array. at NEvoWeb.Modules.NB_Store.ImportCSV.addParentCategoriesToTop(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.SplitCSVdata(Int32 PortalID, String CSVdata, String RowDelimeter, String FieldDelimeter) at NEvoWeb.Modules.NB_Store.ImportCSV.ImportCSVProducts(PortalSettings PS, String ImportFile, Boolean UpdateExistingProductsFlg, Boolean CreateCategoriesFlg, String RowDelimeter, String FieldDelimeter)

So which index is out of bounds.....?

Why is it coming from AddParentCategoriesToTop, when I have one product in the file that is an existing product? It shouldn't be trying to add anything....



Coordinator
Dec 6, 2009 at 3:26 PM

Hi JJ,

The import only matches the Product ref not the internal id.

When importing the, even if you not importing the categories is still processes them for validity...(probably something that should be removed).

Anyway I've recreated your import and it works fine on my dev machine..here is what I used:

 

Vipre,P411IEX1P00,Vipre Consumer Competitive Upgrade Single User 1 Year,39,1 User,Vipre Consumer

(the 39 price was just to check the update process after the first import).

 

categoryCSV.ImportMapping:

<NB_Store_CategoriesInfo>
  <CategoryID></CategoryID>
  <PortalID>2</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>-1</CreatedByUser>
  <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
  <ParentCategoryID></ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>[LANG]</Lang>
  <CategoryName>[COL:6]</CategoryName>
  <ParentName></ParentName>
  <CategoryDesc></CategoryDesc>
  <Message></Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
</NB_Store_CategoriesInfo>

productCSV.ImportMapping:

<P>
  <NB_Store_ProductsInfo>
    <ProductID></ProductID>
    <PortalID>[PORTALID]</PortalID>
    <TaxCategoryID>-1</TaxCategoryID>
    <Featured>false</Featured>
    <Archived>false</Archived>
    <CreatedByUser>-1</CreatedByUser>
    <CreatedDate>2009-09-10T17:03:51.47</CreatedDate>
    <IsDeleted>false</IsDeleted>
    <ProductRef>[COL:2]</ProductRef>
    <Lang>[LANG]</Lang>
    <Summary></Summary>
    <Description></Description>
    <Manufacturer>[COL:1]</Manufacturer>
    <ProductName>[COL:3]</ProductName>
    <XMLData></XMLData>
  </NB_Store_ProductsInfo>
  <M>
    <NB_Store_ModelInfo>
      <ModelID></ModelID>
      <ProductID></ProductID>
      <ListOrder>1</ListOrder>
      <UnitCost>[COL:4]</UnitCost>
      <Barcode />
      <ModelRef>[COL:2]</ModelRef>
      <Lang>[LANG]</Lang>
      <ModelName>[COL:5]</ModelName>
      <QtyRemaining>-1</QtyRemaining>
      <QtyTrans>0</QtyTrans>
      <QtyTransDate></QtyTransDate>
      <ProductName>[COL:3]</ProductName>
      <PortalID>[PORTALID]</PortalID>
      <Weight>0.00</Weight>
      <Height>0.00</Height>
      <Length>0.00</Length>
      <Width>0.00</Width>
      <Deleted>false</Deleted>
      <QtyStockSet>0</QtyStockSet>
      <DealerCost>0.0000</DealerCost>
      <PurchaseCost>0.0000</PurchaseCost>
      <XMLData />
    </NB_Store_ModelInfo>
  </M>
<I></I>
  <D></D>
  <C></C>
  <options></options>
</P>

Check which version of NB_Store your using...make sure it's the latest beta v2.0.6 beta17....I'm going to make this stable at the begining of this week!

Regards,

Dave.

 

Dec 9, 2009 at 6:51 AM

Dave,

Just tested the import, and YES IT WORKED....

I haven't studied it yet, just did a cut and paste.

Now I have a benchmark I should be cool with it all now.

Thanks for your help.

JJ.

PS. Given I only have 7 more business days before Christmas Holidays, I'll go live in Jan. I just have to add some stuff to manage licenses. I'm having a play with DotNetMushroom RAD module, hoping I can use it. I'll let you know how I go.

Dec 10, 2009 at 1:00 AM

Dave,

Just got one small issue.

I've got the products linking to the categories, however it created all the categories as new level 1 categories.

I have the categoryCSV.ImportMapping as:

<NB_Store_CategoriesInfo>
  <CategoryID>[COL:5]</CategoryID>
  <PortalID>2</PortalID>
  <Archived>false</Archived>
  <CreatedByUser>-1</CreatedByUser>
  <CreatedDate>2009-12-09T17:03:51.47</CreatedDate>
  <ParentCategoryID>[COL:6]</ParentCategoryID>
  <ListOrder>1</ListOrder>
  <Lang>[LANG]</Lang>
  <CategoryName>[COL:5]</CategoryName>
  <ParentName>[COL:6]</ParentName>
  <CategoryDesc></CategoryDesc>
  <Message></Message>
  <ProductCount>0</ProductCount>
  <ProductTemplate />
  <ListItemTemplate />
  <ListAltItemTemplate />
</NB_Store_CategoriesInfo>

I have the productCSV.ImportMapping as:

<P>
  <NB_Store_ProductsInfo>
    <ProductID></ProductID>
    <PortalID>[PORTALID]</PortalID>
    <TaxCategoryID>-1</TaxCategoryID>
    <Featured>false</Featured>
    <Archived>false</Archived>
    <CreatedByUser>-1</CreatedByUser>
    <CreatedDate>2009-12-09T17:03:51.47</CreatedDate>
    <IsDeleted>false</IsDeleted>
    <ProductRef>[COL:2]</ProductRef>
    <Lang>[LANG]</Lang>
    <Summary>[COL:7]</Summary>
    <Description></Description>
    <Manufacturer>[COL:1]</Manufacturer>
    <ProductName>[COL:3]</ProductName>
    <XMLData></XMLData>
  </NB_Store_ProductsInfo>
  <M>
    <NB_Store_ModelInfo>
      <ModelID></ModelID>
      <ProductID></ProductID>
      <ListOrder>1</ListOrder>
      <UnitCost>[COL:4]</UnitCost>
      <Barcode />
      <ModelRef>[COL:2]</ModelRef>
      <Lang>[LANG]</Lang>
      <ModelName>[COL:3]</ModelName>
      <QtyRemaining>-1</QtyRemaining>
      <QtyTrans>0</QtyTrans>
      <QtyTransDate></QtyTransDate>
      <ProductName>[COL:3]</ProductName>
      <PortalID>[PORTALID]</PortalID>
      <Weight>0.00</Weight>
      <Height>0.00</Height>
      <Length>0.00</Length>
      <Width>0.00</Width>
      <Deleted>false</Deleted>
      <QtyStockSet>0</QtyStockSet>
      <DealerCost>0.0000</DealerCost>
      <PurchaseCost>0.0000</PurchaseCost>
      <XMLData />
    </NB_Store_ModelInfo>
  </M>
<I></I>
  <D></D>
  <C>
     <NB_Store_ProductCategoryInfo>
           <ProductID></ProductID>
          <CategoryID>[COL:5]</CategoryID>
          <ParentCategoryID>[COL:6]</ParentCategoryID>
      </NB_Store_ProductCategoryInfo>
  </C>
  <options></options>
</P>

 

CSV Data is (sample only)

Sunbelt Software,M401IEC1P10,Vipre Enterprise 5-User License Pack 2 Year - COMPETITIVE UPGRADE,12.47,5 User License Packs,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 5 user pack
Sunbelt Software,M401IEC1P20,Vipre Enterprise 5-User License Pack 3 Year - COMPETITIVE UPGRADE,22.09,5 User License Packs,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 5 user pack
Sunbelt Software,M401IEC1S10,Vipre Enterprise 5-User License Pack 2 Year,12.47,5 User License Packs,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 5 user pack
Sunbelt Software,M401IEC1S20,Vipre Enterprise 5-User License Pack 3 Year,22.09,5 User License Packs,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 5 user pack
Sunbelt Software,M401IEC2P10,Vipre Enterprise 10-User License Pack 2 Year - COMPETITIVE UPGRADE,24.5,10 User License Packs,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 10 User pack
Sunbelt Software,M401IEC2P20,Vipre Enterprise 10-User License Pack 3 Year - COMPETITIVE UPGRADE,44.2,10 User License Packs,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 10 User pack
Sunbelt Software,M401IEC2S10,Vipre Enterprise 10-User License Pack 2 Year,24.5,10 User License Packs,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 10 User pack
Sunbelt Software,M401IEC2S20,Vipre Enterprise 10-User License Pack 3 Year,44.2,10 User License Packs,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 10 User pack
Sunbelt Software,M401IECAP10,Vipre Enterprise 11-24 Seats 2 Year - COMPETITIVE UPGRADE,16.44,11-24 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 11-24 pack
Sunbelt Software,M401IECAP20,Vipre Enterprise 11-24 Seats 3 Year - COMPETITIVE UPGRADE,18.41,11-24 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 11-24 pack
Sunbelt Software,M401IECAS10,Vipre Enterprise 11-24 Seats 2 Year,16.44,11-24 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 11-24 pack
Sunbelt Software,M401IECAS20,Vipre Enterprise 11-24 Seats 3 Year,18.41,11-24 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 11-24 pack
Sunbelt Software,M401IECBP10,Vipre Enterprise 25-49 Seats 2 Year - COMPETITIVE UPGRADE,16.44,25-49 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 25-49 pack
Sunbelt Software,M401IECBP20,Vipre Enterprise 25-49 Seats 3 Year - COMPETITIVE UPGRADE,18.41,25-49 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 25-49 pack
Sunbelt Software,M401IECBS10,Vipre Enterprise 25-49 Seats 2 Year,16.44,25-49 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 25-49 pack
Sunbelt Software,M401IECBS20,Vipre Enterprise 25-49 Seats 3 Year,18.41,25-49 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 25-49 pack
Sunbelt Software,M401IECCP10,Vipre Enterprise 50-99 Seats 2 Year - COMPETITIVE UPGRADE,16.44,50-99 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 50-99 pack
Sunbelt Software,M401IECCP20,Vipre Enterprise 50-99 Seats 3 Year - COMPETITIVE UPGRADE,18.41,50-99 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 50-99 pack
Sunbelt Software,M401IECCS10,Vipre Enterprise 50-99 Seats 2 Year,16.44,50-99 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 50-99 pack
Sunbelt Software,M401IECCS20,Vipre Enterprise 50-99 Seats 3 Year,18.41,50-99 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 50-99 pack
Sunbelt Software,M401IECDP10,Vipre Enterprise 100-199 Seats 2 Year - COMPETITIVE UPGRADE,16.44,100-199 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 100-199 pack
Sunbelt Software,M401IECDP20,Vipre Enterprise 100-199 Seats 3 Year - COMPETITIVE UPGRADE,18.41,100-199 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 100-199 pack
Sunbelt Software,M401IECDS10,Vipre Enterprise 100-199 Seats 2 Year,16.44,100-199 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 100-199 pack
Sunbelt Software,M401IECDS20,Vipre Enterprise 100-199 Seats 3 Year,18.41,100-199 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 100-199 pack
Sunbelt Software,M401IECEP10,Vipre Enterprise 200-499 Seats 2 Year - COMPETITIVE UPGRADE,16.44,200-499 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 200-499 pack
Sunbelt Software,M401IECEP20,Vipre Enterprise 200-499 Seats 3 Year - COMPETITIVE UPGRADE,18.41,200-499 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 200-499 pack
Sunbelt Software,M401IECES10,Vipre Enterprise 200-499 Seats 2 Year,16.44,200-499 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 200-499 pack
Sunbelt Software,M401IECES20,Vipre Enterprise 200-499 Seats 3 Year,18.41,200-499 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 200-499 pack
Sunbelt Software,M401IECFP10,Vipre Enterprise 500-999 Seats 2 Year - COMPETITIVE UPGRADE,7.5,500-999 Seats,Vipre Enterprise,1 year of additional maintenance with Competitive Upgrade of Vipre Enterprise 500-999 pack
Sunbelt Software,M401IECFP20,Vipre Enterprise 500-999 Seats 3 Year - COMPETITIVE UPGRADE,13.5,500-999 Seats,Vipre Enterprise,2 years additional maintenance with Competitive Upgrade of Vipre Enterprise 500-999 pack
Sunbelt Software,M401IECFS10,Vipre Enterprise 500-999 Seats 2 Year,7.5,500-999 Seats,Vipre Enterprise,1 year of additional maintenance with the purchase of Vipre Enterprise 500-999 pack
Sunbelt Software,M401IECFS20,Vipre Enterprise 500-999 Seats 3 Year,13.5,500-999 Seats,Vipre Enterprise,2 year additional maintenance with the purchase of Vipre Enterprise 500-999 pack
Sunbelt Software,M450IEC1P1A,Vipre Email Security 5-User License Pack 2 Year - COMPETITIVE UPGRADE,68.17,5 User License Packs,Vipre Email Security,1 year of additional maintenance with Competitive Upgrade of Vipre Email Security 5 user pack
Sunbelt Software,M450IEC1P2A,Vipre Email Security 5-User License Pack 3 Year - COMPETITIVE UPGRADE,122.71,5 User License Packs,Vipre Email Security,2 years additional maintenance with Competitive Upgrade of Vipre Email Security 5 user pack
Sunbelt Software,M450IEC1S1A,Vipre Email Security 5-User License Pack 2 Year,68.17,5 User License Packs,Vipre Email Security,1 year of additional maintenance with the purchase of Vipre Email Security 5 user pack
Sunbelt Software,M450IEC1S2A,Vipre Email Security 5-User License Pack 3 Year,122.71,5 User License Packs,Vipre Email Security,2 year additional maintenance with the purchase of Vipre Email Security 5 user pack
Sunbelt Software,M450IEC2P1A,Vipre Email Security 10-User License Pack 2 Year - COMPETITIVE UPGRADE,115.9,10 User License Packs,Vipre Email Security,1 year of additional maintenance with Competitive Upgrade of Vipre Email Security 10 User pack
Sunbelt Software,M450IEC2P2A,Vipre Email Security 10-User License Pack 3 Year - COMPETITIVE UPGRADE,208.62,10 User License Packs,Vipre Email Security,2 years additional maintenance with Competitive Upgrade of Vipre Email Security 10 User pack
Sunbelt Software,M450IEC2S1A,Vipre Email Security 10-User License Pack 2 Year,115.9,10 User License Packs,Vipre Email Security,1 year of additional maintenance with the purchase of Vipre Email Security 10 User pack
Sunbelt Software,M450IEC2S2A,Vipre Email Security 10-User License Pack 3 Year,208.62,10 User License Packs,Vipre Email Security,2 year additional maintenance with the purchase of Vipre Email Security 10 User pack
Sunbelt Software,M450IECAP1A,Vipre Email Security 11-24 Seats 2 Year - COMPETITIVE UPGRADE,10.91,11-24 Seats,Vipre Email Security,1 year of additional maintenance with Competitive Upgrade of Vipre Email Security 11-24 pack
Sunbelt Software,M450IECAP2A,Vipre Email Security 11-24 Seats 3 Year - COMPETITIVE UPGRADE,19.63,11-24 Seats,Vipre Email Security,2 years additional maintenance with Competitive Upgrade of Vipre Email Security 11-24 pack
Sunbelt Software,M450IECAS1A,Vipre Email Security 11-24 Seats 2 Year,10.91,11-24 Seats,Vipre Email Security,1 year of additional maintenance with the purchase of Vipre Email Security 11-24 pack
Sunbelt Software,M450IECAS2A,Vipre Email Security 11-24 Seats 3 Year,19.63,11-24 Seats,Vipre Email Security,2 year additional maintenance with the purchase of Vipre Email Security 11-24 pack
Sunbelt Software,M450IECBP1A,Vipre Email Security 25-49 Seats 2 Year - COMPETITIVE UPGRADE,10.23,25-49 Seats,Vipre Email Security,1 year of additional maintenance with Competitive Upgrade of Vipre Email Security 25-49 pack
Sunbelt Software,M450IECBP2A,Vipre Email Security 25-49 Seats 3 Year - COMPETITIVE UPGRADE,18.41,25-49 Seats,Vipre Email Security,2 years additional maintenance with Competitive Upgrade of Vipre Email Security 25-49 pack
Sunbelt Software,M450IECBS1A,Vipre Email Security 25-49 Seats 2 Year,10.23,25-49 Seats,Vipre Email Security,1 year of additional maintenance with the purchase of Vipre Email Security 25-49 pack
Sunbelt Software,M450IECBS2A,Vipre Email Security 25-49 Seats 3 Year,18.41,25-49 Seats,Vipre Email Security,2 year additional maintenance with the purchase of Vipre Email Security 25-49 pack
Sunbelt Software,M450IECCP1A,Vipre Email Security 50-99 Seats 2 Year - COMPETITIVE UPGRADE,9.54,50-99 Seats,Vipre Email Security,1 year of additional maintenance with Competitive Upgrade of Vipre Email Security 50-99 pack

 

It creates the categories that I have in column 5, but doens't link them to the parent categories. I have three parent categories, Vipre Consumer, Vipre Enterprise and Vipre Email Security.

What would be ideal if it created the parent categories also, if they didn't exist. Not necessary for this site but for others it will be.

 

JJ

 

 

 

 

Coordinator
Dec 14, 2009 at 3:49 PM

Hi JJ,

Yes, I'm aware of this, the workaround is to place you parent categories in the top of the CVS file as fake records, or simply create them before you start.

Maybe in a future version the "fake" records could be created automatically, so the parent categoies are created as needed.

Regards,

Dave

Dec 14, 2009 at 8:36 PM

Dave,

Given I only have three parent categories, creating them first would be fine, except that when I import the data, none of the child categories link to the parent categories. I end up with a whole bunch of parent categories.

To make it even worse, I have the situation where I have the following:

parent category 1

   sub category X

   sub category Y

parent category 2

   sub category X

   sub category Y

 

However, when I do the import all the products from the two sub categories end up mixed up together....

Do you have an ETA when this will be fixed. It's not a show stopper at the moment, given we are about to shut down for a month..... Australia goes on holiday from Christams Eve to Australia Day (Jan 26th).

JJ.

PS. Forecast temp for tomorrow is 39C!!!

 

Coordinator
Dec 15, 2009 at 8:37 AM

Hi JJ,

Strange, I have a simular situation and it works OK....Make sure the names of the categories you've created are exactly the same, I think it's case sensitive.

Probably the next time this will get looked at is the next release!!...not sure when that';s going to be yet!

Regards,

Dave.

P.S. -5C today.....(in South of France, but up in the mountains.....due to get colder still!!)