16 comments found.
Hello bro,. Help me.. TypeError: Cannot read property ‘insertId’ of undefined
can you print capture the error please? when you get this error? is it when you try upload the excel files ?
and also did you make a changes to the code? if not, if still pure from codecanyon, it should be work fine! Tested so many times. from the error that you post, there is undefined variable. Maybe you was change with difference variable.
this because, you don’t put header on excel file. Or the header name contain space. Please don’t use space in header! Example use Phone_Number or PhoneNumber ( without space )
is it possible for sql server ?
I am not sure, because this app I created only for MySQL. Maybe you can use SQL Server but need to change a couple things inside the code.
hello, cannot run “node app.js”, can you help me
if you access http://localhost:3002/ you will get not found page, because I put the path for admin is /adminiku. So the login path should be http://localhost:3002/adminiku
it’s already on documentation.
Note: After you extract the files, run npm update first or npm install https://prnt.sc/qWtn7G3ipRnDThen create database and import the .sql file.
Then run “node apps.js”
Hello got error
Incomplete response received from application
app running on Plesk
Version Node.js : 14.17.5
Application Mode : development
https://nimb.ws/O2efZNthanks 
Now I’m getting
Error 502 Bad gateway + Cannot GET /import/auth
Hi Mate, is it error when start the applications ? or when use application feature? can you share full error response that you get? Thanks.
when use application feature
I restart, wiped everything but nothing changed
so the Application running on Plesk system
everything setup well but when after login redirect to /auth
and get Cannot GET /auth
do you have an email where i can send you more details if needed ?
Yes, please send the screenshoot to my email igp.ekasuryawan@gmail.com Seem the problem come from the proxy server. Just send the error that you get.
email sent !
I was reply the email! the problem only adjust the path. Because you remove the subfolder. It’s should be working now.
Thanks.
Demo is throwing proxy errors
It was a cache from my server. But if you see directly on live demo above link. Its working fine.
Thanks.
Proxy Error
The proxy server received an invalid response from an upstream server. The proxy server could not handle the request
Reason: Error reading from remote server
Apache/2.4.29 (Ubuntu) Server at project.devnodejs.com Port 443
Try to use different browser mate. From my side it’s working fine
http://prntscr.com/13f6mbi https://project.devnodejs.com/uploadexjs/adminikuForbiddenError: invalid csrf token at csrf (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/csurf/index.js:112:19) at Layer.handle [as handle_request] (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:317:13) at /var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:335:12) at next (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:275:10) at cookieParser (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/cookie-parser/index.js:57:14) at Layer.handle [as handle_request] (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:317:13) at /var/www/vhosts/project.devnodejs.com/public_html/node_modules/express/lib/router/index.js:284:7
is anyone else cannot access my demo directly? please give some feedback.
Thanks.
i try different browser and try I access directly from demo https://project.devnodejs.com/uploadexjs/adminiku but when I try yo use your software and upload excel file it show erorr msg Proxy Error
The proxy server received an invalid response from an upstream server. The proxy server could not handle the request
Reason: Error reading from remote server
Apache/2.4.29 (Ubuntu) Server at project.devnodejs.com Port 443
Weird. So, you saw the login page right? then after you login, you get the error, correct? if yes, can you screen capture the web browser when you try to login?? please screen cap with the url also.
want to see the result, just curious , would find the error.
Thanks.
Seem like it’s error from excel format that you uploaded. Maybe column format or row format or maybe not excel files.
I upload the excel, it’s working fine
http://prntscr.com/13gvq34 See sample excel files, you can downloaded https://project.devnodejs.com/Book1_TEST.xlsxdemo not working…
Updated path https://igdepe.baliwebcrafted.com/uploadexjs/
Hi Guys, if there is an error from preview codecanyon, please directly see the demo
https://project.devnodejs.com/uploadexjs/adminikuThank you
Updated path https://igdepe.baliwebcrafted.com/uploadexjs/
Hello, can you show me the demo again? it show error… Intrested with the script but the demo currently doesnt work.
it’s just my server issue Thanks
Hi, Thank you for the app. After downloading and setting up the database, I run “node apps.js” and go to localhost:3002 that only shows:”Cannot GET /” Do you know how can I fix this?
Hi A_M_A, See file myroute/backend.js ( see row 19, var base_url ). on the download file, I set base url on that file ”/adminiku” so you need to access http://localhost:3002/adminiku to get the dashboard. You can change if you want.
Hope this help. Thanks.
Thank you very much!
If you think my app is useful for your business or your works, please rate it. Thank you.
Hi. The app looks great. Do you offer customization for a charge? If so how can I send an email over to you with my specifications. Thanks!
Thank you.
is the validation of data in EXcel taken care before upload
reply you in email. thanks
Thanks you
Hello i have a Firebase database
i want exel import solution
and i want to import 10 Million Data in separated exel file are you able to do this custom job
Please Let me know!!
reply you in email. thanks
hello,
in installation, step 1. Create database datauploaddb. Then import datauploaddb.sql.
the download did not include a .sql file. please advise.
Hi hyuneek, sent you on the private message. Thanks
Also, I think on download files already exist also. Please have a look and re-download it.
Thank you.
Demo is throwing proxy errors
Hi Andrew Traub, I was changing something in the server yesterday. Please re-review the demo page
http://preview.codecanyon.net/item/uploadexjs-import-excel-file-into-mysql-with-expressjs/full_screen_preview/24373224?_ga=2.186725736.1375311815.1566543464-1582671009.1566197263Updated Path https://igdepe.baliwebcrafted.com/uploadexjs/
Not sure in the preview not working, but you can try direct link demo here
https://igdepe.baliwebcrafted.com/uploadexjs/Congratulations! Nice Work, GLWS
Great Work, Congratulations GLWS
