FME Form

I am trying to update a feature class containing statistics. Basically i am using the following fieldsfme_basenamefme_featuretypeand each value from the fme_db_operation (insert, upsert, update, delete etc) is the number of eachmy problem is, that if there are no deletes i get no features coming through as expected, but how can i still send through the fme_basename, fme_featuretype, and for example the value of zero for the delete attribute.I want to be able to add the total records, but obviously can not do that if there is no value, hence setting as zero.From what i have, if there are changes then they go through the workflow as expected.Regards Andy   

Hi FME, I have a dataset with date/time stamps where I need to retain only the first occurrence in each hour, on a given day. For example: 1/1/2000 12:05 --> Keep1/1/2000 12:10 --> Discard1/2/2000 12:05 --> Keep1/2/2000 12:15 --> Discard1/2/2000 12:59 --> Discard1/3/2000 12:00 --> Keep1/3/2000 12:12 --> Discard Thanks for taking a look!

Hi!I have an issue that I just don't understand.  Using a FeatureMerger that outputs the correct attributes från the supplier, but it's values are all wrong. First off, I have a TestFilter with output ports depending on if the attribute "Version" is 0, 1 or 2. In this case the output for Version 2 contains 4 points with relevant attributes according to the image below. They are all "Version" 2 and have missing values for "Avslut-datum".Next, I want to use a FeatureMerger to merge this with a bigger database with hundreds of points, to assign the attributes of Version 2 to those said points, if they match. I want to merge the points from the bigger database [requestor] to the output from my "Version 2" [supplier]. See the FeatureMerger parameters in the image below.However, the merged data does not contain the attributes from "Version 2". For example the attribute "Avslut-datum" should be <missing> and the "V

Hi there. I'm preparing our GIS data to adjust to align with new cadastre boundaries when our state mapbase is updated as part of the Digital Cadastre Modernisation. So far with testing it all looks good, but I see one polygon on one the layers has disappeared in the shifted version. On investigating it looks like the adjusted parcel this features sits on looses a few vertices in one corner and the shift vectors being used possibly cause a self intersection. I've attached the example. On the left, the grey is the current parcel boundary and the purple is the shifted, with the shift vector joining.On the right is the particular layer that aligns with the boundary that is disappearing post shift. You can see the shape of the parcel changes and it looks like the shift vectors would cause a self intersection. Just wondering if there are any ways to avoid this? I can see a record in the output data but no geometry, or an invalid geometry. Thanks in advance. Josh

Hello,I'm using a customized projection system that is exported to other official projection (Lambert 93, Lambert zone 2...) and I would like to run these transformation within FME. For ex, here are the steps going from 2154 to my custo projection:Prime Meridian Paris to Greenwich then:{LambertConformalConic: a=6378249.2 f=293.4660212936269 lat0=46.799999999999955 lon0=2.337229169999998 k=0.99987742 (inv)}{GridShiftTransform(NTv2:rgf93_ntf.gsb (Inv))}{LambertConformalConic: a=6378137 f=298.257222101 lat0=46.49999999999996 lon0=2.999999999999997 k=1 }{AffineTransform2D(ScaleXY(1,1) Rotate(0) Translate(700000,6600000))}How to define this in FME?

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

Hello , i have geodatabase data as input ,it includes different points ,lines ,annotations . I would like to read this data in FME workbench and filter specific data from them for city then write the output again into new geodatabase writer .my problem : when I use spatial filter and use the specific city as filter and the geodatabase data as candidate .so the passed port include all data together and for sure not each input has the same attribute names as other .How could I write the output for my data (passed port ) into geodatabase format and each writer includes only his own data without any problem . 

Is there a way using a regular expression to split a string of text such as an address by a number of words/spaces? Or even more functional, split a line at the first space after a certain number of characters?

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

Hello everyone, I try to automate a monthly calculation of water deficit, based on monthly rainfall data. Each feature is characterized by a year (integer), a month (integer), and rainfalls (float). The calculation involves the water reserve at the end of each month ("final reserve"), based on rainfalls and number of rainy days.  My challenge is that I need to carry this quantity to the next month ("former reserve" of current month = "final reserve" of previous month). Easy to do in Excel, but I'm not sure if this is possible and how I should proceed in FME.  Is there a matter of "iterative calculation" here, since the data of each month depends on data of previous month ? Should I convert my "year " and "month" integer into date format ? Thank you in advance !Regards,Arnaud 

I have authored a workspace that creates bills for a lot of customers. The item price on the bill has to be returned with 2 decimals, so I take the mean of all the item prices and ceil the number to 2 decimals. Because of an occasional outlier I can't rely on normal rounding function.In the case below I have 1.173 measurements with an item price of 0,43. The min and max is 0,43 and the range is 0. But the mean value is != 0,43. And since I have to use the ceil function the price changes to 0,44. I understand this must be caused by the internal handling of 32 to 64 bit conversion, but in this case a seemingly very simple operations doesn't work. Why can't I rely on the mean calculation?What can I do to rely on it in the future? 

Hi All,I'm trying to update MDB_ADO reader in existing workspace - it's new data delivery with the same structure as the previous one. I'm getting "An error occurred while updating the reader". I tried also open some random tables in blank workspace, and I was able to do it, but after ran workspace I got "Error running translation" or FME has been closed "automatically".At first I tried to do it in FME 2022.1.1.0 (64 bit), MS Office is 64-bit as well.Then I installed the newest version of FME 2022.2.5.0 - at first everything worked fine - I updated mdb reader and I was able to run the whole workspace. When I closed FME and opened it again I wasn't able to update reader or open any other random tables in blank workspace - so same errors like in older FME version.I tried clean all temp files, I created new temp folder, I tried to repair mdb via "Compact and Repair function in AccessDB. After all of these changes I was able again to work

Hi, I'm running a simple workbench that converts a single dwg to GeoJSON. when I start the process normally in FME it works fine. But when I make a bat+tcl I see that the path to the dwg file changes and there is a "\\" missing between the folder (Linjedata) and the dwg file (T_E6SL_P00_f_C_E6-Profillinje.dwg) (AutoCAD Reader: Error opening file 'C:LinjedataT_E6SL_P00_f_C_E6-Profillinje.dwg' during version check) Is this something I can change in the tcl file? However, I got around this by putting the dwg file on C:, but then I only get a new folder with the same name as the dwg file with an empty file called "C" inside as the result, instead of a GeoJSON file. What I'm trying to achieve is just the same as when I start the workbench in FME, but run as a bat file.

and error message below. Not sure where to from here. It was working but I am a total novice at web connection stuff. 2023-06-01 15:11:03| 0.9| 0.0|WARN |Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad Request2023-06-01 15:11:03| 0.9| 0.0|ERROR |Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.2023-06-01 15:11:03| 0.9| 0.0|ERROR |Traceback (most recent call last): File "fmegeneral\\plugins.py", line 500, in input File "webserviceconnector\\fmewebfs.py", line 1096, in receive_feature File "googledrive\\gdrivefs.py", line 569, in handle_operation File "webserviceconnector\\fmewebfs.py", line 699, in handle_operation File "webserviceconnector\\fmewebfs.py", line 856, in handle_download File "googledrive\\gdrivefs.py", line 466, in get_item_info File "googledrive\\gdrivefs.py", line 241, in get_file_metadata File "C:\\Program Files (x86)\

I would like to be able to use FME to bulk upload data to salesforce. We currently manually upload csv files with awareness that there is a limit of 50,000 rows per file (salesforce import wizard). I have seen it should be possible to automate this using the salesforce reader/writer. I have the API credentials for salesforce and I can see all the table objects available in FME. The issue is that the object we are trying to write to appears to have different fields than expected when read (these look to be metadata fields) - see image. When we run the process to manually import using the wizard the attributes are those in the csv uploaded (see image). Both of these tables are the custom table 'property(_c)', the saleforce URL indicates that this is the case. Do you need to change permissions on the object salesforce side or do anything specific with the reader/writer in FME to get this working? Kind regards,  Antony

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

I would like to output an excel template with one of the columns having cells containing values from a pick list.  From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.  However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro .  FME 2021 Thanks in advance

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

One of them is:WARN MessageCould not load module 'C:\\Program Files\\FME\\2022\\plugins/MAPINFO.dll' : 'The specified module could not be found'Could not load module 'C:\\Program Files\\FME\\2022\\MAPINFO.dll' : 'The specified module could not be found' Translation is successful (Desktop or Server)

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

Hello all, I was planning to do a small workshop on FME Data Express... While preparing this, I found shockingly little information on the specific parameters I could use to interact with some specific phone-app functionality. This ... was the most informative post, noting 'We are still working on our documentation.' two years ago. How do I make the app ask for a QR-code?Can I somehow consume a picture?I seem to be able to get the location of the device with a specially named text-parameter. Are there more of those? Please, give this app some tender love and care in the documentation. Give it a technical blog-post and some example workspaces one can upload to ones own server as a startingpoint.. Martin

I have a CAD layer of control points which have two labels around it. I'm trying to extract the neighboring labels and add them as attributes in the final geodatabase. I have tried using NeighborFinder but it captures the nearest label only. I have tried to use a Tester to differentiate between the two labels and then run NeighborFinder but it leads to multiple records. The red circled is the control point and orange circled are the labels.  How can I capture the attributes and have 5 points in the output rather than duplicating them?