Skip to main content
Question

Problem with workspace runner and excel files

  • May 10, 2016
  • 2 replies
  • 14 views
P

Hi guys,

I need to write about 30 excel files (xlsm) into a sql server database. Each excel files has the same structure, but have different data inside.

I have a workspace that reads the excel file and write data int othe database, without any problem. I tried running a workspace runner to run the 30 excel files. The problem is that it only writes NULL value data. It writes the good amount of entries, but each attribute is NULL.

I have FME desktop 2015.1, and SQL Server 2014.

Thanks,

maxime

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

jdh
Contributor
Forum|alt.badge.img+40
  • jdhContributor
  • Contributor
  • May 10, 2016

So if I understand correctly, you have a workspace (A) that if you point it to one excel file, it processes correctly, but if you call the workspace via the WorkspaceRunner (B) it writes null values to the SQLServer database.

 

 

Do you actually need the workspaceRunner or can you point to multiple excel files in the A workspace? ie if you read in two excel files at once, does it process correctly?
P
  • phatnine
  • Author
  • May 11, 2016

Thanks, it worked without the WorkSpace Runner. I pointed to multiple XLSM files, and all entries are now in the database.

Thank you!

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility 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.