Variable Drive Designation

[John Cunradi]

I have this inline Xbasic command.

file_to_rename = ui_get_file("Select MAPCO SKU Master File", "MAPCO SKU Master file(MxAuditCount.CSV)","G:\MxAuditCount\outbox\*.*","X")
IF file_to_rename = "" THEN
END
END IF
file.copy(file_to_rename,"C:\MAPCO\input\mapco_Temp.Dat")

It works perfectly if my data is on the G: drive.

The trouble is that on some PC's it is on the F: drive or H: drive or some other drive.

How can I change this to work on ANY drive rather than a single drive ?

Thanks.

[robert]

Re: Variable Drive Designation

I'm not a programmer but wouldn't you use something like If exists G:............................ else

I'll wager someone else with programming experience will chime in.

[Stan Mathews]

Re: Variable Drive Designation

It works perfectly if my data is on the G: drive.

Does this mean it doesn't work at all if "the data" is on another drive or does this mean that one has to navigate to the actual location?

my data

Is "my data" in the database directory where your tables are located? The shorthand for that is a5.get_path().

Need more details as to what you want.

[John Cunradi]

Re: Variable Drive Designation

I figured it out. I used the copyfile2 function and just repeated the line with all the different possible drives.

Thanks.

[MikeC]

Re: Variable Drive Designation

John,
Other than using the copy2() function, how did you iterate through all the possible drives? Am curious as to how others accomplish such things. It sounds almost as if you went from A through Z....if so maybe something like the following would be easier. This is how I would attempt it at least...You could put the copy2() function into the True argument where the messagebox is.

dim result as c
dim drive_list as c
dim num as n
num=0
drive_list= FILE.DRIVES_GET(crlf())
result=*for_each(x,if(file.exists(word(x,num+1,crlf())+"tet.txt"),msgbox("The file exists on the "+x+" drive" ),""),drive_list)
if alltrim(result) <>"1"
 msgbox("There is no such file located on any drive!")
end if

[John Cunradi]

Re: Variable Drive Designation

I did go through all the potential drives. In my case it was just drives E through M.

I wasn't sure how to create something so elegant as your code and I had a customer climbing the walls waiting for it to be done so I did the only way I knew how.

Thanks for the insights for next time.

[CALocklin]

Re: Variable Drive Designation

John,

You've peaked my curiosity.

Can you explain your issue in more detail just so I can understand it. The ui_get_file() should allow you to select any file that matches your file type definition on any drive. See this video.

One thing the video doesn't show is that the user may need to click the 'back' button when switching drives. Apparently changing drives takes you to the last folder accessed on that drive (?) rather than the root folder.

Was this just one of those "Oh crap! It really does work." issues? (BTDT!)

Or was the problem not finding the file but copying it to a different drive letter? (I think that could also be more automated but I'm not sure what you were trying to do.)

[John Cunradi]

Re: Variable Drive Designation

The case was this: I knew the folder, sub-folder and file name but the drive would change depending upon which computer was being used.

Many of the people using my app (my clients employees) are, to be kind, not computer literate.

By designating all possible drives, it took them out of the equation for finding the correct file and made the app simpler for them.

[CALocklin]

Re: Variable Drive Designation

Thanks. That makes perfect sense now. (However, users who aren't computer literate? Never heard of such a thing.)