Tango.info database: Difference between revisions

Latest revision as of 2015-01-25T01:07:15

@@ Line 1: / Line 1: @@
-== Links to other websites ==
-=== Existing links ===
-==== Shops ====
-Tango.info is now offering direct links to
-* amazon
-* zivals/tangostore
-* dym (for the Label DYM online)
-* tangocd.com
-* freshsoundrecords (for El Bandoneon + Blue Moon)
-Example for all but DYM and freshsound
+== Structure ==
-*http://www.tango.info/00828766933420 (incl. link to tangcd.com player)
+* [[tango.info music data structure]]
-Example for DYM
+== Changes ==
-*http://www.tango.info/04024236200245
+* [[tango.info music track metadata submissions]]
-==== Audio snippets ====
+== Usage ==
-* tangocd.com
+* [[tango.info music data usage]]
-* amazon (sometimes has audio snippets, no marking in tango.info yet )
-* DYM (Label DYM online has snippets, but no track link possible)
-=== New links ===
+== Workflow within tango.info ==
-To add new shops tango.info needs
+# ODS -export as--> CSV
-* a list mapping the product code of the shop to GTINs or TINs
+# ---upload to--> Server
+# ---load into---> MySQL table
+# alter data via script
+## ---add data via script---> to MYSQL table where data was loaded to
+##* the statistics
+##* the [[Tango.info az 09 name]]
+## ---add data to---> other MySQL tables
+##* table person_role, person_track, person_work to avoid using searches with LIKE %...%, since the ODS contains fields that contain comma-separated values (not 1NF)
+# output
+##--use on --> website
+##use for download ([[tango.info opendata]])