Generate Item List of Objects used in the Object manager.
-
Hey Folks, we need support in programming a custom plugin/Python script that lists all objects which are used in the object manager by name, price etc.. I must admit that we are not able to do any C++ or Python programming and are searching for a programmer who can create an offer and is able to do that for us.
We use C4D as a layout and visualization tool in our sales process to create individual offers for our customers. All our products can be combined in a module system and are assembled in Cinema4D as individual Waterparks.
-> www.wibitsports.comWe have created an Xpresso script that recognizes the names of the products, their number and shows us a total price in EUR & USD as well as the capacity (number of persons per product).
Here is a simple example layout list:- 2x Product_A, Item number; Price EUR xx,xx; Price USD xx,xx; Total price xx EUR; Total price xx USD; capacity xx
- 1x Product_B, item number; price EUR xx,xx; price USD xx,xx; Total price xx EUR; Total price xx USD; capacity xx
- 3x Product_c, item number; price EUR xx,xx; price USD xx,xx; Total price xx EUR; Total price xx USD; capacity xx
This is the output we need. There are always fixed product names, products used multiple times are automatically reset to the original name, only objects on the first level are counted. There is only one exception, some products require additional 1 or 2 sub products. (If Product_A, also add Product_A_1). All other objects (lights, environment, etc.) should be ignored.
We then copy this data into a text file and convert it into a CSV file. In the end we have an item list as CSV with all products, item numbers and prices in EUR & USD. Our sales team uses this for an offer to the clients.Our Xpresso programming is working but, too cumbersome and error prone in the long run. We would like to replace it with a (Python?) script or plugin that queries an external Excel table where the items and prices are stored. In case of price changes, or new products, we could then simply replace the Excel table and the new prices would be shown. There are round about 150 products.
I hope anyone can help us with this
-