General

Hello, I have a problem with my workspace.The Process does work inside the fme - the batch deployed version does not. The problem seems to have something to do with the FeatureMerger. There was a similar question in 2016 (7https://community.safe.com/s/question/0D54Q000080hgb1SAA/problems-with-batch-deploy) but that does not fit do me. the error message in the console is as follows: An error occurred during the batch file execution, 1 translation failed. The following error message was raised:#1 : The clause 'FACTORY_NAME FeatureMerger_3 FLUSH_WHEN_GROUPS_CHANGE No' within 'FACTORY_DEF {*} ReferenceFactory FACTORY_NAME FeatureMerger_3 FLUSH_WHEN_GROUPS_CHANGE No INPUT REFERENCER FEATURE_TYPE AttributeCreator_4_OUTPUT INPUT REFERENCEE FEATURE_TYPE AttributeCreator_3_OUTPUT REFERENCE_INFO GEOM_AND_ATTR_BUILD_AGGREGATES REFERENCE_TABLE @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>Nummer<closeparen>,FeatureMerger_3) @EvaluateExpression(FDIV,STRIN

Not a question, but a Tip. Sometimes there is a need to convert angles measured in Arithmetic convention (counter-clockwise from the X-Axis) to Geographic convention (clockwise from North/Y-Axis).   For example, Transformers like TopologyBuilder output Edge angles in Arithmetic degree angles whereas Desktop GIS systems like ArcGIS can sometimes default to Geographic degree angles. Instead of using complicated Conditional Value formulae to translate angles quadrant by quadrant with different formulae, searching the internet came up with a genius single formulae that converts angles back and forth, no matter what quadrant the calculated angle is in.Geographic Angle = (450 - Arithmetic Angle) mod 360 Rewriting the formula into FME Maths function format it becomes thisGeographic Angle = @fmod((450 - @Value(Arithmetic Angle)),360)It also works in reverse:Arithmetic Angle = @fmod((450 - @Value(Geographic Angle)),360)

(1) Created a SQL view that inner join multiple tables from two different database servers with where conditions. Which Transformer will be the simplest to mimic the SQL inner join? There are SQL Executor, FeatureJoiner, FeatureMerger etc. Not sure which one to use.(2) Once I import those data into the destination SQL table, how can I also apply logic to also update another log table with each line item details (Trx ID, Name, Amount etc.)(3) The import should also validate against the Trx ID in log table (from 2) to make sure there's no duplication trying to import again. Still new to FME. Really appreciate for your advice.ThanksR

Hi There, I'm having some trouble of figuring out an approach to detect features that have "regressed".My data looks something like this:<Fruit> <Batch>Orange, 1Apple, 1Pear, 1Orange, 2Apple, 2Pear, 2Orange, 3Pear, 3 So look at this as Batch 1 had all three fruit, batch 2 had all three fruit, but in batch 3, Apple is missing.What I am interested in is knowing when a fruit went missing, specifically in a sequential view. Meaning, I don't really care about the relationship between batch 1 and 3, but I want to know that between batch 2 and 3, Apple went missing. So even if I have 10 batches, I only really care if I have "pineapple" in batch 8, but missing in 9. I hope my obscure example makes sense and please let me know in case any additional information is needed. Thanks a lot! 

I would like to generat "genericAttributeSet" tag in CityGML data like as follows:   <gen:genericAttributeSet name="xxxxxxxxxxxxx">     <gen:stringAttribute name="xx">      <gen:value>yyy</gen:value>     </gen:stringAttribute>     <gen:stringAttribute name="aaaaaaa">      <gen:value>12345</gen:value>     </gen:stringAttribute>     <gen:measureAttribute name="zzzzz">      <gen:value uom="m">67.54</gen:value>     </gen:measureAttribute> </gen:genericAttributeSet>Could you tell me how to manage attributs for this?

Hello, I am trying to connect to our Enterprise Geodatabase. This used to work for quite a long time using FME 32 bit (several older FME versions). Using FME 64 bit (on the same machine) produced an error like this:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {Keine No SDEHOME-Umgebungsvariable festgelegt} Please ensure the connection parameters are correct (server=`sde', instance=`....', user=`....', password=`***', database=`', version=`SDE.DEFAULT') Now we have FME 2020.2 64 bit and I don't have the 32 bit version anymore.I created a database connection file (*.sde) using ArcCatalog on my machine. There, I can see the database and connect to it. I can also open the connection in ArcCatalog directly using my sde file. But I can't use the same connection file to connect a reader (Format: Esri Geodatabase (ArcSDE Geodb Raster Dataset)) in FME. Three colleagues

Hi I have a shape file with points and a shape file with polygons.I want per point a csv file with all the polygons containing that point.  It looks like this: 1,photo31,photo41,photo71,photo9.... My workbench works, until a point that lays in 2 polygons. The polygon will only be added in the first csv file and not in both. I tried group by name and group by fotonamen, but that doesn't work.

When I re-organize the transformers in a 2019 workspace, the selected transformers are being deselected when panning. Select by fence with the left mouse button. Zoom using CTRL and scroll wheel. Pan clicking the middle mouse / scroll button.I'm quite sure it worked this way in previous versions.Is this a setting which can be changed? If not, am I the only one having this issue?

how can I update citygml data with shapefile attributes and convert to 3d tiles for visualization?

I am new to this and learning but...I have a JSON object and am trying to extract the attributes to load to PostGreSQL and I am hitting my head against a wall. The format of the JSON is generally as so: {    model: 1,    version: 2,    content: [        {            x=1,            y=2        },{            x=3,            y=4        }    ]} I want to output something along the lines of:model, version,   x,    y1,            2,                1,   21,            2,                3,   4 For the life of ne I cannot work it out, to me the documentation and step by steps are not clear. I am using a standard JSON reader. Whatever I try, flattener, fragmentation, I cannot opreate on the content.I had an instance where I managed to get all extracted using an extractor but this would populate the attributes for each item in the content array and concat together to look like this:model, version,   x,    y11,            22,          13,  24 The real JSON is a lot more complicated but at this ve

I have CSVs with over 2 million rows. For some reasons, Reader appears to be dropping some columns , and yet I know Reader recognised they existed because they are missing in the column name order. For example, when columns col3 and col6 are dropped the auto-generated attribute names are col0, col0,col1,col2,col4,col5,col7,col8,col9. I have tried various options in reader but clearly not the right one . There is plenty of RAM and disk space. In some files, the missing columns are blank but I have also seen this happen in files that do not have blanks in missing columns. Some columns have strings enclosed in double-quotes. Any pointers please

I have a bunch of point data (pavement rut) along roads, that I want to practice to cluster analysis. The point of the analysis would be to show where the most significant pavement rutes are accumulated along a road section. (ex. road juction with traffic ligths )I am looking for the best FMEtransformer that can perform the analysis. Do you have any idea for it? 

Hi! Is it possible to convert png to eps in FME? If yes, how? I've tried a simple conversion with just a png reader and a eps writer, but get the error "EPS writer: EPS WRITER: Error, the feature does not have a eps type attached".

Good morningI have a problem I currently am unable to resolve, which is a csv file containing address data and additional spatial and non-spatial information related to the individual addresses. The csv file is ordered according to a Record Identifier.However each Record Identifier has a different number of columns populated with data. The minimum number of columns is 19, the maximum 29If i attach a Tester to set the 1st column to a particular Record Identifier eg 23 then attach an Inspector, the result always shows 19 columns, which is the number of columns the first record in the file has (which is Record Identifier 11).If i export to an .xlsx file using a template of the source Record Identifier data i want to write to, only the first 19 columns are populated, the other 10 columns are blank even if that particular Record Identifier uses the additional 10 columns.Can anyone suggest how i can force the tester to recognise the number of columns the Record Identifier has, or an alternat

I have a NetCDF with below values in each band. How do I go about extracting these values to an attribute using a set of points? They don't seem to come up in attribute list only when I click on a pixel in inspector.  

Hi everyone,It's Mark here with all the FME news that I can find for this week. FME Data Express v1.4.0The latest version of the FME Data Express app is now available. Apart from the usual bug fixes (we try not to include any, but they will sneak in) there is also better geometry parameter support, the location picker now remembers zoom levels and map types, and there is new search functionality in the repository list. As always you can find it on both the Apple App Store and the Google Play Store, so give it a try. It's a great way to run workspaces on Server from a mobile device. FME Server Microsoft .NET APII'm told that the Microsoft .NET API for FME Server is going to be deprecated and removed from the product for FME Server 2021. The technical reason is that the .NET API is incompatible with new updates to Server, and the work to bring it up to speed can't be justified. So, if you're using this API, we strongly recommend that you take the steps to transition t

We have a shared web and database connections directory, into which public FME connections go. Our service account that runs overnight tasks (via Windows Server 2016 task scheduler) has explicit permissions to this directory, but cannot see/use connections unless they are embedded in workspaces. Interactive login is disabled for this account, but I'm wondering if I might need to log in as the account and set default paths for FME so it can see the connections? Alternatively, any other ideas for why this may not be working? In the current case the connection is to ArcGIS Online and there is no apparent option to embed the connection in the workspace. The connection was made public as it was created.

I have some questions about working with point clouds.I’ve done a little work with them before in FME. Mostly coordinate reprojections, clipping, thinning, etc. Pretty basic stuff.This time I have a slightly more complicated problem. I have an LAS data set that is not fully classified, there are no vegetation classifications.I would like to use the LiDAR data to do some basic vegetation classification, resulting in shapefiles that I can use to classify areas that are vegetated.As someone pretty inexperienced with FME, I’m not sure what the best sort of workbench is. I would love to see some examples and to experiment a bit with both of these problems.I’ve built a few workflows but they don’t work!

Hi. I am using the Aggregator transformer to summarise some tabular data by a reference (there may be multiple records originally for each reference). I am merging the attributes and concatenating some attributes. This is technically doing exactly what I want but with nearly 1m records, it is very slow. I know there are usually multiple ways to achieve something in FME so I wondered there an alternative to the Aggregator to do what I need? Many thanks Thanks

Inserting a KMl into FME desktop results in a schema-less reader. Which steps do I have to take to convert its attribute (values) to e.g. shapefile or fgdb?

I have a FME 2019 Desktop workflow that reads three CSV files and write all input data (points) to only one FeatureClass in the output fileGeodatabase. Every CSV file has a different schema, i.e.: every CSV file has several fields in common but most of them are different. This is the workflow:Every month I will have to run this workflow with a different set of CSV files with probably will have different schema than this ones, and also could be more than three CSV files. So, how can I read automatically the schema of CSV files ? Thank you ! 

Dear FME community. I'm trying to extract, from a json object, the json arrays.My object looks like :As you can see, I've multiple sub objects and I want to extract this parts :In this case, I tried to use the transformer jsontemplater but I was stopped by the loop in the json for sub sub object.In this part I do this :But maybe it' not the best method, that's why I need help.Do you see how can I do this ?Thank you very much.

I think I read entire forum... but can't find any answer.I have number of single control point, ascii with XY column and corresponding another file containing also XY. I would like to 1stfor each control points from set 1 find a closest point from set 2 and calculate average xy and rmscombine the rms and average magnited and output as a one number Maaaasive thanks for all your timej

I'm trying to export feature layers from ArcGIS Online to Geodatabase, then upload the Geodatabase to Google Drive. I'm using a 'Choice with Alias (multiple)' user parameter to select and export one or more feature layers. If I select one feature layer my FME script works fine. If I select more than one layer then I get a geodatabase lock error while uploading the Geodatabase to Google Drive. This is the error message: PermissionError: [Errno 13] Permission denied: 'C:\\\\MyDirectory\\\\MyGeodatabase.gdb\\\\_gdb.JD2344.18360.9116.sr.lock'Error encountered while calling method `input'GoogleDrive_Geo_CALLER (PythonFactory): PythonFactory failed to process feature  I'm hoping someone can suggest a solution. My FME script is attached.Regards, Damian

Is it possible to add the coordinates from the coordinate extractor transformer to a writer? Like example from coordinate extractor column _indices{}.x (64 bit real) into a shapefile with column x. I tried changing data type from double, float, char... but the line connecting the transformer to writer simply will not connect to each other.