CSV not exporting correct data from shape file

[qgib]

Author Name: Tara Pirie (Tara Pirie)
Original Redmine Issue: 19325
Affected QGIS version: 3.2
Redmine category:vectors

---

When saving a shape file that has been worked on (i.e. data points have been removed) as a csv file, the vector points are not being saved from the shape file that was worked on and saved, but saves the points that were deleted from the previous file.

---

• MrFB_c.cpg (Tara Pirie)
• MrFB_c.prj (Tara Pirie)
• MrFB_c.qpj (Tara Pirie)
• MrFB_c.shp (Tara Pirie)
• MrFB_c.shx (Tara Pirie)
• MrFB_c.dbf (Tara Pirie)
• MrFB_c.csv (Tara Pirie)
• MrFB_site10.csv (Tara Pirie)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

3.2?

---

• easy_fix was configured as 0
• project_id was changed from 18 to 17
• category_id was changed from Any to Vectors
• status_id was changed from Open to Feedback
• version was configured as 3.2
• crashes_corrupts_data was configured as 0
• regression was configured as 0

[qgib]

Author Name: Tara Pirie (Tara Pirie)

---

Giovanni Manghi wrote:

3.2?

Hi,
It was in 2.18.13 however I have just tried 3.2 and the same issue occurs.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Hi, description is a bit confusing to me, can you kindly add the list of exact steps to follow in order to allow us try replicate the problem? thanks!

[qgib]

Author Name: Richard Duivenvoorde (@rduivenvoorde)

---

Hi Tara,

Can you provide clear instructions on the things you do to get this result?

Because:

• I just downloaded your shapefile,
• opened it in QGGIS
• made the layer editable
• removed a lot of points
• finished editing (! else your edits are not saved, off course?)
• show feature count: 185
• export to csv
• view table: 185 records
  To check if those were the right records I joined the data on the Time field, and all seems ok to me?

So please provide some more info on how to reproduce this.
I'm on Debian Linux, I tested both QGIS 3.2 and master

[qgib]

Author Name: Tara Pirie (Tara Pirie)

---

Richard Duivenvoorde wrote:

Hi Tara,

Can you provide clear instructions on the things you do to get this result?

Because:

• I just downloaded your shapefile,
• opened it in QGGIS
• made the layer editable
• removed a lot of points
• finished editing (! else your edits are not saved, off course?)
• show feature count: 185
• export to csv
• view table: 185 records
  To check if those were the right records I joined the data on the Time field, and all seems ok to me?

So please provide some more info on how to reproduce this.
I'm on Debian Linux, I tested both QGIS 3.2 and master

Hi Richard,

The shape files were the finished and saved files. The attached CSV was the saved file from the attached shape file. If you load the CSV you see there are more points than the shape file (you need to zoom to layer to see them) but it was saved from that file. I even reloaded the shape file into QGIS to make sure all the changes were definitely saved before saving to the csv. I have also tried excel version and copy and pasting the attribute table. When I save to a csv file I do save as, select the csv and find the folder to save it to.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

The shape files were the finished and saved files. The attached CSV was the saved file from the attached shape file. If you load the CSV you see there are more points than the shape file (you need to zoom to layer to see them) but it was saved from that file. I even reloaded the shape file into QGIS to make sure all the changes were definitely saved before saving to the csv. I have also tried excel version and copy and pasting the attribute table. When I save to a csv file I do save as, select the csv and find the folder to save it to.

Can you kindly attach the original data and outline the exact steps you are following? thanks!

[qgib]

Author Name: Tara Pirie (Tara Pirie)

---

Giovanni Manghi wrote:

The shape files were the finished and saved files. The attached CSV was the saved file from the attached shape file. If you load the CSV you see there are more points than the shape file (you need to zoom to layer to see them) but it was saved from that file. I even reloaded the shape file into QGIS to make sure all the changes were definitely saved before saving to the csv. I have also tried excel version and copy and pasting the attribute table. When I save to a csv file I do save as, select the csv and find the folder to save it to.

Can you kindly attach the original data and outline the exact steps you are following? thanks!

Hi Giovanni

Please find the original file attached. I then loaded it into QGIS and removed the extreme data points so only those seen on the shape file (loaded previously) were left. I saved the edits and came out of editing mode then saved the changes as a new shape file which is the one I have given to you. I then saved the same shape file as a csv file which I also attached previously. However when I loaded the "cleaned" csv file and zoomed to layer I found the "deleted" points were still there.

---

• 12925 was configured as MrFB_site10.csv

---

• MrFB_site10.csv (Tara Pirie)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Tara Pirie wrote:

Giovanni Manghi wrote:

The shape files were the finished and saved files. The attached CSV was the saved file from the attached shape file. If you load the CSV you see there are more points than the shape file (you need to zoom to layer to see them) but it was saved from that file. I even reloaded the shape file into QGIS to make sure all the changes were definitely saved before saving to the csv. I have also tried excel version and copy and pasting the attribute table. When I save to a csv file I do save as, select the csv and find the folder to save it to.

Can you kindly attach the original data and outline the exact steps you are following? thanks!

Hi Giovanni

Please find the original file attached. I then loaded it into QGIS and removed the extreme data points so only those seen on the shape file (loaded previously) were left. I saved the edits and came out of editing mode then saved the changes as a new shape file which is the one I have given to you. I then saved the same shape file as a csv file which I also attached previously. However when I loaded the "cleaned" csv file and zoomed to layer I found the "deleted" points were still there.

how did you loaded the CSV in the first place? as a geometryless table or as point layer (in this second case what tool you used to plot the csv as point layer?)?

[qgib]

Author Name: Tara Pirie (Tara Pirie)

---

Giovanni Manghi wrote:

Tara Pirie wrote:

Giovanni Manghi wrote:

The shape files were the finished and saved files. The attached CSV was the saved file from the attached shape file. If you load the CSV you see there are more points than the shape file (you need to zoom to layer to see them) but it was saved from that file. I even reloaded the shape file into QGIS to make sure all the changes were definitely saved before saving to the csv. I have also tried excel version and copy and pasting the attribute table. When I save to a csv file I do save as, select the csv and find the folder to save it to.

Can you kindly attach the original data and outline the exact steps you are following? thanks!

Hi Giovanni

Please find the original file attached. I then loaded it into QGIS and removed the extreme data points so only those seen on the shape file (loaded previously) were left. I saved the edits and came out of editing mode then saved the changes as a new shape file which is the one I have given to you. I then saved the same shape file as a csv file which I also attached previously. However when I loaded the "cleaned" csv file and zoomed to layer I found the "deleted" points were still there.

how did you loaded the CSV in the first place? as a geometryless table or as point layer (in this second case what tool you used to plot the csv as point layer?)?

I loaded it as a deliminated text file, then saved it as a shape file to be able to edit it.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id removed Tara Pirie

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Bulk closing 82 tickets in feedback state for more than 90 days affecting an old version. Feel free to reopen if it still applies to a current version and you have more information that clarify the issue.

---

• status_id was changed from Feedback to Closed
• resolution was changed from to no timely feedback