Using readers and writers to extract and load data.
Recently active
Hello, I have one folder with multiple sub folders that contains multiple shp. I need to read in all shp with specific name from all sub folders.Is this possible in FME? Structure is something like this:Folder-SUB Folder1-1.shp-2.shp-SUB Folder 2-1.shp-2.shp Example, I need to read all 1.shp together.
I'm a newer FME user. I have set up a workflow to read an xlsx file and write out as a csv, however it seems that it only likes reading the first file that i ran it with and does not work with any other file. I've set a user defined parameter to read files contained within a folder. I'm not sure what else i need to configure.
Good morning, I have uploaded a workbench to FME Cloud 2018 that has a GDB as a writer. I would like to download and view the GDB on my computer every time the FME Cloud job runs to see the changes. However, I do not think FME Cloud 2018 has the ability to download folders. I have tried the data download option, but that does not work for GDB. I was thinking of utilizing the HTTP caller. Has anyone used the HTTP caller to pull files from FME Cloud? Thanks!David
I've inherited a number of FME workbenches that I'm trying to decipher and where possible redesign to improve future decipherability. I'm noticing that for certain writers, if I add a new one that is of the same type as one already in the FMW, parameters are different. How can I tell what version (vintage) a certain writer is. Do I need to dig through release notes?
Hello, I have an issue when reading a DWG file with dynamic blocks in it. I'm unable to get proper autocad_block_name for dynamic blocks. Here's what I've done: 1) I've prepared a dynamic block definition in DWG file: it is possible to move attributes of the block away from its original base position. 2) I've created a sample DWG file, where the block definition is used. For some of the block inserts I've moved the attributes away from the original position. When reading the DWG with FME (viewer/workbench) I cannot access the original block name. Istead of proper name "UR_BLOCK" FME reads "*U76" for the blocks whose attributes were moved. Following autocad forums, I've learned that the dynamic blocks get anonymous name like "*U76", when their internals change. This means that technically they are different from blocks that stayed intact. Still when using autocad I'm able to see orignal block name when editing it's at
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