Skip to Content
avatar image
Former Member

Appending files from server node and populating custom table

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-f068636c8b1e?quicklink=index&overridelayout=true

Thanks,

Raj

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2009 at 09:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Dec 29, 2009 at 09:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded