[ppa-help] [phppgadmin - Open Discussion] Can't Import file if it has errornous records

[SourceForge.net <no...@so...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=3215740
By: rajan_bhardwaj

 I am using php-5.0.4,phpPgAdmin-3.5.3 and
postgresql-7.3.4-2.
Whenever i try to import a file (in CSV format)
containing duplicate records or any other formatting
errors import fails.What i want is that
even if file has some duplicate records import should
not fail but valid records should be imported.
I acheived this feature by making following changes
into dataimport.php.
1.If a column is not found for a particular record
comment out the exit
and continue the loop for next record.
2.Comment out the exit if it fails to insert the row
and rollBacks the transaction.
3.Commit into DB everytime it successfully inserts a
row into DB

It is working for me but i want some better solution.If
anybody has an improved solution pls reply me.

Rajan


______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=115883