[%- LxERP.t8('Existing profiles') %]:
- [% L.select_tag('profile.id', L.options_for_select(SELF.all_profiles, title => 'name', default => SELF.profile.id), style => 'width: 300px') %]
+ [% L.select_tag('profile.id', SELF.all_profiles, title_key = 'name', default = SELF.profile.id, style = 'width: 300px') %]
[% L.submit_tag('action_new', LxERP.t8('Load profile')) %]
@@ -45,20 +52,134 @@
[%- LxERP.t8('Help on column names') %]
+
+
+
+
+
[% LxERP.t8("Hide help text") %]
+
+ [%- IF SELF.worker.is_multiplexed %]
+
+
+ [%- FOREACH p = SELF.worker.profile %]
+ [%- p.row_ident %]
+ [%- END %]
+
+
+ [%- FOREACH p = SELF.worker.profile %]
+ [% SET ri = p.row_ident %]
+
+
+
+ [%- LxERP.t8('Column name') %]
+ [%- LxERP.t8('Meaning') %]
+
+
+ [%- FOREACH row = SELF.displayable_columns.$ri %]
+
+ [%- HTML.escape(row.name) %]
+ [%- HTML.escape(row.description) %]
+
+ [%- END %]
+
+
+ [%- END %]
+
+
+ [%- ELSE %]
+
+
+ [%- LxERP.t8('Column name') %]
+ [%- LxERP.t8('Meaning') %]
+
+
+ [%- FOREACH row = SELF.displayable_columns %]
+
+ [%- HTML.escape(row.name) %]
+ [%- HTML.escape(row.description) %]
+
+ [%- END %]
+
+ [%- END %]
+
+[%- IF SELF.type == 'contacts' %]
+
+ [%- 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') %]
+
+
+[%- ELSIF SELF.type == 'addresses' %]
+
+ [%- 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.', 'trans_id') %]
+
+
+[%- ELSIF SELF.type == 'parts' %]
+
+ [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', 'service' or 'assembly'.") %]
+ [% LxERP.t8("Assemblies can not be imported (yet). But the type column is used for sanity checks on price updates in order to prevent that articles with the wrong type will be updated.") %]
+
+
+[%- ELSIF SELF.type == 'inventories' %]
+
+ [%- LxERP.t8('One of the columns "qty" or "target_qty" must be given. If "target_qty" is given, the quantity to transfer for each transfer will be calculate, so that the quantity for this part, warehouse and bin will result in the given "target_qty" after each transfer.') %]
+
+
+[%- ELSIF SELF.type == 'orders' OR SELF.type == 'ar_transactions' %]
+
+ [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.') %]
+[%- END %]
+
+
+ [%- L.submit_tag('action_download_sample', LxERP.t8('Download sample file')) %]
+
+
+
[%- LxERP.t8('Settings') %]
+
+
+
+
[% 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', "1'000.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') %]
@@ -109,22 +230,56 @@
-
- [%- LxERP.t8('Check for duplicates') %]:
-
- [% 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') %]
-
-
+ [% duplicate_fields = SELF.worker.get_duplicate_check_fields() %]
+ [% IF ( duplicate_fields.size ) %]
+
+ [%- LxERP.t8('Check for duplicates') %]:
+
+
+ [% FOREACH key = duplicate_fields.keys %]
+ [% duplicate_fields.$key.label | html %]
+ [% END %]
+
+
+
+
+
+ [% 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', opts, default = SELF.profile.get('duplicates'), style = 'width: 300px') %]
+
+
+ [% END %]
[%- IF SELF.type == 'parts' %]
[%- INCLUDE 'csv_import/_form_parts.html' %]
[%- ELSIF SELF.type == 'customers_vendors' %]
[%- INCLUDE 'csv_import/_form_customers_vendors.html' %]
+[%- ELSIF SELF.type == 'contacts' %]
+ [%- INCLUDE 'csv_import/_form_contacts.html' %]
+[%- ELSIF SELF.type == 'inventories' %]
+ [%- INCLUDE 'csv_import/_form_inventories.html' %]
+[%- ELSIF SELF.type == 'orders' %]
+ [%- INCLUDE 'csv_import/_form_orders.html' %]
+[%- ELSIF SELF.type == 'ar_transactions' %]
+ [%- INCLUDE 'csv_import/_form_artransactions.html' %]
+[%- ELSIF SELF.type == 'bank_transactions' %]
+ [%- INCLUDE 'csv_import/_form_banktransactions.html' %]
[%- END %]
+
+ [%- LxERP.t8('Preview Mode') %]:
+
+ [% L.radio_button_tag('settings.full_preview', value=2, checked=SELF.profile.get('full_preview')==2, label=LxERP.t8('Full Preview')) %]
+ [% L.radio_button_tag('settings.full_preview', value=1, checked=SELF.profile.get('full_preview')==1, label=LxERP.t8('Only Warnings and Errors')) %]
+ [% L.radio_button_tag('settings.full_preview', value=0, checked=!SELF.profile.get('full_preview'), label=LxERP.t8('First 20 Lines')) %]
+
+
+
[%- LxERP.t8('Import file') %]:
[% L.input_tag('file', '', type => 'file', accept => '*') %]
@@ -139,28 +294,72 @@
+
[% 'Mappings (csv_import)' | $T8 %]
+
+
+
+
[% LxERP.t8("Hide mappings (csv_import)") %]
+
+
[% 'These mappings can be used to map heading from non standard csv files to known columns. These will also be saved in profiles, so you can save profiles for every source of formats.' | $T8 %]
+
+
+
+ [% 'Text in CSV File' | $T8 %]
+ [% 'Known Column' | $T8 %]
+
+
+ [% 'There is nothing here yet (csv_import)' | $T8 %]
+
+[%- FOREACH row = SELF.mappings %]
+ [% PROCESS 'csv_import/_mapping_item.html', item=row IF row.from %]
+[%- END %]
+ [% PROCESS 'csv_import/_mapping_item.html', item={} %]
+
+
+
+
+
+
+ [%- IF SELF.deferred %]
+ [%- PROCESS 'csv_import/_deferred_results.html' %]
+ [%- ELSIF SELF.import_status %]
+ [%- PROCESS 'csv_import/_results.html' %]
[%- END %]
+
+
-
-