dms file This is a topic that many people are looking for. khurak.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, khurak.net would like to introduce to you DMS file process. Following along are instructions in the video below:
“The sdrive inside. I said nice for maintenance alandise folder is the break bulletin and and in there ls mw for the nos learning and we re dealing with vms management system. So the job being allowed to do the procedure mainly is in vms mass load. And this word document has hyperlinks to to the procedures.
So the first step is i ll show you that the documents are loaded on sharepoint as if the final versions. We re copying them from sharepoint onto the network and so they do that you control click the link that will take you to the sharepoint directory. And and convert. It the explorer view library.
And then click open with explorer. And then you can have it for view and show that folders those folders and then go into where we re putting them that s the network drive here s the path. We get in control click not middle opener and their view into that folder. And you just copy the files into here.
I m going to ask you the pop up it to create new copies or merged. They merged and you ll do that a couple times for the folders in and you can you don t have to copy on top of existing files. If they re already in there. All the files are in these folders in the structure.
Now that we look we could copy over our onto our network. Share. So thanks beautiful nut updated. The file stay you can run a das pass file.
You re doing this manually and then the dosbox file basically runs these different codes. It goes to the s drive. It goes into that folder and then it makes a direct three to eight excel spreadsheet explores the directory file names. Only this link will actually launch that file.
Though you can control click that link and only have their name decide to change the name of the link. So i will edit the link and just change the filename. I just took away that morning because i just need to be done anymore..
It s all part of the automation. Yeah. So i ll do this step down ctrl click. Gives you okay it runs.
The batch file and then it s copied all the files into it so i ll pass into that final in that folder. So then you can open that file so this like control click to open the file. And you re going to get a dialog box to convert to take film. Because it s actually just text delimited data.
So this link will open that txt file. Now this pop up might be behind your scenes. Sometimes it launches behind the scenes and you have to go and find it and then click ok anyways that would open the file and then you copy the data from it so this is the pop ups. Let s say yes to that and it will then open that tough textile.
Ok and opens. The file yeah if it s like all the files control shift. People. See the copy and bring them into the next step.
So that next step is going into the processing files. The process the path and that s step again i m automated. They don t have to do that and so on so all these steps have been automated. If they weren t automated you d have to manually copy them into the mass load file.
We go into this mass load file. And you copy them into this file to get the dynamic past because paste those values and then that converts this s drive path map dry path into with absolute paths well some of these files may have already been transferred over in the past you don t want them all to need to filter out the ones. I ve been transferred the ones have been transferred or captured before are all listed on the caption file. She oh do you want to filter.
Only to see the na s in flash. You just see the ones that have not been and kept pretty and we only want this dynamic path. We don t want the old path..
We just cook shift control deniro copy that we ll see and then put that on to the template. The template is going is the automation or mill. We re going to create the low sheet. So here s right click cases values and now that s the dynamic path.
That s values. The user name and all these fields are automated on this a lot of popular drug based on what you put in the instruction sheet and with what s important is that file may in the path is too convinced to this short description because we have maximum of 40 characters how that condenses of the series of formulas. This one here strips away the file path. It s one here summarizes.
The words so he doesn t stay running it run and so on this all right. This is it some more and if you need to well. So like does e at the length of life they be for them make sure no bill shall read if they re over 40. And this is if you want to swap the filename to be that the asset first that s what we re supposed to have it as a name with asap.
So it s a cone crusher and then the period. So all the cone crushers of this together and tech id is usually in front. So. That s basically can t review review that make sure everything s good.
Then you review your file names. And make sure. I mean to be that fun with a document. Name and it is built on formula and make sure that s good there s any words that you need to remove or change.
And you on the instructions you just have to insert a new row and save it as electrical. We want let s take a look so these are all the ones that we ve already automated. So there s a function in this file that takes this word substitutes. It with this word and this goes through this list.
So the instructions are on this main sheet. Instruction sheet. If you wanted mass change the attempt late the load..
You can say okay oh. It s not me doing. It. It s amy foster.
It changed that and everything on the template has adjusted if his name and also if it s pam loading. It s probably he s loving not fixed plant. But mobile now what these things things not just automating a template. But it s also if you say normal.
It knows that mobile is the document code 2 51. Only the document type is rfa because we re doing that that s what they decide that east tennessee to use hr is for mean. It s manuals rfa. We re using forward tasks task list job for teachers.
And we re doing mostly word documents. So that defines all the fields on that ten point and so the next one for month. Well the next number it ll get would be five thousand and ten. That s the formula basically looks at your ear loaded history.
And it finds the next number or mobile. And that s it so if i m happy with my name that i m happy with that and i hit the export button. And that button will export the data into the top rated feet. And it will create a new file that ll be a copy of this load sheet file.
Yeah is ready just a minute s. Ap. Well that s the manual procedure. I m going to show you you know i can show you the automation for export because that s all that s all building.
I get that i filled this in manually through that procedure. I ll do the export automatically with the buttons. I get an export and it takes all the data puts it in the right sheets and exports..
It to a new file. So the brand new file and it says it s going to replace the old pen file of this day like this yeah nice one arm and it closes. It it takes to that the template and it cleans the template where it be sure another load. So that s clean the history is added on what i just loaded when i m just put on that load sheet or down to say.
Billy butler. Don t actually you re not actually loading that stuff yet and it macbeth thing needs to be unfiltered again my macro does all that for you it basically runs. It clear on the filter. And then also the macro beliefs.
All yeah stuff that was processed the capture stuff was also would be put in here automatically blown sheets clear everything is now clean again that s the manual proceeded really understand those steps. But they ve automated. Most of these steps templates sharepoint to transfer the files over to the network. It s automated that step.
Which is a hyperlink if you wanna do it manually and steps. Automated and this one. I just automate. It today and that creates the final background and saves.
It i don t want to automate dating that s final file in case you want to clean it up it or just look for any problems and not save those changes. Ok so now i m just going to get a quick demo of after you transfer the bit the files in sharepoint. How you can do it all in two clicks. So you click the first button and basically that has just done the running a batch file so you hit yep ok and then it transfers.
The data files over and you just have to verify that everything is ok that you re happy with the document. Name and if not you can you know play with the data. If you want this to be the description you have to change the reference or the formula temporarily to a k instead of what is pointing at it s pointing at a i to you don t eat bacon and that would take on the swap files. The names.
Where the swamp. Well that s so i m happy with that and the file names are all 40 character so i m ready to load this i just put my instruction sheet everything s good and export again that takes the data and create new file and yes to replace the old file and that s been ” ..
Thank you for watching all the articles on the topic DMS file process. All shares of khurak.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.