Barcode field ETL import

[DCIM_Support]

This question was originally posted on DCIM Support by Javier Zurera on 2019-02-07

---

Hello team,

is it possible to import Barcode field from an ETL import process? We do not see this field in your documentation for the Configuration_Item table:

(CID:139693334)

[DCIM_Support]

This answer was originally posted on DCIM Support by Ed Tarento on 2019-02-07

---

Hi

I suspect this is a documentation error.  This link to Import DB schema graphic show barcode.

https://sxwhelpcenter.ecostruxureit.com/display/DCIMDEVELOPER/ETL+Import+Database?preview=/93914467/...

Another way is to check the columns in the database

Cheers

Ed

Apologies, I misread the barcode for a connection in the network_connection table as a CI barcode. 

I followed my own advice by creating an import DB in DCO 8.2.7 and there is indeed no barcode column in the configuration_item table.

However, using the web client, I added a device with a barcode to the model and added a barcode to an existing asset.  So I assume that its possible via the RESTFUL API.

I'm surprised the addition of a barcode in the import DB is not possible.  I recommend you add a feature request to have this column available in the import DB.

Kind regards and again apologies for my mistake

Ed

(CID:139693400)

[DCIM_Support]

This comment was originally posted on DCIM Support by Javier Zurera on 2019-02-08

---

Hi Ed,

I do not see Barcode field in the schema in table configuration_item, where do you see it?

Thanks in advance.

(CID:139694246)

[DCIM_Support]

This answer was originally posted on DCIM Support by Greg Sterling on 2019-02-08

---

Hello Javier. The ability to import bar code in etl has recently changed as a ci_barcode field is available in dco 8.2.12 (see below screenshot).

Also in the ETL import definition you can set whether the imported barcode replaces the barcode value in the general properties in dco. In fact in dco 8.2.12 you can also lock the name, serial and bar-code fields for cases where the imported data is system of record (see below screenshot from the dco 8.2.12 web client). The ETL interface was moved to the web client between 8.2.7 and 8.2.12.

Regards

Greg Sterling

(CID:139694238)

[DCIM_Support]

This comment was originally posted on DCIM Support by Ed Tarento on 2019-02-08

---

Nice, thanks Greg

(CID:139694244)

[DCIM_Support]

This comment was originally posted on DCIM Support by Javier Zurera on 2019-02-12

---

Thanks! We are going to try this new ETL method in web client.

(CID:140215933)

[DCIM_Support]

This comment was originally posted on DCIM Support by Jef Faridi on 2019-02-11

---

Hi Javier,

It is supported from the latest release version(s) - documentation will be updated soon, thanks.

Kind regards

(CID:139694272)

[DCIM_Support]

This comment was originally posted on DCIM Support by Javier Zurera on 2019-02-12

---

Thanks Jef.

(CID:140215931)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.