Best Answers

I have over 100 Excel files with standard format: each Excel file has multiple sheets corresponding to multiple days in one month on recorded hourly well flow data, and the format for each sheet is fixed. The top part of sheet has well header info while the lower part are recorded hourly well flow data. I need to combine the well header info and hourly flow data into standard table format and load into SQL Server database table. It is easy to read the hourly flow data into. My challenge is to also read well header info from the same sheet , combine with hourly flow data, and write all these data into a table. I am looking for examples and help on similar Excel data loading. Thanks in advance.

Here's some screen shots of the very simple shp to dwg workspace and the workspace runner parameters 

Attribute _xml_fragment contains: <?xml version="1.0" encoding="UTF-8" standalone="no"?><ns2:Envelope xmlns:ns2="http://standardit.tapio.fi/schemas/forestData/envelope" xmlns:ns46="http://standardit.tapio.fi/schemas/forestData/WorkingSiteOperational" xmlns:ns5="http://standardit.tapio.fi/schemas/header" xmlns:ns7="http://www.opengis.net/gml" xmlns:ns8="http://standardit.tapio.fi/schemas/forestData/common/geometricDataTypes">  <ns2:Header>    <ns5:MessageType>WorkingSiteOperational</ns5:MessageType>    <ns5:TransmissionId>11920</ns5:TransmissionId>    <ns5:BusinessSender>FI17017343</ns5:BusinessSender>    <ns5:BusinessReceiver>DK27623549</ns5:BusinessReceiver>    <ns5:TransmissionSender>CF-HARVEST</ns5:TransmissionSender>    <ns5:TransmissionReceiver>WF</ns5:TransmissionReceiver>    <ns5:System>dev</ns5:System>    <ns5:TransmissionTime>2020-09-21T12:10:29.035Z</ns5:Transmission

I'm using a PythonCaller to derive a database instance string to be used to populate an attribute.  The caller works fine until I introduce a python script derived private parameter which outputs an sde connection string.  The string works if I plug it directly into a reader, but fails if I use it as a macro value in the Python Caller.  The error references a dll but I am using the correct interpreter and all my python scripts (including this one until now) are running fine otherwise.  Any thoughts?   Thanks *note all location specific text is changed to "!@#$%"Error snippet:2020-09-17 13:30:18|   3.4|  0.7|ERROR |Python Exception <ImportError>: DLL load failed: The specified module could not be found.2020-09-17 13:30:18|   3.4|  0.0|ERROR |Error executing string `import<space>arcpy<lf>import<space>fmeobjects<lf><lf><lf>#<space>Template<space>Function<space>interface:<lf>#<space>When<space>using<space>t

Hi experts, I'd like to extract text that is within the brackets or trim characters left of the bracket. The length of characters is varied. e.g C213 (Sturt Hwy) -> Sturt Hwy apprecialte your help

Hi, I have and ArcGIS Online account containing around 100 directories (Sp1, Sp2, Sp3,...). Each directory contains a feature layer (Sp1_WFL, Sp2_WFL, Sp3_WFL,...). I'm trying to figure out how to create an FME script that will batch process all of my feature layers. At the moment I want to add a new field to each of my feature layers and populate the field with a particular value. I recently watched an FME webinar that suggested using a DIRECTORY AND FILE PATHNAMES reader and a WORKSPACERUNNER transformer however I can't seem to get it to work. Is this the best option to use for batch processing in ArcGIS Online? If anyone could get me started I would really appreciate it.Regards, Damian

I'd like to send an email upon completion of a workspace in an Automation. The email needs to contain a link to the log file URL.In the traditional Notification/Subscription workflow I could achieve this by using the {logUrl} email template key in the Subscription.In Automations, this key no longer exists and I only have access to the {job.log} key, which expands out to the file path and not the URL. I don't see any URL in the topic JSON if I monitor a topic sent as output from the completion of the workspace. Is the URL available at all?

I have a multi-page Geospatial PDF and want to extract the vector data from each page, but want to retain which page number the data originated.

An errant process has dumped thousands of file into an FTP site with an FTP watcher on it. I now have thousands of jobs backed up in the queue with necessary jobs mixed in. I need to clear just the bad jobs from the queue and I need to do so without clicking through hundreds of pages and checking boxes. Please help.

On the screenshot to the right you can see that the webpage is trying to reach a link with fmeapiv4 in it. If I look in the logs (I added them as attachment) I see some interesting things in the tomcat/core-0/Catalina log. It looks like fmeserver has trouble starting the webapp fmeapiv4. What I can make of it is in part because it can not reach the DB. But everything else seems to be working so the overall connection to the DB seems to be fine.  Anyone any idea what might cause this issue and how to resolve this?

I'm using Filtertype: Contains, and I would like to add muliple string values to Match Expression, like "string A" OR "string B" OR "string C". I've tried creating a User Parameter, but it didn't work... any idea's?

I have a workspace where I am checking to see if features exist and if not I create them. In the workspace I read one table from a database and then join it to another table in the same database (join conditions to inspections). Currently I change the name of the Database manually in the reader and rerun the entire workspace. All my database files are in the same folder but have different names. I would like to be able to run a batch process that would process each database one at a time and then move to the next. Any help is much appreciated.

Is it possible to convert linestrings to arcs (beziers)? I'm looking for something opposite to ArcStroker. I tried the ArcEstimator on some terrain curves, but the outcome was terrible. (I have read that the CurveFitter could do this, but that transformer comes at an extra cost.)

I am using FME Desktop. For my data source I am using MSSQL_JDBC_NONSPATIAL_2. I am reading the data from the data source and copying it into the Socrata platform using the Socrata writer. I copied the first four lines of command line code, pasted into notepad and saved it in the same location as the FME file. When I run window task scheduler. In command prompt, it reads. Reading...Emptying factory pipline...Translation was Successful Then get the following message directly below it.C:\\drive........etc.''--SourceDataset_MSSQL_JDBC_NONSPATIAL_2' is not recognized as an internal or external command, operable program or batch file.C:\\drive.....etc.'--DestDataset_SAFE.SOCRATA.SOCRATA2' is not recognized as an internal or external command, operable program or batch file. I cannot tell, if that is an error message and the task scheduler failed or if that is normal? Thoughts

Hello, I have an FME Desktop workflow within which I have a Counter that is set to start at 700,000, but the final three entries are not rendering with a correct value as per the attached screenshot. The Counter scope is local and I do have a second Counter within this workflow that works fine, although I was having this prior to introducing the second Counter (this has a different transformer name, is also local and starts from 1). I have run this workflow a few times now with Feature Caching On and Off, plus have closed all other FME sessions, but am still getting the issue. Has anyone experienced this before? Thanks, RB

Hi all, I have a number of shapefiles covering a range of dates, with each date recorded in the file name. I also have a number of area of interest polygons and I have been tasked with finding out how much overlap there is with each area of interest and each date period.  For each area of interest I was going to create a spreadsheet with the date taken from the corresponding file used as a field heading populated with an area value for amount of overlap. There are instances where there is no overlap between the two files. Is it possible to still take the date from the file name and attach it to the area of interest polygon and populate the field with 0? I have attached some sample data below Many thanks, Matthew 

Hello Team,I have a drone image ( jpeg ) and there are some metadatas informations, for example: longitude and latitude.I extracted these informations - center point of image.My goal is try to georrefencing this file using the transformer RasterGeoreferencer:  Thanks,Danilo

Is there a transformer that can convert a number into a number with a thousands separator, that is, "1000" to "1,000"? I know you can do it with Python but I can't find a transformer that does this.Thanks

Hello I've created a workspace, writing an IFX 2x3 file with two Property Sets per feature, which works well.Changing the writer format to IFC 4 the two Property Sets are not written. I've no Idea, what the problem could be and hope, that somebody could tell me, what I'm doing wrong.You'll find the workspace and the Data attached. Regards, Hartmut

Hello,I have a program to make that require the use of a PythonCaller. But unfortunately, it looks very different to what I am used to, doing Python work.I have looked up for some tutorials on how the input/output woks, but I have not found anything really useful, or even understandable.Do you have any link for a tutorial that goes further than just launching a PythonCaller ?I need to modify a SHP file, deleting some lines/geometry points and adding some, as well as features. All in 3DThank you

Hi everybody, I need to write to a sqlite database containing tables with foreign keys constraints, but FME seems not to enforce the foreign_keys pragma directive when connecting to the database. I discovered this by running a pragma foreign_keys; query against the database with an SQLCreator (it returned 0).This is obviously a problem, because in this way the SQLite Writer can insert records that violate referential integrity.Is there a way to make the SQLite Writer execute thepragma foreign_keys = 1;directive before start writing? Any suggestion is welcome! Thanks

How to get UTC time in FME 2014? TimeStamper gives local time >>When in DateTimeCalculator I'm subtracting hours from local time to get UTC time, but this won't work after Daylight Saving Time begins.

Hi,I have a postgresql table pre_val_error with following fields GRID_ID|ERROR_LEVEL|ERROR121|1|ERROR1121|2|ERROR2121|3|ERROR3 The requirement is to write all the records to a csv file and insert a record in Oracle with count grouped by error_level. The Oracle table details are below GRID_ID|ERROR_LVL1_COUNT|ERROR_LVL2_COUNT|ERROR_LVL3_COUNT121|1|1|1 As you can see, the number or records has to be grouped by error_level and inserted in Oracle. I have tried aggregator, counter and nothing worked. Can anyone suggest a solution for this problem. 

Hi I would like to call an oracle stored multiple times, passing different parameters. It seems only the first call is successful.Any idea what is the correct syntax ? begin storedproc1(param1, parm2);storedproc1(param3, parm4);end; I have also tried FME_SQL_DELIMITER / begin storedproc1(param1, parm2);storedproc1(param3, parm4);end;/

I'm a pretty new to FME so apologies if my question is a bit basic. There are 2 polygonal shapefiles, one that gets modified daily on a server and another we have in a sde. I'd like the first one to replace the one I have but only where changes have been made to existing polygons, while simultanously puting any new polygons created in a separate shapefile to add in manually for quality control. I'm not quite sure which transformer(s) to use. Any help would be appreciated, thanks!