We recommend the well-developed note-taking software, wire note, and the keyboard Hook Technology to obtain real-time data and materials for good tools to build a code snippet database.

Remember a requirement I mentioned in "List of Scenario Design and requirements in one of the Data solution R & D diaries of the knowledge management system". The user selects a piece of text and then calls the shortcut key, it is also called a hot key. The materials and data are automatically stored in my notebooks. Data Loader has implemented this function perfectly to help you save the note data.

Open Data LoaderProgramTo setting for initial setup, see the figure.

Wire shortcust is a hot key. You can press the keyboard to record the key you are pressing. If you modify it, restart Data Loader to apply new settings to the key hook. The other switch is clear clipboard after fetch its data. When you select a text segment, press Ctrl + C to copy it to the clipboard, and press Ctrl + Q, that is, the wire shortcust you set. It will automatically generate a note item from the data in the clipboard, at the same time, if there is a check box, the clipboard will be cleared. This option can avoid repeatedly adding the same items to the notebooks.

Select a piece of text in MS Word, copy Ctrl + C to the clipboard, and press Ctrl + q. Then, you can see that the interface effect is as follows:

The documents selected in MS Word are automatically added to the wire note library, and a prompt is displayed in the lower right corner.

In the same situation, you can also copy text from notepad and Visual Studio. The effect is quite good. Please refer

In this way, if you are looking at other colleagues'CodeIf you want to collect the code written in it, you can try this function to save a lot of time to organize the code. So as I mentioned in the title, creating a code snippet database means that. Open Visual Studio, browse the code you need, press Ctrl + C to the clipboard, and then send Ctrl + Q to create a new note.

 

Another purpose is recommended. When you browse news or materials on a webpage, you may encounter important or valuable materials. You can also select the required materials, copy them to the clipboard, and press Ctrl + Q to add them to the notebooks. Please refer to this

This is what I saw in the MSN headlines: the developer of the financial crocodile Soros secret committee is waiting to copy the Chinese property market _ Financial Management _ msn, So I copied it to the clipboard, press Ctrl + Q to automatically add the main content of the news to the notebooks. Is it convenient?

 

This can change my previous habit of collecting web pages. Previously, a good and valuable webpage will store it in HTML files, but HTML will contain images and add a large number of useless files (images and CSS). This is annoying; after IE6, by default, the storage format is changed to MHT file, which makes it much easier to store images and webpage content in an MHT file. However, Opening this file is usually very slow and there will be a help protect prompt that cannot be cleared, many methods are used to prevent prompt and fail. The most important thing is that the MHT format should be opened in a browser, which is very slow and inconvenient, and there is no open source code library to read it.

I made an improvement by using the site rebuild application to save the webpage as a doc document for easy editing and storage. For more information, seeArticleShare the well-made knowledge management system blog backup program site rebuild to experience this method.

 

Think about progress. Saving a whole web page as a MS Word document is not needed in many places, but it is also saved to a Word file, such

In this webpage, I do not need to use the red text to relax the circle. I just want to see its main news content. Therefore, I have been thinking about how to capture the data I need. One way is to use rule editor to edit rules to capture specified data. You need to be familiar with regular expressions, another method is the wire note I implemented here. Select the data content you need, and then send a hot key. Wire note uses it as the new note content.

 

To learn more about other features in wire note, right-click the notes and pop up context menu. Its content is as follows:

There are a total of six menu items. For their meanings, see the following table.

Remove selected item	Delete the selected note items
Copy to clipboard	Copy the current note item to the clipboard.
Copy as new note	Copy the current note item to generate the same note as it.
Make it as document	Based on the current notes,
Remove all records	Delete all note items, just clear the interface
Clear all note	Delete all notes, clear the interface, and clear the database.

 

Let's explain how to make it as document. When selecting a note, click this menu and go to document explorer to see that a document has been generated based on the note ), see the following two figures and select the content of the original notes.

