In [12]:
data = """
Ontology based affective context representation
KI Benta, A Rarău, M Cremene
Proceedings of the 2007 Euro American conference on Telematics and …
	37
*
	2007
Multimedia m-learning using mobile phones
KI Benta, M Cremene, R Padurean
Mobilelearning anytimeeverywhere, 27
	24	2005
Towards an Affective Aware Home, ICOST’09, LNCS, vol. 5597
KI Benţa, M Cremene, V Todica
Springer
	23
*
	2009
Agent based smart house platform with affective control
KI Benta, A Hoszu, L Văcariu, O Creţ
Proceedings of the 2009 Euro American Conference on Telematics and …
	22	2009
Evaluation of a system for realtime valence assessment of spontaneous facial expressions
KI Benţa, H Van Kuilenburg, UX Eligio, M den Uyl, M Cremene, A Hoszu, ...
Distributed environments adaptability, semantics and security issues …
	20
*
	2009
Affective aware museum guide
KI Benta
IEEE International Workshop on Wireless and Mobile Technologies in Education …
	11	2005
A multimodal affective monitoring tool for mobile learning
KI Benta, M Cremene, MF Vaida
2015 14th RoEduNet International Conference-Networking in Education and …
	9	2015
Towards real-life facial expression recognition systems
KI Bența, MF Vaida
AECE 15 (2), 93-102
	5	2015
Multifaceted based language for pervasive services with deterministic and fully defined behavior
A Rarau, KI Benta, M Cremene
IEEE International Conference on Pervasive Services, 76-79
	5	2007
Towards a Unified 3D Affective Model
KI Benţa, HI Lisei, M Cremene
Proc. Consortium Proceedings of International Conference on Affective …
	4
*
	2007
Groupware refinements for collaborative teams
MF Vaida, KI Benţa
2015 14th RoEduNet International Conference-Networking in Education and …
	3	2015
Training the behaviour preferences on context changes
KI Benta, M Cremene, A Hoszu
Electronic Communications of the EASST 28
	3	2010
Dezvoltarea de aplicaţii pentru terminale mobile
M Cremene, KI Benţa
Editura Albastră
	2	2006
Mood based services for mobile phone environment
KI Benta, R Pãdurean, M Cremerie
	2	
SPEAKEASY-A MOBILE ASSISTANT FOR THE MANAGEMENT OF SOCIAL ANXIETY IN SPEECH SITUATIONS
KI Benta, M Cremene, SA Matu, IR Podina
Acta Technica Napocensis 56 (3), 29
	1	2015
Adaptation mechanism based on service-context distance for ubiquitous computing
M Cremene, M Riveill, A Rarau, C Miron, I Benta, V Todica
International Journal of Computers Communications & Control 7 (1), 53-60
	1	2012
Secondary emotions deduction from context
KI Benţa, M Cremene, NR Gibă, UX Eligio, A Rarău
Innovations and Advances in Computer Sciences and Engineering, 165-170
	1	2010
Terra Incognita 4-The European Adventure: a collaborative, affective-aware, SMS and web-based learning system
KI Benţa, I Szakáts, R Szakáts
	1	2007
Data distribution platform for multimedia mobile applications
M Cremene, M Riveill, I Benta
Proceedings of the 2nd French-speaking conference on Mobility and ubiquity …
	1	2005
The Affinity Platform: Modular Architecture based on Independent Components
A Ardelean, KI Bența
Proceedings of the International Conference on Software Engineering and …
		2019
AFFECTIVE PERSONALISED CONTEXT AWARE SYSTEMS
PPEC MIRON
Technical University of Cluj-Napoca
		2010
Sisteme senzitive la context personalizate afectiv
KI Benţa
		2010
Sisteme senzitive la context
AE Rarău, M Cremene, KI Benţa
Editura Albastră
		2008
mMVC - an Architecture Design Pattern for Mobile Applications
M Cremene, L Chira, C Loghin, I Benta
Sci. Ann. Cuza Univ. 15, 81-90
		2004
Using a multimedia database for tele-diagnosis and alternative tele-education methods
L Chiorean, MF Vaida, I Benta
		
Elemente practice de bază pentru programarea în limbajul C
LD Chiorean, KI Benţa, MF Vaida, PG Pop, C Strileţchi
C++-editia a doua adaugita
		
Une approche de type optimisation pour l’auto-adaptation de services mobiles
M Cremene, KI Benta, M Riveill
Mobilité et Ubiquité 2011 UBIMOB’11
		
Aplicatii cu senzitivitate autonoma la context
M Cremene, A Rarau, KI Benta, V Todica, C Miron
		
Starea actuala in domeniile aplicatiilor senzitive la context si adaptarii autonome
M Cremene, A Rarau, KI Benta, V Todica, C Miron
		
GESTION DU TRAVAIL INTELLECTUEL-FORMATION EN INFORMATIQUE
I Bența
Le Colloque Francophone sur le Style de Vie Sain des Jeunes 10, 86
"""

In [13]:
def IsDate(line):
    for c in line:
        if c not in "1234567890 ":
            return False
    return True

In [14]:
def AnalyzeLine(line):
    title = ""
    auth = ""
    affil = ""
    date = ""
    
    for l in line.split('\n'):
        if l == "":
            continue
        
        if IsDate(l):
            date = l
            print("date: ", l)
        else:
            if title == "":
                title = l
            elif auth == "":
                auth = l
            elif affil == "":
                affil = l
            print("entry: ", l)
            
    return title, auth, affil, date

In [15]:
pubs = []
for line in data.split('\t'):
    if len(line) < 10:
        continue
    print("--- current line: with length {0} ---\n".format(len(line)), line)
    title, auth, affil, date = AnalyzeLine(line)
    print("title = ", title)
    print("auth = ", auth)
    print("affil = ", affil)
    print("date = ", date)
    print('---- \n')
    pubs.append((title, auth, affil, date))


--- current line: with length 147 ---
 
Ontology based affective context representation
KI Benta, A Rarău, M Cremene
Proceedings of the 2007 Euro American conference on Telematics and …

entry:  Ontology based affective context representation
entry:  KI Benta, A Rarău, M Cremene
entry:  Proceedings of the 2007 Euro American conference on Telematics and …
title =  Ontology based affective context representation
auth =  KI Benta, A Rarău, M Cremene
affil =  Proceedings of the 2007 Euro American conference on Telematics and …
date =  
---- 

--- current line: with length 116 ---
 2007
Multimedia m-learning using mobile phones
KI Benta, M Cremene, R Padurean
Mobilelearning anytimeeverywhere, 27

date:  2007
entry:  Multimedia m-learning using mobile phones
entry:  KI Benta, M Cremene, R Padurean
entry:  Mobilelearning anytimeeverywhere, 27
title =  Multimedia m-learning using mobile phones
auth =  KI Benta, M Cremene, R Padurean
affil =  Mobilelearning anytimeeverywhere, 27
date =  2007
---- 

--- current line: with length 103 ---
 2005
Towards an Affective Aware Home, ICOST’09, LNCS, vol. 5597
KI Benţa, M Cremene, V Todica
Springer

date:  2005
entry:  Towards an Affective Aware Home, ICOST’09, LNCS, vol. 5597
entry:  KI Benţa, M Cremene, V Todica
entry:  Springer
title =  Towards an Affective Aware Home, ICOST’09, LNCS, vol. 5597
auth =  KI Benţa, M Cremene, V Todica
affil =  Springer
date =  2005
---- 

--- current line: with length 167 ---
 2009
Agent based smart house platform with affective control
KI Benta, A Hoszu, L Văcariu, O Creţ
Proceedings of the 2009 Euro American Conference on Telematics and …

date:  2009
entry:  Agent based smart house platform with affective control
entry:  KI Benta, A Hoszu, L Văcariu, O Creţ
entry:  Proceedings of the 2009 Euro American Conference on Telematics and …
title =  Agent based smart house platform with affective control
auth =  KI Benta, A Hoszu, L Văcariu, O Creţ
affil =  Proceedings of the 2009 Euro American Conference on Telematics and …
date =  2009
---- 

--- current line: with length 239 ---
 2009
Evaluation of a system for realtime valence assessment of spontaneous facial expressions
KI Benţa, H Van Kuilenburg, UX Eligio, M den Uyl, M Cremene, A Hoszu, ...
Distributed environments adaptability, semantics and security issues …

date:  2009
entry:  Evaluation of a system for realtime valence assessment of spontaneous facial expressions
entry:  KI Benţa, H Van Kuilenburg, UX Eligio, M den Uyl, M Cremene, A Hoszu, ...
entry:  Distributed environments adaptability, semantics and security issues …
title =  Evaluation of a system for realtime valence assessment of spontaneous facial expressions
auth =  KI Benţa, H Van Kuilenburg, UX Eligio, M den Uyl, M Cremene, A Hoszu, ...
affil =  Distributed environments adaptability, semantics and security issues …
date =  2009
---- 

--- current line: with length 122 ---
 2009
Affective aware museum guide
KI Benta
IEEE International Workshop on Wireless and Mobile Technologies in Education …

date:  2009
entry:  Affective aware museum guide
entry:  KI Benta
entry:  IEEE International Workshop on Wireless and Mobile Technologies in Education …
title =  Affective aware museum guide
auth =  KI Benta
affil =  IEEE International Workshop on Wireless and Mobile Technologies in Education …
date =  2009
---- 

--- current line: with length 168 ---
 2005
A multimodal affective monitoring tool for mobile learning
KI Benta, M Cremene, MF Vaida
2015 14th RoEduNet International Conference-Networking in Education and …

date:  2005
entry:  A multimodal affective monitoring tool for mobile learning
entry:  KI Benta, M Cremene, MF Vaida
entry:  2015 14th RoEduNet International Conference-Networking in Education and …
title =  A multimodal affective monitoring tool for mobile learning
auth =  KI Benta, M Cremene, MF Vaida
affil =  2015 14th RoEduNet International Conference-Networking in Education and …
date =  2005
---- 

--- current line: with length 100 ---
 2015
Towards real-life facial expression recognition systems
KI Bența, MF Vaida
AECE 15 (2), 93-102

date:  2015
entry:  Towards real-life facial expression recognition systems
entry:  KI Bența, MF Vaida
entry:  AECE 15 (2), 93-102
title =  Towards real-life facial expression recognition systems
auth =  KI Bența, MF Vaida
affil =  AECE 15 (2), 93-102
date =  2015
---- 

--- current line: with length 190 ---
 2015
Multifaceted based language for pervasive services with deterministic and fully defined behavior
A Rarau, KI Benta, M Cremene
IEEE International Conference on Pervasive Services, 76-79

date:  2015
entry:  Multifaceted based language for pervasive services with deterministic and fully defined behavior
entry:  A Rarau, KI Benta, M Cremene
entry:  IEEE International Conference on Pervasive Services, 76-79
title =  Multifaceted based language for pervasive services with deterministic and fully defined behavior
auth =  A Rarau, KI Benta, M Cremene
affil =  IEEE International Conference on Pervasive Services, 76-79
date =  2015
---- 

--- current line: with length 144 ---
 2007
Towards a Unified 3D Affective Model
KI Benţa, HI Lisei, M Cremene
Proc. Consortium Proceedings of International Conference on Affective …

date:  2007
entry:  Towards a Unified 3D Affective Model
entry:  KI Benţa, HI Lisei, M Cremene
entry:  Proc. Consortium Proceedings of International Conference on Affective …
title =  Towards a Unified 3D Affective Model
auth =  KI Benţa, HI Lisei, M Cremene
affil =  Proc. Consortium Proceedings of International Conference on Affective …
date =  2007
---- 

--- current line: with length 144 ---
 2007
Groupware refinements for collaborative teams
MF Vaida, KI Benţa
2015 14th RoEduNet International Conference-Networking in Education and …

date:  2007
entry:  Groupware refinements for collaborative teams
entry:  MF Vaida, KI Benţa
entry:  2015 14th RoEduNet International Conference-Networking in Education and …
title =  Groupware refinements for collaborative teams
auth =  MF Vaida, KI Benţa
affil =  2015 14th RoEduNet International Conference-Networking in Education and …
date =  2007
---- 

--- current line: with length 130 ---
 2015
Training the behaviour preferences on context changes
KI Benta, M Cremene, A Hoszu
Electronic Communications of the EASST 28

date:  2015
entry:  Training the behaviour preferences on context changes
entry:  KI Benta, M Cremene, A Hoszu
entry:  Electronic Communications of the EASST 28
title =  Training the behaviour preferences on context changes
auth =  KI Benta, M Cremene, A Hoszu
affil =  Electronic Communications of the EASST 28
date =  2015
---- 

--- current line: with length 91 ---
 2010
Dezvoltarea de aplicaţii pentru terminale mobile
M Cremene, KI Benţa
Editura Albastră

