Barcode field ETL import

[DCIM_Support]

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]

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]

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]

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]

Nice, thanks Greg

(CID:139694244)

[DCIM_Support]

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

(CID:140215933)

[DCIM_Support]

Hi Javier,

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

Kind regards

(CID:139694272)

[DCIM_Support]

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.