I am in need of an option to be able to take an excel file o...

[Kristi Carter]

I am in need of an option to be able to take an excel file on our network shared drive and have it upload onto Reporting Server. I know this can be done manually, but I would like to take it one step further and be able to automate this process and schedule this upload.

I am not seeing where this can be done anywhere in App Studio, data flows, etc Is this an option I am struggling to find any documention if it is.

Thanks,

Kristi Carter

[NYCBabak .]

On the Reporting Server, when I right click on a flow, I see Schedule and Email as an option. See if that works.

image.png687622 42.6 KB

[Kristi Carter]

Right, I know it is an option to schedule a flow. But when developing a flow, is it possible to have it do the step of uploading the excel file to the Reporting Server within the data flow itself From what I can tell, the data flow option needs to have the file manually loaded to the server first before it is an option to include in a data flow. Is this true, or am I missing something

Thanks,

Kristi Carter

[Michelle Adams]

Did you try having the excel file go to a listen folder and then the flow should pick it up automatically from the listen folder.

[Michael Williams 11]

Hi Kristi,

I guess this is dependent on your environments security setup, but if your excel file name is fairly static, you could use something like a procedure with APP Map to the network drive (w/master & access files present in that folder) and take your excel data and then load it into a FOCUS table using the modify(maintain) language (granted Ive taken the lazy route by just using the SQL translator and doing inserts into my XFOCUS table).

[Ian Dalton]

Also check out my query and replies from a few weeks agoCreating a MFD from an Excel Spreadsheet

[Manoj Chaurasia]

Kristi

I dont know if you tried the file listener suggestion, but one other opton would be to embed FTP commands in the flow to move the file.

[Pawan Vuppala]

If you have data migrator that would make it so easy for you but heres one way, if this Excel file is always in a shared folder accessible by WF you can create a synonym and then write a procedure to do MODIFY type request and APPEND or INSERT as you need, then schedule it with ReportCaster.

[Kristi Carter]

How do you recommend creating a synonym with the excel file when it is still on the shared drive area We are currently trying to do an ODBC connection to one, but are unsuccessful so far as we get ODBC error right now.

If you have another suggestion on how we can do the same thing, that would be great.

Thanks,

Kristi Carter

[NYCBabak .]

Direct Excel. https://webfocusinfocenter.informationbuilders.com/wfappent/TL5s/TL_srv_server/source/7709_excel_direct130.htm

[john cullen]

I know this thread is closed, but I have something to add.

There is an adaptor called a delimited CSV/FTP adaptor. It reads CSV files via FTP. If you can FTP to your shared network drive from your reporting server, you can read the file that way via the adaptor. You just configure the adaptor to connect to the FTP site, then make a master file against that FTP site. When you use the master file, it goes and gets the data via FTP. The one big caveat is, it needs to be a .csv file, not a .xlsx file. We have used this approach to get data from any ftp site.