Re: [Qgis-user] Re: .csv table
yepp, german speaking. in case of of need, drop a line to mail at berndvogelgesang.de so I get notified. Cheers, Bernd Am 27.05.23 um 13:03 schrieb Burt Grabowski: Hi Bernd, are you german speaking coincidentally? Maybe in some hours I will need some help, but I am trying to make some clear .csv files. Burt -- Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet. Am 26.05.23, 21:46 schrieb Bernd Vogelgesang via QGIS-User : Hi Burt, I can give it a try tomorrow. Cheers, Bernd Am 26.05.23 um 16:07 schrieb Burt Grabowski via QGIS-User: > Dear all, > > first of all I want to quickly introduce myself. My name is Burt and I > am a student of economics in Austria. I have a special request, because > I am an absolute beginner in QGIS, but have no time left. I am writing > on my diploma thesis and my supervisor wants to have some cards in it. I > spent a whole week, but I am not able to connect a simple .csv file with > the shape file. I would probably need 10 to 15 minutes, so who would > please have some time left for me for a zoom call, so that I can create > some tables for my diploma thesis? I would like to create them over the > weekend, because my deadline is getting closer and I cannot find one > description of my simple problem. > > Regards, > Burt > > -- > Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail > gesendet. > > ___ > QGIS-User mailing list > QGIS-User@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: .csv table
Hi Garth,thank you for your suggestions. Yes, I did not see the replies, because yesterday Kirk Schmidt helped me a lot by a zoom call. For now I am trying to make some clean .csv tables.Burt --Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 26.05.23, 21:46 schrieb Garth Fletcher :
Burt Grabowski wrote:
> ?Dear all, first of all I want to quickly introduce myself. My name is
> Burt and I am a student of economics in Austria. I have a special
> request, because I am an absolute beginner in QGIS, but have no time
> left. I am writing on my diploma thesis and my supervisor wants to
> have some cards in it. I spent a whole week, but I am not able to
> connect a simple .csv file with the shape file. I would probably need
> 10 to 15 minutes, so who would please have some time left for me for a
> zoom call, so that I can create some tables for my diploma thesis? I
> would like to create them over the weekend, because my deadline is
> getting closer and I cannot find one description of my simple problem.
Nicolas Cadieux has replied many times via QGIS-User Digest but perhaps you did not see his replies and offers of help.
Assuming you have a shape file containing some objects, and
you have a .csv file containing lines which should connect to those objects
You need to have (or create) a field in the .CSV file whose contents matches a field in the shape file.
It could be simply a number, or a string. The important thing is that the content of the field in the shape file will match the content of the field in the .csv file.
For example if the Shape file contains a field ShpTag
and the .csv file contain a field named CsvTag of the same type
Load the .csv file as a layer using the Data Manager's Delimited text option
{note: if the 1st line in the .csv contains column names, they will be used as field names}
You then open the shape layer dialog and use the "join" pane to
a) identify the .csv file layer
b) identify the field in the .csv file (CsvTag)
c) identify the field in the shape file (ShpTag)
Each object in the shape file will then have appended to its attributes the .csv contents from the line in the .csv file in which the contents of ShpTag matched the contents of CsvTag.
Very easy and very powerful.
Hope the above helps more than it confuses...
--
Garth Fletcher
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: .csv table
Hi Bernd,are you german speaking coincidentally? Maybe in some hours I will need some help, but I am trying to make some clear .csv files.Burt--Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet.Am 26.05.23, 21:46 schrieb Bernd Vogelgesang via QGIS-User : Hi Burt, I can give it a try tomorrow. Cheers, Bernd Am 26.05.23 um 16:07 schrieb Burt Grabowski via QGIS-User: > Dear all, > > first of all I want to quickly introduce myself. My name is Burt and I > am a student of economics in Austria. I have a special request, because > I am an absolute beginner in QGIS, but have no time left. I am writing > on my diploma thesis and my supervisor wants to have some cards in it. I > spent a whole week, but I am not able to connect a simple .csv file with > the shape file. I would probably need 10 to 15 minutes, so who would > please have some time left for me for a zoom call, so that I can create > some tables for my diploma thesis? I would like to create them over the > weekend, because my deadline is getting closer and I cannot find one > description of my simple problem. > > Regards, > Burt > > -- > Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail > gesendet. > > ___ > QGIS-User mailing list > QGIS-User@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
