Re: Strange...

[jbv via use-livecode]

Le 2024-08-28 13:52, Klaus major-k via use-livecode a écrit :


should suffice for a simple addressbook app. :-)



yep, but not for processing any kind of raw data...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Strange...

[jbv via use-livecode]

("936,474" is within "777,50,1424,1") -> true

("936,474" is within "777,50,1424,10") -> false

LC 9.6.9 on Mac OSX 10.15

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

How to check if a group contains a specific control ?

[jbv via use-livecode]

Hi list,

Is there a quick way to check if a group contains a specific control,
something like :
if there is a fld "xyz" in grp "abc" of this cd

I tried many things but it always generates an error.
So far, the only way I can think of is to maintain a custom prop
for each group, featuring a string that is the list of all controls
names of the group.

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Annual price

[jbv via use-livecode]

Le 2024-08-09 12:24, Bob Sneidar via use-livecode a écrit :

Jeeze can we just please stop with the criticisms??

Bob S



Apart from criticism, it could be a nice option, especially for 
hobbyists,
to be able to pay a Classic license monthly, just like LC hosting, or 
other

development software line Max MSP : https://cycling74.com/shop/max.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

[jbv via use-livecode]

Heather,

I know you suggested a zoom meeting before announcing the new pricing 
plans, but
we were unable to proceed, mainly because I was really busy with the 
server transfer
for our on-rev accounts and all the troubles it caused to my clients 
with their apps

and all the little adjustments that needed to be made.
Besides I needed to check how my clients would react to the new pricing 
plans before
making any decision, and only 2 days ago I was able to find the time to 
check how

much it really meant.
Last but not least, it is very nice of you to offer the possibility of a 
workaround,
but I guess any solution will only be a short-term one, and I need a 
solution for

the many years to come.

jbv

Le 2024-08-02 11:57, Heather Laine via use-livecode a écrit :
Or you could explain your problem to us directly, as Kevin has asked a 
couple of times already on this list and we can see what we can do.


You have an open ticket in support. You have not as yet told me that 
the new pricing is unaffordable for you.


Best Regards,

Heather

Heather Laine
Customer Services Manager
LiveCode Ltd
www.livecode.com



On 2 Aug 2024, at 16:13, jbv via use-livecode 
 wrote:


Same here.

I have been into hypertalk since the 1st version of HC.

I have 2 desktop apps for 2 different clients that I maintain, and in 
each one
the part developed with LC Classic is just a front end for sending 
requests to
the server and displaying the incoming data. In both cases 80% of the 
tasks is

done server side with LC on 2 on-rev accounts.
I know for certain that none of my clients will accept to pay for 
per-seats

license.

So I have 2 options so far :
- paying myself for these licenses, which I can't afford
- rewrite the front-end of both apps with html/js and forget about LC.

jbv




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

[jbv via use-livecode]

Le 2024-08-02 11:17, Bob Sneidar via use-livecode a écrit :

You cannot mean that you want him to go bankrupt


Of course not, but neither me or my clients want to go bankrupt.
My clients have already paid for the deployment of their apps and they
are also paying when some cosmetic changes need to be done.
They don't see why they should also pay for using the apps,
especially because they work in some niche markets where any
additional cost is difficult to handle.

Paying licenses for using Photoshop or dropbox is different,
because one didn't pay anything for the deployment of those apps.
I hope I am making myself clear despite my poor english.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: By popular demand - Extend access to LC Classic IDEs BEYOND 2027!

[jbv via use-livecode]

Same here.

I have been into hypertalk since the 1st version of HC.

I have 2 desktop apps for 2 different clients that I maintain, and in 
each one
the part developed with LC Classic is just a front end for sending 
requests to
the server and displaying the incoming data. In both cases 80% of the 
tasks is

done server side with LC on 2 on-rev accounts.
I know for certain that none of my clients will accept to pay for 
per-seats

license.

So I have 2 options so far :
- paying myself for these licenses, which I can't afford
- rewrite the front-end of both apps with html/js and forget about LC.

jbv




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode Future

[jbv via use-livecode]

I checked the cost of the licensing options and a very
disappointing thing is that if I choose "Native" for
instance, as far as I understand, I can deploy for
all platforms. But in my situation I only need MacOS
and Windows.
So I have the feeling that I will ask my clients to
pay for stuff they don't need...
Please correct me if I'm wrong.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode Future

[jbv via use-livecode]

I checked the cost of the licensing options and a very
disappointing thing is that if I choose "Native" for
instance, as da

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lockscreen and progress bar

[jbv via use-livecode]

Basically my script takes a list of images, checks the imagedata
of every image for possible white areas at the top, bottom, left
or right, crops the image if necessary, resizes the image and
groups it with fields created on the fly with text data from
an xml file.

When I simply lock the screen at the beginning of the main loop,
everything works as expected.
But when I use a group of objects on top of everything to hide
the rest, with a couple of unlock/lock screen to update a
progress bar and the content of a field in that top group, then
imagedata processing stops working. I don't get any error, but
it is as if images didn't feature any white area, when some of
them actually do.

I suspect there is a memory problem or something similar.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lockscreen and progress bar

[jbv via use-livecode]

Actually I forgot that I had a "lock screen" at the very
beginning of my script. And successive "lock screen"
cumulate. Therefore the following sequence doesn't update
the screen layout :
  lock screen
..
  lock screen
..
  unlock screen
  lock screen

Funny how I can get stalled with very basic things
sometimes...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lockscreen and progress bar

[jbv via use-livecode]

Hello Terry,

Yes I thought of that. The problem is that "lock screen" hinders
the progress bar to be updated while the loop is running.
I also tried to shortly "break" the lock screen by inserting
  unlock screen
  lock screen
within the loop, hoping that it would update the display, but
to no avail.

Thank you anyway for the idea.

Le 2024-07-26 02:54, Terry Judd via use-livecode a écrit :
How about taking a screengrab just before you run the loop, place that 
over the top of the content that changes, layer the progress thingy 
over that and then delete the screengrab and hide the thingy when the 
loop is done?


From: use-livecode  on behalf of 
jbv via use-livecode 

Date: Friday, 26 July 2024 at 4:44 PM
To: How to use LiveCode 
Cc: j...@souslelogo.com 
Subject: Lockscreen and progress bar
Hi list,

I have a main loop that does a lot of things, like resizing images,
precessing imagedata, creating fields and groups, etc.
On top of the loop I have added "lock screen" to speed things up, and
also because I don't want users to see what is going on, only the final
layout when the loop is over.
However, while the loop is running, I would like to have a progress bar
and a message such as "step 1/20" etc.

How can I handle that ? I took a look at callbacks, but unless I missed
something, it seems limited to players.

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Lockscreen and progress bar

[jbv via use-livecode]

Hi list,

I have a main loop that does a lot of things, like resizing images,
precessing imagedata, creating fields and groups, etc.
On top of the loop I have added "lock screen" to speed things up, and
also because I don't want users to see what is going on, only the final
layout when the loop is over.
However, while the loop is running, I would like to have a progress bar
and a message such as "step 1/20" etc.

How can I handle that ? I took a look at callbacks, but unless I missed
something, it seems limited to players.

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: crop image

[jbv via use-livecode]

Hi Mark,

Yes, it helped a lot.
Many thanks.
jbv

Le 2024-07-25 05:41, Mark Waddingham via use-livecode a écrit :

On 2024-07-23 14:23, jbv via use-livecode wrote:

Hi list,

I have the following script :

 create image
 put number of imgs into ni
 put id of img ni into tid
 set filename of img id tid to myFile
 put imageData of img id tid into pimage
-- many lines for imagedata analysis
 crop image id tid to rect trect

I get this error :
 crop: object is not an image


That is a slightly misleading error...

'crop' does not operate on images which are referenced - i.e. use a 
filename


To crop such an image, load the data into the image:
   set the text of img id tid to url ("binfile:" & myFile)

Hope this helps.

Warmest Regards,

Mark.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode Future

[jbv via use-livecode]

Hi list,

I am a bit lost as I am trying to figure out how I fit in the
new license plans.
I have built a couple of desktop apps years ago for 2 different
clients who use them in their business, with less than 20 users
in total. These apps make intensive use of LC server and I also
have 2 LC-hosting accounts.
I keep maintaining these apps with cosmetic changes once or twice
a year. Most of the time these modifications represent less than
1% or 2% of the code, but each time I need to recompile for
MacOS & Windows.
I use a license for MacOS and Windows which gets renewed every
year.

Therefore my question : how will I be able to continue in the
same way ?

Thanks,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: crop image

[jbv via use-livecode]

Please check mu second post on the same topic.
For the first one, I pressed "send" by mistake before
finishing to write it.
Thanks.


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

crop image

[jbv via use-livecode]

Hi list,

I have the following script :

 create image
 put number of imgs into ni
 put id of img ni into tid
 set filename of img id tid to myFile
 put imageData of img id tid into pimage
-- many lines for imagedata analysis
 crop image id tid to rect trect

I get this error :
 crop: object is not an image

However, when replacing the "crop..." line with
 select img id tid
it works, the image is visible and selected,
which means the image has been created.

It is as if "crop" doesn't work for images created in
the same script. I have tried with an image created
before running the script, and it works.

I also tried a workaround with "export snapshot" = it
works, also the snapshot features the portion of the card
behind the image, as if the image doesn't exist...

Any idea ?
I am using LC 9.6.9 on Mac 10.15.
Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

crop image

[jbv via use-livecode]

Hi list,

I have the following script :

 create image
 put number of imgs into ni
 add 1 to Nflds
 put id of img ni into tid
put imageData of img

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Problem with hierarchical menu

[jbv via use-livecode]

Hi list,

I have a pulldown menu button with a hierarchical
menu on 4 levels. Level 1 features 35 options, and
each option can have submenus on 1, 2 or 3 sub-levels.
On Mac everything works fine : users can navigate
through all options and sub-options with the mouse down
like in any menu.
But on Windows 10 & 11, at times when the cursor moves
back from level 3 to 2, or 2 to 1 for instance, the whole
menu gets stalled, and users need to release the mouse
and pulldown the menu again.

Any idea of what can cause this problem and what I should
check ?
Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Printing to pdf

[jbv via use-livecode]

Nevermind, I found the solution : I modified
the printScale property.
Best

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Printing to pdf

[jbv via use-livecode]

Hi list,

I have a stack with several cards 750 x 1000px.
I am trying to print these cards as pdf, but
according to this lesson
https://lessons.livecode.com/m/4071/l/29177-how-to-create-pdfs-using-livecode
the stack size should be 575 x 800 to fit a A4
document ratio.
Is it possible to "force" the printing to different
sizes, without clipping the content of the cards ?

I tried :
print card x into 0,0,750,1000
but the cards are still clipped.

The pdf I need to build is not for printing, only
for reading on screen.

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Copying groups

[jbv via use-livecode]

Hello,

Yes, indeed, the sharedText property of the field(s) need to be set to 
true.

Many thanks.

jbv


Le 2024-06-21 08:44, panagiotis merakos via use-livecode a écrit :

Hello jbv,

What is the sharedText property of the field(s)? I _think_ it has to be
true in your use case.

Kind regards,
Panos
--

On Fri, 21 Jun 2024 at 14:16, jbv via use-livecode <
use-livecode@lists.runrev.com> wrote:


Hi list,

I have a single card stack containing several groups,
each group containing several fields and images.
I need to copy these groups to a substack.
I use :
copy grp tname of cd 1 of this stack to cd 1 of stack myTarget

The weird thing is that all groups are copied, but the text
content of every field is missing.
What did I miss ?

Thank you in advance.
jbv



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Copying groups

[jbv via use-livecode]

Hi list,

I have a single card stack containing several groups,
each group containing several fields and images.
I need to copy these groups to a substack.
I use :
copy grp tname of cd 1 of this stack to cd 1 of stack myTarget

The weird thing is that all groups are copied, but the text
content of every field is missing.
What did I miss ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Different borders for a group

[jbv via use-livecode]

Hi list,

Is there a way to have different border widths and colors
for the top and the bottom of a group ?
Or should I include graphic lines inside the group ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Hierarchical submenus in option menu buttons

[jbv via use-livecode]

Hi list,

I am trying to create a hierarchical submenu in an option menu button
with LC 9.6.
I have found this solution that seems to work only with pulldown buttons 
:

https://use-livecode.runrev.narkive.com/cBfAjix2/cascading-menu

I also found this LC lesson that suggests to use polylists :
https://livecode.com/using-polylist-to-create-dropdown-menus/
But that seems way too sophisticated for a simple submenu.

Any idea ?
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Groups id #

[jbv via use-livecode]

Hi list,

I have a script that creates groups on the fly
with the command "group". These groups contain
various flds and imgs.
Can I always assume that the group with the highest
id # is the last one created ?
Thanks,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Saving data in standalone

[jbv via use-livecode]

Hi list,
I am working on an app for a client who will use it as a standalone.
Basically users will be able to import data such as images, text and
even html from various sources. All these data will self organize in
different groups that the user will be able to select, move around
and organise in a layout, and finally export as a pdf file.
The problem is that all this work will be done in successive sessions,
and between each step there will be the need to temporary save the
work to retrieve it in the next session.
And I'm not sure about the best way to save groups within an LC
standalone and retrieve everything in a similar layout in the
next session, or even if it's possible.
Any idea and suggestion are welcome.

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Code translation anyone ?

[jbv via use-livecode]

Le 2024-03-15 12:28, Christer Pyyhtiä via use-livecode a écrit :

Have you tried OpenAi or Gemini? Once just for fun tried asking OpenAI 
to create a structure for a problem using LiveCode, and the result was 
acceptable giving a coarse structure for the solving the problem.


Yes, I have tried ChatGPT, but my problem is that my php weights 500 Kb,
so I started to proceed chunk by chunk, and each time ChatGPT adds 
lengthy

comments and explanations from the php manual...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Code translation anyone ?

[jbv via use-livecode]

One detail I forgot in my question : code translation using
ChatGPT or any other AI.

Thanks,
jbv


Le 2024-03-15 10:36, jbv via use-livecode a écrit :

Hi list,

Has anyone tried to translate code from 1 version to
another, or from 1 language to another ?
Like from php 5 to php 8, or from php to LC ?
My question concerns mainly server scripts.

Thanks,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Code translation anyone ?

[jbv via use-livecode]

Hi list,

Has anyone tried to translate code from 1 version to
another, or from 1 language to another ?
Like from php 5 to php 8, or from php to LC ?
My question concerns mainly server scripts.

Thanks,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Best way to lock a whole mySQL table ?

[jbv via use-livecode]

Hi list,
I have a mySQL table with over a million rows and I would
like to lock the data so that no inserts nor updates are
possible, only reads via select commands.
I have read the doc as well as numerous blogs, and as far
as I understand, the following command
LOCK TABLES myTable WRITE;
locks the table and prevents other users from reading or
writing to the table.
But that's not what I need : I need to allow any user to
read at any time, but prevent anyone to write at any time.
Besides, I also need the lock to be effective in phpMyAdmin.
And of course, I need to do that for 1 table only and not
the other tables in the db.

How can I achieve that ? Does the solution have to do
with the user privileges ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Top things you are waiting for ....

[jbv via use-livecode]

Hi,

My top priority : "rev" libraries (revXML, revZIP, perhaps others) to be 
fully Unicode compatible.


I do a lot of stuff with LC server, and for the moment, my only choice
is to use php instead for some tasks.

Le 2023-11-11 17:43, Tom Glod via use-livecode a écrit :

Hey everyone
Just a market research thread.
What are the top 3 or 5 things you are waiting for in Livecode's 
feature

set?
This is my list.

1. Updated Browser
2. Compiler (its important because speed is important to the user
experience)
3. integrated layering of native controls

What are yours?

Cheers,


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revXML and UTF-8

[jbv via use-livecode]

Thank you for your reply.

I found a workaround, but not a very elegant one :
when xml parsing returns some "", I start the
parsing again, but I process the line as plain text
and not as xml.
It's about as fast.

Le 2023-09-17 09:32, Paul Dupuis via use-livecode a écrit :
There are a number of "rev" libraries (revXML, revZIP, perhaps others) 
that are not fully Unicode compatible.


See:
https://quality.livecode.com/show_bug.cgi?id=18942 (revXML, revZIP)
https://quality.livecode.com/show_bug.cgi?id=22202 (revZIP)

... and possibly others. There are no work-arounds for not being 
Unicode compatible (at least none I know of). In my opinion, bugs with 
no work-around should be among LC's higher priorities for bug fixes.



On 9/17/2023 8:32 AM, jbv via use-livecode wrote:

Hi list,

I have a text file encoded in UTF-8. Each line of the file
is an xml node with several sub-nodes and attributes.

I have a loop in LC that reads lines one by one and creates
an xml tree with revXMLCreateTree. The goal is to parse each
line and extract some data.

The problem is that, when for instance data is japanese or
chinese characters, the data always outputs as .

When opening the file I use :
open file myFile for UTF8 read

I tried to insert before each line :


and also :
put textEncode(myLine,"UTF8") into myLine

Is there a way to declare an xml tree as UTF-8 ?

Thank you in advance,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

revXML and UTF-8

[jbv via use-livecode]

Hi list,

I have a text file encoded in UTF-8. Each line of the file
is an xml node with several sub-nodes and attributes.

I have a loop in LC that reads lines one by one and creates
an xml tree with revXMLCreateTree. The goal is to parse each
line and extract some data.

The problem is that, when for instance data is japanese or
chinese characters, the data always outputs as .

When opening the file I use :
open file myFile for UTF8 read

I tried to insert before each line :


and also :
put textEncode(myLine,"UTF8") into myLine

Is there a way to declare an xml tree as UTF-8 ?

Thank you in advance,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC server, on-rev and time zones

[jbv via use-livecode]

Just tested on On-Rev and it works.
Thank you, that's very helpful.

Le 2023-09-06 09:39, matthias rebbe via use-livecode a écrit :
You could try to set the $TZ variable. I did not try on 
On-Rev/LivecodeHosting, but on a HostM Server which also has Livecode 
Server installed.


This script here for example would set the timezone first to Germany  
and outputs the current time and then for New York.



<€?€l€c€
€put "Europe/Berlin" into $TZ
€set the twelvehourtime to false
put the time
€put ""
€put "America/New_York" into $TZ
€set the twelvehourtime to true
€put the time
?>

Am 06.09.2023 um 15:22 schrieb jbv via use-livecode 
:


Hi list,

How do you handle different time zones in server scripts ?
For example, I and my clients are in Europe, so dates and
times need to be consistent with the local time zone.
But on-rev servers are located in the US East coast, so
there is presently a 6 hours difference.
Furthermore, switching from summer time to winter time
(and back) occur at different dates in Europe and North
America...
How do you guys manage to keep everything consistent
all year round ?

Thanks you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC server, on-rev and time zones

[jbv via use-livecode]

Hi list,

How do you handle different time zones in server scripts ?
For example, I and my clients are in Europe, so dates and
times need to be consistent with the local time zone.
But on-rev servers are located in the US East coast, so
there is presently a 6 hours difference.
Furthermore, switching from summer time to winter time
(and back) occur at different dates in Europe and North
America...
How do you guys manage to keep everything consistent
all year round ?

Thanks you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [semi OT] mySQL question

[jbv via use-livecode]

Hello Ken,

Thank you so much for your answer.

Your solution confirms what I had more or less in mind.
I will give it a try asap.

Best,
jbv



Le 2023-05-11 15:33, Ken Ray a écrit :

I would recommend a table for People, a table for Companies, and a
table for Employment that acts as a linking table between the first
two. Something like (at its simplest):

people

id  INT(11)
first_name VARCHAR(255)
last_name VARCHAR(255)

companies
===
id INT(11)
name VARCHAR(255)

employment

id INT(11)
person_id INT(11)
company_id INT(11)
job_descrip VARCHAR(255)

To get a list of everyone that worked at a particular company, you'd
do:

 SELECT * FROM people
 INNER JOIN employment ON (people.id [1] = employment.person_id)
 INNER JOIN companies ON (employment.company_id = companies.id [2])
 WHERE companies.name="XYZ, Inc."

To get a list of all companies where a person has worked, you'd do:

 SELECT * FROM companies
 INNER JOIN employment ON (companies.id [2] = employment.company_id)
 INNER JOIN people ON (employment.person_id = people.id [1])
 WHERE people.first_name="John" AND people.last_name="Smith"

Make sure to index the 'id' and '_id' columns, and you can use the
employment.job_descrip to hold info on the particular job an
individual had at a specific company.

This is all off the top of my head, so it may need a little massaging,
but you get the idea.

Ken Ray
Sons of Thunder Software, Inc.
Email: k...@sonsothunder.com
Website: https://www.sonsothunder.com


On May 11, 2023, at 9:55 AM, jbv via use-livecode
 wrote:

Hi list,

This is a question for mySQL experts, which I am not.

I have a table of individuals.
I have another table of companies.

Many individuals have worked in more than 1 company with
different jobs descriptions.

I need to build my DB so that, with single requests, I
can get a list of either :
- all individuals who worked in a specific company with
the job description of each one
- all companies in which a specific individual has worked,
along with the job description he had in each company.

The main problem is that the tables might become huge with
the time (several Gb), so searching the tables might take
forever if not carefully built.

I guess I will need to use a third table for the job descriptions
and a combination of fulltext indexes and foreign keys
might do the trick, but my limited skills don't allow me
to find the best solution...

Any help will be much appreciated.
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode




Links:
--
[1] http://people.id
[2] http://companies.id


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

[semi OT] mySQL question

[jbv via use-livecode]

Hi list,

This is a question for mySQL experts, which I am not.

I have a table of individuals.
I have another table of companies.

Many individuals have worked in more than 1 company with
different jobs descriptions.

I need to build my DB so that, with single requests, I
can get a list of either :
- all individuals who worked in a specific company with
the job description of each one
- all companies in which a specific individual has worked,
along with the job description he had in each company.

The main problem is that the tables might become huge with
the time (several Gb), so searching the tables might take
forever if not carefully built.

I guess I will need to use a third table for the job descriptions
and a combination of fulltext indexes and foreign keys
might do the trick, but my limited skills don't allow me
to find the best solution...

Any help will be much appreciated.
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

mySQL and primary key

[jbv via use-livecode]

Hi list,

I have a mySQL table with 1350 entries that weights
almost 20 Gb.
I need to create a primary key on the "id" column.
I have tried in phpMyAdmin as well as in a script with
"ALTER TABLE myTable ADD PRIMARY KEY(id)", but each time
I get a "504 Gateway Timeout" error, and no index is created.

What else can I try ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: revXML and UTF8

[jbv via use-livecode]

Nope, when I process the data without using the xml library, all
characters display fine. The problem is really with revXML.
There must be a trick for using revXML with UTF8 file format.


Le 2023-04-10 07:28, Paul Dupuis via use-livecode a écrit :

Look up textEncode and textDecode in the dictionary. Text from or to a
file needs to be decoded or encoded since LC 7.


On 4/10/2023 4:07 AM, jbv via use-livecode wrote:

Hi list,

I have an xml file with lots of non-western characters
(greek, arabic, japanese...). I need to convert these
data into sql requests to insert into a DB.
For each node, I need to pick only some attributes, so
I wrote a script that :
- opens the file as utf8
- processes each node
- writes a file as utf8 with the processed data.

My problem is that all non-western characters appear as
 in the final file.
Should I use unidecode for each revXMLNodeContents ?
What am I missing ?

Thank you in advance.
jbv



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

revXML and UTF8

[jbv via use-livecode]

Hi list,

I have an xml file with lots of non-western characters
(greek, arabic, japanese...). I need to convert these
data into sql requests to insert into a DB.
For each node, I need to pick only some attributes, so
I wrote a script that :
- opens the file as utf8
- processes each node
- writes a file as utf8 with the processed data.

My problem is that all non-western characters appear as
 in the final file.
Should I use unidecode for each revXMLNodeContents ?
What am I missing ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: How to split a large xml file

[jbv via use-livecode]

Thank you so much for the tip.
It took 12 hours to split 75 Gb into 1278 files of 20 lines each.
I had to add a -a5 parameter otherwise Terminal would output a "too
many files" error.
Thanks again.

Le 2023-04-01 10:19, kee nethery via use-livecode a écrit :

I had to do this once upon a time and I used some of the unix commands
in Terminal on a mac. The command is “split” and it was wicked fast.
Just be sure to work on a copy of the file. Many examples on the
interwebs. If you were going to do this day in a day out, yes, a GUI
app would be a good idea. But for an infrequent thing … use “split”.

https://kb.iu.edu/d/afar

https://www.geeksforgeeks.org/split-command-in-linux-with-examples/

I think I split mine into 5Gb files and used BBEdit to open and
examine them. Not sure what maximum size file LiveCode can parse so
you might want to adjust. But for sure BBEdit was a champ in opening
them and scrolling through them easily.

Kee Nethery



On Apr 1, 2023, at 5:17 AM, jbv via use-livecode 
 wrote:


Hi list,

I have a 75Go xml file that I need to process, and therefore
need to split it into smaller files.
I tried to do that with LC, reading successive chunks of 5
lines with an endless loop and save them in successive files,
but it crashes LC (9.6.9 on OSX 10.15) every time before
finishing.
Of course, I am interested in any working solution using LC.

On the other hand, I found EasySplitMerge that runs on Mac
and the free trial version works fine on files under 30Mb.
Does anyone have any experience with it on larger files ?
I'd be interested in any feedback before purchasing a
license.
https://www.321soft.com/easysplitmerge/

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

How to split a large xml file

[jbv via use-livecode]

Hi list,

I have a 75Go xml file that I need to process, and therefore
need to split it into smaller files.
I tried to do that with LC, reading successive chunks of 5
lines with an endless loop and save them in successive files,
but it crashes LC (9.6.9 on OSX 10.15) every time before
finishing.
Of course, I am interested in any working solution using LC.

On the other hand, I found EasySplitMerge that runs on Mac
and the free trial version works fine on files under 30Mb.
Does anyone have any experience with it on larger files ?
I'd be interested in any feedback before purchasing a
license.
https://www.321soft.com/easysplitmerge/

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Livecode / MariaDB UTF8 charset

[jbv via use-livecode]

Hi list,

I am struggling to configure the charset of a mySQL/MariaDB table
on my Livecode Hosting account.
I have a huge number of utf8 files containing names in various
alphabets (european, cyrillic, japanese, chinese, arabic...) and
I need to insert each name as a separate entry in the table.
When I run a LC script on my Mac to build a large number of
"INSERT INTO..." requests (1 for each name) and then copy/paste
these requests in phpMyAdmin, with the table charset as the default
one : utf8mb3_unicode_ci, it works : each name shows in its own 
alphabet.

But if I run the same script on the server, every character beyond
ascii 256 shows up as "?"...
I have tried other charsets, but to no avail.

My script is rather simple : a main loop that opens successively each
file (open file tfile for UTF8 read), builds the request and then runs
the sql request.

What am I doing wrong ?
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: I need to fetch some text from a WP website, but need to login first

[jbv via use-livecode]

Hello,

The WP REST API can be really slow and therefore painful to use.
I recently had to make changes in a couple of WP websites and
found it much easier to write data straight into the DB.

jbv

Le 2023-02-28 18:57, pere xavier Rossello via use-livecode a écrit :

Hi.

The easy way to do this is using REST API.

https://developer.wordpress.org/rest-api/

And using it from livecofe

https://lessons.livecode.com/m/4071/l/1325310-how-to-request-a-resource-from-a-rest-api

Pere X.





El mar, 28 feb 2023, 18:22, harrison--- via use-livecode <
use-livecode@lists.runrev.com> escribió:


Hi Matthias,

If you can’t get it done with tsNet or LiveCode,
you might want to try using Keyboard Maestro.

Rick


> On Feb 28, 2023, at 11:00 AM, matthias rebbe via use-livecode <
use-livecode@lists.runrev.com> wrote:
>
> Hi,
>
> i need to login into a WP website to fetch some specific data. Currently
this is done manually in a browser, but i would like to automate it 
using

tsNET external or pure Livecode script.
>
> Did anyone already do this with Livecode?
>
> Regards,
> Matthias
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode Hosting

[jbv via use-livecode]

Was moving to HostM really necessary ?
A couple of years ago, Livecode Hosting provided a certificat saying 
that their

service was fully compliant with european GDPR...
And AFAIR, GDPR doesn't require that data must be hosted within 
Europe...

Unless I missed something...

jbv

Le 2023-02-28 08:00, matthias rebbe via use-livecode a écrit :

I have both 1 Livecode Hosting account and 3 HostM accounts

I am still very satisfied with Livecode Hosting,
When Runrev started the On-Rev platform the servers  were hosted in
France, but that changed some time and now the servers are hosted in
the US.
But comply with GDPR of the EU i had to find another provider that
hosts his servers in the EU.
So i moved the business websites with a heavy heart to HostM.
You can even install your commercial LivecodeServer or let HostM do
this for you.
The response time for support requests are very fast.

So in case you have to deal with the european GDPR you have to use a
provider that hosts in the EU.


Am 28.02.2023 um 12:44 schrieb jbv via use-livecode 
:


Hello,
I just had a look at their offer, and it really looks interesting,
especially the possibility to choose the location of your server
(Europe, usa...).
But what about their technical support ? On-rev tech support quality
is hard to beat...

Thanks.
jbv


Le 2023-02-28 05:33, Georges Malamoud via use-livecode a écrit :

Hello
I have been using this service for a certain time, and it works well
for us, Livecode developers (and server admin)
https://www.hostm.com <https://www.hostm.com/>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode Hosting

[jbv via use-livecode]

Hello,
I just had a look at their offer, and it really looks interesting,
especially the possibility to choose the location of your server
(Europe, usa...).
But what about their technical support ? On-rev tech support quality
is hard to beat...

Thanks.
jbv


Le 2023-02-28 05:33, Georges Malamoud via use-livecode a écrit :

Hello
I have been using this service for a certain time, and it works well
for us, Livecode developers (and server admin)
https://www.hostm.com 

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Training the AI to write better LiveCode

[jbv via use-livecode]

https://www.vice.com/en/article/bvm3k5/github-users-file-a-class-action-lawsuit-against-microsoft-for-training-an-ai-tool-with-their-code

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Training the AI to write better LiveCode

[jbv via use-livecode]

https://www.vice.com/en/article/wxn3kw/openai-used-kenyan-workers-making-dollar2-an-hour-to-filter-traumatic-content-from-chatgpt

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: .mov files in a standalone on Windows

[jbv via use-livecode]

Thank you for the answer but this looks a bit too complicated.
Furthermore, the standalone will run only a couple of times on
Windows, and furthermore on a machine on which I can't install
anything.
So I'll take another route and convert the .mov to a format
that is compatible with windows.
Which format is the best : mp4, avi, or... ?

Thank you.
jbv


Le 2023-01-08 15:46, Paul Dupuis via use-livecode a écrit :

Without installing 3rd party codec for DirectShow in Windows, you
can't play .mov media.

LA Filters is free and works very well with DirectShow (the media
player on Windows LC 9.6.8 uses). See
https://github.com/Nevcairiel/LAVFilters/


On 1/8/2023 1:53 PM, jbv via use-livecode wrote:

Hi list,

I am using LC 9.6.8 on Mac.
I have a couple of .mov files that I want to include in a stack
that will end up as a standalone running on windows.
I haven't done that in years.
What is the best way to proceed, to be sure that each video and
its sound track will play fine on windows ?
BTW are video files embedded in the stack, or are they supposed
to be in an external folder ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

.mov files in a standalone on Windows

[jbv via use-livecode]

Hi list,

I am using LC 9.6.8 on Mac.
I have a couple of .mov files that I want to include in a stack
that will end up as a standalone running on windows.
I haven't done that in years.
What is the best way to proceed, to be sure that each video and
its sound track will play fine on windows ?
BTW are video files embedded in the stack, or are they supposed
to be in an external folder ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Just curious...

[jbv via use-livecode]

Hi list,

I'm having a look at the Activity Monitor on my iMac 27"
running MacOS 10.15.7.
I have LC 9.6.8 IDE open with a rather simple stack waiting
for a button to be clicked.
When I check the "Energy" tag of the Activity Monitor, and
more specifically the "Energy Impact", it shows a variation
between 3.7 and 5.0 for LC, and only 0.8 to 2 for Google
Chrome with at least 15 opened windows.
Is there an explanation for the difference, which is not
what I was expecting...

Thanks in advance.
Best,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lock screen and animated gif

[jbv via use-livecode]

Thanks for the offer, but actually things are a bit more complicated
and include several steps :
1- the user selects different options on a modal stack
2- the user clicks a "search" button
3- various calculations are made client side according to the selections
and some data already in the main stack behind the modal one
4- a request is sent to a distant mySQL to retrieve text in a DB
5- data is sent back to the client (by chunks of 500 lines) and is
dispatched in different fields in the main stack
6- 1 field that contains the main text data has textstyle & textcolor
modified line by line and often several words can be modified in the
same line.

The whole process is quite fast, especially when using "lock screen"
for steps 3 and 6, but depending on the user"s selection and the
content of the DB, it can take 3 to 8 seconds at times.
And what I was looking for was a spinning gif throughout the whole
process from step 1 to step 6.
Unfortunately it stops spinning during steps 3 and 6 when using
"lock screen", which isn't very elegant.

Finally I replaced the gif with a progress bar which updates every
25 lines during step 6 (when more than 100 lines are returned) and
it's ok, since it allows me to use "lock screen".

Le 2022-12-20 12:31, Richard Gaskin via use-livecode a écrit :

How many chars in the text?

I'd wager that unless it's uncommonly enormous, you may find that the
one-time cost of writing a handler to use the styledText array of the
field will speed things up so much you may not even need anything more
than a brief watch cursor.

If you can post a sample project with text of similar length we may
have another good opportunity like the many forum threads we've seen
where long processes become brief blips with iterations from the
community.

--
 Richard Gaskin
 Fourth World Systems


jbv wrote:


Le 2022-12-20 08:19, Brian Milby via use-livecode a écrit :

Could you make changes to htmlText in a variable and then assign all
at once back to the field?



I thought of that, but it makes other parts of the script more 
complicated.
Finally I will chose a different strategy : instead of an animated 
gif, I'm

gonna use a progress bar that will be updated every 10 lines...



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lock screen and animated gif

[jbv via use-livecode]

Le 2022-12-20 08:19, Brian Milby via use-livecode a écrit :

Could you make changes to htmlText in a variable and then assign all
at once back to the field?



I thought of that, but it makes other parts of the script more 
complicated.
Finally I will chose a different strategy : instead of an animated gif, 
I'm
gonna use a progress bar that will be updated every 10 lines as follows 
:

  unlock screen
  set currentvalue of scrollbar "progress" to x
  lock screen
It shouldn't slow down the script too much...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Lock screen and animated gif

[jbv via use-livecode]

Do you mean "lock screen without messages" ?
Doesn't work...

Le 2022-12-20 07:27, Richmond Mathewson via use-livecode a écrit :

Try 'without messages'.

On Tue, 20 Dec 2022, 13:26 jbv via use-livecode, <
use-livecode@lists.runrev.com> wrote:


Hi list,
I have a script that modifies line by line the color
and textstyle of some words in a field that can be up
to 500 lines long.
I am using "lock screen" to speed up things.
But at the same time I have a spinning animated gif
to tell end users to wait until the modification is
done.
The problem is that "lock screen" freezes everything
and the gif stops spinning.
Is there a workaround for using "lock screen" and an
animated gif simultaneously ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Lock screen and animated gif

[jbv via use-livecode]

Hi list,
I have a script that modifies line by line the color
and textstyle of some words in a field that can be up
to 500 lines long.
I am using "lock screen" to speed up things.
But at the same time I have a spinning animated gif
to tell end users to wait until the modification is
done.
The problem is that "lock screen" freezes everything
and the gif stops spinning.
Is there a workaround for using "lock screen" and an
animated gif simultaneously ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: itemoffset & wholematches

[jbv via use-livecode]

Again guys, thank you for your suggestions.

But finally I gave up using itemoffset and worked
with arrays instead, which is much much faster :
my script processes the 6 variables in less
than 15 secs.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: itemoffset & wholematches

[jbv via use-livecode]

Hi guys,
Thank you all for your answers.

Actually I thought that some "hierarchy"remained (items inside lines)
when using itemoffset, but obviously I was wrong.
I have about 6 variables to check, so I need my script to be as
fast as possible. I use "replace CR with TAB & CR & TAB in ...", but
as I need to get the exact itemoffset digit, I also need to count
how many items I have added and substract that number from the
result, which is quite cumbersome and slow...

To Jacqueline :
Thanks fro the suggestion, but I have to stick with items and
itemoffset, for some items can contain more that 1 word, like
"pied de biche"...

Le 2022-11-14 14:45, Alex Tweedly via use-livecode a écrit :

That would deal with the last item in a line - but not the first.

Should do

   replace CR with TAB & CR & TAB in ...

and reverse later if needed.

Alex.

On 14/11/2022 18:43, Bob Sneidar via use-livecode wrote:
oic. Odd use case. I suppose a lineOffset function followed by is 
among the items could be used. If he needs the lines to remain intact 
he could also replace cr with tab & cr first.





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

itemoffset & wholematches

[jbv via use-livecode]

Hi list,

I have a variable with a content of 3 lines as follows :
1   sombre  brunprofond
2   flouincertain
3   inexploré   mystérieux  inconnu

The separator between words is tab.
I want to check if a certain word is among the items as a whole.

The following script returns "6" :
   set itemdel to tab
   set the wholematches to false
   put itemoffset("incertain",myVar)

The following script returns "0" :
   set itemdel to tab
   set the wholematches to true
   put itemoffset("incertain",myVar)

The following script returns "7" :
   set itemdel to tab
   set the wholematches to true
   replace return with tab in myVar
   put itemoffset("incertain",myVar)

Scripts 1 & 3 are logical, but any logical explanation
for the result of script 2 ? Does it mean that the return
char after the word is considered as part of the word ?

Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Processing WAV file sample data

[jbv via use-livecode]

Hi,

I have been working on something similar : a stack that reads
samples from wav mono files and displays waveforms in a graphic
control.
It works on Mac & Windows, but I haven't used it for a year,
and AFAIR the code isn't too clean...


Le 2022-10-18 07:10, Peter Reid via use-livecode a écrit :

Hi

I'm developing a project that will manipulate WAV files.

The source files will be in the following form: -
	WAV stereo (2-ch), 48kHz, 16bit 16kbit, 2-15 secs duration, 
uncompressed


The output will be a series of chunks from the source files, each being
WAV mono (1,2,3,4 channels), 16kHz, as long as desired, uncompressed

Does anyone know of any LiveCode extensions that let you extract the
sample data from existing WAV files and build new WAV files by
combining existing  WAV files?

So I'm looking for something like:

WAV2bin - exports from original WAV to binary sample data

WAVproc - processes 1 or more binary sample data files

bin2WAV - converts sample data files to WAV

Note the chopping up of the WAV files should run under Linux (if
possible), but Mac otherwise. Any further data manipulations must work
under Linux , but Mac would be OK as a fallback.

Thanks

Peter
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: PHP -> curl -> LC

[jbv via use-livecode]

Hi Stephen,

Thank you for your answer.
Yes, I would be interested in some example using .htaccess,
although my file is already full of rewriting rules and I'm
afraid that it would add some conflicts...

Best


Le 2022-10-16 17:32, Stephen Barncard via use-livecode a écrit :

Hi jbv,

I think this can be done using the. [dot]htaccess file at the root of 
the

website.

I’ll try to dig up an example.


On Sun, Oct 16, 2022 at 11:22 jbv via use-livecode <
use-livecode@lists.runrev.com> wrote:


Hi list,

In several of my web projects, I have a main php script that
triggers various LC scripts for specific tasks that are often
easier to code in xTalk.
To trigger those LC scripts I use curl and urls in the form :
https://domain.com/irev/script.lc?a=parameters

But very often, the php and LC scripts are on the same server
and on the same account, such as on-rev.
Therefore I've always wondered if there was another way to
trigger the LC scripts from PHP, like for example not using
http, but "inside" the server, by addressing the LC script
via "home/public_html/account/irev/script.lc" ...
Of course, the idea is to be able to use parameters as well,
and to return processed data.
The main idea is :
- to make the whole thing faster than via http
- to keep things within the server and therefore more secure.

Sorry if this sounds like a newbie question.
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

PHP -> curl -> LC

[jbv via use-livecode]

Hi list,

In several of my web projects, I have a main php script that
triggers various LC scripts for specific tasks that are often
easier to code in xTalk.
To trigger those LC scripts I use curl and urls in the form :
https://domain.com/irev/script.lc?a=parameters

But very often, the php and LC scripts are on the same server
and on the same account, such as on-rev.
Therefore I've always wondered if there was another way to
trigger the LC scripts from PHP, like for example not using
http, but "inside" the server, by addressing the LC script
via "home/public_html/account/irev/script.lc" ...
Of course, the idea is to be able to use parameters as well,
and to return processed data.
The main idea is :
- to make the whole thing faster than via http
- to keep things within the server and therefore more secure.

Sorry if this sounds like a newbie question.
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC -> Applescript -> Chrome

[jbv via use-livecode]

If anyone's interested, I think I have found the
cause of my problem with Applescript in LC, and more
specifically with the "click at" command.
For months I've been using MouseTools as Terminal/shell
application to emulate keyboard and/or mouse events.
AFAIK MouseTools is pretty old and hasn't been updated
in ages, and a recent Mac OSX update might have made
its behavior erratic.
Therefore I have switched to cliclick (https://www.bluem.net/),
whose last update is from 2021 and that is much more easier to use,
and things have improved (as far as I can see).

Best

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC -> Applescript -> Chrome

[jbv via use-livecode]

Hi Richard,

Thank you for your reply.
Actually it's kind of weird : after running the script a few
times in the Applescript editor, it started to work again in
LC...
May be it was something in my setup, I don't know.

Best,

Le 2022-10-11 15:27, Richard Gaskin via use-livecode a écrit :

jbv wrote:

I have a stack that interacts with Chrome via Applescript.
It has been running fine for months.
Suddenly, one command line began to stall the whole process,
with the spinning wheel spinning forever.

And when I run the same Applescript in the script editor,
it still runs fine as before.
The line is :
tell application "System Events" to click at {x, y}
I am using LC 9.6.8

What should I look at to fix the issue ?


At first this struck me as potentially an intentional change from
Apple for security purposes, but a quick DuckDuckGo search shows many
having the same AppleScript issue with "click at":
https://duckduckgo.com/?q=macOS+applescript+%22click+at%22

Interesting discussions, but I didn't see a proposed solution that
works for Mavericks.  I also didn't look that hard; there may be a fix
out there. Or it may be a bug in macOS.  But at least it isn't you. :)


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC -> Applescript -> Chrome

[jbv via use-livecode]

Hi list,

I have a stack that interacts with Chrome via Applescript.
It has been running fine for months.
Suddenly, one command line began to stall the whole process,
with the spinning wheel spinning forever.

And when I run the same Applescript in the script editor,
it still runs fine as before.
The line is :
tell application "System Events" to click at {x, y}
I am using LC 9.6.8

What should I look at to fix the issue ?
Thank you in advance.
jb

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Ignoring accented characters

[jbv via use-livecode]

Hello Ben,

Thank you for your detailed answer.

So far, I only have to deal with french text so I only need
a list of diacritic vowels and a list of the chars used as
replacement :
àâäéèêëîïôöùûüÿ
aaaiioouuuy
With a simple loop it is feasible and it doesn't slow down
my scripts significantly.
But indeed, a 'diacriticSensitive' property would be really
helpful.

jbv



Le 2022-09-27 06:22, Ben Rubinstein a écrit :

Hi jbv,

This one of a number of gaps that exist in the jungle of character
processing in LiveCode.

I don't think there is a 'diacriticSensitive' property. Some part of
LiveCode are clever about accents, see e.g.
https://quality.livecode.com/show_bug.cgi?id=15312
https://quality.livecode.com/show_bug.cgi?id=15443

As you note, it would be useful if there was a built-in function to
strip diacritics, which has been requested (for 14 years now):
https://quality.livecode.com/show_bug.cgi?id=6450

One trick that can be used in some contexts is to put the text into a
field, retrieve the htmlText of the fields - which encodes many
accented characters as entity names - and reduce these entity names
back to the unaccented character.

There's also an enhancement request (pending for over 18 years) to
expose this functionality without the need to use a field - useful for
many purposes, not just for stripping accents:
https://quality.livecode.com/show_bug.cgi?id=1372

This especially ought to be a cheap enhancement, since LC evidently
incorporates the necessary tables already.

Putting text through html entities is not a perfect solution to
implementing a "stripDiacritics" function, because e.g. you might
render "—" as "m"; but as far as I know, currently it's either
that or encode your own tables.

Ben


On 16/09/2022 15:10, jbv via use-livecode wrote:

Hi list,

Is there a way to ignore accented characters in LC, like in mySQL
for instance ?
Here's an example : I need these 2 array items below to be considered
as 1 single entity :
   add 1 to myArray["interprétation"]
   add 1 to myArray["interpretation"]

Of course, I can write a function that removes accents, but I was
wondering if there was a built-in function in LC to do that, in a
similar logic as "set the casesentive to false" for instance.

Thanks you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Ignoring accented characters

[jbv via use-livecode]

Hi list,

Is there a way to ignore accented characters in LC, like in mySQL
for instance ?
Here's an example : I need these 2 array items below to be considered
as 1 single entity :
  add 1 to myArray["interprétation"]
  add 1 to myArray["interpretation"]

Of course, I can write a function that removes accents, but I was
wondering if there was a built-in function in LC to do that, in a
similar logic as "set the casesentive to false" for instance.

Thanks you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [semi-OT] PDF on the fly

[jbv via use-livecode]

I am using Safari 15.6 (15613.3.9.1.7, 15613)

But I finally found the origin of the problem :
  put header "Content-Length: " & number of chars of myPDF

After removing that line from the header, files download and
display fine in Safari, as in other browsers.
So far I have no rational explanation though.

Best,
jbv

Le 2022-09-14 17:00, matthias rebbe via use-livecode a écrit :

I just tested on quartz.on-rev.com <http://quartz.on-rev.com/> with LC
Server 9.6.0.

I've created a textfile with a size of 1mb.

tested with this script and it worked. I even tested with put header
instead of put new header.
put new header "Content-Disposition: attachment; FileName=" & 
"justsomeText.txt"

put URL("binfile:" & "justsomeText.txt")
?>

Which version of Safari do you have?



Am 14.09.2022 um 22:44 schrieb jbv via use-livecode 
:


Hi guys,

Thank you for your answers.
No matter what I try, the problem remains the same on Safari.
My LC script runs on my on-rev account, and it uses LC 9.6.
Could this really be the problem ?

Best,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [semi-OT] PDF on the fly

[jbv via use-livecode]

Hi guys,

Thank you for your answers.
No matter what I try, the problem remains the same on Safari.
My LC script runs on my on-rev account, and it uses LC 9.6.
Could this really be the problem ?

Best,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

[semi-OT] PDF on the fly

[jbv via use-livecode]

Hi list,

I have a web site on which end users can select several options,
and then click a button "show PDF", and a pdf containing various
contents from a remote DB with a sophisticated layout is built
server side in a second and automatically downloaded.

The link of the button is something like :
  https://domain.com/showPDF.lc?a=parameters
and the script sets the header of the pdf file as follows :
  put header "Content-Type: application/pdf"
  put header "Content-Length: " & number of chars of myPDF
  put header "Content-Disposition: attachment; filename=" "e& 
myFileName "e


This has been working fine for years, and still works on Chrome
and FF, but apparently the latest versions of Safari don't accept it:
the file is built and the download starts but quickly stalls and that's 
it.

And no error message van be found in the console.

As an alternative solution, I've been thinking of building the pdf 
server side
and writing it in a temporary folder, and then on the web page 
displaying a
prompt with a button containing the actual url of the file. But that's 
not

very elegant IMHO.

What other options do I have ?
Thank you in advance.

Best,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Is syntax a dead issue?

[jbv via use-livecode]

Just curious : why do you use "read from file F for 1 line" ?
Instead, why don't you read the file in one go, load the content
into a variable and then use "for each line j in myVar" ?
Wouldn't that run faster ?

Best,
jbv


Le 2022-07-25 02:42, Geoff Canyon via use-livecode a écrit :

As a meta point, I wrote a version closer to the actual requirements --
lowercase everything, process an external input line by line to allow 
for

arbitrary input size. The result is about 8-10x slower than most other
languages -- not as bad as I feared, not as good as I hoped. Here's the
code for that version:

on mouseUp
   answer file "choose input:"
   if it is empty then exit mouseUp
   put it into F
   lock screen
   put the long seconds into T
   open file F for read
   repeat
  read from file F for 1 line
  repeat for each word w in toLower(it)
 add 1 to R[w]
  end repeat
  if the result is not empty then exit repeat
   end repeat
   combine R using cr and tab
   sort R numeric descending by word 2 of each
   put the long seconds - T into T1
   put R into fld "output"
   put the long seconds - T into T2
   put T1 && T2
   close file F
end mouseUp

On Sun, Jul 24, 2022 at 11:01 PM Geoff Canyon  
wrote:


On this Hacker News thread 
,

I read this programming interview question
. Roughly, the challenge is 
to

count the frequency of words in input, and return a list with counts,
sorted from most to least frequent. So input like this:

The foo the foo the
defenestration the

would produce output like this:

the 4
foo 2
defenestration 1

Of course I smiled because LC is literally built for this problem. I 
took

well under two minutes to write this function:

function wordCount X
   repeat for each word w in X
  add 1 to R[w]
   end repeat
   combine R using cr and tab
   sort R numeric descending by word 2 of each
   return R
end wordCount

There are quibbles -- the examples given in the article work line by 
line,
so input size isn't an issue, and of course quotes would cause an 
issue,
and LC is case insensitive, so it works, but the output would look 
like

this:

The 4
foo 2
defenestration 1

But generally, it works, and is super-easy to code. But for the sake 
of

argument, consider this Python solution given:

counts = collections.Counter()
for line in sys.stdin:
words = line.lower().split()
counts.update(words)

for word, count in counts.most_common():
print(word, count)

That requires a library, but it's also super-easy to code and 
understand,
and it requires just the same number of lines. So, daydreaming 
extensions

to LC syntax, this comes to mind:

function wordCount X
   add 1 to R[w]  for each word w in X
   return R combined using cr and tab and sorted numeric descending by
word 2 of each
end wordCount

or if you prefer:

function wordCount X
   for each word w in X add 1 to R[w]
   return (R combined using cr and tab) sorted numeric descending by 
word

2 of each
end wordCount

Or to really apply ourselves:

function wordCount X
   return the count of each word in X using cr and tab sorted numeric
descending by word 2 of each
end wordCount

So: the xTalk syntax is over thirty years old; when was the last
significant syntax update?

(I'm not at all core to the process, so feel free to tell me how much 
I've

missed lately!)



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

deleting folders on server with revDeleteFolder

[jbv via use-livecode]

Hi list,

On my LC Hosting account, I have a php script that creates directories :
   mkdir($dirname, 0755);
Each directory is used to temporarily store text & image files.

Then I have a LC script that is supposed to delete those directories
under certain conditions. No problem for deleting files inside each
directory, but 2 sub-directories are systematically created, named
"." and ".." and those can't be deleted, either by script of via ftp.
Therefore, there's no way to delete the directories created via php.

Last but not least, the doc for LC 9.6.8 says that "revDeleteFolder"
is the command to use to remove a folder and all its contents and that
it is available on both desktop and server platforms, but on my LC
hosting account I get : Handler: can't find handler (revDeleteFolder)

Any idea how to solve this problem ?
Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC 9.6.8 and UTF-8 on MacOS 10.15

[jbv via use-livecode]

Hi list,

I have a serie of text files in UTF-8 format for which I need to do some 
processing in LC,

and then save to a single text file also in UTF-8.
I am using the following code :

  open file tpath for UTF8 read
  read from file tpath until EOF
  close file tpath1
  --put it into tfile
  put textdecode(it,"UTF-8") into tfile

--processing

  open file tpath2 for UTF8 write
  write liste_credits to file tpath2
  close file tpath2

If I use "put it into tfile" instead of "put textDecode...", the text 
content is full of typical

gibberish (such as "√¶" instead of "æ").
I thought the latest LC versions could process UTF-8 natively. So why is 
"textdecode" necessary

to obtain special characters in their true form ?
Thank you in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Best way to update a large DB ?

[jbv via use-livecode]

Hi list,

I have a mySQL DB with about 40 entries, and I need to update
19 of them in the following way :
update myDB set col1 = "blah blah", col2 = "blah blah" where id = 12345 
limit 1


I have a file with all the requests that weights almost 200 Mb.
I can't upload it via phpMyadmin, because it's too big and running all 
the requests

in one go will end up with a server timeout.

I was thinking of a cron job that would trigger every minute or so, and 
run a short
script that would read successive portions of 100 requests and feed them 
so mySQL.


Any better idea ?
Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC 9.6.7 and Applescript

[jbv via use-livecode]

Hello Panos,

I just installed LC 9.6.8 and everything works perfect.
Thank you for your reply.
I guess I should check https://quality.livecode.com more often :)

Best,
jbv


Le 2022-06-09 04:17, panagiotis m via use-livecode a écrit :

Hello jbv,

This sounds like bug 
https://quality.livecode.com/show_bug.cgi?id=23576,

which is fixed in LiveCode 9.6.8 rc1.

Cheers,
Panos
--


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC 9.6.7 and Applescript

[jbv via use-livecode]

Hi list,

I am trying to use an old stack made with LC 8.1 community that used to 
work fine on Mac OSX 10.11.

Now I am with LC 9.6.7 on OSX 10.15.
The stack features some AppleScript commands such as :
 tell application "Google Chrome" to set URL of active tab of window 1 
to "https://www.domain.com";


But now I get an execution error in LC 9.6.7, while those commands run 
fine in the script editor

utility.
I am not really familiar with the relationship between LC and 
AppleScript.

Where should I look to fix this issue ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Maximum length of mySQL request ?

[jbv via use-livecode]

Le 2022-05-20 11:24, Bob Sneidar via use-livecode a écrit :

I googled around a bit and there doesn't seem to be a limit on
statement length. I will say though that the nature of the query
indicates a possible design issue with the database. I suspect however
that you are at the mercy of someone else's schema. That there is no
common denominator you can query on is to me remarkable. How are you
obtaining your IDs then?



Thank you for your reply.
I also did some google search before asking the question, but didn't
find anything, only about the size of the data returned by mySQL.

What makes you think of a possible design issue ?
The ids are auto-incremented every time a new entry is added to the
table, and the ids in the request are obtained by intersecting various
multi-dimensional arrays that make very complex searches very fast
(less than 1 sec, when it takes 5 to 10 sec with regular SQL queries).

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Maximum length of mySQL request ?

[jbv via use-livecode]

Le 2022-05-20 08:00, Paul Dupuis via use-livecode a écrit :

You can save some characters by the following:

SELECT ... FROM myTable WHERE id IN (5523,7831,162814,34895,...)

which is the same as using multiple OR equals in your example.



Thank you. Yes I will try that.
And I have no idea why it didn't cross my mind... Perhaps because it's 
friday... :)


jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Maximum length of mySQL request ?

[jbv via use-livecode]

Hi list,

Is there a maximum length limit for mySQL requests ?
I don't mean the results returned by mySQL, but the request itself.

For instance, I have a table with 18 entries and counting, and
I will need to send requests such as :
SELECT FROM myTable WHERE id = 5523 OR id = 7831 OR id = 162814 OR id = 
34895...

and at times the request might concern 100 ids or even more.

I am not too concerned about execution speed, as id is a unique key,
but rather for the request itself : I wonder if it might be truncated
if too long...
Or perhaps a better and safer practice would be to break it into a serie 
of

shorter successive requests when it exceeds a certain threshold ?

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Nested loops

[jbv via use-livecode]

Hi list,

What is the best and most efficient way to write the following
javascript loops in LC ?

for (let i = 0, j = myArray.length - 1; i < myArray.length; j = i++) {
}

This goes beyond simple nested loops.
So far, because of lack of time, I have pre-calculated the successive
values of i and j, and have put them into lists of words :
0 1 2 3 4 5
5 0 1 2 3 4
it remains fast enough for what I need to do, but there must be a more 
elegant approach...


Thanks.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC subscription and special characters

[jbv via use-livecode]

Thank you all for your answers.
I am going to contact tech support to see if there is any solution to be 
expected in the near future.


FYI, so far we are using a workaround :
https://www.azerty.global/

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: LC subscription and special characters

[jbv via use-livecode]

Thank you for your reply.
Obviously, it was possible in earlier versions of LC.

So, could someone be kind enough to make a quick test with the most 
recent versions of LC, by typing text inside a field, if special 
characters can be used, like alt+144 for É, and possibly on azerty and 
qwerty keyboards ?

Thank you in advance.

Le 2022-05-10 17:53, Paul Dupuis via use-livecode a écrit :

I thought I recalled a bug in the LC engine where using the keyboard
method of typing the character code, press ALT, and then press X. For
example, to type a dollar symbol ($), type 0024, press ALT, and then
press X, didn't work in Livecode. However, I just tried searching the
Livecode Quality Center for a bug number and couldn't find it so
perhaps I am mis-remembering.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

LC subscription and special characters

[jbv via use-livecode]

Hi list,
I have been asked by a client to make some upgrades to a standalone app 
that I built with LC 6.5 about 12 years ago.
The app is a front end for managing a remote DB on a server. The DB 
content is roughly 90% in french, and the rest in english and german. It 
has about 16 entries and counting.


I am about to buy a LC standard plan for both Mac and Win, since the app 
is been used on both platforms, and will also be in the future.
But before I proceed, I'd like to make sure that it will help solving a 
minor problem that users have met lately.


Last year a re-compiled the app, without changing anything, with a LC 
8.2 Community version.
It keeps running fine on both Win & Mac, except that on Windows, some 
special characters in french (like Ê or Æ or Œ) have become impossible 
to type with regular keys combinations (or any other mean), when it was 
possible before with the LC 6.5 version.
Furthermore, a few new users will be added to the crew, who will work 
with qwerty keyboards, when the rest of the staff will continue to work 
with azerty keyboards.


So finally my question : it seems that the standard plan is the best 
option because it will give me access to the latest LC versions, but 
what about these special characters issue ? Is it only related to LC 
8.2, or will it also occur with the latest versions ?


Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode and interactive video

[jbv via use-livecode]

Le 2022-01-21 14:56, Jim Lambert via use-livecode a écrit :

A quarter of a century ago, we called this Interactive Multimedia.
It was usually delivered on a CD-ROM.   Ask your parents! ;)



he he he... I actually made quite a few myself 30 years ago...
I"m currently browsing through various existing tools that allow
to produce interactive videos, but my main goal is to automate
the process of generating them...
Most of these tools aren't cheap. A promising one seems to be
Adobe Captivate which, unless I'm wrong, offers possibilities
to hack the main file format.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode and interactive video

[jbv via use-livecode]

Hi Rick,

Thank you for your answer. That was actually my very first option,
but it remains the most simple one.
I am now exploring a new option : generate an HTML5 animation and
then convert it to a video format. I'm just wondering if hotspots
(mostly to offer viewers options for branching to different segments
of the video) will be kept after the conversion...


Le 2022-01-20 15:45, Rick Harrison via use-livecode a écrit :

You could probably do it on your own website with LiveCode server.

It would not work with YouTube though.

You might however be able to publish an optional link to
your interactive video on YouTube just below a video
you have posted.

You could say something like:  To try the interactive
version of this video, please click on the link below.

Good Luck!

Rick

On Jan 20, 2022, at 6:49 AM, jbv via use-livecode 
 wrote:


Hi list,
This might be a dumb question but anyway...
Imagine a simple quiz made of a succession of static slides, each 
slide featuring a question and 4 possible answers.
When the user clicks 1 answer, he gets notified if he's right or 
wrong, then a comment about the right answer is displayed, and then 
the user clicks to move to the next question.
At the end, a final screen shows the score and some additional 
comments.


This is easily done with LC. But is there a way to export such an app 
from LC into a format compatible with an interactive video for youtube 
for instance ?


Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your 
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Livecode and interactive video

[jbv via use-livecode]

Le 2022-01-20 13:39, Tom Glod via use-livecode a écrit :
Hi there . can you give an example of an interactive video on 
youtube?

so I can see what you mean? I've never seen one.



Please check this video : it explains the basics of interactive videos,
although I don't know if it's accepted on youtive :
https://www.youtube.com/watch?v=QkGI4OHSjA0

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Livecode and interactive video

[jbv via use-livecode]

Hi list,
This might be a dumb question but anyway...
Imagine a simple quiz made of a succession of static slides, each slide 
featuring a question and 4 possible answers.
When the user clicks 1 answer, he gets notified if he's right or wrong, 
then a comment about the right answer is displayed, and then the user 
clicks to move to the next question.

At the end, a final screen shows the score and some additional comments.

This is easily done with LC. But is there a way to export such an app 
from LC into a format compatible with an interactive video for youtube 
for instance ?


Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: How to detect when the user moves a stack

[jbv via use-livecode]

Hi Klaus,

Yes it works, thank you for the tip.
Oddly I forgot about the "movestack" message, probably because it 
doesn't appear in the list of available messages when I open the stack 
script in LC 8...


jbv

Le 2021-12-15 05:17, Klaus major-k via use-livecode a écrit :

Hi jbv,

Am 15.12.2021 um 11:02 schrieb jbv via use-livecode 
:


Hi list,
How can I detect when the user moves a stack around the screen by 
clicking on the top bar while leaving the mouse down ?
Here's my problem : I have a main stack calling a modal stack that 
displays information in real time while some client / server dialog is 
running. When the modal stack opens, it is located at the loc of the 
main stack. But if the user moves the main stack, the modal stack 
stays at the same place, and I would like it to move accordingly and 
remain at the loc of the main stack, no matter where the user moves 
the main stack.
At least this is happening in the IDE, I haven't built a standalone 
yet.


usually you could check the "movestack" message, but I'm not sure if
the MODAL stack
will not block any actions? Can't you use a "system window" instaed if
that is the problem?


Thanks in advance.
jbv


Best

Klaus

--
Klaus Major
https://www.major-k.de
https://www.major-k.de/bass
kl...@major-k.de


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

How to detect when the user moves a stack

[jbv via use-livecode]

Hi list,
How can I detect when the user moves a stack around the screen by 
clicking on the top bar while leaving the mouse down ?
Here's my problem : I have a main stack calling a modal stack that 
displays information in real time while some client / server dialog is 
running. When the modal stack opens, it is located at the loc of the 
main stack. But if the user moves the main stack, the modal stack stays 
at the same place, and I would like it to move accordingly and remain at 
the loc of the main stack, no matter where the user moves the main 
stack.

At least this is happening in the IDE, I haven't built a standalone yet.

Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Server directory of a running script

[jbv via use-livecode]

Le 2021-11-12 15:10, Phil Davis via use-livecode a écrit :

Also, maybe try "the filename of me". It seems like that should work,
though I could be wrong.



No, you're right, it works too.
Thank you.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Server directory of a running script

[jbv via use-livecode]

Great ! Thank you.

Le 2021-11-12 05:20, Ralf Bitter via use-livecode a écrit :

You might try $_SERVER["PATH_TRANSLATED"]


Ralf



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Server directory of a running script

[jbv via use-livecode]

Hi list,
Is there a way to get the full path of the server directory/subdirectory 
in which an LC script is running, from within the script itself while it 
is running ?

I have a Livecode Hosting account and I need to get something like :
"/home/myAccount/public_html/myDirectory/mySubDirectory/"

Thank you in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

decompressing gzip data server side

[jbv via use-livecode]

Hi list,

I need to post data from an LC standalone to a remote server.

For years, using LC as cgi engine, I have compressed and encoded
the data in base 64 like this :
  put base64encode(compress(myData)) into myVar

and then I run the opposite command server side :
  put decompress(base64decode(myData)) into myVar

Now I need to post from an LC app to a php script.
According to the LC dict, "compress" uses gzip, so I tried the 2
following php commands :
  $data = $_POST['a'];
  $a = gzdecode(base64_decode($data));
  $a = gzuncompress(base64_decode($data));

But in both cases it returns an empty string. The problem is with
the decompressing step, for the base64 encoded data is received by
the server and decoded without error.

Could someone be kind enough to tell me what I am missing ?

Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Resizing images

[jbv via use-livecode]

Hi list,
I need to resize hundreds of jpg and png images.
Most images have different initial width and height,
and the resizing needs to be done according to data
in an xml file, therefore most resizing are quite
unique.
I was wondering : what is the best way to do it ?
1- with a LC script using export snapshot
2- or in php using a library such as Image magik ?

The main point is not how to do it, for I can code
both options, but rather : which option will ensure
the best image quality after resizing ?

Thanks in advance.
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

launch url and then close

[jbv via use-livecode]

Hi list,
On desktop, when a browser window is opened outside
of LC using the "launch url" command, is there a way
to close the browser window after a while from the
LC script ?
I am not talking about the revbrowser, but the actual
default browser.
I guess the answer is "no", as I haven't found anything
in the doc nor in the forum, but I'm asking anyway.

And second question : when a URL is used in a revbrowser,
the default browser is used by LC, but does it use the
same http header as when the same url is entered in the
address bar of the actual browser ?

Thanks in advance

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

revBrowserNavigate

[jbv via use-livecode]

Hi list,
I am using revBrowserNavigate and have the following problem :
sometimes some urls won't display, but they display fine when
I enter them in the address bar of the browser.
What am I missing and what should I check ?
I am using LC Community 8.1.10.

Thanks in advance. Best,
jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

A question for LC and Windows 10 experts

[jbv via use-livecode]

Hi list,
I have a request from a client to sync an accounting software
running on a PC under Windows 10 and a database on a remote
server.
Below is a short description of the solution I have imagined,
and I would welcome opinions & critics from other list members,
as I'm not really familiar with Win 10.

- I will build a small standalone app with LC, that will launch
at start up along with Win 10 and will keep running in the
background. Let's name it "myApp".

- some programmable tasks in the accounting software will create
xml files in a local directory when some actions are performed,
for instance : entering a new customer or a new order.

- every 5 min or so, myApp will check the directory for possible
new files, and will send their content to the remote server as
parameters of a POST request.
If no file is found, the POST request will be sent to the server
anyway.

- on the server, a script will be triggered and will enter the
parameters of the request (the xml data) into the DB, and will
return data relative to possible events that happened on the server,
if any, in the form of xml.

- myApp will write the returned xml data as a file in a directory
on the PC, and another programmable task in the software will read
the file and import the data.

My main concern is the app running constantly in the background.
Is it safe ? Is it Win 10 compatible ? Is there anything I miss ?
Thanks in advance.

jbv

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: numberformat question

[jbv via use-livecode]

Thank you.
I will take a close look at it.

Meanwhile I have finetuned my LC script : it returns the same
results as the js script, and according to my tests, solves
1000 cubic equations in roughly 0.8 second.


Le 2021-03-23 07:14, Andreas Bergendal via use-livecode a écrit :

A few years back I needed calculation to a precision of 300 decimals.
I found a js solution by -hh in the forum, which solved my need:
https://forums.livecode.com/viewtopic.php?f=93&t=29018&start=30


It runs in a browser widget, with easy input from and output to LC
script. I don’t know the precision limit, but it’s way more than 300
IIRC.

Maybe useful here?

/Andreas
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: numberformat question

[jbv via use-livecode]

Le 2021-03-22 12:14, John Balgenorth via use-livecode a écrit :

You might be able to get the info by running your javascript
from a shell command.  Here is a link that might be of help;

https://stackoverflow.com/questions/12659778/is-it-possible-to-run-javascript-files-from-the-command-line



Thank you, but if I run javascript, I would prefer to use a
browser objet and revBrowserCallScript...
BTW, as I haven't used browser controls in a long time, am I
forced to use a distant url, or can I point to some html + js
stored in my stack as a field or even a variable ?

Thanks in advance.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: numberformat question

[jbv via use-livecode]

Le 2021-03-22 12:03, jbv via use-livecode a écrit :

Hi Craig,

Thank you for the link, but it doesn't help much :

bigDivide(-0.007347880794884118999,10)
returns 0 , -0.01




Ooops, I just realized that I forgot to add
set numberformat to "0.##"
at the beginning of bigDivide...

now bigDivide(-0.007347880794884118999,10)
0 , -0.00734788079488411899919975

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode