archux Posted June 2, 2008 Report Share Posted June 2, 2008 Sveiki! Vēlējos jautāt: "Vai kaut kā var pārvietot datus no xls faila uz datubāzi?" Paldies! Link to comment Share on other sites More sharing options...
andrisp Posted June 2, 2008 Report Share Posted June 2, 2008 Viegla varianta nebuus. http://sourceforge.net/projects/phpexcelreader Link to comment Share on other sites More sharing options...
bubu Posted June 2, 2008 Report Share Posted June 2, 2008 Nu ja dati vienkaarshaa formaataa (like viena tabula pilnaa veidaa), tad var ieseivot failu CSV formaataa, un MySQL'aa ar LOAD ielaadeet. Link to comment Share on other sites More sharing options...
marcis Posted June 3, 2008 Report Share Posted June 3, 2008 Atļaušos nepiekrist andrisp teiktajam. Es tur neko sarežģītu neredzu. Pārglabājam failu csv, ar php atraujam vaļā, nepieciešamības gadījumā pārejam pāri ar iconv(), eksplodējām pa "\n", explodējam pa "\t" un metam datubāzē. Link to comment Share on other sites More sharing options...
andrisp Posted June 3, 2008 Report Share Posted June 3, 2008 marcis, nu jaa - man vienkaarshi ir palicis taads iespaids atminjaa, jo vienu reizi naacaas taisiit webisku importeeshanas sisteemu, kurai jaapadod parasts xls fails. Kaa arii papildus prasiiba bija, ka nav zinaams kaadaa seciibaa var buut kolonas, taapeec jaabuut iespeejai manuaali noraadiit. Nochakareejos diezgan. :) Link to comment Share on other sites More sharing options...
archux Posted June 5, 2008 Author Report Share Posted June 5, 2008 tiku galā, ;) paldies tieši par csv failu ;) importēju uz jaunu datubāzi un tad ar find/replace pieliku klāt visu ko vajag un viss aizgāja ;) Paldies! Link to comment Share on other sites More sharing options...
Recommended Posts