FME Form

What transformer would I need, to stop the RasterDEMGenerator from filling in areas that should be void, or what other transformer(s) should I use? I am using a CSV with XYZ values as my input and in some cases there are voids/no data/holes in the data see pics. How do I stop FME from interpreting data that isn't there? Output is a Geotiff.

I’m using Interop via ArGIS and have developed 9 ETLs that need to run in order. I want to make things streamlined and run all 9 at once with one run command? I tried adding ETLs to a model but ran into problems.

In recent version of FME, it is possible to define a tolerance value when using transformers such as LineOnLineOverlayer.  We are having an old FME server (2016) and I would like to know how can I proceed to define a tolerance value when overlaying two lines datasets in FME 2016? @Takashi Iijima​ @Mark Stoakes​ @jdh​ and others

My attempt to export to PDF seemed fairly impossible, so I changed my approach to export to MS Word instead. I've made some progress; I've managed to create a single table that has all records from all of the worksheets - I need to be able to split the data out by these grids (i.e. separate sheets/tables for each grid). I also need these sheets to be in landscape rather than portrait orientation. However, I'm a bit stuck and I'd appreciate any advice that can be offered on how to achieve the result I desire! Thanks!

I have a 2 XLSX files. I delete some records on 1 file to be identical between the 2 XSLX . But when i apply a change detector, FME seem to considerate the line that i have delete.  Can you help me.

Looking for a way to load in files using their path stored in a csv column. I have several different file formats (.mif, .tab, .dem, .grd) that I need to reproject in FME. I've generated a csv that contains the full path location of each file on a new row. I'm wondering if it is possible to import these files directly from the csv, preferably separated by their file extension. I'm a complete beginner, so appreciate any advice. Cheers, Angus

Hi all, I have been given a csv file containing a GeoSpan column representing line data. Any idea how I read this into FME and create the geometry from the GeoSpan? ThanksN

I have a large number of text files of traffic count locations that contain both header information with necessary attribute fields and 2 fixed width sets of data that I also need to bring in as attributes. I am looking to ultimately create a table where the info from each text file is one row/feature in the table so I can join it to an existing point feature class with the Reference Number being the join field. I could do multiple tables if I have to also. I can't seem to figure out a good way to get both the Header attributes as well as the fixed width attributes.  A sample of one of the text files:They are actually .tam, .tpm and .tms files (no idea what those file formats actually are and google was not really any help) but they can be read as .txt files. I have attached one that I saved as a .txt as a sample

Supports geolocation the new application for Android?

Hi folks, I was wondering, is there a way to intentionally write to FME's temp location?  I want to create a workbench that's portable and needs to write a lot of scratch data using a few workbench-runners (deleted at the end of the process).  Is it possible to intentionally write to it? There doesn't seem to be anything on http://fmepedia.safe.com/articles/FAQ/FME-TEMP-environment-variable . I've done some testing:  - %FME_TEMP% as the destination just means FME creates a directory called that. - <FMEDrive> in various guises just results in a workbench crash. - Not specifying a directory means that FME writes the file to wherever the workbench is saved. Only if it's an unsaved (new) workbench will this be the fme_temp directory itself.  Thoughts? Is this even possible? I'd prefer not to have to hard-code somewhere, or even bother with a user parameter.  Cheers, Jonathan

In the MapnikRasterizer settings, in the Raster Properties section, it is necessary to specify the number of columns and rows of the output raster.  When I enter this information manually, there is no problem. When I want these parameters to be filled in dynamically, i.e. using the number of columns and rows of the input raster (using a RasterPropertyExtractor beforehand to access the attributes), I get this error message:"MapnikRasterizer_2 (MapnikFactory): No values were specified for either NUM_ROWS and NUM_COLUMNS, or SPACING. One or the other must be specifiedMapnikRasterizer_2 (MapnikFactory): A fatal error has occurred. Check the logfile above for detailsAttributeManager_OUTPUT_-1_84_Player (RecorderFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details". The number of columns and rows in the input raster are 32 bit unsigned integer. When I converted it to 64 bit integer via the Attribute

Hi. I would need to deal with a completely banal thing, but I'm stuck. I need to load this excel, but only the first line of attributes reads it to me on the reader. I need to load all the attribute rows. Nowhere in the settings can I find where I'm making a mistake. I would also need the first row to be already an attribute and not a column name.Thank you very much

Hello!I have a json text which I got from airtable HttpCaller.I want to read the attributes as normal attributes, and I have some hard time with that.I think I know what should I do:Format it, and then expose the attributes with JSONFragmenterBut It does not enter the attributes into my fileds:What should I do?I tried to do a lot of variations in the JSON Query, but noting helped.. I attached here the work sample..Thanks you all!

