Re: Import from Excel

Thanks /Ferdinando/ Il 07/03/2018 18:15, Timothy Penner ha scritto: I am not sure if it still works, but there is this tech note available: Tech Note: PHPExcel Library with 4D v12 Published On: April 15, 2011 http://kb.4d.com/assetid=76312 -Tim PENNER Timothy Penner Senior Technical

Re: Import from Excel

Another vote for Pluggers Excel plugin. https://www.pluggers.nl/product/xl-plugin/ You will not regret it for creating and reading excel files it is simply the best, just as you would expect from Pluggers. For my usage it has paid for itself over

RE: Import from Excel

Ferdinando , If you convert the Excel file to csv, you shouldn't have any problems with cells containing carriage returns/line feeds when you import into 4D. I assume 4D’s built-in import can handle csv files - I haven’t checked - we use special import and export code to handle csv so we don’t

Installing New SSL Certificate

Hi there, I hope this is the correct mailing list to ask this question... I am trying to install a new SSL certificate for our 4D hosted web site and I keep getting the following error; included below. Has anyone else experience this? I will followup with details if anyone thinks they may

Re: Installing New SSL Certificate

Yes Tim! This is exactly the issue I was facing.  I managed to figure it out, not that gracefully but this would have saved me time.  I appreciate your help! Sandor From: Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Timothy

Re: What's the easiest way to edit an existing constants file?

the constants XLF format is briefly explained in the v13 upgrade manual. http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_13/VIntl/PDF_Format/4D_v13_Upgrade.pdf page 236 what is not mentioned, which I found to be quite important, is to assign a unique id for each group

Re: Find and Replace Component for 4D Write Pro

Pat Bensky found a bug with the "replace all" in certain circumstances. I posted a fix to the same link: http://www.successware.net/downloads/4d-components/FindAndReplace.zip Thanks Pat! -- Jeff Grann

Re: Installing New SSL Certificate

So of course I got this working right after I sent this email... For anyone that is curious, when testing the new certificate I simply renamed the old certificate with a '~' prefix, leaving in its current directory.  Well, 4D didn't like this.  It was still seeing the cert and key files. 

What's the easiest way to edit an existing constants file?

Hi All, I found the 4DPop_Constant_Editor for creating a new constants file. How do I edit one that already exists? I'd rather not use a text editor. (I looked at a custom constants .xlf file and the syntax did not seem overly obvious to me.) dave -- David Nasralla Clean Air Engineering

Re: Import from Excel

When exporting to csv from Excel, the cells that contain commas, double quotes and/or carriage returns will be wrapped by double quotes. The routine that is used to import csv file should be paying attention to the surrounding quotes and handling embedded returns. Any internal double quotes are

Re: Import from Excel

F.Y.I. I've posted a "Match regex" solution to process CSV (read and write). quotes, carriage returns, missing columns and other perks are handled. https://github.com/miyako/4d-component-csv in general, it is easier if you could use TSV instead of CSV, as the format is more compatible with the

RE: Installing New SSL Certificate

Maybe this tech tip will help? Tech Tip: Be careful which files you store as PEM next to the structure http://kb.4d.com/assetid=77137 -Tim ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Find and Replace Component for 4D Write Pro

On 8 Mar 2018, at 1:46 am, Jeff Grann via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I had the need to add find and replace to my 4D Write Pro areas. So I created > a generic component. It easily shows and hides itself at the top of a Write > Pro area and can resize itself automatically. You can

Re: Import from Excel

Pat, As I understand it, in a cvs file, all string values should be enclosed inside “. This means that a CR is simply part of the cell’s string. If you open the exported file with a text editor, you should see the CR enclosed inside “. If it isn’t, the Excel export is not working correctly. If

RE: Import from Excel

I am not sure if it still works, but there is this tech note available: Tech Note: PHPExcel Library with 4D v12 Published On: April 15, 2011 http://kb.4d.com/assetid=76312 -Tim PENNER ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Find and Replace Component for 4D Write Pro

Hey Jeff, Simple! Cool UI trick as well. Works with v16R4 as well. Thanks much, John… > I had the need to add find and replace to my 4D Write Pro areas. So I created > a generic component. It easily shows and hides itself at the top of a Write > Pro area and can resize itself

Re: Import from Excel

Hi Ferdinando, Export from Excel to text file (comma delimited, tab delimited). And then use the 4D import tool or write your own code (receive packet,…) HTH Koen > Op 7 mrt. 2018, om 11:06 heeft stardata.info via 4D_Tech > <4d_tech@lists.4d.com> het volgende geschreven: > > I use 4D V15 or

Import from Excel

Hi all, I use 4D V15 or V16 someone know how i can to import from excel? Thanks Ferdinando ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: Import from Excel

We use Pluggers Excel plugin - works really well for both importing and creating Excel documents: https://www.pluggers.nl/product/xl-plugin/ The problem with exporting form Excel to a text file is if any of the cells contain return or line feed characters, that will mess everything up as 4D will

RE: Import from Excel

Hi Ferdinando, I second Pat Bensky's suggestions of Rob Laveaux's Pluggers EXCEL Plugin. http://www.pluggers.nl/product/xl-plugin There is a reasonable cost for this plugin, but it provides serious capabilities to work with Excel files. This is what we use exclusively. As well there are some

Find and Replace Component for 4D Write Pro

I had the need to add find and replace to my 4D Write Pro areas. So I created a generic component. It easily shows and hides itself at the top of a Write Pro area and can resize itself automatically. You can download it and a demo at:

RE: MailJet

Pat, That’s why Amazon Web Services, Simple Email Solution works! It’s fast, reliable, and allows sending 50K emails a day, or more if you need. And it’s $0.10/1000 emails. David Ringsmuth From: Pat Bensky via 4D_Tech Sent: Wednesday, March 7, 2018 10:12 AM To: 4D iNug Technical Cc: Pat

Re: Import from Excel

No need to export. Save as a text file and you can import that Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Import from Excel

If you are using Numbers on a Mac, there is no way to export to a tab delimited text file, only CSV. Many have complained, but Apple does not listen. The work around is to select the content to be exported in Numbers and copy it to the clipboard. Then past into a plain text TextEdit document.

Re: MailJet

One reason to use a mailing service instead of 4D is - as I recently discovered - if you send a large number of emails in a batch (let's say more than 500) your service provider is likely to block them, as it may appear that your account has been hijacked by a spammer. I'm not familiar with