Tonight we're going to be looking at a important topic and that is how to import all of my data into Obsidian in the easiest and most efficient way possible.

今晚，我們將討論一個重要話題，那就是如何以最簡單、最高效的方式將我的所有數據導入黑曜石。

For many of us cut and pasting or copy and pasting is you know the method we've all begun with but some of us get sick and tired of doing that and we've sort of started exploring other methods and means over the years of how to get the data in more efficiently.

對於我們中的許多人來說，剪切粘貼或複製粘貼是我們開始使用的方法，但我們中的一些人已經厭倦了這樣做，多年來我們開始探索其他方法和手段，以更有效地獲取數據。

I've done so much so that you know I'm basically working in a data analytical role these days.

我已經做了很多，以至於你知道我現在基本上是在從事數據分析工作。

It's a skill set guys and once you've learned it it can be really beneficial to your to your common work jobs and things like that.

這是一種技能，一旦學會，對你的普通工作和類似的事情都非常有益。

So anyway what we're going to be doing is we've been looking at Filings fantastic JSON CSV import tool.

總之，我們接下來要做的，就是研究 Filings 夢幻般的 JSON CSV 導入工具。

It is just called the JSON CSV import tool inside of it but you know it's fantastic and filings amazing so let's just rename it.

它的內部名稱是 JSON CSV 導入工具，但你知道它非常神奇，文件也非常棒，所以我們還是給它重新命名吧。

All right without further ado let's jump over and have a look.

好了，廢話不多說，讓我們跳過去看看吧。

All right so in front of me you can see I've got the Demo Vault 2 going on.

好了，在我面前，你可以看到我正在演示 Vault 2。

Got all sorts of things going in here that we've been testing over there the last couple months and what we're gonna do is just go through the process of getting this thing installed.

這裡有各種各樣的東西 我們在過去幾個月裡一直在那裡測試 我們要做的就是把這個東西安裝好

So come down here to settings we're gonna come in here to community plugins we're gonna go browse and we're gonna do a search for import.

所以，請到這裡的設置，我們要在這裡的社區插件，我們要去瀏覽，我們要做的導入搜索。

So JSON CSV importer you can tell you've got the right one because it's got filing 42 in it.

所以，JSON CSV 導入器中有 42 號文件，你就可以知道你用對了。

Filings obviously the guy we want to really be working with he's been supporting the Realmworks community for years and supporting the Obsidian communities we've moved over to this tool as well.

Filings 顯然是我們希望真正合作的對象，他多年來一直在支持 Realmworks 社區，並支持我們轉移到該工具的黑曜石社區。

It was very quick to put this in.

安裝過程非常快。

Obviously with everything go through and click install.

顯然，一切就緒後，點擊安裝。

Once it's installed click enable and while you're down here and have a look at the readme file.

安裝完成後，點擊 "啟用"，並查看自述文件。

Now I do want to point out that there's something really cool in here that you can have a look.

現在我想說的是，這裡有一個很酷的東西，你們可以看一看。

So handlebars.js.com slash guide.

是以，handlebars.js.com 斜槓指南。

I highly recommend you give this a look.

我強烈建議你看看這個。

All right and we can see here that basically what we've got is a list of basic, I guess you'd say some templates and readme files on how to use those templates.

好了，我們可以看到，基本上我們得到的是一個基本模板列表，我猜你會說是一些模板和如何使用這些模板的自述文件。

But basically handlebar is a template format that's used by other sort of programs in order to import data and what it's going to do is it's going to give you instructions on how to import data and I'm going to show you the very basics of how to use this application.

基本上，handlebar 是一種模板格式，其他程序使用它來導入數據，而它要做的就是為你提供如何導入數據的說明。

All right let it be known that there is more advanced stuff inside of these readmes and if you're doing a lot of this you probably want to sit learn and understand exactly what this thing can do.

如果你經常做這些事情，你可能會想坐下來學習並瞭解這東西到底能做什麼。

I highly recommend it.

我強烈推薦。

All right but we're not going to be going into the depths of that today.

好吧，但我們今天不會深入探討這個問題。

I've installed it, I've enabled it, fantastic.

我安裝了它，啟用了它，太棒了。

