Re: Web help needed

2020-07-12 Thread Richard Gaskin via use-livecode

Bill Prothero wrote:
> Sorry if this is off, but what about just transferring them with ftp?

FTP is good enough for a small number of files.  But for automating 
large numbers of file transfers rsync is hard to beat, a much smarter 
tool making things much more efficient.


By default, rsync will only transfer files that have changed, and even 
then only transfers the portions of a file that's changed.


It can be used to sync folders locally or remotely - I run all my 
backups with it, in addition to using it post files to servers from my 
local master copy.


rsync is preinstalled with macOS, can be added to Windows, and is a 
standard part of most popular Linux distros used on servers.


It's secure using SSH, so if you add your SSH public key to your server 
(useful for a good many things) you not only get good security but it 
makes it easy to automate with LiveCode's shell function.



@Michael Doub: I believe HostM uses Ubuntu, so rsync is preinstalled 
there.  And since you use macOS, your copy is preinstalled on your Mac.


IMNSHO, you'll want to request SSH for any hosting service that doesn't 
offer it by default.  With SSH, not only do you get to use standard 
Unix/Linux utilities like rsync, scp, and others, but sooner or later 
you're likely to need or want to do something on that server outside of 
the limited scope of what FTP is designed for.  With shell access you 
can do anything you need, just as good as having the server sitting on 
your desk, even if it's thousands of miles away.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.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: Web help needed

2020-07-12 Thread Mike Doub via use-livecode
HostM does support rsync but you have to request SSH to be enabled.

I was able to get an sftp client to work.  Im not sure if LiveCode supports 
sftp.

-= Mike
On Jul 12, 2020, 1:13 PM -0400, Mike Doub , wrote:
> I just sent a request to HostM to see if they support rsync.  If they do then 
> one option would be to create all of the pdfs and csv on the mac then rsync 
> them to the server.  This leads me down a new set of unknowns... How do you 
> set up rsync? I assume that there is some configuration required on both the 
> mac and server.
> On Jul 12, 2020, 12:56 PM -0400, Mike Doub , wrote:
> > The server is hosted on HostM and they are very good a keeping Livecode 
> > Server current. I am assuming it is a Unix variant of some sort.  My 
> > desktop is a mac.
> >
> > Let me tell you the details of what I am trying to do.   I have written a 
> > tool in livecode that takes a RideWithGPS route and generates a pdf and 
> > .csv files for the cue sheet.  (basic turn by turn instructions for cycling 
> > the route.)  This tools sits on the server side and processes requests via 
> > a form.   Basically 1 route at a time.
> >
> > There are some 950 routes that are in my cycling clubs archive on 
> > RideWithGPS.  I am looking to generate updated pdf and csv files for all of 
> > the routes.  I was thinking about just cycling thru each of the routes, 
> > create the pdf and csv on my mac and just push the files onto the server.   
> > It is the push them onto the server that I don’t know how to do.   I am 
> > looking for some guidance on both the mac and server side.
> >
> > -= Mike
> > On Jul 12, 2020, 12:32 PM -0400, Rick Harrison via use-livecode 
> > , wrote:
> > > Hi Mike,
> > >
> > > I think we are lacking some key information in order to solve your 
> > > problem.
> > >
> > > Is your LC Server on a Mac? If so, what is preventing you from just
> > > dragging and dropping a folder of your files across the network from your
> > > desktop Mac to your LC (Mac?) Server computer?
> > >
> > > Once your files are on the Server where you want them, then you
> > > can play around with having LC Server access them through forms
> > > if you want to do that. You can also put the data into a database
> > > if you need to do that too and then access them with your LC Server.
> > >
> > > Are you hosting your LC Server on a computer you own, or
> > > are you using a hosting service instead?
> > >
> > > Let us know.
> > >
> > > Rick
> > >
> > >
> > >
> > > > On Jul 11, 2020, at 8:24 PM, Mike Doub via use-livecode 
> > > >  wrote:
> > > >
> > > > I am a rookie at web stuff. I have a couple of end point api’s set up 
> > > > to use with simple forms. Got that working with .lc file that starts 
> > > > using a LiveCode stack that does the work.
> > > >
> > > > I need to move hundreds of files from my desktop Mac to my server. I’m 
> > > > looking for advise as to how best to do this. I was thinking about 
> > > > creating an endpoint on my server that my desktop app would use. But, I 
> > > > don’t understand how that might work.
> > > >
> > > > I need some help for some experience web folks. How do I go about 
> > > > moving files? Most of them are text, but I would like to understand how 
> > > > to deal with binary files too (thinking images). All of the examples I 
> > > > see are for a user interface form and that does not make sense for the 
> > > > number of files I need to move.
> > > >
> > > > Thanks in advance.
> > > > -= Mike
> > >
> > > ___
> > > 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: Web help needed

2020-07-12 Thread Mike Doub via use-livecode
I just sent a request to HostM to see if they support rsync.  If they do then 
one option would be to create all of the pdfs and csv on the mac then rsync 
them to the server.  This leads me down a new set of unknowns... How do you set 
up rsync? I assume that there is some configuration required on both the mac 
and server.
On Jul 12, 2020, 12:56 PM -0400, Mike Doub , wrote:
> The server is hosted on HostM and they are very good a keeping Livecode 
> Server current. I am assuming it is a Unix variant of some sort.  My desktop 
> is a mac.
>
> Let me tell you the details of what I am trying to do.   I have written a 
> tool in livecode that takes a RideWithGPS route and generates a pdf and .csv 
> files for the cue sheet.  (basic turn by turn instructions for cycling the 
> route.)  This tools sits on the server side and processes requests via a 
> form.   Basically 1 route at a time.
>
> There are some 950 routes that are in my cycling clubs archive on 
> RideWithGPS.  I am looking to generate updated pdf and csv files for all of 
> the routes.  I was thinking about just cycling thru each of the routes, 
> create the pdf and csv on my mac and just push the files onto the server.   
> It is the push them onto the server that I don’t know how to do.   I am 
> looking for some guidance on both the mac and server side.
>
> -= Mike
> On Jul 12, 2020, 12:32 PM -0400, Rick Harrison via use-livecode 
> , wrote:
> > Hi Mike,
> >
> > I think we are lacking some key information in order to solve your problem.
> >
> > Is your LC Server on a Mac? If so, what is preventing you from just
> > dragging and dropping a folder of your files across the network from your
> > desktop Mac to your LC (Mac?) Server computer?
> >
> > Once your files are on the Server where you want them, then you
> > can play around with having LC Server access them through forms
> > if you want to do that. You can also put the data into a database
> > if you need to do that too and then access them with your LC Server.
> >
> > Are you hosting your LC Server on a computer you own, or
> > are you using a hosting service instead?
> >
> > Let us know.
> >
> > Rick
> >
> >
> >
> > > On Jul 11, 2020, at 8:24 PM, Mike Doub via use-livecode 
> > >  wrote:
> > >
> > > I am a rookie at web stuff. I have a couple of end point api’s set up to 
> > > use with simple forms. Got that working with .lc file that starts using a 
> > > LiveCode stack that does the work.
> > >
> > > I need to move hundreds of files from my desktop Mac to my server. I’m 
> > > looking for advise as to how best to do this. I was thinking about 
> > > creating an endpoint on my server that my desktop app would use. But, I 
> > > don’t understand how that might work.
> > >
> > > I need some help for some experience web folks. How do I go about moving 
> > > files? Most of them are text, but I would like to understand how to deal 
> > > with binary files too (thinking images). All of the examples I see are 
> > > for a user interface form and that does not make sense for the number of 
> > > files I need to move.
> > >
> > > Thanks in advance.
> > > -= Mike
> >
> > ___
> > 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: Web help needed

2020-07-12 Thread Prothero@earthlearning via use-livecode
Sorry if this is off, but what about just transferring them with ftp?
Bill

William Prothero
http://es.earthednet.org

> On Jul 12, 2020, at 9:57 AM, Mike Doub via use-livecode 
>  wrote:
> 
> The server is hosted on HostM and they are very good a keeping Livecode 
> Server current. I am assuming it is a Unix variant of some sort.  My desktop 
> is a mac.
> 
> Let me tell you the details of what I am trying to do.   I have written a 
> tool in livecode that takes a RideWithGPS route and generates a pdf and .csv 
> files for the cue sheet.  (basic turn by turn instructions for cycling the 
> route.)  This tools sits on the server side and processes requests via a 
> form.   Basically 1 route at a time.
> 
> There are some 950 routes that are in my cycling clubs archive on 
> RideWithGPS.  I am looking to generate updated pdf and csv files for all of 
> the routes.  I was thinking about just cycling thru each of the routes, 
> create the pdf and csv on my mac and just push the files onto the server.   
> It is the push them onto the server that I don’t know how to do.   I am 
> looking for some guidance on both the mac and server side.
> 
> -= Mike
>> On Jul 12, 2020, 12:32 PM -0400, Rick Harrison via use-livecode 
>> , wrote:
>> Hi Mike,
>> 
>> I think we are lacking some key information in order to solve your problem.
>> 
>> Is your LC Server on a Mac? If so, what is preventing you from just
>> dragging and dropping a folder of your files across the network from your
>> desktop Mac to your LC (Mac?) Server computer?
>> 
>> Once your files are on the Server where you want them, then you
>> can play around with having LC Server access them through forms
>> if you want to do that. You can also put the data into a database
>> if you need to do that too and then access them with your LC Server.
>> 
>> Are you hosting your LC Server on a computer you own, or
>> are you using a hosting service instead?
>> 
>> Let us know.
>> 
>> Rick
>> 
>> 
>> 
 On Jul 11, 2020, at 8:24 PM, Mike Doub via use-livecode 
  wrote:
>>> 
>>> I am a rookie at web stuff. I have a couple of end point api’s set up to 
>>> use with simple forms. Got that working with .lc file that starts using a 
>>> LiveCode stack that does the work.
>>> 
>>> I need to move hundreds of files from my desktop Mac to my server. I’m 
>>> looking for advise as to how best to do this. I was thinking about creating 
>>> an endpoint on my server that my desktop app would use. But, I don’t 
>>> understand how that might work.
>>> 
>>> I need some help for some experience web folks. How do I go about moving 
>>> files? Most of them are text, but I would like to understand how to deal 
>>> with binary files too (thinking images). All of the examples I see are for 
>>> a user interface form and that does not make sense for the number of files 
>>> I need to move.
>>> 
>>> Thanks in advance.
>>> -= Mike
>> 
>> ___
>> 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: Web help needed

2020-07-12 Thread Mike Doub via use-livecode
The server is hosted on HostM and they are very good a keeping Livecode Server 
current. I am assuming it is a Unix variant of some sort.  My desktop is a mac.

Let me tell you the details of what I am trying to do.   I have written a tool 
in livecode that takes a RideWithGPS route and generates a pdf and .csv files 
for the cue sheet.  (basic turn by turn instructions for cycling the route.)  
This tools sits on the server side and processes requests via a form.   
Basically 1 route at a time.

There are some 950 routes that are in my cycling clubs archive on RideWithGPS.  
I am looking to generate updated pdf and csv files for all of the routes.  I 
was thinking about just cycling thru each of the routes, create the pdf and csv 
on my mac and just push the files onto the server.   It is the push them onto 
the server that I don’t know how to do.   I am looking for some guidance on 
both the mac and server side.

-= Mike
On Jul 12, 2020, 12:32 PM -0400, Rick Harrison via use-livecode 
, wrote:
> Hi Mike,
>
> I think we are lacking some key information in order to solve your problem.
>
> Is your LC Server on a Mac? If so, what is preventing you from just
> dragging and dropping a folder of your files across the network from your
> desktop Mac to your LC (Mac?) Server computer?
>
> Once your files are on the Server where you want them, then you
> can play around with having LC Server access them through forms
> if you want to do that. You can also put the data into a database
> if you need to do that too and then access them with your LC Server.
>
> Are you hosting your LC Server on a computer you own, or
> are you using a hosting service instead?
>
> Let us know.
>
> Rick
>
>
>
> > On Jul 11, 2020, at 8:24 PM, Mike Doub via use-livecode 
> >  wrote:
> >
> > I am a rookie at web stuff. I have a couple of end point api’s set up to 
> > use with simple forms. Got that working with .lc file that starts using a 
> > LiveCode stack that does the work.
> >
> > I need to move hundreds of files from my desktop Mac to my server. I’m 
> > looking for advise as to how best to do this. I was thinking about creating 
> > an endpoint on my server that my desktop app would use. But, I don’t 
> > understand how that might work.
> >
> > I need some help for some experience web folks. How do I go about moving 
> > files? Most of them are text, but I would like to understand how to deal 
> > with binary files too (thinking images). All of the examples I see are for 
> > a user interface form and that does not make sense for the number of files 
> > I need to move.
> >
> > Thanks in advance.
> > -= Mike
>
> ___
> 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: Web help needed

2020-07-12 Thread Mark Wieder via use-livecode

On 7/12/20 9:10 AM, Mike Doub via use-livecode wrote:

Thanks Richard.   I guess I was not clear.   I was looking for the best ways to 
do the file transfer with LiveCode and LiveCode server.


Why?

get shell("rsync ")...


--
 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: Web help needed

2020-07-12 Thread Rick Harrison via use-livecode
Hi Mike,

I think we are lacking some key information in order to solve your problem.

Is your LC Server on a Mac?  If so, what is preventing you from just
dragging and dropping a folder of your files across the network from your
desktop Mac to your LC (Mac?) Server computer?

Once your files are on the Server where you want them, then you
can play around with having LC Server access them through forms
if you want to do that.  You can also put the data into a database
if you need to do that too and then access them with your LC Server.

Are you hosting your LC Server on a computer you own, or
are you using a hosting service instead?

Let us know.

Rick



> On Jul 11, 2020, at 8:24 PM, Mike Doub via use-livecode 
>  wrote:
> 
> I am a rookie at web stuff.  I have a couple of end point api’s set up to use 
> with simple forms.  Got that working with .lc file that starts using a 
> LiveCode stack that does the work.
> 
> I need to move hundreds of files from my desktop Mac to my server.   I’m 
> looking for advise as to how best to do this.  I was thinking about creating 
> an endpoint on my server that my desktop app would use.  But, I don’t 
> understand how that might work.
> 
> I need some help for some experience web folks.  How do I go about moving 
> files?   Most of them are text, but I would like to understand how to deal 
> with binary files too (thinking images).  All of the examples I see are for a 
> user interface form and that does not make sense for the number of files I 
> need to move.
> 
> Thanks in advance.
>   -= Mike

___
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: Web help needed

2020-07-12 Thread Mike Doub via use-livecode
Thanks Richard.   I guess I was not clear.   I was looking for the best ways to 
do the file transfer with LiveCode and LiveCode server.

  -= Mike
On Jul 11, 2020, 10:50 PM -0400, Richard Gaskin via use-livecode 
, wrote:
> Mike Doub wrote:
>
> > I need to move hundreds of files from my desktop Mac to my server.
> > I’m looking for advise as to how best to do this.
>
> rsync
>
> --
> Richard Gaskin
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web
> 
> ambassa...@fourthworld.com http://www.FourthWorld.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: sorting lines by date

2020-07-12 Thread David V Glasgow via use-livecode
Thanks everyone & Curry.  I will play with this some more.  Looking at the 
lists I am given, most of the date columns are declared to be UTC.  I intended 
to try to detect other formats in due course, but thought I’d start with the 
common one.

Reminds me of my favourite Jake Peralta line: “Stupid rest of the world, 
writing their dates all dumb!”

Cheers, and thanks again.

David G

> On 11 Jul 2020, at 7:06 pm, Curry Kenworthy via use-livecode 
>  wrote:
> 
> 
> Like everything field and text related, this thread caught my eye! :)
> 
> One of my favorite areas of LiveCode, and also one of the areas I have to 
> actively keep an eye on since I rely on it a lot.
> 
> Here's an observation that might help in one way or another
> 
> David:
> 
> > http://adomain/ 27/06/2016 8:10
> 
> > set itemdel to tab
> > sort lines of field "import" datetime by the last item of each
> 
> > the order above is generated.
> > I can’t see any meaningful ordering of the lines.
> 
> I was curious and copied your content into a field where I changed the date 
> format of the dates, like so:
> 
> http://adomain/   06/27/2016 8:10
> http://adomain/   11/17/2013 22:18
> 
> And for me, over here on this side of the ocean (cue Trump rally: USA! USA!) 
> that both looks good, and works well, using your unmodified code. The lines 
> without a date also stacked up at the top, as you predicted, and as I know to 
> be the normal LC sort behavior.
> 
> I realize you need the British format, but again out of curiosity and to make 
> sure everything LC datewise is working properly, you might try your sort 
> again, with a few lines of your content and that modification.
> 
> (There is also a useSystemDate keyword that you could test.)
> 
> Regardless, be assured that ABSOLUTELY it is possible to have datetime sorts 
> working well in fields or text with tabbed columns. Have no doubts or fears 
> in that regard. I very recently delivered a client project, this year, with 
> that feature.
> 
> The only question is efficiency. It would be better and faster to get the 
> datetime sort working directly with your content.
> 
> But if not, you can also sort with a custom function, and then the sky is the 
> limit! LC sort really is powerful and flexible.
> 
> But I would like to know the outcome, so when this is resolved, thanks in 
> advance for posting again to let us know what worked!
> 
> Best wishes,
> 
> Curry Kenworthy
> 
> Custom Software Development
> "Better Methods, Better Results"
> LiveCode Training and Consulting
> 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


___
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