lots of lovely classes for reading Excel with php, last I searched.
I have use comma-separated and tab-separated TEXT files for reading into via
PHP.
* http://php.net/manual/en/function.fgetcsv.php
beverly
On Sep 27, 2016, at 11:25 AM, Bob Patin <bob@xxxxxxxxx> wrote:
I have a client whose database (a half-dozen or so fields) gets regularly
updated with new records.
The client is asking if it would be possible for me to write something for
the web that would allow them to take a spreadsheet and import all the
records en masse.
In other words, it’d be great if I could write a PHP routine that would allow
the user to select an XLS file, then somehow read it and import the records
into FileMaker.
Has anyone done one of these?
I’m thinking that if it’s comma-delimited, I could simply have them select
the file, read the text into a variable, and then parse out the records.
Any thoughts from this august gathering?
Thanks,
Bob Patin
Longterm Solutions
bob@xxxxxxxxxxxxxxxxxxxxx
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin@xxxxxx
Twitter: bobpatin
—
FileMaker Consulting
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting