Skip to main content
Question

How to insert Textformat(.txt) and Excel(.xlsx) formate data into smallworld by using FME.

  • December 14, 2015
  • 4 replies
  • 35 views

Forum|alt.badge.img

I ahve two formates of data text(.txt) and (Excel(.xlsx) The data is in bellow form.I want to insert this data into smallworld by using FME.

The data Formate as bellow in .Txt and Excels.

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.

4 replies

pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • December 14, 2015

Hi,

By using X & Y values, creation of point geometry is required?

Pratap


mark2atsafe
Safer
Forum|alt.badge.img+59
  • Safer
  • December 14, 2015

Hi,

By using X & Y values, creation of point geometry is required?

Pratap

Yes, using the VertexCreator transformer.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • December 16, 2015

Or using either the CSV reader (for text) or Excel reader (for XLS) you can specify attributes as being the X- and Y-coordinates. That avoids having to use the VertexCreator.


erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • December 16, 2015

And on the Writer side you can use the SpatialBiz plug-in for SmallWorld. This will allow you to write data from FME into SmallWorld databases.

http://www.spatialbiz.com/spatialbiz-plug-in.html