Authoring

I have tried and failed and tried and failed. Any help is extremely appreciated in advance! I have column1 containing reference numbers (with duplicates) and I have column2 containing dates (and blanks). I want to create column3 and return yes/no values for all the reference numbers, depending if all ooccurrences of each reference number contains a populated date field. e.g:input:RefDate101/01/2019101/01/2019 201/01/2019 201/01/2019 2 301/01/2019 3 401/01/2019 401/01/2019  Output:RefDateNewField101/01/2019 Yes101/01/2019 Yes201/01/2019 No201/01/2019 No2 No301/01/2019 No3 No401/01/2019 Yes401/01/2019 Yes Thanks,Sideshow 

Hello,i would like to aks you, if you could help me with downloading data from website. i would like to download from this website: http://www.meteo.si/uploads/meteo/app/inca/?par=si0zm. if you open the link, you can see the red frame, in case of rain or snow in this frame shows precipitation with different colors. i would like to download frame and precipitation. i do not now how to download this. i hope you can help me.  

I'm trying to get a webhook up and running so that Microsoft Graph can write straight to a topic on one of my FME Cloud instances. I'm using the following: Go to https://developer.microsoft.com/graph/graph-explorer/, do a POST-request to https://graph.microsoft.com/v1.0/subscriptions using the following body:{   "changeType": "created,updated",   "notificationUrl": "the-topic-url from Message as Subscriber Content",   "resource": "me/mailFolders('Inbox')/messages",   "expirationDateTime":"2019-02-15T18:23:45.9356913Z",   "fmetoken":"token-goes-here"} However, I get the following response: {    "error": {        "code": "InvalidRequest",        "message": "Subscription validation request failed. Must respond with 200 OK to this request.",        "innerError": {            "request-id": "5b842b2b-6325-444e-890e-f9ff6eb61510",            "date": "2019-02-14T13:09:40"        }    }} Using Postman, I've verified that I get a 202-response if I make a POST-request to the topic URL. Is there a

Hello, When setting the Feature Class or Table Name field in an ArcSDE Feature Type writer as a parameter, e.g. $(str_table_prefix)_ALLI get the following error:Geodatabase Writer: Feature Class or Table 'OLDNAME_ALL' must exist when Table Handling is set to 'Truncate Existing'Looking at the FMW file in Notepad, I notice that when I put a formula in the Feature Class or Table Name field, there are still a ton of references to the old value. If I put just a parameter (i.e. remove the _ALL suffix), the same thing happens. If I put just a plain string in this field, all of the old references are updated to the new string value. If Table Handling is set to Create if Needed, the workflow runs, the expected table is created, and the data flows into it. But setting it to Truncate Existing will cause an error when running, if the table OLDNAME_ALL does not exist. If it does exist, then FME will truncate OLDNAME_ALL and then flow the data into NEWNAME_ALL. What? FME ESRI Edition (v2018.0.0.3)

Hello, Today I wanted to experiment a bit. I used WorkspaceRunner with "wait for end" option set to no.  It worked quite well for some time, I had few hundreds of featured to be processed using this, but after some time it all slowed down and then stopped. Then I stopped job in fme workbench and tried to run it again. There was information that I dont have enough licenses.I saw that problem before so I thought that it would be enough only to open task manager end kill some fme.exe processes but there were none. Then I opened powershell and entered get-process command Here there are.  When I try to kill any of those processes it doesnt work, still list is the same Do you know that problem? I hope that there are better ways for solving that then computer reboot :) 

Hi,I use a FeatureReader with the Format "Esri Geodatabse (ArcSDE Geodb).I linked the "WHERE Clause" constraint to an attribute.Then when I checked the parameters of the FeatureReader transformer in the Navigator window, I saw a parameter named "GEODATABASE_SDE WHERE Clause".I would like to know the difference between the "WHERE Clause" parameter and the "GEODATABASE_SDE WHERE Clause" parameter.ThanksValerie

I struggle to find the link for the FMEAR including the Airplane from previous World Tour? Anyone have it or know where to look? Thx

I have simple workspace routine that imports data collated from ArcGIS Survey123 (AGOL) and updates to a SQL server table that needs to run on a daily basis. Can this be done with a batch file (.bat) and scheduled with windows task scheduler?

I have a Microstation v8 file that has 60 odd levels from which I have to filter out 20 and further filter those 20 levels to based on the color of the features. One level has features that go on two different output levels. I am using an Attributefilter to filter them out based on their color value, then use several FeatureCreators to write out the features with the destination color, weight to the destination levels. When I look at the log it shows that features were created for two destination levels, but when I open the dgn file I see no features on one of the destination levels. All output features will be written on a single level. Any idea why?

@david_r @DanAtSafe I've created a simple workspace to download a file from FTP every morning. When I run the workspace in FME -> everything works.When I run the FME workspace from the command line -> everything works.When I run the batch file that I created, which points to the FME workspace -> everything works.When I create a task in Windows Task Scheduler to run the batch file that I created, which points to the FME workspace -> Task Scheduler says it completes successfully, but no files are downloaded or saved.Additionally, I added a function (at the end of the batch file that launches the FME workspace), in order to create a simple log file called "batch_log.txt":C:\apps\FME_18440_x64\fme.exe "J:\workspace.fmw" echo "this works" > C:\apps\Scratch\batch_log.txtWhen I run the batch file from the CMD prompt successfully (not Task Scheduler), the log file contains this:FME 2018.1.0.0 Beta (20180319 - Build 18440 - WIN64)FME ESRI Edition (node locked-crc)Permanent Licens

Hi,Does anybody have any experience with FME and SQLBase?FME doenst support it, but can an ODBC connection can be made?Thanks,Itay

To simplify this issue, my short term goal is to build a simple module which checks each attribute from a transformer or reader and returns the percentage of nulls for each attribute (vs the total number of records).  for instance something like:  Input: Attribute1Attribute2Attribute3Attribute4...... Output: Attribute1Attribute1-null-countAttribute2Attribute2-null-countAttribute3Attribute3-null-count......or something like that...  Again, to clarify, we DO NOT KNOW the Attribute names nor how many attributes there will be. Ideally, I would build a Custom Transformer, which accepts an unknown number of attributes and performs this calculation / process. However, Custom Transformers require that the inputs attributes are static.  From all the research Ive done I cannot figure out any way to make this happen.  I thought about a transformer that takes all attributes and combines them into one then they could be broken apart after but nothing seems to exist. I am open to any suggestions eve

Hi,I have many tables in SQL Server under the 'dbo' schema that I would like to replicate to PostGIS under an 'sde' schema. I would like to do this using the dynamic schema functonality. How can I replace the dbo with sde in the fme_feature_type attribute while still bing able to associate the matching schema for the tables using the dynamic writer.Thank youOliver Please forgive the use of schema term - schema in sql server means something different to schema in FME.

I am 2 feature reader in My WS , to read a PostGIS DB , we update the data in post GIS but when we inspect the featured reader it still sees the old data.we did a test in a new workspace and its working fine.is there any setting we need to handle Thanks

Hi.I like to have most of the essential translation parameters as published. This typically includes the database server name and the database name when working with (MS/SQL) databases.But when I press the "..." next to the current value to choose another, I get an unexpected error, stating that I gave an "Invalid authorization specification", even though I've set it to "Windows Authentication" originally, which worked then.I cannot specify any other "authentification", so I'm left with having to write the database name manually. Not cool, and not very productive. And I cannot change the parameter into a choice list either.Is there another way to get this to work ?Cheers

Hi FME Experts, I have F.C and we received new data for the same F.C it contains 3 types of update:- update on the attribute level.- Update on the geometry level.- Add new data.I am trying the insert the new data into the main destination, I tried the update\\insert feature operation with truncate data but it does not work.there is a way to do this?

Just trying to make a variable input parameter with a Slider in FME 2017 (Build 17271) and it's not on the list of the Parameter types.Anyone knows where is it gone and how to create one?

Hi community,We run into the problems that certain jobs on FME Server fail become the underlying database can not be reached (temporarily). We are looking into the causes of this. In the meantime I am looking for a way to automatically resubmit the failed jobs after a certain time, e.g. retry after 30 minutes and perhaps retry a couple of times, rather than having to manually resubmit the failed jobs by the FME Server administrator.Is there a way to do this?Thanks,Joep Luijten 

I have reviewed the workbench provided in this link(https://knowledge.safe.com/articles/73933/converting-arcgis-indoors-data-to-imdf.html?childToView=86665#comment-86665). Are there any additional steps that need to be taken for generating the imdf? The workbench was able to read openings but none of the other gdb features were getting read.

Hi there,I have some data where one column is only sparsely filled, and I want to fill these missing ones based on another present attribute. Here's a basic representation:ClassTypeMammalDog DogFishTrout Trout TroutReptileLizard Lizard What I need to do is fill in all the empty "Class" lines based on the "Type". In the data, each Type will always have at least one entry in Class (aka, no Type will ever be classless), and no Type will have more than one class.So in short, my current data may have 3 entries with "Trout" and only one of those specify the class as "Fish". What I want is to derive the info from that one Type entry, and fill in all the blank Class lines.  Thanks in advance for any tips! Best regards,

Hi,I would like to use a python caller to compare the files (and their size) that are located between two folders.  My idea will be to used a python caller that will give me the list of the filenames for each folder and then used a Featuremerger to compare the two lists of files name by name and size by size.Any ideas?Arthy  

I have a workspace that produces statistics from some survey data and then writes a finished report as a Microsoft Word document. However I am having some issues.Firstly, there seem to be FME system attributes being passed through to the final report. Namely, "fme_feature_type" and "fme_type" (see image 1 - highlighted rows). These aren't selected in either the writer or reader Format Attributes tab, and I have tried a number of ways of removing them including using Attribute Managers, Removers, Keepers & Testers. The problem is they aren't showing up at any stage of the workflow, except in the final output report.  IMG 1 Secondly, I am having trouble with ordering data within a table as required. I pass the relevant attributes through to an Attribute Manager, sort them as I need (image 2), and then pass them to a MS Word Styler and a MS Word writer. However, they are then sorted differently in the final report (image 1). I can't work out how to sort

Hi,I use a FME Server 2016 to run different workbenches. For the update on FME Server 2018 I have to upgrade these workbenches, too. In one workbench I use the custom transformer LineDivider from Takashi Iijima.After the upgrade I have the problem, that the output of the upgrades workbench is less than the output of the old workbench.old outputnew outputEspecially the PythonCaller has an other output. But the old and the new workbench should have the same size.Has somebody an idea which parts of the PythonCaller has changed? Thanks and best regards 

Hi, I wish to segment a line geometry at the buffer extent. I.e. The buffer centroid is an intersection of lines, and I wish to segment all connecting lines, so that they all have the same length around this node. Thank you for your help, I am a beginner at FME.

I need to compare file sizes and other attributes for a PRE upgrade and POST upgrade output files. O would like to get the list of files from both folders and compare the sizes, names and type. I am new to python and really need help writing a python script.