I have about 11 thousand SHP files with unique names and a XLS list with ID that contains in ID field of SHP. How can i select this SHP files that is in XLS list and write them into another folder?
Solved
How to make selection of shp files?
Best answer by markatsafe
Assuming that the ID field is an attribute in your Shape files and all you have in your Excel file is a list of those IDs. I think the quickest way to do this would be:
1. use the DBF reader (rather then the Shape reader) to build an index of ID & directory/file name, as a CSV file or SQLite table.
2. use the Excel reader to look-up the directory/file name and then use the File Copy writer to move your shape files to your target folder.
I'm suggesting the DBF reader instead of the Shape reader since you don't need to read the shape geometries to lookup the ID.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.