TAS:Pokročilé/Pluginy/Input, Output/Export/SolverTech.Tasha.PlugIns.IO.SolutionDatabaseExporter
Modul, který exportuje hodnoty z řešení pomocí SQL příkazu.
Exportuje jen Trasy označené Na Export (Marked Export).
Předtím spustí SaveSolutionToScenarioCommand
Příklad pro Distrimo. Update DBF databáze.
<?xml version="1.0" encoding="utf-8"?> <SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema%22 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance%22> <ExporterCaption>Distrimo Export do databáze</ExporterCaption> <!--choose one of the following db providers avaiable--> <DbProvider>odbc</DbProvider> <ConnectionString>DSN=TASHA</ConnectionString> <!--sql command to execute on every job or order which is served in solution--> <ServedCommandText>UPDATE dba.hl_pohyb SET stav=1 where dba.hl_pohyb.cis_dokl=? and dba.hl_pohyb.stav=6</ServedCommandText> <!--sql command to execute on every job or order which is not served in solution--> <NotServedCommandText>UPDATE dba.hl_pohyb SET stav=6 where dba.hl_pohyb.cis_dokl=?</NotServedCommandText> <!--choose if command runs on job or order, only one possible--> <RunOnEntityType>order</RunOnEntityType> <!--list of reflected values of properties on order or job added as parameters to sql for example stop[1].location.address--> <ReflectedParameters> <string>otaznikovyparametr;id_objednavky</string> </ReflectedParameters> </SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>
Příklad pro export do SQL databáze - nová verze exporteru:
<?xml version="1.0" encoding="utf-8"?> <SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema%22 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance%22> <ExporterCaption>Database Exporter</ExporterCaption> <!--choose one of the following db providers avaiable--> <DbProvider>mssql</DbProvider> <!-- vybrat typ databáze --> <ConnectionString>SERVER = localhost\sqlexpress; DATABASE = tasha_581;Integrated Security=SSPI;</ConnectionString> <!--sql command to execute on every job or order which is served in solution--> <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> <!--sql command to execute on every job or order which is not served in solution--> <NotServedCommandText></NotServedCommandText> <!--choose if command runs on job or order, only one possible--> <RunOnEntityType>job</RunOnEntityType> <!-- vybrat, jestli má export bežet na provni job nebo order --> <!--list of reflected values of properties on order or job added as parameters to sql. Splitted value by semicolon ; . Firts part is parameter name (used in sql command) second is reflected value--> <ReflectedParameters> <string>@zbozi;zbozist</string> <!-- dynamický sloupec na jobu --> <string>@objednavka;identifier</string> <!-- název (identifier) jobu --> <string>@nazev;stops[1].location.name</string> <!-- název vykládky --> <string>@adresa;stops[1].location.address</string> <!-- adresa vykládky --> <string>@vozidlo;saved_vehicle.identifier</string> <!-- název (identifikátor) vozidla --> <string>@ridic;saved_vehicle.driver.identifier</string> <!-- identifikátor (nikoliv jméno) řidiče --> <string>@eta;saved_eta</string> <!-- ETA vykládky - exportuje pouze čas, datum je 1900-01-01 --> <string>@poradi;saved_order</string> <!-- pořadí jobu na routě, pozor, nakládka v depu má pořadí 1, první vykládka pořadí 2 --> </ReflectedParameters> </SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>
Známé entity apod.:
saved_route
saved_vehicle
saved_routestop
saved_eta
saved_leg
saved_order
saved_site
saved_solution
saved_starfishcost