I’m evaluating Servoy, but when I try to import or export my data, I get the following message: “Exception during import”, “java.lang.NullPointerException”. This happens as soon as I select “From Text file” or “From Excel file”.
Also, the error messages appear to be mixed up. If I select File, Import, From Excel file, the error message says, “Exception during export”. Likewise if I select File, Export, Export To Excel File, the error message says, “Exception during import”.
Hi Craig
Welcome to Servoy.
Can you advise which database, OS and version of Servoy you are using. From experience do know that Import/Export normally works OK so we should be able to get you started.
Have you tried importing the same text file through one of the database managers - Sybase Central, MySQL/Navicat etc just to eliminate possibility of something in the data.
If you could post a subset of the text file would be happy to test it.
grahamg:
Hi CraigWelcome to Servoy.
Can you advise which database, OS and version of Servoy you are using. From experience do know that Import/Export normally works OK so we should be able to get you started.
Have you tried importing the same text file through one of the database managers - Sybase Central, MySQL/Navicat etc just to eliminate possibility of something in the data.
If you could post a subset of the text file would be happy to test it.
This is a scratch installation on Windows 2003, using the default database. I don’t even get to the point of selecting my import file. The error occurs the moment I select the import text file (or Excel file) option. The version is 3.5.3 Build 516.
Weird problem as that error is coming at an unexpected place. I would expect that error to happen once you trigger an import.
A shot in the dark: test using a layout where you can add and delete records with no errors. Just to rule out any chance that it isn’t the key increment value out of sync or a field constraint or a backend trigger interfering with the process.
Other than that – stumped. Java version issue?
Thanks for the suggestions, but I think the problem was user (my) error. I’ve never used Servoy before, and when I first opened it up and tried to create a new Solution, it asked me some questions that I didn’t know the answer to. So, I just canceled out. Unfortunately, that caused me problems down the road. When I loaded up the sample solutions, the import dialogs came up normally. Sorry for the inconvenience, and thanks for the help.
Two of the error messages are still transposed, though.
Craig