Hello @joseph-benguira
Perfect it works like a charm now ^^

Thanks a lot !
Best regards,

@nicolas-flam it's not possible to undo an import, but you can restore the whole database to a previous version from Cloudbackend dashboard, for example with the previous day version

FYI import will add all the rows from your csv file, not just the new ones

@joseph-benguira 👍

Hey Amir,
This is a serverless platform based on AWS infrastructure. So it's not possible to install WHMCS on Appdrag

@joseph-benguira

Solved... and I think I know why, very edge case 🙂

I had a callback at the very end of my function handler, after a bunch of async/await stuff.

Lambda has a context object:
"callbackWaitsForEmptyEventLoop"

From their docs:
"Set to false to send the response right away when the callback runs, instead of waiting for the Node.js event loop to be empty. If this is false, any outstanding events continue to run during the next invocation."

Anyway, removing the callback at the end of the function worked. I think lambda was executing the callback without waiting for the inner await'd functions to finish, which killed the running processes and prevented the updates from happening.

Does "Try" run with a different context object than a scheduled function?

Hi @jbenguira, perfect and thank you for your answer. 😉

Very useful answers. Thank you!

@jbenguira Thank you very much! I'll do that then.

@dick-honing the only access to the db is through the API (for security reasons)

But there is another option!
When you are in Cloud backend dashboard, click on database, from there you can connect to an external mysql server (can be AWS RDS or any MySQL server)

And of course since it's your own MySQL server you can have a direct access to it with the MySQL protocol 😉

@jbenguira that is excellent - thank you

@riichard-moore I get it now LOL.

@pablo-garcia we do have a tutorial here on how to create data visualization with Highcharts and Cloudbackend:
https://support.appdrag.com/doc/Using-highcharts-library

@joseph-benguira Cool, hit me up when it's done ^^

@thomasd nop, not all headers are making the cache vary, and most users will use chrome, safari or Firefox

Thank you !!!

This was a big help!!

Hey @Karol-W

