- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,811 Posts
25,089 Replies

When you subscribe we will email you when there is a new topic in this category

6811 Posts

schulte.aContributor

Converting to Epoch Time?

I am having trouble getting this converted to the right format. The times seem way off when I use the date time converter. This was a time stamp that was in a response message to a REST call that I got. Would anyone know how to prep these values + set up the date time converter correctly?“1722597785000” ← format of timestamp Thank you!

341

4 months ago

nzanellatoParticipant

asked in Data

convert 3dm in pln

Im begging for an answer about the question How can I convert a file 3dm (Rhino 7) into a file pln. (ARCHICAD)?

1001

4 months ago

solyContributor

asked in Data

how to find all possible paths in network ?

Hello , i have points and lines are topology connect together .i would like to find all paths possible in the network .i have used shortest path finder but it finds only the shortest path ,so i am looking for other solution to find all paths in the network between all points.i appreciate any help .Thanks in advance .FME 2021

30711

4 months ago

cbeemsterboerContributor

asked in Data

Can you use a scripted parameter for conditional visibility in another parameter?

I have a multiple choice question at first. Depending on the checked values I want to ask some follow-up questions. I only want these follow-up questions visible when the user checked that topic in the multiple choice question.Since I cannot use a condition on visibility like ‘contains’, I tried this by first using a scripted parameter.If the value is checked, return 1, else return 0.I then use this scripted parameter in the conditional visibility of the follow-up question(s).But.. this does not seem to work and affect the visibility.If I run the script, I can see the scripted parameter does work, it returns a 1 if needed and a 0 otherwise.But it does nothing for the visibility of the follow-up questions.Can this work? Or are the scripted parameters only calculated afterwards/during runtime and therefore cannot be used in conditional visibility of other parameters?I'm also seeing some new possibilties in 2024.1 (currently working in 2023.1) with the scripted selection. Would this solve

887

4 months ago

messagemauriContributor

asked in Data

Assign Values to a field by Conditions

Something simple but can’t get it to work. I have a Field1 with two records. One record contains numbers as 205202021356 and the other record does not contain numbers as DAKLL. I have an attributeManager where I want to assign a value for the records that do not contain numbers and keep the value the same for the records that are numeric. In the AttribteManager transformer, this is what I have under the AttributeValue field 2 possible values:So if Field1 is not numeric, I want to assign NAIf it is numeric (contains numbers) then leave it with its original valueSample below are the records. I want to assign NA to record 2 and keep record 1 as is.Field1205202021356DAKLL When I run the workbench, it keeps assigning NA to both records, rather than to one record. Thank you.

385

4 months ago

solene01Contributor

asked in Data

Can we turn xlsm into xls

Hi,I would like to convert an xlsm into xls so that I can then do a task chain. Is there a transformer or several that can help me ?Thank you for your help

211

4 months ago

pauldContributor

asked in Data

Create a workbench timer

Hi.I have a workbench equipped with several runners. I want to send myself an email upon completion of the workbench, detailing the duration each runner took. I implemented a DateTimeStamper at the Succeeded port for each workbench and attempted to merge this with the creation instance, but it failed to function as expected.I would like the result to include the duration each workbench ran and the total time upon process completion.Any help is greatly appreciated.

493

4 months ago

hieutranContributor

asked in Data

Error when converting data have relationship

Hi all,The data in my geodatabase file has an attached layer for each data layerI want to perform some transformer in FME and got the error:“An error occurred while attempting to open an insert cursor on the table 'XXX'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [DMA]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”I found the solution is to change the setting in Transactions Type to Edit SessionBut after setting, some layers can perform the conversion but some layers get the error:“An error occurred while attempting to stop an edit operation. The error number from ArcObjects is: '-2147220975'. The error message from ArcObjects is: {File read/write error occurred. [XXXXXX]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”Can anyone please advise me what I need to do now to fix these errors

410

4 months ago

alexlynch3450Contributor

asked in Data

SchemaMapper Advance Mapping Create Whitespace before evaluating data value

Hello All,I’m having an issue where SchemaMapper prefix whitespace (space) when using fmeexpression=.I attached a sample workspace and would appreciate if anyone could test before submitting ticket. This issue came apparent after upgrading to FME 2023. for example: col0=’2’, col1=’3’-->using “fmeexpression=@Evaluate(@Value(col0)+@Value(col1))” returns value “ 5” or “fmeexpression=@Evaluate(@Value(col0)@Value(col1))” returns value “ 23”Previously, using “@Evaluate([return “@Value(col0)@Value(col1)])” returns value “23”. I know 2023 introduced new functionality to SchemaMapper, per transformer help doc and https://support.safe.com/hc/en-us/articles/25407523665165-SchemaMapper-Advanced-Schema-Mapping. Would appreciated if someone could test before submitting ticket. Output SchemaMapperDoc

472

4 months ago

fbastian73Contributor

asked in Data

How to trace eletrical network to get desired output

Hello experts,I need suggestions or some help on getting FME workbench to output 2 excel files based on a user parameter which the user will be asked to supply before the workbench begins to run.Both files will be the result of tracing a feeder (the user parameter) downstream from its origin at the feeder/hypernode point.The first file I am trying to output should contain something similar to the below.So up to column G is trace and H and I is result of spatial intersection. This is based on the above screenshot which shows the feeder extension (brown line). The hypernode is located at the zonesub (blue square) and then we want all reclosers (red and white circles) along the feeder to be captured and outputted as well as the fire polygon(s) the feeder intercepts.The second file I am trying to output should contain the ids of any spans/linear objects which follow downstream of the point object until the line comes to another point object (recloser) and then carry on with that device and

1346

4 months ago

kadifeciyasminnObserver

asked in Data

cad to gis

FME kullanarak cad dosyalarını gis dosyalarına nasıl dönüştürebilirim?

381

4 months ago

patlougheedContributor

asked in Data

MariaDB/MySQL writer not ignoring calculated columns

Hi folks, I’m trying to setup a writer to a MySQL database table with a calculated column. When importing the table from the data source, FME (correctly) ignores the calculated field, so when I look at the table’s attributes (screenshot below), the column is not listed. However, when I try to use the writer, the calculated field gets included in the generated SQL insert and so the write itself fails with an error that a calculated field can’t be written to:Error executing SQL query ('INSERT INTO `StageDate` (`Date`,`Year`,`MonthNumber`,`MonthName`,`Day`,`Weekday`,`WeekdayName`,`IsWeekend`,`AcademicYearCode`,`AcademicYearDescription`,`FiscalYearDescription`,`Checksum`) VALUES ('19000103','1900','1','January','3','3','Wednesday','0','1899','1899-1900','1899-1900',NULL),...: 'The value specified for generated column 'Checksum' in table 'StageDate' is not allowed.' Note the `Checksum` in the column list and the NULL at the end of the feature values. We use this same technique with an Oracl

825

4 months ago

lancecContributor

asked in Data

Replace selected DWG Layer(s) & preserve other layers in template

261

4 months ago

daniiiContributor

asked in Data

Write lines in IFC4x3

Is it possible to write lines into IFC4x3 with FME and how to do that since IFC4x3 now supports lines?

370

4 months ago

thijsknapenContributor

asked in Data

Does Hex Encoded Well Known Binary distinguish between MultiPolygon and Polygon?

Hi there,Today I noticed something peculiar when working with data from a PostgreSQL DB (that includes the PostGIS extension).Initially I used the PostgreSQL reader in an SQLExecutor to query for some specific data, and also included the geometry column 'standardized_location’ in the select statement.That seems to output the geometry column in a ‘Hex Encoded OGC Well Known Binary’ encoding. Using the GeometryReplacer I turned this back into a ~'fme geometry object’. If I then however filtered on the GeometryType, it shows up as a Polygon, where I knew in the PostGIS DB the standardized_location geometry column was defined with type ‘geometry(MultiPolygon, 4258)’.I then used the ST_AsEWKT(), ST_AsGML() and ST_AsGeoJSON() functions to return the geometry from the database in some different encodings. If I use the GeoJSON or GML encoding in the GeometryReplacer, the geometry does still show up as a MultiPolygon feature. Also the EWKT encoding depicted the geometry as 'MultiPolygon’.Furthe

724

4 months ago

vilemrousiContributor

asked in Data

Convert multiple XMLs at once

Hello, I am struggling with conversion of several thousands of XML files (same scheme, but different attributes) in to single Excel/CSVThe tool works fine for single XML but not for multiple at once,The XML has nested levels so I am using xml_Id and xml_parent_id to navigate thru and join tohether with featurMerger tool.This is on the other hand the reason why I am struggling with the batch processing - since when multiple files are processed at once, the xml_parent_id is the same among files and the so data are ovewriting themself, or they are rejected in the feature merge with multi-reference error. Don’t you know if there os a way how to proceed? To run one by one, for example with Loop in ArcGIS works but it’s soooo slow. Thank you!

948

4 months ago

paalpedersenContributor

asked in Data

What happened to Dynamic Writer ability for ArcSDE?

Hello, I’m trying to migrate data from a SQL Server 2016 spatial to a ArcSDE on SQL Server 2022. Using ArcGIS Pro 3.2 on same machine. I am using FeatureReader with schema and featureWriter with dynamic writer. I don’t get any errors but I get thousands of this warning:GEODATABASE_SDE Writer: Renamed user attribute 'attribute{109}.name' to 'attribute_109__name' based on format constraints for invalid characters, length, and caseIf this waring occure the feature with this schema will not be written to the database, so it should yield an error not warning. yield waring on FME version 2023.2yields none-traceable error in version 2024.1Anyway I can’t figure out what it means. Any clues?

281

4 months ago

parhatboraniContributor

asked in Data

How do I read dynamic attribute(s) from same file type but in different folder

Hi there,Can you please help me with this? Every time when a new report came in, I’d have to manually open the “FreatureReader” dialogbox and hit “Ok” (to close) so that the new attributes that are added in new report at the new folder location are emerged. Otherwise, it would just read previous attributes from the new report (in below case, up to the end of June, not the July columns). I’m just trying read an MS Access file that is stored dynamically in different folder each month.

645

4 months ago

take_vfContributor

asked in Data

Python Exception TypeError: init() takes at most 2 arguments (4 given) Portal Feature Service writer

After upgrading FME Server from 2022 to 2023.1 my existing workspaces have started failing due to the following error:Python Exception <TypeError>: init() takes at most 2 arguments (4 given)ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for detailsThe same workspace runs correctly locally on FME Desktop (both 2022 and 2023) and I have tested reuploading the WS from FME Desktop 2023 to the Server but without success.I tried creating an entirely new workspace in FME 2023 that should just write a single object using the Portal Feature Service Writer. It failed with the same error on both Desktop and Server when writing to a referenced feature service but was successful with a hosted feature service.In summary:Original workspace (writing to referenced feature service with Portal writer) FME 2022 FME 2023 Desktop Yes Yes Server Yes No New workspace in FME 2023 with Portal writer Referenced feature service Hosted feature service Deskt

1305

4 months ago

probert1968Contributor

asked in Data

Can I use FME to export a PDF to TIFF exactly the same you see in PDF ?

Hi I am new to FME and here as well…I am trying to use a PDF that has an image and I want it to use FME ( not sure which one) to export it to TIFF the same as you see in PDF ? Is that possible for me to do that ?

613

4 months ago

kadifeciyasminnObserver

asked in Data

CAD TO GİS

FME kullanarak cad dosyalarını gis dosyalarına nasıl dönüştürebilirim?

321

4 months ago

ischuContributor

asked in Data

Extracting coordinates from TIFF

Hi,I am trying to extract the four corner coordinates of a tif file using the RasterPropertyExtractor.What I need are the coordinates of the data extent of the image without Nodata, what I get are the coordinates of the full extent of the image. I guess somehow I have to make the existing Nodata “0” to “real NoData”. Any help is appreciated.Thanks

26711

4 months ago

oliverwespParticipant

asked in Data

Are Cesium 3DTiles already DRACO compressed?

Hi,I currently work with the Cesium 3DTiles writer and stumpled upon some requests asking for support for the DRACO compression.I tried to do apply the compression afterwards using ‘3d-tiles-tools’ with no luck. So I took a deeper look on the b3dm Files using ‘3d-tiles-tools analyze’ and it looks to me like it’s already DRACO compressed. ‘3d-tiles-tools analyze’ gives me:{ "asset": { "generator": "FME 2022.2.5.0", "version": "2.0" }, [...]"meshes": [ { "primitives": [ { "attributes": { "_BATCHID": 4, "NORMAL": 2, "POSITION": 1, "COLOR_0": 3 }, "indices": 0, "material": 0, "mode": 4, "extensions": { "KHR_draco_mesh_compression": { "bufferView": 0, "attributes": { "_BATCHID": 3, "POSITION": 0, "NORMAL": 1, "COLOR_0": 2 } } } } ]

771

5 months ago

aric5Participant

asked in Data

How to emulate the "Create Routes" tool from ArcGIS?

I have three lines coming from CAD, I have read them and I would like to use “Create Routes”, instead I have used the measure generator. However, the measurements are wrong, and I suppose because on the way the vertices of the line were drawn (in an illogical order).By using “Create Routes” I could select the coordinate priority (lower left, lower right, upper left, upper right) to tell it to start counting from that point onwards (because the coordinate priority will be different per line). Is there a way that the same can be done in FME? Thanks!

471

5 months ago

antheatungContributor

asked in Data

Copy an UN branch version to a new branch version

Hello All,I am using FME Workbench 2022.2 and ESRI UN branch version. There is an existing branch version that has all the edits to various tables and layers that I want to copy to a new branch version. I have tried to use ChangeDetector but this how cannot detect spatial geometry changes. Is there a way to copy attributes and geometry changes and as well as other UN related table changes from an existing branch version to another version using FME? ThanksAnthea

230

5 months ago

Page 10 / 273

Badge winners

nirmanbhagathas earned the badge FME Flow Authoring Training
phoefflerhas earned the badge Student (Grey)
phoefflerhas earned the badge Teacher (Bronze)
phoefflerhas earned the badge Teacher (Grey)
buraskyhas earned the badge FME Form Advanced Training

Show all badges

30,370: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.