Monday, December 28, 2009

DXL + XSL -> XFDF -> PDF

We started to use XFDF approach when create PDF file. I have to say that FDF is nothing, XFDF is power :). XFDF approach much easier to use and to debug.

For debugging I used Firefox plug-in XSL Results it works good.

So what steps you have to do if you want to use this approach.

  1. get NotesDocumentCollection of document you want to export to PDF
  2. export it using NotesDXLExporter to dxl file
  3. get NotesXSLTransformer and use it :)
  4. check result

you may have problem if you are not familiar with XSL. There are many good sites where you can read about it.

Here is an example on openntf

Here is my first example of XSL for generation XFDF file. It can help to somebody.





Related articles about creating PDF files

Thursday, December 24, 2009

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?

Related articles about creating PDF files

Tuesday, December 22, 2009

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!

UPDATE: We have decided to close the website due to very low interest to skytus.

Friday, December 18, 2009

do you want to re-configurate your server?

I hope everybody knows this, but I just tried it first time in my life (before I only read about this), so just confirm that it is work :)

find notes.ini in domino directory

- make local copy (who know -) probably it will help later)
- remove all line except these:

[Notes]
NotesProgram=d:\IBM\Lotus\Domino
Directory=d:\IBM\Lotus\Domino\data
KitType=2
InstallType=1


fix path and run domino then, now you can manage it again from "draft"

Thursday, December 17, 2009

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.