RE: Duplicate data in Key Field

[Timothy Penner via 4D_Tech]

How did you add the UUID primary key?

When you added the UUID field, did you use SQL, and if so, did you use the 
TRAILING keyword as shown here:
http://kb.4d.com/assetid=76991

-Tim





**
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
**

Duplicate data in Key Field

[Robert McKeever via 4D_Tech]

I’m converting an old database for a client from 4D 2003 to 4D v16. Quite the 
leap.

I’ve run the procedure to add Primary Key UUID’s to all tables.

Now some tables have duplicate data in the UUID field. They have never used the 
log file, so I could just skip them, but I’d rather not.  How does one fix the 
problem? I suppose I could loop thru the tables, then loop through the records 
and, for each table, load the UUID with the record number.

Long ago, when we converted JPEG’s into DICOM images (you just wrap the JPEG 
with the relevant patient data) and then sent them to a real PACS system, we 
were assigned a UUID prefix by the  assigning authority here in Canada. Free, 
as I recall. Costs a bunch in the US. Maybe I should find our old prefix so 
they are real ‘UUIDs’.

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.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
**

RE: Sending PDFs to Chrome

[Timothy Penner via 4D_Tech]

More locally to the developer, it looks like there should also be a list of 
mime types (in XML format) stored within the application:

"Note: The list of MIME types supported by the 4D HTTP server is saved in the 
"MimeTypes.xml" file found in the following folder of the 4D application: 
[Contents]\Native components\HTTPServer.bundle\Contents\Resources."

-Tim



**
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: Sending PDFs to Chrome

[Timothy Penner via 4D_Tech]

> I just want to note that SEND HTML BLOB in tech note is now WEB SEND BLOB.

That is correct, the command was renamed in v13.

I should also note that the documentation for WEB SEND BLOB lists a bunch of 
known mime types as well:
http://livedoc.4d.com/4Dv17/help/Command/en/page654.html

Kind Regards,

Tim PENNER



**
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: Sending PDFs to Chrome

[Andrew R Diaz via 4D_Tech]

Nice - Thanks Tim.

I just want to note that SEND HTML BLOB in tech note is now WEB SEND BLOB.

--

> On Aug 30, 2018, at 1:04 PM, Timothy Penner  wrote:
> 
> This may be helpful also:
> 
> Tech Tip: How to send non-html files using SEND HTML BLOB
> PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
> Published On: July 16, 2009
> http://kb.4d.com/assetid=75828
> 
> 
> 
> Timothy Penner
> Senior Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
> 
> Téléphone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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
**

RE: Sending PDFs to Chrome

[Timothy Penner via 4D_Tech]

This may be helpful also:

Tech Tip: How to send non-html files using SEND HTML BLOB
PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
Published On: July 16, 2009
http://kb.4d.com/assetid=75828




**
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
**

Sending PDFs to Chrome

[Andrew R Diaz via 4D_Tech]

Hi All,

Just throwing this out there in case you ever come across this one. Using the 
command

WEB SEND BLOB(BLOB_File;”pdf”)

Works on most browsers but Chrome will give the error:

Failed to load pdf document

After searching the web for a while I found the fix. Change the call to: 

WEB SEND BLOB(BLOB_File;”application/pdf”)

and now Chrome will load it correctly.

Hope this helps anyone working on the web and battling these weird browser 
differences.

Andrew

--



**
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 Pro WP feature request - need your support

[Tim Nevels via 4D_Tech]

On Aug 30, 2018, at 2:00 PM, Luc Devar wrote:

> I certainly hope we can open/save .docx document with 4D Write Pro in a near 
> future as this is mandatory for me also.  I have an application install on 
> several sites that write contracts from clauses stored in a 4D DB and I need 
> to use 4D write and compatibility with MSWord is a must.  Right now being 
> compatible with .doc document only is already a problem.  

The 4D people say that we should go vote for feature requests and that they 
really do listen.

So let’s all go do that. Go to 4D Forums and vote 4 stars on every post by 
every person in “Feature Requests” that wants 4D Write Pro to be able to 
import/export to Word. There are many. I just did and it only took a couple of 
minutes to click the 4 stars for each post.

