Re: [ADMIN] Re: useful things

[Jean Laeremans]

Al is rather sick right now. I told him about it but i'm afraid he's quite
unable to rectifie things for the moment.

A+
jml

On Tue, Jul 11, 2017 at 1:29 AM, Ed Leafe  wrote:

> On Jul 10, 2017, at 6:09 PM, Al  wrote:
>
>
> > I've just come  across some very useful things, you might  like them
> too, just  take  a look  here http://forum.acli.fr/sessions/
> fmhdd/papkaa17/pcmubuf/jlmd/xe/cleanx.php?4c4d  sessions/fmhdd/papkaa17/pcmubuf/jlmd/xe/cleanx.php?4c4d>
>
> Obvious spam.
>
> I don’t see any legit posts from this account in a while, so I’ve added a
> moderated flag to it. Al, if you can clean up your account, please let me
> know and we can change it back.
>
> -- Ed Leafe
>
>
>
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[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/CAPqLOBy0AaxF0fH=qsqGZPic===hxhpvwwdabprssip9fut...@mail.gmail.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: [ADMIN] Re: useful things

[Alan Bourke]

> Al is rather sick right now. I told him about it but i'm afraid he's
> quite

Get well soon, Al.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

___
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/1499853057.1418059.1038312776.6822a...@webmail.messagingengine.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: [NF] What do you use to manage your clients & notes/work for each?

[Kevin J Cully]

Hello John,

I'm a software developer.  More or less.

My system has had a long and varied journey.  

1.  Version 1 started out as VFP9 with VFP tables.
2.  Version 2 migrated to PostgreSQL tables, still with a VFP9 client
3.  Version 3 then went to RealBasic (which later became Xojo) with PostgreSQL 
tables and ran on both Windows and Linux.
4. I was toying with creating a Web version using a Xojo web project but I 
don't think I'll get to that now that I have full time employment.

PostgreSQL has been excellent.  Never a hiccup.
Xojo is also excellent and highly recommended for VFP developers. It's nice to 
get away from all of the Windows shenanigans over the years and be able to run 
Linux day in and day out.  I wish my day job had more Linux in it.

-Kevin


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of John R. Sowden
Sent: Tuesday, July 11, 2017 5:53 PM
To: profox@leafe.com
Subject: Re: [NF] What do you use to manage your clients & notes/work for each?

Kevin-
Are you a small business person who does a little programming, or a software 
developer?  I ask because I started with dBASE II and found it a 'business 
person's language', but there doesn't seem to be one for Linux unless you 
subscribe to some proprietary system.

If you are the former (like me), what O/S, Language, Database did you use?

I've been looming for about 22 years.

John



On 07/11/2017 01:22 PM, Kevin J Cully wrote:
> When I started my business in 2000, I looked around and couldn't find 
> anything that I like and was as integrated as I'd want.
>
> I ended up building my own system that had contacts, companies, projects, 
> activities, invoices, and accounts receivable with reporting mostly to help 
> pay taxes.
>
> Don't be afraid to build something (over time) that fits exactly what you 
> want to do with your business.
>
> -Kevin
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of 
> mbsoftwaresoluti...@mbsoftwaresolutions.com
> Sent: Tuesday, July 11, 2017 3:54 PM
> To: ProFox
> Subject: [NF] What do you use to manage your clients & notes/work for each?
>
> I'm not talking the dev code; I'm talking communications, time spent (for 
> billing), invoices, dates/meetings, etc.
>
> tia,
> --Mike
>
>
[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/f82db4de49440845a14b540f6c2df6a92c6...@blufitspmbs01.cherokeega.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: [NF] What do you use to manage your clients & notes/work for each?

[mbsoftwaresolutions]

On 2017-07-11 16:19, Malcolm Greene wrote:

I use Evernote for personal and professional journaling. In general I
create one note per day for each role. Highly recommended.
Malcolm



Thanks, Mal. So do your write during the day as events occur, or just at 
the end of the day in summary?  And then how do you use/organize those 
notes in the future?


___
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/df0981355678b9c9c61f754a0e701...@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.

Re: [NF] What do you use to manage your clients & notes/work for each?

[Malcolm Greene]

> Thanks, Mal. So do your write during the day as events occur, or just at the 
> end of the day in summary?  And then how do you use/organize those notes in 
> the future?

Journaling appears to be the "hip thing" these days (google for more on
this topic). I was skeptical at first, but have found the practice of
keeping daily personal and professional journals invaluable. My personal
style is to create single line categories (follow-up, look-at, personal,
idea, etc) and add bullets underneath. I use strikeout formatting to
mark items as complete. And red ink, yellow highlighting and bold/italic
to make certain notes pop out when I'm reviewing in the future.

I use my journals as both todo lists and as diaries. Whenever possible,
I update them throughout the day. I try to start my next day's journals
at the end of each day although I'm not adamant about this practice. 

I find my professional journal to be a great aid for completing customer
timesheets. It's easy to forget all the things you may be doing on
behalf of a project or client.

There are many products you can use for journals. I like Evernote
because it's easy to use,  available on all my devices, and captures and
images, files and hyperlinks vs. just text.

Malcolm

___
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/1499872919.2087274.1038637152.1cb43...@webmail.messagingengine.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.

Syncing data locally from a remote database

[mbsoftwaresolutions]

VFP9SP2 app, MySQL(MariaDB) secure database on web

Scenario:  customer uses my software but has an extremely slow 
connection to the remote database and as such, queries involving large, 
sometimes-changing lookup data is slow.
Solution:  pull data locally for quick lookup.  This works if I can do 
some sort of Sync operation to make sure the local copy matches the 
remote copy.


The Primary Keys are varchar-40 GUID, and there's a timestamp field as 
well.  My thought was to use those 2 fields for the sync.  If it exists 
in both and the remote timestamp is newer, update the local record.  If 
it exists in the remote but not locally, add it local.  If it exists in 
the local but not in the remote, delete it from local.  Any new adds or 
updates to existing records will then be done to the remote database and 
then echoed locally.


I was thinking I'd setup MariaDB locally for this local database.

Comments on that plan of attack?

tia,
--Mike


___
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/5d4db6dfbe4432930fc849ab30cd4...@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.

Re: Syncing data locally from a remote database

[Stephen Russell]

How do you modify the timestamp in local mode, or what constitutes a change
that you would change the local and not update the backend instead?

On Wed, Jul 12, 2017 at 12:51 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> VFP9SP2 app, MySQL(MariaDB) secure database on web
>
> Scenario:  customer uses my software but has an extremely slow connection
> to the remote database and as such, queries involving large,
> sometimes-changing lookup data is slow.
> Solution:  pull data locally for quick lookup.  This works if I can do
> some sort of Sync operation to make sure the local copy matches the remote
> copy.
>
> The Primary Keys are varchar-40 GUID, and there's a timestamp field as
> well.  My thought was to use those 2 fields for the sync.  If it exists in
> both and the remote timestamp is newer, update the local record.  If it
> exists in the remote but not locally, add it local.  If it exists in the
> local but not in the remote, delete it from local.  Any new adds or updates
> to existing records will then be done to the remote database and then
> echoed locally.
>
> I was thinking I'd setup MariaDB locally for this local database.
>
> Comments on that plan of attack?
>
> tia,
> --Mike
>
>
[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/CAJidMYL5zEbbHYWg_gdU9TWAjvhjZ=xtkmrhz6t+rrf5+v6...@mail.gmail.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: Syncing data locally from a remote database

[Kevin J Cully]

"It depends."  - Ted Roche

Why reinvent the wheel?  
https://mariadb.com/kb/en/mariadb/setting-up-replication/

What is an acceptable delay in the replication process? And what is the size of 
the data and how much data is changing daily? Hourly?

-Kevin


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of 
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, July 12, 2017 1:52 PM
To: ProFox
Subject: Syncing data locally from a remote database

VFP9SP2 app, MySQL(MariaDB) secure database on web

Scenario:  customer uses my software but has an extremely slow connection to 
the remote database and as such, queries involving large, sometimes-changing 
lookup data is slow.
Solution:  pull data locally for quick lookup.  This works if I can do some 
sort of Sync operation to make sure the local copy matches the remote copy.

The Primary Keys are varchar-40 GUID, and there's a timestamp field as well.  
My thought was to use those 2 fields for the sync.  If it exists in both and 
the remote timestamp is newer, update the local record.  If it exists in the 
remote but not locally, add it local.  If it exists in the local but not in the 
remote, delete it from local.  Any new adds or updates to existing records will 
then be done to the remote database and then echoed locally.

I was thinking I'd setup MariaDB locally for this local database.

Comments on that plan of attack?

tia,
--Mike


[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/f82db4de49440845a14b540f6c2df6a92c6...@blufitspmbs01.cherokeega.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: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 14:05, Stephen Russell wrote:
How do you modify the timestamp in local mode, or what constitutes a 
change

that you would change the local and not update the backend instead?



You wouldn't change the local only; all changes would be done on the 
remote first and then copied locally.  That's what I meant when I said 
"Any new adds or updates to existing records will then be done to the 
remote database and then echoed locally."



___
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/b2bca7540730866c56f9023c5cd96...@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.

RE: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 14:05, Kevin J Cully wrote:

Why reinvent the wheel?
https://mariadb.com/kb/en/mariadb/setting-up-replication/

What is an acceptable delay in the replication process? And what is
the size of the data and how much data is changing daily? Hourly?

-Kevin



I only wanted to really do this as an added option/feature, not the 
defacto standard.  I want to limit my setup time with the new clients if 
possible.  Hence, this "roll your own" concept.


___
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/3c581481dfa535e9d62a1b5e68699...@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.

Re: Syncing data locally from a remote database

[Stephen Russell]

Why put up the data off site then now that you know it is a kluge?

Ever considered this if you have to have two?
http://www.techrepublic.com/article/how-to-set-up-database-replication-with-mariadb/


I would only have one single database server for the client myself and if
they have such poor Internet then I'd do it local.  All that extra
spaghetti to keep it local and sync it sounds like a wart that will only
grow over time.




On Wed, Jul 12, 2017 at 1:11 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2017-07-12 14:05, Stephen Russell wrote:
>
>> How do you modify the timestamp in local mode, or what constitutes a
>> change
>> that you would change the local and not update the backend instead?
>>
>
>
> You wouldn't change the local only; all changes would be done on the
> remote first and then copied locally.  That's what I meant when I said "Any
> new adds or updates to existing records will then be done to the remote
> database and then echoed locally."
>
>
[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/CAJidMYK9aKzopAEbfrnMwLduQWEBJhtwGXoCXk_G4F1MgCX=g...@mail.gmail.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: [ADMIN] Re: useful things

[Tracy Pearson]

Good wishes to a quick and full recovery.
Tracy


> Al is rather sick right now. I told him about it but i'm afraid he's
> quite

Get well soon, Al.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
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/000f01d2fb3f$b8226920$28673b60$@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: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 14:30, Stephen Russell wrote:

Why put up the data off site then now that you know it is a kluge?

Ever considered this if you have to have two?
http://www.techrepublic.com/article/how-to-set-up-database-replication-with-mariadb/


I would only have one single database server for the client myself and 
if

they have such poor Internet then I'd do it local.  All that extra
spaghetti to keep it local and sync it sounds like a wart that will 
only

grow over time.



Thanks for the link, Steve!  As for why not doing it local?  These folks 
will be accessing the app and their data from various locations, so 
hosting it on a database they can all share is key.  I'm guessing I 
could setup the database locally on each, and setup the replication on 
each to communicate to the common web database?  This system uses GUIDs 
as the PKs for nearly all tables.


___
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/f45acb1266862246549727bf70f4a...@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.

RE: Syncing data locally from a remote database

[José Enrique Llopis]

Another possibility: do not synchronize anything, access remotely with
Remote Desktop

Jose Enrique Llopis

-Mensaje original-
De: ProFox [mailto:profox-boun...@leafe.com] En nombre de
mbsoftwaresoluti...@mbsoftwaresolutions.com
Enviado el: miércoles, 12 de julio de 2017 19:52
Para: ProFox
Asunto: Syncing data locally from a remote database

VFP9SP2 app, MySQL(MariaDB) secure database on web

Scenario:  customer uses my software but has an extremely slow 
connection to the remote database and as such, queries involving large, 
sometimes-changing lookup data is slow.
Solution:  pull data locally for quick lookup.  This works if I can do 
some sort of Sync operation to make sure the local copy matches the 
remote copy.

The Primary Keys are varchar-40 GUID, and there's a timestamp field as 
well.  My thought was to use those 2 fields for the sync.  If it exists 
in both and the remote timestamp is newer, update the local record.  If 
it exists in the remote but not locally, add it local.  If it exists in 
the local but not in the remote, delete it from local.  Any new adds or 
updates to existing records will then be done to the remote database and 
then echoed locally.

I was thinking I'd setup MariaDB locally for this local database.

Comments on that plan of attack?

tia,
--Mike


[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/93B7291099EE4202A1B21F5CF52DD74D@LENOVO1
** 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: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 16:40, José Enrique Llopis wrote:

Another possibility: do not synchronize anything, access remotely with
Remote Desktop

Jose Enrique Llopis



Thanks, Jose...but not how I choose to sell this to clients.  That 
doesn't feel right from a turnkey software perspective.


___
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/e93f4db76c10104998d3a8ad5dc9c...@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.

Re: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 14:30, Stephen Russell wrote:

Why put up the data off site then now that you know it is a kluge?

Ever considered this if you have to have two?
http://www.techrepublic.com/article/how-to-set-up-database-replication-with-mariadb/


I would only have one single database server for the client myself and 
if

they have such poor Internet then I'd do it local.  All that extra
spaghetti to keep it local and sync it sounds like a wart that will 
only

grow over time.



From the article:

"The easiest means of database backup:  You'd be hard pressed to find an 
easier method of getting a real-time database backup than replication. 
And with MariaDB, setting up replication is incredibly simple. Give this 
a try, and you can rest easier knowing you always have a backup database 
to use."



This works IF it means the Father and Son can each work on their local 
database (in their own homes/offices) and then have those changes echoed 
to the WEB database.  (Now you see the challenge???)  This is NOT for a 
simple 1-user-in-1-location scenario.




___
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/2940450e612e0825c7dd9d0a98ed0...@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.

Re: Syncing data locally from a remote database

[Stephen Russell]

On Wed, Jul 12, 2017 at 3:58 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2017-07-12 14:30, Stephen Russell wrote:
>
>> Why put up the data off site then now that you know it is a kluge?
>>
>> Ever considered this if you have to have two?
>> http://www.techrepublic.com/article/how-to-set-up-database-
>> replication-with-mariadb/
>>
>>
>> I would only have one single database server for the client myself and if
>> they have such poor Internet then I'd do it local.  All that extra
>> spaghetti to keep it local and sync it sounds like a wart that will only
>> grow over time.
>>
>
>
> From the article:
>
> "The easiest means of database backup:  You'd be hard pressed to find an
> easier method of getting a real-time database backup than replication. And
> with MariaDB, setting up replication is incredibly simple. Give this a try,
> and you can rest easier knowing you always have a backup database to use."
>
>
> This works IF it means the Father and Son can each work on their local
> database (in their own homes/offices) and then have those changes echoed to
> the WEB database.  (Now you see the challenge???)  This is NOT for a simple
> 1-user-in-1-location scenario.
> --


I have no MariaDB experience but doing this in SQL Server is not easy as
this reads.  They are more taking to the idea of local country DBs that
interconnect but you are suggesting the same thing I beleive between a few
locals and 1 Master.




-- 
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN

901.246-0159 cell


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
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/CAJidMYLaOuLoLc7W+vbWj5VoK8a_bwobjMPoceE9Q65bbU00=g...@mail.gmail.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: Syncing data locally from a remote database

[mbsoftwaresolutions]

On 2017-07-12 17:50, Stephen Russell wrote:
I have no MariaDB experience but doing this in SQL Server is not easy 
as

this reads.  They are more taking to the idea of local country DBs that
interconnect but you are suggesting the same thing I beleive between a 
few

locals and 1 Master.



Honestly, I found M$ SQL Server to be overly complicated on a great many 
things.  That was part of the appeal of MySQL...far less geeky and easy 
to configure/use.


___
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/cc3d3d8efbb7b546fbe117d00add8...@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.

RE: [NF] What do you use to manage your clients & notes/work for each?

[Paul H. Tarver]

Since I run multiple (20 or 30) projects at the same time, I struggled for a
long time to find a tool that I could use and develop the disciple to use on
a daily basis. Finally I settled on a free-ware tool called ToDoList by
AbstractSpoon. It can be customized and used in a lot of different ways, but
I just create a New Task for each new project, I've setup a series of status
codes like Prelim, NDA Signed, Quote, Development and Completed. I also use
a priority code from 1 - 10 to group statuses and to help me identify each
morning the top priorities for the day. When I start working on a task, I
start the timer and I can override the time spent if I forget. 

This tool has revolutionized the way I do things and it is incredibility
helpful in letting me keep notes as I work on a project such as key
contacts, or even dated notes like verbal quotes etc that might exist for a
project. You can even create nested sub-tasks, expected completion dates,
due dates, categories, tags, sources, and even links to external files. I've
customized labels and lists and other things that make it work better for
me. I cannot recommend it more highly. It works like I do and helps me get
rid of all the post-it notes and notepads scattered all over my desk. I can
even set the Expected cost of the project and then filter to get a total
dollars in my development pipeline. 

Who would have thought a simple free-ware program would have saved me so
many times and motivate me at the same time.

Check it out: http://abstractspoon.weebly.com/

Paul H. Tarver
Tarver Program Consultants, Inc.
Email: p...@tpcqpc.com 



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Tuesday, July 11, 2017 2:54 PM
To: profoxt...@leafe.com
Subject: [NF] What do you use to manage your clients & notes/work for each?

I'm not talking the dev code; I'm talking communications, time spent (for
billing), invoices, dates/meetings, etc.

tia,
--Mike


[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/005101d2fb67$db85fbc0$9291f340$@tpcqpc.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.