NeoDBPro import CSV....
Quote from DaviddeArgentina on December 31, 2024, 10:43 pmHello everyone,
Have a great start to the year 2025
I have a php that generates a recordset from a mysql table.
How can I give it the shape and content I want, so far I generated it as a .csv file
Once I have that recordset (csv file) I need to put it into a NeoDBPro grid.
I tried several different ways, using the DBPImportCSV action, but I can't find a way around it.
Does anyone have an example that works to adapt what I need?
Thank you infinitely!
Hola a todos,
que tengan un gran comienzo de año 2025Tengo un php que genera un recordset de una tabla mysql.
Como puedo darle la forma y contenido que quiera, hasta ahora lo generé como un archivo .csv
Una vez que tengo ese recordset (archivo csv) necesito ponerlo dentro de un grid de NeoDBPro.
Intenté de varias maneras distintas, usando la accion DBPImportCSV, pero no le encuentro la vuelta.
Alguien tiene algun ejemplo que funcione, para adaptar lo que necesito?
Infinitas gracias!
Hello everyone,
Have a great start to the year 2025
I have a php that generates a recordset from a mysql table.
How can I give it the shape and content I want, so far I generated it as a .csv file
Once I have that recordset (csv file) I need to put it into a NeoDBPro grid.
I tried several different ways, using the DBPImportCSV action, but I can't find a way around it.
Does anyone have an example that works to adapt what I need?
Thank you infinitely!
Hola a todos,
que tengan un gran comienzo de año 2025
Tengo un php que genera un recordset de una tabla mysql.
Como puedo darle la forma y contenido que quiera, hasta ahora lo generé como un archivo .csv
Una vez que tengo ese recordset (archivo csv) necesito ponerlo dentro de un grid de NeoDBPro.
Intenté de varias maneras distintas, usando la accion DBPImportCSV, pero no le encuentro la vuelta.
Alguien tiene algun ejemplo que funcione, para adaptar lo que necesito?
Infinitas gracias!
Quote from Gaev on January 1, 2025, 5:58 pm@daviddeargentina
Best if you upload to this forum ...
- a minimalist pub with just the rectangle for the grid ... and the relevant commands you are using (like dbpOpenAccessDatabase, dbpCreatetable/dbpOpenTable, dbpImportFromCSV etc.)
- a subset of the csv file that you are attempting to upload
Best if you upload to this forum ...
- a minimalist pub with just the rectangle for the grid ... and the relevant commands you are using (like dbpOpenAccessDatabase, dbpCreatetable/dbpOpenTable, dbpImportFromCSV etc.)
- a subset of the csv file that you are attempting to upload
Quote from DaviddeArgentina on January 1, 2025, 8:18 pmThis is an example that should work.
There is the PUB, the MDB container database, the table that receives the content and the CSV file to test if it works.
Download link:
https://aplicaciones.xp3.biz/pelis/importCSV.rar
Thank you so much!
This is an example that should work.
There is the PUB, the MDB container database, the table that receives the content and the CSV file to test if it works.
Download link:
https://aplicaciones.xp3.biz/pelis/importCSV.rar
Thank you so much!
Quote from emo on January 2, 2025, 12:41 am@daviddeargentina
El php debe generar un retrono de carro y salto de linea en cada registro (\r\n)
En dbpImportFromCSV dbes poner como Delimiter el caracter coma (,) y no |
El php debe generar un retrono de carro y salto de linea en cada registro (\r\n)
En dbpImportFromCSV dbes poner como Delimiter el caracter coma (,) y no |
- You need to login to have access to uploads.
Quote from DaviddeArgentina on January 2, 2025, 8:42 pmInfinitas Gracias !
Gran comienzo de Año!
Un abrazo,
Infinitas Gracias !
Gran comienzo de Año!
Un abrazo,