"New From TNJ"

jarrod's Avatar

jarrod

15 Jun, 2011 04:17 AM

Hi again guys,

Trying to import tnj files into v4. Any file containing images is failing with an "Incorrect integer value" error (see attached image).
I can import our original tnj files that contains no images, just data (student and school info).

I've tried to merge newer tnj containing images with an existing job in v4. This also error with a similar issue ("ParentID" error)

Thought maybe a field was set to integer instead of text. But changed all to text and error still occurring.

Any ideas

  1. Support Staff 1 Posted by Dino Apolito on 15 Jun, 2011 04:38 AM

    Dino Apolito's Avatar

    Jarrod, did you attach the screen grab? Don't see it. Also can you tell us the version you're running?

    Dino

  2. 2 Posted by jarrod on 15 Jun, 2011 04:40 AM

    jarrod's Avatar

    I did, have attached again
    running 4.01

  3. 3 Posted by Richard Browne on 15 Jun, 2011 08:17 AM

    Richard Browne's Avatar

    Hi Jarrod, do you have a small TNJ you could give us to try? I need to see if I can reproduce this here. You can ftp it to our web site at www.timestone.com.au.

  4. 4 Posted by jarrod on 17 Jun, 2011 04:30 AM

    jarrod's Avatar

    Thanks Richard,

    Cannot connect anonymously to ftp
    Do i need user/pass?

  5. 5 Posted by Richard Browne on 22 Jun, 2011 02:11 AM

    Richard Browne's Avatar

    Hi Jarrod, Peter is looking at this problem. He will let you know when he has something.

  6. 6 Posted by Richard Browne on 28 Jun, 2011 05:06 AM

    Richard Browne's Avatar

    Hi Jarrod, I have a fix for the incorrect IntegerValue problem. There are a couple of subjects in your TNJ with an OrderNumber of " " (note the space) which MySQL rejects because it is not a number. I changed our code to just ignore blank strings.

    However I think the incorrect ParentID problem will be a different issue. Can you give me a tnj that gives that error?

  7. 7 Posted by jarrod on 28 Jun, 2011 06:38 AM

    jarrod's Avatar

    That was the same tnj file, I was trying other was to import.
    I imported the original tnj, data only, then merged the tnj with the images.
    thats how i get the ParentID error

    Jarrod Wouters
    Lab - IT

    schoolpix
    P. (03) 9796 3380
    F. (03) 9796 3680
    www.schoolpix.com.au <http://www.schoolpix.com.au>

  8. 8 Posted by Richard Browne on 28 Jun, 2011 11:09 AM

    Richard Browne's Avatar

    Jarrod, I have a fix for both problems. Can you try this version for me and let me know how you go:

    http://www.timestone.com.au/bin/InstallNeoPackPro(v4_0_2beta110628)...

  9. 9 Posted by Richard Browne on 18 Jul, 2011 03:12 AM

    Richard Browne's Avatar

    Hi Jarrod, how did you go with the update I sent you?

  10. 10 Posted by jarrod on 18 Jul, 2011 06:46 AM

    jarrod's Avatar

    Hi Richard,

    Yep, fixed those two issues, thanks

    Jarrod Wouters
    Lab - IT

    schoolpix
    P. (03) 9796 3380
    F. (03) 9796 3680
    www.schoolpix.com.au <http://www.schoolpix.com.au>

  11. Richard Browne closed this discussion on 18 Jul, 2011 07:51 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac