On 2018-09-06 20:31, Frank Cazabon wrote:
On 06/09/2018 04:38 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com
wrote:
it's a slick formula for determining the TIME that's passed within the
workday hours set (not just days; that'd be simple).
Are you sure about that? Everywhere I've looked it sa
On 2018-09-06 17:41, Stephen Russell wrote:
Do you have a table for Holidays? We use it in our system but it also
identifies the country you are in for work. We are USA, CA, UK for
now.
I too tried the formula in base format in excel and it returns days
when my
two cells were 7-30-2018 13:
On 06/09/2018 04:38 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
it's a slick formula for determining the TIME that's passed within the
workday hours set (not just days; that'd be simple).
Are you sure about that? Everywhere I've looked it says it returns the
number of Whole workdays
This is the table I use:
USE [Calendar]
GO
/** Object: Table [dbo].[Calendar]Script Date: 06/09/2018 06:02:16 PM
**/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Calendar](
[dt] [date] NOT NULL,
[isWeekday] [bit] NULL
For Holidays in various countries, please check the calendar class in
GitHub VFp
Koen
Op do 6 sep. 2018 om 23:41 schreef Stephen Russell :
> Do you have a table for Holidays? We use it in our system but it also
> identifies the country you are in for work. We are USA, CA, UK for now.
>
> I too
No, the calendar table has a column to specify if a date is a holiday.
On 6 September 2018 17:41:04 GMT-04:00, Stephen Russell
wrote:
>Do you have a table for Holidays? We use it in our system but it also
>identifies the country you are in for work. We are USA, CA, UK for
>now.
>
>I too tried
Do you have a table for Holidays? We use it in our system but it also
identifies the country you are in for work. We are USA, CA, UK for now.
I too tried the formula in base format in excel and it returns days when my
two cells were 7-30-2018 13:00:00 and 08-01-2018 23:00:00.
I didn't monkey ar
On 2018-09-06 09:30, Stephen Russell wrote:
Today the industry is changing the name from Web Service to API but in
general it works in much the same way.
But I get the impression that it's easier to work with the APIs?
___
Post Messages to: ProFox@l
Ah, didn't know that. My quick Google of it only mentioned days.
Even if it were just days, it's definitely not that simple when you take into
consideration holidays and that some work days are Saturdays in some
places/jobs.
I still see those complications with calculating the time.
On 6 Septe
Cheers tracey I am going to pick apart the vfptweetapi as it seems to contain
everything I need
-Original Message-
From: ProfoxTech On Behalf Of Tracy Pearson
Sent: Thursday, 06 September 2018 20:14
To: profoxt...@leafe.com
Subject: RE: SOAP
You need to add a header. How it is formatted
No no...despite the name, it's not a count of days; it's a count of the
TIME (hours/minutes) within the workday parameters set.
Counting days would be easy.
On 2018-09-05 18:22, Stephen Russell wrote:
Idea on network days
for loop between the days
insert to a cursor if the DOW if not a weeken
On 2018-09-05 17:54, Frank Cazabon wrote:
I use a calendar table (albeit in SQL server but that shouldn't
matter). Then it's just a matter of some simple queries.
On 5 September 2018 16:47:27 GMT-04:00,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
See screenshot for case matter:
https://
You need to add a header. How it is formatted depends on the API.
I have this code, I'm also using the Chilkat ActiveX control for the HTTP
requests.
oHTTPRequest.AddHeader("Authorization", "Bearer " + Token)
As an side note, I started using the Chilkat control over the MSXML control
because the
Keeping it basic at the moment with MsXml2.XmlHttp
But I have noticed in the middle of vfpoauth there is a signrequest method that
doesn't seem to be used ... I have also ventured into the vfptweetapi and that
has the same function so I will delve deeper tomorrow
-Original Message-
Fro
Thank you Kevin
Rafael
El jue., 6 sept. 2018 a las 12:03, Kevin J Cully ()
escribió:
> Take a look in the Downloads area for the Stru2PostgreSQL and Stru2MySQL_2
> program. It should be pretty easy to modify those to get the structures
> generated.
>
> http://leafe.com/download/stru2postgreSQL.P
What are you using to make the web requests in VFP?
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Thursday, September 06, 2018 2:12 PM
To: profoxt...@leafe.com
Subject: Re: SOAP
Progress I have managed to use vfpoauth to get my ac
I have worked with oAuth on two integrations.
1) Google Calendar. We ended up switching gears and are using a C# exe outside
our main exe.
2) Constant Contact. We ended up writing a C# Web service to handle the oAuth
callback. Once the user finishes the login, they need to click a button to
fetc
Progress I have managed to use vfpoauth to get my access token now I need to
work out how to sign a request in vfp , I can get it to work in postman
> On 6 Sep 2018, at 19:01, Stephen Russell wrote:
>
> This might help?
>
> https://github.com/VFPX/VFPOAuth
>
>
>
>
>
>> On Thu, Sep 6, 201
This might help?
https://github.com/VFPX/VFPOAuth
On Thu, Sep 6, 2018 at 10:24 AM Chris Davis wrote:
> Thanks Stephen, I am struggling with oAuth at the moment, the
> documentation gives examples but obviously not in VFP and it looks like
> things like javascript and php include oauth modul
Thanks Ted I have found and downloaded vfpoauth but have failed to get it to
work
-Original Message-
From: ProfoxTech On Behalf Of Ted Roche
Sent: Thursday, 06 September 2018 16:31
To: profoxt...@leafe.com
Subject: Re: SOAP
Chris:
I searched here: http://bfy.tw/Jl8C
and found this: ht
Chris:
I searched here: http://bfy.tw/Jl8C
and found this: https://archive.codeplex.com/?p=vfpoauth
HTH,
Ted
On Thu, Sep 6, 2018 at 11:24 AM Chris Davis wrote:
> Thanks Stephen, I am struggling with oAuth at the moment, the
> documentation gives examples but obviously not in VFP and it looks
Thanks Stephen, I am struggling with oAuth at the moment, the documentation
gives examples but obviously not in VFP and it looks like things like
javascript and php include oauth modules.
So if I can reword my question, has anyone got any oauth code 😊
-Original Message-
From: ProfoxTech
Take a look in the Downloads area for the Stru2PostgreSQL and Stru2MySQL_2
program. It should be pretty easy to modify those to get the structures
generated.
http://leafe.com/download/stru2postgreSQL.PRG
http://leafe.com/download/stru2mysql_2.prg
-Kevin
-Original Message-
From: ProFo
I wrote a little function that reads in a vfp table, and outputs a SQL
Create table script. Would be super simple to either alter it to output
Substr(coriginalname,3) or to edit/replace the field names in the text
output file. Do you want it?
---
This email has been checked for viruses by Av
I made a simple table,st_ex, with ST columns and then here is the
change script to strip the ST off:
/* To prevent any potential data loss issues, you should review this script
in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
Why not write the script in VFP and then cut-and-paste it into the SQL
Server? Use AFIELDS to get the fieldlist, TEXTMERGE to write the script.
Easy, peasy.
On Thu, Sep 6, 2018 at 10:28 AM Rafael Copquin
wrote:
> I need to import a DBF table into SQL Server
> However, all the fields in the DBF t
I need to import a DBF table into SQL Server
However, all the fields in the DBF table begin with the suffix ST (a
previous programmer built the table in 1992, with the notion that all
fields should have a specific suffix related to the table's purpose)
But I just want the sql server table to have
To be honest, REST is just a way that sets up an interaction in complex
ways without the client knowing anything beforehand about the server and
the resources it hosts. You define that the transmission is going to be
HTTP and then follow the rules for it.
Now your call to the API can be done from
Chris
There are several articles on Web Services that you may find useful on Rick
Strahl's web site (west-wind.com)
Paul
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: 06 September 2018 13:31
To: profoxt...@leafe.com
Subject: SO
Thanks for the reply Russell, I have now discovered this particular thing also
supports REST api, just trying to figure out oAuth
-Original Message-
From: ProfoxTech On Behalf Of Stephen Russell
Sent: Thursday, 06 September 2018 14:30
To: profoxt...@leafe.com
Subject: Re: SOAP
Too bad t
Too bad that Alan is no longer among us, he redid his application all in
Web Service calls years ago.
In general, the "service" is a replacement for a data store. You ask for
data from the service and it gives it to you in SOAP, xml that is. What
you actually receive is some sort of collection o
Is anyone able to share an example of working with a webservice purely in code?
Thanks
Chris.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
Post Messages to: ProFox@leafe.c
Didn't follow this whole thread but I see the "first email" problem and the
Outlook model and I recognize this as we used this for 15+ years.
Start Outlook once a day. Send your monitoring account the first email. Let
it run all day.
-Original Message-
From: ProfoxTech On Behalf Of Gene
33 matches
Mail list logo