Looking for programmer for Web and SMS

2022-09-07 Thread Mitchell Shiller via 4D_Tech
Hi,

I am looking to hire a 4D programmer or 2 separate programmers to help with 
following.

I have an Electronic Medical Record (written in 4D (Currently v18. Soon v19). I 
would like to accomplish the following 2 tasks:

Create a web portal to allow patients to book appointments online. The 
appointment scheduler is fully written and functional. I need someone with 4D 
Web experience and some HTML experience to allow my application to serve pages 
based on stored data, collect the appointment information and enter it in the 
database.

To send SMS / Text messages (preferably Twilio) to remind a patient of their 
appointment and receive back a text that confirms or cancels the appointment.

I suspect neither of these are very complicated. But would prefer to outsource 
to someone who has experience in these fields.

I will provide all of the hooks / integration to my program. I will provide the 
flow logic. I can help to tweak the HTML if necessary.

If you are interested, please contact me at mshil...@sympatico.ca

Thanks



Mitch’s 


Sent from my iPhone
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: WAN vs LAN Cache

2020-04-29 Thread Mitchell Shiller via 4D_Tech
Using MacOS 10.13.6
Application 18.1 LTS. Single instance of the application, stored in 
Applications folder.

So unfortunately that doesn’t explain it.

I will test on another machine using 10.14.6

Mitch

> In v17R5 that number changes if you use different instances of 4D. As long as 
> you use the same copy of the 4D application then it uses the same cache 
> folder.
> 
> Is this on Mac or Windows, and where is your 4D application installed?
> 
Sent from my iPad
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

WAN vs LAN Cache

2020-04-28 Thread Mitchell Shiller via 4D_Tech
Hi,

Just upgraded to 18.1LTS

When users connect via the LAN, caching of structure, plugins etc takes place 
only the first time we run the database. This is the expected behavior.

However when I run it over my a WAN, it downloads the cache files every time I 
connect. In the cache, I see a folder with ^DatabaseName_server.domain.com_XXX. 
Where XXX is a numerical in sequence. Today I logged in 4 times and have 4 
caches folders all 228mb in size   Screenshot available on request.

Bug? Feature? Can this behavior be changed as it is filling up my hard drive.

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Administration window on Server

2020-04-21 Thread Mitchell Shiller via 4D_Tech

> 
> Call "OPEN ADMINISTRATION WINDOW" in "On Server Startup”.

Thanks. Don’t know how I missed that….

Mitch

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Administration window on Server

2020-04-20 Thread Mitchell Shiller via 4D_Tech
On Apr 20, 2020, at 15:00, 4d_tech-requ...@lists.4d.com wrote:
> 
> There's a blog entry (somewhere, sorry) about customizing the admin window.  
> I'm sure it tells how to open custom or default.

I looked at the blog entry that seems most relevant.
It seems to deal with setting up a custom window.
I just want the Admin window to open automatically.
Can’t find a database parameter either.

Any ideas?

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Administration window on Server

2020-04-19 Thread Mitchell Shiller via 4D_Tech
Hi,

In previous versions when 4D Server would start up, the Administration window 
would automatically appear.
In v18, the window stays hidden. I realize that it consumed CPU cycles and is 
best hidden.
Is there any way to make it automatically appear?

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Reading and writing large arrays to disk

2020-01-06 Thread Mitchell Shiller via 4D_Tech
So I tested my setup. V17R5, MacOS Mojave.
My results were slightly different. Your mileage may vary.

Compared BLOB, JSON Stringify Array, and OB SET ARRAY / JSON Stringify.

For writing an array that exists in memory, 
BLOB was fastest with average times in  6-9 milliseconds. 
JSA was in the 30-34 milliseconds.
OB / JS in the 36-40 milliseconds.

Compressing the BLOB prior to writing slowed the process with times of about 
20-21 milliseconds.
However, the file size was 1/3 as big. Shrinking from 2.3MB to 0.74 MB.
Note that the files written with JSA  and OB/ JS were 1.1- 1.3 MB in size.

Reading showed similar results .
BLOB 10-16 milliseconds.
JSA 36-43 milliseconds.
OB / JS 38-47 milliseconds.

Reading a compressed BLOB took 16-18 milliseconds.

In the end, any of these methods is fast enough for my needs. The lesson being, 
that while a text loop looks simple and intuitive, it incurs huge overhead and 
cannot be used.

I guess your choice would depend on your need / preference for smaller file 
size, readability etc.

Thanks for everyone’s input.

Mitch

>> 
>> Writing
> I believe disk access is now heavily cached by both disk controller, system 
> and (probably) 4D, with asynchronous access. I would be surprised if this is 
> bottleneck, but it need to be tested.
> 
> So I tested various approaches, code is down. I skipped first option - it is 
> painstakingly slow - and added another possibility - similar to option 3, but 
> instead of OB SET ARRAY / JSON Stringify, I used  JSON Stringify Array. This 
> turned up to be the fastest method.
> 
> Here are results as a screenshot: sorry, too lazy to write it down.
> 
> 
> 
> 
> My conclusion: direct writing to disk is pretty fast, and grows linearly with 
> size of the array and does not depend weakly on size of elements, so it seems 
> to be a good choice for large arrays and solutions that need to be scalable.
> 
> VARIABLE TO BLOB is too slow. Did not tried compression, but that would not 
> improve performance, IMHO.
> 
> JSON Stringify Array is the fastest solution, it seems to grow slightly 
> faster, depending on overall size of data so may be slower for large arrays / 
> element length, but I am surprised how well are these libraries optimised. As 
> the code is really simple, I would go with this.
> 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Reading and writing large arrays to disk

2020-01-05 Thread Mitchell Shiller via 4D_Tech
Hi,

I have large string arrays (about 200 k elements).
I need to write and read them to disk.
Speed is the most important criteria.

Options
1) Create a text variable (loop with CR delimiter) and then TEXT TO DOCUMENT. 
2) VARIABLE TO BLOB, COMPRESS BLOB, BLOB TO DOCUMENT
3) OB SET ARRAY, JSON STRINGIFY, TEXT TO DOCUMENT 

Obviously using the reverse commands to read from disk.
Option one seems by far the slowest.

Anyone know if 2 or 3 is faster?
Does the COMPRESS BLOB help? The resultant file is about 2 MB in size without 
compression.
If yes to COMPRESS BLOB , Any différence from native 4D vs. GZIP compression?

Thanks as always.

Mitch



Sent from my iPad
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Web Area not visible

2020-01-03 Thread Mitchell Shiller via 4D_Tech
Hi,

A combination of things solved my problems.

1) If you have multiple web areas on the same page, make sure that the have 
different variable and object names.
2) Be sure and define the variables for the URL and the Progress.

Let me know if that works.

Mitch

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Structure and Verification issue: Solved

2019-12-10 Thread Mitchell Shiller via 4D_Tech
I read the Verify Log File in BBEdit and searched for  “Warning".
3 Occurrences. Corrected the offending forms.

Verified and it found a bunch of Orphan methods.
Repair and all is fine now.

Lesson: Do not read the Verify Log file in Safari. It does not correctly 
display all of the information.

Thanks to Tom and Eric.


> On Dec 10, 2019, at 2:18 PM, Tom Benedict  wrote:
> 
> Viewing the logs in a web browser is painful, especially on large structures. 
> I open the log in a text editor and look for strings like “warning” or 
> “Error”. Notepad++ has a good search feature which will list all the 
> occurrences in context.
> 
> HTH,
> 
> Tom
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Structure and Verification issue

2019-12-10 Thread Mitchell Shiller via 4D_Tech
Thanks Tom and Eric. Unfortunately, I deleted both the .4DIndx and .4DIndy 
files. Let them rebuild. 
Verified the structure and still get anomalies that were found.
But none highlighted or specified. In the Log Report.

Any other thoughts before I head off to tech support.

Appreciated, as always.

Mitch

> On Dec 10, 2019, at 1:43 PM, Tom Benedict  wrote:
> 
> Some years ago I adopted the habit of always deleting the .4DIndy file (the 
> structure index) when deploying .4DC files. I adopted this as a best practice 
> after a number of ‘weird behavior’ episodes during deployment. It may be 
> superstition, but the overhead for 4D to recreate the .4DIndy is very low, so 
> I continue to do it.
> 
> As you say, rebuilding a .4DIndx can take a lot longer, especially on large 
> data files. I only do it as part of routine maintenance. 
> 
> In this case I think you should consider deleting both, Mitch, and letting 4D 
> rebuild them.
> 
> Tom Benedict
> 
>> On Dec 10, 2019, at 09:41, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I have seen cases where the index files get messed up. For my small 
>> databases I just delete the index files and let 4D regenerate them. But for 
>> big databases it may take a while to rebuild them.
>> 
>>> On Dec 9, 2019, at 5:50 PM, Mitchell Shiller via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hi,
>>> 
>>> Went to verify my structure today after a week of coding. I noticed no 
>>> anomalies or issue with the db but I like to make sure all is OK.
>>> 
>>> Verification reports that anomalies are found. But when I check the log, 
>>> none are highlighted.
>>> I ran a repair 2X. A compact. 
>>> But verification still reports anomalies.
>>> 
>>> Looking through the structure, the Trash has been emptied and there are no 
>>> orphan methods or forms that I can see.
>>> 
>>> Help!
>>> Any ideas?
>>> 
>>> Is this an issue for Tech Support.
>>> 
>>> Thanks
>>> 
>>> Mitch
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Structure and Verification issue

2019-12-09 Thread Mitchell Shiller via 4D_Tech
Hi,

Went to verify my structure today after a week of coding. I noticed no 
anomalies or issue with the db but I like to make sure all is OK.

Verification reports that anomalies are found. But when I check the log, none 
are highlighted.
I ran a repair 2X. A compact. 
But verification still reports anomalies.

Looking through the structure, the Trash has been emptied and there are no 
orphan methods or forms that I can see.

Help!
Any ideas?

Is this an issue for Tech Support.

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Log integration failed

2019-11-19 Thread Mitchell Shiller via 4D_Tech
Hi,

I have sporadic crashes on my 4D Server that I am trying to solve. But that is 
not my issue today.

The server is set to 1) Integrate the log file if database incomplete and 2) 
Restore from backup if the database is damaged.
Also the cache flush is set to 20 sec.

95% of the time this works the way it should. Re-start the computer, it 
integrates the log and off we go.
If there is damage (I assume) 4D makes a copy of the database and timestamps it 
and then backups and restores the log.

Well, yesterday while trying to automatically integrate the Log file it stops 
and gave me the following message;

“Error when executing the method “MESS_COMMOM.automatic_font (runtime) at line 
number 1
Log file cannot be integrated into database Pediatrics v7”

then

“An error occurred during the log file integration, it is recommended to 
restore the last backup of this database in order to attempt the integration of 
this log file”

But as you might expect, trying to restore with this log file results in the 
exact same message.
So I am stuck losing all my data, since the last backup since the log file 
couldn’t be integrated.

My question pertains to this case: Is it worth trying to open the timestamped 
damaged database and repair it? Theoretically I would only lose data since the 
last cache flush.

Thoughts? Experiences?

Recovering from 8 hours of lost data has not been fun.

Thanks as always,

Mitch





**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area, 4D method Parameters

2019-11-12 Thread Mitchell Shiller via 4D_Tech
Thanks. That did it.
>> 
> 
> It probably should be 
> 
>  
> --
> 
> Peter Bozek
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Web Area, 4D method Parameters

2019-11-11 Thread Mitchell Shiller via 4D_Tech
Hi,

Starting working on displaying a table in a web area.
Have my HTML working correctly. i.e. my 4D data is displaying correctly.

My goal is to run a 4D method when clicking on a table row.

My table row is populated with the following HTML (rest of document left out 
for brevity sake);


  Miscellaneous 4D data 



  Next 4D data 



