Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,082 Posts
  • 26,079 Replies
7082 Posts
13gamat
Participant
13gamatParticipant
asked in Data
how to import ArcGIS online image data into FME Data Inspector

190
rylanatsafe
Safer
elpone
Contributor
elponeContributor
asked in Data
Shapefile to dwg becoming a block and losing attribute data

Folks, I know I am missing something simple here. What I am trying to do is convert polygons from a shapefile to a dwg while conserving the attribution. The shapefiles are polygons and may or may not have multiparts and donut geometries. As such it seems a mpolygon is the best fit as an AutoCAD datatype.Something similar has been asked Here: Shape to AutoCAD with attributes by @lmerino but no answer I can get to work.I have the cad writer set to extend entity dataHowever when I look at the output in CAD the polygons are coming through as blocks. @Mark2AtSafe suggested using a Deaggregator transformer but I am not sure how this will help. I have done as @erik_jan suggested and added autocad_entity set to autocad_mpolygon via a AttributeManager and everything in the target drawing will then end up as a mpolygon as desired. However there is no attribution.Sample data: Edit: Seems that using a different writer such as Autodesk AutoCAD Map 3D Object Data ends up with the desired outpu

2410
elpone
Contributor
ciarab
Contributor
ciarabContributor
asked in Data
Movement of Database to Linux Machine- Impact

If I move my database to a windows to a linux machine is there any impact on FME users of this database other than updating database connections

00
ravenkopelman
Safer
S
shepthedog63
asked in Data
Directory and File Path when reading a zip returns 'wrong' dates

Prologue: this suggestion puzzled me, but it's right: in 2016.0 (what I'm using) you can't point a Directory and File Reader at a zip file. You can with a FeatureReader though. Now read on!I'm retrieving the file properties out of a zip file with a FeatureReader with format 'Directory and File Pathnames' and 'retrieve file properties:' set to Yes. Workspace attached, .The file name and file size comes back correct, but all the dates, path_accessed_date, path_created_date and path_modified_date, get set to now. I think FME should be returning the dates the files have inside the zip.P.S. It looks like FME is actually unzipping the files to get at the info:path_windows (string) = d:\\temp\\ea_admin_boundaries.zip_1481293489605_5384\\AREAPF_EA_NE_010K_V1_3.shx...which explains the dates. Still not the right output to give, though, IMNSHO.

180
M
M
mjoarder_pln
asked in Data
Use writer file as a Reader in next step?

Hello Everybody, I am facing trouble to use a writer file (xml) as a Reader file for the second step. I am writing ESRI format metadata in a text_line and saved as a .xml extension. At the second step i want to use this xml file as a input file. Nothing is working , please see the attached imge. I have tried several ways like user parameter, feature to writer and so on,

1060
M
V
valantistsiakos
asked in Data
How to change elements(namespaces) in GML ?

Hi, I am trying to produce a GML 3.2.1 file with elements based on an xsd. Any suggestions ? Thanks in advance,Valantis

405
V
matias
Contributor
matiasContributor
asked in Data
IFC4 setting Unit and Coordinate System

I'm Transforming georeferenced EsriShape to IFC4 the problem is that when I convert the buildings are in millimeters and when I use Scale to switch to meters the location is scale too so the position (georeference) change but the buildings in 3D are scale to Meter. I can not find how to use FME to set the corresponding parameters in ifcSIUnit and IfcCoordinateReferenceSystem have some one use FME and IFC4 ?

570
tono
Supporter
C
chognards
asked in Data
IFC attribute reading

p { margin-bottom: 0.25cm; line-height: 120%; }I would like to get the value of a specific attribute of an IFC data (data from BIM software). Whereas I can see this attribute in the "feature information" window in the inspector, I cannot see it in the user attribute tab or in the format attribute tab of the "feature type" window in the workbench. Thanks for any help.

670
geosander
C
cfordigan
asked in Data
FME Exporter for Revit

We are having problems with certain IFC Parameter data not being available. The IFC Exporter has been installed and all settings correct, but some shared parameters in Revit are not coming through into the FME Data Inspector. Is anyone having the same problem?

80
A
G
gregrieck
asked in Data
How to convert a MapInfo SQL database into an ESRI SQL database

Is it possible to use FME to convert a SQL MapInfo database into an ESRI SQL database? What are the steps needed to complete this task?

100
redgeographics
Celebrity
I
inessou
asked in Data
I need a template fme to convert sketshup to citygml lod2 please help me

60
fmelizard
Safer
W
wolfsnipes
asked in Data
E57 to LAS with time and station ID

I'm trying to convert an ASTM e57 file to LAS, and retain the e57 station IDs as the LAS Point Source ID attribute. Is there a way to do this? Thanks!

860
trentatsafe
Safer
13gamat
Participant
13gamatParticipant
asked in Data
converting dwg file to File Geodatabase

I am having trouble converting the dwg/CAD file to a file geodatabase. I convert it to a shapefile; there is no problem. Any ideas whats going on?This file a has plan layouts of a building. It shows floor plans for 3 different floors.See attached file

780
A
zzupljanin
Contributor
zzupljaninContributor
asked in Data
Writing aggregated features in AutoCAD

Hi,if you try to write aggregates in AutoCAD you'll get block, which is kind of unwieldly, especially if you need to modify geometries in AutoCAD.As it looks like groups can't be written (only read) using FME.I'd like to ask you, what are your experiences with this. Are there some other workarounds...Thanks in advance,Želimir

360
zzupljanin
Contributor
nicholas
Contributor
nicholasContributor
asked in Data
How to get road names from .OSM file (OpenStreetMap)

I have a .OSM file of Australia.I can extract the roads by choosing the Feature Type "highway"But the result is missing the names of the roads.How do I get the names of the roads?I do get the type of road as an attribute, for example; "residential", "secondary", "tertiary"But I want the name of the road as well.

1360
nicholas
Contributor
gio
Contributor
gioContributor
asked in Data
Is it possible to write autocad group entity?

Is it possible to write Autocad groups to dwg.I have tried the available format_attributes.Setting these on objects causes them to not be written, other objects do.Any tips or hints?(NOT talking about reading groups )

300
fmelizard
Safer
R
ravinhasseea
asked in Data
Write invalid records to a CSV writer

Hi I would like to output only the rejected records on each transformer output to a CSV file, and also write total count of invalid records.Any suggestion what's the best way to achieve this?

80
steveatsafe
Safer
I
iant1212
asked in Data
How to get the same folder name to output in different subdirectories using fanout with Server and Data Download

I am trying to output CSV files to a specific directory structure like so:directory1/  bike/    ride_log.csv    bike_features.csvdirectory2/  bike/    customers.csv    When I run the Data Download job the resulting file structure in the output zip file looks like this:directory1/  bike/    ride_log.csv    bike_features.csvdirectory2/  2/    customers.csvThe CSV features ride_log and bike_features belong to the same CSV writer: bike_1, and the customers feature belongs to a CSV writer: bike_2.The bike_1 and bike_2 writers have Dataset Fanout applied based on an attribute named 'directory' which gets set to 'bike' in the transformation process of all three features.  There is also a prefix directory set for bike_1 as 'directory1', and a prefix directory for bike_2 as 'directory2'.  Both features have their output directory linked to $FME_SERVER_DEST_DIR, which as an FME server parameter is set to \.  So how can I get the same folder name in two different subdirectories when using fanout 

90
rylanatsafe
Safer
M
mswards
asked in Data
Server - schedule placing files in wrong folders

Hello all,I have an incredibly weird issue....Running the workspace from FME Desktop, and running manually via Server there is no issues at all. When the workspace runs via a schedule nightly it is writing files into different folders...FME Desktop and Manual Server run - \\\\server\\folder\\folder\\folder 1On server via a schedule - \\\\server\\folder\\folder\\folder 2 I have deleted the schedule and added a new one but the same issue occurs, and it is only for this workspace.Any ideas..?

