Search found 120 matches

by Joerg Hamacher
Thu Oct 30, 2025 11:16 pm
Forum: Questions & Answers
Topic: How to transfer frameworks from one pc to another?
Replies: 1
Views: 12290

How to transfer frameworks from one pc to another?

Hi again,

I have moved my Visual LANSA V15 installation to a new PC.
How do I get the VLF frameworks onto the new PC?
There is no check-in to the repository here, isn't it?

Best regards,
Jörg
by Joerg Hamacher
Mon Sep 29, 2025 10:17 pm
Forum: Questions & Answers
Topic: Server Modules: automatically included routines and statements
Replies: 4
Views: 13364

Re: Server Modules: automatically included routines and statements

Hello David,

Thank you very much for the export file.
However, I am now unsure how to process it further.

How do I create a real server module using this template?
If I want to create a new function, I can enter the template—but how does that work with a server module?

Best regards,
Joerg
by Joerg Hamacher
Fri Sep 26, 2025 5:30 pm
Forum: Questions & Answers
Topic: Server Modules: automatically included routines and statements
Replies: 4
Views: 13364

Server Modules: automatically included routines and statements

Hi everybody,

we are using server modules on IBMi for providing data to be shown on web pages.
To be able to test everything without touching the production data we have written a reusable part to set up the correct library list.
This reusable part we call in a method routine in our server modules ...
by Joerg Hamacher
Fri Jun 06, 2025 2:33 am
Forum: Questions & Answers
Topic: Working with XML files with more than 10 million entries
Replies: 4
Views: 73237

Re: Working with XML files with more than 10 million entries

At the moment I am still testing it on my Windows 10 PC. Can anything be done using utf8 or something like this?
by Joerg Hamacher
Fri Jun 06, 2025 2:31 am
Forum: Questions & Answers
Topic: Using Regex
Replies: 1
Views: 72283

Using Regex

Hi,

is it possible in VL to use regex for changing strings or even better all strings in complete textfiles?
Or using regex for a Scan and Replace in a Blob or Clob?

Best regards,
Joerg
by Joerg Hamacher
Fri Jun 06, 2025 1:13 am
Forum: Questions & Answers
Topic: Working with XML files with more than 10 million entries
Replies: 4
Views: 73237

Re: Working with XML files with more than 10 million entries

Hi Dino,

thank you, I genrally got it running with StreamWriter.

Now I have another problem:

original file contains German umlauts like ä,ö,ü
when I read the lines and write it into my new file these signs are gone

Original xml - read by StreamReader
Define_Com Class(#PRIM_IOC.FileStream) Name ...
by Joerg Hamacher
Thu Jun 05, 2025 7:44 pm
Forum: Questions & Answers
Topic: Working with XML files with more than 10 million entries
Replies: 4
Views: 73237

Working with XML files with more than 10 million entries

HI again,

I need to write a functionality that
reads a XML file in an IFS folder
detects possible erros in the single lines
corrects these errors and
writes back the corrected XML file into the original IFS folder.

I plan to realize this with TRANSFORM_FILE, read the list data, correct them ...
by Joerg Hamacher
Wed May 21, 2025 9:22 pm
Forum: Questions & Answers
Topic: Creating CSV and line feed in a cell
Replies: 2
Views: 30786

Re: Creating CSV and line feed in a cell

Hi Dino,

thank you.
I found out from one of the comments in your link that it obviously only works if a semicolon is used as the column separator. The customer has specified that we should use | as the separator.

In addition, the entire text should be placed in quotation marks so that LineFeed is ...
by Joerg Hamacher
Wed May 21, 2025 12:12 am
Forum: Questions & Answers
Topic: Creating CSV and line feed in a cell
Replies: 2
Views: 30786

Creating CSV and line feed in a cell

Hi everybody,

I need to read a DB2 file and create a CSV file from it.
This is not a problem so far - but I have to read several lines of text in a loop and then I have to output them in a single CSV cell. However, the text should not be written as a long text, but after each line a line break ...
by Joerg Hamacher
Mon Apr 07, 2025 11:00 pm
Forum: Questions & Answers
Topic: Installation of release 11.5 - anybody who still remembers?
Replies: 2
Views: 34766

Installation of release 11.5 - anybody who still remembers?

Hi everybody,

an “old” LANSA customer, a publishing house that uses publishing software written with LANSA, has contacted me with a request for support.
The software company that developed the software has not existed for many years and now the last former programmer who provided them with support ...
by Joerg Hamacher
Mon Feb 24, 2025 11:17 pm
Forum: Questions & Answers
Topic: RAMP: strange behaviour when working with aXes project
Replies: 2
Views: 69403

RAMP: strange behaviour when working with aXes project

Hi,

I do not know if this question is correct here - but is concerning more VLF RAMP than aXes.
I encounter a very strange behaviour in RAMP.
My aXes screen is shown correctly when working in aXes environment with an aXes project aXes01.jpg .


But when I work in VLF / RAMP tools all the images ...
by Joerg Hamacher
Thu Sep 19, 2024 11:26 pm
Forum: Questions & Answers
Topic: Ports when making request to external API from IBMi
Replies: 6
Views: 107541

Ports when making request to external API from IBMi

Hi,

which IBMi ports are used when making an HTTPS request to an external API via #HTTP_Request.DoPost Url(#w_URL.Trim)?
The same port that is defined in Web Administrator's Maintain System window or any standard ports?
Or are the ports defined in a conf.file?

Best rergards,
Joerg
by Joerg Hamacher
Wed Aug 28, 2024 9:51 pm
Forum: Questions & Answers
Topic: Can I use C-program-source code in Visual LANSA?
Replies: 2
Views: 15499

Can I use C-program-source code in Visual LANSA?

Hi,

I have a C program sourcecode (not a running program) for a punycode converter to encode and decode mailadresses with German umlauts.
Is there a way to convert this code into something that I can use in Visual LANSA?

Kind regards,
Joerg
by Joerg Hamacher
Fri Jun 21, 2024 9:54 pm
Forum: Questions & Answers
Topic: SELECT_SQL performs only 1 time
Replies: 4
Views: 23300

Re: SELECT_SQL performs only 1 time

Hi Art, hi Tim,

@ Art
I am sorry but I do not know what options you mean, Art.
I have a RPGLE programme that is callign LANSA objedts UD§CALL1, UD§CALL2 and in the third step my RDML function / process.
And this RDML function calls the RDMLX function with the SQL (to be precise there are more than ...
by Joerg Hamacher
Wed Jun 19, 2024 12:41 am
Forum: Questions & Answers
Topic: SELECT_SQL performs only 1 time
Replies: 4
Views: 23300

SELECT_SQL performs only 1 time

Hi,

I have a RDMLX function that accesses data base files via SELECT_SQL.
This function is called by a RDML function and this RDML function is called by a RPG programm on our IBMi.
When I call the RPG programme via the command line, it works fine the first time.
But if I call it again immediately ...
by Joerg Hamacher
Mon Oct 30, 2023 8:05 pm
Forum: Questions & Answers
Topic: Changing Field colors
Replies: 2
Views: 12836

Re: Changing Field colors

You can handle this wih styles and events like this (web page):

Begin_Com Role(*EXTENDS #PRIM_WEB) Theme(#SYS_THEME<MaterialDesignBlue>)

Define_Com Class(#PRIM_VS.Style) Name(#Style1) Borderbottom(1) Borderbrush(#Brush1) Borderleft(1) Borderright(1) Bordertop(1)
Define_Com Class(#PRIM_VS ...
by Joerg Hamacher
Fri Oct 13, 2023 12:52 am
Forum: Questions & Answers
Topic: Special characters and umlauts
Replies: 2
Views: 12064

Re: Special characters and umlauts

Hi René,

when using only O the xml was readable like this:

<?xml version="1.0" encoding="UTF-8"?>
<eb:Invoice GeneratingSystem="SMHsoftware" InvoiceCurrency="EUR" Language="de" DocumentType="Invoice" xmlns:eb="http://www.ebinterface.at/schema/6p1/">
<eb:InvoiceNumber>6607800</eb:InvoiceNumber ...
by Joerg Hamacher
Wed Oct 11, 2023 12:07 am
Forum: Questions & Answers
Topic: LANSA licenses virtual machines Model / Machine
Replies: 2
Views: 28755

LANSA licenses virtual machines Model / Machine

Hi,

we have a customer that has recurring problems with licenses.
The Lansa machines there are virtual machines and are managed by VMWare, i.e. this software decides on its own whether to migrate the machines from one host to the next based on workload, etc. There is nothing they can do about it ...
by Joerg Hamacher
Tue Oct 10, 2023 7:29 pm
Forum: Questions & Answers
Topic: Special characters and umlauts
Replies: 2
Views: 12064

Special characters and umlauts

Hi everybody,

we have a LANSA RDMLX function running on an IBMi that reads data from an IBMi data base file and creates a xml file that will be stored in IFS.

We save the lines for the XML file in a working list and at the end of the program the file is created using TRANSFORM_LIST like this:
Use ...
by Joerg Hamacher
Tue Aug 22, 2023 12:23 am
Forum: Questions & Answers
Topic: LANSA Web API - sending files
Replies: 1
Views: 5943

LANSA Web API - sending files

Hi,

is it possible to send a complete file as response in a Web-API?
For example:
a request sends the name of a pdf document - can I send back the complete document in the API's response?

KInd regards,
Joerg