Best Answers

So this is a problem that keeps coming up...we need to report text differences between two versions of reports. I can access the before and after fields and read them into FME, but I am searching for ways to analyze the strings and report the differences (additions and deletions).The ultimate goal is to format a report with additions (green) and deletions (red) clearly marked. As a start though, I have to find some method to analyze the two strings and perhaps break things down enough to be able to re-assemble a properly formatted string, perhaps with HTML. Nothing is jumping out right now as a simple answer, so I suspect it is not as easy :)I have looked into the custom workspaces "FuzzyStringComparer" and "FuzzyStringCompareFrom2Datasets", but I don't think they will help me much with the above. I thought about a process of chopping a string into individual words and do some repetitive looping using Regular Expressions to determine which chunks existed before

Dear FME community.I would like to make a loop with concatenation of values like a hierarchy.The result like that :In this case I can have 1, 2, 3, ... x levels, that's why I don't know how to do that.Thank you for your help.

hello. FME tells me that the Command-line to run this workspace isfme.exe abc.fmw --SourceDataset_DGNV8 "abc.dgn" ^--SourceDataset_LAS """"""10.las"" ""11.las"" ""12.las"""""" When executing in dos window only the first las file is processed.any help would be greatly appreciated.

I am unable to read a netcdf4 file into fme (2015, 16 or 17).I get the following error:NETCDF reader: `C:/Users/phtr/Desktop/TCI_ref_to_month_europe_2000_v1.nc' not recognized as a supported file format.NETCDF reader: Failed to open the dataset 'C:/Users/phtr/Desktop/TCI_ref_to_month_europe_2000_v1.nc'. Please ensure source data is valid and correct reader is selectedA fatal error has occurred. Check the logfile above for detailsFailed to obtain any schemas from reader 'NETCDF' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationIf I convert the input to netcdf 3, FME can read it OK.Is anyone else having this issue?  Is it a know limitation of FME?Many thanks

Hallo guys!I have a good question about the if statement (pls look on the pictures). I wanna check if the line is the first one (with Count) then i set my s1=0, after that i want that the next s-value is s2=lenght(first line) and on the next line i need s3= length(first line)+lenght(second line). Its just a straight road so i just have straight lines. I have now the question how can i get the lenght from the last object to fill up the s-value from the next one? My next question is if i try the "if Statement" it include the word "xmlns" into the file and i have no idea why. I hope anyone have a answer for me. Thanks !

FME Server 2016 and earlier have a setting for SECURITY_SUPERUSER_ROLE. The superuser has some permissions that you cannot give to other users, such as doing a backup / restore. Does FME Server 2017 have this concept? I don't see SECURITY_SUPERUSER_ROLE in the config files.It looks like the admin user is the default superuser, is that correct? If so, is it possible to grant other users the superuser powers? I would like to assign the superuser to an Active Directory group but can't figure out how to do that, even when logged in as the admin superuser.

I have one line that express one bus route and would find the bus station within 375 meters. There is other transformer besides NeighborFinder should I use?

Hi,Currently in FME 2018 it´s possible make loop in not custom transformer? Or only custom transformer yet?

Is there a way to create a transposed table in the MSWordStyler? I'd like to have attribute names in column 1 vs. attribute values in column 2 like this:So far I only managed to create a table like this:The horizontal presentation isn't really useful for Word documents, especially when listing lots of attribute values.I've tried creating several individual tables that I concatenate when writing but there will always be a line break between them. I've also had a look at the msword_table_col_header{0} and msword_table_col_value{0} format attributes but it looks like they don't allow for more than one row either.Is there a solution?

I have a problem with FME Server 2018 with version 2018.1 - Build 18520 - win32I installed fme server on windows 10 32-bit and I got the license but engines are not available.I have tried many times to remove fme server and re-installing again but the same problem.When I opened web interface I got those error messages as attached.

Looking for tips to improve performance when selecting rows from a database based on an incoming set of features.  For example, say I have 150 points going into an initiator port on a FeatureReader that then reads 4 tables/features from an Oracle SDE database.  Scenario 1: Spatial Filter is set to "Initiator Intersects Result" While this does greatly improve performance over reading everything from all 4 tables/features, What else can I do to improve performance here? Is there a way to send all of the features at once? OR generate a set of search envelopes to send to the featureReader?  (I tried creating a BoundingBoxAccumulator, but if the points are not close together, this will select too many of the 4 features)  Here is an example of the kind of output in the log file for each of the 150 points that are sent to the FeatureReader (note, I've change the lat/long): Notice - Performing envelope query on the `GEODATABASE_SDE' reader, post-filtering spatial predicate in

Hello. Looking for some suggestions on how to fix geometries. These unnecessary vertices are the result of import from MicroStation cadastral based DGN files. The unwanted vertices are on a cadastral grid line.First case, lines with extra vertex that should be removed:Second case:2 line segments that should be merged, assuming they are colinear. Would need a test for that, right? In the screenshot below, the short segment south of the green highlighted segment should be merged with the green highlighted segment and defined by 2 points (again, assuming they are colinear).Third case: polygons with extra vertices like in the line segments. Pt 4 (and others at cadastral grid lines) should be remove (assuming colinear segments):There are ~25000 lines affected and and similar number of various polygon features.Thank you for any direction!!

Hello,For a distributed installation of FME Server, what are the database requirements? I imagine it will vary a bit based on number of jobs, engines, and such, but is there a rough guideline for the volume of data the server will need to store?

Hi to all, I didn't find any information about requirements for ArcGIS Server and Portal installation for possibility to publish ArcGIS Feature Service. I mean Hosting, Data Store instalation and so on. Documentation? Thanks.

Hi,I think FME does not treat some arc during transformation.I have a polygon in a dwg containing a long arc:What i see in acad:What i see in FME Data inspector: the main problem is that some function like spatial relator (IE: "Requestor is within supplier") don't see the circle in the polygon.In acad, all my circle are inside other polygon, here is what spatial relator see, the highlighted circles are misinterpreted.If i use a dwg writer to ouput data, the arc seems correct in acadIf i use a shape writer to ouput date, the arc is like the one in FME data inspector.I attached the minimal workbench and dwg to this post.Any hint?David

I want to run the workspace by command line. But my workspace don´t have source dataset and output dataset. I´m using just creator and HttpCaller for download the zip file.I haven´t experience to run workspace by command line. I was created the batch file like this:fme.exe C:\\Users\\FME\\Desktop\\Workspace\\download.fmw LOG_FILENAME c:\\fme.log But nothing happens..:(

Hello,I want to to use the NetworkTopologyBuildrer. However, this transformer requires that the network must be topologically noded. How can this be achieved in FME ? Thank you very much

Is it possible to alter a workspace's output before it is zipped and made available for download through the data download service? Specifically, I'd like to output a shapefile, then alter the .prj file using a python shutdown script. All of this before being made available to the user as a zipped download.

I am attempting to configure an email subscriber. I have been following the tutorial concerning this. I have used the snippet of JSON in the tutorial to successfully send/receive email. I can remove the foo@bar.com address from the "email_to" parameter and it successfully uses the setting in the subscriber for the "To:" parameter from the foo@baz.com address. So, email is crossing the SMTP Server (Relay) I've configured in the subscriber. I can even place a personal gmail address as the "From:" and it successfully sends the email. However, when I try to configure the "From:" using an existing email address on our domain.....no dice.Any ideas would be greatly appreciated. Thank you in advance.

I am trying to create a Private Parameter Value from an Attribute Value. What I Have is a SQLCreator that is pulling two columns from a table. ROUTE_ID SYSTEM_CODEThe SQLCreator is using a Published Parameter to query out the data associated the user defined SYSTEM_CODE. What I want to do is assign a Private parameter from that result as the ROUTE_ID value. This would allow me to run other queries based on the Route_ID which is a unique number.

I have a dataset of bridges and I have a road network. I want to create reroutes for each bridge. So I want to clip the bridge part out of the roads to use the shortestPathfinder to get the new route . But I want to send the bridges one by one to this process. I got the workspace working as I want as long as I use just one feature but I need the to do the calculations on all the bridges, but one at a time. I´m really stuck on this one...

Hi,I'm trying to write data into a PostGIS database. However, I get the following error:Bulk copy failed on table 'schemaname.dataset' * using delimiter ':'. Error was 'ERROR: value too long for type character varying(3)CONTEXT: COPY dataset, line linenumber, column columnname : "attributevalue"A fatal error has occurred. Check the logfile above for detailsBulk copy failed on table 'schemaname.dataset' using delimiter ':'. Error was 'no COPY in progressThe type character of the column is not set to have a width of only 3. But I keep getting this (or other similar errors).I have tried multiple things:- Using CSV instead of Excel as a datasource- Increasing the width of the attributes- Changing the type of the attributes ( text or string instead of varchar) of both the reader (input) and output (writer)With the Excel file I would get a similar error, but on a different column and line. with the CSV it gets stuck.I have to note that

Hello allHoping someone can help, i have a minecraft world created with FME, this world contains the Ground mesh.i now have the 3d geometry for the trees and buildings, i want to add this geometry into the exisiting minecraft world.Any ideas. Thank you

I´m using this comand: cd / "C:\\Program Files (x86)\\WinRAR\\Rar.exe" x-y "@Value(_response_file_path)"The file is downloaded correctly but the unzip process don´t work properly.Thank´s

Hi there.I was trying a simple task to download a csv file from S3 and convert to a shapefile. I could download files with S3 Downloader and narrowed down to my target CSV file with StringSearcher. Then, I used FeatureReader to read the target CSV but I couldn't bring any attributes in the CSV file with this process. I am hoping I expose all attributes including latitude and longitude. Then I want to generate geometries from those lat & long with all attributes.When I run the above workspace, then I got no attribute like below. The process itself was successful though.Here is my original CSV table I was working on.When I create a Creator---FeatureReader workflow with a local csv file, I didn't have any problem to include (expose) all attributes. Why I am missing all attributes when I download a csv file from S3 but didn't happen with a local csv file? What I am missing here??Please give me some advice!Thank you.@hirooimaki