×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Start an CSV Import from a command line parameter?

Start an CSV Import from a command line parameter?

Start an CSV Import from a command line parameter?

(OP)
Around the web, I have read numerous people's accounts of how difficult and unreliable the DDE interface is for poking information into PeachTree in general (and for my purposes PeachTree Complete 2002).
I've decided not retravel these rough roads and so I am instead looking for a way to run a CSV file import into PeachTree without user intervention.  One article I read suggested that its author (having tried in vain to get the DDE interface running) was now exploring a keystroke style solution.  Unless this question receives an unexpected positive response, I will probably have to follow that path myself.
Here is my questions...

Is there anyway to tell PEACHW.EXE which company to load from the command line?

Is there anyway to tell PEACHW.EXE to import a specific csv file whose name is provided on the command line?

Before anyone offers the PAWCOM solution, let me thank you for your intentions, but my budget doesn't allow for component purchasing right now.  I'm sure its a great solution, but I can't afford it.

Thanks in advance for any assistance.
Peace,
Colt.

If it's stupid but it works, it isn't stupid

RE: Start an CSV Import from a command line parameter?

I'm sorry for offering the PAWCOM solution, but for a third party component, the price is VERY resonable compare to the time that you will be spending on trying to find a solution (that is from experience). As they always say, Time is money.

Rob

RE: Start an CSV Import from a command line parameter?

(OP)
I agree that time is money.
I agree that for a third party component PAWCOM is cheap.
I agree it would be the simplest and easiest path.

Unfortunately, in this depressed tech market, my total compensation for this project is only $500.  
Spending 4/5's of it for PAWCOM leaves me with almost no profit.
Better to work a little bit, than only make a little bit.

Besides...
I've come up with a few answers for myself.
A). If I put the shortname of a company on the PEACHW command line, that company will automatically load.
B). If I setup my import layout within PeachTree to match the CSV file I am already creating, I can save that layout and if I name it with a low alphabetic value, it will sort to the beginning of the import list.
C). At that point, it is simply a process of launching PEACHW.EXE with the company name on the command line, then after a short time delay, sendkey'ing the appropriate keystrokes to start the import.  This should not take a great deal of time or effort.
It won't be pretty, but since I'm only being paid chicken feed for this solution, pretty is optional.
Thanks for the advice though.
I will bid my next peachtree project higher and include the purchase of PAWCOM in my plans.

If it's stupid but it works, it isn't stupid

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close