Jana.safferova v 26. 3. 2023, 11:56

2023-03-26T11:56:34Z

← Starší verze		Verze z 26. 3. 2023, 11:56
Řádek 74:		Řádek 74:
	<string>@eta;saved_eta</string> <!-- ETA vykládky - exportuje pouze čas, datum je 1900-01-01 -->		<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 -->		<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>

	</ReflectedParameters>		</ReflectedParameters>
	</SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>		</SolverTechTashaPlugInsIOSolutionDatabaseExporterSettings>

Jana.safferova: založena nová stránka s textem „saved_route“

2022-08-17T14:23:57Z

založena nová stránka s textem „saved_route“

Nová stránka

<languages />
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>

<pre></pre>
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>

Known entities, etc.:

saved_route

saved_vehicle

saved_routestop

saved_eta

saved_leg

saved_order

saved_site

saved_solution

saved_starfishcost

{{AttachmentsSectionStart}}
* [[Media:TAS_Pokroile_Pluginy_Input,_Output_Export_SolverTech.Tasha.PlugIns.IO.SolutionDatabaseExporterDB_exporter_sloupce.txt]]

{{AttachmentsSectionEnd}}

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

Jana.safferova v 26. 3. 2023, 11:56

Jana.safferova: založena nová stránka s textem „saved_route“