Áú»¢¶Ä²©

6. §±§â§Ö§Õ§à§Ò§â§Ñ§Ò§à§ä§Ü§Ñ CSV §Ó JSON

§°§Ò§Ù§à§â

§£ §ï§ä§à§Þ §ê§Ñ§Ô§Ö §á§â§Ö§Õ§Ó§Ñ§â§Ú§ä§Ö§Ý§î§ß§à§Û §à§Ò§â§Ñ§Ò§à§ä§Ü§Ú §Ú§Þ§Ö§Ö§ä§ã§ñ §Ó§à§Ù§Þ§à§Ø§ß§à§ã§ä§î §á§â§Ö§à§Ò§â§Ñ§Ù§à§Ó§Ñ§ß§Ú§ñ §Õ§Ñ§ß§ß§í§ç CSV §æ§Ñ§Û§Ý§Ñ §Ó §æ§à§â§Þ§Ñ§ä JSON. §±§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ §Ó:

• §ï§Ý§Ö§Þ§Ö§ß§ä§Ñ§ç §Õ§Ñ§ß§ß§í§ç (§á§â§à§ä§à§ä§Ú§á§Ñ§ç §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç)
• §á§â§Ñ§Ó§Ú§Ý§Ñ§ç §ß§Ú§Ù§Ü§à§å§â§à§Ó§ß§Ö§Ó§à§Ô§à §à§Ò§ß§Ñ§â§å§Ø§Ö§ß§Ú§ñ

§¯§Ñ§ã§ä§â§à§Û§Ü§Ñ

§¥§Ý§ñ §ß§Ñ§ã§ä§â§à§Û§Ü§Ú §ê§Ñ§Ô§Ñ §á§â§Ö§Õ§Ó§Ñ§â§Ú§ä§Ö§Ý§î§ß§à§Û §à§Ò§â§Ñ§Ò§à§ä§Ü§Ú CSV §Ó JSON:

• §±§Ö§â§Ö§Û§Õ§Ú§ä§Ö §ß§Ñ §Ó§Ü§Ý§Ñ§Õ§Ü§å §±§â§Ö§Õ§à§Ò§â§Ñ§Ò§à§ä§Ü§Ñ §Ó §ß§Ñ§ã§ä§â§à§Û§Ü§Ñ§ç §ï§Ý§Ö§Þ§Ö§ß§ä§Ñ §Õ§Ñ§ß§ß§í§ç / §á§â§Ñ§Ó§Ú§Ý§Ñ §à§Ò§ß§Ñ§â§å§Ø§Ö§ß§Ú§ñ
• §¯§Ñ§Ø§Þ§Ú§ä§Ö §ß§Ñ §¥§à§Ò§Ñ§Ó§Ú§ä§î (Add)
• §£§í§Ò§Ö§â§Ú§ä§Ö §à§á§è§Ú§ð CSV §Ó JSON (CSV to JSON)

§±§Ö§â§Ó§í§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §á§à§Ù§Ó§à§Ý§ñ§Ö§ä §Ù§Ñ§Õ§Ñ§ä§î §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î§ã§Ü§Ú§Û §â§Ñ§Ù§Õ§Ö§Ý§Ú§ä§Ö§Ý§î. §°§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §Ö§ã§Ý§Ú §á§Ö§â§Ó§Ñ§ñ §ã§ä§â§à§Ü§Ñ §Ó§ç§à§Õ§ñ§ë§Ú§ç §Õ§Ñ§ß§ß§í§ç CSV §ß§Ñ§é§Ú§ß§Ñ§Ö§ä§ã§ñ §ã ?Sep=? §Ú §Ù§Ñ§ä§Ö§Þ §ã§Ý§Ö§Õ§å§Ö§ä §à§Õ§Ú§ß UTF-8 §ã§Ú§Þ§Ó§à§Ý, §ä§à§Ô§Õ§Ñ §ï§ä§à§ä §ã§Ú§Þ§Ó§à§Ý §Ò§å§Õ§Ö§ä §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î§ã§ñ §Ó §Ü§Ñ§é§Ö§ã§ä§Ó§Ö §â§Ñ§Ù§Õ§Ö§Ý§Ú§ä§Ö§Ý§ñ §Ó §ã§Ý§å§é§Ñ§Ö, §Ö§ã§Ý§Ú §á§Ö§â§Ó§í§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §ß§Ö §Ù§Ñ§Õ§Ñ§ß. §¦§ã§Ý§Ú §á§Ö§â§Ó§í§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §ß§Ö §Ù§Ñ§Õ§Ñ§ß §Ú §â§Ñ§Ù§Õ§Ö§Ý§Ú§ä§Ö§Ý§î §ß§Ö §Ú§Ù§Ó§Ý§Ö§Ü§Ñ§Ö§ä§ã§ñ §Ú§Ù §ã§ä§â§à§Ü§Ú ?Sep=?, §ä§à §Ó §Ü§Ñ§é§Ö§ã§ä§Ó§Ö §â§Ñ§Ù§Õ§Ö§Ý§Ú§ä§Ö§Ý§ñ §Ò§å§Õ§Ö§ä §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î§ã§ñ §Ù§Ñ§á§ñ§ä§Ñ§ñ.

§£§ä§à§â§à§Û §à§á§è§Ú§à§ß§Ñ§Ý§î§ß§í§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §á§à§Ù§Ó§à§Ý§ñ§Ö§ä §Ù§Ñ§Õ§Ñ§ä§î §ã§Ú§Þ§Ó§à§Ý §Ü§Ñ§Ó§í§é§Ö§Ü.

§¦§ã§Ý§Ú §à§ä§Þ§Ö§é§Ö§ß §æ§Ý§Ñ§Ø§à§Ü §³§à §ã§ä§â§à§Ü§à§Û §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ (With header row), §Ù§ß§Ñ§é§Ö§ß§Ú§ñ §ã§ä§â§à§Ü§Ú §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §Ò§å§Õ§å§ä §Ú§ß§ä§Ö§â§á§â§Ö§ä§Ú§â§à§Ó§Ñ§ß§í §Ü§Ñ§Ü §Ú§Þ§Ö§ß§Ñ §ã§ä§à§Ý§Ò§è§à§Ó (§ã§Þ§à§ä§â§Ú§ä§Ö §°§Ò§â§Ñ§Ò§à§ä§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §Õ§Ý§ñ §á§à§Ý§å§é§Ö§ß§Ú§ñ §Ò§à§Ý§Ö§Ö §á§à§Õ§â§à§Ò§ß§à§Û §Ú§ß§æ§à§â§Þ§Ñ§è§Ú§Ú).

§¦§ã§Ý§Ú §à§ä§Þ§Ö§é§Ö§ß §æ§Ý§Ñ§Ø§à§Ü §¥§â§å§Ô§à§Ö §á§â§Ú §à§ê§Ú§Ò§Ü§Ö (Custom on fail), §ï§Ý§Ö§Þ§Ö§ß§ä §Õ§Ñ§ß§ß§í§ç §ß§Ö §ã§ä§Ñ§ß§Ö§ä §ß§Ö§á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§Þ§í§Þ §Ó §ã§Ý§å§é§Ñ§Ö §à§ê§Ú§Ò§Ü§Ú §ß§Ñ §ê§Ñ§Ô§Ö §á§â§Ö§Õ§Ó§Ñ§â§Ú§ä§Ö§Ý§î§ß§à§Û §à§Ò§â§Ñ§Ò§à§ä§Ü§Ú. §¬§â§à§Þ§Ö §ä§à§Ô§à, §Þ§à§Ø§ß§à §Ù§Ñ§Õ§Ñ§ä§î §á§à§Ý§î§Ù§à§Ó§Ñ§ä§Ö§Ý§î§ã§Ü§å§ð §à§Ò§â§Ñ§Ò§à§ä§Ü§å §à§ê§Ú§Ò§à§Ü: §à§ä§Ò§â§à§ã§Ú§ä§î §Ù§ß§Ñ§é§Ö§ß§Ú§Ö, §Ù§Ñ§Õ§Ñ§ä§î §ß§å§Ø§ß§à§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§Ö §Ú§Ý§Ú §Ù§Ñ§Õ§Ñ§ä§î §ß§å§Ø§ß§à§Ö §ã§à§à§Ò§ë§Ö§ß§Ú§Ö §à§Ò §à§ê§Ú§Ò§Ü§Ö.

§°§Ò§â§Ñ§Ò§à§ä§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ

§³§ä§â§à§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ CSV §æ§Ñ§Û§Ý§Ñ §Þ§à§Ø§Ö§ä §à§Ò§â§Ñ§Ò§Ñ§ä§í§Ó§Ñ§ä§î§ã§ñ §Õ§Ó§å§Þ§ñ §â§Ñ§Ù§ß§í§Þ§Ú §ã§á§à§ã§à§Ò§Ñ§Þ§Ú:

• §¦§ã§Ý§Ú §æ§Ý§Ñ§Ø§à§Ü §³§à §ã§ä§â§à§Ü§à§Û §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §à§ä§Þ§Ö§é§Ö§ß ¡ª §Ù§ß§Ñ§é§Ö§ß§Ú§ñ §ã§ä§â§à§Ü§Ú §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §Ú§ß§ä§Ö§â§á§â§Ö§ä§Ú§â§å§ð§ä§ã§ñ §Ü§Ñ§Ü §Ú§Þ§Ö§ß§Ñ §ã§ä§à§Ý§Ò§è§à§Ó. §£ §ï§ä§à§Þ §ã§Ý§å§é§Ñ§Ö §Ú§Þ§Ö§ß§Ñ §ã§ä§à§Ý§Ò§è§à§Ó §Õ§à§Ý§Ø§ß§í §Ò§í§ä§î §å§ß§Ú§Ü§Ñ§Ý§î§ß§í §Ú §ã§ä§â§à§Ü§Ú §ã §Õ§Ñ§ß§ß§í§Þ§Ú §ß§Ö §Õ§à§Ý§Ø§ß§í §ã§à§Õ§Ö§â§Ø§Ñ§ä§î §Ò§à§Ý§î§ê§Ö §ã§ä§à§Ý§Ò§è§à§Ó, §é§Ö§Þ §ã§ä§â§à§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ;
• §¦§ã§Ý§Ú §æ§Ý§Ñ§Ø§à§Ü §³§à §ã§ä§â§à§Ü§à§Û §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §ß§Ö §à§ä§Þ§Ö§é§Ö§ß ¡ª §ã§ä§â§à§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ §Ú§ß§ä§Ö§â§á§â§Ö§ä§Ú§â§å§Ö§ä§ã§ñ §Ü§Ñ§Ü §Õ§Ñ§ß§ß§í§Ö. §ª§Þ§Ö§ß§Ñ §ã§ä§à§Ý§Ò§è§à§Ó §Ô§Ö§ß§Ö§â§Ú§â§å§ð§ä§ã§ñ §Ñ§Ó§ä§à§Þ§Ñ§ä§Ú§é§Ö§ã§Ü§Ú (1,2,3,4...)

§±§â§Ú§Þ§Ö§â CSV §æ§Ñ§Û§Ý§Ñ:

Nr,Item name,Key,Qty
       1,active agent item,agent.hostname,33
       "2","passive agent item","agent.version","44"
       3,"active,passive agent items",agent.ping,55

§°§Ò§â§Ñ§Ò§à§ä§Ü§Ñ §ã§ä§â§à§Ü§Ú §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ

§£§í§Ó§à§Õ JSON, §Ü§à§Ô§Õ§Ñ §à§Ø§Ú§Õ§Ñ§Ö§ä§ã§ñ §ã§ä§â§à§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ:

[
          {
             "Nr":"1",
             "Item name":"active agent item",
             "Key":"agent.hostname",
             "Qty":"33"
          },
          {
             "Nr":"2",
             "Item name":"passive agent item",
             "Key":"agent.version",
             "Qty":"44"
          },
          {
             "Nr":"3",
             "Item name":"active,passive agent items",
             "Key":"agent.ping",
             "Qty":"55"
          }
       ]

§°§Ò§â§Ñ§Ò§à§ä§Ü§Ñ §Ò§Ö§Ù §ß§Ñ§Ý§Ú§é§Ú§ñ §ã§ä§â§à§Ü§Ú §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ

§£§í§Ó§à§Õ JSON, §Ü§à§Ô§Õ§Ñ §ß§Ö §à§Ø§Ú§Õ§Ñ§Ö§ä§ã§ñ §ã§ä§â§à§Ü§Ñ §Ù§Ñ§Ô§à§Ý§à§Ó§Ü§Ñ:

[
          {
             "1":"Nr",
             "2":"Item name",
             "3":"Key"
             "4":"Qty"
          },
          {
             "1":"1",
             "2":"active agent item",
             "3":"agent.hostname"
             "4":"33"
          },
          {
             "1":"2",
             "2":"passive agent item",
             "3":"agent.version"
             "4":"44"
          },
          {
             "1":"3",
             "2":"active,passive agent items",
             "3":"agent.ping"
             "4":"55"
          }
       ]