Printing Excel Document to PDF from 4D - Windows

Hi All, system: 4D v16, All Windows Client/Server From within 4D, programmatically I need to grab an existing Excel document and print it to PDF… (or “magically" transform it to PDF, if that option is available.) We create Excel documents from 4D using Rob Laveaux’s powerful XL Plugin. We

Re: Automatic Excel to Text-tab delimited? - Code Sample

Thanks Randy and everyone else who chimed in so quickly I have ordered Rob’s plugin. (I have heard good thing about this plugin for years…) Sounds like the best solution. Best to all & happy holidays! Kirk > On Dec 12, 2019, at 3:54 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> >

Automatic Excel to Text-tab delimited?

Hi 4D folks, (Environment: All Windows, 4D server/client 16R4) Just curious if anyone has found a way to automatically transform Excel documents to text-tab delimited documents? The issue I am attempting to solved: We have several system which produce document that need to be imported into a

Re: Selection Based ListBox - How do I extract and apply values to a single cell?

I now get selection based ListBoxes… Thanks for your help!! Kirk > On Nov 12, 2019, at 9:09 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> >> Hi, >> schematically, I do this: >> save selection >> // use userset > > use listbox selected set > maybe simpler > apply to

Re: Selection Based ListBox - How do I extract and apply values to a single cell?

t; about selection based listboxes is only useful if you are working on an old > project that requires them. > > On Tue, Nov 12, 2019 at 12:22 AM rooftop99--- via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Hi All >> >> I feel like a rookie, but h

Selection Based ListBox - How do I extract and apply values to a single cell?

Hi All I feel like a rookie, but here is the deal... I have used array Listboxes many times with success. A current project requires the use of a Selection based listbox. How do I execute Cell level logic? For example: Let’s say I want to create a simple “fill down" function. The user

Re: ListBox - Possible to set choice list programmatically?

/4Dv16/4D/16.6/OBJECT-SET-LIST-BY-REFERENCE.301-4445040.en.html > > there was a trick to refresh the list but I can't find the article (forums) > right now > > 2019/11/11 17:43、rooftop99--- via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:

Re: ListBox - Possible to set choice list programmatically?

ay and release a > menu using the menu commands. > > Building even fairly complex menus is amazingly fast. It's easy to write a > method to build and display the menu then return the result to the calling > method. > > > On Mon, Nov 11, 2019 at 12:43 AM rooftop99--- via

ListBox - Possible to set choice list programmatically?

Hi All, When creating a ListBox in the 4D form editor it is possible to select a single column and then set attributes for Choice List, Required List, and Excluded list. This creates drop-down menus in each cell of that column. When creating a Listbox column programmatically I don’t see a

Re: 4D Websites (Are they down?)

The 4D site is working for me as of 9:00 Pacific Time > On Oct 20, 2019, at 8:28 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I haven’t had any luck connecting to 4D.com all weekend. > > Tom Benedict > >> On Oct 20, 2019, at 10:41, Jeremy French via 4D_Tech

4D Application Window off screen when moving from multi to single monitor environment

Hi All, (OS=Windows 10, VMware Virtual Desktop, 4D v16R4, Client/Server) We have discovered a problem where the 4D login window is hidden (off screen) when switching between computers as follows: - Log into a computer with three screens. Log into VMware virtual desktop and launch 4D.

Re: Matt Davis

Hi Steve, I chatted with Matt a few weeks ago. He is doing well, and recently welcomed a baby into his family. So he is around, but perhaps distracted…grin. Kirk > On Sep 10, 2019, at 12:55 PM, Stephen J. Orth via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I've been trying to reach Matt

Re: 4D eMail Editor - full HTML support

Thanks to all who have offered suggestions. Super helpful! The biggest challenge I face is the spec calls for composing the email in Outlook first, then copying and pasting the final version into 4D with full preview and edit capability. None of my tests have proved this is possible. (There

4D eMail Editor - full HTML support

HI All, Environment: All Windows OS, 4D v16R4 Server/Client (Headed to v17 64bit soon…) Our marketing department is creating eMails in Outlook which included images, hyperlinks (text and image), backgrounds, etc. We would like to take these emails and copy the body content into a field in

Re: Printing structures

Very, very cool! Thanks for sharing, Alexander!! > On May 8, 2019, at 9:42 AM, Herr Alexander Heintz via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi folks, > > been a while, i know… > needed something to print structures in a moderately configurable way. > May have gone a bit overboard

Re: Printing Structure Diagram

Thank you Chip, I am aware of the xml and html exports. I have used the xml export for several purposes. My question is, how do I get the printed visual structure digram I need using either of these. Surely there are database schema [structure] diagram printing applications out there

Printing Structure Diagram

Hi All, We are in the midst of analyzing a very old 4D application. We’d like to print/plot/PDF a structure diagram, in all it’s glory, to hang on the wall. It must represent all structure elements such as Tables, Fields, Relations, Indexes, etc…. I have seen these diagrams for other

Re: 4D Developer Available

Having worked with Tom at Free & Clear and Optum for nearly six years I want to add my support. He is an exceptionally talented 4D Dev (plus much more). Anyone needing 4D development could not go wrong hiring this man… Best of luck in your search, Tom. Kirk Call Director of Software

Re: Printing an existing PDF file with 4D silently.

Thanks Matt! I have been testing command-line printing with Launch External Process. It holds some promise… Thanks for the additional details on the process. I look forward to the webinar session March 13th on your WebSockets component. I have seen enough of your work to know it will be

Printing an existing PDF file with 4D silently.

Hi All, We have a need to send existing PDF documents to print (paper) without a user’s input. Programmatically we would select the appropriate PDF, set the appropriate printer, and print. Is anyone doing this via 4D with success? Would you be willing to share your technique? Thanks, Kirk

Re: Display limit of 32K but save much more... Text Fields

d on > the window. > same with paste. > you could say that a text input area is a window to the text that resides in > memory. > >> 2018/08/24 11:15、rooftop99--- via 4D_Tech <4d_tech@lists.4d.com>のメール: >> >> Is this normal or some residue of the applicatio

Display limit of 32K but save much more... Text Fields

Hi All, (4D Client/Server, All Windows environment, 4D v16R5) We have a 20 yr old application currently running under 4D v16R5. It has obviously been converted several times over the years. One behavior I noticed this week that seems odd is: Text Fields are truncated at 32k in the UI. They

Re: 4D Server Fail When Converting from v15.2 to v16R5

working with Microsoft on this. You might open a tech support > case so your voice can be added to ours. > > -- > Jeffrey Kain > jeffrey.k...@gmail.com > > > > >> On Apr 12, 2018, at 12:30 PM, rooftop99--- via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >&

4D Server Fail When Converting from v15.2 to v16R5

Hi All, (OS-Windows Server 2012, 24 GB Ram, or 64GB Ram on second test machine) We are moving a large (90GB) database from v15.2 to v16R5. When converting the application the server eventually grinds to a halt, becomes non responsive, and requires a reboot. I attempted this on two different

Re: 4D Summit 2018 Comments

As one not able to attend the Summit this year - Thank You Tim! Excellent information, easy read. Kirk > On Apr 9, 2018, at 7:06 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I got back from 4D Summit 2018 in Washington DC and thought I’d post a few of > my thoughts and

Re: Print to MS Word Document

Thank you Dan and Keisuke! Helpful!! > On Feb 22, 2018, at 9:25 AM, Dan Gallagher via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Kirk, > > We use process tags to generate an xml document that is packaged in a .docx > file. It is time consuming creating the document templates, but it works >

Print to MS Word Document

Hi All, Our System: 4D v15 Client/Server - all Windows OS... Printing to a PDF document has been around for a while. We now need to print to a MS Word document… Do any of you have a proven method for doing this from 4D? Thanks!! Kirk

Query Editor Date format not available...+

Hi All, When searching on a date field we are having issues with the standard Query Editor in 4D v15.3, Client-Server. The serve and clients rare all running on the Windows OS. Anyone else see the following behavior and have a fix? 1). We pick a date field, then choose the “is" operator, and

Counting occurrences of specific characters In a document

Hi All, The need: To know how many rows are in an Excel or Text file. Overview: We are working with large Excel documents which contain upwards of 750K rows and we need to import each row into a 4D application to create records. In advance of the import process I would like to know how

Mouse Over Events in a standard 4D Output form... ToolTips?

Hi All, Version: 4D v15.2, Windows, Client/Server I would like to create a record specific “ToolTips” display on a standard 4D output form. This is without a click on any records. The desired end user behavior is: User mouses over a particular object in one of the rows of an output form.

Re: Data mining from Oracle Application using 4D

Thank you Bruno, I will contact you direct for more information about your component. Is it compatible with v16.R2 Windows Server/Client? Kirk > On Jun 1, 2017, at 10:24 PM, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> >

Data mining from Oracle Application using 4D

Hi All, I have a large Oracle database from which I need to regularly extract specific data using a 4D application. Is there a preferred way to connect the two for data mining? ODBC, or ??? Anyone doing this with success and willing to share the connection architecture? Many thanks in

Re: Clean Slate - Modern User Experience

Thank you Mitch. Very helpful!! I would love to see some sample pages... Best! Kirk > On Apr 16, 2017, at 12:54 PM, Mitchell Shiller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Kirk, > > I just re-did the UI of my application. > Here are a few tips form my experience. > > 1) Start

Clean Slate - Modern User Experience.

Hi All, After years of working with large legacy systems where their roots were based in 4D v3 or earlier, I am faced with a rare opportunity to create a substantial application - ground up. I would like the end product to have a modern UI. It is a multi-user system. I plan to use a

Problem accessing 4D via ODBC and Excel Power Query

Hi All, (All Windows, 4D server v15.2, 32 bit Excel and 4D ODBC driver) We use Excel to access data in our 4D database via ODBC. Works great, except when we try and use the Excel add-in Power Query. It generates a connection error: Unable to Connect We encountered an error while trying to

Re: Strategy to allow one user to drop another from the server...

Execute on Client, of course!! Thanks Chip, Chuck, and Timothy! > On Mar 6, 2017, at 2:45 PM, Timothy Penner wrote: > > Calling QUIT 4D with EXECUTE ON CLIENT with a uniquely named/registered > client has already been mentioned (twice), that's probably what you need. > Here

Strategy to allow one user to drop another from the server...

Hi, In a large client/server install we are implementing a function to allow one user (client) to drop another from the server. It seems that regardless of how much training is given, inevitably someone during the day walks away from their computer (lunch, etc.) with a record opened.