Using CSV file to control bitmap size in real world scale

[TTC_Alex]

Not sure if this is possible but here is the problem we are looking to solve.

We have a large amount of bitmaps that each have their own different real world scale sizes and it would be extremely tedious having to manually change the values each time in the material editor. We have all the bitmap names and sizes in an Excel spreadsheet which could be easily converted to a CSV file.

Would it be possible to use the CSV file to change the real world scale size in the material editor based on an index number eg. 1 = 25cm x 30cm, 2 = 45cm x 25cm etc.

This would ultimately plug into one material that would be animated from 1 to however many bitmaps we end up using.

Any help would be appreciated. I am happy to explain in more detail if required

[denisT.MaxDoctor]

the task itself is not difficult... the main problem is to define all the rules and conditions...

how to find a bitmap node? it is possible by bitmap texture name or by bitmap file name...

what world units to use? what to do if the scene units do not match the desired units?

etc.

Describe the specification in detail, make an example scene and an example CSV file. Then we'll have something to play with.

[TTC_Alex]

We have 50,000 separate bitmaps (material will be diffuse only) that we need to render on a 100cm by 100cm plane.

Each bitmap has a different UV scale repeat in cm. The scene units are already setup in cm.

We have a CSV file (cannot share due to NDA) that has 4 columns. Column 1 is the index number going from 1-50000. Column 2 has the name of the bitmap (filename is the same), Column 3 is the U size in cm. Column 4 is the V size in cm.

We want to be able to use the CSV file to automate the change of UV real world scale values but we are not sure how to do it.

I hope this is helpful

[denisT.MaxDoctor]

---

@TTC_Alex wrote:

I hope this is helpful

---

example scene (MAX 2020) and CSV file would be helpful... Otherwise, I would have to make examples myself...., but I don't have the time or enthusiasm for that.