How do I format my Connection import file?
You can upload your connection into the CEDS connection tool as an Excel file.
-
Download the Excel template
and enter your data into each of the worksheets included in the file.
- Do NOT rename or delete any of the worksheets
or column headings, even if you don't have any data to enter into them.
-
Click here, or use the "View Available Descriptors" button
at the top of this page to get a list of category IDs you'll need to populate the "Categories" field on
the "Connection" worksheet of the file you're uploading.
-
Use the "CEDS Element IDs" worksheet in the template file to locate any IDs you'll use to
populate the "CEDS_Element_Data_Model_ID" field on the "CEDSElements" worksheet of the file you're uploading.
A template file, with instructions is provided
here.
Use this template to enter your data into. Do not attempt to create one of your own.
There is also a download file with
sample data available with examples of how to structure the data you're going to import.
Download the Excel template
(220 KB)
Download the Excel template
with sample data included
(220 KB)
How do I load my connection?
-
To start the actual upload process click the Choose File button below. You will then choose the Excel
file to upload. Once this information is provided the import process will attempt to load your connection.