Data

I have a Workspace running in FME Desktop 2017.1.1.1 on a server. The Workspace has a SQL Server Spatial Reader in it. The SQL Server database is on a different server which is in the same domain. The Reader is using a named SQL Server connection which is publicly visible. The connection uses SQL Server credentials to connect to the database (not Windows authentication). The connection is not encrypted.The Workspace runs fine when I'm logged in. It works as a scheduled task when running as me. But when I try to run it as a scheduled task using a different user (we have a Domain service account for running scheduled tasks), it fails. I've tried the registry fix suggested here:https://knowledge.safe.com/articles/32356/scheduling-software-doesnt-recognize-fme-connectio.htmlHowever I still get "Invalid authorization specification" in the log file. Interestingly, since applying the above fix, I also get errors about encryption (see below). I don't know if this

Hi,  I want to overlay labels from a FGDB point file on a raster. I'm using the Labeller transformer but my points never pass through. I've uploaded a workbench. Thanks for any help.B

Hello,Main Query: I need to connect to an InterBase DB and it's not listed in the "Reader Gallery".I have installed the ODBC driver(s) for it. Can someone please advise how to go about creating this database connection possibly using the FDS file import? What about making use of an ODBC connection? I can already connect to this database using the IBProvider driver on a different server using a different application. In this particular case though, I must use FME to connect to this table to build a test Corporate Notification Service.Secondary Queries:I also noticed that Ingress was not listed as a "Reader Format" by default. Do you have any plan for implementing this? Has anyone managed to use FirmStep APIs in FME? Thanks,Sameer

In some of my workbenches in FME Desktop I can have over 400k of rows to update to a ArcGIS hosted portal feature service. However the writer will fail somewhere between 400k to 450k, roughly after an hour of updating. I think this is the token from portal expiring, but can't find a way to change the expire duration in FME Desktop when it gets a token from portal. Is there a way around this?

I need to figure out a way of testing if a writer which is an SDE layer is verisioned or not. If it is versioned I do not want to truncate and fill if from the reader but if it is not versioned then I would want to truncate and fill.

I'm sure I'm overlooking something embarrassingly simple but after adding 2019.0 to my computer (currently also have 2018.1 installed to a different path) I cannot complete addition of a .csv reader. I'm able to preview the input files and they show the correct column names and content, but the 'ok' button is greyed out. . preventing me from ultimately adding the reader. Automatic and Manual attribute definition give the same result. I don't have this issue with the Excel reader. Thanks in advance - pulling my hair out!

I would like to color the cells of my first column ID_WS based on the text value contained in a cell UPDATE_STATUS which basically contains the fme_db_operation value.I tried to apply the styling with ExcellFormater but it doesn't seem to be working in the output. What am I doing wrong here ? Thank you !

HiI need to extract info from XMLI used the HTPP caller but now I need to extract the string related to tag <tbody> (see picture) and I don't know how can procede thx Francesco

Hey, I am dealing with a data migration from File Geodatabase to Microstation DGN right now. I am wondering whether it is possible to set the value for the attribute igds_model_name in the DGN Feature Writer. The only accesible attribute is igds_xref_model_name. But I need igds_model_name, because right now all written features get the value Default, which is wrong. The values I want to write are RB, GEM and DIG. They are currently saved in an attribute in a File GGeodatabase.

I have a workspace to convert shapes files to Postgis 1.5 working fineIn the same workspace, I change the conection parameters to conect the same table in Postgis 2.1 but I get an error because of Srid restriction.Reading the log, I see is trying to write SRID=1 (the postgis restriction is to Srid=25830, in both versions of Postgis, so it returns an error)The conection parameters are the same in both conectionsIf I inspect the entity that its trying to write, the properties gives EPSG:25830 Coordinate System,but in the log writes SRID=1Why is trying to load Srid=1 when I change conection to Postgis 2.1? Thanks  

I have two KMZ files containing states and cities borders. I want to combine them and find out which city falls under which state as a result in some tabular format. How I can achieve this with FME? Are there any transformers available for this?

I do not see a reader yet that can read a GeoJSON file in S3. Rather than needing to download it via the S3 transformer.We would like to use S3 as a spatial data hub so it can be used by many tools.

I'm using FeatureReader with following parameters:Dataset: $(Source_WFS:)Feature Types To Read – From Attribute: _FETURE_TYPES$(Source_WFS:) is composed of some fixed URL address (below is an example one, not the real one I'm using) plus dynamically generated token by Python script in private parameter called Token which is:import fmeobjectsimport urllibimport urllib2import jsonusername = FME_MacroValues['Username']password = FME_MacroValues['Password']client = FME_MacroValues['Client']expiration = FME_MacroValues['Expiration']format = FME_MacroValues['Format']url = 'https://www.example.com/tokengen/'values = {'username': username, 'password': password, 'client': client, 'expiration': expiration, 'f': format}data = urllib.urlencode(values)request = urllib2.Request(url, data)response = urllib2.urlopen(request).read()jsonToken = json.loads(response)return jsonToken['token']This worklfow works perfecty in FME 2014, but in FME 2018 I get the error, when trying to load features to Output po

