database help

kamilsparrow

Member
Jul 6, 2015
79
2
0
mekai machanla sean eka,,, mata data migration ekak karanna set wela thiyenne, un laga thiyenne dbase database eka, dbf files thiyenawa hatahutaamarak, mata eka fields map karannai thiyenne, awla mokada kiwa nam mata eke eka field ekak save wenne kohetada kiyala hoyaganna baruwai inne, eka nisa hira wela inne mchanla, eka column ekak namak thiyagena eka thiyena table eka mokakda kiyala hiyaganna puluwan widiyak thiyeida??? danna ekek innawa nam kiyala deepan,,,
 

thinking_guy

Well-known member
  • Apr 16, 2011
    4,718
    2,737
    113
    Meka kochchara durata sarthaka weida danne naa machan eth karala balapan. Db eke table godak nathnam okkoma table join karala thani table ekak ganin. Eeta passe eka CSV walata expoprt karagena Excel walin open karala field name eka search karala balapan.
     

    kamilsparrow

    Member
    Jul 6, 2015
    79
    2
    0
    migration eke aulak na machan,,,, data mapin karana eke aulak thiyenne ban,,, me database eka kunu godak ban, tables hadila thiyenne dbf format eken hadila thiyena files godakin, dbf files thiyenawa 3000k withara, anika mewala namak wath na ban tables wala. man karanne machan fake data dala balanawa koi file ekeda save wenne kiyala, ehema hoyala hoyala godak tables hoyagatha, habai karumeta eka field ekak save wena file eka/ table eka hoyganna baruwa dagalanwa, ekin eka open karala balanna ba mcahn la patta welawak yanwa ekata, ekai machan ahuwe table ekaka column name ekak dila e colum eka thiyena dbf file eka hoyaganna widiyak thiyeida kiyala,,, access ekata import karala nam query karanna widiyak thiyenawa console app ekak liyala,, habai aula thiyenne access import karanwa nam thani thani file import karanna wenawa, patta welawak yanwa ban okata arath samahara files import wenneth na eroor ekak paninawa unsupported format kiyala,,
     

    kamilsparrow

    Member
    Jul 6, 2015
    79
    2
    0
    Meka kochchara durata sarthaka weida danne naa machan eth karala balapan. Db eke table godak nathnam okkoma table join karala thani table ekak ganin. Eeta passe eka CSV walata expoprt karagena Excel walin open karala field name eka search karala balapan.

    thani table ekata ganna widiyak danne nane ban,,, thiyeida? kohomda
     

    kamilsparrow

    Member
    Jul 6, 2015
    79
    2
    0
    උඹට තියෙන්නෙ මේ ලින්ක් එකේ තියෙන විදියෙ පොඩි ඇප් එකක් ලියාගෙන ඉම්පෝට් කරන්න. ටේබල් වල නම් වෙනස් කරන්න එපා.

    http://stackoverflow.com/questions/6490091/reading-a-dbase-table-design

    machan meke thani dbf file ekak import karanna neda ban thiyenne, mehe thiyenawa machan files 3000kata wadiya,,,