FME Form

Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.   

I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!

Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance

Hi, I have a jp2000 file and a j2w file with the georeferencing, but I would like to have the georeferencing at the jp2000 header. Is there any way to do that? Thanks!

If I do not explode, I loose the 3d surface and the geometry is shown as point.

I'm copying PDF files from a source folder to a destination folder. The destination folder is named with today's date (.../outgoing/October-11-2021/).I used the AttributeCreator to create and format the date attribute called "Date_today" and set filecopy_dest_dataset to "Date_today".This all works well, the PDF's are copied into the date folder, however, I also get another empty date folder created in the folder that the workbench is in.Fanout is off. Any ideas how I can stop this extra folder being created?

Need to understand how to avoid error "Table is already locked" while doing transforming data into ArcGIS enterprise nonversioned geodatabase on SDE.DEFAULT version when someone is connected through either ArcGIS Pro or feature services. When close the ArcGIS Pro session, FME transformation works fine. When schedule the FME transformation using FME Server, users must not to be disconnected before transferring the scheduled workbench. Please advise.

I am trying to parse an SLD file (which is XML) and generate a CSV output based on the rules within it. The following is a sample of the SLD structure <?xml version="1.0" encoding="ISO-8859-1"?><StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.opengis.net/sld http

Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks

I have geotiff tiles and some need te be partially blurred, because of military terrains.  I mainly use the rasterresampler to resample the pixels in those area's to 3 meters and then resample them back to their original pixel dimensions.  The problem as you can see in the picture is on the edge.   The black edge is 1,12 meters, so the resampler doesn't have the space to make another 3x3 cell there, so he doesn't.  How can I solve this? I had the idea to make the geotiff tiles canvas bigger (see picture), let it resample and then clip it back with the bounding box of the original tile.But I don't know how to make the canvas bigger.    @Takash

I am trying to generate a JSON message to update editing templates on an AGOL Feature Service. I've got most of it complete. I am having trouble with the last piece though.  Each Editing Template has a list of fields and defaults like this: I am trying to generate 27 unique editing templates based on unique pairs of 2 attributes. The portion of the JSON text I am struggling with is the ["types"]["templates"]["prototype"]["attributes"] section. I have the correct number of "types" (27). I have the correct fields and corresponding default values.  As you can see, I am getting an extra pair of "},{" between each field as co

Hi, I'm new to MongoDB, and I'd like to use FME to import data into it. Can someone please provide me with an example that shows how to set up the connection, specifically the connection Name, Connection Type, Protocol, Host, Port, Database Name, Name and Value parameters? Harry

Hi,I want to read with FME the data from a database oracle.I can connect FME to the database but I am not able to read the linear objects. I use the ORACLE_SPATIAL reader. I have the following message : “Error - Cannot have NULL value for 'z coordinate'” Do I have to parametrize FME to be able to read the null value of Z ?Find attached the text.log oracle_spatial.zipThanks,

Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck. 

Im having trouble configuring a JSON Reader to pull data from a REST API (JSON formated). The problem is that in order to successfully call a query to the REST API (via a URI), there first needs to be sent an authorisation request as separate formatted URI sent ahead that contains a UserID code and a 'Secret' code (ie password) within the URI. The JSON reader has a single web address field (which works well for other applications). To solve this particular problem there would have to be two URIs sent - one to send the Authorisation request and generate a session ID (with the authorisation held in cookies or similar), followed another to submit the data query. I tried the 'Network authorisation' entering the userID and secret into the respective field without success. Have also tried the HTTPCaller and JSON transformers. I dont know enough about FME or API calls to configure this properly, so wondering if there is some advanced use o

Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow  Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow--------------------

Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpful.