date:  2010
entry:  Dezvoltarea de aplicaţii pentru terminale mobile
entry:  M Cremene, KI Benţa
entry:  Editura Albastră
title =  Dezvoltarea de aplicaţii pentru terminale mobile
auth =  M Cremene, KI Benţa
affil =  Editura Albastră
date =  2010
---- 

--- current line: with length 87 ---
 2006
Mood based services for mobile phone environment
KI Benta, R Pãdurean, M Cremerie

date:  2006
entry:  Mood based services for mobile phone environment
entry:  KI Benta, R Pãdurean, M Cremerie
title =  Mood based services for mobile phone environment
auth =  KI Benta, R Pãdurean, M Cremerie
affil =  
date =  2006
---- 

--- current line: with length 164 ---
 
SPEAKEASY-A MOBILE ASSISTANT FOR THE MANAGEMENT OF SOCIAL ANXIETY IN SPEECH SITUATIONS
KI Benta, M Cremene, SA Matu, IR Podina
Acta Technica Napocensis 56 (3), 29

entry:  SPEAKEASY-A MOBILE ASSISTANT FOR THE MANAGEMENT OF SOCIAL ANXIETY IN SPEECH SITUATIONS
entry:  KI Benta, M Cremene, SA Matu, IR Podina
entry:  Acta Technica Napocensis 56 (3), 29
title =  SPEAKEASY-A MOBILE ASSISTANT FOR THE MANAGEMENT OF SOCIAL ANXIETY IN SPEECH SITUATIONS
auth =  KI Benta, M Cremene, SA Matu, IR Podina
affil =  Acta Technica Napocensis 56 (3), 29
date =  
---- 

--- current line: with length 216 ---
 2015
Adaptation mechanism based on service-context distance for ubiquitous computing
M Cremene, M Riveill, A Rarau, C Miron, I Benta, V Todica
International Journal of Computers Communications & Control 7 (1), 53-60

date:  2015
entry:  Adaptation mechanism based on service-context distance for ubiquitous computing
entry:  M Cremene, M Riveill, A Rarau, C Miron, I Benta, V Todica
entry:  International Journal of Computers Communications & Control 7 (1), 53-60
title =  Adaptation mechanism based on service-context distance for ubiquitous computing
auth =  M Cremene, M Riveill, A Rarau, C Miron, I Benta, V Todica
affil =  International Journal of Computers Communications & Control 7 (1), 53-60
date =  2015
---- 

--- current line: with length 167 ---
 2012
Secondary emotions deduction from context
KI Benţa, M Cremene, NR Gibă, UX Eligio, A Rarău
Innovations and Advances in Computer Sciences and Engineering, 165-170

date:  2012
entry:  Secondary emotions deduction from context
entry:  KI Benţa, M Cremene, NR Gibă, UX Eligio, A Rarău
entry:  Innovations and Advances in Computer Sciences and Engineering, 165-170
title =  Secondary emotions deduction from context
auth =  KI Benţa, M Cremene, NR Gibă, UX Eligio, A Rarău
affil =  Innovations and Advances in Computer Sciences and Engineering, 165-170
date =  2012
---- 

--- current line: with length 146 ---
 2010
Terra Incognita 4-The European Adventure: a collaborative, affective-aware, SMS and web-based learning system
KI Benţa, I Szakáts, R Szakáts

date:  2010
entry:  Terra Incognita 4-The European Adventure: a collaborative, affective-aware, SMS and web-based learning system
entry:  KI Benţa, I Szakáts, R Szakáts
title =  Terra Incognita 4-The European Adventure: a collaborative, affective-aware, SMS and web-based learning system
auth =  KI Benţa, I Szakáts, R Szakáts
affil =  
date =  2010
---- 

--- current line: with length 174 ---
 2007
Data distribution platform for multimedia mobile applications
M Cremene, M Riveill, I Benta
Proceedings of the 2nd French-speaking conference on Mobility and ubiquity …

date:  2007
entry:  Data distribution platform for multimedia mobile applications
entry:  M Cremene, M Riveill, I Benta
entry:  Proceedings of the 2nd French-speaking conference on Mobility and ubiquity …
title =  Data distribution platform for multimedia mobile applications
auth =  M Cremene, M Riveill, I Benta
affil =  Proceedings of the 2nd French-speaking conference on Mobility and ubiquity …
date =  2007
---- 

--- current line: with length 176 ---
 2005
The Affinity Platform: Modular Architecture based on Independent Components
A Ardelean, KI Bența
Proceedings of the International Conference on Software Engineering and …

date:  2005
entry:  The Affinity Platform: Modular Architecture based on Independent Components
entry:  A Ardelean, KI Bența
entry:  Proceedings of the International Conference on Software Engineering and …
title =  The Affinity Platform: Modular Architecture based on Independent Components
auth =  A Ardelean, KI Bența
affil =  Proceedings of the International Conference on Software Engineering and …
date =  2005
---- 

--- current line: with length 97 ---
 2019
AFFECTIVE PERSONALISED CONTEXT AWARE SYSTEMS
PPEC MIRON
Technical University of Cluj-Napoca

date:  2019
entry:  AFFECTIVE PERSONALISED CONTEXT AWARE SYSTEMS
entry:  PPEC MIRON
entry:  Technical University of Cluj-Napoca
title =  AFFECTIVE PERSONALISED CONTEXT AWARE SYSTEMS
auth =  PPEC MIRON
affil =  Technical University of Cluj-Napoca
date =  2019
---- 

--- current line: with length 65 ---
 2010
Sisteme senzitive la context personalizate afectiv
KI Benţa

date:  2010
entry:  Sisteme senzitive la context personalizate afectiv
entry:  KI Benţa
title =  Sisteme senzitive la context personalizate afectiv
auth =  KI Benţa
affil =  
date =  2010
---- 

--- current line: with length 81 ---
 2010
Sisteme senzitive la context
AE Rarău, M Cremene, KI Benţa
Editura Albastră

date:  2010
entry:  Sisteme senzitive la context
entry:  AE Rarău, M Cremene, KI Benţa
entry:  Editura Albastră
title =  Sisteme senzitive la context
auth =  AE Rarău, M Cremene, KI Benţa
affil =  Editura Albastră
date =  2010
---- 

--- current line: with length 136 ---
 2008
mMVC - an Architecture Design Pattern for Mobile Applications
M Cremene, L Chira, C Loghin, I Benta
Sci. Ann. Cuza Univ. 15, 81-90

date:  2008
entry:  mMVC - an Architecture Design Pattern for Mobile Applications
entry:  M Cremene, L Chira, C Loghin, I Benta
entry:  Sci. Ann. Cuza Univ. 15, 81-90
title =  mMVC - an Architecture Design Pattern for Mobile Applications
auth =  M Cremene, L Chira, C Loghin, I Benta
affil =  Sci. Ann. Cuza Univ. 15, 81-90
date =  2008
---- 

--- current line: with length 121 ---
 2004
Using a multimedia database for tele-diagnosis and alternative tele-education methods
L Chiorean, MF Vaida, I Benta

date:  2004
entry:  Using a multimedia database for tele-diagnosis and alternative tele-education methods
entry:  L Chiorean, MF Vaida, I Benta
title =  Using a multimedia database for tele-diagnosis and alternative tele-education methods
auth =  L Chiorean, MF Vaida, I Benta
affil =  
date =  2004
---- 

--- current line: with length 141 ---
 
Elemente practice de bază pentru programarea în limbajul C
LD Chiorean, KI Benţa, MF Vaida, PG Pop, C Strileţchi
C++-editia a doua adaugita

entry:  Elemente practice de bază pentru programarea în limbajul C
entry:  LD Chiorean, KI Benţa, MF Vaida, PG Pop, C Strileţchi
entry:  C++-editia a doua adaugita
title =  Elemente practice de bază pentru programarea în limbajul C
auth =  LD Chiorean, KI Benţa, MF Vaida, PG Pop, C Strileţchi
affil =  C++-editia a doua adaugita
date =  
---- 

--- current line: with length 145 ---
 
Une approche de type optimisation pour l’auto-adaptation de services mobiles
M Cremene, KI Benta, M Riveill
Mobilité et Ubiquité 2011 UBIMOB’11

entry:  Une approche de type optimisation pour l’auto-adaptation de services mobiles
entry:  M Cremene, KI Benta, M Riveill
entry:  Mobilité et Ubiquité 2011 UBIMOB’11
title =  Une approche de type optimisation pour l’auto-adaptation de services mobiles
auth =  M Cremene, KI Benta, M Riveill
affil =  Mobilité et Ubiquité 2011 UBIMOB’11
date =  
---- 

--- current line: with length 96 ---
 
Aplicatii cu senzitivitate autonoma la context
M Cremene, A Rarau, KI Benta, V Todica, C Miron

