7 <div class="listtop">[% FORM.title %]</div>
9 [%- INCLUDE 'common/flash.html' %]
11 <form method="post" action="controller.pl" enctype="multipart/form-data">
12 [% L.hidden_tag('form_sent', '1') %]
13 [% L.hidden_tag('action', 'CsvImport/dispatch') %]
14 [% L.hidden_tag('profile.type', SELF.profile.type) %]
16 <h2>[%- LxERP.t8('Import profiles') %]</h2>
19 [%- IF SELF.profile.id %]
21 <th align="right">[%- LxERP.t8('Current profile') %]:</th>
22 <td>[%- HTML.escape(SELF.profile.name) %]</td>
26 [%- IF SELF.all_profiles.size %]
28 <th align="right">[%- LxERP.t8('Existing profiles') %]:</th>
30 [% L.select_tag('profile.id', SELF.all_profiles, title_key = 'name', default = SELF.profile.id, style = 'width: 300px') %]
33 [% L.submit_tag('action_new', LxERP.t8('Load profile')) %]
34 [% L.submit_tag('action_destroy', LxERP.t8('Delete profile'), confirm => LxERP.t8('Do you really want to delete this object?')) %]
40 <th align="right" valign="top">[%- LxERP.t8('Save settings as') %]:</th>
42 [% L.input_tag('profile.name', '', style => 'width: 300px') %]
44 [% L.checkbox_tag('profile.is_default', label => LxERP.t8('Make default profile')) %]
46 <td valign="top">[% L.submit_tag('action_save', LxERP.t8('Save profile')) %]</td>
52 <h2>[%- LxERP.t8('Help on column names') %]</h2>
54 <div class="help_toggle">
55 <a href="#" onClick="javascript:$('.help_toggle').toggle()">[% LxERP.t8("Show help text") %]</a>
58 <div class="help_toggle" style="display:none">
59 <p><a href="#" onClick="javascript:$('.help_toggle').toggle()">[% LxERP.t8("Hide help text") %]</a></p>
62 <tr class="listheading">
63 <th>[%- LxERP.t8('Column name') %]</th>
64 <th>[%- LxERP.t8('Meaning') %]</th>
67 [%- FOREACH row = SELF.displayable_columns %]
68 <tr class="listrow[% loop.count % 2 %]">
69 <td>[%- HTML.escape(row.name) %]</td>
70 <td>[%- HTML.escape(row.description) %]</td>
75 [%- IF SELF.type == 'contacts' %]
77 [%- 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') %]
80 [%- ELSIF SELF.type == 'addresses' %]
82 [%- 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') %]
85 [%- ELSIF SELF.type == 'parts' %]
87 [%- LxERP.t8("If the article type is set to 'mixed' then a column called 'type' must be present.") %]
88 [% LxERP.t8("Type can be either 'part' or 'service'.") %]
93 [%- L.submit_tag('action_download_sample', LxERP.t8('Download sample file')) %]
100 <h2>[%- LxERP.t8('Settings') %]</h2>
104 <th align="right">[%- LxERP.t8('Number Format') %]:</th>
106 [% L.select_tag('settings.numberformat', ['1.000,00', '1000,00', '1,000.00', '1000.00'], default = SELF.profile.get('numberformat'), style = 'width: 300px') %]
111 <th align="right">[%- LxERP.t8('Charset') %]:</th>
112 <td colspan="10">[% L.select_tag('settings.charset', SELF.all_charsets, default = SELF.profile.get('charset'), style = 'width: 300px') %]</td>
116 <th align="right">[%- LxERP.t8('Separator') %]:</th>
117 [% SET custom_sep_char = SELF.sep_char %]
118 [% FOREACH entry = SELF.all_sep_chars %]
120 [% IF SELF.sep_char == entry.first %] [% SET custom_sep_char = '' %] [%- END %]
121 [% L.radio_button_tag('sep_char', value => entry.first, label => entry.last, checked => SELF.sep_char == entry.first) %]
126 [% L.radio_button_tag('sep_char', value => 'custom', checked => custom_sep_char != '') %]
127 [% L.input_tag('custom_sep_char', custom_sep_char, size => 3, maxlength => 1) %]
132 <th align="right">[%- LxERP.t8('Quote character') %]:</th>
133 [% SET custom_quote_char = SELF.quote_char %]
134 [% FOREACH entry = SELF.all_quote_chars %]
136 [% IF SELF.quote_char == entry.first %] [% SET custom_quote_char = '' %] [%- END %]
137 [% L.radio_button_tag('quote_char', value => entry.first, label => entry.last, checked => SELF.quote_char == entry.first) %]
142 [% L.radio_button_tag('quote_char', value => 'custom', checked => custom_quote_char != '') %]
143 [% L.input_tag('custom_quote_char', custom_quote_char, size => 3, maxlength => 1) %]
148 <th align="right">[%- LxERP.t8('Escape character') %]:</th>
149 [% SET custom_escape_char = SELF.escape_char %]
150 [% FOREACH entry = SELF.all_escape_chars %]
152 [% IF SELF.escape_char == entry.first %] [% SET custom_escape_char = '' %] [%- END %]
153 [% L.radio_button_tag('escape_char', value => entry.first, label => entry.last, checked => SELF.escape_char == entry.first) %]
158 [% L.radio_button_tag('escape_char', value => 'custom', checked => custom_escape_char != '') %]
159 [% L.input_tag('custom_escape_char', custom_escape_char, size => 3, maxlength => 1) %]
163 [% duplicate_fields = SELF.worker.get_duplicate_check_fields() %]
164 [% IF ( duplicate_fields.size ) %]
166 <th align="right">[%- LxERP.t8('Check for duplicates') %]:</th>
169 [% FOREACH key = duplicate_fields.keys %]
170 <input type="checkbox" name="settings.duplicates_[% key | html %]" id="settings.duplicates_[% key | html %]" value="1"[% IF ( SELF.profile.get('duplicates_'_ key) || (duplicate_fields.$key.default && !FORM.form_sent ) ) %] checked="checked"[% END %]\>
171 <label for="settings.duplicates_[% key | html %]">[% duplicate_fields.$key.label | html %]</label>
177 <th align="right"></th>
180 [% opts = [ [ 'no_check', LxERP.t8('Do not check for duplicates') ],
181 [ 'check_csv', LxERP.t8('Discard duplicate entries in CSV file') ],
182 [ 'check_db', LxERP.t8('Discard entries with duplicates in database or CSV file') ] ] %]
183 [% L.select_tag('settings.duplicates', opts, default = SELF.profile.get('duplicates'), style = 'width: 300px') %]
188 [%- IF SELF.type == 'parts' %]
189 [%- INCLUDE 'csv_import/_form_parts.html' %]
190 [%- ELSIF SELF.type == 'customers_vendors' %]
191 [%- INCLUDE 'csv_import/_form_customers_vendors.html' %]
195 <th align="right">[%- LxERP.t8('Preview Mode') %]:</th>
197 [% L.radio_button_tag('settings.full_preview', value=2, checked=SELF.profile.get('full_preview')==2, label=LxERP.t8('Full Preview')) %]
198 [% L.radio_button_tag('settings.full_preview', value=1, checked=SELF.profile.get('full_preview')==1, label=LxERP.t8('Only Warnings and Errors')) %]
199 [% L.radio_button_tag('settings.full_preview', value=0, checked=!SELF.profile.get('full_preview'), label=LxERP.t8('First 20 Lines')) %]
204 <th align="right">[%- LxERP.t8('Import file') %]:</th>
205 <td colspan="10">[% L.input_tag('file', '', type => 'file', accept => '*') %]</td>
208 [%- IF SELF.file.exists %]
210 <th align="right">[%- LxERP.t8('Existing file on server') %]:</th>
211 <td colspan="10">[%- LxERP.t8('Uploaded on #1, size #2 kB', SELF.file.displayable_mtime, LxERP.format_amount(SELF.file.size / 1024, 2)) %]</td>
217 [% L.submit_tag('action_test', LxERP.t8('Test and preview')) %]
218 [% IF (SELF.import_status == 'tested') && SELF.num_importable %]
219 [% L.submit_tag('action_import', LxERP.t8('Import')) %]
224 [%- IF SELF.import_status %]
225 [%- IF SELF.errors %]
226 [%- PROCESS 'csv_import/_errors.html' %]
229 [%- PROCESS 'csv_import/_result.html' %]
230 [%- PROCESS 'csv_import/_preview.html' %]
233 <script type="text/javascript">
235 $(document).ready(function() {
236 $('#action_save').click(function() {
237 if ($('#profile_name').attr('value') != '')
239 alert('[% LxERP.t8('Please enter a profile name.') %]');