Data

I am new bee and want to generate FME flow which reads every day file from SFTP server and populate the datathe first half of the file is default then their is date concatenation with “MMDDYYYY” format and then suffix with file extensioni use datetimestamper transformer and found the date but when pass that date to FeatureReader in Dataset with “default text”@Value(_Date) , it does not generate the fileCan someone help with if their is any example which can provide me guidance on how to set auto filenames

I have a field that contains values with parentheses, like (0601310951181134359628), and I would like to remove them. The parentheses always appear once at the beginning and once at the end of the field.I am currently able to achieve this using two StringReplacer transformers, each removing one parenthesis. However, I would like to do it in one step. I tried the recommended regex expressions from previous posts, but none of them worked.Any suggestions?

Hi all,  I want to update certain attributes in a DWG block. To the left where it says "test" I have updated an attribute. However FME writes out duplicate blocks and the new one is also bigger than the original.  Is there a way to update attributes and write the changes to a DWG without touching anything else?  Thanks!  /Jacob

 I have tiff file that I have been provided when I run it through FME Workbench 2024.2 to create a mbtiles package, I get this strange black background, I assume it is the defulat tile for the area.  The orginal tiff only occupies the extent of what you see in the map itself below.  So the conversion is tacking on this huge black boundary.  Any ideas on how I make it not do that?  I have included a screen shot of my settings below.  Thanks for any ideas!!  

 j'ai un fichier dgn contenant les câbles de type polyligne avec leurs extrémités. -je veux extraire les câbles et les convertire en shapefile (.shp) avec les noms des extrémités.???

Hi,I am trying to prepare a PDF with the PDFPageFormatter. I have 6 input ports in the PDFPageFormatter and it seems impossible to align them exactly with each other. I have the same upper left x and -y for all 6, the same size. I selected them all and centered them with allign. but there is still one of the input ports that shifts slightly. How can you set this alignment correctly?The top part of the attachment is the Data Inspector. The bottom part is the PDF. The green areas have shifted.

I saw a very similar question to this from a couple of months ago where the poster managed to resolve it on his own, but his fix did not work in my case.I'm reading from AutoCAD Map OD (multiple files) and writing to AutoCAD Map OD (single file). I've checked my template file and Shape File Folder Path and they all seem to be fine, so I don't understand this error or why my workspace won't run.

I have hundreds of json file saved to one location, they have a structure as example below: [    {        "json_featuretype" : "1da87ac9-2472-42da-a80f-cba37a36cce5",        "path_directory_windows" : "C:\\Magda_H\\test\\",        "uuid" : "1da87ac9-2472-42da-a80f-cba37a36cce5"    }] I’d like to use PythonCaller to save them to location as state under:  "path_directory_windows" : "C:\\Magda_H\\test\\". Can I please ask for the help with creating a python script to run this. Thank you

I found that Industry Foundation Classes (IFC) (Tech Preview) [IFC_API] Reader in FME 2024 cannot reader IfcOpeningElement features and non-subtracted wall, slab etc. features.In some cases it's essential to read IfcOpeningEelement features as simple solid geometries and non-subtracted features.It would be nice if the [IFC_API] reader would have parameters equivalent to the "Subtract Openging Geometries" parameter in the current Industry Foundation Class STEP/XML Files (IFC) reader. 

hello , 👋 I'm working on finding the path for specific lines and reorder points .I have several lines, each defined by a start and end point, but these lines also contain intermediate points. Should I merge the intermediate points with the lines before using a shortest path finder, or how will the transformer know which intermediate points belong to each line if I don't provide them? My goal is to reorder all points, including the intermediate ones, to find the correct sequence from point A to the final point, such as A, B, C, D, E, F, G.

Is it possible to write an image from a jpeg url into a file geodatabase? In other words, I want to store images directly from a url into a geodatabase. I need to extract the image from the url and move that image into a geodatabase. Thank you!

How to securely achieve the desired order of in which are feature types (tables) written in the database? I have some FK dependecies in the target tables and I have somehow discovered that its written from the bottom to the top of the feature types list. If its not written from the parent to the childs it crashes on FK violations. I know there is an idea registered. But so far what are the options? It consider the inserts/updates and also deletes where i would need the inverse order.Thank you for the suggestions.

