Auto update the upload file in upfront portal? 1

[lincon]

In upfront portal upload a spreadsheet file updated daily,but after the spreadsheet file was updated the uploaded file cann't update automaticly.must re-upload the new version of spreadsheet file by manual.How can I make it synchronize between spreedsheet file and uploaded file?

Thanks!

 

[winkid1]

Well when you upload a file into Upfront, it creates a static copy of it. I do not believe there is a way to link them so that you automatically see an update on the web. You would have to code a script to do this upload for you and then kick it off periodically. Can such a task be done? Most likely but I've never attempted such a thing so I couldn't tell you for sure. For everything else there is an api to go through.

 

[drlex]

You could always make it a link, and as the URL, put the full path to the file.
Downside - users could change the file contents

soi la, soi carré

 

[winkid1]

As a URL link though, it wouldn't update the date/time that it changed, would it? Since the link itself is static, the date would be the date it was created. It seems that what lincon is interested in is 'tipping off' the users that the spreadsheet was updated.

But a link would always go to the most recent file so having a date displayed in the portal may not be as important. However, as drlex pointed out, this is a huge hole in security and reliability (as well as accountability). If there is a legal requirement to know who all has changed/touched the data, then a URL link is definitely not the way to go.

 

[winkid1]

Sorry...I mistook lincon's post for another I read. I was busy playing on the Oracle and SqlServer forums and I read like three pages here.

Doesn't seem like he is interested in the date/time at all, so that point is irrelevant to the task at hand.

 

[drlex]

winkid1
Point about date/time is valid, though.
lincon[/]
see the file upf_dg.pdf in documentation and the automation sample vbs scripts (.../cognos/cern/samples/upfront/automation/) to start you off on the .COM route.

soi la, soi carré

 

[Draoued]

If you create a link like Drlex suggested.

You can always update the date modified in Upfront , by sending a command line.

.../bin/UpfrontCmd -u Myuser -p my Password -s UpfrontServer:UpfrontPort '<SetNewsItemProperties><Id>NewsItemID</Id><Update
Date>Now</UpdateDate></SetNewsItemProperties>'

The NewsItemID is the newsitem id in upfront , that you can find from the Properties.

 

[lincon]

Thanks all friends for response!
I have considered what drlex said creating a url link in upfront portal,but like winkid1 said that security will be a problem,must write some api or script to check user session before download the spreadsheet file.I now create url link to a ASP file,througth the ASP process the download request.I want to know what api or script can auto process the update upload file version,hasn't it?

 

[winkid1]

drlex pointed out the security thing first (users can change contents). It won't allow just anyone access to the file. It'll still enforce the security you put on the link/newsbox so only the authorized users can get to it. The flaw comes in that those users could then modify the file. If it was a payroll report for example, they could change the data so it looks like someone made a million dollars a day or something hokey like that. Now, it's just a report so the data getting changed here isn't as much of a problem as having it changed erronously at the source, but it's still going to/may cause reporting headaches like you wouldn't believe.

Not sure on your question though. You're creating the link to an asp page that will do the upload of the file to the user's browser. What's the question on the auto process the update upload file version??