Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
M
manca_ent
asked in General
FME through Windows Task Scheduler

I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it. Has anyone dealt with a similar issue before?

980
M
conrad.schaefer
Contributor
conrad.schaeferContributor
asked in General
"Job Status: Awaiting Worker" - job is endlessly stuck - Thoughts on cause?

For a job that has been working for years, it is now endlessly polling job status and returning awaiting worker. In Server, the last message you get is about the Socrata Write executing. In the desktop software you get more information and it reflects endless polling. Something has changed and I'm having trouble figuring out the cause. 2 of 24 of these (county specific) ran and the rest hung, and now even the two that ran initially will hang. It appears to be happening in the last step involving the Socrata Writer. This is the last log information, with the "Polling the job status: Awaiting worker" repeating endlessly. Other jobs that write to Socrata are still working. It isn't blanket failure on writing to Socrata. Any thoughts on cause or leads to investigate are welcome. ThanksSocrata Writer: 0 features treated as points, 0 features coerced to point, 0 features with unsupported geometries written without geometrySocrata Writer: Invoking Socrata DataSync with control file action 'Ap

510
conrad.schaefer
Contributor
gboquin
Contributor
gboquinContributor
asked in General
Read a single file from a zip file

I have a zip file that has a csv file and multiple jpgs. I tried a CSV feature reader-- not a CSV reader-- as I was trying to read the file with in the zip file but that didn't work. I am using FME 2022.2.2. Is there a way to only extract a particular file from the zipfile? I dont want to unzip the entire thing as it will take a long time. Thanks in advanced.

1630
gboquin
Contributor
mark_zl
mark_zl
asked in General
We recently upgraded our FME server and now the file upload in Server apps is no longer working? When i click upload file the app says "There was an error uploading the file."

We recently upgraded our FME server and now the file upload in Server apps is no longer working? When i click upload file the app says "There was an error uploading the file."

1160
C
spiderman
Contributor
spidermanContributor
asked in General
How to avoid the file geodatabase from creating objectid_1

Hello ,i am working with file geodatabase then writing the output into file geodatabase so my input :file geodatabase and it contains ObejctIdbut when I write the output into file geodatabase after finish work on the data .i have found that the output contains new attribute called objectid_1how to avoid the data from creating the new objectid_1 because I have already attribute Name called objectid and I do not need extra .fme 2021 thanks in advance

1150
david_r
Celebrity
fme
Contributor
fmeContributor
asked in General
Need help with scripted parameter. I want to be able to grab a file path, then modify it by adding double slash. My code runs in python ide but not in FME. Thanks for your help!

def add_double_slash(file_path):  modified_path = ''  for char in file_path:    if char == '\\\\':      modified_path += '\\\\\\\\'    else:      modified_path += char  return modified_path # Example usagefile_path = r'C:\\Users\\Username\\Documents\\file.txt'modified_file_path = add_double_slash(file_path)print(modified_file_path)

134
fme
Contributor
psprague
Contributor
pspragueContributor
asked in General
Select data from one table based on a filed from another table

I have two tables. One is a large ODBC table in which I only want to extract the data when the modification date is greater than the last date of another table. The SQL for what I want to achieve is simple ; SELECT * FROM table1WHERE modwhen > (SELECT MAX(modwhen1) FROM table2);Any help is appreciated.Thank you,  

260
psprague
Contributor
proteve
Contributor
proteveContributor
asked in General
How to replace text in dwg with help of xls spreadsheet

How can I replace different texts in a dwg file with the help of pairs of search/replace data from 2 columns in an xls table?

1630
proteve
Contributor
M
mritunjay4code
asked in General
FME License check on script execution

Hi,I have a floating license for FME. I want to know how this FME license validation works ?Is it like license is checked everytime when I run a script through command line / FME Workbench OR it checked only once when we open the FME workbench ?

160
virtualcitymatt
Celebrity
marias
Contributor
mariasContributor
asked in General
FME Flow error reading .shp.xml file

I am getting an error when run a workbench on FME Flow. The workbench supposed to extract shapefile from S3 bucket and write it to the database.The shapefile has very complicated and big area in it. Not sure if it matters. The total size is 300Mb. Log file has just this error: Job doesn't fail, it looks like it is stuck. It lasts for hours, more than 12 hours. I had to cancel it.  I thought that the problem is explicit with shp.xml file. But I checked previous uploads and there were successful ones. Even with this file.  Please advice.

760
virtualcitymatt
Celebrity
E
ember168
asked in General
The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

100
virtualcitymatt
Celebrity
egge
Contributor
eggeContributor
asked in General
ParameterFetcher Password

Just a minute ago I did discover something I did not know yet: it is possible - to my surprise - that it is possible to retrieve a password stored in a User Parameter using a simple ParameterFetcher!Passwords stored in User Parameters are encrypted (see e.g. this post), but the ParameterFetcher just returns the decrypted password in plain text... :-(So everybody with access to a workspace with passwords and FME Workbench can just use this fetcher to retrieve all passwords.OK - maybe I have been a little naive... :-) But this is surely something to take into consideration.

1450
redgeographics
Celebrity
paulot
Contributor
paulotContributor
asked in General
LogCount_func changed process locale and terminates workspace

Hi, just wondering if anyone can interpret this log message for me and tell me how to change the workspace encoding under Windows, if that will help. Thx! (am including all the software version details for reference) Starting translation...Current FME version: FME 2022.1.1.0 (20220728 - Build 22623 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Desktop Smallworld Edition (floating)Permanent License.Machine host name is: FBC-19-0068lOS Locale Name   : en_USOS Locale Encoding : windows-1252Process Encoding  : UTF-8FME API version: '4.0 20220615'FME Configuration: FME_BASE is 'no'FME Configuration: FME_MF_DIR is 'I:\\GISSBX\\ELECTRIC\\FBC_010_CA_Dashboard\\MXD/'FME Configuration: FME_MF_NAME is 'Condition Assessment Dx.fmw'FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2022.1.1.0'Operating System: Microsoft Windows 10 64-bit (Build 19044)...The workspace was authored with a system encoding of 'windows-1252'. This will be the encod

2460
B
B
basantlalnit
asked in General
3d tileset validation error for cesium js

Hi, FME communityI hope everyone is doing great, I am creating 3d tileset for cesium js and it is getting created successfully, but when I am using 3d tile validator tool(cesium team has implemented a validator tool here https://github.com/CesiumGS/3d-tiles-validator) then I am getting my tileset is invalid because of some errors, I do not know how to overcome of these errors using FME, please anyone if knows how to fix these errors, please let me know. please find the errors below:-   "type": "CONTENT_VALIDATION_ERROR",   "path": "data/data7.b3dm",   "message": "data/data7.b3dm caused validation errors",   "severity": "ERROR",   "causes": [    {     "type": "BINARY_INVALID_ALIGNMENT",     "path": "data/data7.b3dm",     "message": "The byte length must be aligned to 8 bytes",     "severity": "ERROR"    }   ]  },  {   &

530
B
4
4dlink
asked in General
HI. I would like to ask how to manage the storage of FME flow.

HI. I would like to ask FME team about how to see the contents of storage inside of FME flow, and how to manage/delete the storage (temporal storage or primary disk) of FME flows. I would like to reduce unnecessary payment/charges, so please kindly let me know. Thank you. 

160
sanaeatsafe
Safer
albinepro
Supporter
albineproSupporter
asked in General
Simplifying polygons with gaps

I have some floor plan DWG drawing with gaps (walls) between the rooms. The desired result is to make it simplified floor plan, i.e. keep just one line between the rooms.There are hatches that forms the basic shape of polygons to begin with. So far I could get rid of gaps by buffering twice (positive and negative), dividing overlaps and dissolving small artefact sliver polygons to bigger ones. Later snapping the segments. The result is more or less satisfying, I just wonder if there's more elegant solution. For example the snapper (segment) doesn't maintain the orthogonality and makes "crooked" lines...Thanks for any suggestions.

360
albinepro
Supporter
ingalla
Contributor
ingallaContributor
asked in General
How to send through the value of zero if no features coming through...

I am trying to update a feature class containing statistics. Basically i am using the following fieldsfme_basenamefme_featuretypeand each value from the fme_db_operation (insert, upsert, update, delete etc) is the number of eachmy problem is, that if there are no deletes i get no features coming through as expected, but how can i still send through the fme_basename, fme_featuretype, and for example the value of zero for the delete attribute.I want to be able to add the total records, but obviously can not do that if there is no value, hence setting as zero.From what i have, if there are changes then they go through the workflow as expected.Regards Andy   

470
nielsgerrits
VIP
joshuajames1979
Contributor
joshuajames1979Contributor
asked in General
Rubbersheeting Issue where One Polygon disappears - different shape to original

Hi there. I'm preparing our GIS data to adjust to align with new cadastre boundaries when our state mapbase is updated as part of the Digital Cadastre Modernisation. So far with testing it all looks good, but I see one polygon on one the layers has disappeared in the shifted version. On investigating it looks like the adjusted parcel this features sits on looses a few vertices in one corner and the shift vectors being used possibly cause a self intersection. I've attached the example. On the left, the grey is the current parcel boundary and the purple is the shifted, with the shift vector joining.On the right is the particular layer that aligns with the boundary that is disappearing post shift. You can see the shape of the parcel changes and it looks like the shift vectors would cause a self intersection. Just wondering if there are any ways to avoid this? I can see a record in the output data but no geometry, or an invalid geometry. Thanks in advance. Josh

90
joshuajames1979
Contributor
spiderman
Contributor
spidermanContributor
asked in General
Question relates to geodatabase

Hello , i have geodatabase data as input ,it includes different points ,lines ,annotations . I would like to read this data in FME workbench and filter specific data from them for city then write the output again into new geodatabase writer .my problem : when I use spatial filter and use the specific city as filter and the geodatabase data as candidate .so the passed port include all data together and for sure not each input has the same attribute names as other .How could I write the output for my data (passed port ) into geodatabase format and each writer includes only his own data without any problem . 

130
caracadrian
Contributor
arnaud.leidgens
Contributor
arnaud.leidgensContributor
asked in General
Water deficit calculation

Hello everyone, I try to automate a monthly calculation of water deficit, based on monthly rainfall data. Each feature is characterized by a year (integer), a month (integer), and rainfalls (float). The calculation involves the water reserve at the end of each month ("final reserve"), based on rainfalls and number of rainy days.  My challenge is that I need to carry this quantity to the next month ("former reserve" of current month = "final reserve" of previous month). Easy to do in Excel, but I'm not sure if this is possible and how I should proceed in FME.  Is there a matter of "iterative calculation" here, since the data of each month depends on data of previous month ? Should I convert my "year " and "month" integer into date format ? Thank you in advance !Regards,Arnaud 

170
esietinga
Contributor
lferg
Contributor
lfergContributor
asked in General
I have a workbench which has the GoogleDrive Connector in it which downloaded files to a local folder for me however it has stopped working and I get an Authorisation Error 400. When I go to authenticate my web service I get the attached message

and error message below. Not sure where to from here. It was working but I am a total novice at web connection stuff. 2023-06-01 15:11:03| 0.9| 0.0|WARN |Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad Request2023-06-01 15:11:03| 0.9| 0.0|ERROR |Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.2023-06-01 15:11:03| 0.9| 0.0|ERROR |Traceback (most recent call last): File "fmegeneral\\plugins.py", line 500, in input File "webserviceconnector\\fmewebfs.py", line 1096, in receive_feature File "googledrive\\gdrivefs.py", line 569, in handle_operation File "webserviceconnector\\fmewebfs.py", line 699, in handle_operation File "webserviceconnector\\fmewebfs.py", line 856, in handle_download File "googledrive\\gdrivefs.py", line 466, in get_item_info File "googledrive\\gdrivefs.py", line 241, in get_file_metadata File "C:\\Program Files (x86)\

950
debbiatsafe
Safer
spiderman
Contributor
spidermanContributor
asked in General
How to convert from Esri Arcsde into File geodatabase ?

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro .  FME 2021 Thanks in advance

750
hkingsbury
Celebrity
sameer
Contributor
sameerContributor
asked in General
Since upgrading to FME 2022.0.01 (Desktop/Server) I'm experiencing few issues.

One of them is:WARN MessageCould not load module 'C:\\Program Files\\FME\\2022\\plugins/MAPINFO.dll' : 'The specified module could not be found'Could not load module 'C:\\Program Files\\FME\\2022\\MAPINFO.dll' : 'The specified module could not be found' Translation is successful (Desktop or Server)

1260
danminneyatsaf
Safer
F
fruby
asked in General
separately missing, null and empty values

Hi,  I want to separately identify missing, null and empty values in a data array.I tried with the TestFilter, the sorting does not seem to be done correctly.Because, my file contains null and missing values but here all data exits in one place. Do you have a solution ? Thanking you in advance   

160
redgeographics
Celebrity
scootercat_nl
Contributor
scootercat_nlContributor
asked in General
Using FeatureReader after FeatureWriter

I have made a script that writes data to Oracle database, using FeatureWriter.Before I write data, I use FeatureReader to read number of records. At the end of the script I want to know how many records there are now.I also use FeatureReader for this. The results are always the same as before and after the transactions. It seems that the 2nd FeatureReader has already started before the transactions have been processed. I have tried with Oracle Reader, 2nd connection parameter, SQLExecutor.The results are always the same as before and after the transactions.Also using Triggerer and Decelarator. Something has to happen that the 2nd FeatureReader will 're-read' the table. Anyone has a suggestion ? Thank you in advance ! 

170
scootercat_nl
Contributor

Badge Winners

  • English Speaker
    jamatsafehas earned the badge English Speaker
  • Student (Grey)
    hdnguyenhas earned the badge Student (Grey)
  • Teacher (Grey)
    hdnguyenhas earned the badge Teacher (Grey)
  • FME Certified Professional
    rune.van.sevrenhas earned the badge FME Certified Professional
  • English Speaker
    nasirhas earned the badge English Speaker
Show all badges

Community Stats

31,788
Posts
120,755
Replies
39,405
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.