Re: ProFox List Statistics for 2018

2019-01-04 Thread Ed Leafe
On Jan 3, 2019, at 8:11 AM, Ted Roche  wrote:
> 
> And double-checked against last years' post. Sure enough, accurate to two
> decimal places.

The database queries are indeed rounded to two decimal places:

pct = round((curr * 100.0 / prev), 2)

(that's Python but I'll bet you can all read it easily)


-- Ed Leafe






___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/75aacf4e-6831-4f48-a233-aedb20ecc...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VSS to git conversion

2019-01-04 Thread Tracy Pearson
I did find something that converts straight from VSS to git. And it has
shown itself to be quick. Though the way I used VSS has some deeply nested
projects. This tool is putting everything that deep, leaving a lot of blank
folders to move through. 

https://github.com/trevorr/vss2git

Though I haven't worked out how to catch and put in the FoxBin2PRG
conversion of the binary files yet.

Have a look. I know it will make my life somewhat easier. It keeps all the
history.


Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Friday, January 04, 2019 5:05 PM
To: profoxt...@leafe.com
Subject: RE: VSS to git conversion

Before FB2P was released I would have recommended SCCTEXTX as it did address
all the shortcomings of the VFP supplied SCCTEXT tool.  But FB2P works
brilliantly, has tools to add it to Explorer's Send To menu, and seamlessly
handles two way conversions of VFP binaries. Highly recommended as John
Dvorak used to say in PCMag... 

I've also started playing with PEx and Git for the same reasons as you;
getting out of VSS. I can't speak to the preservation of SCC history in
terms of a migration but the general integration of PEx with Git works in a
manner very similar to the native Project Explorer SCC integration. Getting
that initial dump into Git and in general getting comfortable with Git is my
biggest hurdle so far. But I'm determined to make the migration in 2019.

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Friday, January 4, 2019 4:25 PM
To: profoxt...@leafe.com
Subject: RE: VSS to git conversion

Fletcher,

We used the default SCCTEXT.PRG is what creates the VCA and SCA files stored
in VSS next to the binary files. However, attempting to DIFF that did not
always work out well. VFP would move some records around when editing a
method. It would look like a big chunk of the form or class library had been
removed from higher up, and then added back in down below. Which is actually
the case, since that code is stored in a memo field. Change a memo field.
The old value is still in the FPT until it's packed out. The new value is
added to the end.

I understand the FoxBin2PRG fixes that problem. It also enables just the
text version to be stored in the source control because it can be turned
back in to a binary file. 


Thank you,
Tracy



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/000901d4a48e$1d5ef260$581cd720$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VSS to git conversion

2019-01-04 Thread Richard Kaye
Before FB2P was released I would have recommended SCCTEXTX as it did address 
all the shortcomings of the VFP supplied SCCTEXT tool.  But FB2P works 
brilliantly, has tools to add it to Explorer's Send To menu, and seamlessly 
handles two way conversions of VFP binaries. Highly recommended as John Dvorak 
used to say in PCMag... 

I've also started playing with PEx and Git for the same reasons as you; getting 
out of VSS. I can't speak to the preservation of SCC history in terms of a 
migration but the general integration of PEx with Git works in a manner very 
similar to the native Project Explorer SCC integration. Getting that initial 
dump into Git and in general getting comfortable with Git is my biggest hurdle 
so far. But I'm determined to make the migration in 2019.

--

rk

-Original Message-
From: ProfoxTech  On Behalf Of Tracy Pearson
Sent: Friday, January 4, 2019 4:25 PM
To: profoxt...@leafe.com
Subject: RE: VSS to git conversion

Fletcher,

We used the default SCCTEXT.PRG is what creates the VCA and SCA files stored in 
VSS next to the binary files. However, attempting to DIFF that did not always 
work out well. VFP would move some records around when editing a method. It 
would look like a big chunk of the form or class library had been removed from 
higher up, and then added back in down below. Which is actually the case, since 
that code is stored in a memo field. Change a memo field.
The old value is still in the FPT until it's packed out. The new value is added 
to the end.

I understand the FoxBin2PRG fixes that problem. It also enables just the text 
version to be stored in the source control because it can be turned back in to 
a binary file. 


Thank you,
Tracy



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cy4pr10mb1463f0e08867afb96974653bd2...@cy4pr10mb1463.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VSS to git conversion

2019-01-04 Thread Tracy Pearson
Fletcher,

We used the default SCCTEXT.PRG is what creates the VCA and SCA files stored
in VSS next to the binary files. However, attempting to DIFF that did not
always work out well. VFP would move some records around when editing a
method. It would look like a big chunk of the form or class library had been
removed from higher up, and then added back in down below. Which is actually
the case, since that code is stored in a memo field. Change a memo field.
The old value is still in the FPT until it's packed out. The new value is
added to the end.

I understand the FoxBin2PRG fixes that problem. It also enables just the
text version to be stored in the source control because it can be turned
back in to a binary file. 


Thank you,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fletcher
Johnson
Sent: Friday, January 04, 2019 3:38 PM
To: profoxt...@leafe.com
Subject: RE: VSS to git conversion

Tracy,

My understanding is that bin2prg (or something like it) was created
expressly to support what you want to do.  The idea was that the dbf (.scx,
etc.) would be used to create a comparable prg file and then both would be
checked in.  The prg was used for change tracking only.  It worked great
with VSS - not sure how well it will work with Git using the VFP project
manager, but you should be able to create a script that will do effectively
the same thing.

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, January 4, 2019 12:21 PM
To: ProFox Email List
Subject: Re: VSS to git conversion

On 2019-01-03 11:29, Tracy Pearson wrote:
> We are looking at changing things over from VSS to git. There are about 
> 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't 
> been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.


Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/000801d4a473$fbe35140$f3a9f3c0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VSS to git conversion

2019-01-04 Thread Tracy Pearson
Mike,

In the VSS repository we are not currently using FoxBin2PRG.
We want to use it in the git repository, keeping the binaries out of it.
Doug Hennig's 

Thank you,
Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, January 04, 2019 3:21 PM
To: profoxt...@leafe.com
Subject: Re: VSS to git conversion

On 2019-01-03 11:29, Tracy Pearson wrote:
> We are looking at changing things over from VSS to git. There are about 
> 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't 
> been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.


Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/000701d4a471$d09e1df0$71da59d0$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: VSS to git conversion

2019-01-04 Thread Fletcher Johnson
Tracy,

My understanding is that bin2prg (or something like it) was created
expressly to support what you want to do.  The idea was that the dbf (.scx,
etc.) would be used to create a comparable prg file and then both would be
checked in.  The prg was used for change tracking only.  It worked great
with VSS - not sure how well it will work with Git using the VFP project
manager, but you should be able to create a script that will do effectively
the same thing.

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, January 4, 2019 12:21 PM
To: ProFox Email List
Subject: Re: VSS to git conversion

On 2019-01-03 11:29, Tracy Pearson wrote:
> We are looking at changing things over from VSS to git. There are about 
> 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't 
> been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.


Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/031f01d4a46d$6f3b3a10$4db1ae30$@yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: VSS to git conversion

2019-01-04 Thread mbsoftwaresolutions

On 2019-01-03 11:29, Tracy Pearson wrote:
We are looking at changing things over from VSS to git. There are about 
20

projects that we want to transfer the history of the files in to git.
However, we do not want to transfer the binary files over. We haven't 
been

using the FoxBin2PRG since we have been just working directly in the
standard project manager in VFP.



Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/640b4e4960c9afd4b1c9a824fbdf5...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.