General

How can I compare 2 lists and find match elements as per the attached snap:I have 2 different data sate and I need to match attributes as per the element in dataset 2 list2 elements are mandatory and in dataset 1 list1 elements are should contain list2 elements. if list 2 has 3 elements and list 1 has 5, list 2 elements 3 must match list 2 elements, and the rest 2 elements of list 2 are optional. kindly refer to Snap for a better understanding.  

how can I extract the Shapefile from this link via FMEhttps://tgftp.nws.noaa.gov/SL.us008001/DF.sha/DC.cap/DS.WWA/current_warnings.tar.gz   

I have two SQL Server spatial tables (one containing current records and one containing archived records) that I need to merge and read the features ordered by their version number in order to do onward processing in FME.  I have been trying to use a SQLCreator to read these records into FME in the correct order using SQL similar to the below: Select a.* from(        SELECT   [fid]   ,[toid_version]   ,[SHAPE] FROM [dbo].[a_boundaryline]         union all         SELECT    [fid]   ,[toid_version]   ,[SHAPE]                       FROM [dbo].[boundaryline] ) as aorder by a.fid, a.toid_versionThis SQL works in SQL Server management studio without issue. However, when I use it in a SQLCreator (or SQLExecutor) I get the following warning(s) in the log and the geometry is not read (i.e. features have no geometry): ---Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT * INTO #fme_tempAdoDataTypeTable_spatialReader FROM ( Select

I am new to FME Server.  I have a workspace that I published to FME Server. It reads from an Excel spreadsheet, and writes to a File Geodatabase and Access Database.  The data for the reader and writers reside on separate servers, they are not loaded into FME Server.  Can someone take a look at the screenshot and let me know if the Published Parameters are correct? I seem to recall that for the spreadsheet (see red arrow in the screenshot), does there need to be a parameter added to replace the UNC path? What you see in the screenshot is how the workspace was published into FME Server from FME Desktop.  Do I need to add the UNC paths shown in the screenshot as Resources? Can someone explain or point me to a link that explains this process? Can I keep the UNC paths for the File Geodatabase and Database Path or do I need to replace these with an FME Parameter as listed here:https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/!Transformer_Parameters/FME_parameters.htm  

I have 3 workspaces; they need to be run like this:​1st to be run is workspaceA, 2nd to be run is workspaceB, 3rd to be run is workspaceC.​I know in Scheduler I can set each to run for example: ​workspaceA runs at 905p, workspaceB runs at at 910p, workspaceC runs at 915p.​But, this approach poses a risk that if workspaceA fails during its run, workspaceB and workspaceC will still run and that could corrupt my data. It seems more prudent that if, for example, workspaceA fails to run that workspacesB and C will not run.​What is the best way to deal with this situation using FME Server? ​Should I create a new workspace using FMEJobSubmitter Transformer or add FMEJobSubmitter Transformer to the workspaceA, B, and C?​​

Which transformer to use to count the number of joint between connected overhead line and underground cables in ArcMap?

Hello,what are the options for converting Excel data to XML, please? Can you provide me with multiple options (easier/more complex)? Is it possible to show me a graphical representation or even send a file directly? The problem may also occur with the XML file format, but I would address it by using an XSD file. Thank you very much in advance for your help.

I have created a workspace, successfully ran it in FME Desktop. I published it to FME Server. I built the schedule.  I have admin rights to all the servers. ​The workspace reads from a File GDB on another server and writes to a File GDB on a different server. In FME Desktop I am able to make connections to the folders which these GDBs reside. All paths are UNC paths. ​When I run the workspace on FME Server, I receive these errors:​632023-6-30 16:27:10 | Geodatabase Error (-2147024891): Access denied.642023-6-30 16:27:10 | Could not open File Geodatabase dataset `\\\\myserverBob\\folder5\\thtestfmeserver\\test2.gdb' for writing​The Reader reads from this File Geodatabase: \\\\myserverAnn\\folder1\\folder2\\Staff Folders\\folder3\\th_fmeservertest1.gdb​The Writer writes to this File Geodatabase:\\\\myserverBob\\folder5\\thtestfmeserver\\test2.gdb The Workspace I published from FME Desktop is for testing (since I am new to FME Server), it includes a single reader, TimeStamper Transfor

Can FME be used to start and stop a geocoding service? if this is possible I would like to create a workbench that does this on a schedule eventually using FME Server.  Can someone provide me some pointers on where I should start?

Based on the unit of "Find Your Way Around the FME Academy""Show Off What You Know""You've worked hard to earn points and badges, and your profile is the place to show them off. Click your profile image in the top-right corner of Trailhead and click Profile to see all the badges and points you've earned so far, and a breakdown of skills you've learned." However once I click the profile in the top right corner of trailhead, I can't click my profile to see the badges and points that i achieved.  Do anyone know the reason why please? Thank you 

I am new to FME attempting to take over support for Smallworld to Microstation translations; inspecting the existing file that the translations are using I am noticing red and yellow symbols that seem to indicate an error. Just looking for some clarification on what these mean and if this is a cause for concern. It looks like the writers are just not receiving anything for some of these attributes. Any information is appreciated. thank you.   

Emailer & AGO Online Connector: Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer' PythonFactory failed to load python symbol `fmepy_emailer.Emailer' Factory proxy not initialized All references and solutions found for the error message below were mainly focused on FME Server & Cloud. For us, the problem only occurs in the FME Workbench [2021+].  We did reinstall the Geo packages for both of the transformers, but no succes. Where can I find the factory proxy to set up? Or is it something else?  Thanks in advance for your help! 

I have followed this pattern of a workflow for years, where I maintain attribute names and data types in a spreadsheet for different databases, and I import those names and values using the Import... dialog within the AttributeCreator as one of the last steps of a data workflow.​When I import values, here's what I usually have in the AttributeCreator:​Output Attribute Valueattribute{0}.name AreaNameattribute{0}.fme_data_type fme_varchar(64)​Now that the AttributeCreator has a data type in the dialog, should I still follow this pattern?  How does this new data type parameter work with dynamic workflows?

Where can I download of instruction manual for Advanced FME

how can i extract RTF format file in feature reader

Greetings, I keep getting this error:Out of memory. Program terminating.  I ran the FME Performance Tuning document. I cannot set the FME Temp to a SSD.I am reading data from an ESRI fgdbMy laptop configuration is: Core(TM) i7-1255U  1.70 GHz16.0 GB (15.7 GB usable)Any suggestions are appreciated. ThanksClive

I am attempting to write a raster file to a PostGIS DB held on AWS. There is a schema set up to write to and the PostGIS Raster extension has been enabled in the DB. I've added the connection into FME and can successfully connect to itRunning the writer gives the following error message; "Writer failed to create table 'tif.test' because requested schema '\\\\gis\\GIS\\Qgis\\Data\\Raster\\Open Map Local Raster\\SP56SE' does not exist. Please specify an existing schemaPOSTGIS_RASTER writer: Writer failed in write() call" Can someone advise me why this is failing and how to resolve it.

I have a problem that RasterResampler does not provide good enough quality when scaling down a raster. I have tried all the methods available but it is "far" from the quality I get if I do a rescaling with e.g. Irfanview, Pillow (python library) or Photoshop. Are there any other tricks one can use to get better quality when rescaling with FME? See this image where I scaled from 2308x2212 pixels to 512x512 pixels. The left image is what FME can give me with the best settings I found (Average 16)The right image is downscaled with Pillow (python)  Note how "pixelated" FME's result are. Compare for example the road markings.

I have multiple site template polygons, with various dimensions. Let's say I have 2 polygons that are 100' x 100' and 200' x 200'. I then have multiple parcels that I need to see if any of the site templates fit inside the parcel polygons, no matter the orientation of the site. What would be the best method to determine this? The outcome would be finding which site template, if any, would fit and the orientation within the parcel polygon.

Hello,  I would like to ask if it is possible in FME to configure it to always work with the first column or row without knowing its name (to use columns or rows based on their general order). I have many Excel files where columns and rows have different names. This way, I wouldn't have to rewrite everything each time. Thank you very much for your help.

PostGIS database connection I havent been able to connect to the database for the training session. Im currently using the 2021 version, do I have to use the 2022 version?

I have a workspace projecting 3D airspaces to a KML. I am trying to color each different type of airspace certain colors for each type and opacity value but the writer seems to ignore the kmlstyler and I end up with random colors with no opacity. Anyone run into this before?

Hido you know when FME23 will be available in Arcgis Data INteroperability ? Thx Francesco

I have a shapefile with many polygons, of which some portions overlap. When I use the AreaGapAndOverlapCleaner, it disconnects the overlapping portion, but makes it an independent feature with data of either polygons, i.e. now I have two polygons with same data. What I want is, the overlapping portion to be merged with any of the polygon feature. How do I do this? Help me Please