CSV file and its use
In the process of the set, you will definitely hear the word CSV file. So what is the so-called CSV file? What is it used? How do you use it? Read the following text carefully, I believe that you will have a preliminary understanding of CSV.
The so-called "CSV" is the English abbreviation of Comma Separated Value, which is usually a plain text file. Below is some of the contents of the actual CSV file, let everyone have a sense of understanding. We choose the CSV file of SJOJO_RESCAN (Sjojo is one of the members of the ASW-Asian Sweeping Wind).
SJ_MINO1001.JPG, 715282, 4FB55FE8,
SJ_MINO1002.JPG, 471289, 93203C5C,
SJ_MINO1003.JPG, 451929, C4E80467,
Usually, the opening of the CSV file is not left, in the behavioral unit, record a picture of a plurality of data in each row, each data is divided into a comma (standard English comma). Generally speaking, the format of the .csv file is like this:
File name, file size (in bytes), CRC check value, annotation (omitted)
SJ_MINO1001.JPG, 715282, 4FB55FE8,
| | | | | |
File Name File Size CRC Value Note (omitted)
If your machine is loaded with Microsoft Excel, the .csv file is opened by Excel by default. It should be noted that when you double-click a .csv file, Excel opens it, even if you don't make any modifications, Excel often prompt to change to the correct file format when it is closed, and this time I want to choose "No ". Because Excel believes that the number in the .csv file is represented by scientific notes, and the number in the .csv file we want is normal. If you choose "Yes", Excel
Will use all the numbers in the CSV file to represent scientific counts (2.54932e 5), this file is not available. If the most of your CSV file is used on the set map, it is recommended to change the default open mode of .CSV to any text editor, the system comes with a noticeable choice.
Ok, let's go back to the format of the CSV file. See above, from left to right sj_mino1001.jpg is the file name, 715282 is the size of the file represented by byte. When the comma is included in the file name, due to the special role of the comma in the CSV file, in order not to generate ambiguity, you need to create a file with the quotation. For example, "The Art, Fantasy.jpg", 384211, ..., .... then is an 8-bit 16-en-numeric 4fb55FE8, which is the CRC32 check value of the file. The essence of the entire CSV file is here.
Let us give a small example to explain its meaning: Sjojo released a picture SJ_MINO1001.JPG, suppose you get this picture from your friends, then you will often have such questions, this picture is spreading Is it changed during the process? Does it have not intended to be damaged? The CRC exists to solve this problem. Under normal circumstances, the sweeping family released a set of pictures, simultaneously released a CSV file (this CSV is often called OFFICIAL CSV, which is the meaning of the official release of CSV), this CSV's CRC value is used in specialized software The CRC32 algorithm (common CRC algorithm has CRC16) a value generated after the file operation, which can be used as a flag of the file. In most cases, if this file is in the propagation process, whether the size is or the content is changed. Then, the CRC check value generated after the same CRC32 algorithm is calculated is completely different. If the CRC value is the same, there is a reason to think that this file is true and is not changed. Others, the name of the picture file received is changed, then how do you know who is? At this time, the CRC value works again: After processing the picture with a dedicated software, you can get the size of the file and the CRC value, and then look for a suitable picture according to the size and CRC value in CSV. If so, the name of the picture will be changed to the CSV. For example, you received a picture, the name is Pic0001.jpg, and you know that this picture is Sjojo_rescan in this collection, but I don't know which one is. Getting it with software and CRCs are 715282 and 4fb55fe8, respectively, the software found a line sj_mino1001.jpg, 715282, 4fb55fe8, size and CRC in the CSV file, the software thinks that the original name of this picture is SJ_MINO1001.JPG, then Automatically change the name of the file to SJ_MINO1001.JPG. The change is not a CSV file but the file name of the picture. The next is the annotation and description, which can be omitted. Need to note is that the comment is not a comma. If you want to omit the comment, you must keep a comma at the back of the CRC value, otherwise the software will consider the CRC value is noted. I believe that after reading a lot of things above, you will not only understand the CSV file, but it should also be a vague concept for it. We collect pictures that are often through a variety of different channels, such as from the website, IRC, or simply send a friend. During the entire propagation process, the picture is likely to suffer a wide variety of non-human treatments. Especially the pictures received from the website. Sometimes just simply changed the name, more times, because many PLMM station spaces are limited, often reduce the size of the picture, or reduce the picture file. A 1356x588 map was changed to 678x294, or a four-five hundred k files were shrunk to do tens of k. More disgusting is that many websites remove the logo of the original sweeping home and hit the LOGO of our website. There are also some funny players who make a variety of pictures to pick up the wood and change the face. These are general views
The map entertainment is not harmful, but for the setup, it is impossible to receive such pictures. How to check the positive image of the picture, this is the problem of sweeping the furniture and settles. The CSV file is to solve such a problem. The CSV file is used in a simple database, which is simply scanned by the scangers as a mark of your own portraits due to its simple database. As mentioned above, the CSV file is a plain text file, and each line represents a number of properties of a picture. When you receive an atlas, just find its CSV file, use a dedicated software check, you can make a message about the atlas. For example, how many of this set of pictures, how many photos have you received, which is the original picture, those that may be changed or damaged ... We can regard .csv files as a index, you not only You can "salary", you can also check whether the "horse" of the "horse" collected is pure. The source of the CSV file usually has two: one is the CSV released by the scan home, which is generally called Official CSV. That is, the officially released CSV, usually there is a considerable authority. More special is many of Asia's scangers, except for the public release, there are some privately released Special charts, or some pictures dedicated to a friend. Plus the picture is unwilling or not CSV, so the CSVs of their portals are often doing them from some senior seniors in the collection. In this case, there will be several versions of the CSV file in a closet, and there is a small difference between each version. At this time, CSV is not only the basis for authenticing the body, but also gives the setter a hope: This CSV author! There is a famous saying: "There is a CSV that there must be a picture!" Naturally, the folks have some authoritative players who do CSV. For example, early edzone, now still active Osun, Shu, VSAM, TE, PAUL ... and causal COC II WQC
Ok, I said so much, everyone may ask, the CSV file is so easy, what should I use? Will you hand in hand? Oh, do you remember the word "software" in the above? Dedicated software can help us complete this work. Common software has the! Checker and the hunter. At present, these two software have Chinese Simplified Chinese version, and the Chinese people are from the Northern Snowtank (Thanks Snowtank)
