Hi Nicolas, Thanks! Here are two matching files - I would be interested to know if it gives you other options. https://drive.google.com/open?id=1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH (https://link.getmailspring.com/link/[email protected]/0?redirect=https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) Let me know if you need anything else. Sam On May 28 2018, at 4:15 pm, Nicolas Cadieux <[email protected]> wrote: > > > Hi, > Can you send me a sample of the files? I have more options on my computer but > is may be that I am not testing with a .csv. > Nicolas > On 2018-05-28 6:35 AM, Samuel Williams wrote: > > > > Bonjour Nicolas, > > Thanks for taking the time to answer my email. > > Unfortunately the only options that I have for saving the joined files are > > all table based - see the screenshot that I have uploaded here: > > > > https://drive.google.com/file/d/1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ/view?usp=sharing > > > > (https://link.getmailspring.com/link/[email protected]/1?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F0%3Fredirect%3Dhttps%253A%252F%252Fdrive.google.com%252Ffile%252Fd%252F1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ%252Fview%253Fusp%253Dsharing%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > If I do the joins one by one, then yes it is easy to save the point dataset > > as a shapefile after it has been joined with the csv file, but I can't find > > a way of doing this in batch mode. > > Any suggestions? > > Thanks, > > Sam > > > > > > > > > > On May 28 2018, at 2:16 am, Nicolas Cadieux <[email protected]> > > (https://link.getmailspring.com/link/[email protected]/2?redirect=mailto%3Anicolas.cadieux%40archeotec.ca&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > wrote: > > > > > > Hi, > > > Once you have joined the geometry file to the matching attribute file, > > > you should be able to save that as a shape file. If you can’t figure it > > > out, put a sample on the next email. > > > Nicolas > > > > > > Le 27 mai 2018 à 17:10, Samuel Williams > > > <[email protected] > > > (https://link.getmailspring.com/link/[email protected]/3?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F1%3Fredirect%3Dmailto%253Asam.williams%2540sineenvironmental.com%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D)> > > > a écrit : > > > > Hello, > > > > I've hit a issue in Qgis that I'm struggling to resolve, and I'm hoping > > > > that someone might be able to point me in the right direction. > > > > I have 12 point geometry data sets and 12 csv files. Each csv file > > > > contain the attributes for one of the point data sets - there are > > > > exactly the same number of records in each point / csv pair: > > > > Points1.shp: > > > > -- point 1 UID > > > > -- point 2 UID > > > > .. > > > > -- point 980 UID > > > > > > > > Attributes1.csv: > > > > -- record 1 (Point 1 UID, blah, blah, whatever) > > > > -- record 2 (Point 2 UID, blah, blah, whatever) > > > > ... > > > > -- record 980 (Point 980 UID, blah, blah, whatever) > > > > > > > > I've loaded them all into Qgis and was hoping that I could join them as > > > > a batch process, so that I end up with 12 point geometry shapefiles, > > > > with each point associated with the equivalent record from the matching > > > > csv file.... I've had some success, in that the batch interface to join > > > > allows me to list the input layers, fields for the joins and the output > > > > file names very easily, but I can't work out how to preserve the > > > > geometry of the points. The only file type listed that I can save are > > > > DBF / XLSX / CSV / ODS files, which will only preserve the joined > > > > tables not the geometry. > > > > Am I approaching this whole problem in the wrong way, or is there > > > > something very obvious that I've missed? > > > > I'm using: > > > > > > > > QGIS version > > > > > > > > > > > > > > > > 2.18.17 > > > > > > > > > > > > > > > > QGIS code branch > > > > > > > > > > > > > > > > Release 2.18 > > > > (https://link.getmailspring.com/link/[email protected]/4?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F2%3Fredirect%3Dhttps%253A%252F%252Flink.getmailspring.com%252Flink%252F1527454204.local-f62ddf4d-2b7e-v1.2.1-7e7447b6%2540getmailspring.com%252F0%253Fredirect%253Dhttps%25253A%25252F%25252Fgithub.com%25252Fqgis%25252FQGIS%25252Ftree%25252Frelease-2_18%2526recipient%253DcWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%25253D%25253D%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > > > > > > > > > > > > > > > > > > > Compiled against Qt > > > > > > > > > > > > > > > > 4.8.7 > > > > > > > > > > > > > > > > Running against Qt > > > > > > > > > > > > > > > > 4.8.7 > > > > > > > > > > > > > > > > > > > > Compiled against GDAL/OGR > > > > > > > > > > > > > > > > 2.2.3 > > > > > > > > > > > > > > > > Running against GDAL/OGR > > > > > > > > > > > > > > > > 2.2.3 > > > > > > > > > > > > > > > > > > > > Compiled against GEOS > > > > > > > > > > > > > > > > 3.6.2-CAPI-1.10.2 > > > > > > > > > > > > > > > > Running against GEOS > > > > > > > > > > > > > > > > 3.6.2-CAPI-1.10.2 4d2925d6 > > > > > > > > > > > > > > > > > > > > PostgreSQL Client Version > > > > > > > > > > > > > > > > 10.2 (Ubuntu 10.2-1) > > > > > > > > > > > > > > > > SpatiaLite Version > > > > > > > > > > > > > > > > 4.3.0a > > > > > > > > > > > > > > > > > > > > QWT Version > > > > > > > > > > > > > > > > 6.1.3 > > > > > > > > > > > > > > > > PROJ.4 Version > > > > > > > > > > > > > > > > 493 > > > > > > > > > > > > > > > > > > > > QScintilla2 Version > > > > > > > > > > > > > > > > 2.10.2 > > > > > > > > > > > > > > > > > > > > This particular workstation is running Ubuntu 18.04 on amd64 hardware. > > > > Any suggestions welcomed - I know that for just 12 data sets I could > > > > probably have done the joins manually in the time it has taken to type > > > > this out, but I'm really curious as to whether there is a better way. > > > > Cheers, > > > > Sam > > > > _______________________________________________ > > > > Qgis-user mailing list > > > > [email protected] > > > > (https://link.getmailspring.com/link/[email protected]/5?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F3%3Fredirect%3Dmailto%253AQgis-user%2540lists.osgeo.org%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > > > (https://link.getmailspring.com/link/[email protected]/6?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F4%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > > > (https://link.getmailspring.com/link/[email protected]/7?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F5%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=cWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%3D%3D) > > > > > > > > > > > > > > > >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
