Reading Access db table from Nav (license issue, newbie)

galmok

I am new to Navision and especially to its complex license handling so here are my questions.

I am asked to make Navision (4.0SP3) import names, dates and numbers from an MS Access file database (mdb). I figured this shouldn't be so difficult but have learned a bit since then. ;-)

The license has options 7110 and 7120 (form, report and dataport designers and 8600 (100 code units). Checking with the Navision License Viewer program, I see these options available to me:

Form 50000-50099 RIMDX
Report 50000-50099 RIMDX
Dataport 50000-50099 RIMDX
No Codeunits
No System
No table

With "No" I mean there are of course tables, but the client is not allowed to create any of them. My solution seems to have to make due without them. That is, unless I misunderstood it.

Is it possible, using only Forms, Reports and/or Dataports to import data from MS Access file-db to a Navision table (that already exists)?

If not, what would I need to do that? (most importantly, can I do it without 7200 and 7300 (application builder and solution developer?)

Did I understand Dataports correct when I say that they can only handle text in/out?

Thank you for reading. :-)

nunomaia

Did I understand Dataports correct when I say that they can only handle text in/out?

Dataport import / export is done is text file. So you have to export Access to CVS or other text file.

Is it possible, using only Forms, Reports and/or Dataports to import data from MS Access file-db to a Navision table (that already exists)?

Depends table. You need some coding to check/validate data, then you need 7200 or 7300. Somes tables are "protected" and you need 7300.

If can make Object Designer / Table ->Run and insert data.
then you should be able insert data using dataport

galmok

Ok, so dataports are only text in/out. I'll have to check if I can accept a plain text file as temporary data storage.

I'll check if I can insert data using the Object Designer->Table->Run although I am almost sure I can.

I already did try a dataport to export data and that was successful.

Is there any way around Codeunits if I need to use ODBC (to access the MS Access DB directly)? Requiring the 7200 package and maybe even the 7300 package is a bit over the budget limit.

nunomaia

I gived you a wrong information.
Granule 7,110 allows you to access C/AL in dataports. Sorry .....


Use can use ADO to in Navision to query another DB's

themave

Dataports is all you need, we do this constantly, for price updates, import of ship to addresses, lot of things.

Access exports to a txt file, and the dataport imports into Navision.

you can have the dataport do the validation checks.