Transformers

Dear friends,Please help me to merge two databases in single MDB, merge MDB file for winter 2019-2020 to winters 2009-2020 mdb database. I tried few options and it did not help much.Also, I want to setup the system in task schedule. Thank you. Abzal

Hi, I am trying to generate a table with N columns and R rows as a layout page in a DWG file. I have this table defined as a template and the data is from different sources like shape files. I am creating a Multi-text for each field and using a VertexCreator with a fixed x,y position in the paper space to place them at each column. Everything works fine except that the rows are filled in the upward direction rather in the downward direction. Is there a way to auto calculate the position of next row ( x,y ) for multi-text or any other ways to auto fill the table ? any insights to set the rows automatically would be highly appreciated.

I am trying to run a python script in a PythonCaller to Truncate Features in an Oracle ArcSDE database.If I run the script and hard code the Feature it runs fine but when I try to use feature.getAttribute to read a list created in a previous transformer, I keep getting:Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.ERROR 000187: Only supports Geodatabase tables and feature classes My script is:# Import arcpy moduleimport arcpy def processFeature(feature): IFeatures = ('C:\\\\AppData\\\\Roaming\\\\ESRI\\\\Desktop10.5\\\\ArcCatalog\\\\Connection_to_HYDRA.sde\\\\' + feature.getAttribute('_list{0}'))  print (IFeatures) for mark in IFeatures: arcpy.TruncateTable_management(mark)

How to get tutorial materials for FME

i would like to ask about Aggregaator transformer  i have several lines with intersection nodes with another lines i used network topology calculator and aggregator combine by network id with generate list and it works great but my problem when i am using deaggregate transformer or List Exploder to show again the attribute of each line ,it has a list say for specific line consists from 3 line so it has three id for the three line . but after i use list exploder ,i found in the inspector it does not know exactly which id of line relates to this segment ,it refers to the whole line (as this id ) ,when i choose the second id ,it refers to the same whole line .but it should specifies ,which segment refers to this id not the whole line .How could i solve it ?i have another question about line combiner , after i tried to combin on attribute by network id ,break attribute yes ,it can not able to combine all the lines that has the same network id but aggregator can do that .do any one h

Hello therewe need to generate a report for then many roads,we need to draw a line between each point and show the distance valueThe same as the image belowis there a way we could use FME in this case   

When attempting to update the geodb_type attribute from geodb_pro_annotation to geodb_annotation the attribute becomes missing. I'm assuming this isn't expected behavior, so looking for any insight into my problem.For background, in my process I am reading ArcGIS Pro annotation from a file geodatabase and writing it to an FFS file in a separate workbench. This annotation started as standard geodatabase annotation, was upgraded to pro, and I am trying to write it back to a standard geodatabase annotation feature class.In the workbench that is reading the FFS file I am exposing the geodb_type attribute, then updating it with the AttributeCreator. The exposed attribute has a value of geodb_pro_annotation, but after trying to update the value it becomes missing.The image shows the relevant part of my workspace. The Visual Preview is showing the output from AnnoAttributeCreator.Using FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN32)

Forgive my probably dumb question as I am still learning the volume type data.My end goal is to create a volume object from a pointcloud and export it as a solid for cad. I suspected this had to be easy but it might be harder than I anticipated.What I did was feed the pointcloud to a TinGenerator and I got an acceptable surface, which I can apparently not symply extrude. This is all I want, an extruded surface with a thickness of 1 meter.I found the BRepSolidBoundaryCreator.Beta on the hub but it needs python 2.7 which I didn't install last time apparently.Do I want something impossible or am I missing the obvious?Thanks for looking :-)

Hi ,I need to do a conversion between 2 formats with many files in several directories ,how can I define that output directory =input directory

Hello,I'm very new to FME and trying a relatively simple workflow. I have a DWG file of a building layout. It includes polylines for rooms (all on one layer), and within each polyline, there is a simple text label for the room number (all on another layer).  I would like to transform the data in this DWG to an existing PostGIS table, where the room geometries will populate the 'geom' field and the text labels will populate the 'name' field.  I'm having a hard time converting the labels to text strings and also ensuring that the text labels are matched to the correct room polyline.  My current workflow is shown below:The room polygons from the DWG file import fine, however the text labels for rooms do not populate at all in the PostGIS table.

HiI wonder why FME sometimes add more decimals. For example:  If I import the number 652314.30, FME sometimes convert it to 652314.300000004Does anyone know why? I see this problem quite often and I solve it with the string formatter./Fredrik

Hello, I am struggling with an issue within my workbench. It is a bit difficult to explain, so I hope my explanation is understandable. I got stuck at this transformer: The failed output port is similar to this format: The passed output port is similar to this format: What I want to accomplish is the following table:So I want to test the outcome of the failed output port based on the fact if a value in the 'Number' column corresponds to a value in the 'Number' column of the passed output port. And if a row meets this requirement I want to join it with the rows of the passed output port.Can anyone explain to me which transformer(s) I should use to accomplish this? Thanks in advance!Eva

