![]() ![]() How I was used to do this is by programatically creating a script to read the CSV file and map it to a DB population script based on the DB type. ![]() This article will show how to directly use a formula in sheets and generate a DB insert/update query without any programming. So most of the Time data will be comes as a CSV/EXCEL file and has to covert data in to JSON or SQL script and migrate it to a DB like Elasticsearch or SQL DB. But sometimes working with JSON is not the fastest way for a non technical person. Sometimes, the data population has to do some data conversions to JSON or SQL format. So most of the Time data will be comes as a CSV/EXCEL file and has to covert data in to JSON or SQL script and migrate it to a Database.
0 Comments
Leave a Reply. |