Hey everyone. I am trying to import data from a cvs file and I am having issues with certain columns that have multiple entries for corresponding db. In case your wondering its movie data and the other db are genre and other info like that. I am using Microsoft sql server management to do the import of data to my databases but on fields like Genres its not reading the delimiters or I am not exactly sure how to make it understand. This is a sample of a line of my cvs file and you can see its delimiter is , but not exactly how to import the genre field correctly. The bold text is just the corresponding column name. I dont have any programming friends so not sure who to ask
Code:
Budget 215000000,
Genres "[{""id"": 28, ""name"": ""Action""},
{""id"": 12, ""name"": ""Adventure""},
{""id"": 14, ""name"": ""Fantasy""}]",
Homepage http://www.theamazingspiderman.com,
Id 1930,
Keyword "[{""id"": 1872, ""name"": ""loss of father""},
{""id"": 7002, ""name"": ""vigilante""},
{""id"": 8803, ""name"": ""serum""},
{""id"": 8828, ""name"": ""marvel comic""},
{""id"": 156855, ""name"": ""scientific experiment""},
{""id"": 158124, ""name"": ""spider bite""},
{""id"": 158456, ""name"": ""masked vigilante""},
{""id"": 161184, ""name"": ""reboot""},
{""id"": 163455, ""name"": ""super powers""},
{""id"": 163561, ""name"": ""genetic engineering""},
{""id"": 171556, ""name"": ""social outcast""},
{""id"": 179431, ""name"": ""duringcreditsstinger""}]",
Original_language En,
original_titleThe Amazing Spider-Man,
Overview "Peter Parker is an outcast high schooler abandoned by his parents as a boy, leaving him to be raised by his Uncle Ben and Aunt May. Like most teenagers, Peter is trying to figure out who he is and how he got to be the person he is today. As Peter discovers a mysterious briefcase that belonged to his father, he begins a quest to understand his parents' disappearance – leading him directly to Oscorp and the lab of Dr. Curt Connors, his father's former partner. As Spider-Man is set on a collision course with Connors' alter ego, The Lizard, Peter will make life-altering choices to use his powers and shape his destiny to become a hero.",
Popularity 89.866276,
Production_companies "[{""name"": ""Columbia Pictures"", ""id"": 5},
{""name"": ""Laura Ziskin Productions"", ""id"": 326},
{""name"": ""Marvel Entertainment"", ""id"": 7505}]",
Production_countires 36"[{""iso_3166_1"": ""US"", ""name"": ""United States of America""}]",
Release date 2012-06-27,
Revenue 752215857,
Runtimes 136,
Spoken_languages "[{""iso_639_1"": ""en"", ""name"": ""English""}]",
Status Released,
Taglines The untold story begins.,
Title The Amazing Spider-Man,
Votes_average 6.5,
Vote_count 6586