Here is what you do:

Log into forums.4d.com
Click on “Feature requests” in the “Public forums” area
In the “Search” area type in “4D Write Pro” and hit return
On the first page that is displayed you will see 8 threads on this topic
Open each thread and for every single post in that thread click the 4 stars in 
“Your rate”

You just voted for the feature request, multiple times.

Maybe if 10 or more people here on the iNUG go do this it will add up and make 
somebody notice and say “hmm… this appears to be a feature people want. We 
should add that in the next version.”

I love Paul Dennis response: "This is so obvious it shouldn't even be a 
request.”

I have to agree. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Re: Emoticons, Emoji, put pictures into eve

[Jim Crate via 4D_Tech]

On Aug 30, 2018, at 9:23 AM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> Jim Crate via 4D_Tech wrote:
> 
>> editor, it doesn't actually work that way and turns into ?? when you
>> close the method editor. So I found this email to the list from a few
>> years ago, but the ftp link no longer works. This should be supported
>> natively by now (maybe in v17?) but could anyone send me this emoji method?
> 
> I have that DB. Do you still need it?

JPR sent it, although I may not need it since Keisuke Miyako let me know about 
the unicode methods setting.

Thanks everyone!

Jim Crate

**
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: Emoticons, Emoji, put pictures into eve

[Jim Crate via 4D_Tech]

On Aug 29, 2018, at 6:17 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
wrote:
> 
> sounds like your compatibility settings does not allow methods to be stored 
> in unicode.
> 
> emoticons are internally 2 or 4 combining characters which explains the 
> number of question marks

That fixed it, turning on unicode methods allows an emoji to just be pasted 
into a string literal. The listbox displays it nicely too.

Thanks!

Jim

**
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 Pro WP feature request - need your support

[Luc Devar via 4D_Tech]

I certainly hope we can open/save .docx document with 4D Write Pro in a near 
future as this is mandatory for me also.  I have an application install on 
several sites that write contracts from clauses stored in a 4D DB and I need to 
use 4D write and compatibility with MSWord is a must.  Right now being 
compatible with .doc document only is already a problem.  

Luc Devar

> On Aug 29, 2018, at 2:34 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> .doc is probably an issue as it is a proprietary format from MS.
> .docx might not be such an issue as it is "open" and is supposed to be 
> based on xml.
> 

**
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: Roy (Suzi) McGregor Paterson R.I.P

[Tom Dillon via 4D_Tech]

Sad news indeed. I met Roy at the Vancouver Summit where he convinced a few of 
us to take a plane ride on a de Havilland Otter to Vancouver Island. He grinned 
like a kid having ice cream for the first time.

My condolences to her friends and family.

-- 
   --
   Tom Dillon  375 S Main St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
   Wine is always best when shared, 
   even if it's just with yourself. --- Sunastar
   --


**
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: Emoticons, Emoji, put pictures into eve

[Tom Dillon via 4D_Tech]

Jim Crate via 4D_Tech wrote:

>editor, it doesn't actually work that way and turns into ?? when you
>close the method editor. So I found this email to the list from a few
>years ago, but the ftp link no longer works. This should be supported
>natively by now (maybe in v17?) but could anyone send me this emoji method?

I have that DB. Do you still need it?

-- 
   --
   Tom Dillon  375 S Main St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
  The butterfly will only land on you after you stop
  grabbing for it. --- Sunastar
   --


**
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: Re(2): 4D Write Pro WP feature request - need your support

[Chip Scheide via 4D_Tech]

