This topic is locked

Import Excel into Table

6/5/2018 7:25:48 PM
PHPRunner General questions
M
Melanie authorDevClub member

I created a very simple php app to import a simple excel data sheet into 1 single table in my sql database. When I built it on my local windows 7 machine and ran it in chrome it worked fine. When I uploaded it into my Windows 2012 R2 IIS server, the import does not work. When attempting to do the import from the server (with import file being local) It does not show the data properly (shows many nulls and some strange characters). It does not see the data to be imported in this Excel file and will not import it.
Again, as I said - running locally on my windows 7 machine with iiexpress, works fine.
Any help?

admin 6/6/2018

Make sure that are setting write permissions on a temporary import folder.
https://xlinesoft.com/phprunner/docs/export_import_pages.htm

Check the very end of the article.

M
Melanie authorDevClub member 6/6/2018

Thank you - that seemed to get me closer as I can see that the files are being written to that folder now - but the file still does not import correctly
The preview looks like this on my local machine
https://www.flickr.com/photos/tandmellingson/42620384181/in/dateposted-public/
but like this from my 2012 r2 server
https://www.flickr.com/photos/tandmellingson/42569629542/in/dateposted-public/



Make sure that are setting write permissions on a temporary import folder.
https://xlinesoft.com/phprunner/docs/export_import_pages.htm

Check the very end of the article.

M
Melanie authorDevClub member 6/6/2018

So I have discovered that the file DOES import - the preview just does not render or show a proper preview. This will work for now while I research further why the preview does not show the correct information.