Uploading Entiy Data online for use witha website

[QMcKay]

@the133448

SQL DB is locally hosted right on my register. How can I connect to the DB?

PHP SQLSRV Extension, or ODBC. If attaching remotely, you need to configure SQL Express to allow remote connections and open ports in your Firewall.

@the133448

I cant even find the local database files.

Depends if you are using SQL Express or SQL Local DB, but you are looking for MDF/LDF files. SQL Server Management Studio (SSMS) will allow you to see the properties of the database and reveal where the files are located. But that does not really help in your quest, since you need the DBMS Engine to read the files anyway.

@the133448

having an action to export all the member data after a ticket is processed to a file folder

Search for Data Exports feature - it uses Report Tags to export to different data formats including CSV, XML, YAML, etc… This is the most detailed discussion I could find…

Data Exports feature

I notice Data Exports feature under Manage > Reports, but nothing mentioned on the forum about it. What does this do? Can I use it to create CSV exports? Any info much appreciated. Thanks EDIT: Ok I notice it exports the report to a txt file. If for example I use the {REPORT INVENTORY} tag I am getting output like this: >Local Warehouse|| Svedka|4,900|ML Absolute|4,280|ML Belvedere|455|ML Taking same format from the inventory report with the table header [Inventory Report:1,1, 1…