{% extends "base.html" %}

{% block title %}
	General Imports
{% endblock %}

{% block nav %}
	General Imports
{% endblock %}

{% block content %}
	<form enctype="multipart/form-data" method="post" action="/general_imports">
		<fieldset>
			<legend>Import CSV File</legend>	
			<label>File</label>
			<input type="file" name="import_file" size="45"
				value="{{request.values.import_file}}">
			<input type="submit" value="Import">
		</fieldset>
	</form>
	
	{% if process_ids %}
		<ul>
			{% for id in process_ids %}
				<li><a href="/general_imports/{{id}}">{{id}}</a></li>
			{% endfor %}
		</ul>
	{% endif %}
		
	<ul>
		<li>Lines beginning with the '#' character are comment lines.</li>
		<li>
			You can import any number of lines, and mix actions and types in a
			single file.
		</li>
		<li>
			When updating a record, if the field contains {no change}, then that
			field won't be updated.
		</li>
		<li>A blank date field means 'ongoing'.</li>
		<li>If there's a problem, then all rows are rolled back.</li>
		<li>
			Timestamps are in clock-time, unless a Z is appended, which
			means it's in UTC.
		</li>
		<li>The timestamp format is <code>YYYY-MM-DD HH:MM</code>, or blank for ongoing.</li>
	</ul>

	<table>
		<caption>Formats</caption>	
		<tbody>
			<tr>
				<th>Action</th>
				<th>Type</th>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>site</em></td>
				<td>Site Code</td>
				<td>Site Name</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>site</em></td>
				<td>Site Code</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>site</em></td>
				<td>Current Site Code</td>
				<td>New Site Code</td>
				<td>Site Name</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>supply</em></td>
				<td>Site Code</td>
				<td>Source</td>
				<td>Generator Type</td>
				<td>Supply Name</td>
				<td>GSP Group (geographic location)</td>
				<td>Start date (yyyy-MM-dd hh:mm)</td>
				<td>Finish Date</td>
				<td>MOP Contract</td>
				<td>DC Contract</td>
				<td>Meter Serial Number</td>
				<td>DNO Code</td>
				<td>Profile Class</td>
				<td>Meter Timeswitch Class</td>
				<td>CoP</td>
				<td>Comms Type</td>
				<td>Standard Settlement Configuration (blank for HH supplies)</td>
				<td>Energisation Status</td>
				<td>DTC Meter Type</td>
				<td>Import MPAN Core</td>
				<td>Import LLFC</td>
				<td>Import Supply Capacity</td>
				<td>Import Supplier Contract</td>
				<td>Import Supplier Account</td>
				<td>Export MPAN Core</td>
				<td>Export LLFC</td>
				<td>Export Supply Capacity</td>
				<td>Export Supplier Contract</td>
				<td>Export Supplier Account</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>supply</em></td>
				<td>MPAN Core</td>
				<td>Source</td>
				<td>Generator Type</td>
				<td>Supply Name</td>
				<td>GSP Group</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>supply</em></td>
				<td>MPAN Core</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>era</em></td>
				<td><em>MPAN Core</em></td>
				<td>Start date (yyyy-MM-dd)</td>
				<td>Site Code</td>
				<td>MOP Contract</td>
				<td>DC Contract</td>
				<td>Meter Serial Number</td>
				<td>Profile Class</td>
				<td>MTC</td>
				<td>CoP</td>
				<td>Comms Type</td>
				<td>SSC</td>
				<td>Energisation Status</td>
				<td>DTC Meter Type</td>
				<td>Import MPAN Core</td>
				<td>Import LLFC</td>
				<td>Import Supply Capacity</td>
				<td>Import Supplier Contract</td>
				<td>Import Supplier Account</td>
				<td>Import ACTIVE?</td>
				<td>Import REACTIVE_IMP?</td>
				<td>Import REACTIVE_EXP?</td>
				<td>Export MPAN Core</td>
				<td>Export LLFC</td>
				<td>Export Supply Capacity</td>
				<td>Export Supplier Contract</td>
				<td>Export Supplier Account</td>
				<td>Export ACTIVE?</td>
				<td>Export REACTIVE_IMP?</td>
				<td>Export REACTIVE_EXP?</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>era</em></td>
				<td>MPAN Core</td>
				<td>Date (YYYY-MM-DD HH:MM)</td>
				<td>Start date (YYYY-MM-DD HH:MM)</td>
				<td>Finish date</td>
				<td>MOP Contract</td>
				<td>DC Contract</td>
				<td>Meter Serial Number</td>
				<td>Profile Class</td>
				<td>MTC</td>
				<td>CoP</td>
				<td>Comms Type</td>
				<td>SSC</td>
				<td>Energisation Status</td>
				<td>DTC Meter Type</td>
				<td>Import MPAN Core</td>
				<td>Import LLFC</td>
				<td>Import Supply Capacity</td>
				<td>Import Supplier Contract</td>
				<td>Import Supplier Account</td>
				<td>Export MPAN Core</td>
				<td>Export LLFC</td>
				<td>Export Supply Capacity</td>
				<td>Export Supplier Contract</td>
				<td>Export Supplier Account</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>era</em></td>
				<td>MPAN Core</td>
				<td>Date</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>channel</em></td>
				<td>MPAN Core</td>
				<td>Date (yyyy-MM-dd hh:mm)</td>
				<td>Import Related?</td>
				<td>Channel Type (ACTIVE, REACTIVE_IMP, REACTIVE_EXP)</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>channel</em></td>
				<td>MPAN Core</td>
				<td>Date</td>
				<td>Import Related?</td>
				<td>Channel Type (ACTIVE, REACTIVE_IMP, REACTIVE_EXP)</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>site_era</em></td>
				<td>Site Code</td>
				<td>Core MPAN</td>
				<td>Era Start Date</td>
				<td>Is Physical?</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>hh_datum</em></td>
				<td>MPAN Core</td>
				<td>Date</td>
				<td>Channel Type (ACTIVE, REACTIVE_IMP, REACTIVE_EXP)</td>
				<td>Value</td>
				<td>Status</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>user</em></td>
				<td>Email Address</td>
				<td>Password</td>
				<td>Password Digest</td>
				<td>User Role</td>
				<td>Participant Code</td>
				<td>Role Code</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>user</em></td>
				<td>Current Email Address</td>
				<td>Email Address</td>
				<td>Password</td>
				<td>Password Digest</td>
				<td>User Role</td>
				<td>Participant Code</td>
				<td>Role Code</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>channel_snag_ignore</em></td>
				<td>MPAN Core</td>
				<td>Import Related?</td>
				<td>Channel Type (ACTIVE, REACTIVE_IMP, REACTIVE_EXP)</td>
				<td>Description</td>
				<td>From</td>
				<td>To</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>channel_snag_unignore</em></td>
				<td>MPAN Core</td>
				<td>Import Related?</td>
				<td>Channel Type (ACTIVE, REACTIVE_IMP, REACTIVE_EXP)</td>
				<td>Description</td>
				<td>From</td>
				<td>To</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>site_snag_ignore</em></td>
				<td>Site Code</td>
				<td>Description</td>
				<td>From</td>
				<td>To</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>mop_batch</em></td>
				<td>Contract Name</td>
				<td>Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>mop_batch</em></td>
				<td>Contract Name</td>
				<td>Old Reference</td>
				<td>New Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>dc_batch</em></td>
				<td>Contract Name</td>
				<td>Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>dc_batch</em></td>
				<td>Contract Name</td>
				<td>Old Reference</td>
				<td>New Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>supplier_batch</em></td>
				<td>Contract Name</td>
				<td>Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>supplier_batch</em></td>
				<td>Contract Name</td>
				<td>Old Reference</td>
				<td>New Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</tr>
			<tr>
				<td><em>insert<em></td>
				<td><em>mop_bill</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Mpan Core</td>
				<td>Issue Date</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Gross</td>
				<td>Reference</td>
				<td>Type</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>mop_bill</em></td>
				<td>Chellow Id</td>
				<td>Reference</td>
				<td>Issue Date</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Type</td>
				<td>Paid?</td>
				<td>Breakdown</td>
				<td>'element'</td>
				<td>Name</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>mop_bill</em></td>
				<td>Bill Chellow Id</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>mop_bill_element</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Bill Reference</td>
				<td>Name</td>
				<td>Start Date (YYYY-MM-DD HH:MM)</td>
				<td>Finish Date (YYYY-MM-DD HH:MM)</td>
				<td>Net</td>
				<td>Breakdown</td>
			<tr>
				<td><em>insert<em></td>
				<td><em>dc_bill</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Mpan Core</td>
				<td>Issue Date (YYYY-MM-DD HH:MM)</td>
				<td>Start Date (YYYY-MM-DD HH:MM)</td>
				<td>Finish Date (YYYY-MM-DD HH:MM)</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Gross</td>
				<td>Reference</td>
				<td>Type</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>dc_bill</em></td>
				<td>Chellow Id</td>
				<td>Reference</td>
				<td>Issue Date</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Type</td>
				<td>Paid?</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>dc_bill</em></td>
				<td>Bill Chellow Id</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>dc_bill_element</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Bill Reference</td>
				<td>Name</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>insert<em></td>
				<td><em>supplier_bill</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Mpan Core</td>
				<td>Issue Date</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Gross</td>
				<td>Account Reference</td>
				<td>Reference</td>
				<td>Type</td>
				<td>Breakdown</td>
				<td>Kwh</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>supplier_bill</em></td>
				<td>Chellow Id</td>
				<td>Account</td>
				<td>Reference</td>
				<td>Issue Date</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>kwh</td>
				<td>Net</td>
				<td>Vat</td>
				<td>Type</td>
				<td>Paid?</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>supplier_bill</em></td>
				<td>Bill Chellow Id</td>
			</tr>
			<tr>
				<td><em>insert<em></td>
				<td><em>supplier_bill_element</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Bill Reference</td>
				<td>Name</td>
				<td>Start Date</td>
				<td>Finish Date</td>
				<td>Net</td>
				<td>Breakdown</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>register_read</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>Bill Reference</td>
				<td>Meter Serial Number</td>
				<td>MPAN</td>
				<td>Coefficient</td>
				<td>Units</td>
				<td>TPR</td>
				<td>Previous Date</td>
				<td>Previous Value</td>
				<td>Previous Type</td>
				<td>Present Date</td>
				<td>Present Value</td>
				<td>Present Type</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>register_read</em></td>
				<td>Chellow Id</td>
				<td>TPR</td>
				<td>Coefficient</td>
				<td>Units</td>
				<td>Meter Serial Number</td>
				<td>MPAN</td>
				<td>Previous Date</td>
				<td>Previous Value</td>
				<td>Previous Type</td>
				<td>Present Date</td>
				<td>Present Value</td>
				<td>Present Type</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>llfc</em></td>
				<td>DNO Code</td>
				<td>LLFC Code</td>
				<td>LLFC Description</td>
				<td>Voltage Level Code</td>
				<td>Is Substation?</td>
				<td>Is Import?</td>
				<td>Valid From</td>
				<td>Valid To</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>llfc</em></td>
				<td>DNO Code</td>
				<td>LLFC Code</td>
				<td>Valid From</td>
				<td>LLFC Description</td>
				<td>Voltage Level Code</td>
				<td>Is Substation?</td>
				<td>Is Import?</td>
				<td>Valid To</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>llfc</em></td>
				<td>DNO Code</td>
				<td>LLFC Code</td>
				<td>Date</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>market_role</em></td>
				<td>Market Role Code</td>
				<td>Market Role Description</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>party</em></td>
				<td>Market Role Code</td>
				<td>Participant Code</td>
				<td>Name</td>
				<td>Valid From (YYYY-MM-dd hh:mm)</td>
				<td>Valid To (YYYY-MM-dd hh:mm)</td>
				<td>DNO Code</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>g_supply</em></td>
				<td>Site Code</td>
				<td>MPRN</td>
				<td>Supply Name</td>
				<td>Exit Zone</td>
				<td>Start date (yyyy-MM-dd hh:mm)</td>
				<td>Finish Date (YYYY-MM-dd hh:mm or blank for ongoing)</td>
				<td>Meter Serial Number</td>
				<td>Correction Factor</td>
				<td>Unit</td>
				<td>Contract</td>
				<td>Account</td>
				<td>Reading Frequency</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>g_supply</em></td>
				<td>Existing MPRN</td>
				<td>MPRN</td>
				<td>Supply Name</td>
				<td>Exit Zone</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>g_supply</em></td>
				<td>MPRN</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>g_era</em></td>
				<td>MPRN</td>
				<td>Start date</td>
				<td>Site Code</td>
				<td>Meter Serial Number</td>
				<td>Correction Factor</td>
				<td>Unit</td>
				<td>Supplier Contract Name</td>
				<td>Account</td>
				<td>Reading Frequency</td>
				<td>AQ</td>
				<td>SOQ</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>g_era</em></td>
				<td>MPRN</td>
				<td>Date</td>
				<td>Start date</td>
				<td>Finish date</td>
				<td>Meter Serial Number</td>
				<td>Correction Factor</td>
				<td>Unit</td>
				<td>Supplier Contract Name</td>
				<td>Account</td>
				<td>Reading Frequency</td>
				<td>AQ</td>
				<td>SOQ</td>
			</tr>
			<tr>
				<td><em>delete</em></td>
				<td><em>g_era</em></td>
				<td>MPRN</td>
				<td>Date</td>
			</tr>
			<tr>
				<td><em>insert</em></td>
				<td><em>g_batch</em></td>
				<td>Contract Name</td>
				<td>Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</td>
			<tr>
				<td><em>update</em></td>
				<td><em>g_batch</em></td>
				<td>Contract Name</td>
				<td>Old Reference</td>
				<td>New Reference</td>
				<td>Description</td>
				<td>Date Created (YYYY-MM-DD hh:mm:ss.ffffff or blank for now)</td>
			</td>
			<tr>
				<td><em>insert</em></td>
				<td><em>g_bill</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>MPRN</td>
				<td>Issue Date (YYY-MM-dd hh:mm)</td>
				<td>Start Date (YYY-MM-dd hh:mm)</td>
				<td>Finish Date (YYY-MM-dd hh:mm)</td>
				<td>Net GBP</td>
				<td>VAT GBP</td>
				<td>Gross GBP</td>
				<td>Account</td>
				<td>Reference</td>
				<td>Type</td>
				<td>Breakdown</td>
				<td>kWh</td>
				<td>(Meter Serial Number</td>
				<td>Unit</td>
				<td>Correction Factor</td>
				<td>Calorific Value</td>
				<td>Previous Date</td>
				<td>Previous Value</td>
				<td>Previous Type</td>
				<td>Present Date</td>
				<td>Present Value</td>
				<td>Present Type)*</td>
			</td>
			<tr>
				<td><em>insert</em></td>
				<td><em>g_register_read</em></td>
				<td>Contract Name</td>
				<td>Batch Reference</td>
				<td>MPRN</td>
				<td>Bill Start Date (YYYY-MM-dd hh:mm)</td>
				<td>(Meter Serial Number</td>
				<td>Unit</td>
				<td>Correction Factor</td>
				<td>Calorific Value</td>
				<td>Previous Date (YYYY-MM-dd hh:mm)</td>
				<td>Previous Value</td>
				<td>Previous Type</td>
				<td>Present Date (YYYY-MM-dd hh:mm)</td>
				<td>Present Value</td>
				<td>Present Type)*</td>
			</td>
			<tr>
				<td><em>insert</em></td>
				<td><em>valid_mtc_llfc_ssc_pc</em></td>
				<td>DNO Code</td>
				<td>MTC Code</td>
				<td>MTC Valid From (YYYY-MM-dd hh:mm)</td>
				<td>LLFC Code</td>
				<td>LLFC Valid From (YYYY-MM-dd hh:mm)</td>
				<td>SSC Code</td>
				<td>SSC Valid From</td>
				<td>PC Code</td>
				<td>Valid From (YYYY-MM-dd hh:mm)</td>
				<td>Valid To (YYYY-MM-dd hh:mm or blank)</td>
			</tr>
			<tr>
				<td><em>update</em></td>
				<td><em>valid_mtc_llfc_ssc_pc</em></td>
				<td>DNO Code</td>
				<td>MTC Code</td>
				<td>MTC Valid From (YYYY-MM-dd hh:mm)</td>
				<td>LLFC Code</td>
				<td>LLFC Valid From (YYYY-MM-dd hh:mm)</td>
				<td>SSC Code</td>
				<td>SSC Valid From</td>
				<td>PC Code</td>
				<td>Valid From (YYYY-MM-dd hh:mm)</td>
				<td>Valid To (YYYY-MM-dd hh:mm or blank)</td>
			</tr>
		</tbody>
	</table>
{% endblock %}