Re: ProFox List Statistics for 2018
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
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
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
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
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
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
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.