Revision: 62170
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 6, 2013 07:31 by lmontealegre
Initial Code
using System; using System.Collections.Generic; using System.Text; using VisualWebRipper; namespace DataExport { class Program { static void Main(string[] args) { WrProject project = WrProject.LoadByName("projectName"); WrExportData data = project.OpenExportedData(); WrExportArguments exportArgs = new WrExportArguments(data, project); ExportData(exportArgs); } public static bool ExportData(WrExportArguments args) { try { //First we set the SQL we'll use to insert data into the database table. //The Database connection has already been set by defining a shared script //database. Visual Web Ripper will automatically open and close the //database connection. args.Database.SetSql("insert into properties (type,fors,title,description,area) values (@type,@fors,@title,@description,@area)"); args.Database.PrepareSql(); //Loop htough all eth export tables foreach (WrExportTableDefinition table in args.ExportData.TablesDefinitions.Tables) { //Open a data reader for the current table WrExportTableReader reader = args.ExportData.GetTableReader(table.TableName); try { //Loop though all rows in the current data table and write them to the target database. while (reader.Read()) { args.Database.SetParameterTextValue("@type", reader.GetStringValue("type")); args.Database.SetParameterTextValue("@fors", reader.GetStringValue("fors")); args.Database.SetParameterTextValue("@title", reader.GetStringValue("title")); args.Database.SetParameterTextValue("@description", reader.GetStringValue("description")); args.Database.SetParameterTextValue("@area", reader.GetStringValue("area")); args.Database.ExecuteNonQuery(); } } finally { reader.Close(); } } return true; } catch (Exception exp) { args.WriteDebug(exp.Message); return false; } } } }
Initial URL
Initial Description
The Application should load the export data for your project and then call the ExportData method.
Initial Title
Export Script - Sample1
Initial Tags
Initial Language
C#