Announcement

**leehack** · 20-Oct-2007, 09:25 AM

If you backup before you do it, should be fine, although i would be more inclined to do it via flat file import myself. Remember to choose your most common weight and assign that as the default, you then do not need anything to be inserted on those products as they will use the site default weight.

**KevWal** · 03-Nov-2007, 05:37 PM

So, I took the advice and am trying to do it via a file import.

I exported everything, removed every line except products (and the heading for products), added the weight (in the Shipping Data vertical) sorted the Excel CSV comma issue by adding a last heading of 'FULL' and fully populating that vertical and then just ignored it in the import.

The import went fairly well, except for 70 or so (out of 500 products) gave the error:

"Line 3: The given section cannot be found, please check its name. The fragment is still imported but its link is disabled"

A few example lines that have the error are 3, 8 and 10 in the following.

Code:

Header:Product,Product Reference,Short Description,Full Description,Report Description,Price,Image Filename,Can be Ordered Online,Max Quantity Orderable,Min Quantity Orderable,Date Prompt Text,Other Info Prompt,Detail URL or File,Detail Link Text,Hide on Web Site,Shipping Data,Price Text,Button Text,Use External Data,Stock Checks Enabled,Stock in Hand,Stock Warning Level,Stock Suspend Level,Pricing Model,Ship Separately,V4 Tax 1 Data,IsDeleted,No Order Line For Main Product,Date Prompt Minimum Year,Date Prompt Maximum Year,Generate Popup Page,Extended Info Text,Extended Info Image,Display By Image,Display By Link,Display By Button,Extended Info Page Name,Extended Info Link Text,Digital Download File Name,Auto Ship,Product Group ID,Product Type,Original Product Reference,Product Duplicate Index,Fragment Layout,Linked Item ID,Link Type,Is Linked,Fragment Title,Fragment Text,Fragment Image File Name,Image Clickable,Link Text,Exclude From Froogle Data Feed,Thumbnail,nContentCategory,Include in BestSellers List,Include in New Products List,Include in Also Bought Lists,Exclude From Shipping,Shipping Supplement Applied Once,Shipping Supplement,Handling Supplement Applied Once,Handling Supplement,Alternative Weight,Shipping Category,Shipping Quantity,ExtendedInfoPageDesign,ExtInfoWindowWidth,ExtInfoWindowHeight,ProductLayout,ProductImageLayout,AttributeList,PriceLayout,ComponentList,ProductPriceDescription,ExtendedInformationLinks,AttributeColumnCount,ExtendedInformationType,PushButtonGrid,NumberAttributesInPushButtonGrid,YourPricePrefix,RetailPricePrefix,,FULL

