Attachment #170551 for bug #36831

View | Details | Raw Unified | Return to bug 36831
Collapse All | Expand All




        my @invalid_columns;
        my $max_allowed_packet = C4::Context->dbh->selectrow_array(q{SELECT @@max_allowed_packet});

        my ( $column_headers, $rows, $error ) = Koha::BackgroundJob::ImportKBARTFile::read_file($file);
        if ( $file->{filename} !~ /\.csv$/ && $file->{filename} !~ /\.tsv$/ ) {
            return $c->render(
                status  => 201,
                openapi => { invalid_filetype => 1 }
            );
        }

        return $c->render(
            status  => 201,
            openapi => { invalid_filetype => 1 }
        ) if $error eq 'unknown_delimiter';

        # Check that the column headers in the file match the standardised KBART phase II columns
        # If not, return a warning




    <h2>{{ $__("Import from a KBART file") }}</h2>
    <div class="page-section" id="files">
        <form @submit="addDocument($event)" class="file_upload">
            <h3>{{ $__("Requirements:") }}</h3>
            <ul style="margin-bottom: 1.5em">
                <li>{{ $__("The file must be in TSV or CSV format") }}</li>
                <li>
                    {{
                        $__(
                            "The file should not contain any additional information / header rows, e.g. a file with a single title would be structured as follows:"
                        )
                    }}
                    <ol>
                        <li>{{ $__("Column headings row") }}</li>
                        <li>{{ $__("Title data row") }}</li>
                    </ol>
                </li>
            </ul>
            <fieldset class="rows" id="package_list">
                <h3>{{ $__("Select file for upload") }}:</h3>
                <ol>

                    }
                    if (success.invalid_filetype) {
                        message += `<p>${this.$__(
                            "Could not detect whether the file is TSV or CSV, please check the file."
                        )}</p>`
                        setWarning(message)
                    }
- 

Return to bug 36831

Lines 281-295 sub import_from_kbart_file { Link Here

(-)a/Koha/REST/V1/ERM/EHoldings/Titles/Local.pm (-8 / +5 lines)
281	my @invalid_columns;	281	my @invalid_columns;
282	my $max_allowed_packet = C4::Context->dbh->selectrow_array(q{SELECT @@max_allowed_packet});	282	my $max_allowed_packet = C4::Context->dbh->selectrow_array(q{SELECT @@max_allowed_packet});
283		283
284	# Check if file is in TSV or CSV format and send an error back if not	284	my ( $column_headers, $rows, $error ) = Koha::BackgroundJob::ImportKBARTFile::read_file($file);
285	if ( $file->{filename} !~ /\.csv$/ && $file->{filename} !~ /\.tsv$/ ) {
286	return $c->render(
287	status => 201,
288	openapi => { invalid_filetype => 1 }
289	);
290	}
291		285
292	my ( $column_headers, $rows ) = Koha::BackgroundJob::ImportKBARTFile::read_file($file);	286	return $c->render(
		287	status => 201,
		288	openapi => { invalid_filetype => 1 }
		289	) if $error eq 'unknown_delimiter';
293		290
294	# Check that the column headers in the file match the standardised KBART phase II columns	291	# Check that the column headers in the file match the standardised KBART phase II columns
295	# If not, return a warning	292	# If not, return a warning

Lines 2-22 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/js/vue/components/ERM/EHoldingsLocalTitlesKBARTImport.vue (-17 / +1 lines)
2	<h2>{{ $__("Import from a KBART file") }}</h2>	2	<h2>{{ $__("Import from a KBART file") }}</h2>
3	<div class="page-section" id="files">	3	<div class="page-section" id="files">
4	<form @submit="addDocument($event)" class="file_upload">	4	<form @submit="addDocument($event)" class="file_upload">
5	<h3>{{ $__("Requirements:") }}</h3>
6	<ul style="margin-bottom: 1.5em">
7	<li>{{ $__("The file must be in TSV or CSV format") }}</li>
8	<li>
9	{{
10	$__(
11	"The file should not contain any additional information / header rows, e.g. a file with a single title would be structured as follows:"
12	)
13	}}
14	<ol>
15	<li>{{ $__("Column headings row") }}</li>
16	<li>{{ $__("Title data row") }}</li>
17	</ol>
18	</li>
19	</ul>
20	<fieldset class="rows" id="package_list">	5	<fieldset class="rows" id="package_list">
21	<h3>{{ $__("Select file for upload") }}:</h3>	6	<h3>{{ $__("Select file for upload") }}:</h3>
22	<ol>	7	<ol>
Lines 173-179 export default { Link Here
173	}	158	}
174	if (success.invalid_filetype) {	159	if (success.invalid_filetype) {
175	message += `<p>${this.$__(	160	message += `<p>${this.$__(
176	"The file must be in .tsv or .csv format, please convert your file and try again."	161	"Could not detect whether the file is TSV or CSV, please check the file."
177	)}</p>`	162	)}</p>`
178	setWarning(message)	163	setWarning(message)
179	}	164	}
180	-