FME Form

I have an XML geodatabase file that contains all data and his schema(GDB structure) in XSD file format. I want to create a a new GDB using XSD file structure by extracting all data from xml file and import them in the new GDB.

Hi, I need an easy way to split a string at a desired lengt, but I want to avoid splitting words. There once was a WordWrapper but it's not working anymore. Any suggestions?

Hello everyone, I have a dataset contaning several polygons, with sometimes hundreds of vertices and one containing lines, each polygon is paired with a line by a unique ID. I am looking to build a workspace that reads the coordinates of each polygon vertex, projects them along the corresponding line and then calculates the two projections futher down each side of the line or its extension and returns their coordinates. I have used VertexCounter and CoordinateExtractor or CoordinateConcatenator to get the number of vertices and their coordinates and I have a workspace that can calculate the projection of a point along a line, but I am having trouble connecting the two through a Custom Transformer Loop to cycle through all vertices. Any help would be appreciated. Feel free to suggest any improvements to the overall thinking process as well.

how to convert ortho 2d photos convert to 3d

I am running into a issue with OffsetCurveGenerator. There are some instances where it drops nodes from the original linework and breaks the output line into an aggregate, I assume this is beacuse it folds on itself.The uppermost grey line below is the original. The green lines are generated offsets at various distances. Note that the one at the bottom has lost a vertice towards the corner. The linecount coming out of the transformer is correct, but if I run a deaggregator, the total number of lines has increased. As the red line illustrates it has split at the corner. This is not an issue in most occurrences, but I want to run some Snippers on the start and end vertex downstream and the Snipper treats the lines as if they where deaggregated. I tried working around this by first running a Deaggerator followed by a LineCombiner. But if I do the lines sometimes flip their original direction (depending on the order in which it was rebuilt), which results in the end vertexes I wanted to sn

I've successfully made an S3 Web Connection and can write a file to a specific S3 bucket. I'm not seeing how to send the a file to a specific folder within the bucket using the S3Connector transformer settings. See attached screenshot. I have the Request Action set to "Upload." There are input fields for Bucket and Path. I want to upload a file to my bucket "testBucket" and place the file in a subfolder named "Files" that's in a project specific folder named "$(projectName)." In S3 that's testBucket > $(projectName) folder > Files folder > file.png As it is, the Bucket input has to match the S3 bucket name you are uploading to, but it also creates a new folder with your bucket name, and the Path input creates a subfolder within that bucket. In S3 that's testBucket > testBucket folder > $(projectName) folder > file.png.  Any suggestions on how to target testBucket > $(projectName) folder > Files folder

