Creating and organizing workspaces. How to use Workbench.
Recently active
Hello all,I have a simple question. Yet I can't find a solution. So I have an AIXM data where contains around 30000 airports. However, I'm interested in 600. How do I filter them? I know there are Tester and Attribute Filter transformers. But couldn't figure out how to create a list of these 600 and filter the matching data.
If I try to open it normally it works until I try to open a workspace, then I get the errorFile Error! Could not open file:If I open it as administrator it works fine, but I am trying to run my scripts by batch file in a scheduled task and while the script works fine run manually from the workbench (in administrator mode), it is not working through the batch file and I believe the two problems might be connected.Can anyone shed any light on this? I am using FME 2018 on Windows Server 2008 R2.Thanks
The previous versions of the FMEServerJobSubmitter returned an attribute upon failure named _job_failure_type. This attribute value is missing in the latest FMEServerJobSubmitter. Is there any replacement for it?
I'm trying to get to the bottom of this non-spatial data issue and am racking my brain to no avail...I have a table of data that looks as follows...IDFacilityCode1A001,D0471D047,P001,G00512D001,D047,F0012F001,G0092P001,A0013G0053G0054A001Notice that the FacilityCode may be duplicated between records for any particular ID. I need my final table to just be a DISTINCT list of IDs with an alphabetized list of unique FacilityCodes, so it should look like this...IDFacilityCode1A001,D047,P001,G0052A001,D001,D047,F001,G009,P0013G0054A001Theoretically, I'm thinking I might be able to use regex to extrapolate the unique FacilityCodes including the comma-separated values for the records with multiple FacilityCodes (with a StringSearcher? Not even sure what my regex would look like), then a ListDuplicateRemover, a ListSorter (to alphabetize), then a ListConcatenator to bring my list back to a single attribute.I'm not even certain that could all work correctly while maintaining a groupi
Is there a reader for Oracle NMS Mp files? It appears this is an option in the Small World license, but can't find any conformation. Does anyone know if or have a transformer that can be installed for this file type? https://knowledge.safe.com/articles/780/working-with-ge-smallworld-databases.html @MarkAtSafe
When I call the function convert I wrote, I get the error "PythonNameError: global name 'convert' is not not defined"
Hi.I've just built a custom Python based transformer, which utilizes two string attribute values.One of the string had some embedded quotes ("), which were stripped before given to the Python code.I tried swapping the quotes with single-quotes, but that crashed the Python execution entirely.Is there really no automatic escaping of the entered values (into the transformer setup dialog) before passing them on ?I managed to get it working by entering \\" (backslash-quote) in place of " (quote), but that's really a bad work-around. FME should really do that automagically by itself.Cheers.
How can I find the feature types of a CityGML file in the command line itself. Is there any command line argument to find the feature type of input file.
I created a generic fmw file to convert x to y.And i'm trying other x format files in cmd but i'm unable to convert since i dont feature types of newly converting files,how can i pass a command in cmd to select all the feature types instead of mentioning the feature type names.generic:cmd line:"C:\\Program Files\\FME\\fme.exe" --SourceDataset_CITYGML "C:\\test\\sample.gml" --FEATURE_TYPES "building roof " --DestDataset_CESIUM3DTIES "C:\\test\\t2"new conversion using the same fmw file:"C:\\Program Files\\FME\\fme.exe" --SourceDataset_CITYGML "C:\\test\\newsample.gml" --FEATURE_TYPES " " --DestDataset_CESIUM3DTIES "C:\\test\\t3"since i dont know the feature types how can i pass feature types is there any command to select all instead of passing feature type names.when i'm running the second command log message was translation is successful but there is no output file.is there any solution for t
Hi There,Apologies in advance if the title is a mess. Not quite sure how to better word this problem I've encountered. Essentially I want to isolate (and discard) and GROUP where any of the entries involved has First off, let me show what my data looks like:TYPEGROUP1A1A1A1B2B1B1C1C1CI'd like to isolate all GROUPS where any of the TYPE values are "2", Like Group "B" in this example. Even if a group has 100 entries and only 1 of them has value 2, that entire group and all its entries needs to be identified.Any ideas on how to easily achieve this?Best regards,
Hello There We have published a workspace as job submitter but when we test it on the postman, I am getting the server response concerning the status of the job, not the result ( we should get a JSON response )the workspace has a text writer
Hi, I asked about comparing the attributes of two datasets which have same attribute table earlier, and @DanAtSafe helped me out. But now I have a lot datasets to compare and they don't have same attribute table, which means every time I have to create a new comparing workbench, that's a lot work and I may miss some attributes or set the wrong parameters. So I'm thinking about creating a custom transformer to iterate coming feature's attributes. I've been looking into help documents about Looping, but it seems that's not possible to get the count of the incoming attribues, not to mention iterate them. ListElementCounter will only come back with the count of the list, not the attributes in the list.Figure1 below is the whole workbench I created based on Dan's method, Figure2 below is the part of workbench with summary annotation, and Figure3 is all the input attributes of a pair of datasets, I want to compare all attributes in the differ{} list.I'm not su
When I installed FME Server, everything seems to be working ok except I can't run any jobs. The web ui has picked up my licence information, but won't display any engines. I checked in the fmeserver.log file and it says: Wed-15-Aug-2018 09:54:44.913 PM ERROR fmeenginemgrnodeclient 402902 : Failed to connect to Job Queue. Please ensure Job Queue is started.Wed-15-Aug-2018 09:54:44.914 PM ERROR fmeenginemgrnodeclient Could not get a resource from the pool I tried running the "C:\Program Files\FMEServer\Clients\utilities\addQueueNode.bat" just in case, but it didn't change anything How can I get the job queue to start?
Greetings all, Does anyone know if it's possible to expose IPTC metadata tags in JPGs (eg photos) using FME ? Specifically I'm trying to expose the Keyword metadata tag which may contain null or an unlimited number of keywords. ............. If this is not currently possible using FME and someone from Safe is reading this, could this functionality pleased be added ? (it's noted that EXIF metadata tags CAN be exposed). Ideally if keywords could be added as a List attribute ie each keyword seperated by a comma (for example) that would be fantastic. ................................... Regards Howard L'
I have a web service that I want to access with FME. How can I do that? There is something about REST and OAUTH and such. help?
Is there any way to convert a file of x format to y format using cmd. I'm able to do it only i when i created fmw file but i wanted to convert it on the fly is that possible?or is there any way to automate the whole process.I'm trying to build a web app which is able to view only x format files only so i want to view also some z format files(which my app cannot load),so i want to use fme to convert z format file to x format with a single click is it possible without opening manually(conversion should happen in backend).Please do comment if you didn't get my question or if you have any solution.
How can i automate the translation process of FME(eg:collada to gltf) using python.Is it possible to automate the entire process of automation.
Hi,I have multiple files with structures (File_YYYY-MM-DD). I want to merge all file the same YYYY-MM-DD into one file. Example: File1_2018-07-01; File2_2018-07-01 merge into File_2018-07-01.And other files make the same.How to the way to make it? Can be use Stringrepacer function? Thank you
I am still getting the error code from the server was '1000' and the message was: 'String or binary data would be truncated, when I try to delete or insert records into AGOL from my Writer. My Reader, Writer and AGOL field sizes all match. I have not changed the data type for any of the values. I am truncating to the field sizes. Not sure how to debug what is erroring off during the write to AGOL.
Is ist poosible to oppress the Cancel-Buttton on the FME-Server for some individual workbenchs?Following problem (with FME Server 2016):A user starts a workbench on FME-Server and is canceling the job.The workbench has an child-process (FMEServerJobsubmitter) with access to an postgis-database.Cancelling the job generated a lock of the postgis-database.How can I force the running till the end? Cancelling the job may not possible!
I have a fancy Python script running in my PythonCaller, but I want to use a "Group By" logic to process my features. I'd rather not have to manually split my features and plop down a PythonCaller for each separate stream. Is there an easy way to do this within the Python script? Or any way??
Hi @takashi, I was using your method of importing an external startup & shutdown python scripts instead of typing them directly into the fme. However, I have a Global variable in the startup python which is used in the shutdown script but the Global variable is not recognised when the startup & shutdown python is imported as external scripts. eg.import sys sys.path.append('D:/Scripts') import StartupPython
Hello we are using the wordsytler along with the word writer how could we write the paragraphs the sequence the should be in ( 1.1 ten 1.2 ,,,etc )