I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

January Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Accessing an FTP with filesystem in ObjectPal

Accessing an FTP with filesystem in ObjectPal in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Accessing   filesystem   ObjectPal   Accessing FTP   Accessing FTP filesystem  
Sam.S
North Hartland, VT USA
Rank: Ensign

I want to be able to use objectpal to automate grabbing a text file from an FTP site from within paradox in Windows10 with no user intervention.

I have been appraoching it from using a logical drive assigned to the FTP location, but I am having trouble automating the drive setup because Windows requires me setup the logical drive as an administrator.

What I mean by that is I can setup a logical drive using a command line FTPUse, but I have to right click the command executeable and choose run as admin.  Being signed in as an admin isn't good enough.  I have not found a way to turn off the run as admin requirement.  And this is not as automated as I want it to be.

I have seen descripotions of using the 'mapped drive' option in MSexplorer to make a network location for the FTP and then a logical drive, but I have not been able to make that work.

The end goal is to get a known file name from a known file location on an FTP copied to a filesystem location accessible with a objectpal filesystem statement with no user intervention. 

My existing setup works except it requires user intervention to open the logical drive access to the FTP location.

Is there a command line syntax that I could use with an execute() statement?

Is there an html statement I could use fire through IExplr or chrome to automatically download the file?

Any other bright ideas?

You want coffee?  I could write a paradox app for that...

 Posted 22 months ago (Thread Starter)
Comment Quote
About Sam.S -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Sam.S

You want coffee?  I could write a paradox app for that...


Post ID #16586, 5 replies
Thread Started 3/16/2017 11:32:46 AM
View Counter=1387
Last Reply Posted 12/20/2018 2:17:24 AM)
Location=North Hartland, VT USA 
Joined=9 years ago   MB Posts=40  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

wow, great questions.. no, I don't have an answer to any of them (sigh)

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 22 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #16592 (Level 2) and Parent is 16586
Reply Posted 3/17/2017 6:52:10 AM
Location=Myrtle Beach, SC USA 
Joined=28 months ago   MB Posts=233  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
Rank: Fleet Admiral

If I were doing this for a client, I would create a 32-bit DLL in Delphi and simply call it from Paradox to process what was needed.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 22 months ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #16593 (Level 3) and Parent is 16586
Reply Posted 3/17/2017 6:05:40 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=76   BLOG, Topics=4  
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

hey, Mike.. making a DLL doesn't bypass the "admin rights" issue, does it? but if so, that's a really simple solution!

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 22 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #16595 (Level 4) and Parent is 16586
Reply Posted 3/18/2017 5:58:16 AM
Location=Myrtle Beach, SC USA 
Joined=28 months ago   MB Posts=233  
Sam.S
North Hartland, VT USA
Rank: Ensign

I have never checked out Delphi, but I probably should.

That's Objectpal based right?

I can do everything in Objectpal except the admin issue.

I have a hack for it, but it requires user action.

And, well, it's a hack.....

Let`s just say inelegant.

You want coffee?  I could write a paradox app for that...

 Posted 22 months ago (Thread Starter)
Comment Quote
About Sam.S -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Sam.S

You want coffee?  I could write a paradox app for that...


Post ID #16599 (Level 5) and Parent is 16586
Reply Posted 3/23/2017 4:33:44 PM
Location=North Hartland, VT USA 
Joined=9 years ago   MB Posts=40  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA
Rank: Commander

no, Delphi has nothing directly to do with Paradox.. it's C+ based.. it came from Borland, back in the day, and it works well with Paradox tables and the BDE

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 22 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #16600 (Level 6) and Parent is 16586
Reply Posted 3/24/2017 6:22:12 AM
Location=Myrtle Beach, SC USA 
Joined=28 months ago   MB Posts=233  
Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1175A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #16586 Counter
1387
Since 3/16/2017
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,641 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech