FME Form

Is there a way to automatically set the datetime within a parameter and use it to fanout a dataset so that does not then create a folder for every minute the workspace was running.  I just want the initial date time the workspace was run. The default date time parameter is not really ideal for this as it defaults to midnight and requires user input. I'm hoping to not have to use a workspace runner. Using DateTimeNow seems to create multiple folders as the outputs are written.

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc.   Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'

Hi, I am trying to connect to my organisation sharepoint to fetch PDF files stored there, but API call is giving 401 error code with the message "An error occurred while accessing the URL". I am using the username password in the HTTP caller that is used to access the sharepoint in the web browser, but is it not working. The workbench is running on the server, which has another set of authentication, and I am not sure if that is the reason why I am unable to access the API though FME, while I can through the browser. Can you please provide some solution or workaround for this?

So far, I tried two approaches.Read pointcloud--> extract bounds-> tile point cloud into 1mx1m raster-->extract number of points per point cloud-->sort the number of points--> aggregate the number of points into groups-->write to csvread point cloud-->extract bounds-> calculate density by PointClouddensityCalculator--> rasterCellCoercer to extract the number of points into z--> coordinate extractor to get 3d points--> aggregate z (which corrsponds the number of points-->sorter-->write to csvThe problem with both approaches: it takes a lot of time (more than 1 h) . Does anyone have an idea how I could calculate the density quicker?I add a screenshot of my workspace.I appreciate any help. Thanks in advance!Kind regards,Ingrid

Hello,When use Obj Reader,materials aren't appearing properly. .mtl does not refer to additional image resources. Attachment is my obj file.Thanks

Hello everyone,I'm very new participant in this community and FME as well. Please can everyone help me to convert data from .gdb files to .xml file I would be very grateful if someone could write me the steps and some of the important details in the transformersInput (reader): geodatabase file (with extension .gdb). For example, this file can be read in ArcGIS ArcMapOutput (writer): one .xml file Thanks in advance.

Hi, How can you see if a line is a multiline or a polyline?I have a shapefile where i have both but it's creating problems so i have to detect the multilines en make polylines of them.I would think that i should use de deaggregator?

Hi all, I'm using the AmazonAthenaConnector to query an Athena database.In the Translation Log I'm seeing:  "2023-03-10 09:04:27| 6.1| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 5.225 seconds. Data scanned: 27694.09 kB" I'd like to use the info on the file size / Data scanned to do some cost calculation. 1: Is there a way to incorporate the output of the Translation Log as attributes in the workbench? Alternatively I guess I could load the .log file in a workbench and use that for the calculations... 2: I am wondering , can I run the main translation AND the .log file in the same workbench? (wait for the main translation to have finished so it can read in the log file and perform operations on that.)   

I plan to use this method after a transformer "AttributeFilter".So the the number of cases the valeu of an ttribute varies define the repetition number the transformer . 

Morning all,I have points (A) at the intersections of streets/lines. Also I have points (B) scattered everywhere. I need to keep location points A at intersections but would like to bring attribute information from points B. Point A can get all other points around it and stacked at this location.

I am trying to clip many different data layers based on a county boundaries for quarterly updates. I need each layer to end up writing to its own feature class. I am trying to not have to use a lot of different clippers or have to update the writer feature class name every Quarter. That is why I am trying to use a string concatenator that will add the correct quarter to a new attribute to use as the name each quarter. I figured out that I can use the feature type filter after the clipper to get everything to the correct writer feature class but the attribute that I created does not get passed through the filter. The field is under the drop down for blank and unfiltered but not on any of the other ports. 

Hello, I would like to know if this architecture is available with FMEServer : 2 Servers are independent, each have their own FME Interface / ConfigurationNevertheless, these servers share the ENgine.In this configuration , we can imagine for example that these servers share 2 static licences and 7000 hours of dynamic licences.I think it is possible using 3-tier architecture , but I'm not sure 100%. FME is getting more and more popular in my job and maybe, if technically possible, this architecture would be a solution to ease the administration.Thank you  

Hello FME community,I have two feature classes with line type. I would like to find the lines in Feature Class 1 that are parallel to other lines in Feature Class 2 at a certain distance. I calculate the angles of lines and with NeighborFinder I create a list of lines that are near but I don't know how to find the lines that have the same angles to feature class 1 (with about 10 degrees difference). 

Hello everyone.I used this tutorial in order to convert 2d Polyline with Z value (for example, polylines of rooftops), in order to transform them to 3DML file.I succeed to do that, but I have a small problem.The exported 3dml's height is penetrate the terrain surface because the FME don't know what is the absolute ground height. The question is how can I fix this problem? There is an option maybe to insert height surface? (You can see that the problem may accrues because Extruder don't know what is the absolute ground height)  This is my schema:  Thanks a lot! 

Hi,The listsearcher makes it possible to search in a list for a certain value on 1 Attribute.Is it possible to do this (without listexploder) to search in a list for values on different attributes?list example:_names{0}.LC = Arabic_names{0}.NA = Latin_names{0}.PN = true_names{1}.LC = Arabic_names{1}.NA = Arabic_names{1}.PN = true I want to search in names list where PN = true & NA <> Latin and get that indexback. In this case it would be 1If it's not possible in FME, how would I do this via python in FME then?

Hello.I've read in 52 gpkg files into one featureReader. I now want to translate the 52 gpkg files to 52 tab files. But to avoid creating 52 separate featureWriters I want to do this in one featureWriter. Is this possible? If so, how? Thanks.

Hello.When I loaded the ifc file, I noticed that the position of the text was wrong.The image below is the Inspector View when reading FKZ Haus data (*1) (*2).*1) https://www.ifcwiki.org/index.php?title=KIT_IFC_Examples*2) I specified "Industry Foundation Class STEP/ XML Files (IFC)" as the format. On the other hand, the image below shows the same data displayed with FKZViewer.(I hide everything except IfcAnnotation to make it easier to see) What is the reason for this misalignment? Also, are there any workarounds?

Vendor provide me the API, for example: https://www.gocanvas.com/apiv2/submissions.xml?password=xxxxxx&username=xxxx@companyname.com&form_id=3971479&page=4; this way i just able to pull 100 xml pages. In order to pull "30 pages"(page4 is 100 pages of xml)i have to set 30 readers from page 1 to page 30.would you tell me how read all at once. thanks in advance note: page=4 mean i just able to pull 300th to 400th pages of data. i need to pull 1st to 3000th pages of data-> maybe we need to create parameter or loop to pull ?. thanks  

We are working with an Esri SDE SQL database and bringing some annotation layers into FME to review attributes and confirm the appropriate values have been applied based on our business rules. When looking at the Annotation layer within MS SQL Server Management Studio, the attribute of "ELEMENT" shows up. When in FME and after exposing all the attributes on the Annotation layer, no "Element" field is seen. What can be done to expose this attribute in FME?Thanks in advance for your time.

Hello, could i get some tips for Validating IFC files.

I have tested 7 different ways to download all WFS points within a geometry and all give an error using FME 2023.0 Tried the "Initiator OGC-Intersects Result", "Bounding Box OGC-Intersects",Tried settings a Filter<Filter><Within><PropertyName>Geometry</PropertyName> ... GML Polygon Data ... </Within><Filter> Filter Overlaps etc.Filter BBOX with and without namespace declarationsFilter Envelope Nothing seems to be the right settings. I remember having the right parameters when using FME2019 but that doesn't seem to work anymore. Maybe my service is not responding according to specs?https://geodata.nationaalgeoregister.nl/inspire/ad/wfs?request=GetCapabilities&service=wfs  

I am trying to reproject coordinates that are in NAD27 to NAD83. I am not sure about what I am doing wrong?I am using the FME Desktop 2021 version.

I am using an HTTPCaller to return some XML which I then want to turn into attributes. I can extract the Project fragment below using the XMLFragmenter (with Projects/Project in the Elements to Match parameter) but I haven't figured out how to directly extract the children into fragments or directly into attributes. Using Projects/Project/* doesn't work. For instance, I want to extract ProjectNumber and Status more directly into attributes. So far my solution has been to use a StringSearcher and SubstringExtractor to get each attribute. That's a tedious way to do it. Any advice on a better way? <?xml version="1.0" encoding="UTF-16"?><Project ProjectId="508DKDS6B2KA" ProgramId="YAK0C5V4UNVH" ProjectNumber="EST-00001" Status="Cancelled/Archived" StatusTimestamp="2021-04-01T12:23:55-06:00" LastChangeTimestamp="2021-06-29T14:15:01-06:00" ></Project> 

How I can convert milliseconds (for example: 1663767945000) to %Y-%m-%d %H:%M:%S ? I tried with a DataTimeConverter transformer but it doesn't detect the input format. Any ideas? Thank you.

Does anyone have an example of how to successfully write out to 12d XML?