Best Answers

Hello,I am using FME to convert data in .gdb format to .dwg format.In the data I have I have a data layer with rows.In this layer each line contains the coordinates of an x, y point that I want to create but I can't. Can you help me ? 

For the following sample text strings extracted from AutoCad dwg file.I tried to build a RegEx pattern to replace the extra spaces in each word to make it consistent and readable.but it's like a mix of good and incorrectly spaced words.Mostly, the pattern looks like : letter <space>letter<space>letter R i v i e r e --->badSt. Martin --->okTatamaka River ---> badSIR MARTIN S. S. S --->ok( J O H N K E N N E D Y L A N E ) --->bad(A N D R E M A R T I N A V E N U E) --->bad(CLAIRFONDS BRCH. RD No.3) --->ok(EX M A R E G R A V I E R III S T R E E T ) --->bad(SOLFERINO ROAD B77) --->okA.L.M. GELLE STREET --->ok

Is there any way I can use the http caller without an input (Can I start a process with that transformer)? My use case is that I'm trying to create Cityworks Inspections from File geodatabase records and update those inspections with records from the same File geodatabase. In order to do this I need to fetch all the Questions and Answers from the Inspection template to get a list of all the question ID's and Answer ID's. From there I need to somehow map the FGDB records to those Answer values based on the ID's. This would be simpler if I could just call the Cityworks API through the http caller to fetch all of the information as JSON without needing to feed in my GDB s an input. Essentially I want a list of all possible questions and answers for an inspection template to be used later on without having to first feed something into the http caller. Hope this makes sense. Thanks!😀

I am using system caller in child workbench which trigger 3rd party service using command line and start the process e.g. abc.exe in windows. Sometimes process get stuck at their server and I am not able to get the status of the same, hence child workbench continue until any response gets from System caller. Is there any solution to kill the 3rd party process using windows process name or ID if its taking more than a particular time e.g. 1 hr?Note: I am using FME Desktop with concurrent process of 3 jobs, so it should kill only the process which are not getting finished within 1 hr.Can anyone help me on this?

I am extracting Shapefile. Coordinates are reversed. LONGITUDE, LATITUDE. I need to invert to latitude, longitude.location original is in Brazil but show in Atlantic Ocean. reading -54,-31 but correct is -31,-54 degreess. How do I fix the problem?

Thanks much!

I'm writing CityGML buildings with xlink's to the surfaces. A few surfaces are donuts. For these surfaces, the xlink is created in the list with surfacemembers, but the id is missing in the geometry of the surface. Does anybody know what the problem is?

I have the first two pieces worked out thanks to some support from our community. Thanks again to @jdh for the support yesterday with JSON parsing. My workbench features two API calls. GET JOBS LISTGET JOBS DATAThey both work, but GET JOBS DATA is currently hard coded for one job.  I'm trying to loop through features within an attribute (JOB_ID) so that the GET JOB DATA API call can be looped against the JOBIDs from the JOBS LIST. How can I use looping to iterate a list of features into that API call? Thanks in advance for any guidance you can provide! 

Hi all,I have a question about translating Vietnamese language to English in Excel file.Could you show me how to translate it?Thank you

Have two automations happening where one downloads files off an Azure Blob storage. The other is actively listening to the folder where the first automation downloads files too to trigger a workspace. My problem is that for some reason AzureBlobStorageConnector sometimes downloads files as 0kb. Is that cause it's trying to download files that haven't fully uploaded to that Azure Blob Storage? I.e the same thing that happens when you download something off the internet and it goes to the download folder as a temp file - until it downloads fully. CheersDan

So I have been using AttributeManager to redo the attributes of my new geometry that I have created. One attribute I want to add is just a unique ID number that goes from 1 to infinite to just label each geometry in my dataset

Hi,I have 3 writers (feature types), all PostgreSQL connected to the same schema but different tables. The second writer should be the first to be written, then the third and so on. This is because of the dependency of the primary key of one writer as the foreign key in the second writer. Can we fix this writing process?I tried the feature holder, connection runtime order, but no luck yet. Also tried the file writer, however, the required attributes are not written. Any quick solutions that I am missing out on? Thanks!

My Feature Type has several attributes (eg. a, b, c, and s). One of them (e.g. s) is special , it contains the name (string) of one of the other attributes.Now I would like to test my features. I would like to use the string value content from this special attribute s (which for example is 'b') in order to define the left value attribute for my test, for example: @Value(b).Any hints for that are very welcome! Many thanks!

