Hello,

I have a lot of records to import. Curious what the recommended file size limit is, if any, for importing CSV files via the LiveCloud Manager? I don't want to bite off more than it can chew at one time.

Separate but related issue, I am currently importing data using a LiveCode script but seem to run into problems if I try too many records at once; maybe I need to make my script more efficient. Thanks in advance.

Sieg

Hi team, when exporting a table using CSV format and there is a field that includes a comma it is not handled as it should. In other words in such cases the exporting routine has to surround the field contents with quotes in order to be seen as just one field otherwise it will be exported as two fields.

Hope I made myself clear...

Best

Hello,

I'm new to LiveCloud and not a programmer or app builder by trade. My aim is to tweak an existing app with dozens of scripts and fields and thousands of lines of code to use LiveCloud instead of its current MySQL database. In other words, I'd really rather not build a new app from the ground up. This app has performed like a champ for years; just need to move away from MySQL.

I have the current app (IDE, not a standalone) in the directory with the Canela toolkit and the initialization script added to the stack script. The existing app has a splash stack with a button that opens a substack that is functionally the main stack for the app. When I click the button on the splash stack to open the substack, I get this message. "The CanelaDB SDK is missing. Please export your Canela SDK again."

Nothing I've tried works. Suggestions? Tips?

One question occurs to me: Should the initialization script be in the main (splash) stack or the substack or both? I've tried all three options with no luck. Help!

Thanks in advance,

Sieg

Hi friends, I understand you hosted a special conference workshop at the LiveCode California conference, showing everything about the use of LiveCloud.  Are you considering making it available?  
 

How about putting a link for the LiveCloud Forum on the LCM?

I want to register my Subscription for LiveCloud that was part of my Conference 2019 Streaming package.
What do I need to do?

If I have a key that I am using as a linking key that contains multiple recordID's, how do I use this list of comma or "return" delimited data in an update API?
I have seen several code snippets that use different code versions to use these values.
an example: I may have a key  that has :
1f24ac4b-2181-4f7c-8796-d5715d22ff9c
64795139-3f41-4fd0-8505-96ea1f9ebd4a
edaea51d-5def-46c9-b226-bcfe529763e0
2a6b8442-8583-4fdc-a64b-fdadd00fe63b
or 
1f24ac4b-2181-4f7c-8796-d5715d22ff9c, 64795139-3f41-4fd0-8505-96ea1f9ebd4a,edaea51d-5def-46c9-b226-bcfe529763e0,2a6b8442-8583-4fdc-a64b-fdadd00fe63b
( two different list of recordID's)
Which scripting technique would I use?
I remember a scripting code that used a "replace comms with if" to delimit the records.
It seems as though there are several sample code snippets that are suggested depending on how you select them from the LCM window.
I am sorry if this sounds confusing!
BTW, I post questions for the benefit of other users too!

Is there a way to add a new Key in the Blob Table.

This could facilitate the identification of the image or pdf object saved in this file. At the moment the only info is the ID and the type of object.

My project will hold a number of image and pdf objects , for the moment the only solution I have is to create a separate table to  manage and identifty in a fast way the objects I save in the Blob table.

Is this the only solution ?

I need to add a new key to an existing table.

1 - I tried to use the Add Key button in the Manager. I am able to add the name of the key but cannot find the way to save this new key so I could enter data into it after. Is there a button or a procedure I can use ?

2 - I tried adding a key with the code I found in you documentation using this code:
command cdb_addKeys pTable, pKeys

on mouseUp pButtonNumber

local tTable, tKeys

put "Subject" into tTable

put "Why" into tKeys

cdb_addKeys tTable,tKeys
end mouseUp

 I get the following message in the message Windows:
(2019-06-10 20:50:24.543): Error: Failed API Key Authentication

So I checked for A way to log as Developper or Administrator, but I found code that uses "user" but does not tell me with what to replace "user" whit to identify myself as Administrator.
 

on preOpenStack

    initializeCanelaDB

    get cdb_auth(pEmail,pPassword,"user")
end preOpenStack

So What is the way to identify myself as Administrator so I can pass a command to add a new Key ?

Hello!

I'm getting error messages that seem strange. I started getting them in a stack I've been working on, but then I tried one of your sample stacks and got the same errors, so this bug report is for your sample stack "Contacts".

So, I created the project "Contacts" by using your sample project creator function in LCM. Out of the box, with no modifications at all, this is what I get in msg box when I open the stack: