Project and Portfolio Management Practitioners Forum
cancel

Moving data from CSV into Temporary table

Highlighted
Abhi151187
New Member.

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

1 REPLY
AlfredoMonasi
Honored Contributor.

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