Come back down here to my demo vault and the first thing I need to do is really sort of set up a folder where I want all this stuff to go.

回到我的演示庫，我需要做的第一件事就是建立一個文件夾，把這些東西都放在裡面。

So I'm going to go import test is my folder.

所以，我要把測試導入我的文件夾。

I want everything to come into here.

我希望所有的東西都能進入這裡。

All right the next thing I need is a source file.

好了，接下來我需要一個源文件。

So what I've done is I've just gone onto the internet, done a random Google for a table.

所以，我就上網在谷歌上隨便找了一張桌子。

This one came from Google Sheets.

這個來自 Google Sheets。

Someone's shared basically a list of tables on spell items and magic items and stuff, the prices and the rarity of them.

有人分享了一份關於法術物品和魔法物品及其他物品、價格和稀有程度的列表。

All right I'm just using this as an example guys you could do any combination of data that you want.

好吧，我只是舉例說明，你們可以任意組合數據。

All right if you can find the data out there in an Excel spreadsheet or copy your data into an Excel spreadsheet go for your life.

好吧，如果你能在 Excel 電子表格中找到數據，或者把你的數據複製到 Excel 電子表格中，那就去吧。

And I want you know you know just to make you think outside the box like if you can find a spreadsheet of monsters then effectively you could import entire monsters with this thing.

我想讓你跳出固有的思維模式，比如如果你能找到怪物的電子表格，那麼你就可以用這個東西導入整個怪物。

So what I've done is I've found my table online, I've copied it into an Excel and I've saved it as a .CSV file.

是以，我在網上找到了我的表格，將其複製到 Excel 中，並保存為 .CSV 文件。

Now that's very important .CSV files don't have any formatting.

這一點非常重要。CSV 文件沒有任何格式化。

You can see I've copied the but if I was to basically now open that thing now that I've saved it again it should drop everything off.

你可以看到我已經複製了它，但如果我現在打開它，再保存一次，它就會把所有東西都刪除。

All right so let's just try that let's just go close and we'll go Excel and we're gonna try and break this thing.

好吧，那我們就試一試 我們靠近一點，然後用Excel把它打碎

We'll reopen book 2.

我們將重開第二冊。

All right there we go.

好了，我們走吧。

So .CSV files don't have any formatting it is literally just text you can open them up into a notepad you can see the format of things that are going on but the really important things to take away is this top row here.

所以 .CSV 文件沒有任何格式化，只是字面上的文本，你可以將其打開到記事本中，你可以看到其中的格式，但真正重要的是最上面這一行。

All right because these are our column names and we need to make sure that we know what these are.

好的，因為這些是我們的列名，我們需要確保我們知道這些是什麼。

So what I'm going to do is I'm going to stick that over to the side just so I can keep looking at it.

所以，我要做的就是把它貼到一邊，這樣我就可以繼續看了。

I've got some other stuff going on here we'll close that down.

我還有些別的事要做，我們先把這個關掉。

So yeah I've got an Excel spreadsheet all right and now we need to create something called a handlebar file.

所以，我已經有了一個 Excel 電子表格，現在我們需要創建一個名為 handlebar 文件的東西。

Now the good thing about a handlebar file is that they are incredibly simple.

現在，車把文件的好處在於它們非常簡單。

I've got one here that I've made already so I'm going to show you what it looks like.

我這裡有一個已經做好的，所以我要向你們展示一下它的樣子。

It's a note all right so all I've done is create a note I've named it something in this case I've called it my handlebar template for magic items and I've written my note all right I've just written it like I would normally so I put my tags in here I put my name all right but you see the thing that starts to stand out is this here.

我把它命名為 "我的魔法物品手把模板"，然後寫下我的註釋，就像平時寫的那樣，我把標籤放在這裡，寫上我的名字。

All right if I bring this back you'll see that what I've done here is in these see inside these curly brackets I've basically gone through and replicated the name of the columns that I want to import.

好的，如果我把這個拿回來，你會看到我在這裡所做的是，在這些大括號內，我基本上都是在複製我想要導入的列名。

So I'm going to copy the name of here into there the name again into here the price into there the rarity into there.