43
rylanatsafe
Safer
K
kat
asked in Data
Google Drive Connector

Hello, my goal is to delete a previous' week file from google drive and upload the file of the current week on a weekly basis.  The file name changes weekly.  This week I would like to delete report_201729.xls and upload report_201730.xls, next week it would be report_201730.xls to delete and report_201731.xls to upload. The upload is working fine with the Google Drive Connector transformer of FME 2017, but I have troubles to delete the previous' week file. The transformer doesn't have a file name option, only an Object-ID, but this ID changes weekly. How can I solve this problem? Thanks!

170
rylanatsafe
Safer
V
valantistsiakos
asked in Data
Hi, i am trying to convert my access template into an gml compliant with an xsd. Is there any tutorial taht could guide me through this process?

60
danilo_fme
Evangelist
simonhume
Contributor
simonhumeContributor
asked in Data
excel worksheets

Good afternoonOnce again i find myself trying to do something relatively simple in FME and failing miserably. Frustrating doesn't come into it.I have an excel spreadsheet with multiple worksheets, each one populated with planning data.I would like to end up with one spreadsheet for each of the individual worksheets, so i can then use them for some other work with some spatial tables.When i add the excel writer, i'm given the option of all the worksheets, which i select, then attach them to the corresponding reader. But the resulting output spreadsheet contains all the worksheets in one worksheet.Have tried the fanout option to no avail.Have tried adding the source spreadsheet as a a workspace resource, with all the worksheets selected, again, to no availI'm sure this is a simple thing to do in FME, but it's currently beyond me. Any advice would be gratefully appreciatedregardsSimon Hume

1100
redgeographics
Celebrity
M
mjoarder_pln
asked in Data
how do I open and exisitng Enterprise Geodatabase featureclass metadata (esri format) in FME 2016?

Hello Everybody, I have seen some examples to open geodatabase metadata directly in FME using Feature Type Mode (metadata) but I cannot see this in FME 2016 version. I want to open the metadata of a SQL server based feature class/table's in FME and want to export it into our own metadata schema. Please guide me. Thanks

120
david_r
Celebrity
C
cliff_wade
asked in Data
FME to help symbolise attribute values

I have an ESRI Feature Class with 4000 records, of staff and the location they are each based at, in a field "Location." So for arguments sake, there are 50 different locations. What I would like to do is symbolise in ArcMap using proportional symbols the number of staff at each location. Is there a way in FME that I can set up the Feature Class to enable me to do this ? So for example, say of the 4000 staff records there are 1000 based in London (simply populated "London" in the "Location" field) then I wish to then symbolise this proportionally (based on that 100 figure), and likewise for other cities too.Thanks

800
redgeographics
Celebrity
J
jjaksic22
asked in Data
Formatting autocad text features

Hi guys,I'm trying some autocad text features formatting. So, I have a number of text features at their insertion coords. I want those to be formatted like they are aligned in some text editor and I want it in DWG output if possible. I have:100 200 390 420 210 333Of course, this is only a sketch. There can be up to 300-400 text feaures at their locations.I want them to be aligned like this:100200390420etc.Possibly in DWG format. If not possible, some other solution that can be copied to DWG is also an option.Thanks in advance.Best regards

1210
J

Badge Winners

  • FME Certified Professional
    _jacques_has earned the badge FME Certified Professional
  • Integrate Spatial Data
    madihas earned the badge Integrate Spatial Data
  • Webinar Watcher (Bronze)
    bradmakesmapshas earned the badge Webinar Watcher (Bronze)
  • English Speaker
    bradmakesmapshas earned the badge English Speaker
  • English Speaker
    jamatsafehas earned the badge English Speaker
Show all badges

Community Stats

31,790
Posts
120,760
Replies
39,406
Members

Latest FME

Terms & ConditionsCookie settings
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.