I need new projects/ideas :)

Andreas_Lundin

Hi all

I'm desperately seeking some ideas/projects that might help Navision customers or NSC. I running out of ideas myself. So if you have any suggestions or ideas on what might be a nice thing to have in combination with Navision, please post a comment on this thread/Forum or send an E-mail to draupner@jubiipost.dk.

If anything interesting shows up, I'll try to make a tool/solution based on your idea. And I'll make it available as public freeware.

In general, I think we get to little feedback on the tools in the download area. More response will surely be welcome in order to make both current and future tools better. So, if you're a user of files downloaded from www.mynavision.net, please place any suggestion or comment - also negative ones - in this forum.

Regards
Andreas Lundin

r_schueler

Hi Andreas,

a easy to use codeunit/ocx for interfacing the TAPI function
of windows would be great! I have found a tapi.ocx but it is
very difficult to use. I was not able to get it to work. I am
looking for a combination of a codeunit and an ocx which provides
me functions for starting outbound calls or read the CID from
an inbound one. Wouln'd it be great to dial the customers direct
from the navision customers from. Or if you get a call open the
customer record with just one mouse click!

Just an idea. But that is what you wanted, isn't it?

Best regards
Rainer

JohnP

Rainer,

Have a look at VTI on the Vorsprung Business Systems website
(www.vorsprung.co.uk) because it already provides the functionality that you describe.

Regards,
JohnP

Andreas_Lundin

Hi again

If you haven't noticed it <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> The tools I make are for free and distributed as freeware, and the only goal for me making these tools are to be a better programmer. So, why not use an idea useful to the real world, when you learn more about programming?


Of course there's no warranty what so ever, but sometimes freeware is a good alternative if you just want to perform a single task.

Of course you have both support and a company to contact if you have any problems etc. when choosing a to buy the product. The freeware product normally doesn't have the features of a professional software product.

Just some thoughts on freeware and professional software.

Andreas L.

Implevit-cbi

How about an integration of Outlook address data with Navision Financials Adress Data?

Best regards

Christoph

Andreas_Lundin

Hi Rainer

Your suggestion sounds like an interesting subject. I don't know much about the TAPI functions, but I have read something on the subject a few years ago(in some Visual C++ manuals).

I'll do some research on the subject, and I'll try to make a "primitive" OCX capable of placing a call from within Navision. I need to read some litterature first <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> But I know how to use Visual C++, so that part shouldn't be the difficult one.

Would you be interested in testing it, when I have something ready?

Regards
Andreas L.

Andreas_Lundin

Hi Christoph

The idea of integration Outlook address data with Navision Financials Adress Data also sounds interesting. I'll take a first look at it sometime next week. But I need to know exactly what you mean by integrating the address data. Do you think in the lines of importing/exporting addresses between Navision and Outlook, and beeing able to make a two-way update of address data in both systems?

Regards
Andreas L.

Implevit-cbi

Hi Andreas

Most useful would be surely the 2way update of data Navision <> Outlook. But surely also the most difficult possibility... I don't know if it's realy possible but surely it would be great

Regards

Christoph

Dave_Cox

Prospects and Contacts Maybe, but not Customer / Vendor Details
Replication would have to be controlled by an option
From
To
From & To

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Implevit-cbi:
Hi Andreas

Most useful would be surely the 2way update of data Navision <> Outlook. But surely also the most difficult possibility... I don't know if it's realy possible but surely it would be great

Regards

Christoph

<HR></BLOCKQUOTE>

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

Implevit-cbi

Hi Dave

You're absolutely right

Regards

Christoph

Tarek_Demiati

Hi Andreas,

Running out of ideas , eh ? <img border="0" title="" alt="" src="images/smiles/icon_wink.gif" />

What about a cute C/AL text editor (using the same coloration
standard than VB for keywords,etc,etc...)

A little more demanding would be a
C/AL compiler which would generate NF text files
as the FOB file format is undocument(?)

This is a hell of a job between the parser, lexical analyzer,etc,etc...
You won't have to deal with code optimisation
as the compiler will only generate NF text objects.
That could be a very interesting project for someone
who love to code outside working hours.

Tools like Yacc and Lex may reduce the development
time of such a compiler.