WA_CLICK has the following 4D code;

C_TEXT($1;$Text)
TRACE
$Text:=$1
ALERT("Web Area Clicked"+$Text)

I load the html and the all is fine.
I click on the line and the 4D method is called and stops at the TRACE.

BUT, $1 is blank. Anyone know why $1 does not pick up the “Row 1” or “Row 2”?

Thanks. Probably pretty basic but I am very novice with HTML.

Thanks

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area not visible

2019-11-07 Thread Mitchell Shiller via 4D_Tech
Thanks Kirk. That did it.

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Web Area not visible

2019-11-07 Thread Mitchell Shiller via 4D_Tech
Kirk,

I could run Chrome on it, but I need to access 4D methods and that requires the 
embedded engine.

Anyone else notice this problem?

 Takes 1 minute to recreate. New dB. Create a form. Put a web area on it. 
Select use embedded engine. Run form.

Just want to know if it is particular to my setup or if it is A 4D bug?

Thanks
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Web Area not visible

2019-11-06 Thread Mitchell Shiller via 4D_Tech
Hi,

MacOs 12.6 
4D v17R6

Create a form.
Put a Web Area on it.
Open the form and the Web Area is visible.

Same layout. Select “Use embedded Web rendering engine”.
Open the form and the Web Area is not visible

Any ideas? What am I missing?

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Procedural printing HTML or a WebArea

2019-11-03 Thread Mitchell Shiller via 4D_Tech
Hi,

I generate an HTML document that is displayed in a WebArea.
Once completed, I need to generate a PDF procedurally. (No user interaction)

Is there a way to either
1) print out a Web Area ( the contents could be more than 1 page long)
2) convert the HTML to a PDF.

I am on Mac. 4Dv17R5.

Thanks.

Mitch

Sent from my iPad
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Write Pro view mode

2019-10-29 Thread Mitchell Shiller via 4D_Tech
Thanks,

I had the old docs on my computer.

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Write Pro view mode

2019-10-28 Thread Mitchell Shiller via 4D_Tech
Hi,

Is there a way to procedurally change the view mode of a 4D Write Pro area. I’m 
using 4D 17R6.
I have a widget on a page which is displayed in Page mode.
I want to be able to procedurally hide or show the toolbars. 

Thanks

Mitch

Sent from my iPad
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

V17 R - Mojave compatibility

2019-02-15 Thread Mitchell Shiller via 4D_Tech
Hi, 

I know that 17.1 is Mojave compatible.
I am using 17R3. (I need some 4D WP features).
Question: will there be an 17 R release that will be Mojave compatible or will 
I have to wait for v18?

Thanks

Mitch

Sent from my iPhone
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Write Pro-Creating Paragraphs

2019-02-11 Thread Mitchell Shiller via 4D_Tech
Hi,

Banging my head against the wall on this one.
Obviously a simple answer but it seems to be eluding me.

I want to programmatically create a series of paragraphs in WP,
Different paragraphs would have different attributes - e.g. font and margins 
etc.

I cannot find any examples in the KB or in the blog. Documentation seems a bit 
sparse on this.

Any hints?
Are there any example db’s out there?

Thanks

Mitch



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

CalDAV server from 4D

2019-01-04 Thread Mitchell Shiller via 4D_Tech
Hi,

For years I have generated read only .ics files from data in 4D. These were 
then stored on a share point on my OSX Server. Well, now Apple has removed 
almost all features from Server. (In fact, I have now installed it).  I would 
like to still serve up the .ics files so that they can be subscribed to on the 
desktops and iPhones,etc.

Anyone know how if and how that can be done on 4D Server? 

Thanks and happy new year to all.

Mitch

Sent from my iPad
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Write for v17

2018-12-15 Thread Mitchell Shiller via 4D_Tech
Steve,

That was my original question. Where do I get a v17 version of the old 4D Write 
to run in 32 bit mode? Must be having a brain cramp cause I don’t see it on the 
website.

Thanks

Mitch

