コミュニティ

• 

  Permanently deleted user

  • 2016年12月19日 17:56

  There is an article and sample provided in the ABBYY knowledgebase titled "Using Custom Export in Flexicapture Projects". It doesn't export to ODBC, but it does provide a sample on how to identify fields and export them. The sample would need to be modified to export to ODBC.

  いいえ 0 はい
• 

  Permanently deleted user

  • 2016年12月20日 09:01

  Hi Adrian,

   

  Thank you for your reply. My issue I don't know how to work with ODBC in FlexiCapture.

  I presume normal way it done in Visual Basic is not applicable ? (I'm not an expert in VB):

  '------------------ here is example I found on internet--------------------

  Set WSNet = CreateObject("WScript.Network")
  
  varUserName = WSNet.UserName
  'varUserdomain = WSNet.UserDomain
  'varNBName = WSNet.ComputerName
  
  Set WSNet = Nothing
  
  Set MyConn = CreateObject("ADODB.Connection")
  Set RS = CreateObject("ADODB.Recordset")
  
  MyConn.open = "DRIVER={SQL Server};"_
  & "SERVER=SQLSERVER;"_
  & "DATABASE=PKTime;"_
  & "OPTION=35;"
  
  sql_query = "UPDATE dbo.Users SET LoginStatus ='" & "LoggedIn" & "' WHERE LoginID ='" & varUserName & "'"
  
  'ex: sql_query = "UPDATE dbo.Users SET LoginStatus ='" & "LoggedIn" & "' WHERE LoginID ='" & "PaulK" & "'"
  'ex for logout: sql_query = "UPDATE dbo.Users SET LoginStatus ='" & "LoggedOut" & "' WHERE LoginID ='" & varUserName & "'"
  'ex: sql_query = "UPDATE dbo.Users SET LoginStatus ='" & "LoggedOut" & "' WHERE LoginID ='" & "PaulK" & "'"
  
  MyConn.Execute sql_query
  MyConn.Close
  
  Set RS = Nothing
  Set MyConn = Nothing

   

  いいえ 0 はい
• 

  Permanently deleted user

  • 2016年12月20日 15:29

  First, the sample you found is VBScript, not VB.NET. And you do not want to do it this way as it leaves the code open to SQL Injection attacks. A better example is here: http://stackoverflow.com/questions/12634516/how-can-i-insert-data-into-sql-server-using-vbnet

  Second, do you have a reason for wanting to do this in a custom script? You can configure an export to an ODBC database in the "Document Definition > Export Settings" with no custom code required.

  What version of Flexicapture are you using?

  いいえ 0 はい
• 

  Permanently deleted user

  • 2016年12月21日 10:15

   Hi Adrian

  I'm quite new to Flexicapture.

  It's 11.04 Standalone.

  I just need push line items to ODBC database, not the rest of the fields, and process rest of the fields into custom formatted XML file. I done the XML part already, now looking into line items.

  いいえ 0 はい
• 

  Permanently deleted user

  • 2016年12月21日 15:06

  Ok, you should then be able to set up a second export to ODBC for the detail lines. I would suggest only trying to custom script when absolutely necessary.

  Document Definition > Export Settings > Add > Export to ODBC ... use the appropriate OLE DB provider. The setup wizard will let you configure what fields you want to export, and what tables to map them to.

  I hope this was helpful.

  いいえ 0 はい

サインインしてコメントを残してください。