Would not it be great to have debug feature as in VB :
Immediate windows, breakpoints (well there's one in NF but
it's a pain in the ass to set), watches, etc,etc...

tarek_demiati@ureach.com

Borislav_Popov

To Terek and to anyone interested :
just a suggestion about setting breakpoints :
e.g. in codeunit 12 [a huge one]

before the statement u wanna set a breakpoint on :
insert temporary the following :
if confirm('Do you wanna set a breakpoint here') then
error('I hope you already have set one.');
then do the following Run the process you wanna debug with Active = true
Breakpoint on trigers = false
on the confirm question answer with Yes
In the code that appeared set the desired breakpoint
Finish the debug process
Start it Again now answer with no\
the Debugger will stop on the breakpoint...
p.s. : when you use this it causes much less effort than it took me to write this Reply ...
hope it helps for huge amounts of code

Tarek_Demiati

I actually use the same method,
I just stick an ERROR('BREAKPOINT');
just before the bugged section of code.

I guess we're all improvising with what we've got <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />

Ok, enough complaining for today!

tarek_demiati@ureach.com

mfabian

Originally posted by Andreas Lundin:
Hi Christoph

>>The idea of integration Outlook address data with Navision Financials Adress Data also sounds interesting.<<

If you try that (in fact *I* did) you will face the following problem: In Outlook you can store anything in any folder! What does that mean? Well, you can store a task in the contacts, an e-mail in tasks or whatever. As Outlook does not provide any method to limit the searched items to a certain type and Navision doesn not support the generic types, you will run into an error whenever you try to assign an "alien" item to a - let's say ContactItem:
Let's take the following example:
You want to loop through all Items in the "Contacts" folder which is defined as Folder 10. Each found contact should be stored in a "ContactItem" Variable which has the type:
'Microsoft Outlook 9.0 Object Library'.ContactItem
in order to allow access to this Contact such as syncronising it with a Navision address:


_NameSpace := Outlook.GetNamespace('MAPI');
MAPIFolder := _NameSpace.GetDefaultFolder(10);
_ItemsAll := MAPIFolder.Items;
IF _Items.Count <> 0 THEN BEGIN
NoRecs := _Items.Count;
FOR Counter := 1 TO NoRecs DO BEGIN
if evaluate(ContactItem,_Items.Item(Counter)) then begin

[ blabla]
end;
end;
end;

Look at the "evaluate" line which assignes the next Item in the MAPI-Folder to the variable ContactItem: If you have an non-ContactItem within your Contact List (which also applies to Groups) Navision will issue an error and stop processing.

The only possibility to avoid this would be to create your own OCX-Wrapper (programmed in C or Delphi) which filters non-ContactItems from the list.
Therefore Automation-programmers should always be aware of the three restrictions Navision has:
1) Visual controls are not possible
2) Triggers cannot be 'fired'
3) Navision does not provide ANY exception handling.

Have fun anyway

Tschüss

Marcus

---

Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72

Oerlemans

Concerning Contacts synchronisation

I'll use W1 terms for Navision items.

First of all, it's not Outlook but Exchange Server you should look at. What we currently do is a periodic "upload" of the Navision prospects to Xchange. Customers & Suppliers are linked to the Prospects in Navision. This is very easy to do (use OLEDB), but it doesn't give you synchronisation. We are working on the real-time sync, but it's not easy.

This is roughly what needs to be done:
1. Navision-Xchange: Write Navision triggers that update/insert/delete contacts in Xchange using the Xchange store message-id for contact identification (you should store this id in Navision after inserting a contact in XChange). Your contacts should reside in a public folder. Build a COM dll wrapper for CDO 1.21 in VC++ or VB, it's really hard and slow if you do it all in C/SIDE. We did not even try this.
2. XChange-Navision: Use Xchange server-side scripting. There are 2 ways to go: ODBC or C/FRONT. ODBC is easy, we started with this, but are considering C/FRONT because it's a lot faster. Also we started developing using pure VBScript, but we will convert a great deal of code to a VC++ COM dll which we can call from our VBScript. In Xchange we also use the message-id for syncing update/insert/delete.

Well, this is the direction we took. Maybe you have better sugestions...