michio.ch

so its been a while, since i lastly added a new post to this blog… and actually i was supriced, that it was still there.

So its time to reactivate it. But it will be different… the main focus will still be the same… so only a notebook for things i run into, and want to document. own projects and inspiration. Mainly only for me…

so what is different? me 🙂

i dont work as a programmer anymore… so no work related coding stuff… so new stuff:
– i backed a 3d printer on kickstarter.
– i startet sewing.
– i like pinterest.
– i started backing again.

so thats it… we will see, if i stick in this plan 😛

ok something completle different… vba… currently i am working in a small person related company, where they manage their clients in an Excel sheet. This actually is a good tool, but every person has his own sheet, where searching is horrible… so my goal is to write a small script, to generate an index page.

Sub SheetNames()

‘ Erster Eintrag auf Zeile
StartRow = 3

‘ Laufvariable mit der Postion zum einfüllen des aktuellen SheetNamens
Position = StartRow

For i = 1 To Sheets.Count

‘ Nur einfüllen, wenn der SheetName nicht dem Inhaltsverzeichnis entspricht

If Sheets(i).Name <> ActiveSheet.Name Then

‘Link erstellen
‘=HYPERLINK(“[Makro Tester.xlsm]’Tabelle1’!A1”; “Tabelle1”)
Worksheets(“Index”).Cells(Position, 1) = “=HYPERLINK(“”[” & ThisWorkbook.Name & “]'” & Sheets(i).Name & “‘!A1″”, “”” & Sheets(i).Name & “””)”

‘Position weiterzählen
Position = Position + 1
End If

Next i

‘ Leere Zeilen am Ende einfügen, um gegebenenfalls gelöschte Sheets aus dem Index zu löschen
For i = 1 To 5
Worksheets(“Index”).Cells(Position, 1) = “”

‘ Position weiterzählen
Position = Position + 1
Next i
End Sub

The problem is simple… we have a service-contract maven project, which contains all the wsdls… this will be deployed on a seperate server… why not simply use the maven repo?

so there are actually two solutions… put wsdl artifact on maven or unpack the arifact. This blog entry handles only the unpacking…

The solution is to put all wsdls as jar to the maven repo. Get the artifact, unpack it and generate the server or client from the unpacked wsdls. This solution matches my problem at work and no really effort was needed… but the solution kinda sucks… later more… first the solution 😉

Create a jar and pack the wsdls with build-helper-maven-plugin:

<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>build-helper-maven-plugin</artifactId>
<executions>
<execution>
<id>add-resource</id>
<phase>generate-resources</phase>
<goals>
<goal>add-resource</goal>
</goals>
<configuration>
<resources>
<resource>
<directory>src/main</directory>
<targetPath></targetPath>
</resource>
</resources>
</configuration>
</execution>
</executions>
</plugin>

And then unpack it in the actual service with maven-dependency-plugin:

<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-dependency-plugin</artifactId>
<version>2.6</version>
<executions>
<execution>
<id>unpack</id>
<phase>initialize</phase>
<goals>
<goal>unpack</goal>
</goals>
<configuration>
<artifactItems>
<artifactItem>
<groupId>ch.michio.test</groupId>
<artifactId>service-contracts</artifactId>
<version>1.0.0</version>
<type>jar</type>
<overWrite>true</overWrite>
<outputDirectory>${project.build.directory}/service-contracts</outputDirectory>
<includes>**/*.xsd,**/*.wsdl</includes>
</artifactItem>
</artifactItems>
</configuration>
</execution>
</executions>
</plugin>

Important it needs to be unpacked, before the generate-sources. Now it is in the target folder…

And finally generate it with cxf-codegen-plugin.