Hi team, While transforming the tables from Reader ArcSDE to Writer ArcSDE . At the Writer end, didnt write any features and getting following error."3.1| 0.0|ERROR |Could not unregister GlobalID column 'GlobalID' in table 'DBO.Publish_Test_Cables_2'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked [TCS_TEST_PUBLISH_SYNC.DBO.Publish_Test_Cables_2]}" At Writer end, follownig parameters are used.1.Preserving the Global IDs parameter with Unversioned ArcSDE table 2.Trasaction type is "Non-versioned edit session" Highly appreciate for the solution!! RegardsVIPLAW

hi,I want Conversion   osgb to obj .when Multiple osgb to one obj ,how Merge textures image to one

Hello, I'm doing the unit "Publish your Self-Serve Workspace to the Web" as part of the training "Integrate Your Data with the FME Platform". That unit tells me to change the parameter "Destination Generic (Any Format) Folder" of the writer, to a location on the FME Server. If I change that parameter to the FME Server, and run the workspace locally, it seems to store the output in the same folder as the workspace. I would like to store it in a different local folder when running locally. That way, I can use the same workspace both locally and on the server. Is it possible for the workspace to detect if it's running locally? If so, then I can configure it to save to a specific local folder. If not, I can configure it to save to a specific FME Server folder. So far I've tried:Log File. Potentially the workspace could see if "FME_HOME is 'C:\\Program Files\\FME\\'", which i

I am new to FME and going through the unit "Quickly Create a Conversion Workflow " of "Integrate Your Data with the FME Platform". In that unit, we create a reader to a PostGIS database. My understanding is that what we see on the canvas is just the "feature types" of that database, aka individual tables. I thought that they would all connect to the same "reader" in the background. But when I added two new readers to the canvas (marked 2 and 3 in the image), they created brand-new readers in the navigator. Even in the case of reader 3, which has the exact same parameters as reader 1!Can you please suggest if there's any way to modify the feature type marked 3, to make it use the reader marked 1? When I open the feature type's propert

I run features through an AttributeFilter Transformer in order to split the stream for specific manipulations downstream. If I test this in Workbench everything works as expected. If I call the workspace in BATCH from a DOS script all features end at the AttributeFilter (identical data).In FME Log of the BATCH run I see lines likeAttributeFilter_9 AX31001 Transformer Output Nuker (TeeFactory): Cloned 818 input feature(s) into 0 output feature(s)AttributeFilter_9 SD41000 Transformer Output Nuker (TeeFactory): Cloned 1154 input feature(s) into 0 output feature(s) What is going on here ? Why are the features not passed ... very,very confused 👿 😮 FME 2021.0 up to 2021.1.3 all the same 

I have an attribute called "Status." The coded value is an integer and the domain value is a character. When I do not resolve the domains in the reader, then the automatic writer sets as an integer field, but when I resolve the domains, then the "Status" attribute and the "Status_resolved" are both characters. Is there a way to get "Status" field as an integer and get the "Status_resolved" attribute? I don't want to have to use a manual writer because I have >100 fields. 

I have a use case that is not covered under the three snapping modes available in the anchoredSnapper.My candidates are a set of lines, the anchors can be either lines or polygons, but for this discussion will be polygons.The lines need to have their end points (and only their endpoints) snapped to the nearest polygon segment. The rest of the vertices of the line should remain untouched. Currently I am developing the following workflow:Create a unique id for the lines.Extract the end points of the candidate lines, send them to an anchoredSnapper with the polygons as the anchor, use snapping type Segment.Take the original lines and send them to a second AnchoredSnapper with the points as anchors and snapping type End Point, grouped by unique id. Is there a better solution I'm overlooking?

I have been given a huge spreadsheet containing countless series of identical columns that are duplicated many times, with a prefix in front of each that indicates some kind of property of the data. I now want to reformat these data so that the duplicate columns are replaced with unique columns and the attributes that were used to separate the columns become attributes in the data instead. Please see simplified attachment (and screenshot, below) which shows the "Current format" and "Desired format" sheets. CurrentDesired I've tried several things, none of which are giving me the results I want:Adding an AttributeCreator to create a separate, duplicated pi