Skip to main content
Solved

Import data from Excel spreadsheet using file path

  • June 13, 2016
  • 3 replies
  • 113 views
T
Forum|alt.badge.img

Hello FME experts,

Is there a way to read an Excel table containing file paths (100's of them) and load the data into a workbench?

I would like to open the MapInfo TAB files to know the projection parameters and list them in the spreadsheet.

Any help would be greatly appreciated.

Thanks, Thiru

Best answer by thiru

Ok, figured this out. Being back in an Australian office on Monday morning, I think everyone else in the world is spending their Sunday.

I concatenated the filepaths separated by comma (using Notepad++ program) to make it appear as follows

filepath1, filepath2, filepath3, filepath4

copied this string into Source files box.

I wanted to just read one feature per file and that is enough for me to read the projection information.

Used CoordinateSystemExtractor to extract the _coordsys attribiute.

Written the FileName, Path and _coordsys attributes back to Excel.

Job done.

I wish I could devote more time learning FME's powerful features to make my life easier.

Thanks,

Thiru

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.

3 replies

T
Forum|alt.badge.img
  • thiru
  • Author
  • Best Answer
  • June 13, 2016

Ok, figured this out. Being back in an Australian office on Monday morning, I think everyone else in the world is spending their Sunday.

I concatenated the filepaths separated by comma (using Notepad++ program) to make it appear as follows

filepath1, filepath2, filepath3, filepath4

copied this string into Source files box.

I wanted to just read one feature per file and that is enough for me to read the projection information.

Used CoordinateSystemExtractor to extract the _coordsys attribiute.

Written the FileName, Path and _coordsys attributes back to Excel.

Job done.

I wish I could devote more time learning FME's powerful features to make my life easier.

Thanks,

Thiru

mygis
Supporter
Forum|alt.badge.img+14
  • mygisSupporter
  • Supporter
  • June 13, 2016

Ok, figured this out. Being back in an Australian office on Monday morning, I think everyone else in the world is spending their Sunday.

I concatenated the filepaths separated by comma (using Notepad++ program) to make it appear as follows

filepath1, filepath2, filepath3, filepath4

copied this string into Source files box.

I wanted to just read one feature per file and that is enough for me to read the projection information.

Used CoordinateSystemExtractor to extract the _coordsys attribiute.

Written the FileName, Path and _coordsys attributes back to Excel.

Job done.

I wish I could devote more time learning FME's powerful features to make my life easier.

Thanks,

Thiru

Hi @thiru please check this video https://youtu.be/KXsfYwlOc4Q

 

 

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • June 13, 2016

@thiru

You can create a dynamic reader (click the icon with the plus sign) on the top folder G:\\ for *Tab files (including any filters you'd needed).

Then in the Navigator panel go to your reader's Parameters=>Advanced=>Features to read yo

Set the "Max features to read per featuretype" = 1

Community Stats

32,154
Posts
122,047
Replies
39,812
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.