This is an automated email from the ASF dual-hosted git repository.
mcasters pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hop.git
The following commit(s) were added to refs/heads/master by this push:
new 30a2f12e92 HOP-3933 Round decimal value to fit in scale in Numeric
field in Monetdb Bulk Loader
new 702e498be8 Merge pull request #1505 from sramazzina/HOP-3933
30a2f12e92 is described below
commit 30a2f12e92b037cca50e425ec24c3f7f0d4c0e7b
Author: Sergio Ramazzina <[email protected]>
AuthorDate: Fri May 27 11:52:50 2022 +0200
HOP-3933 Round decimal value to fit in scale in Numeric field in Monetdb
Bulk Loader
---
.../pipeline/transforms/monetdbbulkloader.adoc | 24 ++++-
.../monetdbbulkloader/MonetDbBulkLoader.java | 110 +++++++++++++--------
.../messages/messages_en_US.properties | 8 +-
.../messages/messages_it_IT.properties | 42 ++++----
4 files changed, 117 insertions(+), 67 deletions(-)
diff --git
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/monetdbbulkloader.adoc
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/monetdbbulkloader.adoc
index 4b3efbb55b..9c14801fd7 100644
---
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/monetdbbulkloader.adoc
+++
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/monetdbbulkloader.adoc
@@ -62,6 +62,8 @@ This tab contains the destination settings, buffer size and
location for the log
This tab contains information about the temporary files that are generated to
load the data.
+
+
|===
|Field|Description
@@ -82,4 +84,24 @@ This tab contains information about the temporary files that
are generated to lo
=== Output Fields tab
-This tab contains the source to target mapping.
\ No newline at end of file
+This tab contains the source to target mapping.
+
+|===
+|Field|Description
+
+|Target table field
+|Field containing the name of the field in the target table
+
+|Incoming stream field
+|Field containing the value we want to insert in target table
+
+|Format is ok
+|Set to Y if the incoming stream's field is the correct format according to
the target datatatype.
+
+*NOTE:*
+
+This setting is evaluated only when Lazy Conversion is applied.
+
+For example: imagine you are getting values from a text file, your incoming
data contains numbers or dates and Lazy Conversion is enabled in the input
transform. In this case, the data is not transformed internally to the target
data type and is managed as a String by Hop. By setting this flag to Y, we are
saying Hop that the incoming data's value is already in a format clearly
understandable by the target database according to the target datatype.
+
+|===
\ No newline at end of file
diff --git
a/plugins/transforms/monetdbbulkloader/src/main/java/org/apache/hop/pipeline/transforms/monetdbbulkloader/MonetDbBulkLoader.java
b/plugins/transforms/monetdbbulkloader/src/main/java/org/apache/hop/pipeline/transforms/monetdbbulkloader/MonetDbBulkLoader.java
index 56a4e012c9..710f1c8239 100644
---
a/plugins/transforms/monetdbbulkloader/src/main/java/org/apache/hop/pipeline/transforms/monetdbbulkloader/MonetDbBulkLoader.java
+++
b/plugins/transforms/monetdbbulkloader/src/main/java/org/apache/hop/pipeline/transforms/monetdbbulkloader/MonetDbBulkLoader.java
@@ -24,7 +24,9 @@ import org.apache.hop.core.exception.HopException;
import org.apache.hop.core.logging.ILogChannel;
import org.apache.hop.core.row.IRowMeta;
import org.apache.hop.core.row.IValueMeta;
+import org.apache.hop.core.row.ValueDataUtil;
import org.apache.hop.core.row.value.ValueMetaDate;
+import org.apache.hop.core.row.value.ValueMetaInteger;
import org.apache.hop.core.row.value.ValueMetaNumber;
import org.apache.hop.core.util.StreamLogger;
import org.apache.hop.core.util.Utils;
@@ -38,23 +40,25 @@ import org.monetdb.mcl.io.BufferedMCLReader;
import org.monetdb.mcl.io.BufferedMCLWriter;
import org.monetdb.mcl.net.MapiSocket;
+import java.math.BigDecimal;
+import java.math.RoundingMode;
import java.util.Date;
import java.util.List;
public class MonetDbBulkLoader extends BaseTransform<MonetDbBulkLoaderMeta,
MonetDbBulkLoaderData> {
private static final Class<?> PKG =
- MonetDbBulkLoaderMeta.class; // for i18n purposes, needed by
Translator2!!
+ MonetDbBulkLoaderMeta.class; // for i18n purposes, needed by
Translator2!!
private IRowMeta physicalTableRowMeta;
private static final String ERROR_LOADING_DATA = "Error loading data: ";
public MonetDbBulkLoader(
- TransformMeta transformMeta,
- MonetDbBulkLoaderMeta meta,
- MonetDbBulkLoaderData data,
- int copyNr,
- PipelineMeta pipelineMeta,
- Pipeline pipeline) {
+ TransformMeta transformMeta,
+ MonetDbBulkLoaderMeta meta,
+ MonetDbBulkLoaderData data,
+ int copyNr,
+ PipelineMeta pipelineMeta,
+ Pipeline pipeline) {
super(transformMeta, meta, data, copyNr, pipelineMeta, pipeline);
}
@@ -185,7 +189,7 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
}
protected void writeRowToMonetDB(IRowMeta rowMeta, Object[] r, DatabaseMeta
dm)
- throws HopException {
+ throws HopException {
if (data.bufferIndex == data.bufferSize || log.isDebug()) {
writeBufferToMonetDB(dm);
}
@@ -248,10 +252,10 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
}
}
break;
- //
- // formatter pattern to
- // the user.
- //
+ //
+ // formatter pattern to
+ // the user.
+ //
case IValueMeta.TYPE_TIMESTAMP:
case IValueMeta.TYPE_DATE:
// Keep the data format as indicated.
@@ -277,10 +281,10 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
// TIMESTAMP - DATE and TIME put together (e.g., 2012-12-21
15:51:36)
if (colMeta != null
- &&
colMeta.getOriginalColumnTypeName().equalsIgnoreCase("date")) {
+ &&
colMeta.getOriginalColumnTypeName().equalsIgnoreCase("date")) {
line.append(data.monetDateMeta.getString(value));
} else if (colMeta != null
- &&
colMeta.getOriginalColumnTypeName().equalsIgnoreCase("time")) {
+ &&
colMeta.getOriginalColumnTypeName().equalsIgnoreCase("time")) {
line.append(data.monetTimeMeta.getString(value));
} else {
//
colMeta.getOriginalColumnTypeName().equalsIgnoreCase("timestamp")
@@ -306,7 +310,19 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
if (dbl == null) {
line.append(data.nullrepresentation);
} else {
- line.append(dbl);
+ IValueMeta colMeta = null;
+ if (physicalTableRowMeta != null) {
+ colMeta = physicalTableRowMeta.getValueMeta(index);
+ }
+ IValueMeta valueMetaInt = new
ValueMetaInteger(valueMeta.getName());
+ Long precision = Long.valueOf(colMeta.getPrecision());
+ line.append(
+ ValueDataUtil.round(
+ valueMeta,
+ dbl,
+ valueMetaInt,
+ precision,
+ java.math.BigDecimal.ROUND_HALF_UP));
}
}
break;
@@ -315,11 +331,23 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
if (valueMeta.isStorageBinaryString() &&
meta.getFieldFormatOk()[i]) {
line.append(valueMeta.getString(valueData));
} else {
- String string = valueMeta.getString(valueData);
- if (string == null) {
+ BigDecimal bd = valueMeta.getBigNumber(valueData);
+ if (bd == null) {
line.append(data.nullrepresentation);
} else {
- line.append(string);
+ IValueMeta colMeta = null;
+ if (physicalTableRowMeta != null) {
+ colMeta = physicalTableRowMeta.getValueMeta(index);
+ }
+ IValueMeta valueMetaInt = new
ValueMetaInteger(valueMeta.getName());
+ Long precision = Long.valueOf(colMeta.getPrecision());
+ line.append(
+ ValueDataUtil.round(
+ valueMeta,
+ bd,
+ valueMetaInt,
+ precision,
+ java.math.BigDecimal.ROUND_HALF_UP));
}
}
break;
@@ -348,8 +376,8 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
String cmd;
String table = data.schemaTable;
String truncateStatement =
- meta.getDatabaseMeta()
- .getTruncateTableStatement(variables, meta.getSchemaName(),
meta.getTableName());
+ meta.getDatabaseMeta()
+ .getTruncateTableStatement(variables,
meta.getSchemaName(), meta.getTableName());
if (truncateStatement == null) {
throw new HopException("Truncate table is not supported!");
}
@@ -385,7 +413,7 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
logDetailed("getTransformname: " + getTransformName());
}
SqlStatement statement =
- meta.getTableDdl(variables, getPipelineMeta(), getTransformName(),
true, data, true);
+ meta.getTableDdl(variables, getPipelineMeta(), getTransformName(),
true, data, true);
if (log.isDetailed()) {
logDetailed("Statement: " + statement);
}
@@ -424,15 +452,15 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
}
cmdBuff
- .append("COPY ")
- .append(data.bufferIndex)
- .append(" RECORDS INTO ")
- .append(data.schemaTable)
- .append(" FROM STDIN USING DELIMITERS '")
- .append(data.separator)
- .append("','" + Const.CR + "','")
- .append(data.quote)
- .append("' NULL AS '" + nullRep + "';");
+ .append("COPY ")
+ .append(data.bufferIndex)
+ .append(" RECORDS INTO ")
+ .append(data.schemaTable)
+ .append(" FROM STDIN USING DELIMITERS '")
+ .append(data.separator)
+ .append("','" + Const.CR + "','")
+ .append(data.quote)
+ .append("' NULL AS '" + nullRep + "';");
String cmd = cmdBuff.toString();
// See if we need to execute extra SQL statements...
@@ -511,7 +539,7 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
// Confirming Database Connection is defined.
if (meta.getDatabaseMeta() == null) {
throw new HopException(
- BaseMessages.getString(PKG,
"MonetDbBulkLoaderMeta.GetSQL.NoConnectionDefined"));
+ BaseMessages.getString(PKG,
"MonetDbBulkLoaderMeta.GetSQL.NoConnectionDefined"));
}
}
@@ -571,16 +599,16 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
// Support parameterized database connection names
String connectionName = meta.getDbConnectionName();
if (!Utils.isEmpty(connectionName)
- && connectionName.startsWith("${")
- && connectionName.endsWith("}")) {
+ && connectionName.startsWith("${")
+ && connectionName.endsWith("}")) {
meta.setDatabaseMeta(getPipelineMeta().findDatabase(resolve(connectionName)));
}
// Schema-table combination...
data.schemaTable =
- meta.getDatabaseMeta(this)
- .getQuotedSchemaTableCombination(
- variables, meta.getSchemaName(), meta.getTableName());
+ meta.getDatabaseMeta(this)
+ .getQuotedSchemaTableCombination(
+ variables, meta.getSchemaName(),
meta.getTableName());
return true;
}
@@ -607,13 +635,13 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
}
protected static MapiSocket getMonetDBConnection(
- String host, int port, String user, String password, String db) throws
Exception {
+ String host, int port, String user, String password, String db)
throws Exception {
return getMonetDBConnection(host, port, user, password, db, null);
}
protected static MapiSocket getMonetDBConnection(
- String host, int port, String user, String password, String db,
ILogChannel log)
- throws Exception {
+ String host, int port, String user, String password, String db,
ILogChannel log)
+ throws Exception {
MapiSocket mserver = new MapiSocket();
mserver.setDatabase(db);
mserver.setLanguage("sql");
@@ -664,8 +692,8 @@ public class MonetDbBulkLoader extends
BaseTransform<MonetDbBulkLoaderMeta, Mone
* @param database to connect to
*/
protected static void executeSql(
- String query, String host, int port, String user, String password,
String db)
- throws Exception {
+ String query, String host, int port, String user, String password,
String db)
+ throws Exception {
MapiSocket mserver = null;
try {
mserver = getMonetDBConnection(host, port, user, password, db);
diff --git
a/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_en_US.properties
b/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_en_US.properties
index d61c1ff380..076fbe0cae 100644
---
a/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_en_US.properties
+++
b/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_en_US.properties
@@ -40,11 +40,11 @@ MonetDBBulkLoaderMeta.CheckResult.TableNameOK=Table name is
filled in.
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.Label=MonetDB Settings
MonetDBBulkLoaderDialog.NoSQLNeeds.DialogTitle=OK
MonetDBBulkLoaderDialog.Fields.Label=Fields to load\:
-MonetDBBulkLoaderDialog.ColumnInfo.FormatOK=Field format OK
+MonetDBBulkLoaderDialog.ColumnInfo.FormatOK=Format is ok
MonetDBBulkLoaderDialog.SQL.Button=\ &SQL
-MonetDBBulkLoaderDialog.ColumnInfo.StreamField=Incoming Stream field
+MonetDBBulkLoaderDialog.ColumnInfo.StreamField=Incoming stream field
MonetDBBulkLoaderMeta.CheckResult.CouldNotReadTableInfo=Couldn''t read the
table info, please check the table-name & permissions.
-MonetDBBulkLoaderDialog.ColumnInfo.TableField=Target Table field
+MonetDBBulkLoaderDialog.ColumnInfo.TableField=Target table field
MonetDBBulkLoaderMeta.Exception.UnableToReadTransformInfoFromXML=Unable to
read transform information from XML
MonetDBBulkLoaderDialog.Encoding.Label=Encoding
MonetDBBulkLoaderDialog.Log.LookingAtConnection=Looking at connection\:
@@ -102,7 +102,7 @@ MonetDBBulkLoaderDialog.Injection.TABLENAME=General: Target
Table
MonetDBBulkLoaderDialog.Injection.LOGFILE=General: Log File Location
MonetDBBulkLoaderDialog.Injection.TARGETFIELDS=Output: Target Table Fields
MonetDBBulkLoaderDialog.Injection.SOURCEFIELDS=Output: Stream Fields
-MonetDBBulkLoaderDialog.Injection.FIELDFORMATOK=Output: Field Format OK
+MonetDBBulkLoaderDialog.Injection.FIELDFORMATOK=Output: Format is ok
MonetDBBulkLoaderDialog.Injection.SEPARATOR=Settings: Field Separator
MonetDBBulkLoaderDialog.Injection.FIELDENCLOSURE=Settings: Field Enclosure
MonetDBBulkLoaderDialog.Injection.NULLVALUE=Settings: Represent null values as
diff --git
a/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_it_IT.properties
b/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_it_IT.properties
index a1c74f583a..4f12123a29 100644
---
a/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_it_IT.properties
+++
b/plugins/transforms/monetdbbulkloader/src/main/resources/org/apache/hop/pipeline/transforms/monetdbbulkloader/messages/messages_it_IT.properties
@@ -21,15 +21,15 @@ MonetDBBulkLoaderDialog.SQLError.DialogTitle=ERRORE
MonetDBBulkLoaderDialog.DoMapping.UnableToFindTargetFields.Title=Errore nel
prelievo dei campi di destinazione
MonetDBBulkLoaderDialog.DoMapping.UnableToFindSourceFields.Title=Errore nel
prelievo dei campi sorgente
MonetDBBulkLoaderMeta.CheckResult.DatabaseErrorOccurred=E'' avvenuto un errore
di database\:
-MonetDBBulkLoaderMeta.CheckResult.TransformReceivingDatas=Il passo \u00E8
connesso al precedente, ricezione di {0} campi
-MonetDBBulkLoaderDialog.InvalidConnection.DialogMessage=Prego selezionare una
connessione valida\!
-MonetDBBulkLoaderMeta.CheckResult.TransformReceivingInfoFromOtherTransforms=Il
passo sta ricevendo le informazioni dagli altri passi.
+MonetDBBulkLoaderMeta.CheckResult.TransformReceivingDatas=Il transform \u00E8
connesso al precedente, ricezione di {0} campi
+MonetDBBulkLoaderDialog.InvalidConnection.DialogMessage=Si prega selezionare
una connessione valida\!
+MonetDBBulkLoaderMeta.CheckResult.TransformReceivingInfoFromOtherTransforms=Il
transform sta ricevendo le informazioni dagli altri transforms.
MonetDBBulkLoaderDialog.FullyQuoteSQL.Label=Quotare interamente tutte le
istruzioni SQL utilizzate in un''esecuzione (es. "schema_name"."TableName")?
MonetDBBulkLoaderMeta.GetSQL.ErrorOccurred=Errore\:
MonetDBBulkLoaderDialog.LogFile.Label=File di log
MonetDBBulkLoaderDialog.InvalidConnection.DialogTitle=ERRORE
MonetDBBulkLoaderMeta.CheckResult.MissingFieldsToLoadInTargetTable=Campi da
caricare mancanti nella tabella di destinazione\:
-MonetDBBulkLoaderMeta.CheckResult.MissingFieldsInInput=Campi mancanti, non
trovati nell''input dai precedenti passi\:
+MonetDBBulkLoaderMeta.CheckResult.MissingFieldsInInput=Campi mancanti, non
trovati nell''input dai precedenti transforms\:
MonetDBBulkLoaderDialog.Truncate.Label=Tronca
MonetDBBulkLoaderDialog.Shell.Title=MonetDB bulk loader
MonetDBBulkLoaderDialog.Filetype.All=Tutti
@@ -38,29 +38,29 @@ MonetDBBulkLoaderMeta.CheckResult.TableNameOK=Il nome della
tabella \u00E8 stato
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.Label=Impostazioni MonetDB
MonetDBBulkLoaderDialog.NoSQLNeeds.DialogTitle=OK
MonetDBBulkLoaderDialog.Fields.Label=Campi da caricare\:
-MonetDBBulkLoaderDialog.ColumnInfo.FormatOK=Formato campo OK
+MonetDBBulkLoaderDialog.ColumnInfo.FormatOK=Formato campo ok
MonetDBBulkLoaderDialog.SQL.Button=&SQL
MonetDBBulkLoaderDialog.ColumnInfo.StreamField=Campo stream
-MonetDBBulkLoaderMeta.CheckResult.CouldNotReadTableInfo=Impossibile leggere le
informazioni della tabella, prego controllare il nome della tabella ed i
permessi.
+MonetDBBulkLoaderMeta.CheckResult.CouldNotReadTableInfo=Impossibile leggere le
informazioni della tabella, si prega di controllare nome della tabella e
permessi.
MonetDBBulkLoaderDialog.ColumnInfo.TableField=Campo tabella
-MonetDBBulkLoaderMeta.Exception.UnableToReadTransformInfoFromXML=Impossibile
leggere le informazioni del passo da XML
+MonetDBBulkLoaderMeta.Exception.UnableToReadTransformInfoFromXML=Impossibile
leggere le informazioni del transform da XML
MonetDBBulkLoaderDialog.Encoding.Label=Codifica
MonetDBBulkLoaderDialog.Log.LookingAtConnection=Ricerca connessione\:
MonetDBBulkLoaderMeta.Exception.ErrorGettingFields=Impossibile determinare i
campi richiesti.
-MonetDBBulkLoaderMeta.CheckResult.NoInputError=Nessun input ricevuto dagli
altri passi\!
-MonetDBBulkLoaderMeta.GetSQL.NotReceivingAnyFields=Nessuna ricezione di campi
dai precedenti passi. Controllare i precedenti passi per errori ed hop di
connessione.
+MonetDBBulkLoaderMeta.CheckResult.NoInputError=Nessun input ricevuto dagli
altri transforms\!
+MonetDBBulkLoaderMeta.GetSQL.NotReceivingAnyFields=Nessuna ricezione di campi
dai precedenti transforms. Controllare i precedenti transforms per errori ed
hop di connessione.
MonetDBBulkLoaderDialog.Tab.GeneralSettings.Label=Impostazioni generali
-MonetDBBulkLoaderDialog.DoMapping.UnableToFindSourceFields.Message=Non \u00E8
stato possibile recuperare i campi sorgente per questo passo a causa di un
errore\:
+MonetDBBulkLoaderDialog.DoMapping.UnableToFindSourceFields.Message=Non \u00E8
stato possibile recuperare i campi sorgente per questo transform a causa di un
errore\:
MonetDBBulkLoaderDialog.DoMapping.SomeFieldsNotFoundTitle=Alcuni campi
referenziati non sono stati trovati\!
MonetDBBulkLoaderMeta.Exception.TableNotFound=Impossibile determinare i campi
richiesti poich\u00E9 la tabella del database specificata non \u00E8 stata
trovata.
-MonetDBBulkLoaderDialog.NoSQLNeeds.DialogMessage=Nessun SQL \u00E8 necessario
per eseguire questo passo correttamente.
-MonetDBBulkLoaderMeta.GetSQL.NoConnectionDefined=Nessuna connessione \u00E8
stata definita in questo passo.
+MonetDBBulkLoaderDialog.NoSQLNeeds.DialogMessage=Nessun SQL \u00E8 necessario
per eseguire questo transform correttamente.
+MonetDBBulkLoaderMeta.GetSQL.NoConnectionDefined=Nessuna connessione \u00E8
stata definita in questo transform.
MonetDBBulkLoaderDialog.CouldNotBuildSQL.DialogMessage=Impossibile costruire
lo statement SQL a causa di un errore
-MonetDBBulkLoaderMeta.CheckResult.InvalidConnection=Prego selezionare o creare
una connessione\!
-MonetDBBulkLoaderDialog.Tab.ClearedDbCacheTitle=Puliziona Cache Database
+MonetDBBulkLoaderMeta.CheckResult.InvalidConnection=Seleziona o crea una
connessione\!
+MonetDBBulkLoaderDialog.Tab.ClearedDbCacheTitle=Pulizia cache database
MonetDBBulkLoaderDialog.DoMapping.SomeSourceFieldsNotFound=Questi campi
sorgente non sono stati trovati\: {0}
MonetDBBulkLoaderDialog.Encoding.Tooltip=Quale set di caratteri utilizzare per
i dati (vuoto significa codifica di default del workflow)
-MonetDBBulkLoaderDialog.DoMapping.UnableToFindTargetFields.Message=Non \u00E8
stato possibile recuperare i campi destinazione per questo passo a causa di un
errore\:
+MonetDBBulkLoaderDialog.DoMapping.UnableToFindTargetFields.Message=Non \u00E8
stato possibile recuperare i campi destinazione per questo transform a causa di
un errore\:
MonetDBBulkLoaderDialog.TargetTable.Label=Tabella di destinazione
MonetDBBulkLoaderDialog.FailedToGetFields.DialogTitle=Prelievo dei campi
fallito
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.ParameterGroup=Le API di
MonetDB e mclient utilizzano le seguenti impostazioni per interpretare i dati
in ingresso.
@@ -71,19 +71,19 @@
MonetDBBulkLoaderMeta.Exception.TableNotSpecified=Impossibile determinare i camp
MonetDBBulkLoaderMeta.CheckResult.TableExists=La tabella esiste ed \u00E8
possibile leggerne i dati.
MonetDBBulkLoaderDialog.DoMapping.SomeTargetFieldsNotFound=Questi campi
destinazione non sono stati trovati\: {0}
MonetDBBulkLoaderDialog.GetFields.Label=Preleva &campi
-MonetDBBulkLoaderDialog.Transformname.Label=Nome del passo
-MonetDBBulkLoaderMeta.CheckResult.MissingFieldsInInput3=Impossibile leggere i
campi dal precedente passo.
+MonetDBBulkLoaderDialog.Transformname.Label=Nome del transform
+MonetDBBulkLoaderMeta.CheckResult.MissingFieldsInInput3=Impossibile leggere i
campi dal precedente transform.
MonetDBBulkLoaderDialog.CouldNotBuildSQL.DialogTitle=Impossibile costruire SQL
MonetDBBulkLoaderDialog.Log.GettingKeyInfo=ricezione delle informazioni
chiave...
MonetDBBulkLoaderDialog.BufferSize.Label=Dimensione buffer (righe)
-MonetDBBulkLoaderDialog.FailedToGetFields.DialogMessage=Impossibile prelevare
i campi dai precedenti passi a causa di un errore
+MonetDBBulkLoaderDialog.FailedToGetFields.DialogMessage=Impossibile prelevare
i campi dai precedenti transforms a causa di un errore
MonetDBBulkLoaderDialog.Tab.ClearDbCache=Pulisci la cache DB di Hop
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.ParameterGroup.FieldEnclosure.Label=Campo
enclosure
-MonetDBBulkLoaderMeta.DefaultTableName=tabella di caricamento di destinazione
+MonetDBBulkLoaderMeta.DefaultTableName=Tabella di caricamento di destinazione
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.ParameterGroup.FieldSeparator.Label=Campo
separatore o delimitatore
-MonetDBBulkLoader.Log.ErrorInTransform=Errore nel passo, richiesto a tutti
l''interruzione a causa di\:
+MonetDBBulkLoader.Log.ErrorInTransform=Errore nel transform, richiesto a tutti
l''interruzione a causa di\:
MonetDBBulkLoaderDialog.Tab.OutputFields=Campi di output
-MonetDBBulkLoaderDialog.Tab.ClearedDbCacheMsg=La cache di Hop delle tabelle,
dei campi e dei metadati \u00E8 stata ripulita con successo.\n\nIl prelievo dei
campi richieder\u00E0 che il database sottostante esegua una query di
ispezione.\nQuesto risulta benefico per questo passo, poich\u00E9 consente al
passo di scegliere valori di default per\nil formato delle maschere che MonetDB
possa comprendere.\n\nPoi, si dovr\u00E0 cliccare il pulsante "Preleva campi"
per far corrispondere i campi [...]
+MonetDBBulkLoaderDialog.Tab.ClearedDbCacheMsg=La cache \u00E8 stata ripulita
con successo.\n\nIl prelievo dei campi richiede che il database sottostante
esegua una query d''ispezione allo scopo di scegliere valori di default per\nil
formato delle maschere che MonetDB possa comprendere.\n\nPremere il pulsante
"Preleva campi" per far corrispondere i campi dello stream con quelli
della\ntabella del database di destinazione in maniera che l''ordine dei campi
sia corretto.
MonetDBBulkLoaderDialog.Tab.MonetDBmclientSettings.ParameterGroup.NULLrepresentation.Label=Valori
NULL rappresentati come
MonetDBBulkLoaderMeta.CheckResult.AllFieldsFoundInInput=Tutti i campi sono
stati trovati nell''input stream.
MonetDBBulkLoaderMeta.GetSQL.NoTableDefinedOnConnection=Nessuna tabella \u00E8
definita su questa connessione.
