New version of Skytus is available!

Hi ! I'm glad to introduce new version of Skytus :). Hope many of you already read/heard about it and some of you already tried to use it.

What did we do in current version (0.3.0.)? are you interested? Hope you are :). Here is short list of main things we did:

- loading/unloading skype's add-in manager (it does supporting of skype status in real time) much more correctly. We got couple reports (special thanks to Tony Austin) about crashes of LN from time to time after installing Skytus. Hope there are no any issues in that area anymore.
- we've added new feature - synchronization. now users will be able to sync already created contacts in PAB with contacts in Skype, hope many of you will find it useful.
- very important thing we did also is Skytus SDK, that's is really awesome thing! from my point of view. We will add first version of sdk to download page later (hope next week) when finish msi installation for SDK. I will post about possibilities of SDK later in next post.
- speaking about SDK I have also admit that we migrated skytus product to it, so now it is done in more right way.

Now I'm thinking about next steps:
- should we concentrate on new functionality of skytus and continue to improve it? we could probably do recording of voice or improve mail database with skytus' things?
- should we freeze new functionality of skytus for short period and do fixes only and see how it is going on? and in the same time start to do new integration with another AI/tools/product (yep, we already have some ideas what to integration with LN).

What I would really want is to hear any ideas/comments/suggestions from you, that's would be really helpful for us.test link

New version of Skytus 0.2.0 is available for download !

The major changes are installation and unistallation. Now this is MSI installation (before it was NSF, and I have to say I do not liked it). Now it will be more native for user to install and uninstall Skytus. There are also some changes/updates for functionality.

So go on and try it :)

Download Skytus

We made new version of Skytus 0.1.15. it is available for download now !

What do we have in new version?
- fixed issues we found in last build (0.1.14).
- added some more stability to LN when it does not have Skype installed on it.
- we made many tests with this add-on so it should be much more stable.

So if you still did not try our tools, do it now: Skytus !

We will be happy for any comments/suggestions!

How to check all content-type values?

I have some tasks where I have to open xml document in related application, so I had to know the content type values. I did not know that it could be checked in regedit :-)

so here is a way how we can look at it

HKEY_CLASSES_ROOT \ Mime \ Database \ Content Type \

f.x. for excel it will be like this

Print {Content-Type:application/vnd.ms-excel}
Print {Cache-Control: public, must-revalidate}
Print {Expires: Sat, 26 Jul 1997 05:00:00 GMT}
Print xml_output

Way to show FLV into you web pages

If you want to show SWF/FLV files onto you pages I would propose to use swfobject.js library. It's free and open. Here is a link to their site.

Here is an example of code how to do this


Let me do some comments for new people.

1) First of all I have to say that I used 1.5 version of swfobject instead of last one swfobject2.2. I'm planning to update it to 2.2 very soon. So please use 2.2 instead of 1.5, but anywhere approach is very similar.

- as you see DIV with ID FLV is used to be replaced with code that swfobject will generate to show SWF/FLV video.
- preview.swf is a player use want to use to show FLV video.
- your.flv is a FLV file you want to show.

Use XFDF approach insted of FDF when create PDF file

My fellow just shown me that my approach that I posted on my blog couple weeks ago
how to create PDF using FDF is old one :)
It is shame for me :) that I did not find XFDF approach.

Anywhere from now I would recommend to use XFDF approach when you want to generate PDF file. The idea is similar to FDF but done via real XML. It is much easy to work with it and it is readable :)

Here is simple XFDF file, it demonstrate how it looks.



As you see it is really simple XML file and it will use http://ip/pdf_form.pdf file to show data from XFDF file.

Now I am looking for 'opposite way'. Let's say I'm opened PDF file using XFDF approach and add some values to this PDF file. How I can get export this data back then to XFDF file? Does anybody have such experience?

Lotus Notes integration with Skype

Hi guys,

Let me introduce our new product Skytus - live integration Lotus Notes with Skype.

I would like to share it to our community :) and want to get feedback as much as possible as I'm one of developer. I'm interesting about each opinion!

We used C++ and Lotus Notes to make this product. Of course it is only beta and there are some issues there, we will fix it later.

Actually this is only demonstration of our possibilities and knowledge in Lotus Notes Integration area, so if you have any question regarding integration with Lotus Notes, you can contact us directly!

here is a site: http://skytus.com/
here is a download page: http://skytus.com/download

VIEW:


CONTACT:


Thanks!

How to do authentication in google analytics in LN

