Wondering if it's possible to automate some repetitive tasks in QGIS (2.0).
This is my general workflow for importing some xyz type text files from another software package which export (not overly efficient) fixed column data:
- import fixed column text file into Excel
- add fieldnames
- create unique id field and populate using a combination (concatenate) of two fields in the existing data
- remove null rows in between data groupings
- remove unwanted columns
- save to csv
- import into QGIS
- convert to polylines and save as shapefile
I'm thinking that this is achievable in QGIS alone via some scripting?
So, I want to keep the first 4 columns (X,Y,ID,Value), delete the final column, remove the rows with text, and create a polyline shapefile based on a field which is a combination of the 3rd (ID) and 4th (Value) columns (e.g. 0_2000, 0_2100, 1_2100, etc) .