Re: Import from Excel

[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 it is enclosed, I would be looking at the code doing the import - it is not 
working correctly.
Cheers, Keith

> Keith - if you export from Excel to csv, you still have the problem with
> embedded Return characters.

>> Sometimes an Excel csv export doesn’t comply completely with the cvs
>> rules, but mostly it does.

**
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: What's the easiest way to edit an existing constants file?

[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 and constant.

personally I like to use a UUID for each group and gives its members a decimal 
suffix.

this helps the constants to appear by group on the Explorer.

e.g.

  

  YOUR CONSTANT GROUP NAME

  

  

  A CONSTANT THAT BELONGS TO THE GROUP

  

2018/03/08 8:31、Dave Nasralla via 4D_Tech 
<4d_tech@lists.4d.com> のメール：

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.)



**
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: Import from Excel

[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 standard 4D dialogs,
except for vertical tabs (which corresponds to in-cell carriage returns).

I am surprised to hear that Numbers does not export TSV,
as far as I know, it does import and display TSV properly, even vertical tabs.



**
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: Find and Replace Component for 4D Write Pro

[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 download it and a demo 
> at:
> 
> http://www.successware.net/downloads/4d-components/FindAndReplace.zip

Very elegant piece of work, Jeff. Thanks for sharing!

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

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

[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
**
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: Installing New SSL Certificate

[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 Penner  
 Sent:   3/7/2018 6:18 PM 
 Subject:   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:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.
**
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: Installing New SSL Certificate

[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.  Simply 
moving the files out of the current directory was enough to let 4D load the SSL 
cert correctly.

Cheers, 
Sandor



Subject:   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 have insight into my 
dilemma.


Thanks in advance!




Error




Failed to set SSL certificate




Error code: 46

Failed to set SSL certificate

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'

--


Regards,
Sandor


CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.
**
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
**

CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.
**
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: Installing New SSL Certificate

[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:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Installing New SSL Certificate

[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 have insight into my 
dilemma.


Thanks in advance!




Error




Failed to set SSL certificate




Error code: 46

Failed to set SSL certificate

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'




Error code: 49

SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line

component: 'srvr'

task -1, name: 'User Interface'

--


Regards,
Sandor


CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.
**
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: Import from Excel

[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 escaped as double 
double quotes (pulling that from memory).

The following is a sample of a 3 row csv file exported from Excel.:
ROW 1,a,b,c
ROW2, 1,"2
3",4
ROW 3,d,e,f

Them 3rd cell in ROW 2 has a carriage return between the 2 and 3.

It is more of a challenge to import CSV because you can’t assume that the EOL 
character is truly the EOL. It might be embedded within a cell. if you are 
using CSV files you need to be able to handle this scenario.

Hopefully that helps a bit.

Dani


> On Mar 7, 2018, at 2:20 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Keith - if you export from Excel to csv, you still have the problem with
> embedded Return characters.
> 
> Pat
> 
> 
> On 7 March 2018 at 20:48, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> 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 use 4D’s
>> built-in stuff.
>> 
>> Sometimes an Excel csv export doesn’t comply completely with the cvs
>> rules, but mostly it does.
>> HTH, Keith
>> **
>> 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
>> **
>> 
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **

**
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: Find and Replace Component for 4D Write Pro

[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
SuccessWare, Inc.

> On Mar 7, 2018, at 10:46 AM, Jeff Grann  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 download it and a demo 
> at:
> 
> http://www.successware.net/downloads/4d-components/FindAndReplace.zip 
> 
> 
> It requires 4D v16R5. You are free to use and modify it in any way you wish. 
> See the accompanying MIT license.
> 
> Hope this saves someone else some time and effort. :-)
> 
> --
> Jeff Grann
> SuccessWare, Inc.
> 

**
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: Import from Excel

[Pat Bensky via 4D_Tech]

Keith - if you export from Excel to csv, you still have the problem with
embedded Return characters.

Pat


On 7 March 2018 at 20:48, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> 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 use 4D’s
> built-in stuff.
>
> Sometimes an Excel csv export doesn’t comply completely with the cvs
> rules, but mostly it does.
> HTH, Keith
> **
> 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
> **
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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: Import from Excel

[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 use 4D’s built-in 
stuff.

Sometimes an Excel csv export doesn’t comply completely with the cvs rules, but 
mostly it does.
HTH, Keith
**
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: Import from Excel

[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 Services Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Telephone : +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)
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: Import from Excel

[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 and over and just keeps giving…

Regards, Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com   Web : 
http://www.telekinetix.com 


**
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: Find and Replace Component for 4D Write Pro

[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 automatically. You can download it and a demo 
> at:
> 
> http://www.successware.net/downloads/4d-components/FindAndReplace.zip
> 
> It requires 4D v16R5. You are free to use and modify it in any way you wish. 
> See the accompanying MIT license.

**
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: Import from Excel

[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:  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: Import from Excel

[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. The TextEdit 
document must have been converted to plain text before pasting the content. Be 
sure that there is CR after the last line and save the document.

Hope this saves someone some time. I do this all the time as I have grown to 
really like Numbers, but using one of the suggested plugins is really the way 
to go.

John

On Mar 7, 2018, at 5:55 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

> On Mar 7, 2018, at 5:36 AM, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> 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

John Baughman
Kailua, Hawaii
(808) 262-0328
john...@hawaii.rr.com





**
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: Import from Excel

[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   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Mar 7, 2018, at 5:36 AM, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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

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

[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 Bensky
Subject: 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 MailJet so I can't speak for them, but the service we
use (Aweber) offers lots of useful features such as tracking who clicked on
which links in the emails. It would be a lot of work to do that with a
4D-generated email.

HTH!
Pat

On 7 March 2018 at 02:43, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I’ve inherited a project that’s been setup to send email via MailJet. I’m
> having a problem where a newly defined CC email address will not be
> delivered via MailJet unless another test email address is specified as a
> CC as well. So, I have to ask, why might you use a service like MailJet
> when sending email from 4D? Why might the new CC not stand on it’s own?
>
> Thanks,
>
> Robert
>
> **
> 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
> **




-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

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

[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 MailJet so I can't speak for them, but the service we
use (Aweber) offers lots of useful features such as tracking who clicked on
which links in the emails. It would be a lot of work to do that with a
4D-generated email.

HTH!
Pat

On 7 March 2018 at 02:43, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I’ve inherited a project that’s been setup to send email via MailJet. I’m
> having a problem where a newly defined CC email address will not be
> delivered via MailJet unless another test email address is specified as a
> CC as well. So, I have to ask, why might you use a service like MailJet
> when sending email from 4D? Why might the new CC not stand on it’s own?
>
> Thanks,
>
> Robert
>
> **
> 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
> **




-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

Find and Replace Component for 4D Write Pro

[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:

http://www.successware.net/downloads/4d-components/FindAndReplace.zip

It requires 4D v16R5. You are free to use and modify it in any way you wish. 
See the accompanying MIT license.

Hope this saves someone else some time and effort. :-)

--
Jeff Grann
SuccessWare, Inc.

**
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: Import from Excel

[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 free Excel plugins from Miyako :  
https://github.com/miyako
These are great for some quick Excel features.

But if you need real control, Pluggers is it.

Randy Engle, Director
XC2 Software LLC – XC2LIVE!



**
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: Import from Excel

[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 then think that each of those returns or line feeds represents the end
of a row (record).

No problem if you don't have any text fields like that in your spreadsheet
:)

Pat

On 7 March 2018 at 10:36, Koen Van Hooreweghe via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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 V16 someone know how i can to import from excel?
>
>
>
> 
> Compass bvba
> Koen Van Hooreweghe
> Kloosterstraat 65
> 9910 Knesselare
> Belgium
> tel +32 495 511.653
>
> **
> 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
> **
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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: Import from Excel

[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 V16 someone know how i can to import from excel?




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

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

Import from Excel

[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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**