Anyone? I'm desperate, haha.

Hello!

I'd like my project to have the ability to write and read from an active Google Sheets spreadsheet.

In simple terms I'd like the following: User inputs get stored in a column in one google spreadsheet. Then, I'd like Construct to reference the same google sheet to call cells in the same sheet.

I've been using the following tutorials to try and accomplish this:

For sending data to Sheets: construct.net/en/tutorials/sending-data-from-construct-23-to-google-spreadsheet-1447

- This one works like a charm, no issues at all getting data from construct into Google Sheets.

For retrieving data from Sheets, into Construct 3: construct.net/en/tutorials/create-online-database-with-google-spreadsheet-1373

- This is where I get stuck. For this tutorial, you need to publish the google sheet as a CSV first. The problem is that I need to publish the document from Google Sheets, there's no way that I know of to publish from Construct after the game data has been imported into sheets. And if I publish to a CSV file first, then I can no longer edit the spreadsheet from in-game to load new data.

Is there a way to use Google Sheets in the way that I want to?

I found a previous forum post from several years ago that described copying data from one sheet in google sheets to another, so that one could be published while still using the other one, but they did not describe how they were able to do that from Construct.

If there's anyone that knows how to do this, or could help me figure it out, I would be very much appreciative.

Thank you!!

Hello!

I have a very simple video player in my project, which basically asks you to choose a folder in your hard drive, and then loads all videos inside the selected folder.

I'm noticing a strange issue when retrieving the total number of files in the folder, using "FileSystem.FileCount".

When selecting a folder on my local drive, the file count is perfect (folder containing 105 files will return "105"), but when selecting a folder off of an external USB drive, the file count is always double what its supposed to be (USB folder containing 105 files will return "210")

Why does this happen?

In case its relevant, I work on a Mac and the USB drive is formatted "Ex-FAT"

Here's the project file, in case it's helpful: dropbox.com/scl/fi/32d08u085r3uebr3jvgqm/filesystem_videoLoad2.c3p

Again, I'm so thankful for any help!

Okay, turns out I still need a little help.

Once I list content for the sub folder, I can't seem to iterate through the contents, because "FileSystem.FileCount" & "FileSystem.FileNameAt" seem to reference the main folder still.

I tried playing with the File Tag, but it didn't seem to help.

Awesome, that makes perfect sense!

Thanks for all the help!! :)

I think I figured it out!

It didn't occur to me that I'd need to create a new BinaryData object for each file loading in, but I tried and now it works perfectly.

-

One separate question that has now come up: Right now the folder chooser will select all files in the folder, but if a subfolder is inside that folder, neither the subfolder or its contents are included.

For example:

If I were to select the MainFolder in file system, it would return only:

- video1.mp4

- video2.mp4

- video3.mp4

Is there a way I could include the files contained in the subfolder? So that it would return:

- video1.mp4

- video2.mp4

- video3.mp4

- video4.mp4

- video5.mp4

Any help would be great.

Thanks!

Thank you! It feels like I'm really close now!

I was able to get it working with individual videos, but I'm having trouble finding the way to upload all videos in a selected folder.

The way I have it right now, when a folder is selected, each item in the folder is read into a binary file, and then URL from BinaryData.GetURL is saved into an array. The idea is that the arrow keys would then let you cycle through the videos saved to the array. But it's not working, so I assume there is something I'm not quite getting.

Here's the project file I've been testing with:

dropbox.com/scl/fi/omqtdmi1ku8lm83ns9zcp/filesystem_videoLoad.c3p

If you're able to take a look and help me figure out where I'm confused, I would be so appreciative!

Thank you so much!

After reading about the file system plugin, I was able to quickly retrieve a list of filenames from a folder on my hard drive.

It's okay that it doesn't automatically access the folder, I'm okay with the way I have it now: Opening the file browser and navigating to the folder I need to import. I have it so that selecting that folder fills an array with the filenames of its contents.

Now I just need help importing those files into the project. How can I get the videos in the folder into the project, so that they can be used as the source of a video object?

I need help! I'm a relative novice to game design, and coding in general, and need to know if the following is possible in Construct 3. Any help at all would be so appreciated!

I have a project that needs a very basic video player, which I was able to create by uploading all my video files into the project, filling an array with the filenames of those videos, and then using them as the source for a video object.

The problem is: I'd like to not have to upload the videos into the construct project first. Basically, I'd like to have a folder saved on my computer somewhere, that I'm able to fill with as many video files as I want. Then next time I run the Construct file, the game will automatically load the videos from that folder.

Can this be done? Please help me, thank you!

I'm trying to build a video player in my game, but I'd like to load in videos directly from a folder in my hard drive, without importing to Construct 3 first. I basically want to be able to fill a folder on my computer with a bunch of videos, and then when I run the game, whatever videos were added in the folder will automatically be loaded into the game.

I'm pretty new to all this, so I've had trouble understanding documentation on exactly how to get this done. I understand that the "NW.js" object would be used (Possibly AJAX, as well?), but I'm afraid I'm getting tripped up on how to use them. For example, when attempting to use the NW.js "List files from..." action, I'm not sure I'm even formatting the file path correctly, because every attempt to list folder contents comes back empty.

If anyone can assist me, or point me toward the right direction, it would be much appreciated!