HELP! DDE Poke Items to Peachtree

Eric Powers

unread,

Jan 14, 2003, 4:08:46 PM1/14/03

to

I'm trying to automate Peachtree to import maintenance items, using DDE from
Access to run the Peachtree import/export tool. According to the Peachtree
DDE documentation, this can be done by making a poke call in code:

To poke items using Peachtree's Import tool
In your DDE POKE call, add the following:

Note: "PHASE" and "COSTCODE" are allowed only in Peachtree Complete
Accounting.

For example, if you want to import the file C:\MyDocuments\MyChart.CSV using
the import template "Chart of Accounts List" then the command would be:

IMPORTFILE=CHART,TEMPLATE=Chart of Accounts List,FILENAME=
C:\MyDocuments\MyChart.CSV

The calling application is responsible for waiting for the import process to
complete by proper use of the "AREYOUDONE" keyword, as explained below. The
calling program must not attempt to do any additional commands until the
import process is complete. The calling program should go into a loop in
which it "sleeps" for a couple seconds and then sends a DDEPOKE command
IMPORTFILE=[Any one of the import files], AREYOUDONE or in our example,

Item: IMPORTFILE=CHART, Data: AREYOUDONE.

If the system is busy, Peachtree will return 0x4000, and return 0x0000 when
finished

----------------------------------------------------------------------------
--------------------------------

I can't get this to work. I'm not that experienced with DDE and can't
determine the correct syntax to create the Poke call and run the
import/export, and I keep running into errors in the DDE conversation which
state that the DDE server "...cannot poke this file." Not to mention the
above documentation is vague, and the whole thing about AREYOUDONE confuses
me. My code looks like this:

ChannelNumber = DDEInitiate ("PEACHW", "testco")
strItem =
"IMPORTFILE=CUSTOMER,TEMPLATE=PeachImportSpec_Customer,FILE=C:\Customers.csv
"
DDEPoke ChannelNumber, strItem, "AREYOUDONE"

I know this isn't correct, because it doesn't work. But what will????? I
just need a way to send new maintenance records (customers, jobs) to
Peachtree; I don't care how I do it, but it does need to be an automated
process...
PLEASE HELP!

Ralph A. Jones

unread,

Jan 15, 2003, 11:56:39 AM1/15/03

to

PAWCOM, http://www.multiwareinc.com/pawcom.htm

(You're welcome, Robert)

Chad A Gross

unread,

Jan 15, 2003, 3:01:30 PM1/15/03

to

Hi Eric -

As Ralph suggested, PAWCOM is going to be your best bet and give you the
most functionality, especially since DDE doesn't expost all of Peachtree's
fields. If you still want to use DDE Poke, I'll dig up an old Access app I
used before I switched to PAWCOM so I can provide examples of the exact
syntax . . .

--

Chad A. Gross

Heaven doesn't want me and Hell is afraid I'll take over!

"Eric Powers" <er...@axisci.com> wrote in message
news:y%_U9.74104$3v.12930@sccrnsc01...

Eric Powers

unread,

Jan 16, 2003, 10:35:54 AM1/16/03

to

Ralph and Chad:

Thanks a lot for the link/info. It looks like a handy app, but it may be
more than we need and I'm not sure I can get my client to fork over the
ca$h. Chad, if you'd be willing to provide that old Access code, I'd be
grateful....

Eric

"Chad A Gross" <chad....@laytonflower.nospam.com> wrote in message
news:u6jV9.1847$qU2....@news1.central.cox.net...

Chad A Gross

unread,

Jan 16, 2003, 11:02:48 AM1/16/03

to

Hi Eric -

No problem. I've got it archived somewhere - pretty sure on my server at
home. I'll see if I can't get it dug up and get it to you in the next day
or so . . .

--

Chad A. Gross

Heaven doesn't want me and Hell is afraid I'll take over!

"Eric Powers" <er...@axisci.com> wrote in message

news:tjAV9.10598$1q3.2389@sccrnsc01...

Eric Powers

unread,

Jan 16, 2003, 12:19:05 PM1/16/03

to

Thanks, I would appreciate it very much....

"Chad A Gross" <chad....@laytonflower.nospam.com> wrote in message

news:IIAV9.6685$qU2...@news1.central.cox.net...