Hello, I’m new to FME and I’m encountering a problem where the same rows of data aren’t being saved to both writers. I have two writers connected to the same database but with different tables. When the data is processed, the one saved in the shp_db_b table and can be seen, but there’s no output for the dashboard table (Even though it said ‘Translation was SUCCESSFUL’). I think the issue might be with the Aggregator transformer, but I'm not completely sure. I've attached the relevant pictures for reference.  

Hi,I am trying to put data in a zipped file geodatabase in 4 feature tables. Only 1 table is written to the zipped file geodatabase, the rest are not. (no error message). If I write to an unzipped geodatabase file, the 4 tables in the geodatabase are written. How do I write multiple feature writes in the same zipped file geodata tables? (I have tried feature holders to put tables 1 by 1 in the zipped file geodatabase but that makes no difference). 

Hi all,When I write to a newly created Feature Service on ArcGIS Enterprise, the attribute data doesnt populate, all the attribute column data is null.The shape data populates but the attibute data doesnt for the Feature Service.Has anyone come across this when writing a Feature Service to ArcGIS Enterprise using FME?ThanksAnthony

Hi, I have generated a tree in FME that looks like that (data type=buffer)How can I save it as in Excel so it looks the same? I assume the question is how to change buffer data to an image

Hey all, In my previous post It was suggested to use TempPathnameCreator to download these files and once processed, the location and file will be deleted, saving disk space. However, I am unable to view any data in the FeatureReader. In this instance, my FeatureReader has 905 records under the <Generic> Port, but when I view it via Feature Caching, it says “No Schema” for the attribute name and all the values are empty. However, If i click the Columns and hit “select all” it seems that I can actually see the tables, but I can’t seem to access the data with an attribute remover or the likes. Do I need to expose some attribute within the Generic Port <Attributes to Expose>?Any help will be appreciated! Thank you!

Hi all,I am working on a translation in FME, and I’m encountering an issue where my data is being fanned out to multiple locations. However, when FME tries to write the shapefiles to the first file location, the translation stops without any specific warnings or error messages, other than the general "Error running translation."Interestingly, on FME Flow, the process behaves similarly. It doesn't throw any errors, but the translation simply stops after attempting to write to the first location, as if it's hanging or failing silently.I’ve tried to troubleshoot by checking the file locations and permissions, but the issue persists. I would appreciate any guidance or suggestions on what might be causing this or steps I can take to diagnose it further.Thanks in advance for any help :)

Hello,I have an excel files with values in it. I read the excel file, want to use the value from column E (value is 45), use it in a math formular and calculate a new value. At the end the result should be written in to a Feature class in a FGDB. The transformer I want to use is expression value. But the calculation doesn’t work. Has anyone an idea? Thank you!Teresa  

Does writing to a MapInfo Extended TAB format take longer than to a MapInfo TAB ? Just wanted to check with the community if this is a known/expected behaviour with writing data to MapInfo Extended TAB and also if there are workarounds to quicken the writing process.Although I have experienced FME 2017 take considerably longer time to write a MapInfo Extended TAB for polygon data that is about 1.2 million in count, I failed to take note of the actual time it took, from the log. I do have a stat for a much smaller dataset, that of 1500 polygons and it took about 14 minutes to write to a MapInfo Extended TAB

Hi! I have a new question today. I want to create centerlines on highways. Now, long lines, without intersections, work fine. However, i get wrong results when fme encounters a intersection, like in the pictures below. I expected this and tried to solve it, but it only became worse.  Does anyone know a right way to do it? Thanks in advance!    

Microsoft SQL Server Spatial Reader now fails to connect post upgrade to 2020.1. It worked with 2020.0. We are getting this error: Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. - is there something we need to install?

I have got some beautiful Excel templates containing tables (not normal ranges). It's quite easy to write to a named range within Excel but I haven't figured out how to write to a Table. Does anyone know how to do so?

I have an excel file that has a list of addresses, and their associated license number.I want to join this to a geodatabase file to output any parcels that have any of the addresses in the excel file.  I can’t seem to make that work.  Can anybody point me in the right direction?  I’ve tried FeatureJoiner and FeatureMerger and can’t seem to get any output without failure.

I’m using the Data Interoperability extension in ArcGIS Pro.  I can’t seem to get a excel reader to add in.  I’ll set the parameters, it’s not open anywhere else, it’s not password protected or anything like that, and it’s on my local system.   When I click ok to add it, fme acts like it’s trying to add it, but then just sits there and spins until it eventually times out.   What am I doing wrong?  I haven’t used FME in about 7 years or so, but I used it extensively prior to that and never had this sort of issue.