Best Answers

Hi all, I have a number of shapefiles covering a range of dates, with each date recorded in the file name. I also have a number of area of interest polygons and I have been tasked with finding out how much overlap there is with each area of interest and each date period.  For each area of interest I was going to create a spreadsheet with the date taken from the corresponding file used as a field heading populated with an area value for amount of overlap. There are instances where there is no overlap between the two files. Is it possible to still take the date from the file name and attach it to the area of interest polygon and populate the field with 0? I have attached some sample data below Many thanks, Matthew 

Hello Team,I have a drone image ( jpeg ) and there are some metadatas informations, for example: longitude and latitude.I extracted these informations - center point of image.My goal is try to georrefencing this file using the transformer RasterGeoreferencer:  Thanks,Danilo

Is there a transformer that can convert a number into a number with a thousands separator, that is, "1000" to "1,000"? I know you can do it with Python but I can't find a transformer that does this.Thanks

Hello I've created a workspace, writing an IFX 2x3 file with two Property Sets per feature, which works well.Changing the writer format to IFC 4 the two Property Sets are not written. I've no Idea, what the problem could be and hope, that somebody could tell me, what I'm doing wrong.You'll find the workspace and the Data attached. Regards, Hartmut

Hello,I have a program to make that require the use of a PythonCaller. But unfortunately, it looks very different to what I am used to, doing Python work.I have looked up for some tutorials on how the input/output woks, but I have not found anything really useful, or even understandable.Do you have any link for a tutorial that goes further than just launching a PythonCaller ?I need to modify a SHP file, deleting some lines/geometry points and adding some, as well as features. All in 3DThank you

Hi everybody, I need to write to a sqlite database containing tables with foreign keys constraints, but FME seems not to enforce the foreign_keys pragma directive when connecting to the database. I discovered this by running a pragma foreign_keys; query against the database with an SQLCreator (it returned 0).This is obviously a problem, because in this way the SQLite Writer can insert records that violate referential integrity.Is there a way to make the SQLite Writer execute thepragma foreign_keys = 1;directive before start writing? Any suggestion is welcome! Thanks

How to get UTC time in FME 2014? TimeStamper gives local time >>When in DateTimeCalculator I'm subtracting hours from local time to get UTC time, but this won't work after Daylight Saving Time begins.

Hi,I have a postgresql table pre_val_error with following fields GRID_ID|ERROR_LEVEL|ERROR121|1|ERROR1121|2|ERROR2121|3|ERROR3 The requirement is to write all the records to a csv file and insert a record in Oracle with count grouped by error_level. The Oracle table details are below GRID_ID|ERROR_LVL1_COUNT|ERROR_LVL2_COUNT|ERROR_LVL3_COUNT121|1|1|1 As you can see, the number or records has to be grouped by error_level and inserted in Oracle. I have tried aggregator, counter and nothing worked. Can anyone suggest a solution for this problem. 

Hi I would like to call an oracle stored multiple times, passing different parameters. It seems only the first call is successful.Any idea what is the correct syntax ? begin storedproc1(param1, parm2);storedproc1(param3, parm4);end; I have also tried FME_SQL_DELIMITER / begin storedproc1(param1, parm2);storedproc1(param3, parm4);end;/

I'm a pretty new to FME so apologies if my question is a bit basic. There are 2 polygonal shapefiles, one that gets modified daily on a server and another we have in a sde. I'd like the first one to replace the one I have but only where changes have been made to existing polygons, while simultanously puting any new polygons created in a separate shapefile to add in manually for quality control. I'm not quite sure which transformer(s) to use. Any help would be appreciated, thanks!

I have an issue reading ifc files containing an IFC Class called:IFCPHYSICALCOMPLEXQUANTITY  https://standards.buildingsmart.org/IFC/RELEASE/IFC4/ADD2_TC1/HTML/schema/ifcquantityresource/lexical/ifcphysicalcomplexquantity.htm I have tried using a feature reader to read different types of Ifc Files, but to no avail, the file gets rejected. I found a work around, where I would open the ifc file as a text file and replace the IFCPHYSICALCOMPLEXQUANTITY with IFCPHYSICALSIMPLEQUANTITY and then save and close the txt file and run the fme desktop script again, which then opens the ifc file!? Does anyone know how to read ifc files with this class? I am worried that by changing the text, I might lose some dependencies or relations within the ifc structure.  Feature Request Rejection code:'ISO10303-21: Unable to open STEP file: W:\\000_mitarbeiterInnen\\000_fs\\02_FME_Watcher\\000_RawData\\TN05_V1_BEM_200827.ifc'. Please check that the file is readable.A fatal error has occurred. Check t

I have a network where I would like to identify intersections that are not connecting at endpoints. Each line feature has it's own colour in the image below and I would like to sort out all intersections similar to A.  At intersections B and C all the lines are connecting at end nodes, but the yellow line is touching the pink somewhere "midline". I would like to collect the point where this overlap happens. I have been experimenting with the TopologyBuilder but have not figured out to get the result I want.

Hey all Have a server process that is running some parrallel processing and its failing with some really bizarre cryptic errors. The machine has more than enough ram (36gb) and plenty of temp drive space (100gb free). Any one have any thoughts on a way forward? Running on 2019.2.1 build 19823  

