Best Answers

Hi FME Experts,I am trying to read/write from/to fgdb/ArcSDE from fme server 2019.2 64 bit and ArcGIS pro are installed (Standard License) but unfortunately it does not work, when I checked the log file, it is mentioned that the ArcGIS license does not advanced.Please advise

I am using SQL executor to perform insert command to insert table data into Oracle. I have a column with geometry and data type as SDO_Geometry in already existing oracle table. The current geometry I want to insert into oracle is in UTM format. I have converted it using geometry replacer and reprojector in my workspace.SQL Executor is throwing an error with too long string literals and can not be inserted.What is the way that I can insert geometry column with UTM coordinates into Oracle SDO_Geometry column?

Here I am trying to get the sequence before writing data into oracle. All I need to do is to start this sequence with the value of 5000000000.As we can use this in insert function - "insert into nb (XFM_ID) values(XFM_ID_SEQ.NEXTVAL + 5000000000)"But this is not working in FME. I tried all possible ways to insert sequence starting from 5000000000 like using sql creator,executor etc. Sequenced Table columns does not accept " XFM_ID:XFM_ID_SEQ.NEXTVAL+5000000000"

Hello,I need to create and implement control rules which can show that my object (in GML) has dupplicate vertices.I have reader "GML file" with the element which geometry is:<bdz:geometria> <gml:Polygon gml:id="geom.9acd0ccc-6a2a-4dfa-8e70-487b08d83e7b" srsName="urn:ogc:def:crs:EPSG::2176"> <gml:exterior> <gml:LinearRing> <gml:posList>5947602.08 5474440.64 5947598.85 5474445.14 5947598.85 5474445.14 5947602.08 5474440.64 5947603.36 5474448.24 5947606.44 5474443.96 5947602.08 5474440.64</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </bdz:geometria> It contains 7 vertices (1 dupplicate vertex), but when I add inspector, FME show me that there is 6 vertices: Neither the geometry validator nor the coordinat

