FME Form

I struggle to make FME read csv files with correct encoding and datatype.I receive csv files in UTF-8 that includes non ASCII characters.FME think its win-1252 encoding and this interpret signed integer values like -27 as −27 and thus make it a character datatype. To fix the encoding i have to add the csv reader to the workbench and then change en Character encoding to UTF-8, then it works. But at that time the datatype is already set and I cannot change the varchar type column to be int32. It cause issues becasue now I cannot write to my database which expect int and not varchar...So how can I change the datatype of multiple fields after the reader has been added to the workbench? Alternatively (and better), define the CSV reader to be using UTF-8 before the CSV file has been scanned for its content   

I'm working with groups of features and I want minimize the number of blocking transformers in my workflow. Right now I'm using a Sorter to sort features in each group and a PythonCaller to make some attribute manipulation and comparison. Both transformers block the flow so  I wanted to get rid of the Sorter and do the feature sorting inside the PythonCaller but I don't see how to do it.Once I have the list of features, what should I do to sort them by one or any number of attributes? Thank you! import fmeimport fmeobjects class FeatureProcessor(object):     def __init__(self):        self.feature_list = []     def input(self, feature):        self.feature_list.append(feature)     def close(self):        pass     def process_group(self):        for feature in self.feature_list:             ## ...  

Hello everyone, I have a point cloud of a section of a road, and I'm wondering if i can get a front view picture of the point cloud like in the screenshot using FME. I also have the axe of the road if it can help with the direction. Thank you in advance. 

Hi, I have an *.xml file containing a column geometry.polygon.exterior.linearring.pos. with the following value 112771.183 540459.057 0.0 112769.147 540451.142 0.0 112769.904 540450.947 0.0 112764.417 540429.617 0.0 112763.641 540429 .816 0.0 112761.654. Coordinate system is ESPG:28992 how do I convert this into geometry?

Hi !I have a list named "coord" that contain 2 attributes "x" and "y". I would like to create an other attribute that concatate "x" and "y". For example :line number 1 (one geometry) :coord{0}.x = 1.25coord{0}.y = 1.25coord{1}.x = 2.25coord{1}.y = 2.25Résult :coord{0}.x = 1.25coord{0}.y = 1.25coord{0}.all = 1.25;1.25coord{1}.x = 2.25coord{1}.y = 2.25coord{1}.all = 2.25;2.25Thanks for your help !

Need Help I have been using FME Inspector to read an IFC file. Inside the IFC file, there are IfcGeographicElement features (DTM surface). My question is, why doesn't FME display the shape of the object?I noticed in the FME the number of vertices is zero, but when I opened it in Open IFC Viewer, I can see the IfcGeographicElement object, and there are vertex values 15515.Attached herewith are screenshots of both applications views.

I am trying to map a geopackage file to another geopackage file (same format). Why is the geometry in the reader I input in 3D format, but the geometry produced by the writer is only in 2D format? Please help.

Boreholes. Im trying to find a transformer that constructs the end points in a dataset with boreholes. The boreholes have all necessary attributes: Z, Azimuth, angle and length. Is there a transformer that does the it or something I have to build? cheers

I have a list of lists resembling this structure:sublists = [[1,2,3],[4,5,6],[7,8,9]] When I try to set this "list of lists" into a list attribute I get the following:code - feature.setAttribute('chunkList{}', sublists) error - Python Exception <TypeError>: Could not convert attribute value to a supported attribute type.Traceback (most recent call last): File "<string>", line 95, in inputTypeError: Could not convert attribute value to a supported attribute type.Error encountered while calling method `input'PythonCaller_Get_chunkList (PythonFactory): PythonFactory failed to process feature The goal is to have a list of 1000 unique IDs or less to feed into a readerI do not know how many lists there will be ahead of time so I need to dynamically break out the lists into individual lists of 1000 elements later in the workflo

Hello everyone,I have produced a dataset in oracle. I can't display those data in ArcMap because of the issue "the number of points is less than required for feature".After reading several posts, I now understand that the issue come from the esri grid (toleand and precision) which snap point and this snapping process when displaying data in esri create some geometric issues like self-intersections that were not in oracle.I thought of writing to a temporary geodatase. However, after importing the feature from the geodabase to oracle, I still face the same issue. Because, it is an esri issue, the geometry validator is not able to detect them. However, there used to be a transformer called

Hi, I'm trying to read PDFs and it looks like each character of each word is represented as individual features. Each PDF has thousands of these text features that I need to combine to make words. I'm stumped as to how to string these single character text features together to create words.  I have attached an example below. Any help would be appreciated. Thanks in advance.

Hello,  is it possible to read geometry from Sqlite in FME 2023? In FME 2022 I was using SQLite Spatial (GDAL) (deprecated), but I'm missing this format in the new version. Thank you.

to   What is most important is i would like to add permanent different symbol for each 'GType' whenever i load it into Trimble Connect + AR Viewer

Good morning. I'm writing this question to see if someone can provide a new idea! I saw couple blogs talking about, but without good result.I am trying to generate an atlas, given an Oracle database, of different files, each one with its ID, generating a PDF file for each one.The problem appears when adding a common image, such as a logo. If it comes from a reader, when doing a "fanout" on the writer, how it detects that it does not have an ID generates a file separate from the others, with the common information.After trying with a cloner, feature merger, or adding an attribute that is the path to the image for each record, I cannot get it to be seen (I can show that the path is physically written).Any ideas? Thank you so much!

Hello. I have a question. In "list_of_fixes" I have a list of track points and some of the tracks have more than 75 points. For tracks that have a higher number of points, I would need to filter and shorten to 75 points. The reduction in the number of points should be from the center to both sides. This means if I have, for example, 81 track points, I will delete 3 points from each end of the list. In the attachment I am sending fmwt, where the list is visible. Some ideas? Thank you very much

Hi everyone,  I have a dwg with autocad blocks which has several layers of polygons, polylines and annotation. I have a workspace to extract and convert these to shapefiles.  The problem I have is that multipart polygons and polylines are being split by the FME reader. When opened with ArcMap or Autodesk TrueView, the multiparts appear correctly. I have tried to play around with the parameters of the dwg reader (entity option/advanced options...but everything I have tried so far has not worked and some of the settings read far fewer components than needed).  Anyone have any experience with this? Thanks in advance! :)

Hello everyone -  We are migrating from on-prem to Azure. Its lift/shift approach. The machine name is not going to change, but MAC address will change. We can't really get a MAC address before we move the machine. I have below questions. Can we directly edit the current license file with the new MAC address after we have moved to new server ?Does the licencing software supports TWO Network adapters setup. ( two NICs). If its supported, then we can do the below. Is the license server smart enough to detect there are NIC#1 and NIC#2 and that the MAC address of NIC#2 is the correct old address and hence the existing license is valid? We can lift-and-shift the PRD-XXXXX-01 server with the existing license. This will create by default a NIC#1 with the new MAC address.We can then attach a second NIC, NIC#2, to this migrated VM and overwrite its MAC address with the old existing on-prem MAC address.

I have been googling/trying to read about it but I dont seem to understand it too well. I dunno if I am trying to do something I cant. I am trying to use the UK Gov website (https://www.tax.service.gov.uk/check-council-tax-band/search) to search for council tax bands with a list of post codes. But the box to search the postcode sends the request and it appears to encrypt the postcode in the URL. Would it be possible to make it fill in this box and hit search? Appreciate any help as I am completely out of the loop here, never used the HTTP part of FME much. Cheers Also apologies if I have posted this in the wrong place!

FME Quick Translator 2023.1.1を使用して、CitygmlをIMXに変換したいのですが、エラーになります。原因と解決策をご教授頂けると幸いです。

Here is my use case: I have created a workflow that works well and can handle multiple files. However, when I publish this workflow to FME Flow, I have the following problem when I copy and paste multiple files at once: Copy and paste two files at once.The resource or network directory sees the change and triggers the same workflow twice (see https://community.safe.com/s/article/Do-the-Directory-modified-Automation-triggers-support-single-events-for-multiple-file-datasets)The first workflow runs fine and writes all my data to a databaseThe second workflow (which is the same, just triggered a few milliseconds later) fails because

I have a input data file with a unique ID (BORRHAL_NR) with 2 variables (Date/Granvattenniva). I am using a python caller in a CT to generate a chart with matplotlib. I would like to produce as many charts as unique IDs, and I am using the group by in the custom transformer but even though it produces in this case 4 charts I see that is using all data from all unique IDs in those charts (except for the first one that is actually correct).Any ideas?I am using FME 2022.2.4. (Build 22792)

The webpage titled, "Efficiently Convert ArcSDE to GDB" doesn't provide documentation on how to do that. Is there a tutorial or documentation somewhere on how to convert ArcSDE to a File geodatabase?  

I see in the documentation that this is possible (I.E. setting a value in SchemaMapper using a built in FME function). But I sure can't figure it out. Does anyone have an example, or can they please point me in the direction of an example? Thank you.

I used points geometry to create my .shp file. I got the visual preview from the read file. But after extruding, I am not getting anything and it's not showing any error. I want to create 3d cesium tiles.