"Data source Cloud Backend" is to configure which datasources are loaded on the page (don't load too many or your page will be slow)
"Triggers ->Cloud Backend" is to configure an action that will call a cloud backend function

Dynamic datasources are useful to generate pages based on url parameters, they are useless for this kind of interaction you want to do here.
So I would recommend you to remove that data source and replace it with a regular API call instead
We have more tutorials about generating dynamic content without dynamic datasources here: https://support.appdrag.com/doc/Creating-Dynamic-content-using-Factory
https://support.appdrag.com/doc/Creating-Dynamic-content-using-Visual-Factory

here you have a dropdown and you want to change the gallery content when the dropdown value is changed, so you should write some jquery code to capture the change on that SELECT dropdown $( "SELECT[name='YourSelectNameHere']" ).change(function() { var newVal = $("SELECT[name='YourSelectNameHere']").val() //Call your function to load data from the api and display it });

Thanks! you saved the day!

@thomasd it's displayed in the auto generated API function documentation (when you are editing a cloud function, click on Documentation on the right side)

@undefined Done, marked as solved 😉

I can confirm that variables in SQL are not supported on Cloud Backend

@wassim Excellent thank you 🙂

@pierre-sulpice yes, this search only on what is visible on screen, if you need to filter in the whole entries of your DB use the filters.

@Wassim thanks for you answer.

I agree that the file will be tricky to find but I still try to the basic "even hard to find it shouldn't be public when it's related to security", and it's literally for all ma security checks 😕

I thought about the other solution but I'm trying to develop something very easy to maintain for any developers even with a low formation for my clients, your solution itself is great and easy to use, I don't want to complexify it.

I think the third solution I will retain is to create a proxy route that will take care of this common code then call the adequate resource and return the result.

I think having private code outside of a route but still on AppDrag is the only major feature I miss right now !

I haven't said it in a while: Thanks for AppDrag in general, I'm really having a great time on it 🙂

See you soon,
Best regards,

Hi,
Ok I added a fix to handle them even if they're string instead of integers. It will be pushed in production tonight.

Hello @Daniel-Mulroy ,

Dropdown & Dropdown Multi Field Type are only in Cloud DB UI.
To enter content inside you have to create lists and assign a list to the column :

a82b3288-5f99-4444-b370-1941ae3cba44-image.png

a0e59966-4279-43e3-819d-a82c086d36eb-image.png

Then you'll be able to select items from your list
e554ffdb-1db7-4e70-9e97-c269fe7c58c1-image.png

It seems you think linked fields and dropdowns are the same but they aren't.

Linked fields are as their name suggest fields linked to another table Dropdowns are lists you manually create allowing users to select values from it. It can be used only in Cloud DB UI

@Pablo-Garcia

I'm confused by the word VALUE in your query. I am pretty sure that is causing the issue.

If you're coming from a different SQL platform, you should be aware that CloubBackend uses MySQL 5.8 via AWS Aurora, so your queries have to adhere to that syntax.

I think if you simply removed "VALUE" from most of your queries above things might start working 🙂

@Wassim

I'm doing that, but it's limited to 100KB per object string in the JSON.

@Joseph-Benguira suggested that I retrieve the page and parse the tags manually and then return only the HTML as the page, so I guess I'll have no other choice than to do that.

Hi,

I would use an npm package to read the uploaded file :

https://www.npmjs.com/package/csv-parser https://www.npmjs.com/package/csv-reader

And then generate the SQL request to insert it into your database.

@Joseph-Benguira soooorry got it thanks 🙂

@Joseph-Benguira excellent thanks 🙂 and can I upload a gatsby js frontend for it? If yes which option on the dashboard do I choose for that?

Hi,
Yep you can export your database to CSV and import it. There's no direct way or synchronous way to achieve it.

@Joseph-Benguira your plans around cloudgate sound phenomenal ☺️ +1

Hey Franck,
yes it's possible, when you configure your scheduling select "Every-week" in the recurrence type dropdown
you can then indicate the days of the week and hour

dc4a523b-ac9f-4b9b-a1de-1e6aad92c7ae-image.png

Hi Jean,

another option may be to try a csv to sql converter, i.e. https://www.convertcsv.com/csv-to-sql.htm

Then go to your Cloud Backend > Databases > New query

Screenshot 2021-03-17 at 22.27.18.png

The copy the sql code to create the table

Screenshot 2021-03-17 at 22.26.32.png

I've actually built my own tool to create this 'create table' sql code to quickly replicate FileMaker tables in AppDrag 🙂

I do see that when you sync it down, you have a 'config file' (api.json) with the relevant metadata.

Here's a sample:

"appId": "abcd-1234", "funcs": { "/": [ // filepath { "id": 1234, // function ID "name": "myGreatFunction", function Name "description": "", "type": "nodejs12.x", "contentType": "FILE", "method": "PUT", "ram": 128, "timeout": 15, "output": "JSON" }, //etc.

My suggestion is, maybe the fs pull can (either by default or with an arg) write the APIs in the correct folder structure, with the function names.

Then, when uploading, it can match the filenames/paths with the JSON config file in order to upload it back to the server in the right place.

This is a huge difference between something like AppDrag and Netlify or others. I love AppDrag but I'm spending a LOT of time trying to do simple things like sync my code to gitHub or work effectively locally in VS Code without copy/pasting code by hand back and forth.

@Daniel-Mulroy said in Rotating/Changing API Key:

Thanks @Wassim that helps.

Does that mean the environment vars are 'hardcoded' into the version of the script that is published?

more info here :
https://docs.aws.amazon.com/lambda/latest/dg/configuration-envvars.html

You define environment variables on the unpublished version of your function. When you publish a version, the environment variables are locked for that version along with other version-specific configuration.

Thank You Wassim.