3 months ago
Fri May 31 2024, 10:00PM
Hello,
Can you provide a sample for configuring a database connection to an Excel file?
I'm not surve bout the PDO Connection string I require, and also how to set the fields in the database connection. For example, can I just ignore the values en "Server port", or "Separator"? What should I put in the "Database" field? The worksheet name? The file name?
Thank you for your support!
3 months ago
Fri May 31 2024, 10:00PM
We should be able to give a simple answer, but the honest answer is that we can't because something has been broken. The old applications still work, but creating new ones does not pick up the fields. We are currently investigating the issue. In principle, you declare the connection as a CSV and apply a path to the csv file. Then PHsPeed will create a temporary sqlite table that is used to store and maintain the csv. When the database is updated a new csv is generated.
Another approach is done by Kit (JadeWay software) use an odbc connection (which also should work), but runs into similar issues. We're not yet sure that both issues are related, but we look at both issues currently.