Is the LCM Broken?
I having problems with my LCM.

I am getting a problem when I get data from LCM.
I keep getting an error and the editor is opening in debug mode with the Stack "CDB_Starter.lib" I was randomly having this happen for the past week and just closing the editor fixed things, but not anymore. It is constantly opening the editor debug mode.
The message box is not showing any errors!
I'll be examining my scripts but I really don't know what to look for.

I will need some help to find what I messed up!

addendum:
I just got a belated message box error list:
(2019-08-20 06:10:20.896): The server response could not be downloaded at this time.
(2019-08-20 06:10:50.946): The server response could not be downloaded at this time.
(2019-08-20 06:11:21.010): The server response could not be downloaded at this time.
(2019-08-20 06:11:21.010): Error: There was a problem getting a response from the server for cdb_listCloud request.

this was after trying to examine my script in the stack.

Hello. I am very new to and still much in the dark about arrays. I am looking for efficient code to unpack the output from a query to lines of tab-delimited data (one record per line). Here is the code I've come up with so far. I'd guess there MUST be a more efficient approach.

on mouseup
## query constructed above
 put cdb_batchQuery(tInputA,"cloud","logicalAND","recordData") into tOutputA
 put flattenArray( tOutputA) into flattened -- see flattenArray function below
end mouseup

function flattenArray A , d1, d2, T,  X
   if T is empty then
      if d1 is empty then put cr into d1
      if d2 is empty then put tab into d2
   end if
   if A is not an array then return T  & X & A & d1
   repeat for each key K in A
      put flattenArray( A[K],  d1, d2, T,  X & K & d2 )  into T
   end repeat
end flattenArray

This yields the queried records in this format (just one record of many shown here).

[CDB Table ID]    1    [CDB Record ID]    ATTRIBUTES    fopn
[CDB Table ID]    1    [CDB Record ID]    LAST_NAME    Jordan
[CDB Table ID]    1    [CDB Record ID]    STATUS    linnm
[CDB Table ID]    1    [CDB Record ID]    RANK    2
[CDB Table ID]    1    [CDB Record ID]    CITY    San Francisco
[CDB Table ID]    1    [CDB Record ID]    YEAR    2019
[CDB Table ID]    1    [CDB Record ID]    ROLE    5
[CDB Table ID]    1    [CDB Record ID]    NAME    Sam Jordan
[CDB Table ID]    1    [CDB Record ID]    DATE    2019-02-17
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbDateModified    1562677087
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbDateCreated    1562677087
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbRecordID    [CDB Record ID]
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbTableID    [CDB Table ID]
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbRecordVersion    1
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbTableName    stats
[CDB Table ID]    1    [CDB Record ID]    cdb    cdbCloudSyncVersion    1

I then loop through the lines and remove the first two columns, then I filter out the lines with "cdb" keys not needed in my app as long as I preserve the record ID, and get a list of records like this…

[CDB Record ID]    ATTRIBUTES    fopn
[CDB Record ID]    LAST_NAME    Jordan
[CDB Record ID]    STATUS    linnm
[CDB Record ID]    RANK    2
[CDB Record ID]    CITY    San Francisco
[CDB Record ID]    YEAR    2019
[CDB Record ID]    ROLE    5
[CDB Record ID]    NAME    Sam Jordan
[CDB Record ID]    DATE    2019-02-17

Finally, I loop through the lines again and put the data for each record into the tab-delimited format I need, which is something roughly like this…

fopn    Jordan    linnm    2    San Francisco    2019    Sam Jordan    2019-02-17    [CDB Record ID]
ucpn    Smith    linnm    1    Los Angeles    2019    Susan Smith    2019-06-23    [CDB Record ID]

efrain.c and mark_talluto's suggestions for batch record creation and updates were VERY helpful. Thank you.

Does anybody have a simpler solution for this problem? Pretty sure there must be one (many). Thanks in advance.

Hello,

I have LiveCloud Manager with Windows 10.
When I press code snipet button, cannot close the window and come back to data.

Attached Files

Thumbnail(s)
   

Hi Everyone,

 I'm new to all this and based in South Africa. 

Unfortunately I picked San Francisco as the location when I set up the livecloud account. Its really really slow and frustrating so I would like to change the location to LON1 (London UK) If there any way to do this without creating a totally new account? I just need a feature to transfer my account to the closer location...

According to most people in the DigitalOcean LON1 is the best option for us here in SA.

I wonder what the lag times would be for fellas in Austrailia?

Sid

Hi LiveCloud team, I'm afraid there is a LiveCode error on the Example 1 (see picture) as the "into" part of the following statement is missing

put cdb_advancedQuery(tDataA,tAdvancedMap,tTable,tTarget,tResultFormat)


   

Best.

Hi, I have the following doubt for which I would appreciate a clarification.

According to the documentation:

"...any time your users lose their internet connection, CanelaDB will cache this transaction. The transactions are saved even if the application shuts down, so you never have to worry about missing your cloud calls."

I don't get when the cached transactions will be written to the cloud. In other words will this happen the next time the user launches the application or...?

Many thanks in advance

We just did a quick update to the site to reveal the 'Mist Plan'. It has been available in LiveCloud Manager for some time now but wanted people to know it exists when they visit the site. This plan is designed to be useful for testing the service. Learn how the APIs work and get comfortable with LiveCloud Manager. Enjoy!

-Mark

Thanks, Canela Software for this Thread. I hope that the users of LCM and the forum will find this a useful thread.
I will be posting things that I find and hope to get clarification of the LCM API's.

Is it possible to create a Unique number for ie: for invoicing: