Authoring

Hi, I'm inefficient with CSS selector statements - having no HTML authoring background. I want the CSV download links at this site and only the csv download links:https://data.sandiego.gov/datasets/parking-citations/I can get all 'a' tags and the href references no problem but have to test the result ends with '.csv'. Can anyone give me the right selector syntax for the element I'm after? Thanks all.

I have 1 table that has one column called mbipk with a number value and then another column called sales with a number in it. I want to run it against 16 other tables which also have that same mbipk column, I want it to match only the mbripk number and if that matches then I want it to inject a new column called sales_2 and put the sales number from the 1st table into sales_2 into table 2. Is this possible?

I had an issue with a workspace with a disabled junction. I then discovered that disabled junctions won't get grouped in the navigator as disabled transformers and disabled connections do. Is this on purpose or is this something that can be improved? I expected them in the "Disabled Transformers" group. The workaround is to search for "junction" in the workspace search, this will display all junctions and mark the disabled junctions grey. Tested in 2021.1.1.0 (20210730 - Build 21619 - WIN64)

Greetings,I'm running a workspace through FME Python API using FMEWorkspaceRunner, and need to ensure that the 'redirect to fme data inspector' parameter is toggled off prior to running. How can one access this workspace parameter?Thank you,TylerFME 2021.0.0.1Python 3.7

Hello, before writing a Python script, I'd like to know if there is a way to retrieve the lines between a point A and a point B using classic transofrmers?  

Hi authors.FME workspaces are stored in a specific and well-known structure on an FME Server. So finding the path of another workspace is feasiable.I'm wondering whether I can use WorkspaceRunner to submit other workspaces on an FME Server instead of FMEServerJobSubmitter ?Is this completely no-go, or are there benefits, such as running more workspaces within a single job ?It would also simplify building and debugging on desktop.Any insights are appreciated.Cheers

Hi.When you have a workspace with a published parameter of type text, and it has a default (e.g. testing) value, this gets used whenever the value isn't specified in JobSubmitter/WorspaceRunner.If I submit a blank text as a parameter value, this seems to be ignored, and the default value is used instead.Is this WAD ?If I want to overrule a default parameter value with a blank value, how is this achieved ? Cheers

Hey all,I am using the ArcGIS Portal Feature Writer and when I push my edits to a feature service, it overwrites the editor tacking fields (eg. createdby, createddate, modifiedby, lastmodifieddate) with my username and today's date and time of upload, instead of values I have prepopulated. The table sits in a postgres database and I have turned editor tracking off against that table. Is it possible to push data using the FME writer without those values getting automatically populated?

Undefined macro `SourceDataset_FILEGDB_3_FILEGDB_3' dereferenced in file `A:\\...\\...\\FME Worksapces\\wb-xlate-1459541027202_6756'Program TerminatingThis error happened to me today for no identifiable reason. If anyone has encountered this issue or has an idea as to why this could happen I encourage you to share your thoughts here. After this happened two files were created in the folder where I store my work spaces (Not where temp files go).wb-xlate-1459541027202_6756ANDwb-xlate-145865875395_6136A peculiar thing happened to one of my readers and it kept "resetting" to not being set (<Not Set>). So you could not open the containing folder or edit the path. It had no options, but the schema and the reader were still in the workspace.At first I tried rolling back to the very beginning of my work flow history to check if the translation would run when it used to run, but no, I got the same error.The problem can be fixed by copying over the entire workflow into an

I would like to import a select number of tables from Oracle Spatial Object into ESRI geodatabase_SDE (ArcSDE Geodb), where they are given a new table name.I can do this one table at a time, but is there a method where I can batch or loop this process, as I have a large number of tables to process.I have both the required input and 'renamed' output table names in an excel spreadsheet.Please note - I do not want to import the whole database, only a select number of Oracle tables which are then given a new name in SQLserver.

Hi, currently all my zipfile output from my FME Server App using the Data Download Service are being named with "FME_" following by some random numbers. I would like to ask if there is any guide to change the naming of the zipfile, be it through the FME Server UI or configuration files. Thank you. 

Hello FME users,I just wanted to share some information about an update to data types in FME2020, which I don't think has been publicized much. The best demonstration is through a video, but first here's a brief description of the update...Data Type PreservationIn previous versions of FME, attribute data type would not be preserved fully throughout a workspace. For example, a writer could not determine the data type of an attribute added or edited in the workspace.You could prove this by following these steps:Open FME Workbench 2019Add a writer and set the feature type attributes to automaticAdd an AreaCalculator transformer connected to the writerThe result is that _area is added to the writer, as type char(200). The writer was not able to tell that this attribute should be a numeric type. You would often see char(200) fields as a default for unknown types.In FME 2020 this has changed.If you repeated the above step in FME 2020, the result would be a real64 field (or the equiva

I am new to FME and going through the unit "Quickly Create a Conversion Workflow " of "Integrate Your Data with the FME Platform". In that unit, we create a reader to a PostGIS database. My understanding is that what we see on the canvas is just the "feature types" of that database, aka individual tables. I thought that they would all connect to the same "reader" in the background. But when I added two new readers to the canvas (marked 2 and 3 in the image), they created brand-new readers in the navigator. Even in the case of reader 3, which has the exact same parameters as reader 1!Can you please suggest if there's any way to modify the feature type marked 3, to make it use the reader marked 1? When I open the feature type's properties, they are greyed out. The only options I see right now are:keep both readers and maintain "connection parameters" in both, orrecreate that feature type from reader 1 and manually configure it as

Hello, I’m looking for a way to classify (order) the lists within a list attribute. Essentially I need all lists that have a “phase” value of ‘R’ to be on listattribute{0}…all list values that have a “phase” value of ‘Y’ to be stored in listattribute{1}…and all list values that have a “phase” value of ‘B’ to be stored in listattribute{2}.  Using List Sorter, I am able to accomplish this as long as there is a list for all three phases. The data sometime has only 1 or 2 phase values (example: Y and B, but no R). If I sort the lists that only have two phase values, “Phase” = ‘Y’ ends up in listattribute{0}. How do a force a blank list value for ‘R’, so that ‘Y’ still gets stored in listattribute{1} and ‘B’ gets stored in listattribute{2}?.... listattribute{0} could remain blank  These lists need to be structured correctly so that I can run them through an XML Templater and have them placed in the correct spot in the XML. Update - I have attached the workspace and the xml template that cal

See attached images. I'm trying to read a Geotiff of an engineering drawing. When I view it in 3Dpaint the pixel values vary between black, grey and white. But when I read it in FME all the pixel values are either black (0,0,0) or white (255,255,255). I want to sharpen the image by filtering out the grey pixels. But how do I read the file to expose the "grey" pixel values?

I have a gdb with domains with a lot of feature classes and tables. They all have 8 fields that are the same and the remaining fields vary from feature class to feature class. I want to populate those same 8 fields with the same value for all the features but maintain their schemas. I tried doing this with an attribute manager and writing with the template file geodatabase with the attribute definition set as dynamic. I've also tried adding the values to the attribute definition. I know there must be a way, I just can't figure it out! TIA

I need to write to a single excel file with multiple sheets using a template. I've created a template with multiple sheets formatted as I need them but when I write to excel, it will only write one of the sheets and leave the others blank.

import osimport requestsimport jsonimport cv2 directory = r'C:\\boatlaunch'for filename in os.listdir(directory): if filename.endswith(".jpg") or filename.endswith(".jpge") or filename.endswith(".JPG"):  print(os.path.join(directory, filename))  filenamepath=os.path.join(directory, filename)  url = "https://<servername>/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/EnvironmentAffair?createDirectories=false&overwrite=false"  head={   'Authorization': 'fmetoken token=<mytoken>',   'Content-Disposition': 'attachment; filename="test.jpg"',   'Content-Type': 'application/octect-stream',   'Accept': 'application/json'   }  print(head)  filedata = open(filenamepath,'rb')  print(filedata)     res = requests.post(url,data=filedata,headers=head)  print(res.status_code)  print(res.text)  print(res.request.headers)

In the ExcelStyler, it is possible to add a border style to a row.  It gets a value like:version<semicolon>1<semicolon>cell_border_style<semicolon>BORDERSTYLE_THICK<semicolon>cell_border_color<semicolon>0<comma>0<comma>0However, I only want to apply it to the bottom of that row, which is not available in the interface. Does anyone know whether it is a possibility to extend the current formatting value and apply the border style to the bottom only? Maybe something similar to:cell_border_type<semicolon>BOTTOM<semicolon>but then with the right values

We have a custom transformer Updater in FME 2019.0.2.0 which uses a DateTimeStamper to extract the current date and time into an attribute. Geographical location is Denmark.The custom transformer is called at 4 different places in the workspace and the last two are reporting the following message (only shown for custom transformer number 3): 2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to parse '20190626105743.717495+02:00' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm. For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-Format2019-06-26 10:57:43|  50.4|  0.0|WARN  |Updater_3_DateTimeStamper: Failed to evaluate expression '@DateTimeCast(20190626105743.717495+02:00,datetime)'.  Result is set to

Anybody an idea why this combination would not work?The Shutdown script seems to not executed.Startup scriptdef initializeArcFM(): import win32com.client global app app = win32com.client.Dispatch('Miner.Framework.Dispatch.MMAppInitializeDispatch') runtime = win32com.client.Dispatch('Miner.Framework.Dispatch.MMRuntimeEnvironmentDispatch') app.Initialize(0x5) runtime.RuntimeMode = 0x4 print "ArcFM runtime mode", runtime.RuntimeModedef cleanupArcFM(): global app if app: app.Shutdown del app print "ArcFM shutdown"initializeArcFM()Shutdown script cleanupArcFM()

I have recently installed FME Server I have been working through some tutorials, and reviewing the examples installed on the server, to see if I can automate some things I currently do manually.  The first one I am working through is actually based on one of the tutorials in the server training material (Ex 3.3 here).  What I am hoping to achieve is that we can have an FME Server tool that the user can access, select from a list of arcgis online feature layers (things like watermains, property boundaries, etc), then the user can draw a polygon on a map to define the extents, and FME will output this data to the user, including ALL attributes within the selected Feature Layer. Currently I have the attached template, it kind of works, as in it successfully exports the correct spatial data, but for the life of me I cannot work out how to get the attribute data of the selected feature layer to be export to the XLS output file. As previously mentioned, the second thing I am trying to work o

I am trying to generate centerlines from parallel line pairs which are transformed into bounding boxes, then areas. This works but the centerlines do not extend all the way to the edge of the area/bounding box:There does not seem to be any settings in either bounding box, area builder, or centerline replacer to change this. Am I going to have to add a snapper? Any reason why it does not go to the edge? Thanks,@larue​ 

Hallo! I'm trying to set the folders in the zip-file for my data download service, as discribed in this question It works the first time I set the folders. But when I need to do a change in the zip-file order, the value of the 'Path to zip-file' are 'stuck'. Even if I edit them, they go back to the value they were initially set to. How do I get around this? Best regardsKicki M

Trying to calculate distance (Have been using nearestneighbour) but now require were we have a set of points in table 1 and a set of area features in table 2.We need to calculate the distance from each point to the nearest area feature but not its centroid, the requirement is to find the distance from table1 point to the nearest edge or vertex of an area feature from table 2 happy to hear ideas on how to do this thanks