<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="1ccd5275-e3fb-474d-a9b7-ffd1b3d191c0">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<queryString>
		<![CDATA[SELECT REFERENCE, NAME, CODE, ROWNUMBER, CSVERROR FROM CSVIMPORT
WHERE (CSVERROR <> 'New product')  and (CSVERROR <> 'Updated Price Details') and (CSVERROR <> 'Missing data or Invalid number')]]>
	</queryString>
	<field name="rownumber" class="java.lang.String"/>
	<field name="csverror" class="java.lang.String"/>
	<field name="reference" class="java.lang.String"/>
	<field name="code" class="java.lang.String"/>
	<field name="pricebuy" class="java.lang.Double"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="52" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-1" mode="Transparent" x="0" y="0" width="260" height="30" forecolor="#33CCFF" backcolor="#FFFFFF" uuid="c2c29a00-876d-43f8-92d9-017b843e5b21"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="14" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.title}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="false">
				<reportElement key="textField" x="400" y="15" width="135" height="15" uuid="917db804-7f02-4b40-93a0-1acaf9516af0"/>
				<textElement textAlignment="Right">
					<font fontName="SansSerif" size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<rectangle radius="5">
				<reportElement key="rectangle-1" mode="Opaque" x="0" y="50" width="535" height="2" forecolor="#33CCFF" backcolor="#33CCFF" uuid="219649fa-51d8-4a28-87dc-030d541a7fe5"/>
				<graphicElement fill="Solid">
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</rectangle>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-10" mode="Opaque" x="400" y="0" width="135" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="ad59b171-ff57-44d2-a387-66fc346624e3"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.printed}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="18" splitType="Stretch">
			<textField>
				<reportElement x="180" y="0" width="53" height="15" uuid="cde4bace-08ce-4766-9a10-9643b1c96958"/>
				<textElement markup="none">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.reference}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="243" y="0" width="94" height="15" uuid="6f702caf-eab7-4d2d-a73f-3825cf37e38d"/>
				<textElement markup="none">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.barcode}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="17" width="535" height="1" uuid="7fa320de-dc44-4b59-b54b-d3d8d9958172"/>
			</line>
			<textField>
				<reportElement x="347" y="0" width="188" height="15" uuid="13c2543e-a529-4610-b5f6-f5cd3af624ed"/>
				<textElement markup="none">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.qty}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="24" height="15" uuid="a228848e-67b7-4a9a-a9c3-d49031dda342"/>
				<textElement>
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.row}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="34" y="0" width="123" height="15" uuid="5062317c-1943-4df4-9f26-b0aa016e3bbd"/>
				<textElement>
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$R{label.csverror}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="13" splitType="Stretch">
			<textField>
				<reportElement x="180" y="0" width="53" height="13" uuid="8a2abcd4-472d-42ac-aa8c-7d448c637241"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{reference}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="347" y="0" width="188" height="13" uuid="20d496e8-4bef-4a7c-91a4-b53cd1eee9bf"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{pricebuy}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="24" height="13" uuid="19434f4d-13f9-413c-ac0a-1ac923a07a22"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{rownumber}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="34" y="0" width="123" height="13" uuid="fbe5e09d-57f5-4e24-8537-d8153fe12590"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{csverror}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="243" y="0" width="94" height="13" uuid="63a7eede-a373-45c6-9084-52b3bbf065ce"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{code}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="30">
			<staticText>
				<reportElement x="0" y="10" width="136" height="15" uuid="bedc3441-6e9f-4592-acdc-53ad6f27eb02"/>
				<textElement>
					<font fontName="SansSerif" size="8"/>
				</textElement>
				<text><![CDATA[rpt:tools_inventoryqtyupdate]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-7" mode="Opaque" x="505" y="5" width="10" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="aec62426-572c-4d83-9e29-a3e77ac27f5d"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField-16" mode="Opaque" x="485" y="5" width="20" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="0eab28f4-c4ff-434f-921c-f6d16121bc50"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField-17" mode="Opaque" x="515" y="5" width="20" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="4cc16647-fc45-4306-b44b-eb860c8e725a"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#FFFFFF"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Top" rotation="None">
					<font fontName="SansSerif" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-5" mode="Opaque" x="0" y="1" width="535" height="1" forecolor="#000000" backcolor="#FFFFFF" uuid="f180c171-a62e-4bd9-9db5-2571be230ee4"/>
				<graphicElement fill="Solid">
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</line>
		</band>
	</pageFooter>
</jasperReport>