Product,4,JEN .37,"Our follow up project to the successful .56 is the .37 (almost .40 performance from a small .25 sized case). Yes, I know its been done before!.. But we were keen to see how much power was available from a .25 case, before you needed to change the case size (and therefore weight ) to a .40 (or mid .38 ~ .40 sized case) \n\nOur answer was the J'EN .37....\n\n""It starts easily, goes well, has great transition and it?s very smooth. It?s a quart of power in a pint pot and if it came in a tin then I am sure Just Engines would say ?it does exactly what it says on the can!""\nSteve Dorling (AMI July 2005) - Read the <Actinic:Variable Name = 'link'/>.\n ",,4425,pictures\Jen37_p1.jpg,1,0,1,,,,,0,0.46,,,0,0,-1,0,0,2,0,301=1750=0=,0,0,0,0,1,"Typical prop figures on standard silencer; \n\nAPC 9x4 16,800\nAPC 10x4 15,100\nAPC 10x6 13,500\nAPC 11x6 10,500 \n\n(note; a reduction of a few hundred rpm can be expected using the quiet silencer) \n\n\n",,0,0,1,info_4.html,More...,,0,-1,0,,-1,,Engine Reviews & Comments|J'EN Reviews|JEN .37 AMI Review,2,1,,,,0,Full Review here,0,pictures\Jen37_p1_thumb.jpg,Standard,1,1,1,0,0,0,0,0,,Default,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,86,JEN .37 Standard Silencer,,,0,,1,0,1,,,,,1,0.1,,,0,0,-1,0,0,0,0,301=1750=0=,0,0,0,0,0,,,0,0,0,,,,0,-1,0,,-1,,,-1,0,,,,0,,0,,Standard,1,1,1,0,0,0,0,0,,,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,85,JEN .37 Quiet Silencer,,,425,,1,0,1,,,,,1,0.12,,,0,0,0,0,0,0,0,301=1750=0=,0,0,0,0,0,,,0,0,0,,,,0,-1,0,,-1,,,-1,0,,,,0,,0,,Standard,1,1,1,0,0,0,0,0,,,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,71,JEN .47,"As we've been asked for a .40 size engine for trainers and sport models that do not need the awesome grunt of the .56.  40 sized almost 50 performance\n\n(Camera flash has made it a bit blue! - see other J'EN pictures for correct colouring)\n\nCustomer Comments;\n* I recently purchased a .47 from you and am just emailing to say how impressed I am at the quality and performance - much better than another manufacturer's .46 it replaced!!. D. Everest\n\n* Paul, I just thought I'd email to say this JEN47 is a work of art - your photos do not do the quality and colour any justice - seems a shame to actually mount it up and run it!! S. Kidd\n",,4765,pictures\jen47_med.jpg,1,0,1,,,,,0,0.5,,,0,0,0,0,0,2,0,301=1750=0=,0,0,0,0,1,,pictures\jen47.jpg,1,0,0,info_71.html,More...,,0,-1,0,,-1,,,-1,0,,,,0,,0,pictures\jen47_thumb.jpg,Standard,1,1,1,0,0,0,0,0,,,1,Name and Info Text Displayed Below Image,1000,687,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,87,JEN .47 Standard Silencer,,,0,,1,0,1,,,,,1,0.1,,,0,0,0,0,0,0,0,301=1750=0=,0,0,0,0,0,,,0,0,0,,,,0,-1,0,,-1,,,-1,0,,,,0,,0,,Standard,1,1,1,0,0,0,0,0,,,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,72,JEN .57,"We?ve been working for more than 2 years on this project - to see how far you can bore and stroke a .40 case before it either doesn?t work, or becomes too fragile.  We tried every piston and liner combination from .52 to .57 and after success with the .56 we have now arrived at a very nice .57!\n\n(Camera flash has made it a bit blue! - see other J'EN pictures for correct colouring)\n\n""The JEN56 is indeed a .40 size package that thinks it's a 60."" \nMalc Pinnock, (RCM&E September 2004) - Read the <Actinic:Variable Name = 'link'/>\n",,5361,pictures\jen56_p1.jpg,1,0,1,,,,,0,0.5,,,0,0,-1,0,0,2,0,301=1750=0=,0,0,0,0,1,"Performance; (ABC rated @ 1.8HP/17000)\nSuper Quiet Silencer, 13x6 @ 10,400\n(compares to ASP .52 tested same day, same plug etc..10,100)\n(and compares with most Chinese .61s we service @ 10,200)\nGenesis Throttle Pipe, 13x4 @ 11,700\n(a friend then brought round his rather expensive .50;\nsame day, same plug, same fuel, same throttle pipe @ 11,850) \n\nSummary; more performance than our best selling .52 and .53 engines ? almost as good as an engine twice the price! ? and as good as most of the .60/.61s around!!\n\nClearly we can?t guarantee these figures on every engine ? but it gives a true indication of the awesome performance for such a small, light unit.\n\n!!<<strong>>!!JEN .56 Performance Comparison!!<</strong>>!!\n\n!!<<strong>>!!Test 1!!<</strong>>!!\n\nAll engines tested same day (September 11th 2003, a nice warm sunny day - almost ideal test conditions), same plug, same fuel (17% oil, 5% nitro), same prop (all APC), and silencers as provided with engines.\n\n!!<<table border=""1"" cellpadding=""6""><tr><td>Prop. <td>ASP 52 <sup>1</sup><td>C 61 <td>JEN 56 <sup>1</sup> </tr>\n<tr><td>11x6 <td>13000<td>&nbsp <td>13000 </tr>\n<tr><td>11x7 <td>11700 <td>11800 <td>11800 </tr>\n<tr><td>12x6 <td>11000  <td>&nbsp <td>11100 </tr> \n<tr><td>13x4 <td>11800 <td>&nbsp <td>12000  </tr>\n<tr><td>13x6 <td>10100 <td>10200 <td>10400  </tr>\n</table>>!!\n\n!!<<strong>>!!Test 2!!<</strong>>!!\n\nBoth engines tested same day (April 17th 2004, a cool, overcast day - which just shows how temperature and humidity can affect performance) same plug, same fuel (18% oil, 5% nitro), same prop (all APC), and silencers as provided with engines (see below).\n\n!!<<table border=""1"" cellpadding=""6"">\n<tr><td>Prop. <td>ASP 52 <sup>1</sup><td>JEN 56 <sup>1</sup><td>JEN 56 <sup>2</sup></tr>\n<tr><td>11x6 <td>12200<td>12200<td>12500</tr>\n<tr><td>&nbsp<td>&nbsp<td>&nbsp <td>&nbsp</tr>\n<tr><td>13x6 <td>9500<td>9800<td>10000 </tr>\n</table>>!!\n\n!!<<strong>>!!Test 3!!<</strong>>!!\n\nThe factory sent the !!<<strong>>!!1st production engine!!<</strong>>!! via express carrier airmail. Engines tested same day (April 27th 2004, a cool, overcast day with occasional rain) same plug, same fuel (18% oil, 5% nitro), same prop (all APC), and silencers as provided with engines (see below).\n\n!!<<table border=""1"" cellpadding=""6"">\n<tr><td>Prop. <td>ASP 52 <sup>1</sup><td>JEN 56 <sup>1</sup></tr>\n<tr><td>11x6 <td>12400<td>12400 </tr>\n<tr><td>&nbsp<td>&nbsp<td>&nbsp </tr>\n<tr><td>13x6 <td>9600<td>10100 </tr>\n</table>>!!\n\nNotes\n\n!!<<sup>1</sup>>!! Super Quiet silencer \n!!<<sup>2</sup>>!! Standard Large Volume silencer average results (typically 200-400rpm up on the Super Quiet Silencer results on smaller props (but a fair bit noisier!!) and 200-300rpm up on larger props)\n\nC 61 is typical figures recorded when we have serviced 'Chinese .61s' with baffled silencer\n for comparison, see [link] done on a different day - hence slightly different performance figures - but still good for comparison reasons)\n\n\n",,0,0,1,info_72.html,Click here for Performance Data,,0,-1,0,,-1,,Engine Reviews & Comments|J'EN Reviews|JEN .56 RCM&E Review,2,1,,,,0,Full Review here,0,pictures\jen56_p1_thumb.jpg,Standard,1,1,1,0,0,0,0,0,,,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0
Product,88,JEN .57 Standard Silencer,,,0,,1,0,1,,,,,1,0.12,,,0,0,0,0,0,0,0,301=1750=0=,0,0,0,0,0,,,0,0,0,,,,0,-1,0,,-1,,,-1,0,,,,0,,0,,Standard,1,1,1,0,0,0,0,0,,,1,,,,,,,,,,Standard Extended Information Links,,,,0,,,,0

I am unable to tell the difference between lines that failed and lines that didnt, I am not even sure how it is counting line numbers, starting at the first line of the file? counting the blank line? starting at the first product?

Looking in Actinic I can't find anything broken, but I dont want to just leave it and hope understandably....

All help appretiated.

P.S. I remembered the other Excel problem, it doesnt put the same things in double quotes ("), so I re made the changes above in a plain txt editor eithout using Excel at all, so exactly the same number of commas per line, quotes in the same places etc, but I still get the same error.

Thanks
Kevin

**KevWal** · 03-Nov-2007, 06:51 PM

Answering my own question, I finally manged to get it to work (well working around the issue) with no errors by removing all verticals except the 'Product' descriptor, the 'Product Ref' and the 'Shipping Data' (ie weight) vertical.

Inputing just these verticals works without errors.

Cheers
Kev

Announcement

Adding Shipping Weight to all products & Actinic Database

Adding Shipping Weight to all products & Actinic Database

Comment

Comment

Comment