Jump to content

Why are csv files not the same as the data that is held or input on the screen


Recommended Posts

Posted

PHPVMS V7 has a nice import feature from csv files but it seems there are considerable differences between the csv files and what you would input on the screen.  Does anybody know the reason for this such as the Subfleet table has these fields in the csv but you do not input them all on the screen

those marked with   xxxx are input on the screen

airline,type,name,fuel_type,cost_block_hour,cost_delay_minute,ground_handling_multiplier,cargo_capacity,fuel_capacity,gross_weight,fares

 

The others are not input when adding a new Subfleet   two inputs   MAIN HUB and SIMBRIEF TYPE are available for input but do not show on the csv  so that's 6 fields that are not accounted for on the CSV that gets exported or imported and when you look at the 'input/maintain fields on the record 

2 airline_id.  

3 hub_id     

4 type.         

5 simbrief_type

6 name

7 cost_block_hour

8 cost_delay_minute

9 fuel_type

10 ground_handling_multiplier

11 cargo_capacity

12 fuel_capacity

13 gross_weight

There is not even a field for Fares in the database record.

Similar errors and omissions are seen on other tables , it seems that either some of these fields are redundant because of the mew structure of PHPVMS 7 and have been initially copied over from PHPVMS 5 . However as PHPVMS is in a BETA state at present there is opportunity to get these csv file layouts sorted out and prune any redundant fields from these tables if they have been moved elsewhere.  Any thoughts on this can it somebody log it as a 'BUG' to be fixed

 

Posted

As I wrote at GitHub,

 

Missing fields ;

  • hub_id
  • simbrief_type 

Non-Used Extra Fields (which also can be removed from the database, but it is another matter)

  • cargo_capacity
  • fuel_capacity
  • gross_weight

Fares and their relations to subfleets (and flights) is a different subject, I think you will see (code wise) how they work soon :) And I hope your first PR will fix the csv export/import logic of subfleets (at least partially)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...