Data

I am using FME 2018, there is no parameter in the FDB Open API Reader to 'Resolve Domains', as other Knowledge Base posts refer to such as: https://knowledge.safe.com/questions/59706/how-to-expose-a-file-geodatabase-domain.html . If the API Reader does not have this ability, Does the ESRI Geodatabase Reader in 2018 have this? (I realize 64 bit geoprocessing package from ESRI is needed for other ESRI formats)?

I needed to change my geodatabase reader to the File Open API version and I have lost the ability to resolve subtype domains (attribute geodb_subtype_name). Is there a way to resolve the subtype names with the File Open API feature reader?

HI Team,I am converting 100's of DWG's into PDF documents. I have the output set to plot the PDF to A0.The PDF's are all very different with layering and line types.The issue I have is in the layering many of the DWG's have frozen layers in order to depict what it shown in each DWG.The resulting PDF export plot all layers including the frozen ones.Is there an option to ensure the visible layers are shown and the frozen ones are not carried through to the PDF output? I am yet to find it.Thanks in advance!

Hello there I am looking to extract tables name and primary keys of a database in order to use it on the other workspaceAny idea, please

Hello,I am trying to create a GML with XML templater.My reader is Shapefile format.When I paste the sub-element template in the root template I don't have any errors (but then of course the file isn't valid).However, I have the following error when I try to add a sub-element:XMLTemplater(XMLTemplaterFactory): The following error occurred near line 19, column 6 of the query: XMLTemplater(XMLTemplaterFactory): "gml": can not expand namespace prefix to URI XMLTemplater(XMLTemplaterFactory): An error occurred while parsing the 'SUB' sub-template XMLTemplater(XMLTemplaterFactory): A fatal error has occurred. Check the logfile above for details A fatal error has occurred. Check the logfile above for details XML templater:With the following for the SUB template:<?xml version="1.0" encoding="UTF-8"?><gml:FeatureCollection xmlns:za="http://osi.irisnetlab.be/gml" xmlns:gml="http://www.opengis.net/gml">    <za:LayerNameFr>$(Layer_Name_FR)</za:LayerNameFr>    <za:LayerNa

Hello,I have a URL To a google sheet, which has been shared, and can be opened by anyone who has the link. I can view this spreadsheet successfully using Google Chrome. When I try to use the Google Sheets Reader in FME it required Google Authentication. When i enter my own google account details I get the error:400. That’s an error.Unverified state_wrapper. That’s all we know.Is there any other way I can connect to the google sheet?Regards,Helen

I receive Runtime Error! Program D:\\Programs\\ArcGIS\\Data Interoperability (x86)\\fme.exe, abnormal program termination received when reading features in SDE to write in a personal geodatabase. This occurs on a feature class that has 469905 total features at various numbers of features being read. Example of the last three lines in the log when receiving the runtime error. Reading source feature # 325000ResourceManager: Optimizing Memory Usage. Please wait...Attached to existing Java Virtual Machine Every time I run the ETL, the number seems to be different when it fails. The feature class is a line feature class (contours). If I exclude this feature class in the reader, the ETL works fine. What's wrong and how do I fix?

There is a field I need to see in a KMZ file in this conversion to a shapefile. It's called TypeName and the only evidence I see for its existence is this code I got from verbose logging, "<tr><td>TYPE_NAME</td><td>THEORETICAL SPLICE</td></tr><tr bgcolor="#D4E4F3"><td>SPLICE_CLOSURE_ID</td><td><Null></td></tr><tr>I think the parent tag is Document based on this from the Translation Log, "Attribute(encoded: UTF-16LE): kml_parent' has valuekml_id_doc_1.1' Attribute(encoded: UTF-16LE): kml_parent_type' has value Document'", but I'm not sure. It only has 2 features and Placemark has 5878.I was advised to use HTMLExtractor and this is how I have set it up with the Document file:When I run it, don't know what to enter into the HTML File or URL field. But for this attempt I have guessed it's "kml_document".It failed and this message is included in the report: "The below feature caused the translation t

Seems that the ArcGIS Online authentication token expires in fairly short order. Has anyone found a workaround to this issue? This makes running scheduled tasks difficult as re-authentication is needed on a daily basis it seems. This is most likely an issue on the Esri side as FME is just passing your credentials to the Esri's OAuth api endpoint.I'm wondering if anyone has stored their AGO credentials in the workspace, pass those credentials to the OAuth api for authorization, then continue on with accessing feature services in AGO? Probably not the best idea to do this...

Hello,  I am new to FME Server, I have managed to publish a workspace form FME Desktop to FME Server. However when I try to run the workspace in FME Server I get a error:  This also happens when I try to follow the instructions with a test workspace from: https://knowledge.safe.com/articles/22669/publish-a-workspace-to-fme-server-and-run-it.html I have reinstalled FME Server already and it seems the directories of the logs are present in the installation folders. Can somebody explain what I am doing wrong? Thank you.

