HOW TO: export repository media to files

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

HOW TO: export repository media to files

Postby faheemhameed » Thu Apr 13, 2006 12:19 pm

Here is the code.

Code: Select all
var serverName = "repository_server";
var SQL = "SELECT solution_name FROM servoy_solutions ORDER BY solution_name";
var dataset = databaseManager.getDataSetByQuery(serverName, SQL, null, 1000);

var solutionsArr = new Array();
for (var i = 1; i <= dataset.getMaxRowIndex(); i++) {
   dataset.rowIndex = i;
   solutionsArr[i] = dataset.solution_name;
}

var msg = "please select the solution name";
var solutionName = plugins.dialogs.showSelectDialog("", msg, solutionsArr);
if (solutionName == null) {
   return;
}

var destFolderObj = plugins.file.showDirectorySelectDialog("d:/temp/servoyImages/");
if (destFolderObj == null) {
   return;
}

var SQL = "SELECT * FROM servoy_solutions WHERE solution_name = ?";
var args = new Array();
args[0] = solutionName;
var dataset = databaseManager.getDataSetByQuery(serverName, SQL, args, 1);
dataset.rowIndex = 1;
var solutionId = dataset.solution_id;

//=========================================================================//
var SQL = "SELECT * FROM servoy_media WHERE solution_id = ?";
var args = new Array();
args[0] = solutionId;

var dataset = databaseManager.getDataSetByQuery(serverName, SQL, args, 1000);
for( var i = 1 ; i <= dataset.getMaxRowIndex() ; i++) {
   dataset.rowIndex = i;
   var destFilePath = destFolderObj.getAbsolutePath() + "\\" + dataset.name;
   var destFilePath = utils.stringReplace(destFilePath, "\\", "/");
   var destFileObj = plugins.file.convertStringToJSFile(destFilePath);   
   plugins.file.writeFile(destFileObj, dataset.media_data);
}
Hameed
Pilot simple software
Hong Kong
User avatar
faheemhameed
 
Posts: 763
Joined: Wed Sep 10, 2003 7:23 am

Postby Harjo » Thu Apr 13, 2006 1:49 pm

that can be handy!
great tip! :)
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby Westy » Thu Apr 13, 2006 3:38 pm

Thank you for sharing this!
Westy
 
Posts: 852
Joined: Fri Feb 13, 2004 5:27 am
Location: Lynnfield, Massachusetts USA

Postby ngervasi » Thu Apr 13, 2006 4:16 pm

Nice tip!
Nicola Gervasi
sintpro.com
SAN Partner
ngervasi
 
Posts: 1485
Joined: Tue Dec 21, 2004 12:47 pm
Location: Arezzo, Italy


Return to How To

Who is online

Users browsing this forum: No registered users and 6 guests

cron