+
[% LxERP.t8("Hide help text") %]
+
+
+
+ [%- LxERP.t8('Column name') %] |
+ [%- LxERP.t8('Meaning') %] |
+
+
+ [%- FOREACH row = SELF.displayable_columns %]
+
+ [%- HTML.escape(row.name) %] |
+ [%- HTML.escape(row.description) %] |
+
+ [%- END %]
+
+
+[%- IF SELF.type == 'contacts' %]
+
+ [%- 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' %]
+
+ [%- 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'.") %]
+
+[%- END %]
+
+
+ [%- L.submit_tag('action_download_sample', LxERP.t8('Download sample file')) %]
+
+
+
+
+
- [%- LxERP.t8('Number format') %]: |
+ [%- 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') %]
@@ -109,12 +157,52 @@
|
+
+ [%- 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') %]
+ |
+
+
+[%- IF SELF.type == 'parts' %]
+ [%- INCLUDE 'csv_import/_form_parts.html' %]
+[%- ELSIF SELF.type == 'customers_vendors' %]
+ [%- INCLUDE 'csv_import/_form_customers_vendors.html' %]
+[%- END %]
+
+
+ [%- LxERP.t8('Import file') %]: |
+ [% L.input_tag('file', '', type => 'file', accept => '*') %] |
+
+
+ [%- IF SELF.file.exists %]
+
+ [%- LxERP.t8('Existing file on server') %]: |
+ [%- LxERP.t8('Uploaded on #1, size #2 kB', SELF.file.displayable_mtime, LxERP.format_amount(SELF.file.size / 1024, 2)) %] |
+
+ [%- END %]
+
- [% L.submit_tag('action_test', LxERP.t8('Gogogo')) %]
+ [% L.submit_tag('action_test', LxERP.t8('Test and preview')) %]
+ [% IF (SELF.import_status == 'tested') && SELF.num_importable %]
+ [% L.submit_tag('action_import', LxERP.t8('Import')) %]
+ [%- END %]