Data

Hello all, Last week we have upgraded FME Server from version 2018.something to version 2020.0.2. Initially everything seemed to be running smooth: scheduled jobs are run on schedule, and can be run manually as needed. But today I ran into a problem: it proved impossible to run a workspace manually from 'Run Workspace'. All I got was an error message: 'There was an error submitting the job.'.Delving into the logging, at last I found something in log file <server_name>_jobsubmitterservice.log: (located in Resources > Logs > service >current): the job was submitted as user guest, and this user was disabled.After enabling the user, I tried to rerun the workspace. THis gave me the same error message, but the log file provided new information: user guest lacked proper permissions.So I turned to the FME Server Documentation, where I learned that a user needs to have 'Run permission on the applicable repository'. As users (can) get their permissions from

Hi, I have a huge dataset sitting in a table in PostGIS, there are loads of duplicate geometries that I would like to identify and hopefully remove. I am trying to see if there is a faster way than doing a geometry match. Is it possible to create a hash of a polygon so that I could compare that? I can see its possible for point but not polygon data in PostGIS. In there anything FME can bring to the party?Thank you

Hi, I am working with an ifc extension file containing 11 floors. I worked with separate workspaces for each floor and created their topology. I want to calculate the shortest path in the building. For this, I have to combine the topology of each floor with stairs, how can I do this?Since the nodes created for topology slowed down the system, I had to work on each floor separately.

I have a shp-file containing Picture frames with attributes showing the name of the frame. I want to use this shp-file to select the correct raster images for the TIFF-reader. There are so many that it would take me some time to select the right ones... Fme_basename, the name of the TIFF-Picture in my folder photoID, corresponding name of the Picture in a subset of Pictures that I want to select for the reader

Is their any reader in fme available to read data from getech and convert into fgdb??

Hello,I'm looking for some help running a DXF to KML. I've not done this type of conversion before and wondered if there is anything else that should be added to the process?I'm currently running it on a generating workspace and a dynamic schema to write. The DXF contains:Point, poly, line, annotation and the coordinate system should be WGS 1984 UTM Zone 29NAny help appreciated.Thanks

Hello there we have this type of structure in our data Attvaluecity1ph1,ph2,ph3 and we want to get this structureattvaluecity1ph1city1ph2city1ph3 Any idea, please Thank you

Dear FME CommunityI have 70 different species datasets - Species 1, Species 2, Species 3, ..., Species 70. Each dataset is stored in ArcGIS Online. I want to write each dataset to Shapefile. I am trying to create a reader / parameter that will enable me to pick a single species to write to shapefile when I run the FME script. Can anyone assist please?The ArcGIS Online reader requires the following parameters for each species:Feature Service : MyFolder/Species 1/Species 1_WFLLayer: Species_1Regards, Damian 

I'm running a process to generate around 1500 separate DEM's. Seems without incorporating break lines this process will complete, however incorporating break lines for the extents of the models has resulted in FME breaking the process about 1/10th the way through the series of groups with the following error message: get_next_capacity, allocator's max size reached I couldn't find anything with this error. The group by is set to blocking to ensure all features are loaded into the Generator, Both contours and spot heights are filtered to ensure groupings meet the minimum requirement to generate the model and carry the same group ID, as do the break line polygons (as these are also used later to crop the DEM). Any advice would be gratefully received . CheersChris

We are running into this issue https://knowledge.safe.com/questions/71601/mysql-database-connection-error.html and don't know if this is representative of what we should expect.

Hi Guys,i have a block on Layer 0 which includes also another block which is called Heizhaus.... i explode the block and Use block feature type for components so that i have them in the original layer in the Output: i also use a template filethat are the Basics:so at the end of my workflow (rot 1) the text is in the right Rotation and everything is fine ...but when i write it to the ACAD File teh text gets a Rotation which is false and i don't know where this Rotation Comes from. (rot 2)i have tried to write in the real dwg writer….. i have tried to fill certain Attributes like AutoCAD_rotation, fme_rotation, AutoCAD_text_rotation.. i have tried to read the Output DWG and set a new rotation and no Logical number (e.g plus 180, 360 Degrees or something like that)Nothing happens...Always the same false rotationAny ideas or helpsGreetzFranco   

At the moment, the FME script extracts a dataset from ArcOnline and creates a new document with a filename of the previously edited date. Now, I want to have the data imported into Google Drive using a GoogleDriveConnector. However, when doing so, it creates multiple copies of the same document in the drive. Furthermore, when using a Creator instead of an excel reader, I am greeted with this line: Features not written - verify feature type fanout/dynamic settings. I was wondeirng if anyone could help me with this issue. Thanks!   

I writter from oracle 9i reader to oracle geodatabase 18c by fme desktop 2018 it comes error running translate as file attache

I have IFC file exported from Revit with All the detail as required for lod 0 to lod 4 citygml, i want to extract lod 0 to lod 2 from IFC using bounding box, I can do that via IFC spaces, but thats not good for me, i have bounding box detail in my IFC as you can check in screen shot. What is the best method of Automatic bounding box extractor from IFC .

Hi there, With all the pandemic story, my organization is accelerating the migration to Microsoft Teams. They are asking us to migrate almost everything to SharePoint / OneDrive. I would like to know if there would be a way that I can edit my FMW directly from SharePoint. Right now I have to download my FMW, edit and repush it to SharePoint. It's kinda ennoying. Do you have any suggestions? I'Ve read this below but nothing about editing workspaces.https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/sharepoint/sharepoint.htm Thanks!

Hi, See my data below, I have lines that are grouped by countries, but each country has a rows that starts on April 1, but there is no rows in the last few days. You want to double the missing days, take the parameter from the previous day and fill in the missing data automatically, until the last day of May.Can you help me with that? Input data: Current: Expected:  Thank´s Sorato

Hello, I would like to use a wildcard within a conditonal statement. But I don't know if this is possible.  For example, I have the following records:MeldingFor object(s) 001, 002 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. For object(s) 001 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. For object(s) 002, 004 the date dd-mm-yyyy is later than de original date dd-mm-yyyy. I would like to use a conditional statement that gives me recors 1 and 3. So in this case it will become: Instead, I would like to use a wildcard, so that I only need one test clause. Because in my dataset a lot more combinations are possible. Is it possible to use a wildcard so that the test clause can become like this? (I know that % doesn't work, but I use it here to give an idea what I would like to accomplish).  Thanks in advance,Eva

The meshes in the generated GLTF file is split into multiple meshes, and nodes' name does not have the information of globalID

Hello everyone, I need urgent help with my workspace for converting Sketchup to Citygml. Some posts among the forum say that FME wouldn't support the creation of XLinks. Therefore I created my workbench according to this old "How to write Citygml in FME"-Tutorial and used gml_id and gml_parent_id to express the part-whole-relationships. Now I found that if I use the Citygml_feature_types.xml file within the program folder to import the Writer Type, the autocomplete function provides a list attribute called citygml_bounded_by{}.xlink_href. I tried it out and indeed it created XLinks for the gml_ids I gave to it, but how can I manage to create a Solid with only XLinks referencing the BoundarySurfaces? With my current workspace it creates the geometries for the BoundarySurfaces twice + XLinks once.  I hope you guys can help me -- many thanks in advance. I can also provide sample files to clearify my problem. Kind regards, Philip

Hello, Really dumb question: can do I use FME workbench to create a new folder, ideally with todays date?Will the filecopy mover just create the folder if it doesn't exist? CheersN

Hello,I have troubles with the creation of IfcTesselatedItem.When I create an IfcBuildingStorey object in a FME Workbench (v. 2020)automatically IfcProject, IfcSite, IfcBuilding and IfcBuildingStorey are created in the ifc file: Otherwise, if I create a IfcTesselatedItemonly IfcProject is created: How it's possible to create IfcTesselatedItem objects with FME?Thanks for all suggestions and help

When reading NMEA log ( ) using the flow pictured below, some of the lines have an erroneous timestamp.Using FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64), GPSBabel 1.6.0.Is there something i'm overlooking? 

Hello there, Hope you are doing well and safe. I am trying to connect to a SharePoint list but I did not have any success with FME 2018, so upgraded to 2020. However, still, I am getting errors. Could you please advise. Many thanksMohsen AADSTS70011: The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is not valid. The scope https://[TENANT].sharepoint.com/.default offline_access is not valid. The scope format is invalid. Scope must be in a valid URI form <https://example/scope> or a valid Guid <guid/scope>. Please see the screenshots.   

Hello Everyone, I have a question how to copy row data, but cant seem to find an efficient way to do it yet. Below, attached is a Screenshot of the Original Excel file. The idea is to take a cell value (in this case the 0.10 in the blue field at the top) and copy it for all empty column values until it reached the next filled value (0.20), which will then be copied downwards in the column.  So your result will look like this.  I assume with something like: If CellValue Col x Value is EmptyThen Copy Col x - 1 Value to Col X  Continue to Col x + 1 and loop Something along those lines.Has someone dealt with this before? CheersFred

Hi team,I was wondering if there was a timeframe to resolve: FMESERVER-14602?I have a number of large number of work spaces which use the Database Connection, whilst this works with Schedules I can work around using that, but would prefer to use Automations as the tags and search functionality is a lot easier to use. Also, are Automations primed to take over from Schedules in the future (i.e. if we're building something new, should we be looking to build workspaces within that space?)