[% LxERP.t8("Hide help text") %]
-| [%- LxERP.t8('Column name') %] | -[%- LxERP.t8('Meaning') %] | -
|---|---|
| [%- HTML.escape(row.name) %] | -[%- HTML.escape(row.description) %] | -
| [%- p.row_ident %] | + [%- END %] +||||
|---|---|---|---|---|
+
|
+ [%- END %]
+
| [%- LxERP.t8('Column name') %] | +[%- LxERP.t8('Meaning') %] | +
|---|---|
| [%- HTML.escape(row.name) %] | +[%- HTML.escape(row.description) %] | +
+ [%- LxERP.t8("You can update existing contacts by providing the 'cp_id' column with their database IDs. Otherwise: ") %] [%- LxERP.t8('At least one of the columns #1, customer, customernumber, vendor, vendornumber (depending on the target table) is required for matching the entry to an existing customer or vendor.', 'cp_cv_id') %]
@@ -84,9 +114,32 @@ [%- ELSIF SELF.type == 'parts' %]- [%- LxERP.t8("If the article type is set to 'mixed' then a column called 'type' must be present.") %] + [1]: + [% LxERP.t8('The three columns "make_X", "model_X" and "lastcost_X" with the same number "X" are used to import vendor part numbers and vendor prices.') %] + [% LxERP.t8('The column triplets can occur multiple times with different numbers "X" each time (e.g. "make_1", "model_1", "lastcost_1", "make_2", "model_2", "lastcost_2", "make_3", "model_3", "lastcost_3" etc).') %] + [% LxERP.t8('The items are imported accoring do their number "X" regardless of the column order inside the file.') %] + [% LxERP.t8('The column "make_X" can contain either a vendor\'s database ID, a vendor number or a vendor\'s name.') %] +
++ [2]: + [% LxERP.t8('Onhand only sets the quantity in master data, not in inventory. This is only a legacy info field and will be overwritten as soon as a inventory transfer happens.') %] +
++ [3]: + [% LxERP.t8("If the article type is set to 'mixed' then a column called 'type' must be present.") %] [% LxERP.t8("Type can be either 'part' or 'service'.") %]
+ +[%- ELSIF SELF.type == 'orders' %] ++ [1]: + [% LxERP.t8('The column "datatype" must be present and must be at the same position / column in each data set. The values must be the row names (see settings) for order and item data respectively.') %] +
+
+ [2]:
+ [%- LxERP.t8('Amount and net amount are calculated by kivitendo. "verify_amount" and "verify_netamount" can be used for sanity checks.') %]
+ [%- LxERP.t8('If amounts differ more than "Maximal amount difference" (see settings), this item is marked as invalid.') %]
+
@@ -99,18 +152,24 @@
[% LxERP.t8("Hide settings") %]
+| [%- LxERP.t8('Number Format') %]: | - [% SET options = L.options_for_select([ '1.000,00', '1000,00', '1,000.00', '1000.00' ], default => SELF.profile.get('numberformat')) %] - [% L.select_tag('settings.numberformat', options, style => 'width: 300px') %] + [% L.select_tag('settings.numberformat', ['1.000,00', '1000,00', '1,000.00', '1000.00'], default = SELF.profile.get('numberformat'), style = 'width: 300px') %] | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| [%- LxERP.t8('Charset') %]: | -[% L.select_tag('settings.charset', L.options_for_select(SELF.all_charsets, default => SELF.profile.get('charset')), style => 'width: 300px') %] | +[% L.select_tag('settings.charset', SELF.all_charsets, default = SELF.profile.get('charset'), style = 'width: 300px') %] | ||||||||||||||||||
| [% FOREACH key = duplicate_fields.keys %] - + [% END %] | @@ -181,7 +240,7 @@ [% opts = [ [ 'no_check', LxERP.t8('Do not check for duplicates') ], [ 'check_csv', LxERP.t8('Discard duplicate entries in CSV file') ], [ 'check_db', LxERP.t8('Discard entries with duplicates in database or CSV file') ] ] %] - [% L.select_tag('settings.duplicates', L.options_for_select(opts, default => SELF.profile.get('duplicates')), style => 'width: 300px') %] + [% L.select_tag('settings.duplicates', opts, default = SELF.profile.get('duplicates'), style = 'width: 300px') %]||||||||||||||||||||