neoSql Plugin Coming Soon
Quote from luishp on January 17, 2021, 7:00 pmWe already have neoGSheets Plugin to use Google Sheets spreadsheets as a read only "database".
The new neoSql Plugin allows executing complex SQL queries over Excel files (.xlsx) or CSV plain text delimited files. No server side scripting. Read only access. Web server required to avoid CORS. I think it's a great tool for learning SQL :)neoSql sample app:
https://visualneo.com/tutorials/neosqlSample Excel file:
https://visualneo.com/tutorials/neosql/sample.xlsxRegards.
We already have neoGSheets Plugin to use Google Sheets spreadsheets as a read only "database".
The new neoSql Plugin allows executing complex SQL queries over Excel files (.xlsx) or CSV plain text delimited files. No server side scripting. Read only access. Web server required to avoid CORS. I think it's a great tool for learning SQL :)
neoSql sample app:
https://visualneo.com/tutorials/neosql
Sample Excel file:
https://visualneo.com/tutorials/neosql/sample.xlsx
Regards.
Quote from luishp on January 17, 2021, 8:14 pm@cdy44-2 I have just updated the sample app so now it's possible to download an Excel file with the data query result or even any other object data variable. I have not tested it yet but in theory you can query a remote database with neoPhp and download the result as a .xlsx file to the local device.
Yes, it's quite interesting :)
@cdy44-2 I have just updated the sample app so now it's possible to download an Excel file with the data query result or even any other object data variable. I have not tested it yet but in theory you can query a remote database with neoPhp and download the result as a .xlsx file to the local device.
Yes, it's quite interesting :)
Quote from luishp on January 17, 2021, 8:35 pm@vadim thanks! I think neoSql plugin will become the easiest way to import external data into our VisualNEO Web apps. Quite more easy than neoPhp or neoGSheets plugins. And with no external dependencies :)
This is all the code needed to perform a SQL query over an Excel file:
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ?" [data] ""That's all. This simple command will import all the information from the Excel file into a variable object.
And this command will save the result into a new Excel file:neoSqlSaveExcel "queryresult.xlsx" [data]:)
@vadim thanks! I think neoSql plugin will become the easiest way to import external data into our VisualNEO Web apps. Quite more easy than neoPhp or neoGSheets plugins. And with no external dependencies :)
This is all the code needed to perform a SQL query over an Excel file:
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ?" [data] ""
That's all. This simple command will import all the information from the Excel file into a variable object.
And this command will save the result into a new Excel file:
neoSqlSaveExcel "queryresult.xlsx" [data]
:)
Quote from Gustavo1973 on January 19, 2021, 2:34 am@luishp
En que cambiaria la manera con la cual vengo trabjando hoy dia con tu plugin actual al hacer consultas y demas en las bases mysql
O este es solo para archivos excel
En que cambiaria la manera con la cual vengo trabjando hoy dia con tu plugin actual al hacer consultas y demas en las bases mysql
O este es solo para archivos excel
Quote from luishp on January 19, 2021, 8:18 am@gustavo1973 solo para archivos Excel o CSV. Tiene la ventaja de que es mucho más fácil y puedes crear las queries SQL en VisualNEO Web sobre la marcha (no en un archivo .php aparte). Desventajas: solo lectura y los datos no están protegidos.
Saludos.
@gustavo1973 solo para archivos Excel o CSV. Tiene la ventaja de que es mucho más fácil y puedes crear las queries SQL en VisualNEO Web sobre la marcha (no en un archivo .php aparte). Desventajas: solo lectura y los datos no están protegidos.
Saludos.
Quote from rrey on January 19, 2021, 6:24 pm@luishp A mi me parece una herramienta fantástica y con esta herramienta visualneo sigue haciéndose más potente.
Yo tengo la idea de probar de clasificar las apps creadas con visualneo y las que tenía ya creadas en adobe flash (+600), que ahora he recuperado con un simulador instalado en el servidor. Creo que este complemento podría ayudar a crear esa base de datos-hoja de cálculo y que puedan consultar por ejemplo por asignatura, nivel, conenido... Es una idea que quiero probar. No se si podría llamarlo un CMS de consulta de datos.
@luishp A mi me parece una herramienta fantástica y con esta herramienta visualneo sigue haciéndose más potente.
Yo tengo la idea de probar de clasificar las apps creadas con visualneo y las que tenía ya creadas en adobe flash (+600), que ahora he recuperado con un simulador instalado en el servidor. Creo que este complemento podría ayudar a crear esa base de datos-hoja de cálculo y que puedan consultar por ejemplo por asignatura, nivel, conenido... Es una idea que quiero probar. No se si podría llamarlo un CMS de consulta de datos.
Quote from m.burdess on July 15, 2021, 8:10 pmI like this a lot, but can you use Variables to do the search.
So if you have an excel doc with Postcode, Course available College A, Course available Collage B.
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ?" [data] ""How would you need to change the above code, to do the search of a Postcode and show the answer.
I like this a lot, but can you use Variables to do the search.
So if you have an excel doc with Postcode, Course available College A, Course available Collage B.
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ?" [data] ""
How would you need to change the above code, to do the search of a Postcode and show the answer.
Quote from luishp on July 16, 2021, 6:57 amHi @m-burdess I don't understand very well your question. Note that you can use any SQL query. For example:
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ? WHERE Postcode = [value]" [data] ""More information here (original library):
https://github.com/agershun/alasqlBest regards
Hi @m-burdess I don't understand very well your question. Note that you can use any SQL query. For example:
neoSqlExcel "sample.xlsx" "sheet1" "SELECT * FROM ? WHERE Postcode = [value]" [data] ""
More information here (original library):
https://github.com/agershun/alasql
Best regards
Quote from m.burdess on July 16, 2021, 10:37 am@luishp
Sorry if the question was not clear.
I have an excel spreadsheet with over 1 million lines, showing Postcodes and if you can get a Level 2 or 3 course for free. This spreadsheet also includes the Service provider (College) that will provide the service for the postcode ( as some do not cover the all postcodes ). This checking was done by a project worker, and with cuts in funding has to be done but Learn Reps. So I am trying to create a page which the Rep just need to enter the Postcode and it will show them the Service provider that can help the Person.
As may code is not good and needs work, sometime I ask simple questions. I see what I want to achieve, but lack the knowledge to get to it.
Thank you for the help.
Sorry if the question was not clear.
I have an excel spreadsheet with over 1 million lines, showing Postcodes and if you can get a Level 2 or 3 course for free. This spreadsheet also includes the Service provider (College) that will provide the service for the postcode ( as some do not cover the all postcodes ). This checking was done by a project worker, and with cuts in funding has to be done but Learn Reps. So I am trying to create a page which the Rep just need to enter the Postcode and it will show them the Service provider that can help the Person.
As may code is not good and needs work, sometime I ask simple questions. I see what I want to achieve, but lack the knowledge to get to it.
Thank you for the help.
Quote from luishp on July 16, 2021, 12:06 pm@m-burdess I think my sample code should work.
Regards.
@m-burdess I think my sample code should work.
Regards.
Quote from m.burdess on July 20, 2021, 9:08 pmThank you for the help, but I have another question.
When I run the example within VisualNEO Web, the answer screen is not shown, but if I use the link from your first post it works.
Does this mean that it only works when upload to a server.
Thank you for the help, but I have another question.
When I run the example within VisualNEO Web, the answer screen is not shown, but if I use the link from your first post it works.
Does this mean that it only works when upload to a server.
Quote from luishp on July 21, 2021, 7:03 am@m-burdess, please take a look at the plugin description on the first post in this thread:
Web server required to avoid CORS.
You can use the included neoPhp Server locally or your favourite one.
Best regards.
@m-burdess, please take a look at the plugin description on the first post in this thread:
Web server required to avoid CORS.
You can use the included neoPhp Server locally or your favourite one.
Best regards.
Quote from m.burdess on July 23, 2021, 11:24 am@luishp
I have compiled the copy within the sample apps, and test it on line, and this it great. Can you tell me have you change some of the code as with your version above, the information comes below the query line, but with the sample its under the header and query.
Second question, How do you show Dates, i.e. to show a start date and end date.
I have compiled the copy within the sample apps, and test it on line, and this it great. Can you tell me have you change some of the code as with your version above, the information comes below the query line, but with the sample its under the header and query.
Second question, How do you show Dates, i.e. to show a start date and end date.
Quote from luishp on July 23, 2021, 12:28 pmSorry @m-burdess again I don't understand you :/
Sorry @m-burdess again I don't understand you :/
Quote from m.burdess on July 23, 2021, 7:55 pm@luishp
I have attached an image from the link showing the screen display of :
neoSql sample app:
https://visualneo.com/tutorials/neosqlThis screen took Good but when you see the screen from the one that is within the sample Apps, the search start at the top of the page, so some of the search is being hidden under the Header and TextInput line.
The second question is able showing dates i.e. 26/07/2021, with a test excel is coming out as 44403 and not 26/07/2021.
I have attached an image from the link showing the screen display of :
neoSql sample app:
https://visualneo.com/tutorials/neosql
This screen took Good but when you see the screen from the one that is within the sample Apps, the search start at the top of the page, so some of the search is being hidden under the Header and TextInput line.
The second question is able showing dates i.e. 26/07/2021, with a test excel is coming out as 44403 and not 26/07/2021.
Uploaded files:
- You need to login to have access to uploads.
Quote from Gaev on July 23, 2021, 9:59 pm@m-burdess
The second question is able showing dates i.e. 26/07/2021, with a test excel is coming out as 44403 and not 26/07/2021.
Looks like it is the difference (in days) between 01-JAN-1900 and 26-JUL-2021.
The software is storing dates relative to 01-JAN-1900 (or time in milliseconds since midnight of 01-JAN-1900).
The second question is able showing dates i.e. 26/07/2021, with a test excel is coming out as 44403 and not 26/07/2021.
Looks like it is the difference (in days) between 01-JAN-1900 and 26-JUL-2021.
The software is storing dates relative to 01-JAN-1900 (or time in milliseconds since midnight of 01-JAN-1900).
Quote from luishp on July 24, 2021, 10:54 am@m-burdess you are right, there is a small error in the sampleapp. Please download the fixed attached one.
I have just deleted the "col-sm-12" class in the Properties Panel under "Advanced".Regards.
@m-burdess you are right, there is a small error in the sampleapp. Please download the fixed attached one.
I have just deleted the "col-sm-12" class in the Properties Panel under "Advanced".
Regards.
Uploaded files:- You need to login to have access to uploads.