Abhi151187 Absent Member.
Absent Member.
247 views

Moving data from CSV into Temporary table

Does anyone has any shell script/Java code or knows any method for data upload from csv to temp table?

 Requirenment is to have User submit request and add csv file as attachment. That file should be processed and requests  created from backend. We want users to do this and have this automated hence cannot use XML utily. Need this urgently!

Any pointers would be much appreciated. Thanks in advance!

 

Regards,

Abhishek

0 Likes
1 Reply
Absent Member.. AlfredoMonasi Absent Member..
Absent Member..

Re: Moving data from CSV into Temporary table

Hi abhi,

 

You just could easily create a java app thats runs once a day and read the attachments and use PPM WS to create a request for each line of your csv. I built something similar from an excel tat was upload into temp tables by a custom app.

 

The java app could be run by a workflo step using the ksc_local_exec command.

 

Regards,

 

Alfredo

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.