[SAP] Cloud Application Studio의 CSV File Upload

 

if(this.RootAttachment.IsSet())
{
   foreach(var Doc in this.RootAttachment.Document)
   {
         var DocContent = Doc.FileContent.BinaryObject.content.ToString();
 
         var Line       = 1;
         var StartLine = 0;
         var EndLine   = -1;
 
         var DocLength = DocContent.Length();
 
         while(DocLength != StartLine)
         {
            EndLine       = DocContent.Find("\n",StartLine);
            var LineStr   = DocContent.Substring(StartLine, EndLine - StartLine - 1);///
            
            var ColPosition   = 1;
            var StartPosition = 0;
            var EndPosition   = -1;
 
            var Validation = true;
            var VisitCheck = true;
 
            if(Line != 1 && Line != 2)
            {
               var CopyNode : elementsof ProductionList;
               CopyNode.Clear();
 
               while(ColPosition < 6 )
               {
                  var ColStr = "";
 
                  if(ColPosition == 5)
                  {
                     ColStr = LineStr.Substring(EndPosition + 1);
                  }
                  else
                  {
                     EndPosition = LineStr.Find(",",StartPosition);
                     ColStr      = LineStr.Substring(StartPosition, EndPosition - StartPosition);
                  }
 
                  if(ColPosition == 1)
                  {
                     CopyNode.Name1= ColStr;
                  }
                  else if(ColPosition == 2)
                  {
                     CopyNode.Name2= ColStr;
                  }
                  else if(ColPosition == 3)
                  {
                     CopyNode.Name3= ColStr;
                  }
                  else if(ColPosition == 4)
                  {
                     CopyNode.Name4= ColStr;
                  }
 
                  ColPosition   = ColPosition + 1;
                  StartPosition = EndPosition + 1;
 
               }
 
            }
                Line      = Line + 1;
                StartLine = EndLine + 1;
         }
  
  }
   
}

 

CSV파일을 첨부파일을 통해 업로드시 해당 데이터를 C4C에 저장하기 위한 로직입니다.

용도에 따라 수정하여 사용합니다.