Here is an example how to do authentication in google analytics. This example was written not by me (author is Mikael Thuneberg), I just would like to share it here as well, because this example helped me a lot.

There are many example in web with VBA example to get data from Google Analytics (I work on that topic as well).

Public Function getGAauthenticationToken(email As String, password As String)
'Fetches GA authentication token, which can then be used to fetch data with the getGAdata function
'Created by Mikael Thuneberg

Dim objhttp As Variant
Dim authToken As Variant

Dim URL As String
Dim tempAns As String
Dim authResponse As String
Dim ch As String

Dim CurChr As Integer
Dim authTokenStart As Integer

If email = "" Then
getGAauthenticationToken = ""
Exit Function
End If

If password = "" Then
getGAauthenticationToken = "Input password"
Exit Function
End If

'hex password
CurChr = 1
Do Until ((CurChr - 1) = Len(password))
ch = Mid(password, CurChr, 1)
Select Case Asc(ch)
Case 48 To 57, 65 To 90, 97 To 122
tempAns = tempAns & Mid(password, CurChr, 1)
Case 32
tempAns = tempAns & "%" & Hex(32)
Case Else
tempAns = tempAns & "%" & Format(Hex(Asc(Mid(password, CurChr, 1))), "00")
End Select

CurChr = CurChr + 1
Loop
password = tempAns
'/

On Error GoTo errhandler

' authentication
Set objhttp = CreateObject("MSXML2.ServerXMLHTTP")
URL = "https://www.google.com/accounts/ClientLogin"
objhttp.Open "POST", URL, False
objhttp.setRequestHeader "Content-type", "application/x-www-form-urlencoded"
objhttp.send ("accountType=GOOGLE&Email=" & email & "&Passwd=" & password & "&service=analytics&Source=tool-1.0")

authResponse = objhttp.responseText

If InStr(1, authResponse, "BadAuthentication") = 0 Then
authTokenStart = InStr(1, authResponse, "Auth=") + 4
authToken = Right(authResponse, Len(authResponse) - authTokenStart)
getGAauthenticationToken = authToken
Else
getGAauthenticationToken = "Authentication failed"
End If

basta:
Exit Function
errhandler:
getGAauthenticationToken = "Authentication failed"
Resume basta
End Function

Here is another example, it gets real data from Google Analytics.

Create PDF / FDF in Lotus Notes using LS

I had task where I should create PDF file from template and fill fields by values from documents
So what did I do?

I spoke with my brother :-) he recommended to use FDF Toolkit For Windows, instead of iText approach that I used before, and I have to say that it is very cool approach, it is much better at least for me. Instead of generation new PDF file we just export data to FDF file and link it with PDF template and that's all, so our FDF will show data using PDF form/template. -> No Java required and now no non-supported libraries.

Here is a small instruction how to do this:
1) register FDFACX.DLL (for this I copied FdfTk.dll and FDFACX.DLL to windows\system32, but I believe there is better way)
regsvr32 C:\WINDOWS\system32\FDFACX.dll

2) example of code now (it is from Adobe)

USING THE FDF TOOLKIT IN LOTUSSCRIPT
Option Public

Sub Initialize
'
' Set up for using the FDF Toolkit for ActiveX
'
Dim FdfAcX As Variant
Dim outputFDF As Variant
Dim sPdfFileName As String, sFdfFileName As String, sFilePath As String
Set FdfAcX = CreateObject("FdfApp.FdfApp")
Set outputFDF = FdfAcX.FDFCreate()
'
' % REM
'
' Change these paths to reflect your server environment
' Ideally, you could use a Lotus Notes profile document to store this
' information.
'
' Below are the three options for storing the PDF that was discussed in
' the documentation for this application.
'
' Option 1 : UNC Directory Share
' This option oddly asks if you would like to save on close.
'
' sPdfFileName = "\\Mage\domdata\domino\html\pdf\panarama.pdf"
'
' Option 2 : Store in a Lotus Notes Page element
'
sPdfFileName = "http://mage/pdf/panarama.nsf/PDFs/$file/panarama.pdf"
'
' Option 3 : Store in the Domino HTML directory
'
' REM %
'
' sPdfFileName = "http://mage/pdf/panarama.pdf"
sFilePath = "d:\domdata\domino\html\pdf\tmp\"
'
' Set up for getting Lotus Notes information
'
Dim session As New NotesSession
Dim contextDoc As NotesDocument
Dim dateTime As NotesDateTime
Dim tempNumber As Single
Dim rounded As Integer
Dim fileName As String
Set contextDoc = session.documentContext
'
8 Integrating Adobe Acrobat FDF
with Lotus Domino
' This will create a random number between 0 and 100.
' The number will give
' us a good chance of not temporarily having the same file name in the tmp
' directory at the same time. The file will briefly be in the tmp
' directory,
' attached to the Notes document and then deleted.
'
Randomize
temp = Rnd
rounded = Round((temp * 100), 0)
fileName = Cstr(rounded)
sFdfFileName = sFilePath & fileName & ".fdf"
'
' FDFSetValue will set the value you pass it. See page 139 of the
' FDF Toolkit Overview and Reference.
'
outputFDF.FDFSetValue "FirstName", contextDoc.FirstName(0), False
outputFDF.FDFSetValue "MidInit", contextDoc.MidInit(0), False
outputFDF.FDFSetValue "LastName", contextDoc.LastName(0), False
'
' Get the value of the date fields. The DateOnly property
' returns a string.
'
Set dateTime = New NotesDateTime( contextDoc.HireDate(0) )
outputFDF.FDFSetValue "HireDate", dateTime.DateOnly, False
Set dateTime = New NotesDateTime( contextDoc.ModDate(0) )
outputFDF.FDFSetValue "ModDate", dateTime.DateOnly, False
'
outputFDF.FDFSetValue "Address1", contextDoc.Address1(0), False
outputFDF.FDFSetValue "Address2", contextDoc.Address2(0), False
outputFDF.FDFSetValue "City", contextDoc.City(0), False
outputFDF.FDFSetValue "State", contextDoc.State(0), False
outputFDF.FDFSetValue "ZipCode", contextDoc.ZipCode(0), False
outputFDF.FDFSetValue "Country", contextDoc.Country(0), False
'
outputFDF.FDFSetValue "MAddress1", contextDoc.MAddress1(0), False
outputFDF.FDFSetValue "MAddress2", contextDoc.MAddress2(0), False
outputFDF.FDFSetValue "MCity", contextDoc.MCity(0), False
outputFDF.FDFSetValue "MState", contextDoc.MState(0), False
outputFDF.FDFSetValue "MZipCode", contextDoc.MZipCode(0), False
'
outputFDF.FDFSetValue "HomePhone", contextDoc.HomePhone(0), False
outputFDF.FDFSetValue "WorkPhone", contextDoc.WorkPhone(0), False
'
outputFDF.FDFSetValue "Emer1Contact", contextDoc.Emer1Contact(0), False
outputFDF.FDFSetValue "Emer1Phone", contextDoc.Emer1Phone(0), False
outputFDF.FDFSetValue "Emer2Contact", contextDoc.Emer2Contact(0), False
outputFDF.FDFSetValue "Emer2Phone", contextDoc.Emer2Phone(0), False
'
' Tell it which file we're writing to and do a save.
'
outputFDF.FDFSetFile sPdfFileName
outputFDF.FDFSaveToFile sFdfFileName
'
' Always close your open FDF files.
'
outputFDF.FDFClose
ADOBE FDF TOOLKIT
User Guide
9
'
' This will attach the FDF file we just closed to our Notes document
' and then delete it from the tmp directory.
'
Call MoveFdfToAttachment(contextDoc, sFdfFileName)
End Sub
Public Function MoveFdfToAttachment(doc As NotesDocument, fileName As
String) As Integer
'// move each attachment to a rich text field.
Dim attachItem As New NotesRichTextItem(doc, "fdfAttachment")
Dim attachObj As notesEmbeddedObject, newObjName As String
Call attachItem.EmbedObject(EMBED_ATTACHMENT, "", fileName, "")
Kill fileName
MoveFdfToAttachment = True
End Function

check if Bookmark or Name is exists in Word/Excel application

I did not have tasks with export data from LN to word/excel/pdf for 1 years probably. My today's task was easy, I had to export data from LN to xml, processed it using xsl, walk through resulting xml and export everything to word/excel. Then I had to copy values from resulting xml to word/excel's temlpate using bookmarks (in excel it is names).

Here is an example how to check bookrmark/names in word/excel (because before I did not have experience with Excel's names)

excel approach I got from this link

Function NameExists(TheName as String, obj, formType as String) As Boolean

NameExists = False

Select Case formType
Case "word":
if obj.activedocument.Bookmarks.Exists(TheName) Then
NameExists = true
End If
Case "excel"
On Error Resume Next
NameExists = Len(obj.names(TheName).Name) <> 0
End Select

End Function