Skip to main content
  • EN

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

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?

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

Thank you!

Reply


Community Stats

30,108
Posts
114,281
Replies
37,742
Members
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.