Go to document explorer to view the content.

Note items are converted to documents correctly. You can continue to classify and edit documents.

Document Explorer uses the SQL cache dependency query and tracking technology, so there is no need to refresh its interface. When you make it as document notes, the updated document content is correctly displayed in document explorer, increasing convenience. For this reason, you need a database of SQL Server 2005 or above to ensure that the query and tracking technology works properly. If an error is prompted when you open the document explorer form

No permission, please run SQL script first. Run the following script (which can be found in document. SQL ).

 -- enalbe  SQL  Server 2005 cache dependency  declare  @ dbname nvarchar (100)  set  @ dbname = db_name ()  execute  ( 'alter database'  + @ dbname +  'set new_broker with rollback immediate' )  go   declare  @ dbname nvarchar (100)  set  @ dbname = db_name ()  execute  ( 'alter database'  + @ dbname +  'set enable_broker ')  go  

 

Some notes about wire note

1. Saving notes to SQL Server is a failure. This is basically true. The user is unlikely to have to install a large SQL Server to take notes, which is obviously unreasonable. Access does not support x64. First of all, it is excluded that sqllite databases move files without affecting the use of them. db4o is also a green database, which gives priority to both. Database migration and migration are very convenient. This is the main requirement. Wire note is still in the technical evaluation phase. If you have a good database solution, please recommend it to me.

2. Evernote and OneNote are popular Notes software on the market. OneNote regards each note item as a physical file. I don't like this feature. It is troublesome to move files, but it comes from Microsoft and is one of the office suites. It is highly integrated with office products and is convenient and flexible. Evernote is a small and easy-to-use note-taking software, the green version, a total of about 10 m, basic functions are available, from graduation to the present has been the software to collect information. However, I have no confidence that the data I put in it will be able to read one day. The more notes you put, the more worried you will be. One day, my note database crashes. After so many years of technology, the accumulated humanistic data cannot be read, it seems that you don't want this to happen, and so do I. Upgrade the operating system to Windows 7. If many software is not updated, there are more or less problems. For example, Microsoft Visual C ++ 6.0 cannot be installed on Windows 7. While all my wire data and notes are stored in the SQL Server database in the RTF format, you will not worry that I will not maintain Data Loader in the future, and your note data will not be available, you can write a reading tool by yourself to read the notes stored in SQL Server, and usually only a few lines of code can be used.

 
System. Windows. Forms. RichTextBox rtfbox =NewSystem. Windows. Forms. RichTextBox ();StringNote = getnotefromdatabase (1020); rtfbox. rtf = note;
 

You can even write an export tool to export all notes that exist in SQL Server as the RTF document. This requires only a few lines of code.

// Create a writer and open the fileTextwriter Tw =NewStreamwriter ("ISL. rtf");// Write a line of text to the fileStringNote = getnotefromdatabase (1020); TW. Write (Note); TW. Close ();
 

As you can see, my advantage is that the format is open. Using the open RTF format as the note format, you can find a large number of software, tools, third-party class libraries to read and write the note content, secondary development, and then processing.

 

3. Integration considerations. Add-in to the office document to convert the Office document into the notes for wire note. Add-in a common text processing tool to convert the text currently being processed into notes. This is much more convenient.

4. Consider using wire note as a single application program, instead of mixing it in the Data Loader application assembly to facilitate data migration. Usually, the moving data is also copied together with the software. The software only has a few MB, and the data often has several GB. The software can still run with the data moving, changing the computer or changing the system.

5. Evernote uses the cloud computing note synchronization technology. You can upload your own notes anywhere to conveniently download and synchronize notes anywhere. Data Loader does not have this strength to implement this function. Cloud computing is a concept stock operated by merchants, just like Web 2.0. It is not suitable for programmers.

 

Download the latest Data Loader from epn.codeplex.com (http://epn.codeplex.com/releases/view/68647.