Data

I am attaching a sample db3 file that I am using for a project. This db3 file contains many fields of blob type. The table, field of my interest are as belowTable Name: CURRENT_TAGField Name: _TAGOBJ_SUBSTATIONGIDselect _TAGOBJ_SUBSTATIONGID from CURRENT_TAG where _TAGOBJ_GID = '145242397947723855';This particular record in my application shows this value “151433541765593417”But in db3 file it is actually stored as blob. How do I decode the blob as text? I tried to use online tools to convert this binary to text - it doesn’t work. Also, how do I know the data format that is stored as blob - is it either image, xml, json etc.?

Hello, I am trying to create a workbench that will read in all our add/delete tables from our SDE, do a count on the running total of records for each, and export a spreadsheet with the table name, and the counts in each,I’m using a SQL Creator and my SQL statement is something like SELECT COUNT(*) FROM <tablename>,and right now that's not returning me any value even though it was successful? Also, how would I go about coding out to add the next table in?would it be:SELECT COUNT(*) FROM <tablename>unionSELECT COUNT(*) FROM <tablename2>unionand so forth?also for background:We use Microsoft SQL Studio, and I chose the connection as a spatial server.Thanks for any help!

Hello,I want to generate an incrementation from the max value of a column in order to not have duplicate values. The _max value column is not recovered in the counter for the 50 duplicate features :  Any idea ? Thank you 

Hi, I have a text string that looks something like this…LOT 4-6 DP 287 SEC 2-3 SO 345152 I have a regex “(LOT \d+[\s?&-]\d+ DP \d+ ){1,}”  that grabs the LOT 4-6 DP 287 from the text line.How can I split the 4-6 into separate attributes so I end up with Lot 4 DP 287 Lot 5 DP 287 Lot 6 DP 287I could do it with a testfilter but there are unknown combinations. 1-12, 60-62, 78-82 etcAny help is greatly appreciated.Regards, Paul

Hey. Do you have any idea how to solve the sequential processing of input elements on HorizonAngleCalculator? If I have several elements on the input of the Horizontal Transformer, I need one element to be processed and then the next element to follow after that element is processed. After that, I would put a featureholder after the HorizontalAngleCalculator and it might work. I've tried testing the featureholder with counter and filtering features that have already been processed, but somehow I can't get it to work. Thank you very much

Hi.I have a file of text strings that have multiple ‘parts’ that I have split into a _list. Example text string... LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSEDUsing string searcher, I have formed a list of the formatted string to push into the list using regex: (LOT \d+ DP \d+){1,}The result is a list containing the:appellation:LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED matches: LOT 9 DP 19723  LOT 12 DP 384274  LOT 8 DP 30287  LOT 9 DP 2402  What I want to be able to do is remove the matched part from appellation on the way through leaving me with both the matches as individual features, and a subset of appellation with the matches removed. The resultant appellation in this example would be: PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED I would be very grateful for any help with this.Regards, Paul 

WFS 2.0 services are available on the Geoportal Baden-Württemberg. It is not possible for me to view/download the contents of the objects (BP_Plan) with the WFS Reader using FME 2023.Does anyone have any idea what the problem might be?Example:https://geodienste.komm.one/ows/services/org.165.d5516855-2ef7-4512-92f7-68d208f6f722_wfs/org.165.15f5882e-891a-4ce4-b2fc-000a45978e11?SERVICE=WFS&Request=GetCapabilities

Hi there,I am fairly new to FME. I have around 6000 dwg. files regarding the same industrial drawings and the data is roughly found in the same place in each file. I would like to know how i can extract the attributes that i need out of these files.I have started using a wildcard function to read multiple files. I know this question is fairly vague, still I was wondering if anyone has the time to help me with this, or knows any recomendations for explanation (youtube or similair examples/workspaces) Like I said, FME is still pretty new to me so any advice would help. Thank you

I am making a call to an API and getting a JSON in return. With the JSONFragmenter and it's flattening options, I can expose most of the attributes in the JSON into FME attributes, but I am getting stuck on a particular structure. Sometimes there's a little table within a single attribute in the JSON like so: "related_objects": [                    {                        "relation_name": "verbinding",                        "relation_id": 1,                        "objects": [                            "randomid1",                            "randomid2",                            "randomid3"                        ]                    }                ] This indicates objects that are related in a particular way to the object in my query. I would like to generate a list of all of the related objects (randomid1, randomid2 etc.). I want to use that  list in my FME flow. The number of related objects might be one, or a hundred, in this case it's three.How do I make FME turn that littl

Hi, I have one Form workspace that writes to a hosted feature service on AGOL fine. It is set at insert and Truncate. It writes a little more than 9,000 features and I run it every week without issue. However, I now have a different hosted feature service on AGOL that has +23,000 features. When I try the same process to update it, it drops all the data and only ends up writing out 15,000 records at most. The number of records diffs as well. I have tried adjusting the timeout and features per request, but have not been successful in achieving the full write out. Any suggestions would be appreciated.  

Hey. I need some advice, or at least direction, on how to solve a complex problem. See attachment: I have a track. The track consists of waypoints, the waypoints are minisegments which consist of a startpoint and an endpoint and these minisegments form one big segment and these big segments form one complete track. The direction of the "flow" of the points is determined by the number of startpoints and endpoints, see below, where we see that the only possible direction is from A to E, since it must connect startpoint to endpoint between the minisegments, which form one segment out of three. The waypoints of one of the segments at the level of the points that make up the minisegments look like this - A, F, C, E: Startpoint: AEndpoint: FStartpoint: FEndpoint: CStartpoint: CEndpoint? EThe problem I'm solving is that some segments have this sequence of startpoint and endpoint reversed in the source data, so that the sequence of points of one of the segments would look like this: E, C, F, A

We have tried to export(write) an obj 3D building file to dae / citygml / slpk file formats, and all three of the conversions were successful.However, only the dae format was successfully visualized in a viewer, and citygml/slpk failed to visualize with the viewer that supports the formats.Could you give some advice for this issue?CASE1 - obj to citygml (failed to visualize)input 1784_OBJ.zip output  1784_CityGML.zip output import view capture (KITModelViewer) No geometry information, only attribute information can be verified    CASE2 -  obj to slpk (failed to visualize)input 1784_OBJ.zip output  1784_slpk.zip FME Capture   output import view capture (ArcGIS Pro)  

Hello, I have an IFC file I wish to import in Postgres(PostGIS extension) to go through spatial analysis. Oriinally, what I did was to convert the IFC to a 3DGIS compatible format (GML) and import it in Postgreswhich was successful. Exploring a little more, I saw that Postgres supports the solid geometry type of FME and I performed the same conversion, without converting the geometries to b-rep. This photo shows the input in Postgres and this photo shows the output when I am reading it from Postgres. The highlighted part is visualised differently. I couldn't help but wonder the reason why.Could you please help me figuring this out?Thank you, George 

I’m trying to use the Data Inspector to inspect data in a Pro-generated file geodatabase. I’d get these errors which prevents any dataset from coming in.I’m on ArcGIS Pro 3.1.3. Dialog window:“Failed to open datasetEsri Geodatabase (File Geodb) dataset ########### could not be opened as configured. See log window for details. Remove it from recent dataset list?“Log window:An error occurred while attempting to open the table, feature class or relationship class 'Administrative_Lines'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME. If already installed, set the Esri ArcGIS Compatibility setting for this workspace to 'Esri ArcGIS Pro' under Navigator -> Workspace Parameters -> Translation From FME Form, I

We're using FME Flow 2023.1.2.We have got a Windows Share registered as a custom resource at FME Flow, which is locally accessible as a UNC path. I'm looking for a way to reference the custom resource in such a way that it locally uses the UNC path and at FME Flow automatically uses the resource. I believe I can use Deployment Parameters for that.When I create a Deployment Parameter and use it as part of the path in a FeatureReader, it doesn't recognize the file I'm trying to reach, though I did fill in the local value of the Deployment Parameter.Deployment Parameter Value: $(FMEShare) Deployment Parameter Local Value: \\computername\shared_folder\ Reader Path: $(FMEShare)Subfolder\file.xlsxI tried to create an attribute _pathExcel that is set to the path I tried to fill in in the FeatureReader. Locally that worked, but at FME Flow I got this error message:Too many recursive macro substitutions -- line currently is: `$(FMEShare)'How can I tailor this method to get it to work? Thanks!

Hello Community,I have a question and looked for answers but didn’t find it yet.It must be simple for someone but I have not yet figured it out. I tried attribute transposer, aggregator etcI have a table with a feature which has an ID here shown as Feature 1,2,3 and multiple columns with values for each month of the year.It is like so: What I yould like to get is the following:In the end I need a row for each column corresponding to the feature it is refering to.I found some sort of a possibility but it it very “manual” an inelegant in FME as I have to create each month manually and associate a date etc. If someone has a better idea, I am very interested about it. It would help me in the long run as I may have a wrong approach to transposing data with FME.Many thanks to all the contributors. Best regards, Thomas

 Dear FME community,I hoop you will help met with the problem I am try to solve . I am reading WFS data which has more than 200,000 records. I just want to replace one of the fields from my own Excel file. I used to Attributevaluemapper to replace the value of fieldname owner with the value name owner from my exce list. I am not succeeding Do you have any idee how to tackle this?Any help is apricated and thanx in advance!! 

Hi All I have a point distance data set in a parquet file with x y coordinates and a geom column with geometry encoded in hex binary and i have line data for coastline I want to calculate distance between these points and the coast polyline .In my workflow am using geometryreplacer to get the geometry then projecting both layers using csmapProjector then using neighborfinder but am getting unexpected results ...is there a better approach 

Hi,I have a polygon file. I want to make MapboxStyler for it. But I don’t see it styled.I use parameters as the below:Could you tell me why? Thank you

Hi, I have acheived an attribute update in an existing table in QGIS.The transfert to PostGis works well when I use "Insert" and "Drop and Create" handling.However, I can not figure out the operation with "Update" and "Use existing" in order to properly transfert the updated value of the attribute code_dep. Any help is welcome.

My goal is to split the green polygon at the edge of the pink polygon. However, the pink one is not aligned properly. The black line indicates the cutting line I want to achieve. I am thinking of creating a buffer around the pink dataset, however only at the top and bottom border. At the left side, where the cutting line is present, a buffer is not allowed. When such a buffer is created I could use an Intersector probably to split the green polygon. Any support is appreciated! 

I’ve tried searching for answers to this but I’m sure I must be using the wrong search terms as I get close matches but nothing that has pointed me in quite the right direction yet. I’m hopefully that someone can help me understand how to expand the following JSON fragment into a set of features, where each feature contains the same initial set of fields, but only contains one of the final array entries.Here’s an edited example of the JSON I’m dealing with and how I’d like the out to look. {"UPRN":"12345678","CaseNo":"15/01234/ABCDE","Address":"16 Some Rd Surrey SM1 1AA","Name":"Miss T Mountain","DocumentID":["7654321","7654322","7654323"]}I’m trying to extract this into 3 features, each of which includes the uprn, CaseNo, address, name and a DocumentID. I’ve been able to extract the whole array of documentIDs but haven’t figured out how to extract each one in turn and pair it up with the remaining information.The JSON output I’m dealing with contains a number of such records, in each

Hi All,  I’m working on a workflow to export the photos (as .jpeg) collected with the Fulcrum app in the filed for a bridge inspection. I have been able to install the Fulcrum Web Connector from the FME hub here and make the relevant connection through a Token. Also I have put together the following workflow to read and extract the photos but for some reason when I paste the URL photo in my browser says ‘This page isn’t working’. I expected to view and download the photo through the API / URL (picture).Here is the workflow created so far:  I think am not too far off to get this working but would need some advise if am doing something wrong as can’t view the jpg files? example of the URL here.Also below an example of one of the photos extracted in my C drive:Any idea / trick will be appreciated.

Hi All,I’m working on a workflow to extract JPG files using the existing Fulcrum API. I have been able to install the Fulcrum web connector from the FME Hub and make the relevant connection to my organisations using a Token. All good.The problem is am not be able to view the URL photos in my browser as shows ‘This page isn’t working’. Below the workflow to extract the photos:Creator HTTPCaller JSONFragmenter AttributeFileWriterBelow a screenshot of some of the URLs in the JSONFragmenter:Does anyone know why I am getting the This page isn’t working error?

Dears, we have recently upgraded fme server windows machine to 2022. Post that character encoding default changed from Ansii to UTF8 because of this files generated by our workspace having special french characters causing issue for interface systems. Earlier with ansii encoding format they were able to read files with out issue. Im not able to find how can i change to Ansii encoding fo rthe files generated by our workspace. As of now im opening the file in notpad and saving in ansii and then sending to them as a work around. Pleas ehelp me ot automate this utf to ansii conversion. Thanks