Using transformers to modify data.
Recently active
I'd like to find some documentation or information regarding the lookup table attributes 'Type' and 'Mapping type' associated with the Schema Mapper. I have done a lot of digging around the FME knowledge base and cannot seem to figure how to format the values associated with the attributes. This article has many different use cases associated with the Schema Mapper. I downloaded the associated FME Workspace and CSVs. The CSVs have different values assocaited in the 'Type' and 'Mapping type' fields.: https://community.safe.com/s/article/schemamapper-use-case-example?r=1807&ui-knowledge-components-aura-actions.KnowledgeArticleVersionCreateDraftFromOnlineAction.createDraftFromOnlineArticle=1
They have more in common with the Min and Max Extents in the Feature Information window than down below where the geometry coordinates are. Should I expect the indices to align with the existing coordinates? Do aggregates change how the CoordinateExtactor works? It is really mystifying. Any insight is appreciated.
Hi,I am facing a problem while using the realdwg-writer to put out autocad files that include multi-texts (the process running in advance is doing fine). Many of my source files have multiple viewports with different scales (e.g. 1:200 and 1:100). Before writing the data, the values in the autocad_anno_scale list look like this: When opening the resulting DWG file (input DWG is used as template), the aforementioned list includes additional values: Because of this, some multi-texts get different sizes in the viewports in my written files than they have in the original ones. In the case documented by the screenshots, the text is depicted smaller although it should stay the same size, just like it is in the source file. I've tried some workarounds I came up with, but unfortunately without any success. Is there a possibility to control the sizes of texts when writing them to a DWG (or to just keep output sizes the same as input sizes)? Because I have to use my workbench on quite a n
FME Desktop 2022 Build 22304: “GeometryFilter” with and without “GeometryValidator” prior to it shows different results considering that nothing is repaired, I couldn’t figure out why “GeometryFilter” with and without “GeometryValidator” prior to it shows different result considering that nothing is repaired. How come a “multiarea” is detected if the “GeometryValidator” is run before the “GeometryFilter” but never identified if the “GeometryFilter” is run without “GeometryValidator” prior to it? What could be the issue here? The data is attached
My FME translation includes 2 different streams depending on the type of data provided in a zipped file GDB. So the first step before processing data is to test whether it contains a rater dataset/mosaic dataset or any number of feature classes. I don't want to read data yet, just check the data type of feature datasets. What's the best way to check that? Tried a generic schema reader but it doesn't provide an attribute with the format of feature types inside the file GDB.
I would like to make a custom map for Power BI's Shape Map visualisation: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map When I make a TopoJSON with FME and open it in Power BI I see a completely filled square (basically the bounding box is filled). When I take the TopoJSON generated by FME and process it using the default paramaters of the online mapshaper tool (https://mapshaper.org/) by exporting as a TopoJSON the mapshaper TopoJSON file open's without a problem in Power BI. When I compare the FME TopoJSON files to the mapshaper TopoJSON file using a text reader the only obvious difference that I see is that the parameters are in a different order, but the scale and transformation parameters are similar. I have attached the files to this message. Any ideas on what I need to do with FME so that the outputted TopoJSON files will open in Power BI?
I am trying to extract records from one table based on a series of date ranges in another table. I want all the records from table A, that fall between date ranges from table B. Each table B row has a start date and end date.
Hi.I'm generally use the workspace repository to assign job queue when scheduling job executions, although I have a couple of special queues to enable high importance jobs to run sooner.But jobs that are not scheduled by the FME server itself, instead being initiated via the REST interface, all seem to end up using the Default queue.I've looking into the API example, and it doesn't seem to include a queue name request parameter. And there's no way to create a queue designated for REST initiated jobs.Is it possible to control the execution queue with REST initiated jobs ?Using 2020.2.5
Hi,I have a set of polygons following a line like shows attached figure. The distance between these polygons along the line are the same. Objective: I have to create some polygons at the end/beginning of the line in the same line direction. Line could be in any direction, not only horizontal. Method (FME Desktop 2020): The original dataset is a polygon shapefile, so (1) I have computed a layer with center point of polygons, and (2) I have constructed a Line (LineBuilder) with this ordered points to know the line direction. (3) I generate a new polygon at the beginning or end of this line at some known distance. The size of new polygon is the same as the original ones, and I have to translate the polygon along the line (In fact, I have to generate several (n) new polygons along the line equally spaced (d)): I have extend the line (LineExtender, n*d), split the line n times to get center points,and then I have to create a new polygon in every center point. Question: Is it possible to mak
Hello, I have vector data as gdb with multiple data layers: Communes Building Roads Green spaces I want to be able to cut out this data a bit like a cookie cutter according to the boundaries of the municipalities and group all the corresponding data, eg: Municipalities_01 Building (for this area) Roads (for this area) Green spaces (for this area) Municipalities_02 Building (for this area) Roads (for this area) Green spaces (for this area) Municipalities_... Building (for this area) Roads (for this area) Green spaces (for this area) Do you know how I can achieve this? Thanks very much
We have just upgraded to FME 2020.0.0.1 and are slowly testing our different workspaces. We use the python print command to log different things into the FME log file and since we have upgraded to 2020 all these log statements has disappeared form the log file. Python compatibility is set to 3.7+.Is that somehow a feature or a bug?
Convert GDB to GML Hi I'm a beginner with FME, so I need help because I want to convert a GDB to GML and I don't know how to do it at all. Can you help me ? Thanks very much
Good morning. I have a table with two geometry fields in a SQL Server database. The coordinate system for both of them is EPSG:25830. I've followed this article to be able to write both columns at the same time: https://community.safe.com/s/article/writing-to-tables-that-contain-multiple-geometry-c It works great; but, when I check the SRID of both fields with the function STSrid, I get the 0 value for both of them instead of 25830. Before writing, I set the coordiante system with a CoordinateSystemSetter, so I don't know why it's not stored properly. That doesn't happen with tables with just one geometry column. The data comes from a DGN (v7) file. I'm using FME 2021.1.0.0. Am I missing something? I've found this question with a similar issue from 5 years ago: https://community.safe.com/s/question/0D54Q000080hQwSSAU/multiple-geometries-with-different-srsid-The last answer was by @mark2atsafe saying the devs were going to check it, but no further posts about i
Main workspace:LoopingAndBlocking.fmxThis gives me error: > Custom transformer 'LoopingAndBlocking' does not have a port named 'PrivateInput' which is suitable for parameter 'LOOPBACK_INPUT_TAG' Settings:Enable blocked looping: YesMax iterations: 100Attribute to hold iteration count: FME_LOOP_ITERATION_COUNT Using ALWAYS LINKED Publishing the PrivateInput Port does solves the LOOPBACK_INPUT_TAG problem, but then my feature are outputed through the Incomplete port. That suggests they could not be looped at all? Any thoughts appreciated. Attaching fmw + fmx
I have a script that strips a bunch of feature layers out into a GDB database that is then zipped. I then made a Creator that attached to ftpCaller. I set in the properties 'create at end' to be yes. This seems to work, however i notice it seems to still be doing the upload while other features are writing to the gdb. how can i say that i want to run the creator and the ftpcaller after every other feature has been written to the gdb? thanks
How would I go about copying the name of a column and using it as an attribute?
What is the best way to join 2 ArcSDE layers and then add a whereclause on the joined data?
Working with ArcGIS SDE Enterprise and feature classes. I am looking to create a back up of feature classes every month. The gdb changes every month and feature classes get added. Is there a way to automatically add readers based on those additions?
Hello, I am looking to convert RGBI (four bands) tiff files into JPEG2000 format and maintain the RGBI data. I cannot seem to work out how to maintain the infrared band as the write format seems to allow for that.
Hello please advice. How do I view these attributes? They are not visible in the workspace. I only see them in the data inspector. Thank you
Is there a work instruction to sort a text file then export as a Excel? I have attached my current workbench and file as ZIP. I need to sort into 0-500, 501-2000, 2001+ sections.
Hi All,I am just starting with FME and so far it is amazing! I downloaded a CityGML file for the sidewalks of NYC (see attached) and want to export it to Unreal Engine. ( I already did the same with another cityGML file and it worked great) Yet with this particular model (it is 800 mb, so I have to use google drive link here: https://drive.google.com/drive/folders/1Ov3Y_y2IVs_MPiazpZO1o2xNnMWiTEju?usp=sharing ) it exports empty file and the geomerty is not showing up in FME Workbench, while I can see it in FME Inspector. At this point I am pretty desperate and cannot find any solution on how to address this..Please let me know if you know how to resolve it! I really appreciate your time and help!
Hey - I have to transform a lot of DWG Files into a custom coordiante system. The transformation works, but I have a problem doing so when a file has external references (in this case the reference points to another DWG in the same directory, which therefore has to get transformed as well). Following my first thought, I tried to transform all files but leave the insert points for the references untouched, but this didn't work. Even when discarding the RealDWG reader Option "Read External References" or trying to filter out everything that has the value "autocad_xref" for autocad_entity with a test filter and letting these objects bypass the transformation process in my workbench, I'm getting the same result: The insert points for the references are transformed too and therefore seem to be shifted double the distance in comparison to other objects. Do you have any advices for me how to solve this problem? Thanks a lot! :-)
Hello! I need to open a raster and use it as a reference to create a larger one (a few inches bigger on the height of the initial image). This procedure must be done for a set of images of varying sizes and not georeferenced.Later on combining the two files, the original and the other that was created (I thought use the RasterMosaicker), I would have an additional blank area at the bottom of the image where I could add a text box. I'm having trouble with:- creating larger images that have as reference a set of images of varying sizes- adding the text box with message in the fixed position (the bottom border that were added in each resulting image). Does anyone know any transformer or transformer set to solve this problem? Thanks for help!
Hi, i'm trying to use the to rename the attributes. What i want to to is replace a part of the attributes with the values of a string but nothing seems to happen.If i use a regular string (f.e. "_1987") it works but if i use the expression @Value(_listJ{0}.J) nothing happens. Is this allowed? can i use a list in the field string?