Create Data Comparison Videos From Excel Files | No Manual Work Needed | Setup Camera With PY Script
In this Blender tutorial, we have discussed how to create a world data comparison video super fast with our Python script. No manual work is needed at all. Just fill-in your data in an excel format and Blender will generate a good-looking data comparison video with appropriate lighting and background. Please watch the video for the complete tutorial. If you have any question on this tutorial, please leave your comment below.
๐๐๐ญ๐๐ก ๐จ๐ฎ๐ซ ๐๐๐ญ๐ ๐๐จ๐ฆ๐ฉ๐๐ซ๐ข๐ฌ๐จ๐ง ๐๐๐-๐จ๐ง ๐ โข Create Excel to Data C...
๐๐ ๐ฒ๐จ๐ฎ ๐ ๐๐ญ ๐๐ง ๐๐ซ๐ซ๐จ๐ซ, ๐ฐ๐๐ญ๐๐ก ๐จ๐ฎ๐ซ ๐ฌ๐๐๐จ๐ง๐ ๐ฏ๐ข๐๐๐จ ๐ก๐๐ซ๐ ๐ โข Method 2: Create Data ...
==================================================
๐๐ง๐ฌ๐ญ๐ซ๐ฎ๐๐ญ๐ข๐จ๐ง๐ฌ ๐จ๐ง ๐ก๐จ๐ฐ ๐ญ๐จ ๐ฎ๐ฌ๐ ๐จ๐ฎ๐ซ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ:
Create a folder called C:\MyTest on your computer (if you use another folder location, you need to change this name in our script). You have to keep 4 things within this folder: One excel file containing your data (use your own or download our sample file from bit.ly/5mbSampleExcel), a font file (download from bit.ly/5mbarialbdfont), a world HDRI file (download from bit.ly/5mbworldHDRI) and a subfolder called Pictures that should contain all your pictures or logo files. Now open Blender and run the following scripts, then render the video from Blender.
๐
๐ข๐ซ๐ฌ๐ญ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ: ๐๐ก๐ข๐ฌ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐๐ง๐๐๐ฅ๐๐ฌ ๐๐ฅ๐๐ง๐๐๐ซ ๐ญ๐จ ๐ซ๐๐๐ ๐๐ซ๐จ๐ฆ ๐๐ง ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐. ๐๐จ๐ฎ ๐ง๐๐๐ ๐ญ๐จ ๐ซ๐ฎ๐ง ๐ข๐ญ ๐จ๐ง๐ฅ๐ฒ ๐จ๐ง๐๐ ๐๐จ๐ซ ๐ฒ๐จ๐ฎ๐ซ ๐ฆ๐๐๐ก๐ข๐ง๐ ๐ bit.ly/5mbexcel2blender
๐๐ก๐๐ง ๐ฒ๐จ๐ฎ ๐ ๐๐ญ ๐๐ง ๐๐ซ๐ซ๐จ๐ซ: If the first script does not run correctly, you'll get an error in the second script (like "Module Not Found" error). The most common source of this error is insufficient access on your device, so it is advisable to execute this script from an admin account on your machine. If the error still persists, I suggest you to use the portable version of Blender (follow the steps given here ๐ bit.ly/5mbexcelscripterror). Or you can skip this step and use the CSV version of our script given below.
๐๐๐๐จ๐ง๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ (๐๐ฑ๐๐๐ฅ ๐๐๐ซ๐ฌ๐ข๐จ๐ง): ๐๐ญ ๐๐ซ๐๐๐ญ๐๐ฌ ๐ญ๐ก๐ ๐ง๐๐๐๐ฌ๐ฌ๐๐ซ๐ฒ ๐๐ง๐ข๐ฆ๐๐ญ๐ข๐จ๐ง ๐๐ฅ๐จ๐ง๐ ๐ฐ๐ข๐ญ๐ก ๐ญ๐ก๐ ๐๐๐ฆ๐๐ซ๐ ๐ฌ๐๐ญ๐ฎ๐ฉ ๐ bit.ly/5mbDCBasicScript
๐๐๐๐จ๐ง๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ (๐๐๐ ๐๐๐ซ๐ฌ๐ข๐จ๐ง): ๐๐๐ฏ๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐ ๐๐ฌ ๐ ๐๐๐ ๐๐ข๐ฅ๐ ๐๐ง๐ ๐ฎ๐ฌ๐ ๐ญ๐ก๐ข๐ฌ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐ bit.ly/5mbCSVBasicScript This is recommended if you are getting errors in running the above script. In this script, you need to mention the CSV file path instead of Excel, and all other things remain the same.
๐๐ก๐ข๐ซ๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ (๐๐ฑ๐๐๐ฅ ๐๐๐ซ๐ฌ๐ข๐จ๐ง): ๐๐ก๐ข๐ฌ ๐ข๐ฌ ๐๐๐๐๐ฌ๐ฌ๐ข๐๐ฅ๐ ๐จ๐ง๐ฅ๐ฒ ๐๐จ๐ซ ๐จ๐ฎ๐ซ ๐ฆ๐๐ฆ๐๐๐ซ๐ฌ. It creates the animation, the camera setup, background and lighting, floor and the world setup, no need to run the second script if you use this ๐ bit.ly/5mbDCFullScript or you can download the complete package from ๐ bit.ly/5mbtut196R
๐๐ก๐ข๐ซ๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ (๐๐๐ ๐๐๐ซ๐ฌ๐ข๐จ๐ง): ๐๐๐ฏ๐ ๐ฒ๐จ๐ฎ๐ซ ๐๐ฑ๐๐๐ฅ ๐๐ข๐ฅ๐ ๐๐ฌ ๐ ๐๐๐ ๐๐ข๐ฅ๐ ๐๐ง๐ ๐ฎ๐ฌ๐ ๐ญ๐ก๐ข๐ฌ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ ๐ bit.ly/5mbCSVFullScript This is recommended if you are getting an error while running the above script. In this script, you need to mention the CSV file path instead of Excel, and all other things remain the same.
==================================================
๐๐จ๐ข๐ง ๐จ๐ฎ๐ซ ๐๐ก๐๐ง๐ง๐๐ฅ ๐๐จ๐ซ ๐ญ๐ก๐ ๐๐ฅ๐๐ง๐ ๐๐ข๐ฅ๐ & ๐๐๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐ฉ๐๐ซ๐ค๐ฌ ๐ / 5minutesblender
๐
๐จ๐ฅ๐ฅ๐จ๐ฐ ๐ฎ๐ฌ ๐จ๐ง ๐๐ง๐ฌ๐ญ๐๐ ๐ซ๐๐ฆ ๐ / 5minutesblender
We have many more tutorials that can help you learn Blender like a professional. You can go through the following playlists for the relevant topics:
๐ ๐๐ฅ๐๐ง๐๐๐ซ ๐
๐จ๐ฎ๐ง๐๐๐ญ๐ข๐จ๐ง ๐๐จ๐ฎ๐ซ๐ฌ๐ ๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ:
If you are absolutely new to Blender, take this foundation course.
โข Blender Foundation Course
๐ ๐๐ฅ๐ฅ ๐๐ ๐๐ฅ๐๐ฌ๐ฌ๐๐ฌ ๐๐จ๐ ๐๐ญ๐ก๐๐ซ ๐๐ง ๐๐ง๐ ๐๐จ๐ฎ๐ซ:
โข Blender Foundation Cou...
๐ ๐๐ฅ๐๐ง๐๐๐ซ ๐๐ข๐ฉ๐ฌ ๐๐ง๐ ๐๐ซ๐ข๐๐ค๐ฌ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Blender Tips & Tricks
๐ ๐๐๐ฌ๐ฒ ๐๐จ๐๐๐ฅ๐ฌ ๐
๐จ๐ซ ๐๐๐ ๐ข๐ง๐ง๐๐ซ๐ฌ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Easy Models For Beginners
๐ ๐๐๐ญ๐๐ซ๐ข๐๐ฅ๐ฌ ๐๐จ๐ฎ ๐๐๐๐ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Materials You Need In ...
๐ ๐๐ฅ๐ฅ ๐๐๐ฑ๐ญ ๐๐๐๐๐๐ญ๐ฌ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Text Effects In Blender
๐ ๐๐๐ฆ๐๐ซ๐ ๐๐จ๐ฏ๐๐ฆ๐๐ง๐ญ & ๐๐๐ญ๐ญ๐ข๐ง๐ ๐ฌ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ:
โข Camera Movement & Sett...
๐ ๐๐ฌ๐๐๐ฎ๐ฅ ๐๐ข๐ ๐ก๐ญ๐ข๐ง๐ ๐๐๐ญ๐ฎ๐ฉ ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Useful Lighting Setup ...
๐ ๐๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐ก๐ฒ๐ฌ๐ข๐๐ฌ & ๐๐ข๐ ๐ข๐ ๐๐จ๐๐ฒ ๐๐จ๐ง๐ฌ๐ญ๐ซ๐๐ข๐ง๐ญ๐ฌ:
โข Rigid Body Physics in ...
๐ ๐
๐ข๐ซ๐ & ๐๐ฆ๐จ๐ค๐ ๐๐ข๐ฆ๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Fire & Smoke Simulatio...
๐ ๐
๐ฅ๐ฎ๐ข๐ ๐๐ข๐ฆ๐ฎ๐ฅ๐๐ญ๐ข๐จ๐ง ๐๐ง ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Fluid Simulation in Bl...
๐ ๐๐๐ฌ๐ญ๐๐ซ๐ข๐ง๐ ๐๐ฅ๐๐ง๐๐๐ซ (๐๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ๐ฌ):
โข Mastering Blender
#Blender #Animation #WorldData #Excel
Timestamp
00:00 Intro
00:30 Run script-1 to link with excel
01:20 Run script-2 for data comparison
03:02 Run the animation and verify
03:58 How to setup your camera
ะัะบััะปะตั: 183
๐ ๐จ๐ซ๐ ๐๐ญ ๐๐๐จ๐ฎ๐ญ ๐ญ๐ก๐๐ฌ๐ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ๐ฌ ๐๐ง๐ ๐ฎ๐ฌ๐ ๐จ๐ฎ๐ซ ๐๐๐ญ๐ ๐๐จ๐ฆ๐ฉ๐๐ซ๐ข๐ฌ๐จ๐ง ๐๐๐-๐จ๐ง, it's more powerful, more flexible and easy to apply - ๐๐๐ซ๐ ๐ข๐ฌ ๐ญ๐ก๐ ๐ญ๐ฎ๐ญ๐จ๐ซ๐ข๐๐ฅ ๐ kzread.info/dash/bejne/eX2A19iteNazfrw.html Get it from ๐ 5minblender.gumroad.com/l/3d-data-visualizer or www.blendermarket.com/products/3d-data-visualizer
@kumargaurav6770
11 ะฐะน ะฑาฑััะฝ
Hey Bro, how to stop bars from resizing, like if you see next bars decrease/adjust their height after they appear, it is making it hard to use your flag plugin, any ideas to change the script?
@nabilelh6613
8 ะฐะน ะฑาฑััะฝ
Hello What application do we need to open a file exr hdri ?๐
@MH_Educate
8 ะฐะน ะฑาฑััะฝ
whenever i paste the code indent error occur what to do now
@5MinutesBlender
8 ะฐะน ะฑาฑััะฝ
@@MH_Educate Use notepad to copy-paste code so that no unnecessary fancy things happen in between. Also, if the indent error is just on one line (quite common for the first line or the last line while copy-paste), it may be easier to rectify that manually. Just add spaces or remove spaces to match it with surrounding lines.
@5MinutesBlender
8 ะฐะน ะฑาฑััะฝ
@@nabilelh6613 Looks like I missed replying to this comment, extremely sorry for that! You can use Photoshop to open these files. There may be other apps as well, but I am not aware of. Photoshop is good.
Great video! This is something I never consider doing with Blender and you make it easy!
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Glad I could help! ๐
Thank you โค๏ธ so much this tutorial is very helpful for us.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Glad it was helpful! ๐๐๐
@footballclubdata
7 ะฐะน ะฑาฑััะฝ
Where can I get the second script please?
Thank you so much this tutorial is very helpful for us
@5MinutesBlender
3 ะฐะน ะฑาฑััะฝ
Glad to know that it was helpful for you ๐๐๐
Muy bueno video, muchas gracias por subir estos tutoriales
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you so much ๐๐
If you getting an error while running your first script then you must turn off your Anti-virus. Thanks. It solves my problem.
@5MinutesBlender
3 ะฐะน ะฑาฑััะฝ
Thanks for sharing the tip, it may help others๐๐
Thank you so much bro , God bless you ๐ฅฐ๐ฅฐ
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you too ๐๐
Great video, thanks
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Glad you liked it! ๐๐
Cool! ๐
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you ๐
Great video brother โคโ๐ฅโคโ๐ฅโคโ๐ฅ๐ค๐ฅฐ
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thanks for joining us ๐๐๐
Love it!
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you so much ๐๐
@mariegrasmeier9499
ะัะป ะฑาฑััะฝ
@@5MinutesBlender Are you planning to release it as an addon or will it always require the scripting magic?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@@mariegrasmeier9499 Probably we'll come up with an addon later with more functionality and more options to add. However, the basic module installation (to connect your excel file) still remains a challenge today because it fails in some cases due to access restrictions. It can be solved by using the portable version of Blender, but that is not a good commercial solution. Once we get a better solution for that, we can easily create an addon. By the way, thanks for your suggestion ๐
ุฑุงุฆุน ุฌุฏุง ูุง ู ุจุฏุน
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you so much ๐๐
It is very good
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you ๐
Nice... very helpful for my comparison data channel
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Glad it helped ๐ Did you create something with the script?
@most3d
ะัะป ะฑาฑััะฝ
@@5MinutesBlender not yet. Maybe next project
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@@most3d All the best! Any help needed, we're here!
@leultesfaye5533
ะะน ะฑาฑััะฝ
is it still monetized?
@most3d
ะะน ะฑาฑััะฝ
@@leultesfaye5533 yes
You finally made it ๐ ๐
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Yes bro ๐
No words to thanksโค
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Most welcome ๐
Pls make a separate video and do all the stuff , to prepare the Excel file and add the image file location and also how we can add the Excel sheet location in code also.โคโค
Helo.. thanks for sharing this script, very helpful. but if I may ask, how do I change the width of the Bar and its image? because i want to make with Bar and bigger image. And I've tried adding a flag, but the flag can't move following the bar animation and just stays in place. are there any tutorials for this? I would really appreciate your help, because I'm still learning and still experiencing many problems. especially in the animation section. Thank You..
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Glad to know that you liked our tutorial. Regarding the width of the bar and the size of your image, it is possible to do that by changing few things in the code. But I think the width is optimum. If you make it wider, it may not look good. See, everything is relative. Instead of making the bar wider, you can use lesser height and bring the camera closer to the bar (change the y-location of the camera, we moved it along x and z dimension, y is not touched, so you can freely move it along y as you need). It will be the same as making the bar wider. You don't need to use a bigger image, you need to bring the camera closer, the picture will automatically look bigger. Now coming to the flags, we did not create a tutorial on how to move the flag along with the animation of the bar. But it is not very difficult to do. You need to fix the flag to the pole by using a hook modifier. Then animate the pole along with the data bar, the flag will automatically animate with it. Something similar to this is discussed toward the end of this tutorial ๐ kzread.info/dash/bejne/mIyTmpmvZ7anac4.html
where did you get the tts?
โคโค
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Thank you ๐
Hi @5 Minutes Blender, your videos are very beautiful compliments, but is it possible to replace the cube with another previously created geometric shape?
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
Thank you for the appreciation ๐๐๐ As of now it is not possible to replace the cube with any other model. We can implement that later, but the problem is with the text and the picture that display on the cube. With any random model it won't be possible to display the text and the picture like that using a script.
@T.N.T.84
6 ะฐะน ะฑาฑััะฝ
@@5MinutesBlender Thanks for your knid reply. I understand, i can image that the text not always is possible to connect with the shape (cube or others). Can you say me, how i can to buy the add-on please?
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
@@T.N.T.84 You can visit our stores (links given in the pinned comment below) and purchase the add-on. Please let me know if you find any issues.
Bro if u don't mind can u make a tutorial on how to make heartbeat animation in blender??? Not that human heart but โค๏ธโค๏ธ this type of heart and it's beating animation.. please
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Okay, noted down. We will see if we can get it into the list of future tutorials. Thanks for the suggestion.
Please sir make another tutorial for us how to change script and add flag on blender
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Sure thing! We'll bring another tutorial and a free script for automated flag for each of the data columns ๐
How do you adjust the picture display so that it will display with 4x5 picture or a movie poster dimension?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, we need to make some modification in our script to accommodate these changes. If you are a member of this channel, send me your requirements - I will help you with the modified script.
If you are getting an error while running the 2nd or the 3rd script, it is often due to access restrictions. You can use the Portable version of Blender (steps are given here ๐ bit.ly/5mbexcelscripterror) or use the CSV version of our script which is explained here ๐ kzread.info/dash/bejne/hmhtsaRmdsi2ZtY.html
@DAIMSTALKS
ะัะป ะฑาฑััะฝ
Can you please make a video on module not found error or all the possible errors that are comming
@kushagrashukla7668
ะัะป ะฑาฑััะฝ
Which software are you using?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@@kushagrashukla7668 This is created using Blender. It is a free and open source software which is very powerful. You can download it from www.blender.org/download/
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@Revenge-Time-CR We are coming up with an addon next week. It will be available on our store and will be a lot easier to work with than these scripts.
@UtubePasu
10 ะฐะน ะฑาฑััะฝ
i am getting modulenot found error for pandas file@@5MinutesBlender
How do you make the width of the bars wider so longer text can fit?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, we need to make some modification in our script to accommodate these changes. If you are a member of this channel, send me your requirements - I will help you with the modified script. Otherwise I suggest you to use the same script and run it. Let the text get truncated. You can manually select the text objects and reduce the font size. That will be as good as using a wider pillar.
Hi โคโค
Can i change the size of the bars if i buy it for 10 dollars, and will it cause any problem to camera movement
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
You should not change the height of the bars because it is automatically driven by the data you feed into the add-on. You have an option to either normalize the input data or leave it as it is in the add-on. In either case, the height of the bar is auto-calculated and the camera is placed accordingly so that the output looks good. Having said that, you can definitely change the bar heights manually after the add-on creates everything. But in that case you need to also adjust the camera position/ movement manually to capture the bars correctly.
hi,i want to know which virsion of the Blender and the python you are using.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Blender 3.5 and Python 3.10 but actually the built-in python that comes with Blender is being used for the script, not the one separately installed on my machine.
i am facing this error in both cvs and excel texture.image = bpy.data.images.load(display_pic_list[data_counter])
@5MinutesBlender
9 ะฐะน ะฑาฑััะฝ
Ok, this is a line from the code. What is the error that you're getting? Go to the Window menu > Toggle System Console. It will display the details about the error. I guess your picture file name in the excel/csv may not be correct. Check for the correct name along with correct extension.
Can you please make a video on module not found error or all the possible errors that are comming
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, I have checked several cases where people got this error "No module called pandas". The reasons and the possible solutions are so wide-spread based on the source system that I doubt if we can cover them in a video or whether it will be truly useful. It is about failure to install a 3rd party module (that our first script does) - and it can happen for various reasons. So instead, we later came up with the CSV option which does not need any 3rd party module. So it works 99% of the times (in the rest 1% rare cases you can use the portable version of Blender and it will work). We created a video on this ๐ kzread.info/dash/bejne/m2eao9aKmpCciJM.html and added the CSV version for every script that we have published so far. Those are given under the respective videos.
Please let me know on which basis I will access the third script. (I really need it)
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Please join our members group by clicking on the join button (visible below any of our videos and also on our home page). It has a very small monthly fee, in exchange you get all our tutorial files and a free product every month.
i created a ecxel file with 5 company names and their aftter running the file i only had got the first bar with no picture
@5MinutesBlender
ะัะป ะฑาฑััะฝ
It seems the script ran into some problem after adding the first bar, and it is most probably due to a missing font file. Please check our updated description where we have added a link to the font file and also updated the script (a minor change). If the error still persists, please send your system console screenshot to 5minblender@gmail.com and we'll get it fixed.
Sir > Can you tell me Which verson you use
@5MinutesBlender
ะัะป ะฑาฑััะฝ
We created it in Blender version 3.5 but it should work in any version above 3.0 since we used only very basic functions.
Hello, can you please tell me if I can make renderings like this with an RTX 3050 Ti video card? Together with i7-12700H and 16gb DDR5 Ram. Thanks
@5MinutesBlender
8 ะฐะน ะฑาฑััะฝ
Yes, it should be generally good. But I may not know every specific about the video cards, you can follow the official guideline on this case. For comparison videos, I believe it should be sufficient.
I want to make competition video with 360 eara by blender, but I dont Know, how to combine 360 eara that befor downloaded with charts
@5MinutesBlender
11 ะฐะน ะฑาฑััะฝ
You mean 360 degree video? I did not understand what "360 eara" is, so can you please elaborate it?
Once i pay for a membership, will i have access to these scripts without this permission thing
@5MinutesBlender
2 ะฐะน ะฑาฑััะฝ
Yes. You will get access to this script and the other scripts similar to this that are available for our members.
kindly tell me about the version of Blender you are using.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
This tutorial was made in version 3.5 beta. We have shared two versions of the script, one for Blender 3.5 and higher, another for 3.4 and below.
Hello What application do we need to open a file exr hdri ?
@5MinutesBlender
8 ะฐะน ะฑาฑััะฝ
You can surely open it using Photoshop (and maybe with some other applications as well, but I don't know of any).
I have an error in line 62 of the second code ( data_height_mean = sum(data_list) / len(data_list)
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Can you please send the full console output that shows the error details? Or send your excel file so that we can run it and see the error. We can then send you a fix. Our email ID is 5minblender@gmail.com Thanks!
Brother, how to make 3d comparison video make, give voice to the videos in Hindi through ai.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
You can look for some tutorials on KZread regarding the audio editing, we don't focus on the audio part. Btw, we do check every comment from our viewers and we reply as soon as possible, no need to leave the same comment on multiple videos ๐
Making data comparison video with excel will monitize by youtube or not?
@5MinutesBlender
7 ะฐะน ะฑาฑััะฝ
That's something that KZread can best answer. But many such channels do get approved for monetization. Whether you create contents with automation or not, is not the issue. Whether it is interesting enough or informative enough, whether it is really appealing for a general viewer, is the question - so your creativity is going to play the key role. We always use some tools or the others to create contents. If you get an audience and they really like your video, I don't think monetization will be an issue. Focus on creating an audience, money will automatically follow you.
Great Video. I have 2 questions. 1. Can you please elaborate how we can customize the material of cubes? 2. How to add flags (I have seen your flags video) from the csv file?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
1) To customize the material, you need to select a cube and open shader editor. There you can change the color or the material, its shine or roughness etc. If you know Blender well, you can do much more complex things in the shader editor. 2) We have a plan to come up with another script or addon to add flags quickly for such comparison videos, but currently there is no easy way to do that from a csv file.
@victory.vaultt
ะัะป ะฑาฑััะฝ
Can you make video on it how add flags on cubes with this method or others way?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@@victory.vaultt Yes, we're coming up soon with an Addon for our members to add flags automatically on the data pillars.
@victory.vaultt
ะัะป ะฑาฑััะฝ
Ok thx but quickly
@5MinutesBlender
ะัะป ะฑาฑััะฝ
@@victory.vaultt This month itself ๐
Bro the 2nd script asking for fonts file Arialbd.ttff where to get this file?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Uploaded the font file and updated the script as well, please download the new script and mention the font location in the script.
Python: Traceback (most recent call last): File "\Text", line 240, in RuntimeError: Error: Cannot read 'C:\MyTest\Pictures\JoJ': No such file or directory please help
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, you need to create a folder as C:\MyTest and create a subfolder there called Pictures, and keep your logo files there. If you use a different folder, you need to update the same in the script. Please also check if it is JoJ or J&J and also check if there is an extension like jpg or png. Looks like something is missing in this line.
where did you get the tts? iam getting the font error
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Did you keep the font file in the right location as suggested in the video description?
what the process to be member of your channel
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
You can click on the JOIN button and proceed with the payment process. This button should be visible below watch of our video and also on the homepage. Please let us know if you need any help.
Bro i have a question that we make this excel file themselves?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
We need to make the excel file ourselves. You wanna automate that part as well, maybe with ChatGPT? ๐ค๐๐
@victory.vaultt
ะัะป ะฑาฑััะฝ
I don't understand, can you make video on this topic plz?
@victory.vaultt
ะัะป ะฑาฑััะฝ
where are you from?๐ค
Where can I get the second script please?
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
Please check the video description, the links are given there.
Ok I solved the other errors. How? 1. If step 2 fails download portable blender and install 2. Open it as administrator 3. Run script 1 4. Run Script 2 Then i get this error Python: File "\Text", line 199 ob.data.font = bpy.data.fonts.load("C:\Users\Julio\Documents\Arialbd.ttf") ^ SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Yes, it works without any issues with the portable version. Regarding the other error, it is asking for a font file which we have missed. Now we have updated the script and also uploaded the required font file and shared it. Please check the video description once more and download the updated script along with the font file. You need to change the font file location (which you correctly did as I can see, just keep the font file there and it will work smoothly). If still any error, please let us know.
Does it run for LibreOffice?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
You can use it with LibreOffice as well. The script has two versions - one for Excel and another for CSV files. First export your data into CSV format from LibreOffice. Then use it with the CSV version of the script, it should work.
Python: Traceback (most recent call last): File "\Text", line 98, in KeyError: 'bpy_prop_collection[key]: key "Camera" not found' How to solve this
@5MinutesBlender
ะัะป ะฑาฑััะฝ
The script expects a camera called "Camera" in your composition. This camera is present in the scene by default unless you remove it. If the script fails to find that "Camera" it will throw this error. Please add a camera into the scene and give it this exact name: Camera. Then run the script again.
First Script Installed Successfully then also getting Following Error in 2nd Script Error: Python: Traceback (most recent call last): File "\Text", line 3, in ModuleNotFoundError: No module named 'pandas' Please help Sir
@5MinutesBlender
ะัะป ะฑาฑััะฝ
This actually means the first script did not execute correctly. It does not throw an error in the first script because that script did install the required package - but in a wrong location. So the second script fails. It can be corrected, but if you are very new to python and scripting, I would suggest you to use the csv version of our script instead. It does not need any extra installation, it works right with your existing Blender, hence it's the easiest solution. You need to only convert your excel file to csv (Save As in excel and choose the comma delimited option).
Why doesn't it make more than 15 bar? I gave it 49 pen in the excel file, but it makes 15, can you help me?
@5MinutesBlender
11 ะฐะน ะฑาฑััะฝ
There is no such limit in the script. If it makes only 15 and then stops, it means it encountered some error at number 15. You can see the error details in the console (Window>Toggle Console) and take a corrective action. Otherwise delete row number 15 onward, and repeat row 14 several times, say 6 more times (because row 14 was processed correctly). Now run the script. If it creates 20 bars, it means - that row 15 indeed had some problem with its data. Please let me know what you find out from this exercise.
File "\Text", line 259, in RuntimeError: Error: Cannot read 'โชC:\Users\SKY\Documents\flags\Switzerland.png': Invalid argument
@5MinutesBlender
10 ะฐะน ะฑาฑััะฝ
The most likely cause of this error is, you may not have access to that folder or the image file does not exist there. Please check for any spelling mistakes. Use a simple location like C:\Test first, if it works you can move things into the proper place. This error has nothing to do with our script, it is a system input-output error it seems.
What are the minimum requirements to run this on the PC?
@5MinutesBlender
5 ะฐะน ะฑาฑััะฝ
Same as the minimum requirements mentioned on Blender's official page ๐ www.blender.org/download/requirements/
how can i get membership?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
You'll see a Join button below any of our video. Click on the same and follow the instructions there to pay and join us.
Brother Can you give the solution For rendering video fast Because it takes very long time to render only two seconds video
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, are you using Eevee or Cycles? Please use Eevee for a fast rendering. It takes about 4-5 seconds for rendering each frame (or even less if you have a good machine), so for a 1-minute long video it takes 2 hours at max for a basic machine. Usually it takes even lesser time (1-1.5 hrs). If it is taking more time for you, there is probably some problem with your scene setup. And don't render the entire scene at a stretch. Give some rest to your machine intermittently otherwise it will heat up soon.
@gulbhai-gp7nm
ะัะป ะฑาฑััะฝ
@@5MinutesBlender brother Can you make video on this i don't know eveee
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Blender by default uses Eevee. If you did not change it to Cycles, it is probably already set as Eevee in your case. If it is still taking a long time, the problem is somewhere else. Please send your blend file to us (5minblender@gmail.com) so that we can verify. Please write the problem statement as well in the mail, otherwise we won't be able to connect, we get tonnes of mails everyday.
5
its giving an error when run 2nd script. Python script failed
@5MinutesBlender
ะัะป ะฑาฑััะฝ
The source of the error is in the first script. Please check the video description for the error scenarios and the solutions. Best is to use the portable version of Blender which is proved to work always. But change the script as suggested there.
@BukhariVoice-zx4tl
ะัะป ะฑาฑััะฝ
@@5MinutesBlender when i click to render the blender just close
@5MinutesBlender
ะัะป ะฑาฑััะฝ
โ@@BukhariVoice-zx4tl This usually happens when your machine has insufficient RAM. Do you have any complex object in your scene apart from the data columns? Our script itself should not cause Blender to crash. So I'm wondering why this happened in your case ๐ค๐ค
How to become a member?
@5MinutesBlender
9 ะฐะน ะฑาฑััะฝ
You can take our membership by clicking on the JOIN button. But if you are only interested for data visualization, I suggest you to purchase our 3D Visualizer Add-on. It is far easier to use than the scripts, and it comes with all the scripts built-in that we have published so far on data comparison videos. You get everything together. The tutorial on this add-on and the links are here ๐ kzread.info/dash/bejne/eX2A19iteNazfrw.html Our membership program is different from the Add-on. It has a small recurring monthly fee. You'll get access to our scripts and other assets for every month, but this add-on is not included in the membership package.
Bro it shows cannot read C\MyTest\pictures\j j.png. i have tried changing names in excel and even of my file but this is showing
@5MinutesBlender
10 ะฐะน ะฑาฑััะฝ
Hmm. Are you sure that you have access to that file and there is no typo? It seems a system input-output error or access problem, not related to the script.
@sonusharma90671
10 ะฐะน ะฑาฑััะฝ
@@5MinutesBlender bro i created a folder called pictures in MyTest folder and in pictures folder i downloaded 3 png images and kept same name as given in Excel file and had also tried it in reverse way changing name of Excel file , why it shows error or there is something I am missing?
@5MinutesBlender
10 ะฐะน ะฑาฑััะฝ
@@sonusharma90671 Do one thing. Send us three screenshots to 5minblender@gmail.com 1) The script that you are running (just the top part where the file locations are mentioned) 2) The error screenshot from console 3) Windows explorer screenshot showing the location & names of your files. Something is missing somewhere, we have to find it out.
Can you share the code please
@5MinutesBlender
6 ะฐะน ะฑาฑััะฝ
Please check the video description, the download links are given there. Btw, I am traveling, so this late response.
hello sir, I am getting this error while I am running first script, I tried everything that you prefer but ฤฑ couldnt solve, pls help Python: File "\Text", line 6 subprocess.check_call([pybin, '-m', 'pip', 'install', 'pandas', '--target=C:\Users\orhan\OneDrive\Masaรผstรผ\KZread\BLENDER\blender-4.0.2-windows-x64']) ^ SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 11-12: truncated \UXXXXXXXX escape
@5MinutesBlender
5 ะฐะน ะฑาฑััะฝ
Hi, you should use double slash '\\' instead of single '\' as shown in our docs. Also the path seems to be wrong. Please refer to our docs for the correct path, it ends with site-packages, not windows-x64 ๐ค
ะะตั ะดะพัััะฟะฐ ะบ ัะบะฐัะบะต ัะฐะนะปะพะฒ.
@5MinutesBlender
8 ะฐะน ะฑาฑััะฝ
Some of our scripts are free for all, you don't need access to open them. But some scripts are only available for our members. The main part of this animation is available for everyone, it is free. Only the enhanced version that includes the camera & lighting setup would require you to take our membership. You can create the basic animation without any special access. Which script are you trying to download?
@computer_game
8 ะฐะน ะฑาฑััะฝ
I would like to create a channel on this topic. You have the skills and the tools. As I understand it, the script package automates the placement of the camera, and I wanted to download this package, since I do not know how to place the camera, and there are no detailed instructions in the video. How can I get your membership? Or you could teach me how to work with a camera.
my error after step 2 : Error: Python: Traceback (most recent call last): File "\Text", line 3, in ModuleNotFoundError: No module named 'pandas'
@Bigdata3d466
ะัะป ะฑาฑััะฝ
Me too , did you find the solution?
@5MinutesBlender
ะัะป ะฑาฑััะฝ
The easiest way to solve it is to use the portable version of Blender with administrative privilege. From another comment I can see that Warigato solved this issue with the portable version which is great!
@footballclubdata
7 ะฐะน ะฑาฑััะฝ
Where can I get the second script?
Hello have error, thaks for help in advance Report: Error 111 Python: Traceback (most recent call last): File " \Text", line 56, in File "CAUsers\KiriMppData\Roaming\Python\Python310\site-packages\pandas\io\excefi_base.py", line 478, in read_excel io = ExcelFile(io, storage_options=storage_options, engine-engine) File "C:\Users\KiriMppData\Roaming\Python\Python310\site-packages\pandas\io\excefi_base.py", line 1500, in _init_ raise ValueError( ValueError: Excel file format cannot be determined, you must specify an engine manually.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
This is an error I saw with corrupted excel files. Are you sure that you're using the correct file with the correct script (excel file with excel script and csv file with csv file - not the vice versa)?
@user-bl4xu8wf3e
ะัะป ะฑาฑััะฝ
@@5MinutesBlender Thanks a lot
kzread.info/dash/bejne/eZlspMShZ9iuhrw.html How to make this like video ๐๐
@5MinutesBlender
ะัะป ะฑาฑััะฝ
That's a full course character animation - just like tom & jerry and similar toons. Too broad to explain here and it's a long journey before someone can create an animation like that.
hey why are you removing my comment
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi, we did not remove anything. What did you comment? I will check if the spam filter caught something and let you know.
@dakshsahni5693
ะัะป ะฑาฑััะฝ
@@5MinutesBlender This is my error drive.google.com/file/d/1bvhEttM7NkFvMzwME1ZySaRYjTKp8rVw/view?usp=share_link
@5MinutesBlender
ะัะป ะฑาฑััะฝ
Hi Daksh, saw this error. It seems the location where you have your excel file and what you have mentioned in the script are different. Please check the location and the path.
@dakshsahni5693
ะัะป ะฑาฑััะฝ
@@5MinutesBlender ok i recreated the excel file then this error drive.google.com/file/d/12SRZaVG4GenLyMeBW2-F7zfFBahC9er0/view?usp=share_link
blender not responding ๐ ๐ช๐ช
@5MinutesBlender
ะัะป ะฑาฑััะฝ
At which step? The first time you run a script after starting Blender, it's going to take some time.
@GuessGuru291
ะัะป ะฑาฑััะฝ
@@5MinutesBlender i wait for 2 minutes nothing happened and on above showing blender not responding text.
@5MinutesBlender
ะัะป ะฑาฑััะฝ
It does show "not responding" msg but it works in the background. Do one thing. Open the System Console before you run the script. Now run the script and switch over to the console window. It will show you the progress, you'll know what is happening, or if anything is happening at all. You will get a better idea when it may finish.
Bro please 3d piller compirison vedio make from A to Z tell in vedio For example : Floor tutorial Background's tutorial Sky download Floor download link please playlists from A to Z๐ข๐ข๐ข
@5MinutesBlender
11 ะฐะน ะฑาฑััะฝ
Hi, we have a playlist that covers all Data Comparison tutorials kzread.info/dash/bejne/noue0pmelJfAhrA.html&pp=gAQBiAQB But no tutorial specifically for the floor or the background. These are very trivial and you can create them if you just know the basics of Blender. I suggest you learn the basics and create them yourself. If you are planning to create very attractive comparison videos, you'll definitely need to do a lot of things yourself. Even if you get help on creating basic things like a floor, it won't help you go further in future. Blender is not difficult to learn, you can learn it in a few weeks. Try it ๐