Re: Import from Excel

2018-03-07 Thread Keith Goebel via 4D_Tech
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: What's the easiest way to edit an existing constants file?

2018-03-07 Thread Keisuke Miyako via 4D_Tech
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: Import from Excel

2018-03-07 Thread Keisuke Miyako via 4D_Tech
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: Find and Replace Component for 4D Write Pro

2018-03-07 Thread Justin Carr via 4D_Tech
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

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

2018-03-07 Thread Dave Nasralla via 4D_Tech
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: Installing New SSL Certificate

2018-03-07 Thread Sandor Szatmari via 4D_Tech
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: Installing New SSL Certificate

2018-03-07 Thread Sandor Szatmari via 4D_Tech
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. 

RE: Installing New SSL Certificate

2018-03-07 Thread Timothy Penner via 4D_Tech
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:

Installing New SSL Certificate

2018-03-07 Thread Sandor Szatmari via 4D_Tech
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: Import from Excel

2018-03-07 Thread Dani Beaubien via 4D_Tech
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: Find and Replace Component for 4D Write Pro

2018-03-07 Thread Jeff Grann via 4D_Tech
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: Import from Excel

2018-03-07 Thread Keith Goebel via 4D_Tech
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

Re: Import from Excel

2018-03-07 Thread stardata.info via 4D_Tech
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

2018-03-07 Thread Douglas Cryer via 4D_Tech
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: Find and Replace Component for 4D Write Pro

2018-03-07 Thread truegold via 4D_Tech
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

2018-03-07 Thread Timothy Penner via 4D_Tech
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: Import from Excel

2018-03-07 Thread John Baughman via 4D_Tech
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: Import from Excel

2018-03-07 Thread Chuck Miller via 4D_Tech
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: MailJet

2018-03-07 Thread David Ringsmuth via 4D_Tech
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: MailJet

2018-03-07 Thread Pat Bensky via 4D_Tech
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

Find and Replace Component for 4D Write Pro

2018-03-07 Thread Jeff Grann via 4D_Tech
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: Import from Excel

2018-03-07 Thread Randy Engle via 4D_Tech
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

Re: Import from Excel

2018-03-07 Thread Pat Bensky via 4D_Tech
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

2018-03-07 Thread Koen Van Hooreweghe via 4D_Tech
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

2018-03-07 Thread stardata.info via 4D_Tech
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: