Read file and insert into bank

Robson Amaral

I need to read a file and save the Schedule Date field, Document Value, Protocol, Barcode, Record: record date and time, how could it be doing? Here is my code attached. The file can be opened in txt, but I can not attach it. Within this file I have several vouchers, I left only two as a basis for the explanation. I need help out of courtesy.

using System;
using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace ServiceProcessingVouchers
{
public class ProcessReturn
{
private static object objReader;
private static void Main (string [] args)
{
List <string> Values found = new List <string> ();
try
{
string [] File = System.IO.Directory.GetFiles (@ "\\ S3A601 \ ftp @ sefarix \ are \ Output_SDPJ \ test", "* .cpv");
foreach (var item in File)
{
string [] line = item.Split (new [] {''}, StringSplitOptions.RemoveEmptyEntries);
if (line.Length> = 3)
{
values found .Add (line [2]);
}
}
}
catch (Exception ex)
{
}
}
}
}

File information:

------------------------------------------------

CONTAK TECHNOLOGY SA

--------------CONTAK CORPORATIVO--------------

Electronic Payments and Transfers

PAYMENT: JUDICIAL DEPOSIT

------------------------------------------------

Client: José Frederico Costa e Silva

Enc Ger APLIX - Cta C

Account: 5.535.0125

Agency: 104-Central

Cod. Bars: 898800000078 000002130424

017092700009 270400028680

Agreed: JUDICIAL DEPOSIT

Date Scheduling: 29/09/2017

Document Value: R$500,00

Protocol: 94651134

Source: CORPORATE CONTAK

================================================

EFFECTIVE TRANSACTION

================================================

Record: 29/09/2017 11:21:29 /local/home/tef/d/20170929/sfcg012.

Emission.: 30/09/2017 09:54:19

------------------------------------------------

CONTAK TECHNOLOGY SA

--------------CONTAK CORPORATIVO--------------

Electronic Payments and Transfers

PAYMENT: JUDICIAL DEPOSIT

------------------------------------------------

Client: José Afrânio

Enc Ger APLIX - Cta C

Account: 5.535.0125

Agency: 104-Central

Cod. Bars: 898800000078 000002130424

017092700009 270400028680

Agreed: JUDICIAL DEPOSIT

Date Scheduling: 29/09/2017

Document Value: R$509,00

Protocol: 94651134

Source: CORPORATE CONTAK

================================================

EFFECTIVE TRANSACTION

================================================

Record: 29/09/2017 11:21:29 /local/home/tef/d/20170929/sfcg012.

Emission.: 30/09/2017 09:54:19

------------------------------------------------

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Robson Amaral8y ago
Yes Nitin, of course I care, so much I tried to adapt the suggestion that you proposed here, so much that I am very grateful for it, even because all help is welcome, not demeaning the other colleagues, thank you all, and on top of your suggestion I also tried to work a different logic to see if I could read the data I need in each line, but in some files I can read yes, but there are files that those fields that need to end up appearing on different lines, that's where the problem, my code was based on the number of rows until I got the item I need to read, based on its logic and after numerous changes, it was as follows:

This is my method that I use to read the file extension and generate the start and end log of the service execution:
public class ReadingTxt
    {
        static Thread _ThreadVerification;

        static string FoldersFile = "C: \ CommonIndex \ ProofPants";
        static string FileFilesImported = @ "C: \ Provisional Import \ ProofImported";
        static string FolderLogLog = @ "C: \ CommonComports \ Log";

        public static void Read ()
        {
            // creation of the verification thread and its execution
            _ThreadVerification = new Thread;
            _ThreadVerification.Start ();
        }


// will check whether or not to execute the method every 1 hour
        private static void CheckTime ()
        {
            while (true)
            {
                if (DateTime.Now.Hour == 10) // If it is 07:00 AM in the morning
                {
                    InsertLog ("");
                    InsertLog ("\ n HOME ::" + DateTime.Now.ToShortDateString () + "" + DateTime.Now.ToShortTimeString ());

                    try
                    {
                        DirectoryInfo dirPending = new DirectoryInfo (PendingPlacesFolder);

                        // list files in the current directory
                        foreach (FileInfo file in dirPending.GetFiles ())
                        {
                            if (file.Extension == ".cpv")
                            {
                                Process File (file.FullName, file.Name);
                            }
                        }

                    }

                     catch (Exception)
                    {
                        throw;
                    }
                    finally
                    {
                        InsertLog ("\ n FIM ::" + DateTime.Now.ToShortDateString () + "" + DateTime.Now.ToShortTimeString ());
                    }
                }

                Thread.Sleep (3600000); // 3,600,000 milliseconds equals 1 hour (Standby)
            }
        }
And here is the method used to read the data I need in each line of the file:
private static void ProcessFile (string FullPathFile, string FileName)
        {
            try
            {

                bool Move = true;
                string [] StringLine = System.IO.File.ReadAllLines (FullPathFile);
                string CodBar = "";

                for (int line = 0; line
                {
                    string DateScheduling = "";
                    string DocumentValue = "";
                    string Protocol = "";
                    string Record = "";
                    string Emission = "";

                    #region Retrieve the Barcode

                    if (String [line] .Contains ("Bar Cod:"))
                    {
                        CodBar + = String [line] .Replace ("Cod. Bars:", "");
                        line + = 2;
                    }
                    if (CodBar! = "")
                    {
                        CodBar + = String [line];
                        CodBar = CodBar.Replace ("", "");
                    }

                    #endregion

                    if (CodBar == "")
                        continues;

                    line + = 6;

                    #region Scheduling Date

                    if (String [line] .Contains ("Delay:"))
                    {
                        DateScheduling + = String [line] .Replace ("Dt.Scheduling:", "") .Replace ("", "");
                    }

                    #endregion

                    line + = 2;

                    #region Document Value

                    if (String [line] .Contains ("Vlr.Document:"))
                    {
                        DocumentValue + = String [line] .Replace ("Vlr.Document:", "") .Replace ("", "");
                    }

                    #endregion

                    line + = 2;

                    #region Protocol

                    if (StringLine[line].Contains("Protocol:"))
                    {
                        Protocol += StringLine[line].Replace("Protocol:", "").Replace(" ", "");
                    }

                    #endregion

                    line += 12;

                    #region Register

                    if (StringLine[line].Contains("Register:"))
                    {
                        Register += StringLine[line].Replace("Register:", "");
                    }

                    #endregion

                    line += 2;

                   #region Emission

                    if (String [line] .Contains ("Emission:"))
                    {
                        Emission + = String [line] .Replace ("Emission:", "");
                    }

                    #endregion

                    // Search Bar Code, here I access another method that I use the barcode of the files to check if it is in the table of the procInter database, from here down everything works ok.
                    string CodProcInter = GetCodProcInter (CodBar)


if (! string.IsNullOrEmpty (CodProcInter))
                    {
                        if (! CodBarInserted (CodBar))
                        {
                            // Insert Bar Code
                            bool inserted = BankInfo (CodProcInter, CodBar, DateScheduling , DocumentValue, Protocol, Register, Emission);
                        }
                        else
                        {
                            // Bar Code Already Inserted
                            Move = false;
                            InsertLog ("\ n Already Exists ->" + CodBar);
                        }
                    }
                    else
                    {
                        // Barcode not available in table -> sdpj_proc_inter
                        Move = false;
                        InsertLog ("\ nCode Bar Not Available ->" + CodBar);
                    }

                    / Clear Variables
                    CodBar = "";
                }

                if
                {
                    MoveFile (FileName);
                }

            }
            catch (Exception ex)
            {
                throw;
            }
        }
If you realize I'm jumping from line until I get to the field I need to read, but there are .cpv files that are generated that end up coming in different lines, then the file is not read, I'd like to know if it's possible to take advantage of my logic and see a means to read only the fields I need instead of programming to read by line Nitin Sontakke?
Well, that's all I need to finish, but I do not know what can be done. In your code you use StartsWith, but I can not implement it in the logic I did.

Could you please help me again?
+1
Nitin Sontakke8y ago
If you just care fully read whatever Željko Peric and myself are trying to convey you see that that's the best can be done.

As you will see my code, you will realise that all I am doing is trying to make sense out of the text file.

There is no magic here. There are several assumptions made in my code. If those assumptions turns out to be false, you obviously will have to modify the code so as to adhere to the incoming file.

Unfortunately, I couldn't identify the line of the error you stated.

The file you originally gave and have show below has word "Cod. Bars:". But if you see the debug image, it has "Cod. Barras:", which are two different things. Maybe you will need to add this OR that while checking for those words.

Remember, if your source file changes, your assumptions fail.

Hope you understand.
+1
Robson Amaral8y ago
Nitin Sontakke,
I made the additions of your code in my project but it did not work very well, I'm getting the following message:

System.NullReferenceException: 'Object reference not set to an instance of an object.'

StackTrace:
in ImportValue.ReleaseTxt.ParseTextFile (String FullPathFile) in D: \ SVN \ SDP \ SDJ \ branches \ SJ-Import-Proxy Import-v1.0.0 \ Importing Proxy \ Importing Proxy \ ReadingTxt.cs: line 116
   () in D: \ SVN Repository \ SDP \ SDJ \ branches \ SJ-Provisional Import-v1.0.0 \ ProxyCount \ ProxyCount \ ReadingTxt.cs: line 58
   in System.Threading.ThreadHelper.ThreadStart_Context (Object state)
   in System.Threading.ExecutionContext.RunInternal (ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   in System.Threading.ExecutionContext.Run (ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   in System.Threading.ExecutionContext.Run (ExecutionContext executionContext, ContextCallback callback, Object state)
   in System.Threading.ThreadHelper.ThreadStart ()
TargetSite:
{System.Collections.Generic.List`1 [Provisible Import.ReadText + ProofInfo] ParseTextFile (System.String)}
System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
It is this information that I acquired when I was compiling my application, I do not know if there is a better way to read this file, since I need to read the following fields and get the value of each field:
CodBars Payday
Document Value
Protocol
Record
Emission
This data can come in several lines of the file randomly, because it is a voucher, I have to get and store the information of each field of these items I mentioned above, but it does not work at all: It also follows the structure of this voucher.
Maybe I'm complicating a way to be properly programmed, if someone has more experience and wants to contribute a better practice to take this reading, thank you:
+1
Nitin Sontakke8y ago
Given below is a piece of code which might work great as a starting point. Feel free to modify to fit to your requirement.
public class VoucherParser
{
  public static List ParseTextFile(String Filename)
  {
    List returnValue = new List();
    String[] lines = File.ReadAllLines(Filename);
    VoucherInfo vi = null;
    Boolean InBarCodes = false;
    const String NEW_RECORD = "Electronic Payments and Transfers";
    const String SCHEDULE_DATE = "Date Scheduling:";
    const String DOCUMENT_VALUE = "Document Value:";
    const String BAR_CODES = "Cod. Bars:";
    const String AGREED = "Agreed:";
    const String RECORD_DATETIME = "Record:";
    foreach (String line in lines)
    {
      if (line.StartsWith(AGREED))
      {
        InBarCodes = false;
        continue;
      }
      if (line == NEW_RECORD)
      {
        if (!(vi == null))
          returnValue.Add(vi);
        vi = new VoucherInfo();
        InBarCodes = false;
      }
      if (line.StartsWith(SCHEDULE_DATE))
      {
        String datePart = line.Split(new Char[] { ':' })[1].Trim();
        DateTime result = DateTime.ParseExact(datePart, "dd/MM/yyyy", CultureInfo.InvariantCulture);
        vi.ScheduleDate = result;
        continue;
      }
      if (line.StartsWith(DOCUMENT_VALUE))
      {
        String valuePart = line.Split(new Char[] { ':' })[1].Trim();
        Double result = Double.Parse(valuePart.Replace("R$", "").Replace(",", "."));
        vi.DocumentValue = result;
        continue;
      }
      if (line.StartsWith(BAR_CODES))
      {
        String barCodePart = line.Split(new Char[] { ':' })[1].Trim();
        vi.BarCodes.Add(barCodePart);
        InBarCodes = true;
        continue;
      }
      if (InBarCodes)
      {
        vi.BarCodes.Add(line.Trim());
      }
      if (line.StartsWith(RECORD_DATETIME))
      {
        String[] lineParts = line.Split(new Char[] { ' ' });
        String datePart = lineParts[1] + " " + lineParts[2];
        DateTime result = DateTime.ParseExact(datePart, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
        vi.RecordDateTime = result;
      }
    }
    if (!(vi == null))
      returnValue.Add(vi);
    return returnValue;
  }
}

public class VoucherInfo
{
  public VoucherInfo()
  {
    BarCodes = new List();
  }
  public DateTime ScheduleDate { get; set; }
  public Double DocumentValue { get; set; }
  public List BarCodes { get; set; }
  public DateTime RecordDateTime { get; set; }
}
There is a plenty of scope for improvement.
+2
Robson Amaral8y ago
Thanks my friends.
+2
Željko Perić8y ago
Hello Robson Amral,
The enclosed text document represents an ordinary I/O sequential file, containing data organized as records, You called it vouchers. All You have to do is open file, read data, record by record, and extract only those data from record that You need for further processing, saving to different file.

By analizing text I suppose that this would be one complete data record :

------------------------------------------------

CONTAK TECHNOLOGY SA

--------------CONTAK CORPORATIVO--------------

Electronic Payments and Transfers

PAYMENT: JUDICIAL DEPOSIT

------------------------------------------------

Client: José Frederico Costa e Silva

Enc Ger APLIX - Cta C

Account: 5.535.0125

Agency: 104-Central

Cod. Bars: 898800000078 000002130424

017092700009 270400028680

Agreed: JUDICIAL DEPOSIT

Date Scheduling: 29/09/2017

Document Value: R$500,00

Protocol: 94651134

Source: CORPORATE CONTAK

================================================

EFFECTIVE TRANSACTION

================================================

Record: 29/09/2017 11:21:29 /local/home/tef/d/20170929/sfcg012.

Emission.: 30/09/2017 09:54:19

You should use StremReader class and it's methods for acessing data inside sequential data base file, eg. *.txt document containing data. Read all about it at this url :

https://msdn.microsoft.com/en-us/library/system.io.streamreader(v=vs.110).aspx

There are many solutions for getting data from records inside data base and one of them is to create structure that represents one data record and then to use it for declaring variable for loading data from data base. If You know how many records are inside data base You could declare Array of records instead. read all about struct at this url :

https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/struct
public struct record
        {
            public string text_line1;
            public string text_line2;
            public string text_line3;
            public string text_line4;
            public string PAYMENT;
            public string text_line5;
            public string CLIENT;
            public string text_line6;
            public string ACCOUNT;
            public string AGENCY;
            public string COD_BARS;
            public string AGREED;
            public string DATE_SCHEDULING;
            public string DOCUMENT_VALUE;
            public string PROTOCOL;
            public string SOURCE;
            public string text_line7;
            public string text_line8;
            public string text_line9;
            public string RECORD;
            public string EMISSION;
        }
Declare variable Client_Data type of record :
public record Client_Data = new record();
and acess record data as instance of Client_Data , exmpl:
string client = Client_Data.CLIENT;
To declare array of records do this :
public record [] Client_Data = new record[100];
and acess record data as instance of Client_Data , exmpl:
string client = Client_Data[1].CLIENT;
From this point it is easy to create solution for saving wanted data to separate txt file.

All the best,
Željko Peric
+1

Read file and insert into bank

Nitin Sontakke,