Authoring

There is a workspace that copies a dataset from a production oracle database to a postgresql database. The postgresql database will be weekly updated with fme-server.What is the fastest way to udate the postgresql database?- check for the differences and write only these to the progressql database - drop and create the table, so you write each time the complete dataset.-or maybe another solution?Thanks,Kind regards Kees

I have two sde databases representing different coordinate systems, both used for managing basemaps in a local coordinate system. I am trying to use a dynamic schema to merge those into a web mercator sde database. everything work fine except it adds what looks like the fme_type as a suffix to the featureclass name. Instead of Building I get Building_polygon.Writer setttings:Feature Class or Table Name: fme_feature_typeGeometry: From Schema DefinitionDynamic Properties box is checked.Schema Sources: set to both source sde database readersSchema Definition Name: Default from Feature Class or Table Name aboveClearly I am missing something... Please help. My only other alternative is a static schema process which I would rather not use. Is there any other information I should provide?Aaron

I am looking for advice on what to set the FME_SERVER_WEB_URL parameter to.In our current install it is set to our internal network address, e.g. http://<networkURL>:80This seems to generally be working fine, but using the FMEServerJobSubmitter is problematic. This requires us to connect to FME Server using the FME_SERVER_WEB_URL, but we can only connect to FME Server using our external URL, e.g. https://<myfmeserver>.com, as there is a security certificate on the server that uses this URL.Should we be using this external URL for FME_SERVER_WEB_URL?Are there any ramifications to changing FME_SERVER_WEB_URL to the external URL?ThanksKeith

I read the following on https://knowledge.safe.com/articles/1211/parallel-processing.html."As of FME2019, the Parallel Processing options have been removed from most transformers and exist only in the custom transformer infrastructure. A separate article exists to explain setting up parallel processing in a custom transformer."Why was this change made? Thanks. 

Does anyone have any experience of using FME to push out data from a Caris Hydrographic Production Database (HPD)? HPD Server utilises Oracle storage, and FME can obviously be connected to an Oracle db. Can this connection be used to read a Caris HPD?  

