It would be helpful if there would be a page only for the admin to delete records direct with the serial number, maybe like the pubmed id import function. But there should be a fixed delimiter - as it is a little dangerous to fill in a line of "to delete" ids.
or is it already possible with SQL?
And the second question:
Is there a possibility to do a double entry precheck during batch importing from Pubmed or from reference files for the future?
I can see that an admin page for batch deletion of records might be useful. However, there are probably more important things that await implementation, especially since this functionality can be achieved rather easily via an SQL query:
DELETE FROM refs WHERE serial RLIKE "^(27867|27868|27869)$";
This example command will delete records with serial numbers 27867, 27868, 27869.
> Is there a possibility to do a double entry precheck during batch importing from Pubmed or from reference files for the future?
Yes, this is a planned feature and I'm eager to see this implemented as well.
I think the SQL command is a good workaround.
As a first step for batch importing I wrote a small procedure which is extracing the Pubmed ID including a delimiter from a file.
The next step was to write me a cite file which is creating the SQL delete record. (needs some correction just now, but works)
Call the dups function
-> show serial field
mark all # Works only if the duplicates are the newest
Cite as SQL_delete and ascii
Copy and paste into SQL thats it.
Just imported about 2000 records from pubmed found 152 dups
deleted it below 1 minute :-)
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.