Hi I'm trying to download data from Ordnance Survey using their API. I've got this working successfully but the downloaded files do not have their correct filenames.  I've used JSONfragmenter to create a column called "url" for the download location and another called "fileName" for the filename. Can anyone help explain how I can rename the downloads with the name from fileName please? ThanksRob

 I have a basic list of guids to iterate over and get the related object, append to another list, then use in a function as one of the arguments. Here is my script:import fmeimport fmeobjectsimport uuidimport timeimport tempfileimport ifcopenshell class FeatureProcessor(object):        def input(self, feature):                create_guid = lambda: ifcopenshell.guid.compress(uuid.uuid1().hex)                 # Obtain references to master file        filename = FME_MacroValues['OUTPUT_FILE_PATH']        ifcfile = ifcopenshell.open(filename)                owner_history = ifcfile.by_type("IfcOwnerHistory")[0]        building_storey = ifcfile.by_guid(feature.getAttribute('storey_guid'))                   guids = feature.getAttribute('_guids{}._guid')               guids = [ifcfile.by_guid(x) for x in guids]                   # Relate the wall to the building storey        ifcfile.createIfcRelContainedInSpatialStructure(create_guid(), owner_history, "Building Storey Container", None, guids,

I'm trying to run a workspace in FME Server and I'm getting a message: "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9' which requires ArcGIS Pro...." I have ArcGIS Pro installed. The workspace runs fine in FME Desktop.

Hi list.I have a dataset with mixed date/time formats in a single field.I want to create a cascade to transform these, i.e. "Try this format", and if it fails, "Try that format", etc.HOWEVER, when data are output on DateTimeConverter's rejected port (signalling a data error), the field value is cleared, rendering a cascaded approach impossible. Why is that ??Is there a way to avoid this unwarranted nulling of a possible valid field value ?Cheers.

Can anyone advise the most efficient way to bulk extract attribute string lengths?

I've used the AUTOCAD_OD Reader to get the table and Attribute Manager to add the column and this seems to work. I've even output to an Excel spreadsheet to see that the column has been added, but I can't figure out how to get the change back to the Original drawing. Any suggestions are appreciated.

I'm trying to create a conditional parameter value in a WorkspaceRunner, based on an attribute value. I can do this, as the WorkspaceRunner is allowing me to fill in conditional values for the parameters, however, every time I click OK and reopen my WorkspaceRunner, all these conditional values are reset and again replaced by their hard coded values, as read from the model that the WorkspaceRunner is calling.Is there a reason for this behaviour or is this just a bug?I'm using FME 2018.1 build 18547 WIN64.

Hello, I am looking for the equivalent to the "Append Fields" tool in Alteryx, where many rows from one table are replicated for each row of another table. For example:Table 1:Table 2:Target Table:I've searched and experimented, but can't seem to sort it out in FME. Any advice? Thanks!

I have an FTP Caller that keeps throwing the error: FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -43, Failed getting bannerFTPCaller (FTPFactory): FTP info: Closing connection 0FTPCaller (FTPFactory): HTTP/FTP transfer error: 'Failed initialization' I can access the file on the ftp site using other ftp clients, and I have tried different configurations of the FTPCaller but I can't get this to work and I can't find much info on the error. Has anyone seen this before? Thanks!

I have multiple tables and need to check if their schemas conform to specs which are specified in text files containing field names separated by line breaks. How can I compare if the field names are mapped correctly?

Hello!I have a challenging work to do. I have 3 differents vectors data (DataVector1, DataVector2 and DataVector3 ) which i've extracted from a pdf file. And, I have also from the same pdf file, the location of the three Datavectors (boundaries). The boundaries is also a vector data that i've extracted from the pdf. However, the boundaries boxes are smaller compared to the limit boundaries of the Datavectors. Now, I need to scale and shift all my 3 Datavectors into the boundaries boxes. How can i do this ? knowing that the coordinates are in local values ( fake coordinates from PDF). After that, I'll do a manual georeferencing, since I know real coordinates of 3 points over the whole 3 Datavectors.Anybody, have some hints ? Thank you in advance !

At first you get the warning: 2022-06-08 09:00:12|  1.4| 0.0|INFORM|Creating reader for format: Oracle Spatial Object2022-06-08 09:00:12|  1.5| 0.0|INFORM|Performing query against ORACLE_SPATIAL dataset ` ----'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `----', user name `----, password `***'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Rich geometry.2022-06-08 09:00:12|  1.5| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'2022-06-08 09:00:12|  1.6| 0.1|INFORM|Environment variable ORACLE_HOME is not set.2022-06-08 09:00:12|  1.6| 0.0|INFORM|Connecting to ORACLE database `----' with user name of `----' and password of `***'2022-06-08 09:00:13|  1.6| 0.1|WARN |Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`----', userName=`---