the basic gist I've gotten from the forums and examples is:httpCaller>jsonFragmenter>jsonExtractor and I can make that work in a couple of simpler examples. My ignorance is showing when I get to a larger _response_body. I've attached an example json file that is the response for this specific API call, and I would just post my whole workbench but it includes an API key that I don't want to expose.Thanks in advance for any guidance you can provide. I'm basically trying to flatten the entire response into a table.

I published a FME Workspace with a FMEServerJobSubmitter in FME Server, I can run the FME Workspace and the FMEServerJobSubmitter starts the subsecuent FME Workspace, however if someone else in my team wants to run the same workspace, it fails with error "FMEServerJobSubmitter (ServerFactory): Failed to access FME Server web connection 'lopeztor FME Server'", I shared the repository where the FME Workspaces are and the web connection used.

I everyone, I need to vertically shift data between two canadian orthometric heights (HT2.0 to CGVD2013). I have this conversion grid in .byn format (I get it from NaturalRessources Canada website) and create de .gdc file to use it in the CsmapReprojector transformer. However the CsmapReprojector transformer offers only orthmetric to ellipsoid or ellipsoid to orthometric handling, but the shift should be between to orthometric heights. So when I try both I get my data shifted up or down regarding to the vertical handling choice. But I have no idea wich one is the right shift ! Is there's a way to just apply (or transform) a .byn file for vertical shift ?  Thanks ! 

Hi! I've built all of our municipality (including terrain, type of terrain, roads, water, bridges, tunnels, buildings, trees and railway) in FME. The kids keep complaining about the slow railway :) So now I've added powered rail on redstone to get faster trains. But the powered rail does not seem to be activated. If manually removing the powered rail and add again manually, the new powered rail get activated and the train goes fast. Is there a way to programmatically activate the powered rail in FME? I've tried using a block state parameter (which is supported in Minecraft) in addition to blockID and blockData. I called the parameter blockState, and set it to true, but FME does not seem to support that parameter. Can you add that support, or is there another way to programmatically activate the powered rail?Best regards, Ken Karlsson

When using the JSONTemplater I want to be able to add a real boolean to the template and not get a string.I made a work around by replacing the text boolean by a real boolean: Has anyone figured out how to handle a boolean without the need of replacing?

Hi all,I want to replace in this:12/3 >> 12 A 313/2/5 >> 13 B 2 A 5Could you show me how to make regex? Thank you

For my workbench I have one input dataset from an oracle spatial reader. The dataset has over 2 million features. At the moment workbench takes over 12 hours to run as the features get stuck at a featurejoiner transformer near the end of the workbench.

I have an SQL reader the loads json and a geometry from a postgis tableSELECT $SQL$@Value(schema)$SQL$ AS schema,       attributes,       wkb_geometryFROM @Value(schema).features_addressesI have to do this as the database connection is dynamic as is the schema and cannot be fixed in a Reader.  My question is how do I extract the geometry as an FME geometry so it can be passed to a FeatureWriter? I tried using a GeometryReplacer and WKB format but FME rejects the WKB even though it is valid? 

I was wondering if the FME Server adopts the settings of your workbench or workspace when it comes to logging (Tools -> FME Options -> Translation -> Log message filter) or does FME Server have an own setting for this? I know there is a workspace parameter -> Logging with a few settings (max Features to log, max logged features to record and log file) that is workspace specific. I'm asking this because i'm making a final package for release and one of the steps in the release guide for this customer is "In FME desktop, set the logging of the FME workspaces to only 'WARNING' and 'BUGS'." what i think would be a unnecessary step to perform, cause i dont think this would have any effect on the server. Or i'm i mistaken?  

I am trying to install the custom transformer GeographicAreaCalculator which was downloaded to C:\\Users\\GUANA\\AppData\\Roaming\\Safe Software\\FME\\FME Store\\Transformers\\GeographicAreaCalculator/fmx on my FME desktop. I follow this article https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Coordinate_Systems/Workbench/Sharing_Custom_Resources.htm to publish my workspace while adding this fmx file. The publishing succeeded, but when running the workspace on the server, it stills say this custom transformer does not exist on the FME server.

In ArcGIS, we have been using the geodesic area calculations to calculate polygon areas in square kilometers from a geographic coordinate system such as WGS84. See http://dmahr.com/2015/07/geodesic-areas-arcmap-field-calculator/. I don't seem to find a similar reprojection in FME. is there an one that is closet?