The Excel function takes the inputs NORM.DIST(x, mean, standard deviation) where x is the value that you want to calculate the cumulative normal distribution for. I intend to use 0 for the mean and 1 for the standard deviation (i.e. the standard normal distribution). I've looked through the StatisticsCalculator as well as the Math Functions in the ExpressionEvaluator but I don't see anything like it in those transformers. This is related to this post where they are attempting to do the inverse: https://community.safe.com/s/question/0D54Q000080hEk3SAE/is-there-a-function-to-calculate-inverse-normal-cumulative-distribution?t=1599138666050 In that post the solution was to use PythonCaller and I am planning to follow that solution but wanted to see if I could use a standard FME transformer to complete this calculation instead.

Hello people, I am new to FME (about 3 months) and this is my first post on this community. So, please be patient, if this question sounds ridiculous to you ;-)The background of my question is as follows: I have a big major workspace and want to split this into a few smaller, less complex, workspaces. In addition, I would like to re-use some of these new small workspaces in another context. Therefore, my idea was to build a few FME-workspaces as modules and use these modules to build bigger major workspaces.I understand that I can use custom-transformers and/or workspace-runner for this, but both do have some disadvantages on its own.Workspace-runner on the one hand, can just run another workspace (as the name says) and it can transfer data from the parent-workspace to the child-workspace via published parameter. However, the workspace-runner cannot give you an output from the child-workspace back to the parent-workspace (if I am right here?). So the workspace-runner is limited in its

I'm having some difficulties with an translation of an Excel file that contains a some sort of layered structure and needs to be transformed to a sort of folder/path attribute structure in Excel. The input is as followed:The first problem I encounter is the use of indentation in Excel, it looks like FME does nog recognize this kind of setting/formatting. This issue makes it a lot harder to transform the layered structure of attribute "Naam" to a path structure with an "folder" and "name" attribute. As shown below: I already have a solution separating the steps and merging them back when the structure is OK. I can do this by splitting the steps using the Sampler with a Group By number with sample rate (N) 1 and sample type first N with no randomization. All steps will be in the NotSampled area and can be merges back later based on the number getting the structure from the Sampled part of the flow.  So is there a way to use the indention or anther wa

I'm converting a batch of shp from one MCD to another. I can easily map 80% of the fields without any problem. But for the output MCD I need to generate a new primary key based on a concatenation of a string and a three digit increment. I've tried modifying the value (in the feature type dialog box) using the text editor, and 'string_'@Count() - this sort of works it produces 'string_1' etc but i need 'string_001' etc. Also, I already use Count() in another field which seems to confuse FME - This is probably very easy, but I'm new FME...

Hi,  I have a single file geodatabase, within this I have a number of polygons that are broken down into various classes. For example, grass, buildings and forest etc. I want to be able to check if a grass parcel touches another grass. Would this be possible to check? ThanksB

I have about 20 tables which I would like to do some data profiling on. I would like to generate a summary showing the percentage of null or empty values in each column.For example if the input table looks like this:  I would want an output like this:I have played around with a few transformers like AttributeValidator, StatisticsCalculator and ListBuilder, but is PythonCaller really needed here?I am using FME 2020Thanks!

I have an FME script which takes specific headers of a source spreadsheet and copies the them and the field values to two new fields (Substrate Size Distribution & Substrate Size Distribution Value). There are transformers which replace alphanumeric characters from the original header string, sorts the numbers that are left, and concatenates the alphanumeric characters back to the sorted values. This works great. But, the script is coping a header from a field called "Visit_Year" to Substrate Size Distribution field and its value, "1989", to Substrate Size Distribution Value, where values are null in the specific headers I am trying to reformat. This is not what I want. See attachment. I want Substrate Size Distribution and Substrate Size Distribution Value fields to contain only the headers and their values, not the header text Visit_Year. Thoughts as to what is going on?

Hello, as the title already implies, I'm trying to merge XML formatted text ("insert") into a similarly ISO19115-1 formatted root template ("template"- see attachments) in a XML Templater feature. The insert (see attachment) is put together in a String concatenator feature from a set of values extracted from a database in a previous stage of the workflow and stored in an attribute named "SCIENTIST_INFORMATION". AFAIK I have two options to achieve what I want:  *Option 1 - plain 'fme:get-attribute()' *:If I use a simple {fme:get-attribute("SCIENTIST_INFORMATION")} the templater replaces XML special chars with their respective protected counterpart (e.g. < with <), rendering the text insert into something I do not intend. Note that I cannot reverse these transformation with a string replacer after the templater, as this also replaces non-XML specific special characters making the resulting XML files invalid.  *Option 2 - &#

Dear community,I am running a conversion from dwg to ifc. the necessary information is placed on a layer which is named differently in each file. I can't find a way to process this automatically, since everytime the workspace-runner brings in a new dwg-file, the attributes are stored on a differenty named layer. Is there a possibilty to read in dwg-files with a filter looking for specification within a layername?Thanks a lot for any hint on this matter.

Hi, I have upgraded my sqlexcutor transformer - now the result ashow as single, row , delimited and shows missing.is this the way it should work - or a bug?before (version 8)after upgrade (version 9)  

I have a set of 2d points that I need to generate a smooth curve between all points. My goal is to either take a polyline or a set of points and generate a spline between all of the points for a best fit and write this out to a DWG.  I'm trying to figure out which transformers would be best to build this. I just need to make sure that the spline passes through each point for a best fit. 

I have a string attribute:eg.(sign,45,"red, white",null, "stop") I want to be able to split this attribute while respecting the use of "" to surround the text.  If I use a regular Attributesplitter the result is:sign45"redwhite"null"stop" what I'm aiming for is:sign45"red, white"null"stop" Anyone got any ideas?  Cheers,David