Re: Plotting Equations that Bifurcate
On 31/10/2020 02:28, Roger Guay via use-livecode wrote: Lots of clever ideas here, Alex, but I think you’re missing the point of what I ultimately want to do. I'm building a plotting program for which I want to plot any equation including those that have multiple values of y for a given x. An equation might branch at any point and might even have multiple branches both of which are unknown before plotting. Of course, there’s always the possibility that I’m not fully comprehending your suggestions??? What does NB stand for? Are you suggesting creating a new polygon every time a branch is detected? That just might work?! Hi Roger. You're right - I missed the point; I jumped to the assumption that you were asking about a fairly small, specific issue - so leapt too quickly to a code sample. But before I address the general question(s), let me get the little points out of the way :-) NB - sorry, kind of common usage in British English. Actually, it's from a Latin phrase - "Nota Bene" - meaning "note well". So basically just 'take note of'. "a new polygon every branch" - yes, perfectly possible. Also possible is what I did in the first case of the code sample - a new 'sequence of points' for each branch, and then stitch those together (with blank lines between) into a single polygon; but that's, for now, a detail. The essence of the problem is that your app will (somehow) develop a number of 'sequences of *data* points' - and then those need to be translated into equivalent sets of *display* points (by either a plotting library, or by your own code) to allow it to be displayed appropriately. There are at least two possible plotting libraries that might do what you want (or do something close enough that they could be useful). By coincidence, they were both discussed at the San Jose LC conference in 2019.If you have access to the video / papers from that you might already have some of the info you need; I don't know if the conference papers are ever put out for more general usage later. Option A. Monte described a wrapper for the JSPlot library. It's a very powerful library capable of many kinds of graphs / plots, and very quick and capable. The most obvious downside is that it needs to be used within a browser widget - but well worth looking at it if you can. Option B. I did a library called "GraphMaker" - a pure-Livecode plotting library. It is (I think) fairly easy to use - but that may not be the case for someone else coming to it new. I know it can handle this case of bifurcating plots (using multiple sequences of data points). The conference slides were a decent, if very brief, introduction; the lengthier documentation was, maybe, not quite complete. However, it does come with a demo app that uses the library to draw a variety of graph types. Main advantage is it's pure LC, and hopefully easy to use - both in understanding and in ease of integration into an app (you just create a suitable group to contain the graph, set its rect properly and pass in all the point data along with various parameters. It has nowhere near the coverage of different graph types that JSPlot does - it's basically line, bar and scatter plots, with primary X-axis, and can have shading, etc. Option C. Roll your own. I'd certainly suggest investigating the use of an existing library first. There's quite a lot of effort needs to go into determining how to scale the data to the space available, how to label the axes, how to add tick marks, grid lines and (perhaps) multiple Y-axes. That stuff probably accounted for 90% of the effort of creating the library. If you'd like to try out my library, the latest version can be found at https://www.tweedly.org/lcms.lc/GraphMaker (sorry - I haven't formatted it into my usual download structure - so this is simply a page that gives links that allow you to download the 2 files you need and 2 more files you don't need.) Of course, I'll be happy to help out in any way I can with it. Alex. P.S. the demo app includes an example of a 'branching' plot (Graph 3). ___ 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: IOS Screen resizing /EXACT FIT not working as before
On 11/3/20 4:08 PM, Lagi Pittas via use-livecode wrote: Thanks though - every suggestion comes in useful sometime (is that a Dean Martin song?) LOL -- Mark Wieder ahsoftw...@gmail.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: IOS Screen resizing /EXACT FIT not working as before
Hi, Thanks for that hint Jacque will certainly have a look at that. Panos - we have 4 Iphone pluses and they are all set to standard - all worked fine before. But I checked mine and another just in case an IOS update changed it - nope both still standard. Thanks though - every suggestion comes in useful sometime (is that a Dean Martin song?) Regards lagi On Tue, 3 Nov 2020 at 08:48, panagiotis merakos via use-livecode < use-livecode@lists.runrev.com> wrote: > Hello Lagi, > > In the iPhone 8 Plus device, could you check in Settings -> Display and > Brightness and then scroll down and in the "Display Zoom" section, does it > say "Standard" or "Zoomed" ? > > If it says Zoomed, then the stack will scale as if it was on an iPhone 8. > Changing this to Standard will cause the stack to scale as before. > > Kind regards, > Panos > -- > > On Mon, 2 Nov 2020 at 22:53, J. Landman Gay via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > Try fullscreenMode "showAll" or "noBorder". I generally use showAll. > There > > will be black bars > > at the sides or top/bottom on some devices depending on which mode you > > choose but the advantage > > is that it retains the stack ratio. At least one dimension will always > fit. > > > > You can obscure the black bars by setting the backcolor of the stack to a > > matching or > > complimentary color. The unused areas will fill with that color instead > of > > showing black. > > > > On 11/2/20 1:30 PM, Lagi Pittas via use-livecode wrote: > > > Hi, > > > > > > On an IOS app we have been using the > > > > > > setfullscreenmode of stack "XYZ" to exactfit. > > > > > > Although it isn't perfect in the sense it doesn't try to use the > "notch" > > it > > > has been working well. > > > > > > We have compiled with the latest livecode stable and the latest XCODE > and > > > now the there is > > > a greater margin on either side and the top (especially on the iphone > > plus) > > > > > > We did notice this happened randomly and very very rarely on the > previous > > > version of xcode and the previous stable livecode but it > > > wasn't a "HARD" error and not on everybody's IPHONE 8 plus > > > > > > Anybody have any ideas the best way to make the App resize well on all > > the > > > new ones? > > > > > > The dimensions of the stack are 414 by 736 (the logical resolution of > the > > > iphone 8 plus) . > > > > > > To date it has scaled pretty well down and up but now on the iphone we > > have > > > more of it is not scaling up properly. > > > > > > Any suggestions for making this work SIMPLY ie we don't need it to > bother > > > too much about the notch as long as it uses as much > > > real estate for the different sizes. The App looked fine on the X as > well > > > even if it didn't go right down to the bottom. > > > > > > I am not one to follow the latesdFads ghis is a business program so > there > > > is no dark mode or other stupid ideas to make > > > people upgrade for no reason other than its different. > > > > > > Any ideas or help appreciated. > > > > > > > > > Lagi > > > > > > > > > -- > > Jacqueline Landman Gay | jac...@hyperactivesw.com > > HyperActive Software | http://www.hyperactivesw.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 > -- KIndest Regards Lagi ___ 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: Query large CSV file as a data source?
> Am 03.11.2020 um 23:02 schrieb Bob Sneidar via use-livecode
> :
>
> Just read for 10,000 lines and check for empty each time.
>
To be honest, i've never used the read file for ... lines.
I was expecting that there might be an error if one tries to read more lines
than there are left for read
Good to know that one can just read in a loop without calculating the loop
count first.
-
Matthias Rebbe
Life Is Too Short For Boring Code
> Bob S
>
>
>> On Nov 3, 2020, at 7:09 AM, matthias rebbe via use-livecode
>> wrote:
>>
>> Regarding the loop.
>>
>> you could do a
>>
>> put the detailed files
>>
>> to get the file size of that csv file.
>>
>> With that size you would now how often you have to run the loop
>>
>>
>>
>>
>>
>> -
>> Matthias Rebbe
>> Life Is Too Short For Boring Code
>>
>>> Am 03.11.2020 um 15:14 schrieb Keith Clarke via use-livecode
>>> :
>>>
>>> Thank you Matthias, I wasn’t aware of that ability to open the file and
>>> read its contents straight from the disk.
>>>
>>> A quick experiment looks positive - no hanging and fast access - so I just
>>> need to work on the loop.
>>>
>>> Much obliged.
>>>
>>> Best,
>>> Keith
>>>
On 3 Nov 2020, at 13:37, matthias rebbe via use-livecode
wrote:
Couldn't you read the file partially
you would open the file for read
open file tFile for read
then in a repeat loop you could read e.g. 1 lines and process the data
read from file tFile for 1 lines
Just a thought.
-
Matthias Rebbe
Life Is Too Short For Boring Code
> Am 03.11.2020 um 13:14 schrieb Keith Clarke via use-livecode
> :
>
> Hi folks,
> I’ve a 3GB CSV file with 18M rows from which I need to create a subset
> CSV file for the rows containing tString. The following script results in
> LiveCode becoming unresponsive, so I’m wondering if I’m missing an
> obvious trick or what alternative approach I might take...
> on mouseUp pButtonNumber
>
> -- Select CSV File
>
> answer file prompt as sheet
>
> put it into tFile
>
> put tFile into field "File"
>
> -- Process CSV extract
>
> put URL ("file:" & tFile) into tText
>
> put line 1 of tText into field "List"
>
> filter lines of tText with "*tString*"
>
> put tText into field tList
>
> end mouseUp
>
> I don’t normally deal with large data sets, so maybe LiveCode isn’t the
> best tool for this but Excel 365 seems to only offer CSV file import, not
> query.
>
> Any thoughts greatly appreciated.
>
> Thanks & regards,
> 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-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
___
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: Ideas on iOS GPS tracking needed
Seems to me if you are tracking linear movement, you need to average the trending values, say the last 5 or 10 reads, against a time base, and reject the ones outside an acceptable tolerance. You may reject some good data here and there, but something grossly outside tolerance should be pretty easy to grok. Sounds easy, huh? :-) But it really is. For a car moving at 60mph, obviously the trend is going to be greater than a person walking, and slower than a small airplane. For an alien spacecraft traveling at insane speeds and making wild maneuvers, I’m afraid you are on your own. The tolerance can be a percentage of the average of the last x reads or the last x seconds. Seconds makes more sense to me since if you drop 2 or 3 reads it will skew the averages significantly. That is likely how Google Maps does it. Bob S On Nov 3, 2020, at 2:39 PM, Alan Stenhouse via use-livecode mailto:use-livecode@lists.runrev.com>> wrote: Hi Graham Are you checking the horizontal accuracy of each reading? (It's part of the array of data with your lat-longs, as well as speed, etc - though not on every phone). If not, try that and see if the anomalous readings are hugely out. From my experience, that's normally the case. If so, the easiest thing is to drop them in the short term, unless you get too many and then you may need to be a bit fancier. If you do, would love to hear the solution that you come up with. HTH, cheers Alan ___ 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: Ideas on iOS GPS tracking needed
Hi Graham Are you checking the horizontal accuracy of each reading? (It's part of the array of data with your lat-longs, as well as speed, etc - though not on every phone). If not, try that and see if the anomalous readings are hugely out. From my experience, that's normally the case. If so, the easiest thing is to drop them in the short term, unless you get too many and then you may need to be a bit fancier. If you do, would love to hear the solution that you come up with. HTH, cheers Alan > On 4 Nov 2020, at 3:30 am, Graham Samuel wrote: > > From: Graham Samuel > To: How to use LiveCode > Subject: Ideas on iOS GPS tracking needed > Message-ID: <6c855814-1850-4975-b185-1731efcd6...@mac.com> > Content-Type: text/plain; charset=utf-8 > > Sorry this is a bit long. > > For a long time I?ve been tinkering with an app that uses the GPS on iPhones > to show how far ?as the crow flies? the user is from some base point, which > is set before the journey starts. It?s intended for walkers and cyclists, and > I was using a beta version in the first French lockdown, which forbade one > walking more than 1km from one?s house. I put the completion of this aside, > but now we?re in the second French lockdown and it looks worth finishing - > but I have some issues which I believe are not just down to my bad coding > (though of course that?s more than possible), and I wonder if anyone else has > thought about this stuff. > > The basic idea is extremely simple, as you can imagine, and it wasn?t hard to > code. The app keeps working out the point-to-point distance from the base and > tests it against the permitted limit. If the limit is exceeded, it sounds an > alarm. If the user goes back within the limit, the alarm stops. Everything > else is just cosmetic, really. > > The issue I have is that in every journey of say 40 minutes to an hour, the > iPhone appears to generate a few ?bad? GPS readings. When I say bad, I mean > way beyond the published accuracy of the GPS (which varies up to about 70m). > Sometimes the GPS wants to tell me that I?ve walked half a kilometer in three > seconds! > > I have analysed a lot of data (.gpx files) from other apps for walkers, > drivers and cyclists and I don?t see such glaring anomalies; and using such > apps on my main test phone (an iPhone X), I don?t see these strange readings > affecting the data. > > Assuming this isn?t just a stupid coding error on my part (OK, a risky > assumption), I need to find a solution, either by increasing the accuracy of > the readings, or by finding the anomalies as they occur and eliminating them. > I know no way of doing the first, and although I have ideas for the second > (check apparent speed, for example), none seems foolproof. As the app works > in real time, a retroactive curve-fitting solution is no good for me, even if > my maths was up to coding it (Kalman filter, anyone?). > > Has anyone tried anything like this, and if so, did you find any anomalies in > the data, and how did you cope with them? > > I?d be grateful for any ideas. > > Graham ___ 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: Query large CSV file as a data source?
Just read for 10,000 lines and check for empty each time.
Bob S
> On Nov 3, 2020, at 7:09 AM, matthias rebbe via use-livecode
> wrote:
>
> Regarding the loop.
>
> you could do a
>
> put the detailed files
>
> to get the file size of that csv file.
>
> With that size you would now how often you have to run the loop
>
>
>
>
>
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
>
>> Am 03.11.2020 um 15:14 schrieb Keith Clarke via use-livecode
>> :
>>
>> Thank you Matthias, I wasn’t aware of that ability to open the file and read
>> its contents straight from the disk.
>>
>> A quick experiment looks positive - no hanging and fast access - so I just
>> need to work on the loop.
>>
>> Much obliged.
>>
>> Best,
>> Keith
>>
>>> On 3 Nov 2020, at 13:37, matthias rebbe via use-livecode
>>> wrote:
>>>
>>> Couldn't you read the file partially
>>>
>>> you would open the file for read
>>>
>>> open file tFile for read
>>>
>>> then in a repeat loop you could read e.g. 1 lines and process the data
>>>
>>> read from file tFile for 1 lines
>>>
>>>
>>> Just a thought.
>>>
>>>
>>> -
>>> Matthias Rebbe
>>> Life Is Too Short For Boring Code
>>>
Am 03.11.2020 um 13:14 schrieb Keith Clarke via use-livecode
:
Hi folks,
I’ve a 3GB CSV file with 18M rows from which I need to create a subset CSV
file for the rows containing tString. The following script results in
LiveCode becoming unresponsive, so I’m wondering if I’m missing an obvious
trick or what alternative approach I might take...
on mouseUp pButtonNumber
-- Select CSV File
answer file prompt as sheet
put it into tFile
put tFile into field "File"
-- Process CSV extract
put URL ("file:" & tFile) into tText
put line 1 of tText into field "List"
filter lines of tText with "*tString*"
put tText into field tList
end mouseUp
I don’t normally deal with large data sets, so maybe LiveCode isn’t the
best tool for this but Excel 365 seems to only offer CSV file import, not
query.
Any thoughts greatly appreciated.
Thanks & regards,
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-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: Query large CSV file as a data source?
Regarding the loop.
you could do a
put the detailed files
to get the file size of that csv file.
With that size you would now how often you have to run the loop
-
Matthias Rebbe
Life Is Too Short For Boring Code
> Am 03.11.2020 um 15:14 schrieb Keith Clarke via use-livecode
> :
>
> Thank you Matthias, I wasn’t aware of that ability to open the file and read
> its contents straight from the disk.
>
> A quick experiment looks positive - no hanging and fast access - so I just
> need to work on the loop.
>
> Much obliged.
>
> Best,
> Keith
>
>> On 3 Nov 2020, at 13:37, matthias rebbe via use-livecode
>> wrote:
>>
>> Couldn't you read the file partially
>>
>> you would open the file for read
>>
>> open file tFile for read
>>
>> then in a repeat loop you could read e.g. 1 lines and process the data
>>
>> read from file tFile for 1 lines
>>
>>
>> Just a thought.
>>
>>
>> -
>> Matthias Rebbe
>> Life Is Too Short For Boring Code
>>
>>> Am 03.11.2020 um 13:14 schrieb Keith Clarke via use-livecode
>>> :
>>>
>>> Hi folks,
>>> I’ve a 3GB CSV file with 18M rows from which I need to create a subset CSV
>>> file for the rows containing tString. The following script results in
>>> LiveCode becoming unresponsive, so I’m wondering if I’m missing an obvious
>>> trick or what alternative approach I might take...
>>> on mouseUp pButtonNumber
>>>
>>> -- Select CSV File
>>>
>>> answer file prompt as sheet
>>>
>>> put it into tFile
>>>
>>> put tFile into field "File"
>>>
>>> -- Process CSV extract
>>>
>>> put URL ("file:" & tFile) into tText
>>>
>>> put line 1 of tText into field "List"
>>>
>>> filter lines of tText with "*tString*"
>>>
>>> put tText into field tList
>>>
>>> end mouseUp
>>>
>>> I don’t normally deal with large data sets, so maybe LiveCode isn’t the
>>> best tool for this but Excel 365 seems to only offer CSV file import, not
>>> query.
>>>
>>> Any thoughts greatly appreciated.
>>>
>>> Thanks & regards,
>>> 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-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: Query large CSV file as a data source?
Thank you Matthias, I wasn’t aware of that ability to open the file and read
its contents straight from the disk.
A quick experiment looks positive - no hanging and fast access - so I just need
to work on the loop.
Much obliged.
Best,
Keith
> On 3 Nov 2020, at 13:37, matthias rebbe via use-livecode
> wrote:
>
> Couldn't you read the file partially
>
> you would open the file for read
>
> open file tFile for read
>
> then in a repeat loop you could read e.g. 1 lines and process the data
>
> read from file tFile for 1 lines
>
>
> Just a thought.
>
>
> -
> Matthias Rebbe
> Life Is Too Short For Boring Code
>
>> Am 03.11.2020 um 13:14 schrieb Keith Clarke via use-livecode
>> :
>>
>> Hi folks,
>> I’ve a 3GB CSV file with 18M rows from which I need to create a subset CSV
>> file for the rows containing tString. The following script results in
>> LiveCode becoming unresponsive, so I’m wondering if I’m missing an obvious
>> trick or what alternative approach I might take...
>> on mouseUp pButtonNumber
>>
>> -- Select CSV File
>>
>> answer file prompt as sheet
>>
>> put it into tFile
>>
>> put tFile into field "File"
>>
>> -- Process CSV extract
>>
>> put URL ("file:" & tFile) into tText
>>
>> put line 1 of tText into field "List"
>>
>> filter lines of tText with "*tString*"
>>
>> put tText into field tList
>>
>> end mouseUp
>>
>> I don’t normally deal with large data sets, so maybe LiveCode isn’t the best
>> tool for this but Excel 365 seems to only offer CSV file import, not query.
>>
>> Any thoughts greatly appreciated.
>>
>> Thanks & regards,
>> 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-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: Query large CSV file as a data source?
Couldn't you read the file partially
you would open the file for read
open file tFile for read
then in a repeat loop you could read e.g. 1 lines and process the data
read from file tFile for 1 lines
Just a thought.
-
Matthias Rebbe
Life Is Too Short For Boring Code
> Am 03.11.2020 um 13:14 schrieb Keith Clarke via use-livecode
> :
>
> Hi folks,
> I’ve a 3GB CSV file with 18M rows from which I need to create a subset CSV
> file for the rows containing tString. The following script results in
> LiveCode becoming unresponsive, so I’m wondering if I’m missing an obvious
> trick or what alternative approach I might take...
> on mouseUp pButtonNumber
>
> -- Select CSV File
>
> answer file prompt as sheet
>
> put it into tFile
>
> put tFile into field "File"
>
> -- Process CSV extract
>
> put URL ("file:" & tFile) into tText
>
> put line 1 of tText into field "List"
>
> filter lines of tText with "*tString*"
>
> put tText into field tList
>
> end mouseUp
>
> I don’t normally deal with large data sets, so maybe LiveCode isn’t the best
> tool for this but Excel 365 seems to only offer CSV file import, not query.
>
> Any thoughts greatly appreciated.
>
> Thanks & regards,
> 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-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
Query large CSV file as a data source?
Hi folks,
I’ve a 3GB CSV file with 18M rows from which I need to create a subset CSV file
for the rows containing tString. The following script results in LiveCode
becoming unresponsive, so I’m wondering if I’m missing an obvious trick or what
alternative approach I might take...
on mouseUp pButtonNumber
-- Select CSV File
answer file prompt as sheet
put it into tFile
put tFile into field "File"
-- Process CSV extract
put URL ("file:" & tFile) into tText
put line 1 of tText into field "List"
filter lines of tText with "*tString*"
put tText into field tList
end mouseUp
I don’t normally deal with large data sets, so maybe LiveCode isn’t the best
tool for this but Excel 365 seems to only offer CSV file import, not query.
Any thoughts greatly appreciated.
Thanks & regards,
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: IOS Screen resizing /EXACT FIT not working as before
Hello Lagi, In the iPhone 8 Plus device, could you check in Settings -> Display and Brightness and then scroll down and in the "Display Zoom" section, does it say "Standard" or "Zoomed" ? If it says Zoomed, then the stack will scale as if it was on an iPhone 8. Changing this to Standard will cause the stack to scale as before. Kind regards, Panos -- On Mon, 2 Nov 2020 at 22:53, J. Landman Gay via use-livecode < use-livecode@lists.runrev.com> wrote: > Try fullscreenMode "showAll" or "noBorder". I generally use showAll. There > will be black bars > at the sides or top/bottom on some devices depending on which mode you > choose but the advantage > is that it retains the stack ratio. At least one dimension will always fit. > > You can obscure the black bars by setting the backcolor of the stack to a > matching or > complimentary color. The unused areas will fill with that color instead of > showing black. > > On 11/2/20 1:30 PM, Lagi Pittas via use-livecode wrote: > > Hi, > > > > On an IOS app we have been using the > > > > setfullscreenmode of stack "XYZ" to exactfit. > > > > Although it isn't perfect in the sense it doesn't try to use the "notch" > it > > has been working well. > > > > We have compiled with the latest livecode stable and the latest XCODE and > > now the there is > > a greater margin on either side and the top (especially on the iphone > plus) > > > > We did notice this happened randomly and very very rarely on the previous > > version of xcode and the previous stable livecode but it > > wasn't a "HARD" error and not on everybody's IPHONE 8 plus > > > > Anybody have any ideas the best way to make the App resize well on all > the > > new ones? > > > > The dimensions of the stack are 414 by 736 (the logical resolution of the > > iphone 8 plus) . > > > > To date it has scaled pretty well down and up but now on the iphone we > have > > more of it is not scaling up properly. > > > > Any suggestions for making this work SIMPLY ie we don't need it to bother > > too much about the notch as long as it uses as much > > real estate for the different sizes. The App looked fine on the X as well > > even if it didn't go right down to the bottom. > > > > I am not one to follow the latesdFads ghis is a business program so there > > is no dark mode or other stupid ideas to make > > people upgrade for no reason other than its different. > > > > Any ideas or help appreciated. > > > > > > Lagi > > > > > -- > Jacqueline Landman Gay | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.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
