super tutorial!!!! Also it was terrific to see your debugging process and thinking out loud process was also very helpful. Keep up the amazing content!
@inPrincipleGames
9 ай бұрын
Thank you for the kind words. Unfortunately, while I keep up with the comments on this channel, I don't upload content to it anymore, as the ratio of earnings to effort makes no sense at all to me. Or anyone, really, considering this channel has never been monetised! But I'm glad you found this content helpful and I wish you all the best in your work.
@jameslavery2958
4 жыл бұрын
I'm glad that I found your channel. I have a project that I wanted to write back more than one bit of information to a cell. Nice job explaining this topic. Most helpful. Thanks.
@inPrincipleGames
4 жыл бұрын
Glad to be of service. if you feel like supporting me, please check out store.steampowered.com/app/942520/Thrusty_Ship/
@user-ui2qk3tq1u
4 жыл бұрын
You are a genius and a life saver! this is exactly what i needed and couldn't find how to do it that simply anywhere else. Thank you a lot for this video! :)
@inPrincipleGames
4 жыл бұрын
Appreciate the kinds words. If you feel like supporting me, please consider buying a copy of my latest game, Thrusty Ship: store.steampowered.com/app/942520/Thrusty_Ship/. It's 50% off right now! Thanks!
@alexpenalva4093
10 ай бұрын
El link del archivo para probarlo esta caido
@AgataFeelin
3 жыл бұрын
Fantastic! This is precisely what I needed and your code is so clear I did not even had to go through the video! Many thanks
@inPrincipleGames
3 жыл бұрын
Glad to be of service. Cheers.
@AgataFeelin
3 жыл бұрын
@@inPrincipleGames Would you have the opposite tutorial by any chance (Import .csv data into Unity)?
@inPrincipleGames
3 жыл бұрын
@@AgataFeelin Already done, but a much longer tutorial. kzitem.info/news/bejne/x6KGrKaoj2OaaGU. But I suspect you want something very different. Making tutorials is very unprofitable for me, unfortunately, so I almost never have time to make more. See if this helps, if not, let me know.
@haechanlee6460
Жыл бұрын
Thank you so much!!! Your video helped me a lot, I love you
@inPrincipleGames
Жыл бұрын
Glad to help
@LeochannelTV
3 жыл бұрын
Thank you so much for this video! I wasn't able to find a solution to my problem anywhere else and your video did exactly that. Also the tutorial was clear and easy to follow. Keep the good content!! :)
@inPrincipleGames
3 жыл бұрын
Thanks Leonor, glad to be of service.
@TheStoryBlueprint
3 жыл бұрын
Exactly what I was looking for, thanks so much!
@inPrincipleGames
3 жыл бұрын
My pleasure, thanks for the kind comment.
@amirabarham1515
3 жыл бұрын
I love you man. Literally saved me hours
@kilianruchti8969
3 жыл бұрын
Really great video, well done ! Exactly what I was looking for, thank you :)
@nv7287
2 жыл бұрын
OMG awesome! This is so well done thanks a lot!! You made something hard look doable!
@basiliki1989
3 жыл бұрын
In case you have a problem downloading the project files check if your anti-virus interfering (was my case)
@MrNico5301
3 жыл бұрын
Nice tutorial ! Thank you, you save my day !
@inPrincipleGames
3 жыл бұрын
No worries. Glad to be of service.
@SV-mh7cj
3 жыл бұрын
Super! You made a pefect code that help me! Thanks a lot!
@inPrincipleGames
3 жыл бұрын
My pleasure.
@wenhanchia8448
3 жыл бұрын
Thank you! It's a huge help :)
@sanjanapandey5156
2 жыл бұрын
this link that you mentioned for download project files is not working can you please check
@inPrincipleGames
2 жыл бұрын
It's working for me, but I do get a warning from my browser that the connection could be insecure, because my website (www.inprincipleinc.com) is not https. The link is functioning. Download the file at your own risk.
@PP-up7ox
2 жыл бұрын
How does one export data from unity to .CSV but using a wireless connection?
@inPrincipleGames
2 жыл бұрын
Not so sure how to answer this. What difference does the hardware make? I don't understand the question.
@EduardoGarcia-ib8nq
3 жыл бұрын
This was a huge help, thank you very much for this tutorial. Quick question, are you able to send these reports to an email address?
@inPrincipleGames
3 жыл бұрын
There should be classes for that you can use? Maybe in the WWW class in Unity. Alternatively, you can use VBA in Excel + Outlook to achieve the same result. I have done the second approach many times.
@EduardoGarcia-ib8nq
3 жыл бұрын
@@inPrincipleGames Awesome, thank you so much!
@walney2008
3 жыл бұрын
Hello, how are you ? I have a cv file, with musical notes and how long it should be played in sequence, how to put it to play? Do; 0.1456 Re, 0.1567 Mi, 0.1645 Do, 0.1545 so this is the csv that i am defining for example, how to read this note in sequence and play? thank you
@inPrincipleGames
3 жыл бұрын
Hi Walney. This doesn't sound too complicated. You basically need a small scheduling script with a routine that waits for an appropriate amount of time, then asks an audioSource to play the audioClip that corresponds to the note you want to play, then carry on to the next one.You can code this yourself relatively quickly. Alternatively I can code it for you, if you'd like to hire my services, just get in touch using info(at)inprincipleinc(dot)com and we can continue the discussion there.
@nurfarzanazulkhiri8967
3 жыл бұрын
HI ! How to make c# script input validate from csv file? For example, user key-in the password in unity, then the script check/validate whether it is same from csv file. If same, it can log in. Thankyou!
@nurfarzanazulkhiri8967
3 жыл бұрын
Btw, It is really good video. Hope you can answer my question :)
@inPrincipleGames
3 жыл бұрын
@@nurfarzanazulkhiri8967 Hey there, you can use System.IO to open and read pretty much any file and grab all of its text. You can then parse this text matching its structure. Assuming it's classic CSV, you would separate by line breaks first, commas second. Then you find the corresponding username and password. Any video tutorial that shows you how to read and write to and from a file should help. In this video I think I'm writing to, but the process backwards is nearly identical. Cheers.
@martin8447
3 жыл бұрын
Why not XLSX? CSV has no design values
@inPrincipleGames
3 жыл бұрын
Hey there, thanks for your question. The simple answer is that I have no idea how to write an XLS or similar directly. The goal was to write data simply so that Excel can do the conversion for us. With that said, I would very much like to write to Excel files directly some day, so that I can include formatting and all types of jazz. If I find the time someday I'll do it. Thanks for the suggestion.
@amirabarham1515
3 жыл бұрын
If, instead of wanting the data to be recorded after pressing control F1, we want the data to be recorded every second, how could we achieve that?
@inPrincipleGames
3 жыл бұрын
Hi Amir, you can create a coroutine that has a while(recording) { DoTheThingThatTriggersWithControlF1AndWriteALineForIt(); } CloseFileYoureWritingToAndSaveIt();
@jessicatello2447
4 жыл бұрын
How could I format the exported file? for example putting color to the cells
@inPrincipleGames
4 жыл бұрын
Hi Jessica. I've never looked into doing that myself. The exported file is a file you can open in Excel, but not an ACTUAL Excel file. One thing you could do is set up a file in Excel that can receive the data you export and then parse it as you prefer. VBA would be your friend there. It wouldn't be fully automated, but turn a several hour operation into 2 clicks or close enough. My other tutorial going the other way (VBA to C#) can teach a bit of VBA. In short, I don't presently know how to export an XLS file directly. Would be an interesting thing to try to be sure. :)
@SaurabhSingh-wh9zr
10 ай бұрын
i could not find report folder in my mac book after doing the scripting can any one help
@inPrincipleGames
10 ай бұрын
Check where the path goes to when exporting.
@SaurabhSingh-wh9zr
10 ай бұрын
did you create the report folder in asset or it will come automatically @@inPrincipleGames
@inPrincipleGames
10 ай бұрын
@@SaurabhSingh-wh9zr I can't remember it's been ages. :) Does it not explain it in the video?
@TheMamdos
4 жыл бұрын
Hello when I do control + F1 I have a line that is created but when I redo control + F1 I am on the same line. I have each time only one line but the line is updated ??
@inPrincipleGames
4 жыл бұрын
mamadi dioubate not sure I understand what the issue is. Can you explain what you expect should happen vs what actually happens instead?
@TheMamdos
4 жыл бұрын
@@inPrincipleGames I would like to have several lines of data but I only have a 1 line.
@inPrincipleGames
4 жыл бұрын
mamadi dioubate it must mean that you didn’t add a line break where you want the next line to go. In the code there has to be a line that says “.writeLine()” with something inside the brackets. More of these will add more lines. I did the tutorial several years ago so I can’t remember
@lucenHan
4 жыл бұрын
Thanks, very useful, it's working well. but i applied your code to mine. it wasn't working...so get back to the beginning. the latest runtime string loaded to csv. there are only two lines in the csv file.
@lucenHan
4 жыл бұрын
it's not working sw.writeline(string);
@inPrincipleGames
4 жыл бұрын
@@lucenHan That doesn't make sense. What do you mean it isn't working? What is it doing instead? I assume it compiles. So what is the effect of using that line?
@yigitpusatl5134
4 жыл бұрын
Hello, I really like your video but I have a question. I can't go to bottom line when printing to excel file, can you help me? Thank you...
@inPrincipleGames
4 жыл бұрын
Hi there. I'm not sure I understand your problem. Could you explain it in detail? Thanks.
@yigitpusatl5134
4 жыл бұрын
@@inPrincipleGames I solved the problem, thanks
@RogelioIturra
5 жыл бұрын
Awesome!!!!! Thanks for this tutorial :)
@inPrincipleGames
5 жыл бұрын
Rogelio Iturra glad to be of service
@hayke9483
4 жыл бұрын
Good tutorial man. However in my case, the CSV report doesn't take account separator. All strings are on the A colum of the file. Have you encounter this problem during the development ?
@inPrincipleGames
4 жыл бұрын
I haven't but if you're doing a pure csv, commas separate elements horizontally (in a row) and line breaks separate arrays vertically (in a column). I can see two possible explanations for your problem: 1. Your code is incorrect and you're exporting line breaks only. To diagnose this, open your export file with notepad or notepad++ (ideally), and see if all elements are separated by line breaks. You have to then amend your code so it works as intended. 2. Excel is configured in an incorrect manner to open CSVs. You should be able to find answers if this is the case using a search engine. There will be options that regulate this. Good luck.
@Juppo90
4 жыл бұрын
If anyone else gets stuck with this you can take a look at this: www.koskila.net/how-to-change-the-delimiter-when-exporting-csv-from-excel/ "How to export a CSV with custom delimiter using Microsoft Excel: 1:Make sure Excel is closed 2:Open Control Panel 3:Select “Region“ 4:Click the “Additional Settings” -button 5:Find the “List separator” and change it to your preferred delimiter such as a pipe (“|”). 6:Click OK -> OK -> exit Control Panel 7:Open the Excel file you want to export to a pipe delimited file 8:Select File, Save As 9:Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’ 10:Change the name and file extension if you want, by default stays as csv even though a different delimiter 11:Click Save -> OK -> Yes"
@hayke9483
3 жыл бұрын
@@Juppo90 Yeah, it was my character separator which was not recognized by the computer. I've change it and my problem of column was anwsered. Thanks a lot !
@THEBLEKE
Жыл бұрын
@@Juppo90 I LOVE U BROTHA, spent around 3 HOURSS!!!! trying to fix it
@naomik473
4 жыл бұрын
How do you continuously write to csv file (like in an update function) when MyTools doesn’t inherit from monobehaviour?
@inPrincipleGames
4 жыл бұрын
There are many possible solutions to the problem. You could keep your scripts static and non inheriting from Monobehaviour, but add some calls where you: 1. Open the target file, 2. Write individual lines, one by one and over time, 3. Close the file. Another option would be to create a dedicated handler that does inherit from Monobehaviour and is a singleton in your scene, that does what I described in my previous answer.
@naomik473
4 жыл бұрын
in Principle Thanks for the reply! if you could clarify, how would I repeat my call every frame using the first method?
@inPrincipleGames
4 жыл бұрын
@@naomik473 I just noticed that the CSVManager class already has an CreateReport() method and a AppendToReport(string[] strings) method. All you have to do is call CreateReport first, then AppendToReport can be called every frame and you need to feed it the strings you want. Should be as simple as that.
@user-rn5cs6hz7t
3 жыл бұрын
I have a question, if I want to record data every second, how can I write it?Thank you.
@inPrincipleGames
3 жыл бұрын
Hey there, you need to open the file when you want to start recording, then create a recording coroutine that adds a line every interval that you decide (example every second), then close the file when you're done.
@user-rn5cs6hz7t
3 жыл бұрын
@@inPrincipleGames Using coroutine is a good suggestion, I finished it! thank you!
@inPrincipleGames
3 жыл бұрын
@@user-rn5cs6hz7t No problem, glad I could help.
@belenmontabesdelacruz5890
2 жыл бұрын
This is great! Could you share the project files link again? For some reason it does not let me access it:S Thank you!!!
@inPrincipleGames
2 жыл бұрын
Your antivirus is probably blocking the file download. They are on a non-https server.
@danyalmalik4619
3 жыл бұрын
If i made this into a WebGL build, will the csv file still be saved to the persons computer via the website?
@inPrincipleGames
3 жыл бұрын
No idea. Feel free to try it out and then let us know in a comment. Thanks!
@xuehaozhang8554
3 жыл бұрын
Hi, do you find any solution for that?
@momoyaya12
4 жыл бұрын
Hello , I still didn't watch the video I just have a Question ! this video or can if you can Answer me i'd like to know that there is a possible way from unity to Edit ( No Save ) Just Edit Specific Cell the Excel File will be well Designed has it is own Tables , Images inside it and i just need to edit specific Cell from unity to the Excel File this video contain that ? or if you can Answer Me , Thanks
@inPrincipleGames
4 жыл бұрын
Hi there, this video might help with that area, but it doesn't deal with Excel files directly. I'm sure it's possible to do so, but accessing them directly is something I haven't had the need to do just yet. The video goes to CSV, which can be elegantly parsed in Excel. Now with that said, you could still design macros to read a CSV that's in a fixed place, so that you could achieve the exact result you're after. Sky's the limit.
@susmithacanny1384
4 жыл бұрын
I already tried your tutorial, but when I build the unity into .exe why it didn't work? I can't get the report.. thank you
@inPrincipleGames
4 жыл бұрын
Sorry, I'm going to need more information than that. I have no idea.
@susmithacanny1384
4 жыл бұрын
@@inPrincipleGames thank you for your response, I already got the answer.
Пікірлер: 83