TAS:Pokročilé/Pluginy/Input, Output/Export/SolverTech.Tasha.PlugIns.IO.SolutionDatabaseExporter/en

A module that exports values from the solution using an SQL command.

It exports only Routes marked for Export (Marked Export).

Before that it runs SaveSolutionToScenarioCommand

Example for Distrimo. Update DBF database.

<?xml version="1.0" encoding="utf-8"?> <SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ExporterCaption>Distrimo Export do databáze</ExporterCaption>
<DbProvider>odbc</DbProvider>
<ConnectionString>DSN=TASHA</ConnectionString>
<ServedCommandText>UPDATE dba.hl_pohyb SET stav=1 where dba.hl_pohyb.cis_dokl=? and dba.hl_pohyb.stav=6</ServedCommandText>
<NotServedCommandText>UPDATE dba.hl_pohyb SET stav=6 where dba.hl_pohyb.cis_dokl=?</NotServedCommandText>
<RunOnEntityType>order</RunOnEntityType>
<ReflectedParameters>
<string>otaznikovyparametr;id_objednavky</string>
</ReflectedParameters>

</SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>

Example for export to SQL database - new version of exporter:

<?xml version="1.0" encoding="utf-8"?> <SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

 <ExporterCaption>Database Exporter</ExporterCaption>
 <DbProvider>mssql</DbProvider> 
 <ConnectionString>SERVER = localhost\sqlexpress; DATABASE = tasha_581;Integrated Security=SSPI;</ConnectionString>
 <ServedCommandText>
  <![CDATA[
   INSERT INTO [dbo].[export]
   (zbozi
   ,cislo_objednavky
   ,nazev
   ,adresa
   ,vozidlo
   ,ridic
   ,eta
   ,poradi)
    
   VALUES
   (@zbozi
   ,@objednavka
   ,@nazev
   ,@adresa
   ,@vozidlo
   ,@ridic
   ,@eta
   ,@poradi)

]]>

 </ServedCommandText>
 <NotServedCommandText></NotServedCommandText>
 <RunOnEntityType>job</RunOnEntityType> 
 <ReflectedParameters>
   <string>@zbozi;zbozist</string> 
   <string>@objednavka;identifier</string> 
   <string>@nazev;stops[1].location.name</string> 
   <string>@adresa;stops[1].location.address</string> 
   <string>@vozidlo;saved_vehicle.identifier</string> 
   <string>@ridic;saved_vehicle.driver.identifier</string> 
   <string>@eta;saved_eta</string> 
   <string>@poradi;saved_order</string> 
 </ReflectedParameters>

</SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>

 </ReflectedParameters>

</SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>

Known entities, etc.:

saved_route

saved_vehicle

saved_routestop

saved_eta

saved_leg

saved_order

saved_site

saved_solution

saved_starfishcost

• Media:TAS_Pokroile_Pluginy_Input,_Output_Export_SolverTech.Tasha.PlugIns.IO.SolutionDatabaseExporterDB_exporter_sloupce.txt