Skip to main content
Question

Read From SQL Reporting Service and convert to a Shapefile?

  • November 17, 2019
  • 2 replies
  • 23 views
M
Forum|alt.badge.img

Hello, I was wondering if there is any way I can save a report from SQL Reporting Service into a shapefile? This lit building report has lat/lon and If I can grab from one of the formats it exports and then convert to a point shapefile, that would be my end goal. I have tried saving the excel using HTTPCaller to a folder then writing that to shapefile, but it has not been able to get the file. Is there another way that I should be going about this if it is possible? I would most likely not be able to get access to the backend database due to IT Assurance.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

Excel looks like it would be the most promising option. If the Latitude and Longitude columns are in the file you can use a VertexCreator to create points and write them to a Shapefile.

However, if you can't get access to the file it's all a bit moot (assuming you don't want to manually export and save the excel every time)

FME rocks! \m/
M
Forum|alt.badge.img
  • morijlumos
  • Author
  • November 18, 2019

Excel looks like it would be the most promising option. If the Latitude and Longitude columns are in the file you can use a VertexCreator to create points and write them to a Shapefile.

However, if you can't get access to the file it's all a bit moot (assuming you don't want to manually export and save the excel every time)

OK, the excel reader worked, what I was missing was having it use my windows sign on credentials to pull the file! Thank you!

Community Stats

32,211
Posts
122,316
Replies
39,898
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.