1 [% USE HTML %][% USE LxERP %][% USE L %]
4 <div class="listtop">[% FORM.title %]</div>
6 [%- INCLUDE 'common/flash.html' %]
8 <form method="post" action="controller.pl" enctype="multipart/form-data">
9 [% L.hidden_tag('action', 'CsvImport/dispatch') %]
10 [% L.hidden_tag('profile.type', SELF.profile.type) %]
12 <h2>[%- LxERP.t8('Import profiles') %]</h2>
15 [%- IF SELF.profile.id %]
17 <th align="right">[%- LxERP.t8('Current profile') %]:</th>
18 <td>[%- HTML.escape(SELF.profile.name) %]</td>
22 [%- IF SELF.all_profiles.size %]
24 <th align="right">[%- LxERP.t8('Existing profiles') %]:</th>
26 [% L.select_tag('profile.id', L.options_for_select(SELF.all_profiles, title => 'name', default => SELF.profile.id), style => 'width: 300px') %]
29 [% L.submit_tag('action_new', LxERP.t8('Load profile')) %]
30 [% L.submit_tag('action_destroy', LxERP.t8('Delete profile'), confirm => LxERP.t8('Do you really want to delete this object?')) %]
36 <th align="right" valign="top">[%- LxERP.t8('Save settings as') %]:</th>
38 [% L.input_tag('profile.name', '', style => 'width: 300px') %]
40 [% L.checkbox_tag('profile.is_default', label => LxERP.t8('Make default profile')) %]
42 <td valign="top">[% L.submit_tag('action_save', LxERP.t8('Save profile')) %]</td>
48 <h2>[%- LxERP.t8('Help on column names') %]</h2>
50 <div class="help_toggle">
51 <a href="#" onClick="javascript:$('.help_toggle').toggle()">[% LxERP.t8("Show help text") %]</a>
54 <div class="help_toggle" style="display:none">
55 <p><a href="#" onClick="javascript:$('.help_toggle').toggle()">[% LxERP.t8("Hide help text") %]</a></p>
57 <p><b>Dieser Hilfetext wird demnaechst noch verbessert und wandert vermutlich in ein Popup.</b></p>
60 <tr class="listheading">
61 <th>[%- LxERP.t8('Column name') %]</th>
62 <th>[%- LxERP.t8('Meaning') %]</th>
65 [%- FOREACH row = SELF.displayable_columns %]
66 <tr class="listrow[% loop.count % 2 %]">
67 <td>[%- HTML.escape(row.name) %]</td>
68 <td>[%- HTML.escape(row.description) %]</td>
76 <h2>[%- LxERP.t8('Settings') %]</h2>
80 <th align="right">[%- LxERP.t8('Number Format') %]:</th>
82 [% SET options = L.options_for_select([ '1.000,00', '1000,00', '1,000.00', '1000.00' ], default => SELF.profile.get('numberformat')) %]
83 [% L.select_tag('settings.numberformat', options, style => 'width: 300px') %]
88 <th align="right">[%- LxERP.t8('Charset') %]:</th>
89 <td colspan="10">[% L.select_tag('settings.charset', L.options_for_select(SELF.all_charsets, default => SELF.profile.get('charset')), style => 'width: 300px') %]</td>
93 <th align="right">[%- LxERP.t8('Separator') %]:</th>
94 [% SET custom_sep_char = SELF.sep_char %]
95 [% FOREACH entry = SELF.all_sep_chars %]
97 [% IF SELF.sep_char == entry.first %] [% SET custom_sep_char = '' %] [%- END %]
98 [% L.radio_button_tag('sep_char', value => entry.first, label => entry.last, checked => SELF.sep_char == entry.first) %]
103 [% L.radio_button_tag('sep_char', value => 'custom', checked => custom_sep_char != '') %]
104 [% L.input_tag('custom_sep_char', custom_sep_char, size => 3, maxlength => 1) %]
109 <th align="right">[%- LxERP.t8('Quote character') %]:</th>
110 [% SET custom_quote_char = SELF.quote_char %]
111 [% FOREACH entry = SELF.all_quote_chars %]
113 [% IF SELF.quote_char == entry.first %] [% SET custom_quote_char = '' %] [%- END %]
114 [% L.radio_button_tag('quote_char', value => entry.first, label => entry.last, checked => SELF.quote_char == entry.first) %]
119 [% L.radio_button_tag('quote_char', value => 'custom', checked => custom_quote_char != '') %]
120 [% L.input_tag('custom_quote_char', custom_quote_char, size => 3, maxlength => 1) %]
125 <th align="right">[%- LxERP.t8('Escape character') %]:</th>
126 [% SET custom_escape_char = SELF.escape_char %]
127 [% FOREACH entry = SELF.all_escape_chars %]
129 [% IF SELF.escape_char == entry.first %] [% SET custom_escape_char = '' %] [%- END %]
130 [% L.radio_button_tag('escape_char', value => entry.first, label => entry.last, checked => SELF.escape_char == entry.first) %]
135 [% L.radio_button_tag('escape_char', value => 'custom', checked => custom_escape_char != '') %]
136 [% L.input_tag('custom_escape_char', custom_escape_char, size => 3, maxlength => 1) %]
141 <th align="right">[%- LxERP.t8('Check for duplicates') %]:</th>
143 [% opts = [ [ 'no_check', LxERP.t8('Do not check for duplicates') ],
144 [ 'check_csv', LxERP.t8('Discard duplicate entries in CSV file') ],
145 [ 'check_db', LxERP.t8('Discard entries with duplicates in database or CSV file') ] ] %]
146 [% L.select_tag('settings.duplicates', L.options_for_select(opts, default => SELF.profile.get('duplicates')), style => 'width: 300px') %]
150 [%- IF SELF.type == 'parts' %]
151 [%- INCLUDE 'csv_import/_form_parts.html' %]
152 [%- ELSIF SELF.type == 'customers_vendors' %]
153 [%- INCLUDE 'csv_import/_form_customers_vendors.html' %]
157 <th align="right">[%- LxERP.t8('Import file') %]:</th>
158 <td colspan="10">[% L.input_tag('file', '', type => 'file', accept => '*') %]</td>
161 [%- IF SELF.file.exists %]
163 <th align="right">[%- LxERP.t8('Existing file on server') %]:</th>
164 <td colspan="10">[%- LxERP.t8('Uploaded on #1, size #2 kB', SELF.file.displayable_mtime, LxERP.format_amount(SELF.file.size / 1024, 2)) %]</td>
170 [% L.submit_tag('action_test', LxERP.t8('Test and preview')) %]
171 [% IF (SELF.import_status == 'tested') && SELF.num_importable %]
172 [% L.submit_tag('action_import', LxERP.t8('Import')) %]
177 [%- IF SELF.import_status %]
178 [%- IF SELF.errors %]
179 [%- PROCESS 'csv_import/_errors.html' %]
182 [%- PROCESS 'csv_import/_result.html' %]
183 [%- PROCESS 'csv_import/_preview.html' %]
186 <script type="text/javascript">
188 $(document).ready(function() {
189 $('#action_save').click(function() {
190 if ($('#profile_name').attr('value') != '')
192 alert('[% LxERP.t8('Please enter a profile name.') %]');