Friday 29 June 2012 4:41:29 pm - 2 replies
Hi,
I am trying to import images from a 3rd party database to ez using sqlimport.
I can import the images by providing full path to image , if the content object attibute is of image datatype.
But if I wanted to import from xmltext contain images, I cannot. for example the code below contain images cannot be imported using SQLIXMLInputParser
<Intro><img height="75" alt="" hspace="8" src="/UserFiles/Image/115/Viral_thumb.jpg" width="75" align="left" vspace="8" /><</Intro>
Is there anyway I can do this ?
thanks in advance
Modified on Friday 29 June 2012 4:44:58 pm by Romeo Antony
Monday 02 July 2012 11:33:20 pm
Finally somehow I have managed to import it . I know there is some other perfect solution exists.But I couldn't find it out. My solution as follows
Get the image name and unique id from xmltext
<id>54</id><Intro><img height="75" alt="" hspace="8" src="/UserFiles/Image/115/Viral_thumb.jpg" width="75" align="left" vspace="8" /><</Intro>
create a source handler in sqliimport to import the images as a separate field , for that, images needs to be copied in local directory. Problem is that images cannot be embed as it in external db. It will be mapped into into an image field within the class object.
Modified on Monday 02 July 2012 11:34:53 pm by Romeo Antony
You must be logged in to post messages in this topic!