Skip to main content
Question

I would like to import multiple xlsx files into a single Geodatabase.

  • October 27, 2021
  • 2 replies
  • 15 views

I am working on creating a geodatabase made up of multiple types of proformas, a total of 67 different proformas. The proformas contact collected survey data of differing species and spatial data.

2 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • 2000 replies
  • October 27, 2021

to get you started here is an article on getting started with Excel in FME:

 

https://community.safe.com/s/article/getting-started-with-excel-2

 

And another one on Converting to geodatabase:

https://community.safe.com/s/article/writing-to-geodatabase-various-formats-to-geodatab

 

A lot of the rest of the workflow will be up to how your input data is structured and how you want your output to look.

 

To create geometries from x and y's (or lat/long) you can use a tool called the VertexCreator. This will create points.


  • Author
  • 1 reply
  • October 27, 2021

Thanks very much for responding.

 

I have gone through countless forums now and cannot seem to find the specific issue I am facing.

 

I think the process should be involve proformas -> collating/merging into multiple entries on a single file-> inputing the combined proformas into a geodatabase.

 

Do you know of any further information I could use please