Jump to content

josh90

Members
 View Profile  See their activity

  • Posts

    31

  • Joined

  • Last visited

 Content Type 

Posts posted by josh90

  2. Unable to import .csv routes

    in Support Forum

    Posted

    Hi,

    One of our admins has brought to my attention that we can no longer import routes from a .csv file. We're trying to import using the template file that sits on our server, that comes with the phpVMS installation. When trying to import this file we get the error ' The import process is complete, added 0 schedules, updated 0, for a total of 0' .

    Attached is the template.csv file with just one fictious route that I'm trying to import as a test.

    This issue has been brought up a number of times on this forum by the looks of it, but I can't find a solution that works for us, things I've tried:

    1. Creating a new blank .xls file, adding the headers as they appear in the template file and adding all fields except the route, leg and distance field, which can be omitted according to 3. of the instructions. One question I've got is, in point 3, it does mention to remove the legs column from the file as it is no longer counted. I can't see a legs column in the template file, or in the database itself so I guess that's correct and is aimed at people who may be using an older version of the template file. After filling out all the fields, I've saved the document as a .csv file.

    2. Saving in two different types of format Windows Comma Seperated (.csv file) and MS-DOS (.csv file) format.

    Things to note:

    1. We're using David Clark's version of phpVMS (5.5-2.x)

    2. MS Excel 2010 to modify the .csv file

    3. We had to re-install phpVMS a few weeks back due to a problem with our host. This feature has worked before then.

    4. Routes can be added singularly using the 'Add Schedule' option in the Admin Centre

    5. The airline, aircraft, dep/arr airports all exist for this test schedule

    6. The schedule number is not already in use

    7. When exporting the schedules, using the 'Export Schedules' option in the Admin Centre, it generates a file called schedules.csv.txt. Does that mean the import file has to be appended with .txt too?

    8. An error is received in MS Excel when saving to .csv format, something along the lines of some features may be removed when saving in this format.

    Thanks in advance

    Josh

    template.csv

  6. how do i change Icons on recent flights front page

    in Support Forum

    Posted

    Got it!!

    thanks do you know a statement to use a few other images in accordance with the airline code?

    like use image A for airline code DLH

    image B for airline code AFR , ad so on...?

    Hi ercio,

    Replace line 108 (in your .tpl/.php file) with this:

    echo '<td><img src="'.fileurl('/path/to/your/images/'.$pirep->code.'.png').'" alt="'.$airline->name.'" /></td>';

    Above code copied/modified from tid:21018 (flyalaska)

    Personally, I'd use the following as the path:

    echo '<td><img src="'.fileurl('/lib/images/'.$pirep->code.'.png').'" alt="'.$airline->name.'" /></td>';

    Obviously, you'll need to create the images for each airline and name them the same as your airline codes e.g. DLH.png, AFR.png (using your example).

    Also, ensure they reside (and are publicly viewable) in the path you are pointing to.

    Hope this helps

    Josh

  9. Awards images showing but name & description not

    in Support Forum

    Posted

    Hi all,

    I am trying to get my pilot's awards to show on their Pilot Centre page. This is the code I am using which is pretty much the standard built into phpvms. The award images show just fine, but for some reason the name and description won't.

    <div class="inner-content-box">
 <ul class="icons-list">
<?php
if(!$allawards) {
echo '<li><i class="fa fa-trophy icon-large"></i> No awards yet</li>';
} else {

/* To show the image:
 <img src="<?php echo $award->image?>" alt="<?php echo $award->descrip?>" />
*/

?>
	 </ul>
<ul class="icons-list">
<?php foreach($allawards as $award){ ?>
<li><img src="<?php echo $award->image?>" alt="<?php echo $award->name ?> - <?php echo $award->descrip?>" /></li>
<?php } ?>


</ul>
<?php
}
?>
	 </div>

    Any ideas anyone? I've tried various combinations of coding but the name and description just never show up.

    Hi Harry,

    Hope you're well. Based on your current code, the only time the name and description will display is if there's a problem displaying the image, as the name and description are being used as a textual alternative using the "alt" attribute. If you wish to display the name and image, you'll have to "echo" these too.

    Try replacing your code with (notice the addition on line 17):

    <div class="inner-content-box">
 <ul class="icons-list">
<?php
if(!$allawards) {
echo '<li><i class="fa fa-trophy icon-large"></i> No awards yet</li>';
} else {

/* To show the image:
 <img src="<?php echo $award->image?>" alt="<?php echo $award->descrip?>" />
*/

?>
	 </ul>
<ul class="icons-list">
<?php foreach($allawards as $award){ ?>
<li><img src="<?php echo $award->image?>" alt="<?php echo $award->name ?> - <?php echo $award->descrip?>" />
<?php echo $award->name ?> - <?php echo $award->descrip?></li>
<?php } ?>


</ul>
<?php
}
?>
	 </div>

    Hope this helps

    Josh

  11. Can't login as admin anymore

    in Support Forum

    Posted

    You could try creating another account, using the registration form, accept/register that account, then try to connect with the client using that account. If that works ok, try giving admin permissions to that account, using the one that currently works and see what happens.

  12. Can't login as admin anymore

    in Support Forum

    Posted

    I think my previous post failed to post....

    Until a few weeks ago I was able to login to the site as administrator and do all administrative activities. Today when I use those same credentials (I have not changed them) results in me being brought to a login page asking for my login credentials. I doesn't go further than that.

    However, when I used the kACARS Free client 1.0.1 (latest) using those same credentials, I managed to log in to the system using the kACARS client but NOT on the website.

    I then used the password reset and it said it sent a password reset link to my account but I never receive it. I checked the email address on the database and it is correct. But in the meantime due to the password reset, the system has reset my password to something unknown so now I can't even login with kACARS either.

    Have you got a recent backup of your database for phpVMS?

    Have you got anyone else registered with administration permissions? Has the same happened to them?

    Thanks

  13. Retire if hours are 0

    in Support Forum

    Posted

    Hello,

    I think you may need another variable, to consider. Otherwise you may end up retiring new pilots, as most will probably start with 0 hours (unless they have some transferred). Perhaps something like if they've been registered for X days and 0 hours have been logged?

  17. Total Airlines

    in Code Snippets

    Posted

    Hello,

    Perhaps you could use something like:

    <?php
$querydb ="SELECT count(name) AS total FROM phpvms_airlines";
$dbrow = DB::get_row($querydb);
echo $dbrow->total;
?>

    Just checks how many rows are in your phpvms_airlines table, each airline has their own row, so just counts them up.

    Hope it helps

    Josh

  21. Updating routes(solved)

    in Support Forum

    Posted

    I know if you import a csv file it removes all the flight bids that have been made but can you add/edit routes individulay in admin without it affecting the bids already made?

    Hi Matt,

    If I understand your question correctly. You can add individual routes by going into the admin centre->airline operations->flight schedules and routes->top left yellow sticky, "Add Schedule".

    For you to add the route, you need to make sure the airport is in your airport list. If not add it by admin centre->airline operations->add and edit airports->top left yellow sticky, "Add a new airport".

    Doing it this way should not alter Flight Bids already made.

    Josh

×
×
  • Create New...