Question

Problem with workspace runner and excel files

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

2 replies

jdh
Rank
Badge +22

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

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

28,707
Posts
109,480
Replies
36,553
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.