Using readers and writers to extract and load data.
Recently active
I've had to point a FME Server workspace at a different network share output directory and it is not failing with the following error message:Destination Feature Type Routing Correlator(RoutingFactory): Could not create output folder `<my_directory_path>' for use by ESRISHAPE writerThis FMW merely reads a number of ESRI ArcSDE feature classes and writes them out to SHP. So about as simple as it gets. What is the Routing Correlator/Routing Factory?The workbench runs fine when run from my local machine. I've tested that the service account used for running FME Server has WRITE permission on the target directory.Any suggestions other than rebuild it and try fresh? Thanks.
Hi All,I'm new to FME and have been pouring over videos to try and do my first projection. Any help is much appreciated. I have a raster geotiff I'm trying to project onto a City map. I'm hoping someone can point me in the right direction with a start to finish video or thread to help guide me through the process.Thanks,Adam
I have a mapinfo tab file called PARKS, that I have done thematic mapping (IndValue) of a text attribute called CATEGORY, to get point symbols colored by CATEGORY. CATEGORY has about 10 different values eg bench, lamp. So that my mapinfo users are working from our corporate database, not flat files, I wish to get PARKS into a new MSSQL Spatial (v2008) layer/table, complete with the color coding. I'm hoping that a mapinfo pro v15 user can connect to the MSSQL database and see colored points. I want to use FME to read from the tab file and write to MSSQL. I have already imported from tab to MSSQL successfully, and the mapinfo users can view and edit the layer/table in MSSQL - great. a) I wish to import it via FME2018.1 and store the points' colors, in a new table for the mapinfo pro v15 users. b) later, I wish store points and their symbol shapes in yet another new MSSQL layer/table, for the mapinfo pro v15 users.I hope someone can advise, please.
I got exported FBX file from INFRA WORKS 360 with actual coordinates system, but when i got convert that file into citygml by using fme that coordinates value change to LOCAL values, Even I did inspect of the reader file .fbx its on local coordinates value. My question is How to read the fbx file with actual coordinates system by suing fmeNote: I have supporting file for fbx is .pos file, In FME there is no option to add the .pos file while using the reader for FBX....,
Here is the log file from today along with a few notes from myself:Error when trying to connect FME 2018.1FME version 2018.1.0.0 Build 18520 Win64I have tried both AD account and Email account and getting same issue.I have had our SharePoint admin, make my account an Admin on the site.Trying to determine if this is FME or SharePoint to troubleshoot. Failed to obtain any schemas from reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information
Good morning!I need to export data from a WFS to a GML. The data is INSPIRE compliant, so I'm using the INSPIRE GML Writer.This is what I'm getting for the "nationalLevel" attribute:<au:nationalLevel xlink:href="http://inspire.ec.europa.eu/codelist/AdministrativeHierarchyLevel/6thOrder"/>And this is what the person using the GML wants:<au:nationalLevel xlink:href="http://inspire.ec.europa.eu/codelist/AdministrativeHierarchyLevel/6thOrder">6thOrder</au:nationalLevel>I thought that wasn't a big deal. I just added the following attribute to the writer:I use an AttributeManager transformer to set the "nationalLevel" value.But the GML hasn't changed at all.Does anyone know how I could achieve what the user wants? I don't know if I'm doing something wrong in my workspace or I'm missing some concept about the INSPIRE GML, but I'm stuck.The workspace I'm using is also attached.FME 2017.1 (32 bits)Thanks for any help provided!!
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>&lt;Null&gt;</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.