Hierarchial Import not functioning

[IanS]

I have a site www.orbodi.com which is going to need a load of book images, and have a new design which grabs images from the publishers site (with their permission!), using a custom variable "ImageURL". The products to go on also have a few other custom variables necessary for proper functioning. I created and uploaded 1 test product manually, and all works well needs a little cleaning up, but basic functioning is there. I then proceeded to create an excel file containing 60 odd additional products, which includes the image url's and the data for the other custom variables. Used Actinic's file converter to create the hierarchial file, and proceed to import. Actinic 11 tells me it can't import this file because it is already open, which it isn't. I've changed file name, path, the lot, it flatly refuses to import the file every time because it is "already open". Anybody any ideas? Manual input is not an option, I'm looking at close to 14,000 books...

[NormanRouxel]

There are no forum posts containing "already open" since 2008 and these were nothing to do with Importing.

Is that the actual error message you are getting?

[NormanRouxel]

Also, you are generating invalid IMG tags that seem to embed the default product image inside your external one. I see (newlines added for clarity):

<div class="image_product">
<img 
	src="http://assets.hayhouse.co.uk/images/2010/09/5006@search.jpg" 
	border="0" 
	title="Angel Therapy Oracle Cards " 
	<img 
		src="invisible_image.gif" 
		border="0" 
		title="Angel Therapy Oracle Cards " 
		alt="Angel Therapy Oracle Cards "
	/>
</div>

[IanS]

This is the full message:

"A problem occured when trying to open up the file C:\Users\User\ActinicV11\Files to Import\HHCards.txt
please check the file and file name, make sure it isn't open in another program (eg excel) and try again."

The path is corect, the file name is correct, and it isn't open...

[IanS]

The Design to import the IMG from the external site, was developed by Actinic support...

[NormanRouxel]

Accuracy in posting problem reports helps.

However "A problem occured when trying to open" only appears twice on this forum and they're both unresolved 2009 posts.

It's possible that the error message is nothing to do with the file being already open. It may be invalid content. Try simplifying the file and re-importing. The usual way to do this sort of debugging is called a "binary chop". Remove half the variables and see if error persists. If not, the error was in the half you removed. If still there, error is in the half you're importing. You now amend file to remove half of the known faulty set and repeat.

However, as you are using custom Variables, it may be worth removing these first.

As for the bust IMG tag. Saying "was developed by Actinic support" doesn't really help much. It doesn't matter who broke it, I presume you want it fixed.

We'd need to see the code used in your Product Image Layout (possibly Standard Product Image - only you know what layout's being used there) in order to fix it.

[IanS]

Code in Standard Product Image layout, as requested:

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e" >
<actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20a%20Pop%2dUp%20Window%22">
<a href="<actinic:variable name=ExtendedInfoPageEncoded />" target="ActPopup" onclick="return ShowPopUp('<actinic:variable name=ExtendedInfoPageEncoded />',<actinic:variable name="ExtInfoWindowWidth" />,<actinic:variable name="ExtInfoWindowHeight" />);">
</actinic:block>
<actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20the%20Same%20Window%22" >
<a href="<actinic:variable name="ExtendedInfoPageName" />">
</actinic:block>
</actinic:block>

<actinic:block if="%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29" >
<a href="<actinic:variable name="ProductPageName" />">
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%20AND%20%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%3d%3d%20%27%27" >
<img src="<actinic:variable name="ProductImageFileName" />"
border="0"
width="<actinic:variable name="ProductImageWidth" />"
height="<actinic:variable name="ProductImageHeight" />"
title="<actinic:variable name="ProductName" encoding="strip"/>"
alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%20%21%3d%20%27%27" >
<img src="<actinic:variable name="ImageURL" />"
border="0"
title="<actinic:variable name="ProductName" encoding="strip"/>"
alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%3d%3d%20False">
<img src="<actinic:variable name="DefaultProductImage" />"
border="0"
title="<actinic:variable name="ProductName" encoding="strip"/>"
alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e%20OR%0d%28%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29%29" >
</a>
</actinic:block>

I just hope this makes sense to you, because it sure doesn't do anyting for me... If not, tell me how to get it the way it should look

[IanS]

It's possible that the error message is nothing to do with the file being already open. It may be invalid content. Try simplifying the file and re-importing. The usual way to do this sort of debugging is called a "binary chop". Remove half the variables and see if error persists. If not, the error was in the half you removed. If still there, error is in the half you're importing. You now amend file to remove half of the known faulty set and repeat.

Have it chopped down to the 1 field only, product reference, and still gives me the same error.

[Duncan Rounding]

The import may not be liking the @ symbol in the IMG URL. Try using %40 iinstead of @ in the string.
ie

http://assets.hayhouse.co.uk/images/2010/09/5006%40search.jpg

[IanS]

The import may not be liking the @ symbol in the IMG URL. Try using %40 iinstead of @ in the string.
ie

http://assets.hayhouse.co.uk/images/2010/09/5006%40search.jpg

Nope, no joy. I cut this right down to 1 field only, and it doesn't matter which one I use, it gives me the same error message every time. which is getting a little worrying....
The original file was generated from an Access 2007 export to Excel. That would not have anything to do with it by any chance?

[NormanRouxel]

Are you sure that Standard Product Image is the actual layout you are using?

If so, could you re-post the code but put it between
[c o d e]

and

[/c o d e]

tags. Note that you have to type "code" without any spaces between the letters.

[IanS]

Just looked at the design pages, and for the product page bulk area it tells me the layout used is Standard layout using css and it uses the "Standard Product Image".
tages don't make any difference so it seems

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e" >
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20a%20Pop%2dUp%20Window%22">
      <a href="<actinic:variable name=ExtendedInfoPageEncoded />" target="ActPopup" onclick="return ShowPopUp('<actinic:variable name=ExtendedInfoPageEncoded />',<actinic:variable name="ExtInfoWindowWidth" />,<actinic:variable name="ExtInfoWindowHeight" />);">
   </actinic:block>
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20the%20Same%20Window%22" >
      <a href="<actinic:variable name="ExtendedInfoPageName" />">
   </actinic:block>
</actinic:block>

<actinic:block if="%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29" >
	<a href="<actinic:variable name="ProductPageName" />">
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%20AND%20%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%3d%3d%20%27%27" >
   <img src="<actinic:variable name="ProductImageFileName" />"
      border="0"
      width="<actinic:variable name="ProductImageWidth" />"
      height="<actinic:variable name="ProductImageHeight" />"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%20%21%3d%20%27%27" >
   <img src="<actinic:variable name="ImageURL" />"
		border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%3d%3d%20False">
   <img src="<actinic:variable name="DefaultProductImage" />"
      border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e%20OR%0d%28%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29%29" >
   </a>
</actinic:block>

[NormanRouxel]

The code that weirdly isn't being generated is in fact in the layout. marked in red below:

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e" >
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20a%20Pop%2dUp%20Window%22">
      <a href="<actinic:variable name=ExtendedInfoPageEncoded />" target="ActPopup" onclick="return ShowPopUp('<actinic:variable name=ExtendedInfoPageEncoded />',<actinic:variable name="ExtInfoWindowWidth" />,<actinic:variable name="ExtInfoWindowHeight" />);">
   </actinic:block>
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20the%20Same%20Window%22" >
      <a href="<actinic:variable name="ExtendedInfoPageName" />">
   </actinic:block>
</actinic:block>

<actinic:block if="%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29" >
	<a href="<actinic:variable name="ProductPageName" />">
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%20AND%20%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%3d%3d%20%27%27" >
   <img src="<actinic:variable name="ProductImageFileName" />"
      border="0"
      width="<actinic:variable name="ProductImageWidth" />"
      height="<actinic:variable name="ProductImageHeight" />"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%20%21%3d%20%27%27" >
   <img src="<actinic:variable name="ImageURL" />"
		border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%3d%3d%20False">
   <img src="<actinic:variable name="DefaultProductImage" />"
      border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e%20OR%0d%28%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29%29" >
   </a>
</actinic:block>

[NormanRouxel]

However Actinic Support have missed out some condition code that is causing the Default Product Image to also be displayed even if your ImageURL is present. Best code would be (I've marked the bit they forgot in blue):

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e" >
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20a%20Pop%2dUp%20Window%22">
      <a href="<actinic:variable name=ExtendedInfoPageEncoded />" target="ActPopup" onclick="return ShowPopUp('<actinic:variable name=ExtendedInfoPageEncoded />',<actinic:variable name="ExtInfoWindowWidth" />,<actinic:variable name="ExtInfoWindowHeight" />);">
   </actinic:block>
   <actinic:block if="%3cactinic%3avariable%20name%3d%22ExtendedInformationType%22%20%2f%3e%20%3d%3d%20%22Opens%20in%20the%20Same%20Window%22" >
      <a href="<actinic:variable name="ExtendedInfoPageName" />">
   </actinic:block>
</actinic:block>

<actinic:block if="%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29" >
	<a href="<actinic:variable name="ProductPageName" />">
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%20AND%20%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%3d%3d%20%27%27" >
   <img src="<actinic:variable name="ProductImageFileName" />"
      border="0"
      width="<actinic:variable name="ProductImageWidth" />"
      height="<actinic:variable name="ProductImageHeight" />"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%20%21%3d%20%27%27" >
   <img src="<actinic:variable name="ImageURL" />"
		border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsProductImageDisplayed%22%20%2f%3e%20%3d%3d%20False%20AND%20%3cactinic%3avariable%20name%3d%22ImageURL%22%20%2f%3e%20%3d%3d%20%27%27" >
   <img src="<actinic:variable name="DefaultProductImage" />"
      border="0"
      title="<actinic:variable name="ProductName" encoding="strip"/>"
      alt="<actinic:variable name="ProductName" encoding="strip"/>" />
</actinic:block>

<actinic:block if="%3cactinic%3avariable%20name%3d%22IsPopUpDisplayedByImage%22%20%2f%3e%20OR%0d%28%28%3cactinic%3avariable%20name%3d%22PageType%22%20%2f%3e%20%3d%3d%20%22Section%22%29%20AND%20%0d%28%3cactinic%3avariable%20name%3d%22ProductListImageLink%22%20%2f%3e%20%3d%3d%201%29%29" >
   </a>
</actinic:block>

[IanS]

ok, you obviously know what you're doing. I on the other hand just try to sell lots of books... So, pardon my ignorance, are you telling me to remove the red "/>", and paste the blue bits on to the code line in the layout?