entry:  Aplicatii cu senzitivitate autonoma la context
entry:  M Cremene, A Rarau, KI Benta, V Todica, C Miron
title =  Aplicatii cu senzitivitate autonoma la context
auth =  M Cremene, A Rarau, KI Benta, V Todica, C Miron
affil =  
date =  
---- 

--- current line: with length 133 ---
 
Starea actuala in domeniile aplicatiilor senzitive la context si adaptarii autonome
M Cremene, A Rarau, KI Benta, V Todica, C Miron

entry:  Starea actuala in domeniile aplicatiilor senzitive la context si adaptarii autonome
entry:  M Cremene, A Rarau, KI Benta, V Todica, C Miron
title =  Starea actuala in domeniile aplicatiilor senzitive la context si adaptarii autonome
auth =  M Cremene, A Rarau, KI Benta, V Todica, C Miron
affil =  
date =  
---- 

--- current line: with length 134 ---
 
GESTION DU TRAVAIL INTELLECTUEL-FORMATION EN INFORMATIQUE
I Bența
Le Colloque Francophone sur le Style de Vie Sain des Jeunes 10, 86

entry:  GESTION DU TRAVAIL INTELLECTUEL-FORMATION EN INFORMATIQUE
entry:  I Bența
entry:  Le Colloque Francophone sur le Style de Vie Sain des Jeunes 10, 86
title =  GESTION DU TRAVAIL INTELLECTUEL-FORMATION EN INFORMATIQUE
auth =  I Bența
affil =  Le Colloque Francophone sur le Style de Vie Sain des Jeunes 10, 86
date =  
---- 


In [16]:
for paper in pubs:
    print(paper)


('Ontology based affective context representation', 'KI Benta, A Rarău, M Cremene', 'Proceedings of the 2007 Euro American conference on Telematics and …', '')
('Multimedia m-learning using mobile phones', 'KI Benta, M Cremene, R Padurean', 'Mobilelearning anytimeeverywhere, 27', '2007')
('Towards an Affective Aware Home, ICOST’09, LNCS, vol. 5597', 'KI Benţa, M Cremene, V Todica', 'Springer', '2005')
('Agent based smart house platform with affective control', 'KI Benta, A Hoszu, L Văcariu, O Creţ', 'Proceedings of the 2009 Euro American Conference on Telematics and …', '2009')
('Evaluation of a system for realtime valence assessment of spontaneous facial expressions', 'KI Benţa, H Van Kuilenburg, UX Eligio, M den Uyl, M Cremene, A Hoszu, ...', 'Distributed environments adaptability, semantics and security issues …', '2009')
('Affective aware museum guide', 'KI Benta', 'IEEE International Workshop on Wireless and Mobile Technologies in Education …', '2009')
('A multimodal affective monitoring tool for mobile learning', 'KI Benta, M Cremene, MF Vaida', '2015 14th RoEduNet International Conference-Networking in Education and …', '2005')
('Towards real-life facial expression recognition systems', 'KI Bența, MF Vaida', 'AECE 15 (2), 93-102', '2015')
('Multifaceted based language for pervasive services with deterministic and fully defined behavior', 'A Rarau, KI Benta, M Cremene', 'IEEE International Conference on Pervasive Services, 76-79', '2015')
('Towards a Unified 3D Affective Model', 'KI Benţa, HI Lisei, M Cremene', 'Proc. Consortium Proceedings of International Conference on Affective …', '2007')
('Groupware refinements for collaborative teams', 'MF Vaida, KI Benţa', '2015 14th RoEduNet International Conference-Networking in Education and …', '2007')
('Training the behaviour preferences on context changes', 'KI Benta, M Cremene, A Hoszu', 'Electronic Communications of the EASST 28', '2015')
('Dezvoltarea de aplicaţii pentru terminale mobile', 'M Cremene, KI Benţa', 'Editura Albastră', '2010')
('Mood based services for mobile phone environment', 'KI Benta, R Pãdurean, M Cremerie', '', '2006')
('SPEAKEASY-A MOBILE ASSISTANT FOR THE MANAGEMENT OF SOCIAL ANXIETY IN SPEECH SITUATIONS', 'KI Benta, M Cremene, SA Matu, IR Podina', 'Acta Technica Napocensis 56 (3), 29', '')
('Adaptation mechanism based on service-context distance for ubiquitous computing', 'M Cremene, M Riveill, A Rarau, C Miron, I Benta, V Todica', 'International Journal of Computers Communications & Control 7 (1), 53-60', '2015')
('Secondary emotions deduction from context', 'KI Benţa, M Cremene, NR Gibă, UX Eligio, A Rarău', 'Innovations and Advances in Computer Sciences and Engineering, 165-170', '2012')
('Terra Incognita 4-The European Adventure: a collaborative, affective-aware, SMS and web-based learning system', 'KI Benţa, I Szakáts, R Szakáts', '', '2010')
('Data distribution platform for multimedia mobile applications', 'M Cremene, M Riveill, I Benta', 'Proceedings of the 2nd French-speaking conference on Mobility and ubiquity …', '2007')
('The Affinity Platform: Modular Architecture based on Independent Components', 'A Ardelean, KI Bența', 'Proceedings of the International Conference on Software Engineering and …', '2005')
('AFFECTIVE PERSONALISED CONTEXT AWARE SYSTEMS', 'PPEC MIRON', 'Technical University of Cluj-Napoca', '2019')
('Sisteme senzitive la context personalizate afectiv', 'KI Benţa', '', '2010')
('Sisteme senzitive la context', 'AE Rarău, M Cremene, KI Benţa', 'Editura Albastră', '2010')
('mMVC - an Architecture Design Pattern for Mobile Applications', 'M Cremene, L Chira, C Loghin, I Benta', 'Sci. Ann. Cuza Univ. 15, 81-90', '2008')
('Using a multimedia database for tele-diagnosis and alternative tele-education methods', 'L Chiorean, MF Vaida, I Benta', '', '2004')
('Elemente practice de bază pentru programarea în limbajul C', 'LD Chiorean, KI Benţa, MF Vaida, PG Pop, C Strileţchi', 'C++-editia a doua adaugita', '')
('Une approche de type optimisation pour l’auto-adaptation de services mobiles', 'M Cremene, KI Benta, M Riveill', 'Mobilité et Ubiquité 2011 UBIMOB’11', '')
('Aplicatii cu senzitivitate autonoma la context', 'M Cremene, A Rarau, KI Benta, V Todica, C Miron', '', '')
('Starea actuala in domeniile aplicatiilor senzitive la context si adaptarii autonome', 'M Cremene, A Rarau, KI Benta, V Todica, C Miron', '', '')
('GESTION DU TRAVAIL INTELLECTUEL-FORMATION EN INFORMATIQUE', 'I Bența', 'Le Colloque Francophone sur le Style de Vie Sain des Jeunes 10, 86', '')

