verify the file before reload

[vireshkolagimat]

Hi Guys,

I have an excel which will be loaded on a weekly basis. Sometime i need to make some changes and will upload that file to sharepoint.   

There is one more team they will make use of the same file and they will also add some information to the same file. They will copy the file and add additional sheet to the same file. But some time whatever the changes i have made, will not be available.

Is there any way to prevent this. A kind of version control.Before I load we can make sure that the file contains latest changes.

Thank you.

Viresh

[Anil_Babu_Samineni]

You might clear the cache and all from browser and server

[vireshkolagimat]

Nope that is not going to solve my problem. Basically i want to make sure that if the latest changes are not available in the file, i don't want load the file and script should provide that information.

Is that possible?

thank you

Viresh

[Anonymous]

You can create a variable which save the date or id of the last record read, to be used in the next load, and then when reading excel, use an if statement to know if you have more recent information ... If there runs the script, otherwise does nothing.

[rupamjyotidas]

You can always get the date of the Sharepoint sit. The 'Modified On' Date of SharePoint and save it in a variable.

When you copy paste the link to web file in script editor, you can find the 'Modified Date' from there.

You can use that variable for your loading.

[krishnacbe]

Hi,

My suggestion is Instead of updating the excel why cant you create new excel and insert those new records from the new file. If there are any updates you can use the Incremental load.

Else you should maintain any version control tool.

[vireshkolagimat]

Actually what happens is if there are any changes(changes to formula)to the source file, i will make those changes and will upload that file to the sharepoint. The users will have a similar copy with them and they will use same file every week. While uploading the modified file, they forget to make the changes i have made before. So how to deal in this case.

By the way new records will not be added to the file. i have few tables in the ex excel file and those numbers will get refreshed every week.Then i will load this data into qlikview.

thanks

[Anonymous]

Sounds like the manual process you have using these spreadsheets is unreliable.  Personally I would look at implementing a database solution and getting away from the spreadsheets.

There is the old IT adage of GIGO, Garbage In Garbage out.