login
On Wed, 29 Aug 2018 15:49:26 -0700, Don Lapin via 4D_Tech wrote:
> I would suggest keeping the pressure on them. They've gone every 
> which-way about promising 4D Write Pro features. As it has been 
> delivered, it is unusable. I've the same issue with Word 
> compatibility.
> 
> When I click on the link from the original poster, I get into a list 
> of forums, not the request. What's the problem -- login?
> 
> Thanks,
> Don
> 
>> On Aug 29, 2018, at 3:12 PM, Chuck Miller wrote:
>> 
>>> I also have one client that is a huge 4d write user. We also need to
>> have ability to convert to Microsoft word. Additionally, there are some
>> things we do not seem to be able to do in write pro so for now, we will
>> be maintain 4d write licenses across multiple servers and standalone
>> dos. At the last Summit many spoke of this issue and 4D stated that they
>> were going to implement export to word and not rtf.
>> 
>> That's fantastic news! Glad to hear support for Word is coming. 
>> 
>> Tim
>> 
>> *
>> Tim Nevels
>> Innovative Solutions
>> 785-749-3444
>> timnev...@mac.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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: How to tie 4D to barcode readers?

[Tony Pollard via 4D_Tech]

Hi Kirk and Steve,

Kirk:  You can usually programme prefix codes to the readers so that you can 
identify the reader (if there are several connected).  If there is a “context” 
needed for the bar code scanning then we either use a card of custom bar codes, 
or there are “location" codes.  You can also get the scanner to provide info on 
what kind of code it is, which can help in 4D in decoding the context.  In the 
case of a warehouse there are custom barcodes for the shelves and boxes (to 
keep track of where things are).  I don’t use wedge input.

Steve:  The IP-based wireless scanners sound good!  Which ones are you using?

Cheers!

Tony

Tony Pollard
Another Dimension Ltd



> On 29 Aug 2018, at 2:09 am, Stephen J. Orth via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Kirk & Tony,
> 
> We do lots of bar coding systems every year using wedge-readers (keyboard 
> input), RS-232 wireless, and IP-based wireless.  Going forward we are no 
> longer doing RS-232 scanners as it is simply too much work for both us and 
> our clients.
> 
> If a wedge-reader is the right tool, we use this first, otherwise all our 
> projects are now IP-based scanners which are basically browsers.  Our 
> communication is via web services, which are very, very fast to develop and 
> provide very fast network communication.  The scanner displays on these units 
> are small so generating HTML pages for this is really quite trivial.  We have 
> also done a number of IP-based tablets and all of what I said is also true 
> here.
> 
> Best,
> 
> 
> Steve
> 
> *
>  Stephen J. Orth
>  The Aquila Group, Inc. Office:  (608) 834-9213
>  P.O. Box 690   Mobile:  (608) 347-6447
>  Sun Prairie, WI 53590
> 
>  E-Mail:  s.o...@the-aquila-group.com
> *
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks 
> via 4D_Tech
> Sent: Tuesday, August 28, 2018 6:56 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Kirk Brooks 
> Subject: Re: How to tie 4D to barcode readers?
> 
> Tony,
> How are you handling programming the barcode reader to include information
> about what the barcode belongs to? Or are you using it as an extended
> keyboard input?
> 
> On Tue, Aug 28, 2018 at 4:19 PM Tony Pollard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> If you want the bar code scanning to be independent of where the user is
>> on the UI, then there is usually a serial port emulation available on USB.
>> GET SERIAL PORT MAPPING is useful for this on Mac.  You can then run
>> serial comms in a separate process, which is handy if (for instance) the
>> bar code readers are RF and being used at a distance from the computer
>> (which also lets you run multiple scanners per computer).  Or I’d guess
>> that there must be some IP wifi based bar code scanners out there by now,
>> so you could (presumably) simply do a TCP_Open.
>> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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
**

Re: 4D Write to 4D Write Pro

[Bernd Fröhlich via 4D_Tech]

Tim Nevels:

> The only legacy support they promised to provide is to convert legacy 4D 
> Write documents. 

And even that does have it´s problems: Line spacing is not preserved.
So if you have e.g. a 6 page 4DWrite document it is 8 pages after the 
conversion :-/

> But I have a crazy idea… 
> 
> What if someone created a 4D component that had the major 4D Write Plugin 
> commands with all the same parameters but as 4D component methods. And each 
> method accomplished the same results as the plugin command.

Would be an instant buy over here.

Greetings from Germany,
Bernd Fröhlich
**
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
**