Best Answers

I need to read a GeoJson from an URL. One of the attributes of the call is the current time that I could get using the "Date/Time Functions" on Text Editor, however those functions are note available in the reader. I tried to use a FeatureReader where I can set the current time properly but then I don't have the "Network Authentication" options under parameters.  Any clue on how to set the reader source GeoJSON URL dynamicaly?

I am trying to adjust the text orientation by changing the fme_rotation attribute in the TextAdder transformer. However, the text orientation attributes does not take the changes. Do you know how I can access or somehow manipulate the values in the red box from the image below? In this example i have change the rotation to 116, but the text still have a rotation of 118.

Hi EveryoneI have .txt as attached, the first line is the schema and separated with "tab" space. I can open this is in excel like .csv however I want to read this in FME and create attribute for each schema at first row. I tried attributesplitter with "tab" as delimiter but it seem not as what I want. Can anyone show me how to do it?the input file Expected attribute to be in FME to processThanks.

Hi,  I'm looking for a way to read all the tables which are in one schema without having to select them manually.  I have to export all the table which are stored in one particular schema in spatialite. New tables can be added end old one deleted. That's why I need something automatic...   Does anyone have a clue ?   Thank's   

Hi Everyone,I attempt to create a new work space in FME Desktop 2018 and add a reader to read .shp file. However, I wasn't able to create the reader and saw the following error:"Failed to obtain any schemas from reader 'ESRISHAPE' 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 information"Can some one please point me to where I can resolve this issue? Which components are the culprit in this case? I've ArcGIS and ArcGIS Background Geoprocessing installed as well.Thank you for looking into this

Hi all,I have a table with (XYZ) coordinates measured in time. Each time the Z-value (field J and further) of the specific point changes. The XY-coordinates (field E and F) stay the same. Sometimes the Z-value is missing.How can I project all of these point without manual adjustments to the table? So for the second row we have:1st measurement: X=94439,5, Y=435795,0 and Z=-0,803702th measurement: X=94439,5, Y=435795,0 and Z=-0,805003th measurement: X=94439,5, Y=435795,0 and Z=-0,806004th measurement: X=94439,5, Y=435795,0 and Z= missing here so no projectionand so further onIn the end I want to have a geodatabase.Many thanks for you reply!Alan

Hi GuysI am trying to count the occurrence of a value across a large number of attributes. All the attributes have a different name, however they all have "_SIG" in their name (a value that rates significance). Ie ENVIA_SIG, WATRF_SIG etc. There are heaps of them and I want a way to just test those attributes using a wildcard of sorts. Basically I would like to use a tester to test for the existence of the number 5 in all attributes that end with _SIG. However in the tester (or Test Filter) I have to manually add each of those attributes which is not realistic as there are over 50 of those attributes. Any suggestions would be greatly appreciated!Thank youDominique  

I use a PointCloudFilter where I try to find the lowest parts in a PointCloud.In this way I get two long straight stretches of PointCloud remainders, which are clearly seperate and quite far from each other (i.e. >10 times the distance of points in the Pointcloud).My problem now is how to split up those different parts/groups of the same PointCloud so I can use each remainder independently ?PointCloudCoercer -> "Single Multipoint" + HullReplacer doesn't give me different parts.I could not find other ways to tile/split PointClouds in the way I need.Any ideas ?

One of my workspaces recently broke because FME can't read in the features from AGOL. I'm running Win 7 x64 and FME Beta Build 18198. Has anyone else experienced this issue?When trying to inspect the AGOL feature layer, this is the error I receive:ArcGIS Online Feature Service Reader: Requesting portal informationUpdating access token for 'Daniel.Matranga Esri ArcGIS Online'JSON Message: {"error":{"code":498,"error":"invalid_request","error_description":"refresh_token expired","message":"refresh_token expired","details":[]}}JSON Error: JSONObject["error"] not a string.Unable to update access token for 'Daniel.Matranga Esri ArcGIS Online'Updating access token for 'Daniel.Matranga Esri ArcGIS Online'JSON Message: {"error":{"code":498,"error":"invalid_request","error_description":"refresh_token expired","message":"refresh_token expired","details":[]}}JSON Error: JSONObject["error"] not a string.Unable to update access token for 'Daniel.Matranga Esri ArcGIS Online'Python Exception <HTTP

