josh90

Can anyone help on this please?

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

Hi parkho, I have this trouble too, it's most annoying trying to access on an android device. This was brought up some months ago now, in the thread below: http://forum.phpvms....oid#entry121142 However, the problem still remains unfortunately. Have you considered switching to 'Apple' devices? Josh

Me too, using Android. Josh

Excellent work there flyalaska! Thanks Josh

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

Hi ercio, Check line 108 in the file lib->skins->lance->frontpage_main.tpl edit the image source (src) there. Hope this helps Josh

Hi David, Would just like to express my thanks for taking on the running and development of phpVMS/vaCentral. I'm sure it's appreciated by many, even though it's probably not said often. Keep up the great work. Josh

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

Try core/templates/flown_routes_map.tpl Around line 10

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.

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

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?

Do you still need help with this?

Which skin are you using?

In your layout file, there's probably a line similar to: <title><?php echo $page_title; ?></title> Remove the bits between the title tags and replace with what you wish.

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

Bump.

Great piece of code! Just one question, is there anyway of showing the total amount of airline ranks, for example: Our airline is rank X out of (Total airlines) Thanks Josh

Ok that's great news! Thanks & all the best Josh

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

That sounds like a good idea. I work with PHP mainly, but am by no means an expert. Do website work now and then too. Josh

Sounds like a great idea. I'm willing to help, where I can. Will this be open to only a few people when released like your chat module, or to everyone? I don't mind helping, but I'm all for releasing stuff so everyone can reap the benefits and not only a select few. Thanks, keep up the good work Josh

We use VATSIM and our own FSD network.

Just been reading through this post, looks very interesting. Are there any plans to make any progress on this in the future? Many Thanks Josh