Welcome, Guest. Please Login.
04/24/24 at 22:03:27
News:
Home Help Search Login


Pages: 1
Send Topic Print
Import Item EVO Notes (Read 2333 times)
BethanyW
Browser
*




Posts: 46
Import Item EVO Notes
11/29/12 at 10:09:22
 
Is there a way to import EVO Notes for Items?
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Import Item EVO Notes
Reply #1 - 11/29/12 at 14:36:46
 
I don't think so.
but you can do it via sql. The name of the table is ISNOTES
and the id is BKICMSTR Plus the Item ID
 
 embarrassed
 
PD: check with ISTECH
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Import Item EVO Notes
Reply #2 - 11/30/12 at 08:31:48
 
Because of the way the notes are currently stored in the WBTRVMEMO file it is not possible but we are working on a change to the structure for the next (year end) update that will store the actual body of the note in the ISNOTES file at which time the import will be possible.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
BethanyW
Browser
*




Posts: 46
Re: Import Item EVO Notes
Reply #3 - 11/30/12 at 10:12:25
 
Thanks to you both!
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Import Item EVO Notes
Reply #4 - 07/12/13 at 08:24:46
 
I have about 5000 items I want to do notes for.
 
What version do I have to be on to be able to do note import ?
 
 
Oh I see I need the latest one.
 
anyone tried it yet ?
 
JW
 
Back to top
 
« Last Edit: 07/12/13 at 09:45:49 by shadowcaster »  
WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Import Item EVO Notes
Reply #5 - 08/21/13 at 07:46:40
 
Really need to do some note imports.
Anyone have any suggestions on how to go about doing this ?
Back to top
 
 
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Import Item EVO Notes
Reply #6 - 08/21/13 at 12:13:09
 
I will have Bethany get in touch with you - she's done quite a lot with it. From what I understand, it's a real pain, but definitely doable.
 
BTW, you do have to be on the next most recent update (March/April?).
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
BethanyW
Browser
*




Posts: 46
Re: Import Item EVO Notes
Reply #7 - 08/22/13 at 05:34:52
 
Sorry shadowcaster, somehow I didn't see your first post.  I'm certainly no expert so there may be a better way, but this is what I've found to work.
 
I suggest using the general import program (UT-A > T7GENIMP) with your import file.  For fields:
  • ID - first 8 characters is table name (append a space if the table is only 7 characters), the rest identifies the record in the table (usually just the ID, but in the case of lines for sales orders, etc. it's slightly more complex)
  • TYPE - note type (e.g. CSN, STD, HID)
  • CDATE - not required, but recommended: as far as I can tell, should be the date of note creation
  • CTIME - same as above: time of note creation
  • CWHO - same as above: user who created note
  • ALPHA - the actual note

If you think you ever might want to change the note via import, make sure each note can be identified in one of the following ways:
  • ID + Type (Key)
  • ID + Type + CDate (Key2)
  • ID + CDate (Key3)
  • ID + Contact (Key4)

If you haven't used the general import program before, or have any questions, let me know.
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
shadowcaster
Active Member
*****


I'm not here because
I know what to do.

Posts: 678
Gender: male
Re: Import Item EVO Notes
Reply #8 - 08/23/13 at 08:19:11
 
Wow thanks.
 
That's sure gives me a place to start !
Back to top
 
 
WWW   IP Logged
Pages: 1
Send Topic Print