{"id":2328,"date":"2016-07-03T13:22:02","date_gmt":"2016-07-03T13:22:02","guid":{"rendered":"https:\/\/grindgis.com\/?p=2328"},"modified":"2017-05-25T04:22:04","modified_gmt":"2017-05-25T04:22:04","slug":"no-code-to-count-gis-files","status":"publish","type":"post","link":"https:\/\/grindgis.com\/?p=2328","title":{"rendered":"No Code Required to Count Shapefiles or GIS Files in a Folder"},"content":{"rendered":"

There are different codes available in internet for counting GIS files but the method I am going to demonstrate you is simple and does not require any coding or no knowledge of python script. You just need few DOS command and Microsoft Excel software. You can do all kinds of analysis on excel sheet after importing list of shapefiles. On the below image you will notice I have different types of files; shapefiles, excel files and geodatabase files. So our target is to create a list of files with their name and extension in a excel sheet.<\/p>\n

\"No<\/p>\n

1. <\/strong><\/span>First step is to open the DOS command window, go to Start > All Programs > Accessories > Command Prompt on Windows 7 premium. Or shortcut way is to type CMD<\/strong> on the search box.<\/p>\n

\"Command<\/p>\n

2. <\/strong><\/span>Now use the CD <\/strong>DOS command to add your directory (DOS basics<\/a>). Note, use CD..<\/strong> Command to clear directories. Below image shows the directory that I will be counting files.<\/p>\n

\"CD<\/p>\n

 <\/p>\n

3. <\/strong><\/span>Now type the dir \/b > mylist.txt <\/strong>on the command window at the end and press Enter which will create mylist.txt files inside the shapefile folder. This txt file will be later imported to Excel.<\/p>\n

\"CD<\/p>\n

 <\/p>\n

Few other Commands:
\n<\/strong><\/p>\n

dir\/b > mylist.txt,<\/strong> create list containing files names only.
\n<\/span><\/p>\n

dir\/b > mylist.txt,<\/strong> create list with file size and dates.
\n<\/span><\/p>\n

dir\/b\/s > mylist.txt<\/strong>, create list including files in the sub-directories
\n<\/span><\/p>\n

4. <\/strong><\/span>File called mylist.txt is created on the shapefile folder<\/p>\n

\"list<\/p>\n

OR
\n<\/strong><\/span><\/p>\n

You can directly create xls file instead of txt file (dir\/b > mylist.xls<\/strong><\/span>). This will create excel file (mylist.xls) then you can avoid step 5.<\/p>\n

5. <\/strong><\/span>Now open the Microsoft Excel and import the mylisit.txt file, then click finish to create a list.<\/p>\n

\"export\"Text<\/p>\n

6. <\/strong><\/span>You will have a excel sheets with a list of shapefiles and you can use it to clean the data.<\/p>\n","protected":false},"excerpt":{"rendered":"

There are different codes available in internet for counting GIS files but the method I am going to demonstrate you is simple and does not require any coding or no knowledge of python script. You just need few DOS command and Microsoft Excel software. You can do all kinds of analysis on excel sheet after […]<\/p>\n","protected":false},"author":1,"featured_media":2362,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[104],"tags":[413,410,412,411,409],"class_list":["post-2328","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-count-shapefiles","tag-counting-gis-files","tag-dos-command","tag-no-code","tag-no-pyhton","entry","has-media"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t