delete txt file after import

hawwa

Dear all,

I have a dataport to import data from a text file. How do I delete the text file after importing all the file.

Thank You,
hawwa

Kowa

Put the following Code in the OnPost Dataport Trigger

WHILE EXISTS((CurrDataport.FILENAME)
DO ERASE(CurrDataport.FILENAME);

The WHILE -DO Statement is safer than IF-THEN.

NaviTools.com

Hi Kowa,

you don't trust Windows too much

Kowa

The Windows file deletation is ok, but the Navision - Windows interaction is
not on all terms "state-of-the-art."
The precaution stated above comes from experience, not from prejudice.
Our customers have imported hundreds of dataport files. Every once in a while, the file deletion did not work, where WHILE-DO wasn't used, for no apparent reason. Better play it safe, this will save you time and money correcting the nasty impacts of double imports.

Savatage

Kowa wrote:

Put the following Code in the OnPost Dataport Trigger

WHILE EXISTS((CurrDataport.FILENAME)
DO ERASE(CurrDataport.FILENAME);

The WHILE -DO Statement is safer than IF-THEN.

I get the Error Message:

You cannot use the file Z:\ABC.txt because it's already in use.

What I'm shooting for is a pop-up that says - Import Completed would you like to delete the file Y/N.

Savatage

Ok this works better

CurrFile.CLOSE;
ERASE(CurrDataport.FILENAME);

Gotta Close the file first.

I didn't start the thread so I cannot add [Solved] :roll:

Marije_Brummel

Savatage wrote:

What I'm shooting for is a pop-up that says - Import Completed would you like to delete the file Y/N.

And of course you need to add the

Currfile.close
IF Confirm(Text000, true) then
  erase(...

Where Text000 = 'Would you like to delete the file?'

Succes.

Savatage

I've noticed you sure are quick on reply's!! 8)

Nobody else has a chance

Marije_Brummel

I just post a message if I think know the answer, thats all.

DenSter

Sounds like business is a litle slow in Holland

Marije_Brummel

Yeah, whatever.

DenSter

or you are an insomniac :-k

Marije_Brummel

Guys, I am just an ordinary guy from holland trying to have a little fun and distraction on this forum.

If you have any problems, please let me know. Preferably by email, or pm.

DenSter

No problems here, just a little fun at your expense :whistle:. Didn't mean to get your panties in a bunch, and I am sorry if I did. Your (and everybody else's) help is greatly appreciated, trust me.

Savatage

Mark Brummel wrote:

Guys, I am just an ordinary guy from holland trying to have a little fun and distraction on this forum.

If you have any problems, please let me know. Preferably by email, or pm.

It was all light hearted, sorry if you took it wrong O:)

DenSter

ehm... I think we've highjacked this thread... :oops:

Savatage

OK then...

[Solved]

Put the following Code in the OnPost Dataport Trigger

CurrFile.CLOSE;
IF Confirm(Text000, true) then
ERASE(CurrDataport.FILENAME);

Where Text000 = 'Would you like to delete the file?'

Thanks to all \:D/

DenSter

Alrighty then... Hawwa or Luc, please put the [solved] thingy in the subject

Kowa

There was a national holiday yesterday here so I couldn't take part in the chatting , but specially if the import file is on a network drive I would prefer :

CurrFile.CLOSE;
IF Confirm(Text000, true) then
WHILE EXISTS(CurrDataport.FILENAME)
DO ERASE(CurrDataport.FILENAME);