{"id":6161,"date":"2025-09-22T08:52:17","date_gmt":"2025-09-22T08:52:17","guid":{"rendered":"https:\/\/docs.zenner-connect.com\/docs\/7-4-3-hinzufuegen-durch-csv-import-neu\/"},"modified":"2026-03-10T11:13:07","modified_gmt":"2026-03-10T11:13:07","slug":"csv-import","status":"publish","type":"docs","link":"https:\/\/docs.zenner-connect.com\/de\/docs\/datahub\/geraete\/hinzufuegen\/csv-import\/","title":{"rendered":"7.4.3 Hinzuf\u00fcgen via CSV-Import"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Wenn Sie mehrere Ger\u00e4te<\/strong> auf einmal hinzuf\u00fcgen m\u00f6chten, k\u00f6nnen Sie dies \u00fcber den CSV-Import<\/strong> tun. <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"Datahub:\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Zu diesem Zweck wird die Beispieldatei heruntergeladen<\/strong>. Die Informationen zu den jeweiligen Sensoren werden in die daf\u00fcr vorgesehenen Felder eingegeben. Die neue Datei wird dann \u00fcber die Schaltfl\u00e4che „Als CSV importieren<\/strong>“ hochgeladen. <\/p>

Hier m\u00fcssen Sie die Beispieldatei des zu importierenden Ger\u00e4tetyps ausw\u00e4hlen. Es ist nicht m\u00f6glich, verschiedene Ger\u00e4tetypen mit einer einzigen Ger\u00e4tedatei zu importieren<\/strong>. F\u00fcr jeden Ger\u00e4tetyp muss die entsprechende Beispieldatei ausgew\u00e4hlt werden<\/strong>. <\/p>

Wichtig<\/span><\/strong>: Die Korrektheit der eingegebenen Daten wird beim Import nicht \u00fcberpr\u00fcft<\/strong>. Wenn in DevEUI, JoinEUI oder Appkey ein Fehler auftritt, wird das Ger\u00e4t trotzdem erstellt. Es kann jedoch keine Verbindung herstellen, wenn die Daten falsch eingegeben wurden! <\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Im Folgenden ein Auszug aus einer Beispiel-CSV-Datei f\u00fcr LoRaWAN\u00ae-Ger\u00e4te<\/strong>:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"Datahub:\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Field<\/strong><\/span><\/p><\/td>

Meaning<\/strong><\/span><\/p><\/td><\/tr><\/thead>

devEUI<\/strong><\/p><\/td>

The devEUI (Device Extended Unique Identifier) of the device<\/p><\/td><\/tr>

type<\/strong><\/p><\/td>

The device type must be always LORA_OTAA \u2192 can remain as in sample file\u00a0<\/p><\/td><\/tr>

joinEUI<\/strong><\/p><\/td>

The joinEUI of the device<\/p><\/td><\/tr>

appKey<\/strong><\/p><\/td>

The appKey (Application Key) of the device<\/p><\/td><\/tr>

devAddr<\/strong><\/p><\/td>

The devAddr (Device Address) of the device,\u00a0automatically regenerated during each join process when activated via OTAA \u2192 can remain as in sample file<\/p><\/td><\/tr>

nwkSKey<\/strong><\/p><\/td>

The nwkSkey (Network Session Key) of the device,\u00a0automatically regenerated during each join process when activated via OTAA \u2192 can remain as in sample file<\/p><\/td><\/tr>

appSKey<\/strong><\/p><\/td>

The appSKey (Application Session Key) of the device, automatically regenerated during each join process when activated via OTAA \u2192 can remain as in sample file<\/p><\/td><\/tr>

rxDelay<\/strong><\/p><\/td>

RxDelay must be always 4 \u2192 can remain as in sample file<\/p><\/td><\/tr>

classC<\/strong><\/p><\/td>

True for class C devices, otherwise false<\/p><\/td><\/tr>

activated<\/strong><\/p><\/td>

True or false (only if it is activated it can join)<\/p><\/td><\/tr>

parser<\/strong><\/p><\/td>

The parser is selected here, for ZENNER & PDC\/NDC Devices it must be Minol\/ZENNER<\/em><\/p><\/td><\/tr>

status<\/strong><\/p><\/td>

Installation Status of the device \u2192 Mounted or dismounted<\/p><\/td><\/tr>

locationId
(Project ID)<\/strong><\/td>		Project ID of the existing project to which the device is to be assigned, if needed<\/td><\/tr>

street<\/strong><\/p><\/td>

The current street of the device location<\/p><\/td><\/tr>

houseNo<\/strong><\/p><\/td>

House number of the device location<\/p><\/td><\/tr>

postalCode<\/strong><\/p><\/td>

Postal code of the device location<\/p><\/td><\/tr>

city<\/strong><\/p><\/td>

City of the device location<\/p><\/td><\/tr>

geoType<\/strong><\/p><\/td>

Always enter \u201cPoint\u201d unless no longitude and latitude are entered<\/p><\/td><\/tr>

latitude<\/strong><\/p><\/td>

Latitude of the device location<\/p><\/td><\/tr>

longitude<\/strong><\/p><\/td>

Longitude of the device location<\/p><\/td><\/tr>

differentAddress<\/strong><\/p><\/td>

A different address can be entered here<\/p><\/td><\/tr>

tenant<\/strong><\/p><\/td>

The tenant in which the device is created<\/p><\/td><\/tr>

country<\/strong><\/p><\/td>

The country of the device location<\/p><\/td><\/tr>

buildingNumber<\/strong><\/p><\/td>

The building number of the device location<\/p><\/td><\/tr>

unit<\/strong><\/p><\/td>

The unit number of the device location<\/p><\/td><\/tr>

alternative_address<\/strong><\/p><\/td>

An alternative address can be entered here<\/p><\/td><\/tr>

installationDate<\/strong><\/td>Here you can select when the device was installed<\/td><\/tr>

removalDate<\/strong><\/p><\/td>

Here you can select when the device was removed (if possible)<\/p><\/td><\/tr>

installationPosition<\/strong><\/p><\/td>

Current installation Position of the device \u2192 e.g. room or floor<\/p><\/td><\/tr>

medium<\/strong><\/p><\/td>

The medium captured by the device \u2192 water, electricity, gas<\/p><\/td><\/tr>

manufacturer<\/strong><\/p><\/td>

The manufacturer of the device<\/p><\/td><\/tr>

meterType<\/strong><\/p><\/td>

The meter type of the device<\/p><\/td><\/tr>

pulseFactor<\/strong><\/p><\/td>

Pulse Factor = quantity of a pulse (see technical documents for the respective meter\/device)<\/p>

Only important for sensors that send their data with pulse output, like ZENNER PDC\/NDC Devices<\/p>

Must be entered, otherwise the calculation of the actual readings (measured values) and\u00a0 consumption will be wrong<\/p><\/td><\/tr>

meterSize<\/strong><\/p><\/td>

The size of the meter<\/p><\/td><\/tr>

initialMeterRead<\/strong><\/p><\/td>

Initial Meter Read of the device \u2192 Must be entered, otherwise it will assume 0. If nothing is entered, the value may be incorrect<\/td><\/tr>

tags<\/strong><\/p><\/td>

To which tags<\/a> the devices should be assigned<\/p><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"featured_media":0,"parent":6473,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_tag":[],"class_list":["post-6161","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs\/6161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/comments?post=6161"}],"version-history":[{"count":14,"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs\/6161\/revisions"}],"predecessor-version":[{"id":9241,"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs\/6161\/revisions\/9241"}],"up":[{"embeddable":true,"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs\/6473"}],"prev":[{"title":"7.4.2 Manuell hinzuf\u00fcgen","link":"https:\/\/docs.zenner-connect.com\/de\/docs\/datahub\/geraete\/hinzufuegen\/manuell\/","href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/docs\/6178"}],"wp:attachment":[{"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/media?parent=6161"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.zenner-connect.com\/de\/wp-json\/wp\/v2\/doc_tag?post=6161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}