{% extends "base.html" %} {% block title %} General Imports {% endblock %} {% block nav %} General Imports {% endblock %} {% block content %}

Import CSV File

{% if process_ids %}
    {% for id in process_ids %}
  • {{id}}
  • {% endfor %}
{% endif %}
  • Lines beginning with the '#' character are comment lines.
  • You can import any number of lines, and mix actions and types in a single file.
  • When updating a record, if the field contains {no change}, then that field won't be updated.
  • A blank date field means 'ongoing'.
  • If there's a problem, then all rows are rolled back.
  • Timestamps are in clock-time, unless a Z is appended, which means it's in UTC.

Formats

Action Type
insert site Site Code Site Name
delete site Site Code
update site Current Site Code New Site Code Site Name
insert supply Site Code Source Code Generator Type Supply Name GSP Group (geographic location) Start date (yyyy-MM-dd hh:mm) Finish Date MOP Contract MOP Account DC Contract DC Account Meter Serial Number Profile Class Meter Timeswitch Class CoP Standard Settlement Configuration (blank for HH supplies) Energisation Status Properties Import MPAN Core Import LLFC Import Supply Capacity Import Supplier Contract Import Supplier Account Export MPAN Core Export LLFC Export Supply Capacity Export Supplier Contract Export Supplier Account
update supply MPAN Core Source Code Generator Type Supply Name GSP Group
delete supply MPAN Core
insert era MPAN Core Start date (yyyy-MM-dd) Site Code MOP Contract MOP Account DC Contract DC Account Meter Serial Number Profile Class MTC CoP Comms Type SSC Energisation Status Properties Import MPAN Core Import LLFC Import Supply Capacity Import Supplier Contract Import Supplier Account Import ACTIVE? Import REACTIVE_IMP? Import REACTIVE_EXP? Export MPAN Core Export LLFC Export Supply Capacity Export Supplier Contract Export Supplier Account Export ACTIVE? Export REACTIVE_IMP? Export REACTIVE_EXP?
update era MPAN Core Date Start date Finish date MOP Contract MOP Account DC Contract DC Account Meter Serial Number Profile Class MTC CoP Comms Type SSC Energisation Status Properties Import MPAN Core Import LLFC Import Supply Capacity Import Supplier Contract Import Supplier Account Export MPAN Core Export LLFC Export Supply Capacity Export Supplier Contract Export Supplier Account
delete era MPAN Core Date
insert channel MPAN Core Date (yyyy-MM-dd hh:mm) Import Related? Channel Type (active, reactive import, reactive export)
delete channel MPAN Core Date Import Related? Channel Type (active, reactive import, reactive export)
insert site_era Site Code Core MPAN Era Start Date Is Physical?
insert hh_datum MPAN Core Date Channel Type Value Status
insert user Email Address Password Password Digest User Role Participant Code Role Code
update user Current Email Address Email Address Password Password Digest User Role Participant Code Role Code
insert channel_snag_ignore MPAN Core Import Related? Channel Type Description From To
insert channel_snag_unignore MPAN Core Import Related? Channel Type Description From To
insert site_snag_ignore Site Code Description From To
insert batch Role Name (dc, supplier or mop) Contract Name Reference Description
update batch Role Name (dc, supplier or mop) Contract Name Old Reference New Reference Description
insert bill Role Name (dc, supplier or mop) Contract Name Batch Reference Mpan Core Issue Date Start Date Finish Date Net Vat Gross Account Reference Reference Type Breakdown Kwh (Meter Serial Number Mpan Coefficient Units TPR Previous Date Previous Value Previous Type Present Date Present Value Present Type)*
update bill Chellow Id Account Reference Issue Date Start Date Finish Date kwh Net Vat Type Paid? Breakdown
update register_read Chellow Id TPR Coefficient Units Meter Serial Number MPAN Previous Date Previous Value Previous Type Present Date Present Value Present Type
insert llfc DNO Code LLFC Code LLFC Description Voltage Level Code Is Substation? Is Import? Valid From Valid To
update llfc DNO Code LLFC Code Valid From LLFC Description Voltage Level Code Is Substation? Is Import? Valid To
delete llfc DNO Code LLFC Code Date
insert market_role Market Role Code Market Role Description
insert party Market Role Code Participant Code Name Valid From (YYYY-MM-dd hh:mm) Valid To (YYYY-MM-dd hh:mm) DNO Code
insert g_supply Site Code MPRN Supply Name Exit Zone Start date (yyyy-MM-dd hh:mm) Finish Date (YYYY-MM-dd hh:mm or blank for ongoing) Meter Serial Number Correction Factor Unit Contract Account Reading Frequency
update g_supply Existing MPRN MPRN Supply Name Exit Zone
delete g_supply MPRN
insert g_batch Contract Name Reference Description
update g_batch Contract Name Old Reference New Reference Description
insert g_bill Contract Name Batch Reference MPRN Issue Date (YYY-MM-dd hh:mm) Start Date (YYY-MM-dd hh:mm) Finish Date (YYY-MM-dd hh:mm) Net GBP VAT GBP Gross GBP Account Reference Type Breakdown kWh (Meter Serial Number Unit Correction Factor Calorific Value Previous Date Previous Value Previous Type Present Date Present Value Present Type)*
insert valid_mtc_llfc_ssc_pc DNO Code MTC Code MTC Valid From (YYYY-MM-dd hh:mm) LLFC Code LLFC Valid From (YYYY-MM-dd hh:mm) SSC Code SSC Valid From PC Code Valid From (YYYY-MM-dd hh:mm) Valid To (YYYY-MM-dd hh:mm or blank)
update valid_mtc_llfc_ssc_pc DNO Code MTC Code MTC Valid From (YYYY-MM-dd hh:mm) LLFC Code LLFC Valid From (YYYY-MM-dd hh:mm) SSC Code SSC Valid From PC Code Valid From (YYYY-MM-dd hh:mm) Valid To (YYYY-MM-dd hh:mm or blank)
{% endblock %}