是以，我要把這裡的名稱複製到那裡，再把這裡的名稱複製到這裡，把價格複製到那裡，把稀有度複製到那裡。

Now just as an example to show you know just how flexible this thing is I've gone and made a table all right where I've just copied it through again so you can certainly do that as well.

舉個例子，我做了一個表格，把它複製了一遍，你也可以這樣做。

All right so all you have to do is go curly bracket curly bracket the name of the column and curly bracket and curly bracket and you're done that's it all right that's very simple right if you have a hundred columns in your Excel spreadsheet you could map all hundred of them you could format this however you want you could bold the headings italics lay it out you could probably add let's just try this right import oh it's been a while call out here we go read aloud this is my text I have this name in my bag just as an example right just to show that it can be done all right that's a handlebar file that's that's that's it there's nothing really much that much to it you basically just creating a file or a note inside of obsidian that tells you where you want to import those items when they come from your your spreadsheet and with that we then come over here to the JSON CSV importer icon which will be down your left-hand side here choose JSV CSV file so we're gonna go choose file and I'm going to use the the book 2.CSV that I saved before choose template file so this is my handlebar file that I just created so I know that that's in my vault so we're gonna go to obsidian demo vault 2 it's in where is it templates it's a markdown and it is my handlebar magic items all right so that's now selected field to use as a note name all right so I want my files to be named according to well in this case here what I'm going to use is I'm going to use the magic item that's fine and which folder do I want to put it in I'm gonna put it into the import test all right now just to show you just how cool this thing is right like import test right now is empty there is nothing in here now we come back to here I can't do this again I take long if I can't remember where I put everything okay I'm ready set go boom import finished okay so what is it done let's go and have a look it's not empty anymore all right what it's done it's just imported and created a new note for every single one of these interestingly I've actually got more have I oh no it's just it's okay it's we can come in here and have a look we've got the the tag that we put in we've got the name came in the price the rarity the table populated and the call-out box worked all right now you can see it's created one note for every single line in my table and you can see instantly how useful that can be right you just have to go and I don't know let's say well can you find an NPC spreadsheet online for example pretty sure there's actually a reddit out there of D&D DMs who've been collecting NPCs for a while there's thousands of them technically you can import the whole thing or if you could find like an SRD file that contains all the monsters or all the spells you can import all that all right simples so yeah that is a that's filing CSV JSON importer again this is just a simple demo of how the functionality works just to get your head sort of in the mindset of thinking about what you could do with this thing it does work on JSON JSON files which means technically if you were playing with fifth edition monsters you could do the import from there as well I will say though that JSON is more complex than CSV JSON tends to have nested data elements and what I mean by that is there's usually a parent item and then underneath the parent there might be different items so for example there might be a parent variable called attributes and then inside the attributes you won't find another variable called strength and dexterity and constitution so when that happens you're gonna need to sort of jump into that readme file and really sort of go through and find out how you can access the sub layers of that I've played around with it I managed to get it working I haven't got it working completely accurately to what I wanted so I stopped playing with it but I found some other ways to do what I wanted to need to do myself but yeah obviously if you're you're playing with bulk data or you know this is a it's not not really that technical so for those of you who aren't data analysts or don't understand SQL or don't want to dive into KNIME or Alteryx or something like that you know this is a really fantastic option so yeah anyway guys I hope that's a big useful for you hope it helps obviously get your your data into the tool in a much more efficient way and yeah we'll see what you guys can do with it so outside of that I'll speak to you guys on the forums have a great day

好了，你要做的就是把列名用大括號括起來，再用大括號括起來，這樣就完成了，非常簡單，如果你的 Excel 電子表格中有 100 列，你就可以把這 100 列全部映射出來，你可以隨心所欲地設置格式，你可以把標題用粗體斜體標出來，你還可以添加一些內容，讓我們來試試看吧。這是我的文本，我的包裡有這個名字，只是舉個例子，只是為了說明可以這樣做，好了，這是一個手把手文件，就是這樣，就是這樣，其實沒有什麼太多的東西，你基本上只是在黑曜石裡面創建了一個文件或一個備註，告訴你當這些項目來自你的電子表格時，你想把它們導入到哪