Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Moving data from CSV into Temporary table

Highlighted
Abhi151187
Occasional Advisor

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

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

//Add this to "OnDomLoad" event