We have tried using FME but it always generates an error saying that it "Could not open File Geodatabase dataset". Below is the log error: FME API version of module 'FILEGDB' matches current internal version (3.8 20210302) Geodatabase Error (-2147024893): The system cannot find the path specified. Could not open File Geodatabase dataset `C:\\Users\\guillermo.rendon\\OneDrive - SYSTEMWARE INC\\Documents\\PCS\\Database Tables\\SYSAPP1CLONE copy of PCS database\\SWIS.GDB' for reading FILEGDB reader: A fatal error has occurred. Check the logfile above for details Failed to obtain any schemas from reader 'FILEGDB' 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 FME Session Duration: 0.3 seconds. (CPU: 0.0s user, 0.2s system)END - ProcessID: 23880, peak process memory usage: 44604 kB, current process memory usage: 44120 kB

Hi, we installed FME (which we don't use for now) on a Linux server . I forgot the user ID and password for the following for URL: http://<Servername>:8080/fmeserver/#/home.How do i reset them? there is no option to restet pwd/userid "Forgot Password) option.

Hi All,Can some one help me to solve why s3Connector not showing Actions drop down list ?. Using this We have to read objects from S3 and need to update SQL database based on file inputs(JSONs).is there any dependency of Python version if yes, Please let me know which version I have to use?  Thanks Chandra Sekhar Guda

Our Functional team doesn't have access to the linux server and therefor can't launch FME Desktop/FME inspector tool. Is there a way they can launch a URL/GUI without giving them access to the linux server? thx

I have a FME worbench that is reading an excel file and merging it with data in a SDE geodatabase. For each record in the table I need to create an ID field that consists of a consistent initial 3 letters depending on the company, then a 2 digit year, and then 4 digits. It would need to be unique as well. I would need to find the last 4 digit number used by the company and add one to it.I would then need to put this all together into one ID field attribute. Any ideas of how to do this would be appreciated!

I have set up a very simple reader/writer combination that reads an ArcGIS raster from a file geodatabase (File Geodb Raster Dataset) and writes the raster to an ArcGIS Enterprise SDE SQLServer database (ArcSDE Geodb Raster Dataset). This operation fails repeatedly with the message:  “Failed to write raster data tile when writing to raster dataset 'r1_max'. The error number from ArcObjects is: '-2147155566'” I am able to successfully write the raster to a different file geodatabase, and am able to successfully write vector layers to the SDE SQL Server Dbase, so my database connection file is correct. This same error has been referenced in other postings, but I have not seen a solution that resolves the issue. Any help is greatly appreciated.Software versioningOS: Windows Server 2019SQL Server Enterprise: 15.0.2080.9FME Workbench:  v2020.2.1ArcMap:  v10.8.2

In the FME Server I have an Automation: FTP Watch. This checks on a regular interval (15min) to see if the ftp directory has changed. If it detects a CREATE event, it will call upon my workbench. In the workbench I try to download the file from the FTP server to a network server. Sometimes I have no problems, but other times I get a Time-out error. These are my connection parameters: I never have an issue when there's only one new file. It's always when there are multiples. Does it have something to do with the amount of connections? Should I manually close the FTP connection after each run? Thanks!

I have a string in a attribute. At the end of the string there are brackets containing one or more words. I would like the contents, including the brackets to be put into a new attribute. Ex:Attribute = "cat mouse (cheese crackers)"Desired new attribute = "(cheese crackers)"NOTE: sometimes there is one, two or more words with in the brackets, and I want all of them in the new field. Using a RegEx (\\(([\\w]+( [\\w]*)*)\\)$) I can select that portion of the string, but I don't know how to put that portion into a new attribute.  Currently I have an AttributeCreator with Attribute Value = @FindRegEx(@Value(Attribute),"\\(([\\w]+( [\\w]*)*)\\)$")but the result is not the string, but numbers.  Thank you in advance for your time.Julia

Hi All,I'm attempting to take a table that has 600K+ rows that have an individual value for a type of utility per location in it, join/merge the up to 8 values into one row to be able to join to another feature class at a later date based on the location unique id. I've tried aggregator, feature merger and feature joiner. Nothing is giving me the desired results. I've used the aggregator to get the unique location id, then used feature merger or joiner to attach the additional columns to the one location id. Tried to create the list, still not getting desired results. I get only one filled in. I've used testers to put yes in the named utility column based on the code type, and then where the values remained missing/null, I used the NullAttributeMapper to change them all to N in order to concatenate the data and get all columns accounted for, still missing some of the values.It's likely something that I'm overlooking, but have been working on it for two or

I am reading in a CSV file. I need to reference the first cell (Column MA and row 1) and extract the date and time from this cell, and use these two values to populate two new columns - Date and Time, and add these two new columns to my output along with existing columns such as MA, 1, 2, 3 from current CSV files. I like to get hep on how to reference and extra the cell value, and then add the two columns through AttributeManager or AttributeCreator. Thanks in advance for your help.

From this Q&A;: Geometry Template, problem getting list attributes when using variable for indicesIn fact, I've never used Geometry Template in the XMLTemplater, but I noticed that the GUI of the transformer won't recognize a Geometry Template when testing a solution for the question above. This configuration works as expected, but the property button is still red and the tooltip reports that "GEOM" does not exist.

hello,   I have a workspace with 2 tables. these tables are automatically populated. in the translation is a FeatureJoiner (left join) which joins the data from these 2 tables and "moves" it further.. Is it any possibility to stop the translation after running it if one of the input tables is empty(no records)?   Thank you Nicu 

The mentioned database is available under the following url: https://www.opengeodata.nrw.de/produkte/geobasis/3dg/lod2_gml/lod2_gml/ . According to a very brief documentation the database is provided as an ATOM Download-Feed. But unfortunately I don't understand how to handle it in FME and will appreciate any advise. Best regardsAlex

Hello, is it possible to set the cell/column width in a dynamic Excel Writer. I can imagine to precalculate the width for each column or to use a auto mode. Hendrik

I have GeoJason data from USGS site which contains Epoch time such as 1650016756409 or 1649948565590. I tried to read them in either %s$ or %Es% using DateTimeConverter, all failed and cannot convert. I am using FME desktop 2021.2. Please help.

What type of Autocad drawing was used in training that showed road names and other information as attributes. Usually DWG does not have any attribute unless we use AutoCAD Civil 3D etc. I need to tell my AutoCAD staff to provide me CAD data in that same format so I could easily convert the DWG into feature classes with useful attributes directly coming from the source DWG.

Where can I find FME 2021.x Technical Specifications?

Hello, please, I wanna ask. If I wanna export many viewports of DWG in FME Desktop, is there any way how to define which layers will be frozen in each viewports? I need little bit different composition of layers for every viewport. Thanks a lot for tips!Lubo

Will applying the FME Extension for ArcGIS in the FME Integration Console, as an administrator, persist the settings to any user of the machine or is it profile specific? Also, will this cause any user of ArcGIS, on startup, to consume an FME license?