In [17]:
import mariadb
import json

In [18]:
with open('../credentials.json', 'r') as crd_json_fd:
    json_text = crd_json_fd.read()
    json_obj = json.loads(json_text)

In [19]:
credentials = json_obj["Credentials"]
username = credentials["username"]
password = credentials["password"]
table_name = "publications_cache"
db_name = "ubbcluj"

In [20]:
mariadb_connection = mariadb.connect(user=username, password=password, database=db_name)
mariadb_cursor = mariadb_connection.cursor()

In [21]:
for paper in pubs:
    
    title = ""
    pub_date = ""
    affiliations = ""
    authors = ""
    
    try:
        pub_date = paper[3].lstrip()
        pub_date = str(pub_date) + "-01-01"
        if len(pub_date) != 10:
            pub_date = ""
    except:
        pass
    
    try:
        affiliations = paper[2].lstrip().split('\'')[0]
    except:
        pass
    
    try:
        title = paper[0].lstrip().split('\'')[0]
    except:
        pass
    
    try:
        authors = paper[1].lstrip().split('\'')[0]
    except AttributeError:
        pass
    
    table_name = "publications_cache"
    
    insert_string = "INSERT INTO {0} SET ".format(table_name)
    insert_string += "Title=\'{0}\', ".format(title)
    insert_string += "ProfessorId=\'{0}\', ".format(18)
    if pub_date != "":
        insert_string += "PublicationDate=\'{0}\', ".format(str(pub_date))
    insert_string += "Authors=\'{0}\', ".format(authors)
    insert_string += "Affiliations=\'{0}\' ".format(affiliations)
    #print(insert_string)
    

    try:
        mariadb_cursor.execute(insert_string)
    except mariadb.ProgrammingError as pe:
        print("Error")
        raise pe
    except mariadb.IntegrityError:
        continue

In [22]:
mariadb_connection.close()

In [ ]: