Re: Confirm sort container order...

[Dick Kriesel via use-livecode]

> On Mar 30, 2022, at 2:16 PM, Paul Dupuis via use-livecode 
>  wrote:
> 
> sort lines of tText by word 1 of each & word 2 of each & word 3 of each

Hi, Paul.

The only feature missing is padding the first two words:

   sort tText by pad( word 1 of each ) & pad( word 2 of each ) & word 3 of each


function pad tString
   put "" into item 1000 of tString
   replace comma with space in tString
   return char 1 to 1000 of tString


Does that work for you?

— Dick
___
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: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Curry Kenworthy via use-livecode]

Me:
> I would like to know if some people still need LC 6.7.

BTW, I will support LC 6.7 in most addons for 2022-2023!

A few users still need it. Plus I like to benchmark with it
and perform some debugging there.

(After mid-2023, I'll gradually start moving past 6.7.)

Rick:
> Ah, the old days of LC 6.7 when LiveCode was fast.
> How much I miss that!

Yes! But LC 9 is getting there with optimization lately.
Once a version of LC 9/10 beats LC 6.7 on most tasks,
that will become my new benchmark to beat.

Matthias:
> I've updated old and created new apps with different
> versions of LC6 w/o any big problems.

Same here, for me LC 6.7 was more stable than 5, 7, or 8.
All of which I also used for projects. 9 is pretty good.

Best wishes,

Curry Kenworthy

WordLib: Import MS Word and OpenOffice files in LiveCode!
"Dominate documents with WordLib and LC"
http://livecodeaddons.com/wordlib.html

Radically Innovative Christian LiveCode Development
"Passion for Elegant and Efficient Code"
http://livecodeconsulting.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

Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Bob Sneidar via use-livecode]

Okay no answer to my question so here is why I ask. SQL databases typically 
have a limit on how many columns you can have, and how many total bytes a 
record will take. If it is possible to import each CSV file as a separate 
table, that would be ideal. If not you need to make yourself aware of those 
limits, and if you are going to exceed them, then SQL is not the way to go. 

CSV format is OK if the text fields are enclosed in quotes, and the numeric 
fields can be enclosed in quotes or not, it doesn't matter. If text fields ARE 
enclosed in quotes, then Excel should be able to open it natively, even if 
there are commas in the field text, that is not as delimiters. Id the fields 
are NOT enclosed in quotes, and the field text DOES contain commas, you are 
essentially screwed. 

Bob S


> On Apr 4, 2022, at 10:37 , Bob Sneidar via use-livecode 
>  wrote:
> 
> Does all the data need to be in a single table? 
> 
> Sent from my iPhone
> 
>> On Apr 4, 2022, at 10:31, Mike Kerner via use-livecode 
>>  wrote:
>> 
>> keith,
>> are all the files structured the same way? are they all gathered in the
>> same place?
>> LC's big strength, IMHO, is text handling, so you're right in its
>> wheelhouse.
>> for the simplest example, let's assume that all the files have all the same
>> column layout and they're all in the same folder.
>> in that case, you would
>> * grab the list of files in the folder
>> * exclude files that shouldn't be included - maybe filter everything
>> that doesn't have a .csv suffix. you could do this during the loop, below,
>> or ahead of time.
>> * iterate through the files by reading each one, and appending the contents
>> to a variable/container (if you do this, don't forget to make sure that
>> when you append each file, the last line ends with a line delimiter)
>> * create a new file
>> * save the variable/container to the file
>> 
>> slightly more complicated: the layouts aren't the same
>> you can either:
>> * rearrange the columns upon reading the file or
>> * use something like an sqlite db and create a record for each row,
>> assigning the column in each record based on the column name in the csv
>> file,  or
>> * use a LC array, using the column names in the file as the keys of the
>> array.
>> * create a new file
>> * output the result of whichever of the three solutions you chose to the
>> new file.
>> 
>> both the easy and less-easy scenarios should take, i'm guessing, somewhere
>> between twenty and fifty lines of code, and are easy to implement. if you
>> have a couple hundred files, i think that the LC solution would be much
>> faster and easier to write, test, and run than the drag-and-drop solution.
>> 
>>> On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
>>> use-livecode@lists.runrev.com> wrote:
>>> 
>>> Hi folks,
>>> I need to consolidate a couple of hundred CSV files of varying sizes
>>> (dozens to hundreds of rows) and column structures (some shared columns but
>>> many unique), into a single superset dataset that comprises all data from
>>> all files.
>>> 
>>> There are too many files and columns to attempt a manual process, so in
>>> I’ve been trying to achieve this with LiveCode - by iterating through the
>>> files to parse the column header rows into into row template and column
>>> mapping arrays used to build the combined table. However, I'm struggling to
>>> both compile the superset and render the results.
>>> 
>>> I feel I may be designing a very complicated solution for a problem that
>>> has probably been solved before. I wonder if I’m missing a simpler method -
>>> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
>>> self-organising database GUI for SQLite, etc?
>>> 
>>> Thanks in advance for any ideas.
>>> Best,
>>> Keith
>>> ___
>>> 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
>>> 
>> 
>> 
>> -- 
>> On the first day, God created the heavens and the Earth
>> On the second day, God created the oceans.
>> On the third day, God put the animals on hold for a few hours,
>>  and did a little diving.
>> And God said, "This is good."
>> ___
>> 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 sub

Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Ben Rubinstein via use-livecode]

Hi Keith,

I feel your pain. I spend a lot of time doing this kind of manipulation.

I generally avoid CSV, the format of the devil. If necessary I have a library 
that does a reasonable job of converting CSV to TSV, and run everything 
through that. Let's just assume for now that you've already done this


My technique is this:

- given that you've got a routine to iterate over a folder or tree of files
- given that you can easily treat a row at a time, and on each row can easily 
work through a column at a time (e.g., this is TSV, you've set the 
itemdelimiter to tab)

- given that the first row in each file gives the column names

1. Maintain an ordered list of output column names

I'd probably keep it in two formats: a string with tab separated column names, 
 an array mapping column name to index, and a variable giving the number of 
columns.


2. For each file, go through the list of column names (the 'items' of the 
first row). For each one, if it's not already in the master list of column 
names (e.g., it's not in the array) then append it with a tab to the end of 
the string, and add it to the array with the appropriate index.


Also keep an array mapping column index in _this_ file to column index in the 
master file.


3. Then for each row after that, start with an empty array. For each non-empty 
item on the row, add it to this 'row array', with the key being the index in 
the master file corresponding to this item's index in this file.


4. When you've got to the end of the row, dump the data from this array; index 
from 1 to number-of-master-columns, adding a tab between each. Then add this 
to the master file accumulator.



So code would look something like this


local tMasterColumns -- tab delimited column names for output 'master' file
local aColumnNameToMasterIndex -- array mapping column name to index in above 
 local iNumMasterColumns -- number of items in the above two


local tMasterFileData -- will accumulate the rows of data for the output file

local aFileIndexToMasterIndex -- for each file, maps index of column in file 
to index in master file

local aRowData -- for each row, we first move data into this array...
local tOutRow -- ...then output it into this string

local iFileNumCols -- number of columns in the current input file

local iFileColInx, iMasterColInx -- keep track of input and output col indices


repeat for each file... load it into tFileData.. etc

  -- map the columns of this file to the (growing) columns of the masterfile
  put 0 into iFileColInx
  repeat for each item x in line 1 of tFileData
add 1 to iFileColInx
get aColumnNameToMasterIndex[x]
if it = empty then
   put tab & x after tMasterColumns
   add 1 to iNumMasterColumns
   put iNumMasterColumns into aColumnNameToMasterIndex[x]
   get iNumMasterColumns
end if
-- now it is the index of this column in the master file
put it into aFileIndexToMasterIndex[iFileColInx]
  end repeat
  delete line 1 of tFileData
  put iFileColInx into iFileNumCols

  repeat for each line tRowData in tFileData

-- get data from the row into the proper columns
put empty into aRowData
repeat with i = 1 to iFileNumCols -- number of columns in this file
  put aFileIndexToMasterIndex[i] into iMasterColInx
  put item i of tRowData into aRowData[iMasterColInx]
end repeat

-- now dump the row
put empty into tOutRow
repeat with i = 1 to iNumMasterColumns
  put aRowData[i] & tab after tOutRow
end repeat
put (char 1 to -2 of tOutRow) \ -- delete last tab
  & return after tMasterFileData

  end repeat

end repeat -- for each file

-- finally save tMasterColumns & return & tMasterFileData










On 04/04/2022 18:03, Keith Clarke via use-livecode wrote:

Hi folks,
I need to consolidate a couple of hundred CSV files of varying sizes (dozens to 
hundreds of rows) and column structures (some shared columns but many unique), 
into a single superset dataset that comprises all data from all files.

There are too many files and columns to attempt a manual process, so in I’ve 
been trying to achieve this with LiveCode - by iterating through the files to 
parse the column header rows into into row template and column mapping arrays 
used to build the combined table. However, I'm struggling to both compile the 
superset and render the results.

I feel I may be designing a very complicated solution for a problem that has 
probably been solved before. I wonder if I’m missing a simpler method - with 
LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of 
self-organising database GUI for SQLite, etc?

Thanks in advance for any ideas.
Best,
Keith
___
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-live

Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Craig Newman via use-livecode]

Hi.

I rarely deal with the csv monster, but every time I have had to it all boiled 
down to the fact that a comma is a terrible character to use as a delimiter of 
ANY kind.

Ideally it would be possible to simply replace every comma with a tab. The 
returns remain untouched. If that works, you are very lucky. Have you tried it?

Craig

> On Apr 4, 2022, at 1:37 PM, Bob Sneidar via use-livecode 
>  wrote:
> 
> Does all the data need to be in a single table? 
> 
> Sent from my iPhone
> 
>> On Apr 4, 2022, at 10:31, Mike Kerner via use-livecode 
>> mailto:use-livecode@lists.runrev.com>> wrote:
>> 
>> keith,
>> are all the files structured the same way? are they all gathered in the
>> same place?
>> LC's big strength, IMHO, is text handling, so you're right in its
>> wheelhouse.
>> for the simplest example, let's assume that all the files have all the same
>> column layout and they're all in the same folder.
>> in that case, you would
>> * grab the list of files in the folder
>> * exclude files that shouldn't be included - maybe filter everything
>> that doesn't have a .csv suffix. you could do this during the loop, below,
>> or ahead of time.
>> * iterate through the files by reading each one, and appending the contents
>> to a variable/container (if you do this, don't forget to make sure that
>> when you append each file, the last line ends with a line delimiter)
>> * create a new file
>> * save the variable/container to the file
>> 
>> slightly more complicated: the layouts aren't the same
>> you can either:
>> * rearrange the columns upon reading the file or
>> * use something like an sqlite db and create a record for each row,
>> assigning the column in each record based on the column name in the csv
>> file,  or
>> * use a LC array, using the column names in the file as the keys of the
>> array.
>> * create a new file
>> * output the result of whichever of the three solutions you chose to the
>> new file.
>> 
>> both the easy and less-easy scenarios should take, i'm guessing, somewhere
>> between twenty and fifty lines of code, and are easy to implement. if you
>> have a couple hundred files, i think that the LC solution would be much
>> faster and easier to write, test, and run than the drag-and-drop solution.
>> 
>>> On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
>>> use-livecode@lists.runrev.com > wrote:
>>> 
>>> Hi folks,
>>> I need to consolidate a couple of hundred CSV files of varying sizes
>>> (dozens to hundreds of rows) and column structures (some shared columns but
>>> many unique), into a single superset dataset that comprises all data from
>>> all files.
>>> 
>>> There are too many files and columns to attempt a manual process, so in
>>> I’ve been trying to achieve this with LiveCode - by iterating through the
>>> files to parse the column header rows into into row template and column
>>> mapping arrays used to build the combined table. However, I'm struggling to
>>> both compile the superset and render the results.
>>> 
>>> I feel I may be designing a very complicated solution for a problem that
>>> has probably been solved before. I wonder if I’m missing a simpler method -
>>> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
>>> self-organising database GUI for SQLite, etc?
>>> 
>>> Thanks in advance for any ideas.
>>> Best,
>>> Keith
>>> ___
>>> 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
>>> 
>> 
>> 
>> -- 
>> On the first day, God created the heavens and the Earth
>> On the second day, God created the oceans.
>> On the third day, God put the animals on hold for a few hours,
>>  and did a little diving.
>> And God said, "This is good."
>> ___
>> 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: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Bob Sneidar via use-livecode]

Does all the data need to be in a single table? 

Sent from my iPhone

> On Apr 4, 2022, at 10:31, Mike Kerner via use-livecode 
>  wrote:
> 
> keith,
> are all the files structured the same way? are they all gathered in the
> same place?
> LC's big strength, IMHO, is text handling, so you're right in its
> wheelhouse.
> for the simplest example, let's assume that all the files have all the same
> column layout and they're all in the same folder.
> in that case, you would
> * grab the list of files in the folder
> * exclude files that shouldn't be included - maybe filter everything
> that doesn't have a .csv suffix. you could do this during the loop, below,
> or ahead of time.
> * iterate through the files by reading each one, and appending the contents
> to a variable/container (if you do this, don't forget to make sure that
> when you append each file, the last line ends with a line delimiter)
> * create a new file
> * save the variable/container to the file
> 
> slightly more complicated: the layouts aren't the same
> you can either:
> * rearrange the columns upon reading the file or
> * use something like an sqlite db and create a record for each row,
> assigning the column in each record based on the column name in the csv
> file,  or
> * use a LC array, using the column names in the file as the keys of the
> array.
> * create a new file
> * output the result of whichever of the three solutions you chose to the
> new file.
> 
> both the easy and less-easy scenarios should take, i'm guessing, somewhere
> between twenty and fifty lines of code, and are easy to implement. if you
> have a couple hundred files, i think that the LC solution would be much
> faster and easier to write, test, and run than the drag-and-drop solution.
> 
>> On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
>> use-livecode@lists.runrev.com> wrote:
>> 
>> Hi folks,
>> I need to consolidate a couple of hundred CSV files of varying sizes
>> (dozens to hundreds of rows) and column structures (some shared columns but
>> many unique), into a single superset dataset that comprises all data from
>> all files.
>> 
>> There are too many files and columns to attempt a manual process, so in
>> I’ve been trying to achieve this with LiveCode - by iterating through the
>> files to parse the column header rows into into row template and column
>> mapping arrays used to build the combined table. However, I'm struggling to
>> both compile the superset and render the results.
>> 
>> I feel I may be designing a very complicated solution for a problem that
>> has probably been solved before. I wonder if I’m missing a simpler method -
>> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
>> self-organising database GUI for SQLite, etc?
>> 
>> Thanks in advance for any ideas.
>> Best,
>> Keith
>> ___
>> 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
>> 
> 
> 
> -- 
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>   and did a little diving.
> And God said, "This is good."
> ___
> 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: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Mike Kerner via use-livecode]

keith,
are all the files structured the same way? are they all gathered in the
same place?
LC's big strength, IMHO, is text handling, so you're right in its
wheelhouse.
for the simplest example, let's assume that all the files have all the same
column layout and they're all in the same folder.
in that case, you would
* grab the list of files in the folder
* exclude files that shouldn't be included - maybe filter everything
that doesn't have a .csv suffix. you could do this during the loop, below,
or ahead of time.
* iterate through the files by reading each one, and appending the contents
to a variable/container (if you do this, don't forget to make sure that
when you append each file, the last line ends with a line delimiter)
* create a new file
* save the variable/container to the file

slightly more complicated: the layouts aren't the same
you can either:
* rearrange the columns upon reading the file or
* use something like an sqlite db and create a record for each row,
assigning the column in each record based on the column name in the csv
file,  or
* use a LC array, using the column names in the file as the keys of the
array.
* create a new file
* output the result of whichever of the three solutions you chose to the
new file.

both the easy and less-easy scenarios should take, i'm guessing, somewhere
between twenty and fifty lines of code, and are easy to implement. if you
have a couple hundred files, i think that the LC solution would be much
faster and easier to write, test, and run than the drag-and-drop solution.

On Mon, Apr 4, 2022 at 1:04 PM Keith Clarke via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi folks,
> I need to consolidate a couple of hundred CSV files of varying sizes
> (dozens to hundreds of rows) and column structures (some shared columns but
> many unique), into a single superset dataset that comprises all data from
> all files.
>
> There are too many files and columns to attempt a manual process, so in
> I’ve been trying to achieve this with LiveCode - by iterating through the
> files to parse the column header rows into into row template and column
> mapping arrays used to build the combined table. However, I'm struggling to
> both compile the superset and render the results.
>
> I feel I may be designing a very complicated solution for a problem that
> has probably been solved before. I wonder if I’m missing a simpler method -
> with LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of
> self-organising database GUI for SQLite, etc?
>
> Thanks in advance for any ideas.
> Best,
> Keith
> ___
> 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
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
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

Tools & techniques for one-off consolidation of multiple 'similar' CSV files?

[Keith Clarke via use-livecode]

Hi folks,
I need to consolidate a couple of hundred CSV files of varying sizes (dozens to 
hundreds of rows) and column structures (some shared columns but many unique), 
into a single superset dataset that comprises all data from all files.

There are too many files and columns to attempt a manual process, so in I’ve 
been trying to achieve this with LiveCode - by iterating through the files to 
parse the column header rows into into row template and column mapping arrays 
used to build the combined table. However, I'm struggling to both compile the 
superset and render the results. 

I feel I may be designing a very complicated solution for a problem that has 
probably been solved before. I wonder if I’m missing a simpler method - with 
LiveCode or perhaps with Excel or ‘drag & drop’ into some kind of 
self-organising database GUI for SQLite, etc? 

Thanks in advance for any ideas.
Best,
Keith
___
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: Can't get jsonToArray in standalones ?

[panagiotis m via use-livecode]

Hello Matthias,

Hmm, this sounds like a bug. Thanks for spotting it and filing the report :)

Kind regards,
Panos

On Mon, 4 Apr 2022, 17:15 matthias rebbe via use-livecode, <
use-livecode@lists.runrev.com> wrote:

> Panos,
>
> is there a reason why mergJSON is not listed in the dictionary anymore in
> LC 9.6.6,9.6.7, 10DDP2, 10DP3?
>
> Matthias
>
> > Am 04.04.2022 um 16:08 schrieb panagiotis m via use-livecode <
> use-livecode@lists.runrev.com>:
> >
> > Hello Ben,
> >
> > You need to check megJSON.
> >
> > The JSON Library inclusion is for JSONImport and JSONExport handlers.
> >
> > Cheers,
> > Panos
> >
> > On Mon, 4 Apr 2022, 16:28 Ben Rubinstein via use-livecode, <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Building a standalone that uses jsonToArray.
> >>
> >> Works fine in the IDE.
> >>
> >> If I use "search for required inclusions" when building the standaline,
> >> then
> >> when the script calls jsonToArray it throws error 219 (Function: error
> in
> >> function handler).
> >>
> >> If I use "select inclusions", and check "JSON Library", then it crashes.
> >>
> >> Interestingly, if I *uncheck* "JSON Library" from the inclusions, then
> it
> >> also
> >> crashes! (I expected it would throw error 219.)
> >>
> >> This is the same on LC 9.6.6 and 9.6.7; and (at least the crash) same on
> >> both
> >> Mac and Windows.
> >>
> >> My best guess is that I need to have something else checked in the
> >> inclusions
> >> - any suggestions?
> >>
> >> TIA,
> >>
> >> Ben
> >>
> >> ___
> >> 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

launch file with app

[Klaus major-k via use-livecode]

Hi friends,

macOS 12.3, LC 9.6.7

I have e.g. a MP3 file and want to open it with "Quicktime Player.app":
...
## tPrompt contains a localized string, of course
answer file tPrompt with specialfolderpath("apps") with type "|app|"
put it into tApp
## I select QTPLayer.app
if the result = "cancel" then
exit to top
end if
## tDatei holds the complete path to the MP3
## tApp the path to QTPlayer.app
launch tDatei with tApp
put the result
...

It will open the MP3 with QTPlayer as desired BUT
it also opens the file with "iTunes/Music" additionally!?
And I don't want that! :-D

The result is EMPTY.

Bug or feature?
And can I avoid to also open the file with "Music"?

Thanks in advance!


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

Re: launch tFile with tApp

[Klaus major-k via use-livecode]

> Am 04.04.2022 um 17:45 schrieb Klaus major-k :
> 
> Hi friends,
> 
> macOS 10.3, LC 9.6.7

sorry, I mean macOS 12.3
> 
> I have e.g. a MP3 file and want to open it with "Quicktime Player.app":
> ...
> ## tPrompt contains a localized string, of course
> answer file tPrompt with specialfolderpath("apps") with type "|app|"
> put it into tApp
> ## I select QTPLayer.app
> if the result = "cancel" then
> exit to top
> end if
> ## tDatei holds the complete path to the MP3
> ## tApp the path to QTPlayer.app
> launch tDatei with tApp
> put the result
> ...
> 
> It will open the MP3 with QTPlayer as desired BUT
> it also opens the file with "iTunes/Music" additionally!?
> And I don't want that! :-D
> 
> The result is EMPTY.
> 
> Bug or feature?
> And can I avoid to also open the file with "Music"?
> 
> Thanks in advance!
> 
> 
> 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

launch tFile with tApp

[Klaus major-k via use-livecode]

Hi friends,

macOS 10.3, LC 9.6.7

I have e.g. a MP3 file and want to open it with "Quicktime Player.app":
...
## tPrompt contains a localized string, of course
answer file tPrompt with specialfolderpath("apps") with type "|app|"
put it into tApp
## I select QTPLayer.app
if the result = "cancel" then
exit to top
end if
## tDatei holds the complete path to the MP3
## tApp the path to QTPlayer.app
launch tDatei with tApp
put the result
...

It will open the MP3 with QTPlayer as desired BUT
it also opens the file with "iTunes/Music" additionally!?
And I don't want that! :-D

The result is EMPTY.

Bug or feature?
And can I avoid to also open the file with "Music"?

Thanks in advance!


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

Re: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[Rick Harrison via use-livecode]

Ah, the old days of LC 6.7 when LiveCode was fast.
How much I miss that!

Hopefully our new compiler when it comes out
will make me feel that LC 6.7 was really slow.

Thanks for the walk down memory lane!

Rick

___
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: Can't get jsonToArray in standalones ?

[matthias rebbe via use-livecode]

Panos,

is there a reason why mergJSON is not listed in the dictionary anymore in LC 
9.6.6,9.6.7, 10DDP2, 10DP3?

Matthias

> Am 04.04.2022 um 16:08 schrieb panagiotis m via use-livecode 
> :
> 
> Hello Ben,
> 
> You need to check megJSON.
> 
> The JSON Library inclusion is for JSONImport and JSONExport handlers.
> 
> Cheers,
> Panos
> 
> On Mon, 4 Apr 2022, 16:28 Ben Rubinstein via use-livecode, <
> use-livecode@lists.runrev.com> wrote:
> 
>> Building a standalone that uses jsonToArray.
>> 
>> Works fine in the IDE.
>> 
>> If I use "search for required inclusions" when building the standaline,
>> then
>> when the script calls jsonToArray it throws error 219 (Function: error in
>> function handler).
>> 
>> If I use "select inclusions", and check "JSON Library", then it crashes.
>> 
>> Interestingly, if I *uncheck* "JSON Library" from the inclusions, then it
>> also
>> crashes! (I expected it would throw error 219.)
>> 
>> This is the same on LC 9.6.6 and 9.6.7; and (at least the crash) same on
>> both
>> Mac and Windows.
>> 
>> My best guess is that I need to have something else checked in the
>> inclusions
>> - any suggestions?
>> 
>> TIA,
>> 
>> Ben
>> 
>> ___
>> 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: Can't get jsonToArray in standalones ?

[panagiotis m via use-livecode]

I mean mergJSON, not megJSON :)

Cheers,
Panos

On Mon, 4 Apr 2022, 17:08 panagiotis m,  wrote:

> Hello Ben,
>
> You need to check megJSON.
>
> The JSON Library inclusion is for JSONImport and JSONExport handlers.
>
> Cheers,
> Panos
>
> On Mon, 4 Apr 2022, 16:28 Ben Rubinstein via use-livecode, <
> use-livecode@lists.runrev.com> wrote:
>
>> Building a standalone that uses jsonToArray.
>>
>> Works fine in the IDE.
>>
>> If I use "search for required inclusions" when building the standaline,
>> then
>> when the script calls jsonToArray it throws error 219 (Function: error in
>> function handler).
>>
>> If I use "select inclusions", and check "JSON Library", then it crashes.
>>
>> Interestingly, if I *uncheck* "JSON Library" from the inclusions, then it
>> also
>> crashes! (I expected it would throw error 219.)
>>
>> This is the same on LC 9.6.6 and 9.6.7; and (at least the crash) same on
>> both
>> Mac and Windows.
>>
>> My best guess is that I need to have something else checked in the
>> inclusions
>> - any suggestions?
>>
>> TIA,
>>
>> Ben
>>
>> ___
>> 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: Can't get jsonToArray in standalones ?

[panagiotis m via use-livecode]

Hello Ben,

You need to check megJSON.

The JSON Library inclusion is for JSONImport and JSONExport handlers.

Cheers,
Panos

On Mon, 4 Apr 2022, 16:28 Ben Rubinstein via use-livecode, <
use-livecode@lists.runrev.com> wrote:

> Building a standalone that uses jsonToArray.
>
> Works fine in the IDE.
>
> If I use "search for required inclusions" when building the standaline,
> then
> when the script calls jsonToArray it throws error 219 (Function: error in
> function handler).
>
> If I use "select inclusions", and check "JSON Library", then it crashes.
>
> Interestingly, if I *uncheck* "JSON Library" from the inclusions, then it
> also
> crashes! (I expected it would throw error 219.)
>
> This is the same on LC 9.6.6 and 9.6.7; and (at least the crash) same on
> both
> Mac and Windows.
>
> My best guess is that I need to have something else checked in the
> inclusions
> - any suggestions?
>
> TIA,
>
> Ben
>
> ___
> 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

Can't get jsonToArray in standalones ?

[Ben Rubinstein via use-livecode]

Building a standalone that uses jsonToArray.

Works fine in the IDE.

If I use "search for required inclusions" when building the standaline, then 
when the script calls jsonToArray it throws error 219 (Function: error in 
function handler).


If I use "select inclusions", and check "JSON Library", then it crashes.

Interestingly, if I *uncheck* "JSON Library" from the inclusions, then it also 
crashes! (I expected it would throw error 219.)


This is the same on LC 9.6.6 and 9.6.7; and (at least the crash) same on both 
Mac and Windows.


My best guess is that I need to have something else checked in the inclusions 
- any suggestions?


TIA,

Ben

___
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: Hey Lurkers: Anyone still using LC 6.7? (Regulars too)

[matthias rebbe via use-livecode]

> Am 10.03.2022 um 20:39 schrieb doc hawk via use-livecode 
> :
> 
> Gosh, I never got *any* version of 6 to work well enough to use!
> 
Really? I've updated old and created new apps with different versions of LC6 
w/o any big problems. 
The apps do db stuff (MSSQL and MySQL), FTP uploads/downloads, dp post/get 
requests and we used LC Server 6 on our webserver for several tasks e.g form 
processing, db communication, handling post requests and others. That all 
worked fine here.

As soon as a new version, even DP, comes out and if time allows, i try to 
create at least our in-house apps with the new version. 
Firstly this helps to find bugs in the new version, at least in the areas our 
apps are using, and secondly, it ensures also that our apps can also be created 
with that new version.

That above is, of course, not to say that others did not have problems with 
LC6. Just wanted to share my experience with 6

Matthias


> :)
> 
> There’s still switches in my code for 5, but there are enough other uses of 
> later features of 7+ that it’s a non-issue.
> 
> 
> ___
> 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