thanks dwanthy and itimpi for the quick reply
my old external hard drive recently had some problem, luckily i was able to recover most of the file using unstoppable copier plus testdisk. there was some error in the calibre portable folder, some books were not recovered and some files like opf and in calibre settings folder. i like to move the publisher to author so incase this happen again i can manually check if i lost a book.
i have blenderart magazine in calibre that is set to publisher "blenderart", no author because its a community magazine, its in the unknown folder, but if i move the "blenderart" to author then i can see all the blenderart magazine in one folder.
i think it would be better if i put "blenderart" in both publisher and author? how do i copy the text in publisher to author without requiring me to do it one by one?
thanks