Hi. I want to export some fields from shape file to excel. Any help in this regard would be highly appreciated.

Hi all,I've 3D model of building sample as you can see at the .jpg file.I worked in the .dgn file.But when i import .dgn file to FME data inspector i've more geometry about drawing.I think that FME is handing logs .dgn file geometry history cause i copied exactly same coordinate into building room drawing geometry. So, how can i resolve this problem? Can i resolve in FME Desktop with transformers? (MS Drawing)(Same .dgn file looks in FME)

Hello, What we do is get KMZs and run the ArcGIS tool to convert them to to layers in a file GDB. When you use the layer in ArcMap there is a field PopupInfo, which has HTML data we need to extract?? I have tried several recommendation with HTML, but nothing gets me to where I can flatten the data out into a usable table. Please let me know any suggestions?

Hi there... Sorry about my English. I'm trying to translate survey drawings made in Autodesk Civil 3D 2017 and 2019 to GDB using CoGoPoints and Survey Figures. For CoGoPoints no problems at all, but Survey Figures are not supported at my FME ESRI Desktop 2017.0.0.1.If the Survey Figure is supported by FME Desktop 2018 or newest, I will ask to my company for a software update, if not I need change my strategy. Thanks in advance! Demetrius

Hello - part 2 of an XML thread.  I have a bunch of nodes in an XML document that look like this;<nodes>            <node>              <properties>                <property type="field_name">first_name</property>                <property type="field_data">Ben</property>              </properties>            </node>            <node>              <properties>                <property type="field_name">last_name</property>                <property type="field_data">Potts</property>              </properties>            </node></nodes>And I want to get those out as variables to use down the line in an FME workbench. At the moment I am relying on the order of them in a Test Filter (i.e. If @Value(_attr_name) = nodes.node{0}.properties.property{1} = first_name then put it on an output port of 'first_name') - however I hate relying on the order and I'm sure there is a better way of ge

Hi All,I'm getting a fatal error that I can't figure out the source of.2019-04-12 11:44:31| 1.2| 0.1|FATAL |Precondition failed at stfchainsegmentmodifier.cpp:1093. Expression: prevRealNode_->arcInfo_ != nullptrI think it occurs as the result of either a Geometry Extractor or Snapper transformer I don't understand what it means. Any ideas?Thank you!Katrina

Hello,  I am dealing with large LAS file that is output of AgiSoft Photoscan. I need to generate break lines and isohypses.  In this question I have seen the potential solution but I think this can't solve both of my needs. I hope I can get some hint.  Thank you all in advance,With respect, Dejan

How to set the colour of the linetype of text to be 'by layer' in a DWG? I learned from https://knowledge.safe.com/questions/30155/how-to-set-bylayer-color-in-a-gis-to-cad-transform.html that autocad_color = 256 will set the colour by layer, not by entity (which doesn't make sense, but apparently is the answer, and it does work for me). However, this only works for lines and arcs - for text, the text is still coloured 'by entity'. I am transforming a DWG to a different configuration of DWG (seeing layer names, colour, splitting by an input layer, etc) so no major changes. I just can't figure out how to manipulate this particular item

If using the DGNV8 reader and choosing to Drop Complex Chains/Shapes is there any common attribute between features that originated from the same complex shape?

Greetings for the day, I am working with IfcOpenShell and Python on the extraction of IFC entities. I have developed a Python code which I want to use to extract the structural model from the architectural model. But there is an issue which I am not able to understand and resolve because I am a beginner. When I try to extract the entities which do not contain any entity written in bracket the code runs accurately. for example:- #1=IFCPERSON($,$,'',$,$,$,$,$); #2=IFCORGANIZATION($,'',$,$,$);But the issue occurred when I want to extract the entities with previous entities written in Brackets for example:- #3=IFCPERSONANDORGANIZATION(#1,#2,$);The issue was that when I try to extract the entity for example "IFCPERSONANDORGANIZATION", the code will extract the "IFCPERSON" and "IFCORGANIZATION" twice if I have already extracted these two entities as done in the code given below.Please help me with this issue. 

Hi, I hope someone here can help me out.I have ArcGIS Pro Advanced license plus Data Interoperability license.When I was using Pro 2.2, there was no problem. But since I upgraded Pro to 2.3 and Data Interoperability as well, I keep getting FME Desktop License Assistant when I launch Data Interoperability.Has anyone experienced same issue?I really need this tool for my UNME work.Thanks for your attention. Regards,Min

Authentication fails when attempting to connect to ESRI ArcGIS Online feature service writer. After entering organizational credentials for AGOL, the error states "Failed to Obtain Refresh Token: Error retrieving access token". The translation log reads "java.lang.NoSuchFieldError:INSTANCE". I experienced this problem with FME desktop ESRI Edition v2017.0 and after upgrading to 2017.1 the issue still persists.