Using transformers to modify data.
Recently active
We have some automatic data-updates on an ESRI File Geodatabase. I also want to update some parts of the metadata also automatically as part of the update procedure. I want to change Edition, Publication date, Revision date and dataset ID. I succeeded getting the right information to insert in the XML updater, but the XML updater doesn't seem to do anything in the metadata. I don't see any result. Could anybody help me out? I added the workspace to this question. Addition 9/12/2022:I just discovered that, if I fill out these fields manually in ArcGIS Pro, that this information is not found in the metadata that is read by FME. This is what's filled out and seen in ArcGIS Pro:I used the mehod with the XML Formatter to see what's in the metadata, and this gives the log attached. You'll see the information shown in ArcGIS Pro, can not be found in the XML read by FME.Exporting the metadata out of ArcGIS Pro to XML, contains other (and right) information: <identificat
Sorry if the question does not express what I want to achieve, but of the top of my head I did not know how to ask differently.The issue I have is, that features provided by the very left reader are used to identify raster files they intersect with, which afterwards are mosaicked and processed. There are a lot of raster files and a lot of features coming from the reader, and I would like to run this entire process rather feature by feature, instead of feeding all the features into the process.What is the best way to achieve that?
Happy New Year all. Can anyone please how can I change a date column (dd/mm/yyyy) from string to date time format within a workbench. The column is originally coming from a CSV file but after reading in FME, its getting converted into string. I want to apply test filter to get values within a certain date period but because the date is in string, I cannot do it. Do you have any idea how to resolve the issue? Thanks in advance.
Hi, I am looking for a solution to read the correct text height of a dimension from the Model Space. If the dimension is not-annotative, you can simply use the fme_text_size attribute. When a dimension is set to Annotative, the fme_text_size is rescaled.In AutoCAD:While in FME:--> Scaling factor = 10However, I noticed that most of the time in the autocad_extended_data_list{} , you can select the last "real:" value in the list to find the actual text height.So far so good, but now I have a new input file, where I cannot find a correct real value in this list. I have attached this DWG.--> scaling factor = 5 I have disabled the "Explode Dimensions" in the reader parameters, butI have checked an this has no effect. For dimensions I can't find some kind of annotative scaling factor to multiply the fme_text_size. Any ideas? Jasper
Morning, I'm trying to extract logger data from an api returning XML. I can use the XMLFlattener to match my message element and return the pt element as an xml fragment. However I need to then expose all the key value pairs in the <pt></pt> element into attributes and if I try to use the AttributeExposer there's a huge list, which will change when i run the api with different data ranges (ie more key value pairs to manually expose).Is there any way I can automatically expose all of the elements within the <pt></pt> xml element one column each of time, value, ch, chtype etc to insert into a db table? Cheers!
I have a linear asset, such as a road, that needs work done to it. The work group can only travel 5 miles per day and can only do a maximum of 5 jobs per day. I am trying to group the locations using these constraints. Some groups may be 5 miles with 5 work locations, some may be 5 miles with fewer than 5 work locations, and some may be less than 5 miles with 5 work locations. I have both the linear asset and the work locations as spatial data with all the appropriate attributes (road name, mile points, etc). The linear asset has measure values that correspond to mile points. What is the best way to dynamically group the work location data based upon the above mentioned constraints?
Hi, I would like to change the coordinate system in Lambert 93 EPSG: 2154 for shapefiles. But i can't find the good one in the coordinate system Gallery. (i have a tamplate to compare(PRJ file)) do you know if i can add this .PRJ to reprojector maybe ? because i need to change a lots of files Thanks, Charles.
I have power lines for a utility that I want to merge into our esri gis system. For any given feature class there are some field that will map straight across without modification. But there are many cases (many fields) where they have, what I think of as an esri domain (a code - integer linked to a description- string). Then on our side, we have a normal arcgis domain. So, for example, they may have an attribute value of 2 that I need to change to a 4 when it is loaded into our gis. At first, I used the attribute value mapper. This worked great. But it does not appear to work well for many fields. So, now I am trying to do it with schema mapper. I did the tutorials but still having a hard time getting it to work.So, questions are:1) Is schema right tool for this problem?2) If so... what is wrong with my workflow:Lookup table test (only one field so far)ActionsWhat I am trying to say is:if ID_PHASE = 1 then PHASEDESIGNATION = 99 Thanks for the help!
I have been tweaking workspace briefly described in this question for better performance and encountered weird behaviour on setting up worskpace runner parameters. The workspace is loading XML data, parsing and fetching results to PostGIS database. When I setup the workspace runner to 4 concurrent processes and 4 workspace runs per process I end up with some features not being written. On contrary running directly the child workspace or setting up the workspace runner to just 1 concurrent proccess, all features are being written.On the comparison you can see limited features written (left, import_RUIAN_c4_w4.log) and all features (right, import_runner_c1_w1.log) from the same XML:Looks like some translations fails in concurrent processes trying to delete some file:ERROR |AttributeKeeper_6 (AttributeKeeperFactory): Failed to delete the following files: 'D:\Zakazky\APHA\FME\per_partes\import_RUIAN_1b_zapis_log.ffs'. Please ensure that the files are not in use and that you have sufficien
Hi everyone, I am creating a model to make it quicker to convert DWG files to SHP. They have the same format but there are several hundred files in various folders. The DWG files get updated from time to time, so the tool will be used often which is why I would like to set it so I only have to input the DWG file and the rest is automated. For example: C:\\CAD\\A\\1\\points.dwgC:\\CAD\\A\\2\\points.dwgC:\\CAD\\A\\3\\points.dwgC:\\CAD\\B\\1\\points.dwgC:\\CAD\\B\\2\\points.dwgEtc.... I need to write it to the GIS folders which are very similarC:\\GIS\\A\\1\\points.shpC:\\GIS\\A\\2\\points.shpC:\\GIS\\A\\3\\points.shpC:\\GIS\\B\\1\\points.shpC:\\GIS\\B\\2\\points.shpEtc.... I have used FilenamePartExtractor to get the filepath of the DWG and then used StringReplacer to replace "C:\\CAD\\A\\1\\" with "C:\\GIS\\A\\1\\". Is there a way I can use this value to specify the output location? It has worked to specify a filename, but no luck with filepath so far. Thanks in
Hi all, How to join the line geometries to make area in below scenario? I tried with area builder transformer it could able to convert few lines only !Is there any other ways?my input data is dwg file. Thanks in advance!saravanakumar
I got this message when laoding data to a ArcGis Online Feature Layer: Python Exception <HTTPError>: 413 Client Error: Request Entity Too Large for urlThe workspace use FeatureWriter to load lines in to a AGOL Feature Layer. It has worked well for a long time, but suddenly it stops with this error. What does this error mean?
I feed a table to a pdfpageformatter. The table varies in height.I would like to create an object in the pdfpageformatter that is very large, but for the layout to make any sense the input-table needs to be aligned to the upper-left corner.It seems that the default behavior is to mid-align the input.
have 353 asc files but only need 137 (BatesmanBay example) as identified in polygon file, name field to filter files
Hello There we are consuming streaming data coming from the GPS location of a large number of assets, we are getting around 4 Million records a day all those records represent the location of the asset moving in reel time we need to store this data in the database to get the path for each asset. due to the size of the data, it takes a long time to query the database and retrieve the path of the assets during a period of time is there anyway, instead of storing the Point we store line, and this will reduce the number of records how could build a line path that will have the same alignment as the road or any other solution that will solve this issue Thanks
I have a dozen connected large point clouds (2-3 sq km) which have ended up about 100m out in elevation due to transformations performed in another product to align them accurately. I want to take each point cloud (LAZ) and shift it up 97.5m in elevation. How can I do this in FME? Please be detailed as I am still learning to use FME and not familiar with a lot of its capabilities. Thanks in advance
Is there a way to: make a reader case-insensitive?Change the case of the headers?Stop the workspace and generate an error if the wrong case is encountered in the file headers?
I've noticed the Features can be read irrespective of if the random string at the end is present or not. They seem to change each day or time I re-add the reader, which doesn't make much sense. The AGO Feature Layers are named fine, permissions are correct, so there's no reason for it to add random characters. I didn't know if there was anything in FME that might resolve the issue as I cannot run the job unattended. It refuses to read the Feature Layer, though using the GUI I can read the Feature Layer and Attributes just fine.
A generic workflow is required to produce a linear referencing system of road network. Please share steps and needed transformers with parameter settings. Thanks.
Hi.JPG photo from a DJI drone contains coordinates in the EXIF but is not displayed in the correct location.
Hi everyone!I try using AttributeSplitter to split up a file path in all it's folder parts, but the returned list is empty. I have tried to split by '\\', '\\\\' and '/' but with the same result. How do I get this to work?I want the 6th folder in the path wich can contain 7 or more folders so it doesn't work with FilenamePartExtractor.I am using Windows. The filepath looks like this '\\\\server.local\\path\\to\\folder1\\folder2\\and\\so\\on\\file.mxd
I prepared simple script with HTML report. Script is checking all txt files in input directory, compare values with parameters and prepared html report with href to each file or folder. I have access problem i think in FME Server Streaming Service.Hrefs to files are not working with FME Server. HMTL file generated from this script is working outside the FME Server Streaming results. Can you help me?
I have a project in which I generate four shapefiles. In 1 of the shapefiles I add new attributes via transformers and fill them with a specific value. But even though I have neatly arranged the order of the attributes in my writer, this is not followed in the output in the shapefile. The added attributes are in other places than indicated in the writer itself. How can I ensure that the output is neatly arranged as I want it?
Hello , I would like to have fixed color of lines and write it into Esri shape file.i have used feature color setter or DGN styler but it does not work .when I read the shapefile again , I have found it has random color .Any help please FME 2021
Feature Type: `'Attribute(string: UTF-8): `fme_geometry' has value `fme_point'Attribute(string: UTF-8): `fme_type' has value `fme_point'Coordinate System: `LL84'Geometry Type: IFMEPointCoordinate Dimension: 3(-123.07702450837,49.2953290456494,0) Data displays well, but I wonder about the implications and causes...Does it have to do with ESRI engine?