General

I have two oracle recordset(output of sql executors).let me say recordset A has two column segment_id and cable_idand one more recordset B has segment_id and Previous_segment_id record set ASEGMENT_ID | CABLE_ID21 | 0111 | 053 | 068 | 11 | 0 Recors set BSEGMENT_ID | PREVIOUS_SEGMENT_ID21 | 111111 | 5353 | 6868 | 11 | 9Function needed here is... if the set cable_id of segment_id is 0(zero), thenI need to loop thru Second set B by fetching previous Ids.(i pasted image below) in the example for the segment_id 21, cable id is 0, so i have to move forward by taking its previous id(PREVIOUS ID IS IN SET B)which is 111, but for for 111 again cable id is zero(in the record set A), so kepp on loopinguntil i get 68( because for 68 c

I have excel file where empty Cells but have space on cells so when i transfer from excel to SQL so row are not Null so there is any way to remove space from cells in FME ??

Hi,I don't really know how to solve my current issue.ContextI have data as follow :IDCIS1CIS2CIS3TPS1TPS2TPS30001AMACHLLOR780102414200002LIVAMARBN681702895..................  The TPS columns are times in seconds. I need to add a delay to these times regarding the corresponding CISX value (e.g. add 1000 when CIS is 'AMA', add 1500 when CIS is LOR...).Then I need to sort the values to get the quicker CIS regarding to the TPS time with the delay added.IdeasTo do that I think that putting all my CIS and TPS in a list with two attributes can help me, but I can't find how to do it.What I think I need to have as a first result (to start manipulating my data) :ID0001List{0}.CISAMAList{0}.TPS780List{1}.CISCHLList{1}.TPS1024List{2}.CISLORList{2}.TPS1420 I tried with the ListPopulator, it works fine if I give it CIS as prefix I get my list but of the CIS only.I can put two ListPopulator, one with CIS as prefix then one with TPS as prefix, but I get two different lists.How can I cr

Hello ! To test the new 2019 RasterObjectDetector feature, I wanted to benchmark the tool with my own dataset, and therefore, making my own annotations.As explained in this post, I wanted to run the "opencv_annotation.exe" tool. However, even after carefully checking the command line, I still get some errors of missing dll's (see screenshot below), particularly those :MF.dllMFPlat.DLLMFReadWrite.dll  Is there any required decencies that I missed to install ? Thanks !@dmitribagh

Below I have included the python code I added to the startup script, how do I include the zip file module if possible?import osimport zipifle def convert_to_zip(path):for root, dirs, files in os.walk(path):for filename in files:if filename.endswith('.ghg'):# print rootoldname = os.path.join(root, filename)newname = oldname + ".zip"os.rename(oldname, newname) def convert_to_zip(path, extract_path):for root, dirs, files in os.walk(path):for filename in files:if filename.endswith('.zip'):# print rootzf = ZipFile(path, 'r')zf.extractall(extract_path)zf.close()  convert_to_zip("")

Howdy Everyone,I'm playing around with the fmear format and I was hoping to garner some advice. I have a georeferenced feature class of a building, it is just lines and polygons. I set an extruder on each feature and wrote it to fmear, not very complex at all. When I try to see the model in AR, I see its loading x of x layers succesfully but my phone keeps scanning for ground. What I mean by that is, I have a perfect floor and the mesh is not red but I just keep scanning like I can cover my whole office in the white mesh. I expect the building to pop any second but I just keep adding more scanned mesh. I'm beginning to think my AR is gigantic or something with the scale. Do I have to add any extra transformers to change a feature class of a building into a pocket-sized AR feature? I didn't notice any talk of that in the tutorials. Thank you!

Can anyone tell me what kind of error this is?CSV reader: Detected excess data and/or delimiters in addition to the defined schema in line 3523 with value '3.53,0,3.53,0,0,0,0,3.53,0,0,0,130299203063,258,201903,0,0,0,0,0,0,0,0,0,0,0,0,0,3.5682002,2302,201903,0,0,89.33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,42.3025,-83.40304' read from file 'P:\Office Depot\FME Workflows\Local Update Workflows\Sales by BG by Store\Workspace Runner - 7h\3. Workspace Runner\Outputs\Sales_by_Store_by_BG2.csv'.  Excess data will not be read.  This can occur if the file is not uniform in the number of fields per row or if fields have been intentionally removed from the source feature type.  In order to read the excess data, recreate the source feature type and set a larger value for the 'Maximum Rows to Scan' option to scan additional rows for fields.  If the file contains field names, ensure that the field names line represents all of the columns in data rows, or enable the 'Scan for Additional Fields' option.

I have a parent bench that uses a workspace runner to run a child workbench several times using different source shapefiles. The parent and child workbench's run with no errors but when I check the file directory the child bench has not written anything!This is reflected in the child workbench log which states that the expected number of features have been read but non have been written.Does anyone know why this is happening? The child bench runs fine and writes as expected when run manually.

Hi Team,I worked to create the annotions.txt ( https://www.safe.com/blog/2019/01/fme-does-computer-vision/ ) , but when I used the transformer RasterObjectDetectorSamplePreparer - I didnt't success.i received the error information on Data Inspector: fme_rejection_message (encoded: UTF-8): Internal OpenCV Error has occured: b'Unable to open image: C:\\Solutial\\ML_Lixeiras\\ML_Detector\\C:/Solutial/ML_Lixeiras/Positive/Novas\\1.jpg\r\nOpenCV: terminate handler is called! The last OpenCV error is:\r\nOpenCV(3.4.3) Error: Assertion failed (0 <= roi.x && 0 <= roi.width && roi.x + roi.width <= m.cols && 0 <= roi.y && 0 <= roi.height && roi.y + roi.height <= m.rows) in cv::Mat::Mat, file c:\\build\\3_4_winpack-build-win64-vc15\\opencv\\modules\\core\\src\\matrix.cpp, line 465\r\n'My configuration: Version: FME(R) 2019.0.1.0 (20190506 - Build 19253 - WIN64) @dmitribaghThanks,Danilo

Hi, I have an attribute WKT_coordinates that I use to create a geometry with WKT format.My problem is all the numbers in this attribute are too big by 100.I am looking for a simple way to divide them all by 100. Example of string in WKT_coordinates :((86530120 638698160,86530140 638700660,86526150 638712680,86512380 638737780,86510880 638737790,86507360 638734820,86530120 638698160))I would like to have((865301.20 6386981.60,865301.40 6387006.60,865261.50 6387126.80,865123.80 6387377.80,865108.80 6387377.90,865073.60 6387348.20,865301.20 6386981.60)) I can have geometries with multiple parts too :((100 100,200 100,200 200,100 200,100 100),(125 125,175 125,175 175,125 175,125 125))and want :((1.00 1.00,2.00 1.00,2.00 2.00,1.00 2.00,1.00 1.00),(1.25 1.25,1.75 1.25,1.75 1.75,1.25 1.75,1.25 1.25)) Any idea ?

Hi ALLI have created straightline diagram and can be viewed in FME Inspector. I also write into ACAD but I find that the ACAD output not as pretty as showing FME Inspector.Is there a way to save the graphic from FME Inspector or export same format as it shown to a file? Regards 

Hi FME Experts,Can anyone assist me in this issue?I am trying to extract the Max value from a field then use it in calculating the value for another field (sequence), but I want an automated way to calculate it since the client does not familiar with the FME  Thanks in advance! 

Hi FME Experts, I would like to add a specific value (03) start of the attribute to make the attribute digits 4. EX:origin value new value 78 03785 0035....... Thanks in advance!

Hi, is there any template to read IEC CIM/XML format file?

Hi All,We have a plan to upgrade FME server from 2016 to 2019. Do I need to also upgrade workbench from 216 to 2019? or this is only optional, and If I don't upgrade the workbench will there be any issues related to compatibility of versions between workbench and FME server?There are more than 75+ workbenches and it will require 1000 of Transformer/reader/writer to be upgraded and tested. What is the best practice in above case?Please share your thoughts , suggestion and experience. ThanksZubair 

Hello all, I have 2,450 ESRI ArcGIS Binary grids, and I want to convert all of them to ESRI Ascii Grids. That is; one binary grid becomes one ascii grid.I am trying and failing to use Workspace Runner to do this process.I have successfully made a workbench to convert one binary grid to an ascii grid.But I have failed to configure the Workspace Runner to run the first workbench

I want to read features from a WFS service version 1.0 , which has a limitation of maximum 10000 features per call .How to split my bounding box , when reaching the max number? It should loop the reading, unti I get all my features.

Destination Feature Type Routing Correlator(RoutingFactory): JSON Writer: Cannot create dataset: 'C:\\conversions\\183d5013e531487c96a18afef4527d48\\2549_6672.json' of type Directory, expected a dataset of type Regular file.Why im getting this error @virtualcitymatt,@markatsafe.im unable to get the output.I have attached the workspace please check it.What is giving me error.

Hi,Iam using FME 2019.0.1.0 (20190506 - Build 19253 - WIN64) and I cant find the Menu bar. It seems the menu bar is hidden as I can click on the location where the menu bar is supposed to be and get the menu options.Since the menu bar is hidden, mouse clicks on the rest of the application have shifted below by few centimetres than where they are displayed.I have tried reinstalling and using different monitors but all with same issue.

Hi,I am new to FME, I am using FME 2019 version.I am trying to smallworld data to google maps. My smallworld data is in Belgium Lambert coordinate system. I have created a new custom coordinate system(by referring Belgium Lambert Meter coordinate system) in FME. I am using this coordinate system in the readerI am exporting in .GPX format.In the writer I am using EPSG:3857 coordinate system for projecting it in google maps.But the data is displaying in arctic circle but not in belgium region.Could someone help me in getting out of this problem.Thanks in Advance.Regards,Raja. 

I am trying to read DWG file using FME 2019. Below is the workflow Create FME SessionCreate ACAD ReaderOpen AutoCAD fileRead Feature and Feature Schema from File (SUCCESS)Close FME Reader and SessionDispose ALL FME ObjectsRepeat steps a) to f), crash observed at step d) when reading Feature Schema When the same workflow is executed for DGN or Microstation file, it works fine.I am attaching the sample code and FME Log files  

Hi,This might be simple but a tricky one for me. Also, I had read a lot about transposing data from rows to columns and vice versa, etc., but couldn't find much about this one.I have data in one column which are column separated.1,2,3 2,3,6 4,6 I want to append all the data one below the other and take the count of which number appeared how many times. I can take the count from Aggregator. 1 2 3 2 3 6 4 6  Approach that I followed: AttributeSplitter(list 0-100(since the values can be too many as well)) to disintegrate the values in different columns. But, that leads to a number of columns and appending all the columns and rows in one column becomes the issue.Any quick solution for this? Thanks!

I have been using FME for some simple tasks but I would like to take it to the next level. I have workbench is a simple conversion from .pbf format and it loads this information into a geodatabase.Next up I would like to have this workbench download an updated pbf file before it starts the conversion.Is there a way to run an HTTPCaller and then automatically read a file that is downloaded from this transformer within a workspace? I am not sure how I would connect the output of the HTTPcaller so that is readable within my workspace.  

I have an XML file (see example attachment) from which I want to delete all Notification elements when the Notification type is 'Change of Circumstances'. So in this case I'd start with 3 Notification elements (New Claim, Change of Circumstances and Claim Termination) and once I've deleted the 'Change of Circumstances' Notification I'd just be left with 2 Notification elements (New Claim and Claim Termination).I'd found this article (https://knowledge.safe.com/questions/77687/deleting-elements-in-xml-file.html) which seems to be what I'm after but I'm struggling to replicate it with my file.I've been using Text File Reader with parameter 'Read Whole File at Once' set to 'Yes' and the XMLUpdater with Delete XML Path (though I'm struggling what syntax I need in the XML Path).For info. I'm using Workbench 2018.1.2Thanks in advance.

Dear FME community,I have an attribute which has many blank spaces in the middle. I want to reduce the amount of blank spaces to only one single space (character). I'm not very fit in regular expression, so I'm hoping somebody can tell me the code for the StringReplacer. Many thanks!Kind regardsThomas