Posted: 18 Oct 2017 9:38 EDT Last activity: 20 Oct 2017 5:29 EDT
Parse Delimited rule reading only first row
My requirement is reading data from A table convert it into CSV file put it on service export directory and read from that file and insert into B table in 6.2SP2v.
For this i created a activity which reads from that A table using pxRetrieveReportData and placed in ServiceExport directory using pxConvertResultsToCSV, and now to read data from directory and insert into B table i have created ServicePackage, FileService, Delimited rule, and activity to insert data into another table and a file listener to monitor that ServiceExport directory.
I tried in 7.3v everything working fine.
But its not working in6.2SP2V only first record is inserting, when i run service by giving file content not file it is inserting all the rows and one thing i used parseCSVHeader in parse segments because i don't want to insert header in B table.