I wish to convert dwg file to png using fme by running workbench using java.But i am not able to set color ,hatch style and line width dynamically based on my dwg file.I'm attaching the dwg file please help me.

Hello, this is the output (GeoJSON) I would like to createRight now I have the alias data in a table format like this and all the other data in another table. How can I create that JSON array shown above ? I use a GeoJSON writer in the end. What type should be used for the alias attribute?ID Code Name 85908 null Ab 85908 PP Hg 85909 OO Gtu 85909 QQ KU 

Based on if reader zip file contains certain file name I need it to read the file name to determine the scripts path.

Hi - I would like to convert Texas Department .dgn with its levels and line styles to Georgia Department of Transportation .dgn - I currently trying to setup the Tx.dgn as reader and G.dgn as writer - How do I import all layers incl empty ones and link them to the new layers and styles - thanks so much 

Hello I have an FME Server (2019) instance hosted on FME Cloud (standard instance size). One of the hosted workbenches allows users to upload PDFs as input, then reads the pages as raster data and carries out some operations on that imagery. Most of the time this workbench works without any issue, but a large PDF (or a small PDF with lots of pages) will cause the workbench to use all available memory (8GB, standard instance), and FME Server becomes unresponsive. A reboot and cancellation of the job is required in this situation. I have a couple of ways to mitigate the risk of crashing the server (PDF file size limit, using a job expiry time etc), but I'm wondering if there is any way to manage the memory FME Server is committing to the job. E.g. only 4GB of memory is ever committed to this workbench. Or should I be revisiting the workbench to make it use memory more efficiently?  Looking for a pointer in the right direction, appreciate any help.

Hi there, I'm working on a workbench where I write DGN V8 data. I would want to use a custom linestyle from my seed file but it does not seem to work. What I do is I use an attributeCreator to create the attribute igds_style and I try to assign the custom linestyle value but I don't know what it's supposed to be. From the documentation, it is said that igds_style takes negative integer to represent custom linestyle.My question would be how to know which number is assigned to my custom linestlye?Also , do you have an other idea as to how to write my custom linestyle ? Thanks in advance !

I want to read a specific selection from an Excel spreadsheet that varies the data displayed based upon the values selected in two drop down picklists. (See attached.) My Excel knowledge is not great....any suggestions gratefully received.      

We have a ESRI FGDB file available with .z02 file extension. Is it possible to read FGDB data on FME without ARCGIS ? Can we upload FGDB file to Oracle spatial database through FME ? Any pointer on this would be appreciated

I cannot import a file geodatabase into FME 2014.  I am using ArcGIS 10.1.  I checked with the data provider and they are on the same version.  Also the file geotabase does open in ArcGIS but not FME.  Anyone know why this may be.

I have 3,144 geotif files I want to mosaicI get the error "Too many recursive macro substitutions"Is there a maximum number of files that can be read?

 Howdy, I'm running FME 2019.0 and I am having problems writing a file geodatabase relationship table, specifically working with geodatabase attachments.In my situation I am using an ArcGIS Online Feature Service Reader to read in data collected with the ArcGIS Collector App. For my purposes I have filtered out unwanted attachments and now I need to write the data as a file geodatabase with the desired attachments.The error message I am consistently getting is:|ERROR |Failed to retrieve origin row for a relationship feature with OBJECTID '558' from table/feature class 'RC_Fire_Hazardous_Trees_Removal_CIP2260'This error implies that in the origin table (the point geometry) the 'geodb_oid' is written to the 'OBJECTID' field. However, testing out the "Writing ArcGIS Geodatabase Attachments" template file (https://knowledge.safe.com/articles/45301/writing-arcgis-geodatabase-attachments.html) it does not appear to be necessary to be feasible nor necessary to write the 'geodb_oid' to 'OBJECT

Hi community,  I'm confronted to a problem with DWG Writer.  The problem is simple:  A DWG is used to be validated and, as a report, a dwg is sent to user to show him what's correct/incorrect in the DWG...  The problem is with some DWG's that contain shape files ...  My writer use a template dwg file to display point as a block. At this particular feature writer , I get this error: Shape defined within template is not stored. Error When I open the original dwg in autocad I get this alert window:  

Hello all,I have several hundred geoTiff tiles that I want to mosaic into a single ecw.How can I set the background of the ecw to white?Currently the ecw has a full black background, which is a waste of ink when printing.My workbench is simple; geotiff reader => raster mosaicker => ecw writer

We are looking at implementing a solution similar to the demo shown at https://knowledge.safe.com/articles/1463/data-upload-validation-and-real-time-display-1.html  Can you let me know if the features and steps mentioned on the above page are possible with FME Cloud? 

Currently using FME 2018 Desktop. I have a workbench using the AGOL Writer to write a large data set to an ArcGIS Online Feature Service layer as follows:Writer mode: INSERTTruncate First: YesFeatures per request set to 1000When executing the workbench, sometimes it works and sometimes it Fails and gives the output time out error 504. What's the best approach to optimize the AGOL Writer or the workbench to avoid timeout issues with AGOL? Thank you.