Re: Import from Excel

2018-03-08 Thread Jeremy French via 4D_Tech
Hi Tim, Just tried the Tech Note using v16 without success. Apparently PHPExcel is deprecated. It’s successor is PHPSpreadsheet at: https://github.com/PHPOffice Could you possibly do a new edition of your Tech Note using PHPSpreadsheet and v16? Best regards,

Re: Import from Excel

2018-03-08 Thread Keith Goebel via 4D_Tech
Pat, > Yes ... We wrote a procedure to import csv files. My point was that you can't > just use the basic 4D Import option to import such files. We don’t use 4D’s import, so I can’t comment on whether it works correctly or not. Chip, > >> the problem I have found with csv is that different

Re: Import from Excel

2018-03-08 Thread Chip Scheide via 4D_Tech
the problem I have found with csv is that different software creates different formats. sometimes, everything is quoted, sometimes only certain values are quoted, and similar to the problem of a tab delimited text file, if the text contains a equation mark(s) everything gets screwed. In my

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