Skip to content

CsvTool converts the given csv file into c# model, sql insert command and mongo insert command.

Notifications You must be signed in to change notification settings

Eneswunbeaten/CsvTool

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CsvTool

Converts Csv File to Mongo Insert, Sql Insert and C# Model Structure.

Usage

  • When the program starts, it asks you to drag a .csv file onto it.
  • image

  • Enter the delimiter in Write a delimiter. For example, parsers can be one of the following (| , : : ;)
  • What should the output be like, section selects exactly what the csv file will be converted to.
  • In the Table name section, the table name must be entered exactly correctly. The name of the output file will start with this table name (e.g. BoardCategories_Mongo.txt)
  • In the Export path section, select exactly which folder to save the resulting txt file. (Default saves to the desktop.)
  • Add Id checkbox section is opened if mongo is selected. Generates ObjectId.
  • image

  • If there are no column names in the first line of the csv file, i.e. in the headers, click the Add new names manually button and enter the column names one by one.
  • image

  • Pressing the Start button starts the process and the result of the conversion is displayed on the screen.