Hoping someone can help me out. I have a geometric network of wells, pipelines and facilities. I have already ran a custom ArcHydro python script to break the pipelines up at every junction point and give the pipelines unique HydroIDs, ToNodes, FromNodes and NextDownIDs (which indicates which pipeline, AKA HydroID, to flow to next). The wells produce water and I can add the monthly production values from the wells to the adjacent pipeline using the Bufferer and SpatialFilter transformers.  I'm now trying to find a way to add the production through the rest of the pipelines. I have NextDownIDs, which I thought I could maybe just group the pipelines by all pipelines that share the same NextDownID field and add the production values in the Water_Production fields together, however this adds the values incorrectly because it doesn't add the pipelines in order from well (source) to facility (sink). Does anyone have an idea of how I can use FME to add the production values up correct

New user here so be patient! I would like to remove from a KML all the geometry (point, lines and areas) that are outside of an arbitrary bounding box (let's say a square defined by the corner coordinates). I tried using a Tester but I can't seem to get the numerical values of the of the placemark. With the following parameter I get always "passed" even if the points coordinates don't respect the condition:Moreover this approach will be problematic for lines and areas. I tried multiple transformers but with no success. So does anyone have a suggestion on what will be the best approach for filtering this data? Thanks!

Hello community,I have a folder with all .mdb files that I want to process independently. Therefore I am using a 'directory and file pathnames' reader together with a workspace runner. So every file is send to another workbench, where it will be processed.In this 'other' workbench I have a 'Microsoft Access' reader, with the 'Single Merged Feature Type' box switched on. When I select the table name myself it works all perfectly. However, here comes the trick. The table names that I am using are different for each incoming file. For example the table name for file 1 could be trees_abc, for file 2 monumental_trees_abc and for file 3 tree_export_abc.The table names have one thing in common. They contain the word tree and always end with _abc. This regular expression should catch all the possibilities: ^(\\w+|)tree\\w+_abc (so it has the word tree somewhere and always ends on _abc). Now I was wondering if I could implement this regular expression somewhere i

Hi,I don't really know how to solve my current issue.ContextI have data as follow :IDCIS1CIS2CIS3TPS1TPS2TPS30001AMACHLLOR780102414200002LIVAMARBN681702895..................  The TPS columns are times in seconds. I need to add a delay to these times regarding the corresponding CISX value (e.g. add 1000 when CIS is 'AMA', add 1500 when CIS is LOR...).Then I need to sort the values to get the quicker CIS regarding to the TPS time with the delay added.IdeasTo do that I think that putting all my CIS and TPS in a list with two attributes can help me, but I can't find how to do it.What I think I need to have as a first result (to start manipulating my data) :ID0001List{0}.CISAMAList{0}.TPS780List{1}.CISCHLList{1}.TPS1024List{2}.CISLORList{2}.TPS1420 I tried with the ListPopulator, it works fine if I give it CIS as prefix I get my list but of the CIS only.I can put two ListPopulator, one with CIS as prefix then one with TPS as prefix, but I get two different lists.How can I cr

Is there a way to check the page size of an AutoCAD DWG that is read into a FME workspace?

Hello FME friends, I have a question about system path variables and how that translates to FME server.I downloaded the Google cloud Storage connector from FME HUB. I'm using a Google service account along with a service account, JSON key file. Part of the configuration is to set the windows environment variable GOOGLE_APPLICATION_CREDENTIALS to a JSON key file I downloaded from Google Cloud Console.The package works flawlessly in FME workbench on my workstation. I would like to now publish a workflow to FME server, but am scratching my head trying to figure out how to deal with the environment variable GOOGLE_APPLICATION_CREDENTIALS and how that translates to FME server. I assume the .JSON key file for this Google service account needs to be on FME server somewhere, but how do I tell FME server that the environment variable points to the .JSON file on an FME server resource folder? Thank you!

I've got some features and one of their attribute is a sequence of number or number with letter such as A001, A002... Now some of numbers are miss from sequence due to editting was performed. Is there a way to find out miss numbers and asign them to newly created feature from North to South, West to East?

Hello, what is the easiest way to convert these dates ? June 28, 2019 to 2019-06-28 May 31, 2019 to 2019-05-31 April 26, 2019 to 2019-04-26 etc.

Hi, I tried to use Directory and File Pathnames and FeatureReader to control workflow, I used Directory and File Pathnames linked to a gdb file, then put a Tester after it, connected passed port to FeatureReader. But it seems that gdb was treated as folder, every file in picture below was passed to FeatureReader, as result all feature were read muti-times instead of one, how can I set parameters right to get what I want? Or else, how can I control workflow if I don't want some gdbs to be read in fmt?

Hi Experts,I am merging many csv files into one and I want to get the name of the input file in an attribute 'filename'. I am using FileNamePartExtractor for this purpose and its working correct with single input. But, when I use this with multiple files, it takes the name of the last input file and shows in all the rows. Can anyone help me with where I am going wrong!!

Hello, I have an Timestamp attribute in UTC time (e.g. 20180311013252.000). I would like to create a new attribute converting the UTC Timestamp to EST/EDT Time. After that both attributes should be transformed to %Y%m%d. In this example the output should be 20180311 for UTC and 20180310 for EDT/EST.

Hello, I am trying to solve the problem with dangling roads in the network. Given the input of the roads, I simply ran it like this:  I assumed that the topologyBuilder would give me _node_angle{}, _node_angle{}.fme_arc_id and everything else, as per the docs,as the edges are perfect, but it seems that there is a challenge somewhere, as only _node_number is shown.  

Hello, I noticed that notifications (emails) from the Community site have stopped since some point within past few days. Can you receive notifications according to the settings on your preference?

Hi, I am using FME Desktop 2015.1.I am running a process which includes a LineOnAreaOverlayer which I suspect is the source of the message, within the log window I get a message' Hit data-shattering case as 6463 new nodes were created after phase 2, compared to 1 nodes created after phase 1.' What does Data-Shattering mean within the context of the calculation factory process? In essence I am interested to know if this is something I need to worry about and attempt to mitigate somehow? If any given feature which has experienced data shattering within a transformer, is the output result from that tramsformer correct? Or has some sort of calculation collapse occurred and the result may be incorrect?I realise that data shattering may occur at a feature level and not necessarily to all feature which enter a transformer. Thanks in advance, Rob 

I would like to create new attributes for all features with a value of null. The tricky part is that the number of these attributes and their names is not known before running the workflow. The names have to be equal to the feature values provided by some part of the workflow. I attach an image of what I am trying to do: I am feeding the AttributeCreator with the main table (the one where I want to have new attributes --or columns -- with null values) and with the UnmergedRequestor of the Feature Merger. The feature values of SimWaterBodies_FN (the output of the UnmergedRequestor) are supposed to be the names of the new attributes (2 in this case) of the table. I have tried by setting @Value(SimWaterBodies_FN) as the New Attribute and null as the Attribute Value of the Attribute Creator, but this doesn't create the 2 columns with same length of the main Table. Here is a simple example of what I am trying to do: Let's say this is the main Table initially:  When I run my workflow

Below I have included the python code I added to the startup script, how do I include the zip file module if possible?import osimport zipifle def convert_to_zip(path):for root, dirs, files in os.walk(path):for filename in files:if filename.endswith('.ghg'):# print rootoldname = os.path.join(root, filename)newname = oldname + ".zip"os.rename(oldname, newname) def convert_to_zip(path, extract_path):for root, dirs, files in os.walk(path):for filename in files:if filename.endswith('.zip'):# print rootzf = ZipFile(path, 'r')zf.extractall(extract_path)zf.close()  convert_to_zip("")