Raikia / FiercePhish

FiercePhish is a full-fledged phishing framework to manage all phishing engagements. It allows you to track separate phishing campaigns, schedule sending of emails, and much more.
https://github.com/Raikia/FiercePhish/wiki
GNU General Public License v3.0
1.29k stars 253 forks source link

which targets were rejected on import? #73

Open digininja opened 6 years ago

digininja commented 6 years ago

I had 3 targets in the system, I imported a CSV containing 562, I now have 563 targets in the system. The import failed for 2 of the entries but I don't know which ones. You need some way to show which lines failed.

Raikia commented 6 years ago

Yeah, thats true. The import job is a background job so I didn't make any type of error notification system for it, which was shortsighted. I'll make sure I address this in the next iteration! Good call

digininja commented 6 years ago

For anyone interested, the way I worked it out was doing this:

select target_users.first_name, target_users.last_name, target_users.email from target_users into outfile "/var/lib/mysql-files/imported.csv" FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

and then sorting and diffing the file with my input file.