Dramamini's Recent Forum Activity

  • Maybe you are using the wrong key..

    As I wrote above, open your file from google drive and copy (only) the key from the link that appears in your browser.

    Do not use the key that is generated by "Publish to web" option.

    I tested it again and it's working for me.

    Also, have in mind that:

    1. The new link which bypasses cors policy, works either if you type (at the end of the link) "YourSheetName" or the default "Sheet1" name.

    2. If you are using a CSV to Array addon to load your data, (after a construct's update) only this addon is working:

    https://www.construct.net/en/make-games/addons/234/csv-array-c3-runtime

    3. This addon is not working with worker mode.

    If you still have problem, when I find time I will make an example .c3p project file.

  • I had the same problem...

    Google has changed CORS Policy (due to security reasons) and you cannot open files using other programs, anymore.

    I found a solution for anyone who is interested in:

    The link we were using in order to open a csv file was something like this:

    https://docs.google.com/spreadsheets/d/e/.../pub?output=csv

    In order to bypass cors policy and open your csv file, the link should be in this format:

    https://docs.google.com/spreadsheets/d/SHEET_KEY/gviz/tq?tqx=out:csv&sheet=SHEET_NAME

    * You can find the sheet key by opening your sheet file in google drive

    https://docs.google.com/spreadsheets/d/SHEET_KEY/edit#gid=0

    ** SHEET_NAME, not your file's name

  • You can change CORS Policy when the file is uploaded on your server.. but what happens when you use a google sheet file?

    Google has changed CORS Policy (due to security reasons) and you cannot open files using other programs, anymore.

    I found a solution for anyone who is interested in:

    The link we were using in order to open a csv file was something like this:

    https://docs.google.com/spreadsheets/d/e/.../pub?output=csv

    In order to bypass cors policy and open your csv file, the link should be in this format:

    https://docs.google.com/spreadsheets/d/SHEET_KEY/gviz/tq?tqx=out:csv&sheet=SHEET_NAME

    * You can find the sheet key by opening your sheet file in google drive

    https://docs.google.com/spreadsheets/d/SHEET_KEY/edit#gid=0

    ** SHEET_NAME, not your file's name

  • I had "Bundle Addons" checked. I don't know why it asks for the addon...

    Anyway. I removed the addon, you can open it now..

    Thank you very much for your interest.

    Console says: "...... has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource."

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads
  • Hi!

    Few months ago, I made a project that reads csv data from a google sheet file, using Ajax: request URL. Everything was working fine, project closed. Yesterday, I re-opened it but Ajax request is not working any more. Is it working for you or should I fill a bug report?

    Here is a simplified .c3p file for testing:

    https://drive.google.com/file/d/1ZUt6Q77UqVXOBeprR4px-emjxJYagks3/view?usp=sharing

  • As I see from your screenshots, it's not only your blue background that's being dragged right and down, but also all the elements in it (the whole layer / layout). Maybe you should upload a minimal project representing this issue for further investigation

  • Maybe your sound is being triggered on every tick during animation. Try to add “Trigger once”. You can find it in system special conditions.

  • Try to disable any physics, particles, sine behavior etc, and then take the screenshot. It worked for me this way.

  • If you run an empty project or another project, it crashes?

  • Try clearing your browser's cache.

  • Hi! How many megabytes of memory is your layout using (after the loading screen)? You can monitor it either from debug window or right click your project's name (on project panel) and select "tools -> view project statistics".

    If there is a memory issue, there are some things you can do in order to solve the problem:

    1. Delete one by one the objects in your layout. Use debug mode after every deletion, in order to see which of them are significantly increasing memory.

    2. If you see that "ObjectX" is using a lot of memory, investigate it. View spritesheets (right click your project name (on project panel) and select "tools -> view spritesheets"). You may see "ObjectX" is being merged along with a big background or with other objects that you don't need them in your layout at the moment.

    3. Remember that jpeg images are being exported alone, as a single spritesheet, with no other sprites next to them, so convert -where possible- your sprites to jpeg. You can set the export image format via construct's animation editor.

    4. If you are using sprites as "hotspots", for example a transparent sprite as a clickable area, resize it through the editor and make this sprite as small as possible, for example 14x14 pixels, and then stretch it in the layout.

    5. Try to reduce the "max spritesheet size" from advanced properties panel. At default it is set to 2048 you can select a smaller size.

    6. Read C3 documentation about memory usage here:

    construct.net/en/make-games/manuals/construct-3/tips-and-guides/memory-usage

    7. Also read "Remember not to waste your memory" here:

    construct.net/en/blogs/construct-official-blog-1/remember-not-waste-memory-796

    I recommend to repeat this process for every layout in your game that uses too much memory.

    The good part is that sometimes low end devices help us programming our apps more efficiently.

Dramamini's avatar

Dramamini

Member since 4 Nov, 2017

Twitter
Dramamini has 1 followers

Trophy Case

  • 7-Year Club
  • Regular Visitor Visited Construct.net 7 days in a row
  • RTFM Read the fabulous manual
  • x6
    Quick Draw First 5 people to up-vote a new Construct 3 release
  • Lightning Draw First person to up-vote a new Construct 3 release
  • Email Verified

Progress

12/44
How to earn trophies