File Directory Listing

marina_ee · 2006-08-21

I need to import files with dynamic filename, for example this naming convention: POrder[YYMMDD].txt, where the [YYMMDD] is dynamically named by a third party software according to their generation date.

I have setup the dataport according to the file structure, my intention is to have a codeunit to find the list of filenames, then call dataport with file name parameter to process them one by one. Is this possible?

Please help.

ara3n · 2006-08-21

http://www.mibuso.com/forum/viewtopic.php?t=10968&highlight=file+drive

marina_ee · 2006-08-21

CLEAR(recFile);
recFile.SETRANGE(Path, FeedPath);
recFile.SETRANGE("Is a file", TRUE);
recFile.SETFILTER(Name, '@s*');

recFile is a variable of
DataType-Record
SubType-File 2000000022

but when I access symbol menu, there are no fields named path, "Is a file", "Name"?

ara3n · 2006-08-21

does your code compile?

marina_ee · 2006-08-21

no, it says:

You have specified an unknown variable.

Path

Define the variable under "Global C/AL symbols'.

kine · 2006-08-21

And which fields you can see in the symbol menu? Sometimes the fields are localized...

marina_ee · 2006-08-21

Code
Description
Type
File Name
Table ID
Table Name
Export Filter Key
Export Filter Field 1
Export Filter Field Name 1
Export Filter Text 1
Export Filter Field 2
Export Filter Field Name 2
Export Filter Text 2
File Filter Key
File Filter Field 1
File Filter Field name 1
File Filter Text 1
File Filter Field 2
File Filter Field name 2
File Filter Text 2
File Columns

kine · 2006-08-21

I mean fields for the recFile variable... :-)

marina_ee · 2006-08-21

yeah, this are the fields i saw when i click symbol menu. It is weird isnt it? I check my declaration many times, it is correct.

Name - recFile
DataType - Record
Subtype - File

SQL Server 2000
Navision 4.0 SP2

marina_ee · 2006-08-21

i tried it with another database from another client in the same server, it works. Path, Is a File, etc... do appear in symbol menu.

kine · 2006-08-21

It seems like there are two tables with name File. Try to enter the subtype through ID not through name...

marina_ee · 2006-08-21

great, solved, now i can proceed, many thanks.
never thought of this because i choose from the table list.

ara3n · 2006-08-21

Looks like you can have the same table name for File and Navision doesn't complain about it being reserved?

kine · 2006-08-21

No, because it seem like Navision is testing just regular tables and not Virtual table names. Try it, it is allowed to create table with name File or e.g. Breakpoint etc.

Howdy, Stranger!

Quick Links

Categories

File Directory Listing

Comments