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!
Re: Moving data from CSV into Temporary table
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.