hi, I have an excel file, which has 3 fields: date, confirmed and country. But some data and confirmed values are without values. For those who are without values, I would like them to be filled out, considering the last value. In other words, the last data for a given country was 04/29 and the next data record for empty, the filling must be automatic for 04/30. The same thing should happen for "confirmed" if the last record is determined for 50 country and the next record is empty for that same country, the filled value must be 50, always the previous value.  thank´s

Prior in FME Server 2016.1, CANA83-10TM115-EAP is recognized by FME SVR.Predefined coordinate system `CANA83-10TM115-EAP' (Alberta NAD83; 115 deg West, positive easting coordinates) matches dataset coordinate system Now in FME Server 2019.1,  here is the log:Predefined coordinate system `10TMAEPFOREST_83' () matches dataset coordinate systWhich is not the one set in the submitted gdb. This is specific to FME Server, when running locally, CANA83-10TM115-EAP is set correctly within FME properties.  This is not a custom coordinate system so it should not be added to the Engine/CoordinateSystems repository according to the documentation  Any thoughts anyone? tks

Is there a way to import settings directly into the DGNStyler, ideally using an export from another Microstation file to maintain the symbology etc?

HelloI am looking to write a simple execution report in a file with the name of the writer / table name and the number of records written. I don't want to use summaryReporter or FME_END_PYTHON. How to do this simply? Thanks in advance  

So the last requirement for the professional certification states:Once you’ve completed the exam and have a grade of 75% or higher, you are ready to submit your application. Before submitting your application, please review the sample documentation. Your application must include: 2-3 workspaces from projects which conform to FME best practices as outlined in FME Desktop Basic Best Practice section. Your sample projects should demonstrate an advanced level of FME expertise. Any related files or information should be provided just as if you were delivering a solution to a client. Source data or output data is not required for your sample projects.Workspace documentation in a PDF, Word document, or Text file. Here is an example of workspace documentationReferences from 2 clients whose projects you’ve been involved with within the last two years.All parts of your application must be in English with the exception of your workspaces. At the moment, I'm only using FME that comes shipped

Simple need, simple question.I have a raster with 1 cell size 25x25 meters (geotiff)Just want to have the cell split up to a 5x5 meters raster with having those new 25 cells with a 5x5 meters raster having the same value as the original 1 cell of 25x25 metersAnd nothing else should change! But whatever Transformer I use or in combination with each other, it doesn't let me succeed in my goal.For example: with the RasterResampler it recreates a new raster with my desired resolution, but it doesn't keep the original values. It also seems to shift my raster. I have also tried to create a new raster and then use the points from that raster to extract the desired values. But that takes so much time to process...  What am I missing? What do I not understand?

Is it possible to transform a RASTER file into MBTiles format using FME? For example GEOTIFF raster to MBTiles format.Is there a tutorial on youtube?

For one user, SQLExecutor is correctly changing to connect to DEVSQL\\High at run-time. For another user, the default parameters specified in the SQLExecutor (QASQL\\High as shown above) are being used. What user configuration setting needs to change in order to correctly grab the same database as user #1 is getting?

Hi, not sure where else to ask this (first time poster).I have a large amount of coordinate data (only know the coordinates in Gauss-Kruger and the zone (zone 3)). Is there any way I can mass convert these coordinates to UTM? I've been researching this all day and have came across a few helpful research articles and one finished with a website that was created by a team of researchers using R and Shiny software, but the link was dead and I don't have time to recreate their work.I do not need to put them into a GIS, this data is being recorded in an rdb for analysis purposes, but is still very reliant on LOCIIDs.

Hi everyone,Noob here.I want to translate (move) the red lines in order to have the ending (or initial point) on the red line over the blu line. The length of the red line does not have to change. I tried with anchored snapper, but I think I need an anchored mover?!The red lines can also have many many vertices. Thanks,Have a nice day. 

Are there any known conflicts between Harris Geospatial FlexNet License Server and FME Server?

Hi,I'm trying to convert UTC datetimes to CET/CEST but can't find the way of getting a datetime that takes into account the Daylight Saving Time differences. The local settings of the DateTimeStamper or @TimeZoneSet function are of no use because the workspace is run in an FME Server where the local time is UTC.Thanks a lot in advance! Francisco

Hi, I'm using a JSON reader to grab data from an API. It's reading the attributes, but the datetime is formatted like so: 1587896100000 Firstly, what is the format of this? Is it JSON specific? And how can I convert to this to a SQL datetime,. which is where the output is going to be stored? ThanksN