ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Evo Menu & Evo-ERP >> Tables for Evo Notes and Links
http://www.istechforum.com/YaBB.pl?num=1181745313

Message started by GasGiant on 06/13/07 at 07:35:13

Title: Tables for Evo Notes and Links
Post by GasGiant on 06/13/07 at 07:35:13

Where are these blobs of text kept?

Title: Re: Tables for Evo Notes and Links
Post by NovaZyg on 06/13/07 at 07:54:32

All the new notes (memo fields) are accessed through the individual files like notes are in ISNOTES, and the notes for links are in ISLINKS. The File where the actual data is stored is wbtrvmemo.b in the DBAMFG folder.

Title: Re: Tables for Evo Notes and Links
Post by GasGiant on 06/13/07 at 08:24:49

ummm.... how in the world do I access those notes via ODBC? When I grab the IS.NOTE.NOTE field it is empty. It appears to be a reference field, but I can't retrieve the reference, which I assume has something to do with the BTRV.MEM.CNTR field in WBTRVMEMO.B, eh?

[a little Canadian lingo, there]

Title: Re: Tables for Evo Notes and Links
Post by gtladmin on 06/14/07 at 13:33:28

Canadian, eh? I thought you are from Maine, ayuh! ;)

Title: Re: Tables for Evo Notes and Links
Post by GasGiant on 06/14/07 at 15:16:58

I was trying to speak Allen's language. It didn't help.

Title: Re: Tables for Evo Notes and Links
Post by NovaZyg on 06/14/07 at 20:56:03

I have not tried to access the notes using ODBC, I don't need ODBC I have TAS so I can access it directly. To answer you, yes the IS.NOTE.NOTE contains a ref to BTRV.MEM.CNTR, but It is all internal pervasive stuff so I don't know how it is doing the offsets, and like I said until now I had never thought about accessing it with ODBC. I understand why you would want to.. but I am sorry I don't think I can be much help to you here. You can try Tim, KKMFG, or Kellogs, they may have some ideas. :-/

Title: Re: Tables for Evo Notes and Links
Post by daletone on 04/09/12 at 07:31:13

Colin, were you ever able to find a secret key to unlock the Evo Links data in ISLINK? I would really like to be able to use ODBC to look at this data if possible. Anyone else have any ideas?

Title: Re: Tables for Evo Notes and Links
Post by GasGiant on 04/09/12 at 08:12:15

Because the data falls outside of any "company", there is not an easy way to get at the file. I'm not sure its even a PSQL file. It looks like random fields with an encoded index scheme. It has notes from all over the place scattered around in it. It's probably just a big blob of text.

:-/

This was enough of an issue for us that we have stayed with the old notes system by using CSN.

Title: Re: Tables for Evo Notes and Links
Post by Kelloggs on 04/09/12 at 08:57:49

I think, there is a way to "connect" to the WBTRVMEMO.
On your server, open the PCP, add a new database.

If you data is on X:\DBAMFG\default
just use X:\DBAFMG. Called what ever you want then open it. the WBTRVMEMO table will appear as "WBTRVMEMO_B"

:P

Kelloggs

Title: Re: Tables for Evo Notes and Links
Post by GasGiant on 04/09/12 at 09:28:23

Right, but then what? All of the various kinds of notes are mixed together in there. You'd need to use a programing language to pull things out. Reporting tools would likely not be up to the task of even linking that info with SO header info, since that would require linking to two DSNs at once. I guess you might be able to build a new table using Access. Rather beyond the typical Excel or CR user.

Title: Re: Tables for Evo Notes and Links
Post by Kelloggs on 04/09/12 at 10:05:38

Easy to connect: select * from DBAMEMO.WBTRVMEMO_B

where DBAMEMO is the newly created DSN.

Now, we need to figure out how the BTRV_MEM_LINK works

:P

Kelloggs

PD:
same for the notes

select * from DBAMEMO.isnotes_B

;D