Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,310 Posts
  • 26,855 Replies
7310 Posts
A
ashish_m1
 Data
ottadini
Supporter
ottadiniSupporter
 Data
Temporary network path mapping (Windows)

Some UNC paths are very long (\\global\analysis\more\another\and\so\on\...), so it might be necessary to map the very long path to a drive letter for example. How can I do this and retain transportability across Windows platforms, and maybe other platforms?At the moment I use a SystemCaller, and simply assign a drive letter I pick to the UNC path, e.g., SUBST X: \\global\analysis\etc\.But, this is possibly going to be wrong at some stage, when X: is assigned by the admins without warning, well, maybe. In Windows there are various ways to get the next unused drive letter, one of which is PUSHD \\global\analysis\etc\but, then how do I get the drive letter that is assigned, using the system caller?Or, is there another way?

1322
david_r
Celebrity
A
Anonymous
 Data
P
philippe33
 Data
nielsgerrits
VIP
nielsgerrits
 Data
FME server path handling

Dear community, I have difficulties understanding the behavior of server handling (unc) paths. I'm quite new to server so this one might be simple but I don't get it.What I want to do is use a Directory Watch publication on a upload folder. Then let a workbench subscription react to a new upload. This works. I need the workbench directory file and pathnames reader to scan the upload folder, add the new files to a list and move the files to a queue folder.This is where the trouble comes in. The log tells me that the folder is not found. But the path is not the path I defined (\\\\fc01\\FMEdata\\KLIC\\upload) but local (D:\\Program Files\\FMEServer\\repositories\\KLIC\\01_scan\\upload).When I create the path dynamic (datapath = \\\\fc01\\FMEdata\\KLIC, dataset = @Value(datapath)\\upload) things works fine. So I got it working but I do not understand why... Can anyone give me a hint in the right direction?I know for sure server has read/write acces to this path as I have no proble

1352
nielsgerrits
VIP
M
mhammond
 Data
Salesforce Writer appears to be stopping after 200 records

I have a transformation from Oracle Non Spatial to Salesforce that works fine until there are more than 200 records. At that point it errors. I can't tell from the error message what the issue is exactly. Is it some setting in Salesforce? Do I not have the parameters set correctly on my Reader/Writer? Any help would be appreciated. I do know that the records after 200 do not have data issues as I can write them only not when they are greater than feature 200.Salesforce Writer: Record 201 was not processed successfully: 'CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:InternalServiceOrderTrigger: execution of AfterUpdate caused by: System.NullPointerException: Attempt to de-reference a null object Class.InternalServiceOrderTriggerHandler.emailRelatedServiceOrderSDC: line 668, column 1 Class.InternalServiceOrderTriggerHandler.triggerHandler: line 93, column 1 Trigger.InternalServiceOrderTrigger: line 4, column 1:--'

340
M
M
michaeltfl
 Data
G
greenroze
 Data
zzupljanin
Contributor
zzupljaninContributor
 Data
M
mattdoa2
 Data
Accessing FME_MacroValues['FME_JOB_ID']

I'm trying to figure out how to access the FME_MacroValues['FME_JOB_ID'] system parameter.  I'm trying to link this script to a writers destination. Basically want to include the job ID in the file name of the output. I've attempted this using the code below but am getting the error shown in this log:Starting translation...INCLUDE -- failed to evaluate Python script `def ParamFunc():  import fme  return '\\\\ServerLocation\\logging\\failed_logs\\' + 'failed_load_' + FME_MacroValues['FME_JOB_ID'] + '.xlsx'value = ParamFunc()macroName = 'DestDataset_XLSXW2'if value == None:  return { macroName : '' }else:  return { macroName : str(value) }'Program TerminatingTranslation FAILED.Traceback (most recent call last):  File "<string>", line 5, in MF_Include_1490921734471  File "<string>", line 4, in ParamFuncKeyError: 'FME_JOB_ID'This is the python code:import fmereturn '\\ServerLocation\\logging\\failed_logs\\' + 'failed_load_' + FME_MacroValues['FME_JOB_ID'] + '.xlsx'

2205
takashi
Celebrity
gmbutler2
Contributor
gmbutler2Contributor
 Data
K
katiem
 Data
Issue with using the XMLUpdater transformer to manipulate Metadata

I'm using the Esri Geodatabase (ArcSDE Geodb) reader with Feature Read Mode set to Metadata, to read in GEMINI metadata from SDE. I'd like to manipulate certain elements before sending the updated metadata back to the SDE feature class. Using the XMLUpdater I've been able to amend the content for some elements, however I haven't had any success when trying to amend the revision date, as there are three different date strings all with the same XML path: metadata/gmd:GEMINI_Metadata/gmd:identificationInfo/gmd:MD_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:date/md:CI_Date/gmd:date/gco:DateCurrently none of them are getting updated on the output XML. The different date types are differentiated in the gmd:dateType element, e.g: <gmd:dateType> <gmd:CI_DateTypeCode codeList="http://standards.iso.org/ittf/PubliclyAvailableStandards/ISO_19139_Schemas/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode" codeListValue="revision">Rev

1459
itay
Supporter
A
angela
 Data
E
eltigre333
 Data
How to Extract Coordinates from Oracle Spatial Object Table

Hello, I've searched all available online sources but none appear to have this issue.Very simple task: I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when running."Error - Cannot have NULL value for 'z coordinate'"I've looked at the table in Oracle developer and indeed the Z values are Null.I'm aware that this table has multiple Spatial columns so I've checked: Handle Multiple Spatial Columns: YesI've tried a SELECT statement to run before translation:SELECT c.GEOM.SDO_POINT.X AS X, c.GEOM.SDO_POINT.Y AS Y,  FROM A.ENTITIES c  WHERE ACCESS_CODE = 'O'I've tried to expose the attributes: oracle_sdo_point.x oracle_sdo_point.y oracle_sdo_point.zIs there a way to force this to 2D rather than looking at the Z values?Any ideas appreciated. 

8364
E
tim_wood
Contributor
tim_woodContributor
 Data
ciarab
Contributor
ciarabContributor
 Data
R
robyn_studts
 Data
M
mishenka
 Data
hlouie
Contributor
hlouieContributor
 Data
N
nickcarsn
 Data
B
bas_boers
 Data
courtney_m
Contributor
courtney_mContributor
 Data
Updating SDE Feature Classes That Are Involved in a Relationship Class

I have a series of workspaces that sync an Oracle Database with an SDE database every hour (ORACLE_SPATIAL and GEODATABASE_SDE Readers > GEODATABASE_SDE Writer). I created several relationship classes in the SDE database (via ArcCatalog), and now my workspace fails to update any of the feature classes that are involved in a relationship class.I am receiving the following error: Error while retrieving an ArcObjects update cursor for the table/feature class 'DBO.EL_SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session}If I delete the relationship classes, the Feature Types update as expected.I tried setting geodb_feature_has_relationships to 'yes' before writing to SDE, but I still received the same error.Also, the Transaction Type on the SDE reader and writer is set to "Versioned Edit Session", as I am updating a versioned SDE databa

2734
courtney_m
Contributor
K
kamyabshabrandi
 Data
S
stuartohara
 Data
B
barbara
 Data
Show more activity

Badge Winners

  • FME Certified Professional
    belinda.kerrhas earned the badge FME Certified Professional
  • Summer Bingo 2026 Bronze Badge
    aphilipphas earned the badge Summer Bingo 2026 Bronze Badge
  • Online Training
    malwandehas earned the badge Online Training
  • Summer Bingo 2026 Gold Badge
    jeannlhas earned the badge Summer Bingo 2026 Gold Badge
  • Summer Bingo 2026 Gold Badge
    harrcapphas earned the badge Summer Bingo 2026 Gold Badge
Show all badges

Community Stats

32,865
Posts
124,703
Replies
41,461
Members
Terms & ConditionsAccessibility statement
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.