Hello, I'm using attributevalidator to make multiple check on attributes. There is one check I don't know how to implement. I would like to hightlight the attributes finishing with newline. I used this regex : [^(\\n)]$ . It is working when I use external tools (for example (https://regexr.com/ ), but not in FME. I didn't find any other regex to do that (I'm a beginner in regex).In case, there is one other solution : using tester/attributecreator, but if possible, I would like to gather all the tests in the same transformer to make the workflow as simple as possible (the workflow contains a lot of attribute / spatial tests) Thank you  

When copy/pasting SQL code into the SQLCreator SQL statement editor (2018.1) specific characters are replaced by others, e.g. '}' becomes '%7D'. This doesn't happen using the 2017.0 version.How can I make it work in the 2018.1 version?

There are some postings on this topic but it does not work for me yet:I am trying to contact an external API via HTTP POST to get a token back. If I use Postman from the same computer everything is okay:The response from Postman is:{  "access_token": "<access_token>",  "expires_in": 300,  "refresh_expires_in": 1800,  "refresh_token": "<refresh_token>",  "token_type": "bearer",  "not-before-policy": 0,  "session_state": "c25bf161-2dee-426c-9bdc-970836fe4f4f",  "scope": "email profile" } Comment: Hostname, company, username, password, access_token and refresh_token are replaced by dummy text in this posting...This response ist correct! But when I try to do the same in FME 2019 I got errors:Multipart Upload 'password' is missing in this screenshot. Other values are replaced by dummy text... There are no parameters set

We are running FME Workbench 2019.1 and FME Server 2019.1.2 on Windows Server 2016 Standard. On the same server, we have ArcGIS Desktop 10.6.1 and ArcGIS Server 10.6.1. The Desktop license is running off a concurrent License Manager on another server. We have the ArcGIS Desktop license set to Advanced on ArcGIS Administrator.This setup has worked fine until about 4 days ago. Now many of our FME services are failing. The workbenches run fine. An excerpt from the log on one FME service is shown below. I have already exhausted my search for solutions. I am considering trying to install ArcGIS Pro on the server, though I would prefer not to. Any suggestions would be appreciated. Thanks!145The Esri Product license used by this machine does not include licenses for the 'ArcServer' licensing level146The ArcObjects license 'Advanced' is being selected from the Windows registry147The Esri Product license used by this machine does not include licenses for the 'Advanced' l

Hey Everyone,I have had some challenges creating apps in FME Server that have published user parameters that are as robust as Workbench. I wasn't sure if it was just a limitation of FME Server as of 2019 or if I am doing something wrong.For example, if my workbench parameter needs a user to select a Coordinate System Name, it is very easy to find the CS you need:On the other hand, on an FME Server App the search functionality is unable to find my CS and it it giving way less results to scroll through. If I knew the EPSG code I'm guessing it would be fine but I'm thinking in my users' shoes who need to type in more broad terms like "texas". In the App, searching texas doesn't bring up any NAD27 CS choices at all. It is a similar situation with folder/file locations. I was hoping this folder selection view would be similar in the app as well. Does anyone have any thoughts? Is this more of an idea for improvements?

Hi, I have a DGN file that have links attached to elements.However, I cannot see the links exposed/supported in FME.Please see a screen grab showing the link attached to element in Bentley Microstation.I cannot get to this object in FME.Please can you help?Many thanks, Magda

I am attempting to convert from Oracle to a shapefile and getting the following error consistently. look like it is failing on the .dbf file. Any suggestions?

i want to convert from date format 01.12.2000 to 2000 in one attribute  some times it is working great with my input excel files and some files show me this msg . The below feature caused the translation to be terminatedDateTimeConverter_2_<Rejected>(TeeFactory): DateTimeConverter_2_<Rejected> what is important for me to read the last 4 digit  Could someone provide me solution for this issue .Thanks for help

Hello!I have point next to each other with a slope value between two neighbor points. Now I want to average these values with a loop, like:for n in range(num):    numbers = float(input('Enter number : '))    total_sum += numbersavg = total_sum/numCan you help me to put it in practice with FME

Hello,I would like to round numbers to the nearest 0.05. Like this:-2.33 > -2.35-2.32 > -2.30Is this possible within the AttributeRounder? Or how can I get this result? Thanks in advance,Eva

Hi folkswhen i try a translation from DWG to a GIS format, i encounter that message : FATAL |Incompatible visitor version 1 in FMEOrientedArc::acceptGeometryVisitorConst. This release of FME is compatible with versions 6 to 6 I tried many ways to solve it, GeometryValidator, Orientor, but the message still remainsthe DXF file is hudge, so i can't attach to the message ...regards

Hello Team,Can we place workspaces directly into the repository directory instead of publishing to server? I tried doing this but workbenches were not reflecting in the server. Can somebody clarify whether the process i followed was correct? If yes then why newly placed workbeches are not reflecting in the server? Thanks in advance...

Hello everyone,I am attempting to copy a select number of files from a given directory and came across the FileCopy writer. After experimenting with it, it appears that it is copying all the files specified in the source directory whereas I would like to specify which ones it copies instead. Can anyone confirm this limitation in the writer? And of course, I would be very happy to hear any ideas and workarounds for this. I am considering using PythonCaller to accomplish this but I would like to avoid this if at all possible.

i have read lots of article about Feature Writer , but i could not get the point ,how can i get my attributes and connect it to excel writer without effect on my output ,it does not matter to show this attributes in excel file output but i want to keep it in excel writer to use it lateri have at the beginning excel file then i converted it to csv then i apply the output on excel file but i missed some attributes that i need to usemost of attribute are missing ,onle my result what i can get ,could i ask,how can i find the rest of Attributes  exactly my target ,i want to name excel writer as the field name included attribute but i could not find most of attributes after Featurewriter.FME version 2018.1

I am trying to find a method for reader to link between many sources to one source but i could not find . i have many readers come from the same source when i run my workbench with quick translator ,as result it gives me around 10 sources to select but 8 of them from one source , bcs i have chosen from the beginning individual Feature typesis there a method to refer only to one source files instead of 8 sources . because all of them from the same file  

Hi, I'm trying to practice with spatial thinking, and I have a set of lines that I want to merge to a single point in the middle (see attached). The way I want to these lines merge into the point, is to use the nearest point of the line to the point in the middle of all the lines, and making the lines longer than they were previously, not just snapping them and moving them.

Hi FME gurus,For an engineer I would like to parse OSM XML data with line and polygon features. Although point features are no problem to parse, the geometry from the line and polygon features is not coming correctly along by the OSM XML reader.I can parse the OSM XML by a combination of FME transformers:However this transformation is rather slow due to the number of vertices that have to be parsed.Attached therefore an example of an OSM XML with highways. Is someone able to use the OSM XML reader with some settings, whereby the geometries of the line and polygon features are correctly parsed?

Hello!I would like to calculate the difference of z value between two neighboor points in the following way:- test if the extreme_ is LOKMIN- if it is LOKMIN , then take the two neighbor value (the points are sorted), take the higher (so the bigger number) and exract them each other.Here is my attempt:import fmeimport fmeobjectsfrom functools import reducefrom math import sin, pidef left_slope(feature_a, feature_b, feature_c):    a_x = float(feature_a.getAttribute('z_uj'))    a_sz = feature_a.getAttribute('_szelsoertek')    b_x = float(feature_b.getAttribute('z_uj'))    b_sz= feature_b.getAttribute('_szelsoertek')    c_x = float(feature_c.getAttribute('z_uj'))    if b_sz == "LOKMIN":        k = c_x - a_x        #_nyomvalyu = b_x - a_x        feature_b.setAttribute('_nyomvalyu', k)    return feature_a    return feature_cclass FeatureProcessor(object):    def __init__(self):        self.features = []    def input(self,feature):        self.features.append(feature)    def close(self):    

Hello,I want to calculate slope between neighbor points. I want to use python caller to do something like take the first point (pointID is smallest) go to the next one , calculate the slope between the points and write it in a new attribute (_slope). Then go to the next point (so 2nd and 3rd) calculate slope and save the value.I am new with python in fme, so could you help me?

We have a problem with the cases of our attributes. Normally the attributes were all uppercase, but we have some customer which send us data where they are not. They sometimes mix the cases in all sort of ways. We have a ArcGIS SDE Reader and a Hexagon SQL Warehouse Writer. Here an example: Table: WASS_SUBART_HYDRAttributes: OBJECTID, CODE, DESCRIPTION_G, GlobalIdThis is our configuration, but our customer send us data, where the CODE Attributes is lowercase. Then our FME Workbench does not work, because the code Attribute is "ignored" and the writer will write a NULL Value to the Database. If we see it correctly, the problem is, that the reader has the wrong information about the attribute.Is there a way to ignore the upper- and lowercase of a reader? (If not, this would be a nice feature, because ArcGIS and MS SQL can handle this no matter how it is written)Or is there a way to change the reader dynamically?This is only a small example to keep it simple. We have to deal wit

Hello Friends,I need an urgent help. Can anyone please help?I am having something like this:and i want to fill down the values something like this in excel:its like a fill down option for sample id and ID till the time it finds a new sample line in text_line data or till the time it finds a blank value in its own column and stop when next row has a value.Also attaching the excel file for your reference.Thanks