Data

I have a workspace where I fetch las-files and clip them with a bounding box. I connected an inspector after the clip-transformer and the Inspector starts up but then crashes. The las-files are indeed created, and I can open them with i.e ArcGis Pro. I have also tried to open several of the original las-files with the Data Inspector but no success. I am using FME( 2019.0.1.0 (20190506 - Build 19253 - WIN64). I have also the 32bit-version installed(2019.0.1.0 (20190506 - Build 19253 - WIN32)) and the data inspector fails in the same way. I have run out of ideas and I hope someone can point me in the right direction. Thanks in advance.

Hi!I have a .docx document framework (template) and I would like to insert specific "field" with QuickPart or anything like that on the document. Then, with FME, write data on this specifics locations.Is it possible? I think not because I read on the Microsoft Word Writer description "The writer can either create a new document or append to the end of an existing template document ".Maybe with programmation?The same question on excel. I would like to write on named cells (like A2 is named "VALUE1" for exemple) in the best case scenario. Or if is not possible, write on the same sheet but on differents locations specified by number row/column. But when I duplicate writer, I can't give the same sheet name. Maybe do a series of FeatureWriter, but I don't succeeded. Thank for your answer.

Hello! I have a large CSV of thousands of properties in Edmonton that are in Lat Long, I want to convert these into UTM and then into UTM zone 12 N and show them in Arc, and advice? never used this software before

I have a workbench that reads an Access database. The workbench works fine on desktop but fails on FME Server.The log records the following error - 'Type=5;Data Source=\\\\server1\\file1\\file2\\example.mdb;User ID=admin;Password=********'. Provider error `(-2147467259) Cannot open a database created with a previous version of your application.'A quick google seems to indicate that this error occurs when you try to open Access 97 with Access 2013 or later. Is this the issue? and is there a workaround? I hope there is as my client is unable to update their version of Access .

I am adding a client's data from a Google Sheet to some shapefiles. I currently read the files online with my gmail sign in info but this is not a workable solution to incorporate into an automated workflow. Because these are not my files, but generated by the client, I'm not sure how to use Refresh Token or OAuth2. I am very new at all of this and none of those things make sense to me. Any suggestions on how to read in these docs?

Hello !I have a workflow that ends with a writer in txt format and an Emailer that should send the same text. An exemple of the txt file from the writer is attached. This are names of administrative areas, grouped by an attribute (set in an AttributeCombiner parameters) so in this exemple there are two "blocks" of text.Is it possible to sort by alphabetical order the text inside each group ? I can't figure it out since the text is already combine with the AttributeCombiner...I also need to send an email with the same text message. I tried the Emailer transformer but it sends an email for each group/block of text, so 2 emails here. I would need just one. Moreover, the text formating is lost in the email received (i.e. each administrative area in a separate line)... I tried to connect the Emailer to a FeatureWriter (in txt format) instead of the AttributeCombiner but I can't find how to Edit Value in the FeatureWriter... and the Emailer doesn't seems to provide carr

HI,I'm converting geodatabase GDB files to PostGIS. The table conversion works well but some of the attributes are empty after the conversion (only 5 attributes over 200 in 7 differents tables).The five attributes don't have the same types.Does anyone knows where it could come from?

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?