1
Automation Interface, Add-Ins and Tools / Re: Scripts do not run - V15
« on: November 05, 2019, 07:57:41 am »
Unfortunately I have the same issue with a new EA 15 installation on my Windows 10 notebook. Would be grateful for any tip.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Sub createBaseline()
Dim eaConn As New EAConnector
Dim baselinePackGUID As String
Dim docGUID As String
Dim baselineVersion As String
Dim baselineName As String
Dim baselineNotes As String
Dim baselineContent() As Byte
Dim insertSql As String
Dim strFilePath As String
Dim objStream As New ADODB.Stream
Const adTypeBinary = 1
baselinePackGUID = "{CFABA5B2-D733-4b80-B761-EECDCA09BB45}"
baselineVersion = "1.0.1"
baselineName = "Merge Test"
baselineNotes = "Notes of the Baseline"
strFilePath = "C:\temp\zip\txt.zip" 'This is the path to the file on disk.
'Set objStream = CreateObject("ADODB.Stream")
objStream.Open
objStream.Type = adTypeBinary
objStream.LoadFromFile strFilePath
baselineContent = objStream.Read
docGUID = generateEA_GUID
insertSql = "INSERT INTO t_document " & _
"(DocID, DocName, ElementID, Version, Notes, BinContent, DocDate, ElementType, DocType,Style,isActive)" & _
" VALUES ('" & docGUID & "','" & _
baselineName & "','" & _
baselinePackGUID & "','" & _
baselineVersion & "','" & _
baselineNotes & "','" & _
EncodeBase64(baselineContent) & "'," & _
"Now(),'" & _
"Package','Baseline','Zip=1;',0)"
Debug.Print (insertSql)
Call eaConn.getRepository.Execute(insertSql)
objStream.Close
End Sub 'createBaseline
CREATE TABLE [SixidLogfile]
should be: CREATE TABLE [ana].[SixidLogfile]