Solved

Coldfusion CFDirectory mapped and local drive

Posted on 2014-12-08
1
184 Views
Last Modified: 2015-01-09
A user can have several CSV files stored on his PC (C:\Users\username\Documents\payroll) or on a mapped drive
j:\documents\payroll. These CSV files are generated from an payroll application.

The name pattern of the CSV files is always PAYROLL_YYYYMMPP where YYYY is payroll year, MM is payroll month and PP is payroll period
e.g. PAYROLL_20140101.csv, PAYROLL_20140102.csv, PAYROLL_20140201.csv, PAYROLL_2014002.csv etc...


I need to read ALL the CSV file names and content from either the user's PC or mapped drive (J), depending on which selection the user made.

I tried many combinations of CFDIRECTORY but has been unsuccessfully so far.

Any help will be greatly appreciated.
0
Comment
Question by:Errol Farro
1 Comment
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 40486829
CFDirectory can't read files on a client computer. It only has access to files that reside on the CF server machine  -OR- files on a mapped drive that's accessible to the user account the CF service is running under.  In other words, from a mapped drive on the CF server machine.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now