Exporting Customer Records from SQL DATABASE

[markjw]

Just upgrade your V4 to V5 instead of starting fresh.

If you really don’t want to do this, for whatever reason you want a fresh V5 install, I would suggest the best way to get that data out from V4 database is actually to upgrade it to V5 then use the Data Export feature under Reports. You can create a report to export the customer records to CSV.

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…

This is the best approach, because customer data is stored in JSON within the SQL table, and it’s not easy to extract.

Also, there was a similar post to yours a few days ago, there are some other options for getting the data out from JSON formatted fields if you really don’t want to upgrade the database to V5 to use data export feature, but I don’t see any reason why you wouldn’t want to. Remember you can just take a backup of your V4 database beforehand then you always have it prior to upgrade.

Here is the other post:

Querying Custom Data Columns in SQL

I would appreciate some help in doing a query on a custom data fields. I have my Driver entity with custom data as such I’ll skio the cut and paste and give a few fields Custom data= Address, Email Address, Hourly Rate, Rate Per Delivery - as an example So it would be something like Select ??? from entities where EntityId =3 and Name = ‘Joe’; Not looking for a tutorial just an example of how to query these custom data columns Thank You in Advance