Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,779 Posts
  • 24,931 Replies
6779 Posts
O
oscar_obinabo
asked in Data
How to solve HTTP Status 405 Error

​I am getting a HTTP status 405 error when I try to generate a GEOPDF using the link http://arcgprdcgy001.network.lan/fme/GenerateGeoPDF/. It says: HTTP method GET is not supported by this URL. The method received in the request-line is known by the origin server but not supported by the target resource.

481
redgeographics
Celebrity
3 years ago
swethabhupathi
Contributor
swethabhupathiContributor
asked in Data
is fme supprort to read Arcgis Pro file formats (like aprx, lyrx,mpkx,etc.,)

i want to read an aprx or lyrx file in fme . is it possible?

2082
andreaatsafe
Safer
3 years ago
fbastian73
Contributor
fbastian73Contributor
asked in Data
hello experts, I am trying to make my workbench output the result data into an already existing folder of the same name as the data file. How can I implement something like this?

I have attached the actual workbench below. SO in more detail, what I am trying to do is to output fanned out (by council name) shape files and GDBs to an already existing folder (of the same name as the council name attribute) on a drive somewhere. Is there a way to direct the output data to go into the different council folders when this workbench is run for all councils?The intention is to place this in the server and then schedule it to run on a quarterly basis.any thoughts?thanking you in advance.

42
fbastian73
Contributor
3 years ago
tnarladni
Enthusiast
tnarladniEnthusiast
asked in Data
adding multiple child elements xml to existing xml or replace value if tag exists from excel

I have an excel spreadsheet with 3 columns (featureclass, tag, summary). I want to update the metadata.xml file that corresponding to the featureclass. These xml files are embedded in a column in an sde table gdb_items. I'm able to extract the xml, but I don't know how to add xml elements. I have seen the xmlUpdater which works but only when that tag exists in the xml. Also, the "tag" field in the excel is a list of tags separated by commas. I need to create multiple <keyword> tags, one for each item. Here's my workspace so far. shows the xml without the existing "summary" and "tag" <idPrup> <searchKeys> with child nodes <keyword>, respectively shows xml with those nodes (lines 80 to 86)

7316
kailinatsafe
Safer
3 years ago
V
vlabs
asked in Data
Convert DWG solid colors to OBJ

I'm trying to convert a DWG with solids to an OBJ mesh.The conversion is good but the OBJ doesn't include the color of the solid ("autocad_color"). I tried GeometryColorSetter but I can't seem to set it up properly.I also tried the AppearanceSetter, following this post: https://community.safe.com/s/question/0D54Q000080he8G/how-to-set-the-color-of-an-ifc-objet-ifcproxy but I can't set it up correctly Could you give me some suggestions on how to setup the transformer GeometryColorSetter (or a better one) so that it takes the "autocad_color" of the geometry and gives the same color to the resulting obj.

313
J
3 years ago
dor1411993
Contributor
dor1411993Contributor
asked in Data
2-step verification for Fme Server Apps

Hello everyone! I have a question regarding information security in server applications. Is it possible to perform 2-step verification for apps with sensitive Data? There is of course the access using a username and password that I set. Is it possible to do another step for verification via email, for example?Thanks!

531
david_r
Evangelist
3 years ago
N
neilpawson
asked in Data
Why can't FME data inspector read my Locusview gdb dataset?

I have a gdb (ESRI) dataset from Locusview which QGIS can read fine but FME Data Inspector (2019) says there is a file missing, but doesn't say which.  The key part of the errors seems to be: "2021-08-26 05:19:36.616 ERROR - Geodatabase Error (-2147024894): The system cannot find the file specified." Log reads as follows: 2021-08-26 05:19:20.981 INFO - FME Data Inspector is starting up...2021-08-26 05:19:29.189 INFO - Loaded module 'fmeprompter' from file 'fmeprompter.dll'2021-08-26 05:19:36.204 INFO - Creating reader for format: Esri Geodatabase (File Geodb Open API)2021-08-26 05:19:36.278 INFO - Trying to find a DYNAMIC plugin for reader named `FILEGDB'2021-08-26 05:19:36.279 WARN - FME Configuration: Maximum of 2000000 feature(s) will be read starting from feature number 12021-08-26 05:19:36.613 INFO - Loaded module 'FILEGDB' from file 'C:\\apps\\FME2019\\plugins/FILEGDB.dll'2021-08-26 05:19:36.614 INFO - FME API version of module &#

181
M
3 years ago
C
clowncutie
asked in Data
Check multiple DWG versions

Hi, I'm trying to create a workspace to check multiple DWG versions, Iäve tried Real DWG reader and others, but cannot find the attribut that tells me the version. I made a picture below.Select multiple DWGs to readCheck The DWG Version with a testerOutput filename and check if version is 2013 as en excel(or user selected version test check)My issue is mainly finding the version at all and making it into a tester  

91
virtualcitymatt
Evangelist
3 years ago
dr_snglr
dr_snglr
asked in Data
I3S LODs and ArcGIS online, LOD, visibility issues

Hello,I'm wondering if anyone is actively using I3S files from FME in ArcGIS online. I ran into some issues, where depending on the camera position, some meshes disappear. Like this: https://i.imgur.com/R9PMcj3.gifvIs this maybe because of missing LOD defintions?

82
dr_snglr
3 years ago
p.jeremie
Contributor
p.jeremieContributor
asked in Data
Oracle writer column does not exist in table

Hi,  I am updating an existing table (in fact updating/inserting/deleting with fme_db_operation, created with ChangeDetector). All data is well updated, all coming from my revised source, on all columns of my destination table. However, I have a lot of warning telling me that the column xxxxxx does not exist in table XXXXXXX.In the database, the columns exist, of course. I am using a FeatureWriter and the feature types have been imported from dataset, Oracle Spatial Object and selecting the tables.All columns are not updated (some have the red triangle, other the green one). Any idea why I get these warning, whereas the columns are well updated ?

955
p.jeremie
Contributor
3 years ago
fmelizard
Contributor
fmelizardContributor
asked in Data
How do I get the folder name for my features stored in a KML/KMZ file?

When I open my KML file in Google Earth, I can see the data displayed in folders in the table of contents. When I use the KML reader to read the data, that folder name doesn't show up on my features. How do I get that out?

1534
K
3 years ago
swach
Contributor
swachContributor
asked in Data
ECW background color

I am creating a mosaic from a bunch of tiff files into an ecw. The shape of all the tiffs together is irregular so there is empty space. It is defaulting to black, I would like it to be white. This seems like it should be an easy fix but I can't figure it out.

2181
david_r
Evangelist
3 years ago
R
rinfante
asked in Data
ArcGIS Online Reader/Writer Error: Code 503

Hello,So we have some workbenches (FME 2018.1.1; 20181203 - Build 18578 - WIN64) that either read or write to AGOL after performing a bunch of operations on the data. These workbenches were working fine up until a week ago, when all of a sudden they started throwing a very generic 503 error message and failing completely.If I understand correctly, a 503 means it's a server side error (so it's likely something with ESRI), right?We've been having issues with our organization's ArcGIS Online portal for the last couple of days (layers being randomly dropped from maps, apps refusing to load) and I'm starting to think that their December 2018 AGOL update messed some things up, including the way FME's readers/writers communicate with it. Is anyone else having trouble working with AGOL lately?Thanks! 

41534
E
3 years ago
P
pijke
asked in Data
Point coordinates cannot be infinite error

