Community

• 

  Vladimer Nikuradze

  • July 08, 2024 11:20

  If I understand you correctly, then after processing the documents you need the information to be recorded in the database, right?

  using System;
  using System.Data.SqlClient;
  
  string connectionString = @"Data Source=;Initial Catalog=ExportDocument;Integrated Security=True";//In source add your DB source
  
  /*
  if you don't have this field ServiceField then you can remove it and change the code a little
  I created it to get the name of the document from the path, well, in this case I use it to check in the database. If there is already an existing sing in the database, then there is no need to add a value
  */
  string selectStatement = "SELECT COUNT(*) FROM Invoice WHERE Service_Field = @Value8";
  string insertStatement = "INSERT INTO Invoice (InvoiceNumber, Service_Field) VALUES (@Value1, @Value8)";// check your table and columns
  
  string value1 = "";
  /*
  ...
  ...
  */
  string value8 = "";
  
  /*
  here I have a check for a specific document definition since my invoices are divided into categories
  */
  if (Document.DefinitionName=="G2_ინვოისი_ლიმონათი")// add your document definition
  {
      value1 = Document.Field("Invoice\\InvoiceNumber").Text; //for example InvoiceLayout//InvoiceNumber
      /*
      ...
      ...
      */
      value8 = Document.Field("Invoice\\Service Field").Text; //for example InvoiceLayout//ServiceField
      
      using (SqlConnection connection = new SqlConnection(connectionString))
      {
          connection.Open();
  
          using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
          {
              selectCommand.Parameters.AddWithValue("@Value8", value8);
  
              int existingRowsCount = (int)selectCommand.ExecuteScalar();
  
              if (existingRowsCount == 0)
              {
                  using (SqlCommand insertCommand = new SqlCommand(insertStatement, connection))
                  {
                      insertCommand.Parameters.AddWithValue("@Value1", value1);
                      insertCommand.Parameters.AddWithValue("@Value8", value8);
  
                      insertCommand.ExecuteNonQuery();
                  }
              }
          }
      }
  }

  

  

  

  In general the script works like this.
  After processing the documents, if the database already has a record from this document and this is checked through the service field, then a new record will not appear, and if there is no such service field, then a new record will be added.

  The screenshot shows how I sent 2 different document definitions for processing, one condition worked and wrote a record to the database, and the other document had a different definition for which I did not have a condition and, accordingly, there is no record either. But at the same time, the record that was added, and if I submit this document for processing again, then after recognition the record will not be added to the database.

  I hope I understood you correctly and if any problems arise, I will try to help you

  No 0 Yes
• 

  Vladimer Nikuradze

  • July 08, 2024 11:38

  By the way, it would be better to get the base path through Project->Properties->Environment Variables 
  since you will add the base path in one place and call it wherever you need it, and if you transfer the project to another server, you will have to change the path only in one place

  

  Here are the links for this method
  1.https://help.abbyy.com/en-us/flexicapture/12/distributed_administrator/environment_variables/
  2.https://support.abbyy.com/hc/en-us/articles/360012558260-How-to-use-environment-variables-with-FlexiCapture
  3.https://support.abbyy.com/hc/en-us/articles/5019943260819-How-to-access-project-environment-variables-from-the-stage-script
  4.https://support.abbyy.com/hc/en-us/articles/15242213538963-How-to-use-an-environment-variable-to-set-an-export-path
  5.https://support.abbyy.com/hc/en-us/articles/10744746851347-How-to-configure-database-connection-via-environment-variables
  5.https://support.abbyy.com/hc/en-us/articles/5517387769875-How-to-use-environment-variable-as-a-path-to-the-Hot-Folder-in-the-Image-Import-Profile

  No 0 Yes

Please sign in to leave a comment.