THERM7.8.71.0 Material Import Question

[Matt]

I've imported my materials into THERM via CSV. But not only are all the material color BLACK instead of what was chosen via HEX code, but the material library is "PROTECTED".

Is there something I'm missing to correctly import the CSV to not only have the HEX colors picked, but also not have it locked?

[Zugur Rakhmanov]

Hi,
Try to open your CSV file with notepad.exe and rewrite the color value as the screenshot below. Also delete the comma after the "Composite" word.
Then reload the library in the Therm and check the colors.
Good luck.

Best regards,

Zugur

--
You can view the THERM forum online at:
https://groups.google.com/g/LBNL-THERM
---
You received this message because you are subscribed to the Google Groups "THERM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to LBNL-THERM+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/LBNL-THERM/c7f08b3e-1418-4e7f-8604-c99516e6e86cn%40googlegroups.com.

[Robin Mitchell]

You probably already found this, but here is a link to the Knowledge Base article about importing a CSV into the THERM Material Library. 

https://windows.lbl.gov/material-library-import-csv-file

As Zugur noted, the color needs to be in HEX -- there are many RGB to HEX converters on the web.

And the name probably shouldn't have commas, although the quotes should handle that. 

I will check to see if the imports come in protected, which they shouldn't. 

Robin

To view this discussion on the web visit https://groups.google.com/d/msgid/LBNL-THERM/CAHkBh38ja-dofXjeWD83hXm8J_x-mWtqAaTtS81AjQeOVvq0cA%40mail.gmail.com.

--

Robin Mitchell

Building Technology and Urban Systems Division
Energy Technologies Area
Lawrence Berkeley National Laboratory

[Robin Mitchell]

I just confirmed that Material Library records that are imported from a CSV file do come in Protected. I don't think we want to change that, because there are some people using THERM that make libraries this way that they don't want their user groups to change. 

So you will want to make sure that everything is defined properly in your CSV file, so that you don't need to edit it in THERM. 

I also confirmed that it is fine to have commas and other punctuation in the name, as long as it is surrounded by quotes. 

So it seems the main problem with your CSV file is that the colors are not in HEX

Robin

[Zugur Rakhmanov]

Dear Robin,

you are correct, the comma can be used there. I already wrote to Mat about it(by private letter).

Sorry again.

Kind regards,

Zugur

пт, 22 сент. 2023 г., 21:40 Robin Mitchell <rdmit...@lbl.gov>:

[Matt]

Fixed the Hex color numbers to include "0x"

Kept comma in description

"understood" protection constaints

Everything worked as it should.  Thank you!

[Robin Mitchell]

Excellent !!

Thanks for reporting back !

Robin

To view this discussion on the web visit https://groups.google.com/d/msgid/LBNL-THERM/dbddf666-325d-49e7-906a-e9b89b10e13fn%40googlegroups.com.

[yal...@gmail.com]

Hi  can the material database in THERM be exported as a CSV file?

Thanks,

Yalin

[Robin Mitchell]

Yes.

Open the Material Library, click Save Lib As, use the CSV extension for the filename, and the library will get saved as a CSV file. 

To view this discussion on the web visit https://groups.google.com/d/msgid/LBNL-THERM/ac49b914-27ec-4db1-925b-7359558f938en%40googlegroups.com.