Automatically recognized column names
Verze z 10. 8. 2022, 08:01, kterou vytvořil Jana.safferova (diskuse | příspěvky) (založena nová stránka s textem „Automatically recognized column names“)
Some column names that are assigned to individual stops are recognized automatically.
| Field | One of the possible column names |
| id | id |
| name | name, jmeno, nazev |
| location | location,locationid |
| address | address,adresa |
| y | y,lat,latitude,sirka,lati |
| x | x,lon,longitude,delka,long, |
| demand1 | demand,demand1,weight,weight1,vaha,vaha1,naklad,naklad1,load,load1,poptavka,poptavka1,tonaz |
| demand2 | demand2,weight2,vaha2,naklad2,load2,objem,volume,poptavka2,palety |
| demand3 | demand3,weight3,vaha3,naklad3,load3,poptavka3 |
| demand4 | demand4,weight4,vaha4,naklad4,load4,poptavka4 |
| demand5 | demand5,weight5,vaha5,naklad5,load5,poptavka5 |
| start1 | open,open1,start,start1,from,from1,od,od1,otevreno,otevreno1,zacatek,zacatek1 |
| start2 | open2,start2,from2,od2,otevreno2,otevrenood2,zacatek2 |
| start3 | open3,start3,from3,od3,otevreno3,otevrenood3,zacatek3 |
| start4 | open4,start4,from4,od4,otevreno4,otevrenood4,zacatek4 |
| start5 | open5,start5,from5,od5,otevreno5,otevrenood5,zacatek5 |
| start6 | open6,start6,from6,od6,otevreno6,otevrenood6,zacatek6 |
| start7 | open7,start7,from7,od7,otevreno7,otevrenood7,zacatek7 |
| start8 | open8,start8,from8,od8,otevreno8,otevrenood8,zacatek8 |
| start9 | open9,start9,from9,od9,otevreno9,otevrenood9,zacatek9 |
| start10 | open10,start10,from10,od10,otevreno10,otevrenood10,zacatek10 |
| end1 | close,close1,end,end1,to,to1,do,do1,zavreno,zavreno1,konec,konec1,finish,finish1 |
| end2 | close2,end2,to2,do2,zavreno2,konec2,finish2 |
| end3 | close3,end3,to3,do3,zavreno3,konec3,finish3 |
| end4 | close4,end4,to4,do4,zavreno4,konec4,finish4 |
| end5 | close5,end5,to5,do5,zavreno5,konec5,finish5 |
| end6 | close6,end6,to6,do6,zavreno6,konec6,finish6 |
| end7 | close7,end7,to7,do7,zavreno7,konec7,finish7 |
| end8 | close8,end8,to8,do8,zavreno8,konec8,finish8 |
| end9 | close9,end9,to9,do9,zavreno9,konec9,finish9 |
| end10 | close10,end10,to10,do10,zavreno10,konec10,finish10 |
| duration | duration,doba,skladka,dobaskladky,delkaskladky,trvani |
| admintime | admintime,adminduration,fixedtime,dobaadministrace |
| workingtime | worktime,pracovniminuty,workingtime |
| specialcodes | specialcodes,specialcode,zvlastniznacky,zvlastniznaky,znaky,zvlastniznak,specialniznaky,specialniznak,znak,codes,code |
| precedence | precedence,precedenc,posloupnost |
| headorder | headorder,poradiprid |
| tailorder | tailorder,poradizad |
| info1 | info1,info,poznamka,poznamka1 |
| info2 | info2,poznamka2 |
| info3 | info3,poznamka3 |
| notservedpenalty | notservedpenalty,notservedpenalty,cenaneobslouzeni,cenazaneobslouzeni |
| revenue | revenue,price,obrat,zisk |
| stoptype | stoptype,typzastavky |
| deliveryundetermined | deliveryundetermined,dodanineurceno |
| sourceundetermined | sourceundetermined,zdrojneurcen |
| alwaystryloading | alwaystryloading,vzdyzkusnalozit |
| set | set,skupina |
| product | product,producttype,produkt |
| maxstopsbetweenpickupanddelivery | maxstopsbetweenpickupanddelivery |
| maxminutesbetweenpickupanddelivery | maxminutesbetweenpickupanddelivery |
| open1day | open1day,od1den,otevreno1den |
| open2day to open10day | only the digit changes |
| close1day | close1day,do1den,zavreno1den |
| close2day to close10day | only the digit changes |