automatically transfer data from one table to another table

vyanku
Member Posts: 791
Can we transfer some fields from one table to another table after perticular interval or on perticular date automatically?
(Like if there are vendor having different date of birth
If there today's date is the date of birth of any vendor that vendor will transfer into perticular table automatically)
(Like if there are vendor having different date of birth
If there today's date is the date of birth of any vendor that vendor will transfer into perticular table automatically)
0
Comments
-
Can be done in CU1 if needs be, although its not the prettiest thing to do, since it will be run on every client startup. Could attach it to user setup so its not run every time.0
-
Can be done in CU1 if needs be, although its not the prettiest thing to do, since it will be run on every client startup. Could attach it to user setup so its not run every time.
What do u mean by CU1?0 -
Hi,
you can use NAS to do this.Navision Developer and Consultant0 -
you can use NAS to do this.
[I think] :-k NAS is for other application, to enteract data between navision and other application.How it will help me to transfer data within navision tables.
Is there any other method??? ](*,) :-k0 -
Hi,
you can use for transfer within Navision itself as well. You can schedule time for automaticaly run some report or codeunti where you will have your transfer code for transfer datas between tables with condition what ever you like.
I think is very good solution, once run and then you can just relax:whistle:
Navision Developer and Consultant0 -
Hi, we have similar solution for tranfer datas between countries from one navision to another navision, but some countries are just different companies in one Navision and its work very well.Navision Developer and Consultant0
-
Ok,
But our client dont have NAS license. :-k
Will u please explain......0 -
When we had not NAS once i used form which was something like scheduler. Just add some code to OnTimer trigger and set TimerInterval in form properties and you have very simple scheduler for running repeated jobs.
Then just link to your transfer report or just function and run this form and it will be function. This is not very nice solution you have to have run this form all the time somewhere on server.Navision Developer and Consultant0 -
OK
But I want to transfer data not on the basis of time but on the basis of date.0 -
if datdate = TODAY then run else skipNavision Developer and Consultant0
-
Both NAS and scheduler cost money and the CU1 solution is free(save development costs).0
-
Still, I am missing the "why" to do that. If you have some process you need to run over such a records, you can run it directly over the original table just with appropriate filters.0
-
Hi all.Both NAS and scheduler cost money and the CU1 solution is free(save development costs).
As far as I know is one NAS session ALWAYS free and usually already available in the customers licens.
The use of NAS vs. only CU1 (which needs to be adjusted anywhichof these2ways you choose) reduce the job to be done of only one user (NAS). Though it seems a bit too much development work for what you want.
If it really has to be an automatic Job, I would go for a Report which is Called from the CU1 when any User logs on. If necessary it could save a Datetime when last run, I dont see why though as with the proper Keys it'll be through in notime and it sholdn't matter that the Report is run by all Users.It is impossible to make anything foolproof, because fools are so ingenious.0 -
Not always, just for new licenses since v 3.10 or 3.60 (I do not know exactly). But not for old original 2.60 and older.0
-
kine wrote:Not always, just for new licenses since v 3.10 or 3.60 (I do not know exactly). But not for old original 2.60 and older.
Pulling my leg now do youIf not I desperately want a Navison-version before 2.65 that can handle single instance codeunits lol
CheersIt is impossible to make anything foolproof, because fools are so ingenious.0 -
For example, this is part of one 2.60 license file:Maximum No. of Sessions
Total....................: 21
Any......................: 21
Maximum No. of satellites..: 0
after this customer bought the NAS session and some user sessions:Maximum No. of Sessions
Total....................: 37
Any......................: 36
Application Server.......: 1
Maximum No. of satellites..: 0
I know that the one free NAS session is part of the license since the granule 1010 Foundation Layer was included. But may be ther was some local difference, I do not know.0 -
Soft Tod wrote:I desperately want a Navison-version before 2.65 that can handle single instance codeunits0
-
vyanku wrote:[I think] :-k NAS is for other application, to enteract data between navision and other application
Navision Application Server is a Navision client session without a user interface, that can run as a Windows Service. That is all there is to it.
The only real limitation is that you can't run any forms or dataports, or any other process that requires user interaction. So if you have a process that has a confirmation message that you want to automate, you will have to program that process to be able to handle no user interaction, like a default value in some setup, or a hard coded default value.
Read the documentation on the product CD, in the Doc folder there's a pdf called w1w1atas or something that will explain how to set it up.0 -
DenSter wrote:You don't need NAS to run single instance codeunits. Codeunit 1 is a single instance coduenit for instance.
It's true that you don't have NAS to run single instance codeunits. It can as well be done from a central codeunit like the CU1 or manually. But to implement NAS as a background service, it's the back bone.
The clue with a single instance codeunit (introduced in v 2.65) is that it's unloaded only when the user close his session. This behaviour allows this particular Codeunit to react to events from Automation objects. F.ex. a timer tick as so often used in applications using NAS.
Codeunit 1 on the other hand is not defined as a single instance codeunit, it's more used like a central entry point for any internal/external access to global/customisable functions, which are accessed directly by ID and not by name.
Best RegardsIt is impossible to make anything foolproof, because fools are so ingenious.0 -
vyanku wrote:Can we transfer some fields from one table to another table after perticular interval or on perticular date automatically?
(Like if there are vendor having different date of birth
If there today's date is the date of birth of any vendor that vendor will transfer into perticular table automatically)
You (and everyone replying) are looking at this from the wrong direction. You are trying to move data into a new table on a specific date. If you were saying you wanted to populate and post a journal or something similar, I could maybe see what you are doing. But in you example, it looks like you are trying to be able to have a list through a table of Vendors that have a birthday today.
This just not how it is done in Navision. Instead you have a form that when opened, sorts and filters the Vendor table by birth date, and shows only those records.
Rather than explain how you want to solve the problem, why not explain what the problem is and we can give you help with a solution.David Singleton0 -
Soft Tod wrote:DenSter wrote:You don't need NAS to run single instance codeunits. Codeunit 1 is a single instance coduenit for instance.
that must have been a customization I saw once a very long time ago, and assumed that it was standard. You learn something new every day
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions