|
|
|
|
|
|
|
|
|
Resonate KT Knowledge Base > WebReports Discussion > Copy file from Windows share on server to Livelink
|
WebReports Discussion
|
|
|
|
|
|
|
Get help or share ideas and techniques for creating applications and reports with WebReports and WebReports Extenstions for Workflow.
To receive notifications when new posts are created, please choose the "Alert Me" option from the Actions menu below. (Actions > Alert Me)
Started: 1/22/2010 7:28 AM | |
|  | Copy file from Windows share on server to Livelink Hi All,
How can we have a webreport import a file from a Windows share on a fileserver.
It should be something like:
SQL as input.
SQL results contains filename of files to get from Windows share on file server (outside Livelink).
Import files from Windows share to location in Livelink.
I might use the XML object importer for the actual import and let webreport create the XML for that but it would be better to cover it in one process.
After this is done we need to do some workflow stuff with the file but that's pretty much covered.
Any thoughts?
Rgds,
Gavin | |
Posted: 1/22/2010 2:53 PM | |
| |
Hi Gavin,
Today we can report on the contents of a file if the file is in HTML table or CSV format. In this case the contents become accessible with WebReports tags so, as an example, the external file might contain a list of DATAIDs and then a couple of columns representing permissions. We could take these values and use them to update permissions on the Livelink node identified by DATAID. That’s as far as we can go right now as we can’t import the source file.
In the summer release I’m hoping we will be a step closer to what you need – though it will probably still be short. The plan is to support file system commands as a data source. This means you would be able to get a list of the contents of a folder and have things like the file name, access perms and create date as columns in the WebReport. You would then be able to call a sub WebReport (potentially itself) to get the contents of sub folders – and so on down the tree. When we find a file of interested we will be able to use the contents of the file itself as a data source. The bit we are missing is what we refer to as “pass through”. That is the ability to take the actual content from any supported data source and send it to any supported destination. We have every expectation of providing this functionality but we have not identified a specific timeframe or release yet. My best guess would be one of the major releases in 2011.
If you have budget to cover a services engagement I’m sure we can arrange to bring this forward for you – let me know.
Thanks,
Lee. | |
Posted: 1/25/2010 3:41 AM | |
| | Hi Lee,
Ok, what I can do is read the file and process the complete content to destination in Livelink.
If I can use parameters to set the 'External File Path', that would be fine. I'll test this, but if you have any thoughts in this?
The only thing what is still an open issue is how to remove the file from the file server after it's imported to Livelink. Any thoughts on that?
Rgds,
Gavin | |
Posted: 1/25/2010 3:41 AM | |
| | Hi Lee,
Ok, what I can do is read the file and process the complete content to destination in Livelink.
If I can use parameters to set the 'External File Path', that would be fine. I'll test this, but if you have any thoughts in this?
The only thing what is still an open issue is how to remove the file from the file server after it's imported to Livelink. Any thoughts on that?
Rgds,
Gavin | |
Posted: 1/25/2010 3:41 AM | |
| | Hi Lee,
Ok, what I can do is read the file and process the complete content to destination in Livelink.
If I can use parameters to set the 'External File Path', that would be fine. I'll test this, but if you have any thoughts in this?
The only thing what is still an open issue is how to remove the file from the file server after it's imported to Livelink. Any thoughts on that?
Rgds,
Gavin | |
Posted: 1/26/2010 10:33 AM | |
| |
Hi Gavin,
I've spoken with the team here and we've determined that this isn't possible right now. With the next release we will likely be able to call a SWR to perform the delete operation. As for dynamically generating the source patch for file as a data source - that isn't possible right now either. We have it on the feature list but don't have it flagged against a specific release.
Per my initial response, if it's an emergency we can probably arrange a services engagement. If you can wait 6 months or so then we should be able to get at least part of this in the core release.
Thanks,
Lee. | |
|
|
|
|
|
|
|
|
|
|
|