Project

General

Profile

importing data into the processing database

Added by Cheri Hampton almost 14 years ago

Hi, I need to import (upload) data to the processing database. Problem is, I don't know where "upload images" is looking or what filepath to use. Will it see other computers on the network? When I try to point it to a file path I get the following error message:
ERROR: Database does not contain instruments for appion image upload


Replies (6)

RE: importing data into the processing database - Added by Amber Herold almost 14 years ago

Hi Cheri,
Your error message indicates that there is not a scope or camera set up for Appion. This should be set up for you automatically during installation for Appion 2.0 or later, so I assume you are using an older version.
You will need to add some values for these fields. It is not important what you enter as it will not affect your upload, but they do need to exist.

To set them:
1. Go to browse to myamiweb/ to view the Appion and Leginon Tools home page.
2. Select the Administration tool
3. Select Instruments
4. Add new instruments AppionTEM and AppionCamera as shown in the attached screenshots
5. Set the Host, Instrument Host,Scope and Camera as shown in the screenshots.

Then try your upload again. When you upload images you can specify the absolute path such as /home/amber/images/imagesToUpload, but the processing server (where the appion python scripts are installed) does need to have access to the path that you specify. In other words, if you are logged into the processing server, you need to be able to change directories to the images you wish to upload.

If you are still having trouble after that please let me know!

AppionCamera.png (213 KB) AppionCamera.png AppionCamera Settings
AppionTEM.png (212 KB) AppionTEM.png AppionTEM settings

RE: importing data into the processing database - Added by Cheri Hampton almost 14 years ago

Well, I was able to add AppionCamera and AppionTEM to the list on the left, but could not set host, instrument, camera across the top. I get an object not found error 404 medssage.

RE: importing data into the processing database - Added by Amber Herold almost 14 years ago

OK, you should be fine without those since they are used for Leginon rather than Appion. Try the upload again and when you see the command the important thing is that --scopeid and --cameraid parameters are set to the scope and camera that you added. I've attached a screenshot showing the command with these values set. If the command is not working you can check your database to make sure the id's in the command are the correct ones (let me know if you need instruction for this). If the ids are missing or incorrect, we will need to troubleshoot your installation.

Screenshot-3.png (146 KB) Screenshot-3.png upload images command

RE: importing data into the processing database - Added by Jason de la Cruz over 13 years ago

Hello,

I have a similar problem. I am getting the following error message after attempting to upload images:

ERROR: Database does not contain instruments for appion image upload

I've tried to import instruments by going to Home > Administration > Instruments. I am able to add, but not remove, instruments (the "Remove" button does not work for me). I therefore have several copies of "AppionCamera" and "AppionTEM" in the left-hand column. How do I remove the duplicates?

Pressing the "Import" button gives me the following 404 error message:

Not Found

The requested URL /myamiweb/';echo $_SERVER['PHP_SELF']; was not found on this server.

Thanks for your help,
--Jason

RE: importing data into the processing database - Added by Amber Herold over 13 years ago

Hi Jason, can you tell me a little more about your installation. Is it older, did you recently update to a newer version, or did you recently install for the first time? Do you know what version you have installed? It looks like your installation did not go quite right.

Also, please check the troubleshooting page to see if it reports any problems.

1. Go to the home page at myamiweb/
2. Click on the [test Dataset] link in the upper left region of the screen
3. You should see an image view with 2 images available and viewable - if not, there is a problem
4. Click on the [Troubleshoot] link in the upper left
5. There are several automated checks that occur.
6. Look for any bright red text. These indicate something that may need your attention, or may cause a problem. Toward the bottom of the page you should see 2 images displayed.

Let me know if the troubleshooter finds any problems.

Also, the Remove button for the instruments may have been disabled intentionally by us. I do not believe it will cause a problem to have duplicates, but I can look into it further if everything else checks out ok.

Thanks,
Amber

Troubleshooter.png (112 KB) Troubleshooter.png Screenshot of Troubleshooter page from AMI's installation

RE: importing data into the processing database - Added by Amber Herold over 13 years ago

Hi Jason,
It looks like perhaps the database initialization code was not run during installation.

Please try running the initialization.
1. browse to YOURHOST/myamiweb/setup
2. Enter your database username and password - if you do not know it, it is listed in the myamiweb/config.php file. You will need access to the web directory to view the file. They are listed under DB_USER and DB_PASS.
3. Just click the next buttons through the wizard. Stop when you get to step 6 "Review Your Setup"
4. Press the "DB Initialization" button located at the top of the page. I have attached an image indicating its location.

If you recieve a message saying the initialization is only required for new Installations and you do not need to do anything, we may need to add the instrument information to your database manually.
Otherwise, try the upload again.

If you have installed PHPMyAdmin, or you are savvy with MySQL, you can check the database directly to ensure the instuments have been added correctly. Here is the data that you should see if the installation is correct (in xml format):
<sqltable name="InstrumentData" >
<field name="name" >AppionTEM</field>
<field name="hostname" >appion</field>
<field name="type" >TEM</field>
</sqltable>
<sqltable name="InstrumentData" >
<field name="name" >AppionCamera</field>
<field name="hostname" >appion</field>
<field name="type" >CCDCamera</field>
</sqltable>

Let me know if you need help adding these values manually if the automatic initialization does not work.

Thanks,
Amber

DBInit.png (79.7 KB) DBInit.png Location of DB Initialization button in setup wizard
    (1-6/6)