General

I have an excel file with many sheets. I need to process each sheet separately. How would I go about doing this?

So I got a dataset, floorID and Unit Number. Here is what I want to do.  For each of the floorID (meaning each floor), the unit number should start from 0001 to the max number in sequence. For instance, in my example, there are 4 floor ID "level1", the unit should be 0001-0004. In contrast, there are 3 floor ID "level2", so the unit should be 0001-0003. In my case, the input of floorID and unit number is unknown. But I want to find out the missing unit numbers or wrong input unit numbers. Could someone guide me how to work in this case? I have attached the correct and wrong output in here. Oh, also, I have another question. This is the sample of the data1-1, 1-2, 1-32-1, 2-2If I want to see if the incoming input is within this value, might I ask what kind of transformer should I use? Do I need to input these values manually? Thank you very much and sorry for all the questions. Zach 

Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?

Hello, New to using web services here. I am trying to use oauth2 login to Portal ArcGIS Server feature service on a specific layer index and use the REST Query function to pass in a couple of parameters and then have the output to json format.  For instance this is the ArcGIS Server Feature Service on a particular feature layer (e.g. index 3) https://ppp-snoopy.com/un/rest/services/SnoopyUN_Network/FeatureServer/3  Then pass in the string query parameters according to this reference page Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers  where: GUID = 'abc1234xyz'gdbVersion : Snoopy.Surveyoutfields : objectid, GUIDf: json I am trying use HTTP Caller to access the ArcGIS Server feature service using NTLM authentication and got this error :{"error":{"code":499,"message":"Token Required","details":[]}} I also tried to use direct URL to the ArcGIS Server Feature Service (without Portal) and no luck.  Any help wo

I want to know if there's a way to Generalize (in 3D) a 3D line. Common Generalizer tools are for 2D lines. But is a 3D Genralizer tool exist? I mean if I want to generalize a 3D line from a Z tolerance. Imagine a 3D polyline with ups and downs and I want to smooth or generalize the line. And the resulting line is within 20cm (in 3D) from the original 3D line. Thanks, Frank

Sorry Team, This is not one question.  I have one fme file, which writes (conventional writers)to 50 PostGIS tables. I need table names and total features written counts from fme.Since I am writing to a staging database, I need to do validation of counts, before making / swapping these tables as the main tables for the application.  once I am okay with the previous counts(count from the previous run) and current counts(comparing prev run with the current fme run), we are copying the tables to the main DB. table1 100000table2 50table3 6895698....like this to write these info (table_name , total_count)to one more postgres table ie fme_written_status table. I know our feature writer does this job, but I need to replace all the writers. summary port gives this output with total_features_written.But not one feature writer, I need 50 separate feature writers. because summary port gives total, not table-wise. can I replace all normal writers to feature writer transformers in one go? can I ac

I have selected ~50 records from a shapefile of ~5.5 million records using a column of unique reference numbers. The unique reference numbers are stored in a CSV. I have used FeatureJoiner to join the CSV and shapefile.  The resulting joined records have been correctly selected but the values in final two columns containing the X and Y coordinates have been altered when viewed in the visual preview. Where in the workspace has the change taken place?

You can export/import database connections in FMEworkbench (as xml or enc-file), wouldn*t it be nice to have the same function in FME server? Will we see it soon?

Hello, Can someone explain to me why is JSONFragmenter returning json_type = object instead of json_polygon? And how to adjust anything to get valid json_polygon? Parameters of JSONFragmenter: JSONFragmenter returns: Usually for this kind of JSON data I get (with correct geometry): JSON data for correct return is given as attachment, as well as the incorect one.  

I am renaming the Postgres tables inside the SQL executor(Postgres).If the task is successful, I need a success mark or flag from the SQL executor(stored proc).here there are two flags variables in my code ie "done2" and "i"But the initiator only comes out, nothing comes from the output port. I need one feature from Result port 1 for success or 0 for failure.Can Anyone help me?CREATE OR REPLACE FUNCTION func1()  RETURNS integer AS$BODY$DECLARE   cntold INTEGER := 0 ;    cntcur INTEGER := 0;   i INTEGER := 0;   BEGIN        SELECT INTO cntold count(*) FROM @Value(table_name_old) limit 10;        SELECT INTO cntcur count(*) FROM @Value(table_name) limit 10;        --SELECT INTO cntnew count(*) FROM @Value(table_name_new) limit 10;        IF cntold > 0 and cntcur > 0 THEN            EXECUTE 'DROP TABLE @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name) RENAME TO @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name_new) RENAME TO @Value(

Hello there, So I have bunch of points and lines in my database. For the final output, I would like to extract the points/line (possibly the name) that cannot fullfill the following criteria. 1) The points MUST touch the lines, but it can have a tolerance of 1m to the closest lines.2) The starting and ending of the lines MUST have points.  So the sample shows that points 1-6 are correct, while the points 7-9 and the line below (C) are not correct. It is because the line C does not have the starting and ending points. Also, the points 7-9 do not contain lines within 1m buffer.Might I ask what kind of transformers I can use? I am not very good at FME and hopefully someone can give me a hand.Thank you very much. Zach

Hello #FMECommunity!Here is the news about FME for the week ending 22nd October. Community Activities: Random Acts of TransformationSo during our Community Webinar yesterday (depending on where you are and what your 'yesterday' is) Dale and I tried our hand at Random Acts of Transformation (RAOT) which is where we pick a transformer at random and try to explain it in as much detail as we can, with some lesser-known tips and tricks. Fate dealt us an XML-based transformer as our first go, which was a bit rocky, but then we gave a good description of the FeatureMerger transformer and that was a lot better. You can find just that section of the webinar on YouTube, where I hope to post more of these in the future. Community Activities: GeoguessrWe're nearing the end of the Geoguessr subscription (about 7-10 days remaining) and many users are having fun with this:  We still have a few open spots if you want to play, so let me know. Community Activities: Postcard ExchangeSo while

Hi all, Can someone tell me what the fme.uuid file is for when activating a Floating License and what the content means? Kind Regards, Krien Guijt

Hi again, I would like to change my string containing "100000,00" to "100 000,00E". In other words, adding a space and an E in the string. I can not seem to find an easy solution for this. Thanks in advance!

HI. I have one point layer that contains residential locations. The second layer contains the location of fast food outlets. I want to create a distance weighted count of nearby fast food outlets such that:outlets nearer than 500 metres away get a weight of 1 outlets more than 2000 metres away get a weight of 0those between 500 and 200 metres get a weight of 500/distance Could anyone tell me if this is this possible in FME please?

I have an excel spreadsheet where the attribute name changes based on a formula, every time we fill in an X in line 2 the attribute has the same name, but the number can change to 1,2,3 and 4. I created a reading dynamic, but when for example the COD_STREET = 0 in the dynamic FME reader keeps showing COD_GATE = 4 in one of the attributes, what am I doing wrong? attachment follows the spreadsheet

Hello, I want to write features in postgreSQL. Because of a bad type of a table column some features are not written. Alert message for one of them :210 Value of attribute 'idrlt' could not be converted to type 'int4'. Feature will be logged and skippedI want them to be logged BUT written too (not skipped). Is it possible ? Thank you

Hi,  Is it possible to connect a coordinate with a street using for example NeighborFinder and generate several hits for one street if there are several coordinates close to the street? For example, if there are 5 coffee shops close to Arbitrarystreet, I want it to say that there are 5 coffee shops nearby and not just that there is a coffee shop nearby. Thanks!

Hi FME'ers,Apologies for the lack of What's Up Wednesday last week. Both Liz and I were out of the office. Anyway, let's dive into FME news for this week. Upcoming WebinarsIt's been a while since I listed upcoming webinars, so here are a few.   The most important to me is Build Your FME Community Network, where on October 19th Dale and I will cover some of the changes we're making to this community, and have a go at a couple of community activities. So make sure to join us because it should be both educational and entertaining. Also upcoming is the Masked Revit User on October 27th.  This is where a special guest Revit user will demonstrate real-world examples of what others have made possible by using FME to automate preparing and extracting from Revit. The other webinar I wanted to highlight takes place on 20th October and is about Automation Keys in FME Server. Automations are really powerful items and one of the reasons is the ability to pass information from on

I need the operations to work in the following order:TerminatorDatabaseDeleterData Load (rest of workspace) I tried using a WorkspaceRunner transformer, having split out the three functions. It works fine if I'm in FME, but if I try to run it using a batch file, it errors out. Ultimately, I want to be able to schedule this through Windows Task Scheduler to run nightly. It will compare the last updated date between two datasets, and terminate if the destination dataset is already up-to-date. Otherwise, it will proceed to delete a subset of the destination dataset (a "partial truncate" for lack of a better term), and then re-load the new data.

I am new to FME Desktop and experimenting with downloading a feature from a Map Service hosted on an ESRI ArcGIS server. Is there a way to enable the "return_true_curves=True" when downloading the feature to a local FGDB. I have everything working using a Reader pointed to the map service; however, FME is converting the true curves to simple curves when reading or writing the data. I am able to download the feature using a query and the ArcGIS REST API in python to get a feature with two point curves to a FGDB. Would like to do this directly in FME.

Hi how to avoid to repeat 3 days of data read after a translation failed? Seems the temporary folder run out of space. Can I swap the temporary location and restart the process from certain point instead of starting again from the begin? Alex

This morning all of my FME workbenches failed to open and I get an exception breakpoint application error. It says (0x8000000003) occurred in the application at location 0x00007FFAB8D6293. The only option is to terminate the program. Any help would be appreciated. Thank You. 

Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.

I am trying to parse an SLD file (which is XML) and generate a CSV output based on the rules within it. The following is a sample of the SLD structure <?xml version="1.0" encoding="ISO-8859-1"?><StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.opengis.net/sld http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd"> <NamedLayer> <Name>Standard style</Name> <UserStyle> <Title>Line</Title> <Abstract>Line Style</Abstract> <FeatureTypeStyle> <Rule> <Name>Line - 1:0 to 1:4,000</Name> <ogc:Filter> <ogc:PropertyIsEqualTo> <ogc:PropertyName>code</ogc