Hello!Once again, I've come across an error I have never seen before and can't find online.I'm adding a new ArcGIS Online feature layer to an existing workbench, which matches points inside polygons (using the PointOnAreaOverlayer) and gives the points the project number attribute from the polygon.This works fine for all the layers inside it, but this new layer gives the following error:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '<layerName>'. The error code from the server was '1000' and the message was: '24126: Point coordinates cannot be infinite or not a number (NaN).'I checked the point which was sent to the layer (using the feature caching), it shows on the map just fine and according to the attributes it's an IFMEPoint. But at the end of the coordinates it shows <nan>, regardless of the X, Y and Z values. The main difference between this layer and the others is this one is the first with a Z-value attached. So I expect that's the pro

4910
N
3 years ago
S
seyjoo
asked in Data
IFC to Cesium 3D Tiles - geometry colors disappearing

Hello everyone, I recently updated to FME 2019, since then the IFC - Cesium3DTiles conversion does not preserve geometry colors (it was working fine with FME 2018). I think the problem comes from the Deaggregator. When I inspect the IFC, colors are preserved, but they disappear right after the Deaggregator. Has someone got into the same issue ? Thankssj 

132
danminneyatsaf
Safer
3 years ago
dparsons42
dparsons42
asked in Data
Creating ESRI Vector Tiles in ArcGIS Online sing FME

Is it possible to create ESRI Vector Tiles in ArcGIS Online using FME. I'd like to read from a database feature class for example, and keep an ArcGIS Online Vector Tile layer up to date with period updates. I can only seem to create and update ESRI Vector Tiles in ArcGIS online from ESRI PRO or possible write a script in Python3 and use the ESRI GIS API, in which case I don't really need FME.

1393
daraghatsafe
3 years ago
A
anandak
asked in Data
Bad geometry detected in the following feature; Geometry could not be encoded for Oracle

Hi,  I am using a bufferer and a dissolver transformer to generate a buffer polygon from an aggregated set of 500+ geometries. The Inspector is showing the generated geometry but the Oracle Spatial writer is unable write the geom into the spatial table. I am getting the error "Bad geometry detected in the following feature; Geometry could not be encoded for Oracle".  I have added a GeometryValidator after the Dissolver transformer. The generated geom comes through the PASSED output but still the error remains.  FME Desktop 2013 is used.  Regards, Ananda

825
p.jeremie
Contributor
3 years ago
A
alidada
asked in Data
Processing with the Microstation DGN with TAGs

I have decided to understand how to resave DGN file with tags using FME. I have dowloaded some files from this article (https://community.safe.com/s/article/writing-microstation-dgn-tags-with-fme#AdvancedExample) and ran it. It works correctly, but when I decided to change data to display into Microstation, I got NOT displayable data into DGN file. Before and after my changes into AttributeKeeper and AttributeCreator transformers:  Owner.x_offset and Owner.y_offset are created too. Before and after my changes there are some differences between output DGN files even while trying to enable display option for new tag:    Openning modified DGN file into FME, diffences are so big:Reader configurated like:  And Exposed some hidden attributes I get:Owner.color = 0Owner.display = noOwner.justification = 2Owner.x_offset = 0Owner.y_offset = 0 But Owner.original_justification = 7Owner.x (y and z) are NOT the same as I set into output DGN file. And I see NEW attributes such:igds_color, igds_weight

551
A
3 years ago
_
_trent
asked in Data
Is it possible to change the text size when writing ArcGIS Pro geodatabase annotation?

I am writing to an ArcGIS Pro annotation feature class in a file geodatabase defined where the text symbol is not required to be selected from the symbol table. My intent is to change the size of the text and have the symbol stored inline, but have been unsuccessful in my attempts. The font size always ends up as 10. This doesn’t seem to be related to the definition of the annotation class symbol, as I have created annotation classes with different size symbols and the resulting size is always 10. I am setting the following attributes in the workbench and exposing these on the writer:geodb_text_size: 72geodb_symbol_id: -1geodb_anno_class_id: -1geodb_allow_symbol_overrides: TRUEgeodb_font_point_size: 72  In my testing I have been able to change these properties and see the results come through:geodb_text_colorgeodb_font_name I have tried using the TextPropertySetter to change the text size but that doesn’t translate to the resulting annotation. I did try running this with FME 2020.1 aga

441
_
3 years ago
fhyde
Contributor
fhydeContributor
asked in Data
From the Postgresql Writer, when a table is truncated and then inserted with new data is it possible to reset the Primary Key sequence to '1'? It currently restarts at the last PK value (+1) from previous entry.

From the Postgresql Writer, when a table is truncated and then inserted with new data is it possible to reset the Primary Key sequence to '1'? It currently restarts at the last PK value (+1) from previous entry.

315
fhyde
Contributor
3 years ago
W
wthoman
asked in Data
The Odata reader fails to read organizational Odata feed.

We recently moved to an OData feed for one of our data sets, I am still fairly unfamiliar with this format. I am seeking to find out 1. if I am missing something in getting the Odata Reader to work 2. Failing that, what the recommended process would be to bring this data into FME. The feed (https://itd-pr-test.infotechinc.com/AuthModelService.svc/), is behind our firewall so I copied the header and first item into odata_xml.txt. Using FME's Odata reader I used Basic authentication and the link above. When I try to access the Feeds parameter in the reader or enter one of the table names manually into this parameter, it generates the error found in log1.txt, the most usable part of the log states there is an issue with format.  After some research, I thought the Odata might be readable in a json format so I appended ?$format=json at the end of the feed to get the json version( first rows in format_json). This actually allows me to see the tables within the odata in the feeds param

302
geomancer
Evangelist
3 years ago
johnk
Contributor
johnkContributor
asked in Data
Error using ArcGIS Online Feature Service Writer: Not overwriting feature data where already present

Hi FME world, I have a workspace which reads from and writes to several ArcGIS Online feature service layers. At some point, it has stopped updating the data within one of the layers. The workspace still runs successfully and writes features to the layer, but the data is not updated (where there were existing data present) when I check the written features. Where there are blank fields before, the update works as expected. So there is something to do with not being able to overwrite fields where data is already present.The writer mode is set to UPDATE and there are only ever an X amount of features to update, so the OBJECTIDs never change.  Any ideas?Thanks

1467
chrisatsafe
Contributor
3 years ago
swach
Contributor
swachContributor
asked in Data
Running out of memory when reading Smallworld

I have a process that is reading from Smallworld (using the SWORLDSWAF reader) in 2020.1. All it is doing is writing to a file geodatabase. It keeps running out of memory no matter what I do. Is there anything I can do to reduce memory usage when accessing Smallworld?- I can't use 64 bit because the Smallworld reader isn't compatible-I have 32 GB of RAM on my Windows 10 machine-I have the temp files writing to a separate hard drive-I have a WHERE clause filtering out the incoming features Thanks

207
swach
Contributor
3 years ago
swach
Contributor
swachContributor
asked in Data
Smallworld Reader Query

I am looking for the proper format to use the WHERE Clause to query features using the Smallworld 4/5 reader in FME 2019.1. The closest I can seem to get is:[interfaces].maintenance_notification where code_group_for_part = "DMPS0TR"[interfaces].maintenance_notification where code_group_for_part = "DMPS0VM"I have tried every combination of things but it always throws errors.

312
swach
Contributor
3 years ago
arnovananrooij
Contributor
arnovananrooijContributor
asked in Data
Multipage pdf example not working

Hi,I found an example for creating multipage pdf on https://www.safe.com/webinars/choosing-the-right-transformer-for-your-data-challenge/?utm_source=youtube&utm_medium=social&utm_campaign=webinar-transformers-2018. I downloaded the workspace pdfpalooza.fmw and tried it. In the demo I see it crates a pdf with multiple pages, but when I run de workspace in FME 2020.1 it writes evething to one page, see attached PNG. I want to achieve the exact same thing, so multiple pages for one of my own workspaces so it would be nice to have a working example. Anyone?

232
redgeographics
Celebrity
3 years ago

Badge winners

Show all badges
30,122
Posts
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.