diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -130133,8 +130133,8 @@
-
-
+
+
diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml
+++ b/src-db/database/sourcedata/AD_FIELD.xml
@@ -101151,7 +101151,7 @@
-
+
diff --git a/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java b/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java
new file mode 100644
--- /dev/null
+++ b/src-util/modulescript/src/org/openbravo/modulescript/ConvertImages.java
@@ -0,0 +1,78 @@
+package org.openbravo.modulescript;
+
+import java.awt.image.BufferedImage;
+import java.io.ByteArrayInputStream;
+import javax.imageio.ImageIO;
+import java.io.File;
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Properties;
+
+import net.sourceforge.jnlp.util.PropertiesFile;
+
+import org.openbravo.modulescript.ModuleScript;
+import org.openbravo.database.ConnectionProvider;
+import java.io.FileInputStream;
+import java.util.Properties;
+
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+import javax.imageio.ImageIO;
+
+public class ConvertImages extends ModuleScript {
+
+ @Override
+ public void execute() {
+ try {
+ String catalinabase=System.getenv("CATALINA_BASE");
+ if(catalinabase==null || catalinabase.equals("")){
+ return;
+ }
+ Properties properties = new Properties();
+ properties.load(new FileInputStream(getPropertiesFile()));
+ File imagesFolder=new File(catalinabase, "/webapps/"+properties.getProperty("context.name")+"/web/images/");
+ if(!imagesFolder.exists() || !imagesFolder.isDirectory()){
+ return;
+ }
+
+ ConnectionProvider cp = getConnectionProvider();
+ String sql="SELECT i.imageurl, i.ad_image_id from ad_image i, m_product p where ";
+ sql+=" i.ad_image_id=p.ad_image_id and binarydata is null order by i.ad_image_id ";
+ ResultSet rs=cp.getPreparedStatement(sql).executeQuery();
+ while(rs.next()){
+ String imageurl=rs.getString(1);
+ String imageid=rs.getString(2);
+ File imageFile=new File(imagesFolder, imageurl);
+ if(imageFile.exists()){
+ FileInputStream is = new FileInputStream(imageFile);
+ long length = imageFile.length();
+ byte[] bytes = new byte[(int)length];
+
+ int offset = 0;
+ int numRead = 0;
+ while (offset < bytes.length
+ && (numRead=is.read(bytes, offset, bytes.length-offset)) >= 0) {
+ offset += numRead;
+ }
+ is.close();
+ ByteArrayInputStream bis = new ByteArrayInputStream(bytes);
+ BufferedImage rImage = ImageIO.read(bis);
+ String qupdate="UPDATE ad_image set binarydata=?, width=?, height=? where ad_image_id=?";
+ PreparedStatement ps=cp.getPreparedStatement(qupdate);
+ ps.setObject(1, bytes);
+ ps.setLong(2, rImage.getWidth());
+ ps.setLong(3, rImage.getHeight());
+ ps.setString(4, imageid);
+ ps.executeUpdate();
+ cp.releasePreparedStatement(ps);
+ }
+ }
+ } catch (Exception e) {
+ return;
+ //This modulescript can fail in different ways.
+ //However, the build should continue without problems
+ }
+ return;
+ }
+}
\ No newline at end of file