Data importer doesn't recognize my .tsv file with 2 columns. As you can see in screenshots below this file is properly formatted. count(\t) == count(\n), I've counted this delim chars in notepad++ in Search dialog. But on import both columns are recognized as a single one. Reason is in data in one of columns. I believe you will get same behavior with this data. What should I do and where should I post this bug report? I haven't found Data Importer repo or feedback contacts.
note_id note_note
1 Earned a degree in physics from the University of Minnesota in 1948. Used his knowledge of Scandinavia and science extensively in his career. Has contributed a huge body of highly literate SF and Fantasy to the field. Father-in-law of writer Greg Bear.
2 American citizenship in 1958
3 Became a US citizen in 1928. Undergraduate degree in chemistry from Columbia University, 1939; MA in 1941; PhD in chemistry from Columbia University, 1948.
4 Started writing SF after winning a amateur short story contest for <i>Thrilling Wonder Stories</i>, with "The Broken Axiom". He wrote scenarios for DC Comics (<i>The Green Lantern</i> and <i>Batman</i>), wrote for radio (<I>Charlie Chan</i> and <i>The Shadow</i>), wrote for TV (<i>Tom Corbet, Space Cadet</i>), and was a book reviewer for <i>Fantasy & Science Fiction</i>. In the 1950's he took a position with the magazine <i>Holiday</i>, later becoming the senior literary editor of the magazine. During this period of time her wrote very little SF. Upon his return to the genre in the 70s, his work was uneven.
5 Campbell received a degree in Physics from MIT and Duke University in 1923; his first story was published while still a student at MIT. His initial splash was in <i>Amazing Stories</i> with his <i>Arcot, Morey and Wade</i> series, which established him as %%A,Edward E. Smith%%'s main rival in galactic epics. He later took on the pseudonym <i>Don A. Stuart</i> (supposedly derived from Donna Stuart), to move away from space-opera, changed his writing style to a more literary tone, and began writing stories for Tremaine's <i>Astounding Stories</i>. He also wrote the controversial short story "The Irrelevant" under the pseudonym Karl van Campen. <p> In 1937 Campbell was appointed editor of <i>Astounding Stories</i>, and would remain so through its name change to <i>Analog</i> until his death in 1971. As editor, he discovered %%A,Isaac Asimov%%, %%A,Robert A. Heinlein%%, %%A,Lester del Rey%%, %%A,Theodore Sturgeon%%, and %%A,A. E. van Vogt%%. He also brought %%A,L. Sprague de Camp%%, %%A,L. Ron Hubbard%%, %%A,Clifford D. Simak%%, %%A,Henry Kuttner%%, %%A,C. L. Moore%%, and %%A,Jack Williamson%% into the <i>Astounding</i> stable of writers. He was also instrumental in the originations of many classic SF ideas; Asimov co-credits Campbell with the Three Laws of Robotics. <p> Campbell also edited the fantasy magazine <i>Unknown</i>, a companion magazine to <i>Astounding</i>. <i>Unknown</i>, along with <i>Weird Tales</i>, helped to shaped the fantasy genre into it's modern shape. <i>Unknown</i> died prematurely due to a wartime paper shortage.
6 Born in Minehead, Somerset, England. Chairman of the British Interplanetary Society, 1946-1947 and 1950-1953. BSc with first class honours from King's College, London in physics & mathematics in 1948.
7 Born in Terra Haute, Indiana, Farmer settled in Peoria Illinois. He received a B.A. in creative writing from Bradley University in 1950.
8 Taken from "A Note About The Author" in his book, "Friday": Robert Anson Heinlein was born in Butler, Missouri, in 1907. A graduate of the US Naval Academy, he was retired, disabled, in 1934. He studied mathematics and physics at the graduate school of the University of California and owned a silver mine before beginning to write science fiction in 1939. In 1947 his first book of fiction, "Rocket Ship Gallileo", was published....[deleted text listing other books published], all winners of the Hugo Award. Heinlein was guest commentator for the Apollo-11 first lunar landing. In 1975 he received the Grand Master Nebula Award for lifetime achievement.
9 Not to be confused with %%A,Neil R. Jones%%.
This file is properly formatted, it can be imported correctly in powershell:
PS C:\JAVA2023\isfdbDump> Import-Csv -Delimiter `t '.\tsv\notes - Copy.tsv'
note_id note_note
------- ---------
1 Earned a degree in physics from the University of Minnesota in 1948. Used his knowledge of Scandinavia and science extensiv…
2 American citizenship in 1958
3 Became a US citizen in 1928. Undergraduate degree in chemistry from Columbia University, 1939; MA in 1941; PhD in chemistry…
4 Started writing SF after winning a amateur short story contest for <i>Thrilling Wonder Stories</i>, with "The Broken Axiom"…
5 Campbell received a degree in Physics from MIT and Duke University in 1923; his first story was published while still a stu…
6 Born in Minehead, Somerset, England. Chairman of the British Interplanetary Society, 1946-1947 and 1950-1953. BSc with firs…
7 Born in Terra Haute, Indiana, Farmer settled in Peoria Illinois. He received a B.A. in creative writing from Bradley Univer…
8 Taken from "A Note About The Author" in his book, "Friday": Robert Anson Heinlein was born in Butler, Missouri, in 1907. A …
9 Not to be confused with %%A,Neil R. Jones%%
I was able to import this data with this workaround:
Import-Csv -Delimiter `t '.\tsv\notes.tsv' | ConvertTo-Csv > 'tsv\notes.csv'
But it'd be better if no workarounds needed. Still it seems like a bug.