Has anyone else had issues with feature order in partial runs when there are two parallel streams?  Example a SpatialFilter set to Filters First If I run the entire workspace everything behaves as expected. If I Run From This on the SpatialFilter, all the filters are rejected as `EXTRA_BASE_FEATURE' and all the Candidates fail (due to lack of filters).  

Hi , How can I pass the CRC attributes as a published user parameter (e.g., $(CRC_ATTR))  The purpose is to automate the workspace, without having to re-enter the attributes manually in the CRCCalculator transformer.  FME Desktop 2014 SP3  Thanks, Sami

 I'm new to FME. I have a process that intersects a line buffer from Oracle with a shp stored in local. In the end there is a dissolver to reduce the number of polygons and write it in a shp.The problem is that from Oracle come 11 million records ... and in the dissolver I get an error.My question would be if there would be a way to execute the process in the following way: that I read 500,000 records, process them, write them in the shp, then another 500,000, then others and so on until the end. It could be done?

Are there any tools that can be used to document the contents of a workspace?

I would like my script to keep only one attribute designated by the user in a shape in which it will be renamed. I created the workspace below.   the attribute "ATTRIBUTE" persists in keeping the value 0 while the selected attribute contains 5, 12, 8, 45 .... Where can my mistake be?  Thank you

Is there a transformer that is a cross between an AttributeKeeper/Remover and a Tester? Meaning that I need to dynamically split my data not on attribute values but on the attribute field names, so all of the fields with the suffix '_alias' are routed one direction and all other fields are routed another.Any thoughts on how I can achieve this?

Hi all, I have a geojson file, where I would like to concatenate the some key value pair to one as array. I have tried ListConcatenator however it simple concatenate without creating array. You can see the below my attempt and desired result. Thanks in advance. Output of ListConcatenator{            "type" : "Feature",            "geometry" : {                "type" : "LineString",                "coordinates" : [                    [ 4.3458008766, 50.8345288033 ],                    [ 4.346331954, 50.8348774905 ],                    [ 4.3474423885, 50.8357197041 ]                ]            },            "properties" : {                "osm_id" : "",                "osm_way_id" : "30010739",                "_amenity{0}.amenity" : "hospital",                "_amenity{1}.amenity" : "pharmacy",                "_amenity{2}.amenity" : "drinking_water",

I am trying to create a custom tool to help me do QA better and faster.I have no problem detecting columns with null, empty ... etc but I really struggle to do so with <missing> values in PythonCaller.Thanks for your help in advance.

Hi, I'd like to set up a notification that watches over some web address.When the changes of content occurs, it should notify me via e-mail or something. How can I do that?

Is it possible to use a % symbol in a choice type parameter?e.g. if i wanted the parameter options to be %y%m%d or %d/%m/%Y

I have an IFC conversion to citygml, in which I created spaces in revit and I converted them using the Citygml Room feature. I want to have the information about the volume of these spaces in the final Citygml Room attribute table after the conversion. the volume information is stored in the BaseQuantities.GroosVolume attribute Of IfcSpace.

I have a list which I exploded using the listExploder. The output contains an attribute _element_index. I want to create an attribute with a name composed of the value of _element_index concatenated with another string. When I try to write the name of this new attribute in an AttributeCreator, it seems like the @Value(_element_index) doesn't work as no new attribute is created (the new attribute name doesn't appear as an option in the AttributeExposer).

When reading features from REVIT Reader reader, some attributes like BASEQUANTITIES.GrossFloorArea were not being populated (missing). When reading this IFC in FmeDatainspector, they are not missing.

I'm using AreaGapAndOverlapCleaner to fill in holes created within or on the edge of polygons in a dataset of 1.7 million polygons. This takes some time (12 hours for the whole Workspace although there are other transformers in there). I have wondered about using Group By in AreaGapAndOverlapCleaner but I don't know whether this would mean that gaps between polygons in different groups would be cleaned or not.For example, polygon 1 is in group A and polygon 2 is in group B. If there's a gap between these polygons, and I'm using Group By in AreaGapAndOverlapCleaner, will the gap be filled in?This is on my to do list of experiments but if anyone knows the answer straight away, please let me know :-)BTW "AreaGapAndOverlapCleaner" is not available as a topic to tag this post with...

Hello,I would like to pass date/time user parameter (Date Ranges) to a SQL-Non Spatial reader where clause. I have tried the following with no success.[wo_complete_dt]>= {ts $(DateRangeStart)} AND [wo_complete_dt]< {ts $(DateRangeEnd)}[wo_complete_dt]>= {ts ‘$(DateRangeStart)’} AND [wo_complete_dt]< {ts ‘$(DateRangeEnd)’}[wo_complete_dt]>= '$(DateRangeStart)' AND [wo_complete_dt]<'$(DateRangeEnd)'[wo_complete_dt]>= $(DateRangeStart) AND [wo_complete_dt]< $(DateRangeEnd)However, if I change the user parameter to a text type or input the dates directly into the Where clause as shown here it does work. [wo_complete_dt]>={ts '2019-06-09 00:00:00'} AND [wo_complete_dt]<{ts '2019-06-16 00:00:00'} Can someone please guide me?Using FME Desktop 2019. Thanks in advance,Keith

Hi, I have a workspace which looks at all files in a location (using a "Directory and File Pathnames" reader), picks the file that I want (using a tester), reads the attributes with a feature reader and writes it to a database. This works fine when I run this workbench in desktop. When I publish the workspace to FME server it requires the user to fill in the Source Dataset. This workbench is triggered by another one, so it fails at this step. Is there a way to use an attribute as the default source dataset on FME Server?Thanks in advance 

I want to merge features by attribute that contains string from target attribute. FeatureMerger does job done but only in case where attribute(req) = attribute(sup). In my case i want to expression to loke like this attribute(req) CONTAINS attribute(sup).

I have a gdb featurewriter that passes through to a shp featurewriter. For attributes with names at the 10 character limit, the shp writer is using their _alias field to populate instead of the correct one.Example: ASSETCLASS field is being filled with 'Asset Class', instead of 'Rail'.Is there a way around this besides adding in and attribute removed for each of the Feature Types?

Hi, I am new to FME and i need to build a model that does the following thing: 1. Select all Address Points that are inside an Area Polygon type= OSA by a given Id. 2. Filter out all addresses that are Allocation Status = No Build.3. Output should be the sum of the "Location Id" field of all addresses points that are "No Build" per polygons id..I need to create out put in excel format.

I'm looking for a way to execute a workbench from a python script. I came across a sample py code from the fme knowledge center and I tried it (see py code below). It first gave me a win 32 error. My python is 32 bit. So, I downloaded python 64 bit, but still can't access the fmeobjects. see error message below. The fmeobjects does exist in the path below. What am I missing? How to execute a fme workbench from python?  ........error message running the py script.....  import fmeobjectsImportError: DLL load failed: The specified procedure could not be found. .......... py code...........import syssys.path.append(r"C:\\Program Files\\FME\\fmeobjects\\python27")import fmeobjects# initiate FMEWorkspaceRunner Classrunner = fmeobjects.FMEWorkspaceRunner()# Full path to Workspace, example comes from the FME 2014 Training Full Datasetworkspace = &#39