Sent from my iPad
> 
> Message: 2
> Date: Sat, 15 Dec 2018 16:56:59 +
> From: UKVetDerm 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: 4D Write for v17
> Message-ID: 
> Content-Type: text/plain; charset="utf-8"
> 
> In the 32bit version of v17 you can use both old 4Dwrite (with v17 versions) 
> and Write Pro as long as you have the plug ins installed. However, the 32-bit 
> version is pretty painful speed wise with the new interface unless you use 
> the 64bit app - but it is fine for development.
> 
> We are currently using v17r2 server (64 bit) with 32 and 64 bit clients as 
> needed, with the hope of dropping the 32 bit clients as soon as I have got 
> everything just so.
> 
> HTH
> Steve (UKVD)
> 
> On 15/12/2018, 15:04, "4D_Tech on behalf of Mitchell Shiller via 4D_Tech" 
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
> 
> 
> 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Write for v17

2018-12-15 Thread Mitchell Shiller via 4D_Tech
Thanks.

I will have to some of the conversion in v16 and then some in v17.
My interface needs some of the newer features e.g. standard actions available 
in v17.
I was hoping to develop and test side by side in the same database.
I’ll open two versions.

Thanks.

> 
> Maybe 4D Write version 16 plugin will work with 32 bit 4D 17? Not sure, never 
> tried it. As long as you don't need to run 4D Write in version 17 (just need 
> to compile/load with the old code), you can create a 64 bit plugin stub that 
> just has the 4D Write resources. I can send you one if you need help on that.
> 
> John DeSoi, Ph.D.
> 
> 
>> 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

4D Write for v17

2018-12-14 Thread Mitchell Shiller via 4D_Tech
Hi,

In process of migrating from v16 32 bit to v17 64 bit all on Mac.
Converted my interpreted database, but can’t find a copy of 4D Write for v17. 
The v16 version won’t load in v 17.
I wanted to convert all my 4D Write to 4D WritePro in 32 bit. Once stable then 
jetison the old 4D Write and compile for 64 bit.

Any idea where I can find the plug in (It is not in the Mac complete 
installer)? Or do I have to do this in v16 first?

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D data on the web - what do you use?

2018-03-15 Thread Mitchell Shiller via 4D_Tech
For what is is worth, I had the complete opposite experience in Quebec.
(Remember that health care is a provincial mandate, so experience varies from 
province to province.)

In the last two years, Quebec overhauled the interface for payments for 
doctors, and those  services covered by pharmacists, dentists and optometrists.

They produced working papers. Have many well attended meetings with developers 
over several years. Encouraged beta test users and took feedback and actually 
incorporated it. The produced the final specifications. Roll out was over a 15 
month period. Developers had access to a test site to test their application. 
There was also a dedicated support team, that ( I can’t believe I am writing 
this) promptly responded to questions. I am a 2 bit player in this universe but 
got to know the support team by first name.

Their new system is robust, fast, and collects meaningful billing and service 
data compared to the last system. My doctors get paid quicker and billing is 
faster and more accurately captures what they do.

4D was the ideal environment for this with its full XML and SOAP library. Got 
help from the NUG too of course. I wrote the whole module in 1 month of part 
time coding.   ( I practice medicine the rest of the time). Again thanks to 4D.

So again, I can’t believe I am saying this but our government here in Quebec 
got it right. There are dozens of competitors out there still thriving.

Jody, I am so sorry to hear about your experience. ( highlights the worst 
aspect some governments have ). I met you many years ago at a Summit and you 
gave me many useful tips and ideas.

Mitch



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Intermittent server crashes

2018-02-08 Thread Mitchell Shiller via 4D_Tech
I believe I have a clue.

The last three crashes occurred overnight when new updates were available to be 
installed. i.e. I get the notification on the desktop from macOS that an update 
is ready.
The server ran fine for 7 days prior to that.

How do I report this to 4D?


Thanks
Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Intermittent 4D Server / System crashes

2018-02-01 Thread Mitchell Shiller via 4D_Tech
Thanks for the suggestions:

1) Upgrading to 16.3 HF1. I will do this but none of the reported bug fixes 
seems to address the problem.
2) This is a 32 bit application
2) Memory setting. Since this is 32 bit on OSX my understanding is that the 
memory allocation is fixed by the OS at around 2 GB. I usually just keep the 
default settings.
3) I have looked at the Console at Errors and Faults and there is nothing 
reported.

Plan.
I am going to run a non production clone of the server on a mac mini running 
10.11 and see if that works.
I will report back.

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Intermittent 4D Server / System crashes

2018-01-28 Thread Mitchell Shiller via 4D_Tech
Hi,

4D Server 16.2
Mac OS  10.13.2 running on a MacMini (Late 2014) 8GB RAM
External RAID 0+1 Samsung SSD. Using SoftRaid XT 

Only applications running are:
4D Server (no stored procedures), 15 users
Carbon Copy Cloner 5.05 (latest) scheduled to run every hour except from 22:00 
- 6:00 when there are no users logged in)
Retrospect Client (14.6.0.127 latest) (which backs up a second attached drive 
that contains the 4D backup files at 23:00)

I have been having  intermittent system crashes. These happen every 2-5 days.. 
Never when the system is in use. (8-21:00) Usually  early in the morning long 
after Retrospect has run. Retrospect Client takes about 15-30 to back up to our 
main Server. 
I get the spinning beach ball of death. So it is not just a 4D crash.  Nothing 
is responsive. The computer requires a hard reboot to get going again and then 
I am fine for 2-5 days.
Usually no users are logged in at the time.

In the console I get the following information from the most recent 2 crashes;

https://www.dropbox.com/sh/2xejz2dehwqf3wu/AADcablM2L7vzu8uLRxY0-Hxa?dl=0

I have tested the disk integrity, RAM integrity. All OK. I changed to a new 
computer with no change.
The previous computer was running 10.12
I contacted the SoftRaid support who downloaded  a crash report and stated that 
the crash is not happening with a disk access to the RAID system.


Any idea what the next step should be?

Thanks

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v14 and OS Sierra - Any real life issues

2017-06-15 Thread Mitchell Shiller via 4D_Tech
Hi,

The compatibility chart says “Compatible”  but not “Certified”. Any real life 
issues, show-stoppers, annoyances?

Both for Server and Developer.



TIA

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: PROCESS 4D TAGS [Solved]

2017-04-28 Thread Mitchell Shiller via 4D_Tech
Thanks Jim.

So based on your post, I tried it with Select Document and as you note it works.
Then I changed the path name to use the Folder Separator constant even though 
“:” (semi-colon) seemed to be working fine and voila, the code works.
Don’t know why but it works.

Mitch

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

re: PROCESS 4D TAGS

2017-04-28 Thread Mitchell Shiller via 4D_Tech
BTW the template is:

“ ”

Randy, I tried the compatibility option but that didn’t do it.

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

PROCESS 4D TAGS

2017-04-28 Thread Mitchell Shiller via 4D_Tech
v14 OSX

HTML Template:











Method:

C_TEXT(tHTML;tTemplate;$tPathname;tData)
$tPathname:=Get 4D folder(Current resources folder)+"Templates"+":"+"Test 
Template.html"
tTemplate:=Document to text($tPathname)
tData:="Hello There"
PROCESS 4D TAGS(tTemplate;tHTML)

Result:

The Template is loaded but tData is not replaced with “Hello There”. i.e. tHTML 
is the same as 


What am I missing?

Thanks

Mitch





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Preventing On Start Up from Running

2017-04-23 Thread Mitchell Shiller via 4D_Tech
Hi,

I accidentally inserted some recursive code in my Start Up procedure.
Now I when I open the database, I can’t get to the design environment.

I can’t remember how I prevent this form happening.
I know it has something to do with preferences… I think

TIA

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Clean Slate - Modern User Experience

2017-04-16 Thread Mitchell Shiller via 4D_Tech
As requested, I have posted a link to a folder with some samples:

https://www.dropbox.com/sh/3rhyxaaqok0in2m/AADJZmWfoRTpTDuoC08a951ra?dl=0

In it you will find;
1) The Spectrum palette I use for this project
2) The same palette ported to the OS Color Picker
3) Dialog - this is a basic detail form
4) List Form- this is my basic list form.
5) Detail Form - I have blocked out some of the detail in the subform - for 
privacy reasons.
6) Detail - Icons hidden - when you navigate to the first or last record the 
icons are hidden
7) Detail Form - Additional Panels - how I add additional functions to a detail 
view
8) List View - Extra Panels -  how I add additional functions to a list view

My toolbars  for both List and Detail view are always in blue.  
Ny toolbars are inherited Project Forms, with my code that automatically hides 
or show or adds additional icons / buttons depending on the data found in a 
configuration object that defines each process. The configuration object is 
stored in the Resources folder. All I do is configure the object, and launch a 
generic process which defines the type of process, data columns, fonts, 
buttons, etc.
The icons are 4 state.
My panels have  purple headers and white buttons. Icons are purple with a flat 
motif.
All of my labels  /headers are grey- visible but don’t attract attention. The 
data is what you want the user to focus on. Whenever possible I use 
placeholders.

Hope this helps

Mitch

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Clean Slate - Modern User Experience

2017-04-16 Thread Mitchell Shiller via 4D_Tech
Kirk,

I just re-did the UI of my application. 
Here are a few tips form my experience.

1) Start by picking a color palette of 4-6 colors. I use Spectrum- great app 
for selecting colors  based on their relationship- monochromatic, analogous, 
complementary etc.
Make a table and decide which colors you will use for which form elements- 
headers, buttons etc.

2) Google modern UI or Flat UI and look thru the images and choose a style that 
appeals to you.

3) For icons, I use Picons. Low cost, royalty-free icons. These work perfectly 
with Sketch. A great app for modifying the icons or creating 2 or 4 state icons.

4) The most important thing I learned about design was from Roland Lannuzel who 
co-wrote 4D Write Pro. He stressed that in good design, “Less is best”.  I went 
through all of my forms and removed divider lines, boxes. etc.  The result is 
easier to design, build etc. I was shocked about what I removed. No more sunken 
effect. No borders around list boxes. 

5) I define a grid ahead of time and decide the size of all elements. e.g. 20 
pixels blank border for all elements from the side of the window. 10 pixels 
between groups of data.  All buttons are 100 pixel wide unless absolutely 
necessary.  I have rules for how I align elements, so that each page looks very 
similar.

6) On a personal not I like to have white text on a colored background for 
headers. I like the various elements of form to look like they “float” on the 
page. No defined border.

If you would like I can send you some sample pages to better understand what I 
am saying.

Mitch
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: PDF's

2017-04-16 Thread Mitchell Shiller via 4D_Tech
You can use Miyako’s pdf plugin to do basic pdf manipulation.

For instance we receive our faxes as pdf’s from an e-fax service.
In our application, we create thumbnails of the various pages. The staff can 
then chose to delete pages (i.e. the cover page) or group pages together as a 
single pdf.
All done with his plugin at the the wonderful price of free.

Mitch



**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Question about storing data outside of datafile

2017-02-16 Thread Mitchell Shiller via 4D_Tech
Kirk,

Not sure this will help in your situation but this is what we do. This applies 
to OSX only.

I store all documents (hundreds of thousands) in their native format outside 
the data file in a directory on the same drive as the 4D datafile. I store the 
files by client / patient in their own folder with several subfolders. I use 
Execute on Server to retrieve / save the documents.  I store all the relevant 
metadata including the relative path of the document in the 4D datafile. I like 
to keep the 4D datafile as small as reasonable. e.g. for repairs etc.

Now for the backup, I have a separate RAID drive attached to the 4D Server. I 
use Carbon Copy Cloner to clone the documents folder every 15 minutes. At 
night, the 4D Server runs the backup to a separate directory on this second 
drive.

Once the 4D backup is complete, I use Retrospect to backup encrypted to a 
removable drive that goes offsite and to the cloud.

Just another option.

Mitch

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**