Looking for an expert in databases to help migrate content from an ASP.net website to WordPress. The client has provided CSV files from the old site, which need to be reformatted in a way that can be uploaded to the new WordPress database.
They currently have 457 recipes in the database, which is well worth to automate the upload. What will be trickier to automate is the assignment of the current images to the future WordPress implementation.
Other information from the client:
Attached is the database download as csv files from table 'BusinessPartner' which is relevant for your necessary query. Your SQL query should be something like: SELECT * FROM BusinessPartner WHERE IsSupplier = 1
The relevant columns to retrieve information from are in a .csv file with content. The column definitions for the full table are shown with 2 screenshots. However, you only need the columns listed in the csv file.