cancel
Showing results for 
Search instead for 
Did you mean: 

Appending files from server node and populating custom table

former_member248450
Active Participant
0 Kudos

Hello Experts-

I am trying to a built a report for portal KM activity. In EP i have set a command which writes the user activity in KM to a txt file and its written to each node on the cluster to the following directory.

/usr/sap/<SID>/J[C]<instance_#>/j2ee/cluster/server<number>/portalActivityTraces

I am not very well versed in UNIX scripting to append these text files.

Can any one suggest me the best way to append all these files and how to access them.

I have XI developer access. What kind of other access would i need for me to get the collection of files and then parse it and populate a table.

I have gone through the documentation below. It uses UNIX scripting. I want to use XI for this. Please let me know if any one have any thoughts on this.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e07edaa8-70ae-2b10-2390-f068636c8...

Thanks,

Raj

Accepted Solutions (1)

Accepted Solutions (1)

sunil_singh13
Active Contributor
0 Kudos

Hi Raj,

As u mentioned the file you are trying to pick is in text format, in this case u have to convert the text file into xml (File content conversion)using file adapter in XI using NFS protocol and then use JDBC adapter to write the content to the database.

Thanks,

Sunil Singh

former_member248450
Active Participant
0 Kudos

Just a small clarification. I have this text file on server node. We use AIX machines. Can you let me know. how I would I gain access to it. Is there any process other than scripting to copy this text file to a shared location or does XI have capapbility to access it?

Thanks.

Former Member
0 Kudos

Hi,

You have to use FTP for this. XI has capability to pick file from any remote location by using transport protocol as FTP in Sender File Adapter. Once you get the user id, password, dir path & file name from AIX then XI will pick the file from your AIX source location.

Regards,

Sarvesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Can any one suggest me the best way to append all these files and how to access them.

-- If you are already using PI to write these files using File Adapter then the append option should satisfy your concern.

Regarding the access, Developer access usually suffices for development. You may however want to check if the access provided has appropriate roles included into it such as RWB access for testing.