Excel XML

Here you can post your opinions, ask questions and share information regarding GPI (Searching the EPO’s worldwide bibliographic, legal event and full-text data sets via the “Patent information services for experts” user interface).

aortega
Posts: 5
Joined: Fri Mar 12, 2021 10:57 am

Excel XML

Post by aortega » Wed Mar 17, 2021 1:33 pm

Hello team,
I am trying to do the statistical analysis in excel by exporting the GPI data as XML, but I cannot display it correctly in Excel. I would also like to analyze them in Power BI, but I don't know how to import them to visualize them correctly. Somebody could help me?
Thank you,
Alicia


EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Thu Mar 18, 2021 7:56 am

Dear Alicia,

Could you please indicate the columns included in your result list?
Do you open the XML under Excel using the option "Open as XML table"?

This is what we get when using the columns Publication and Inventor (e.g. EP 2111865 A1 is present 4 times because it has 4 inventors):

Publication p
EP 1976217 A1 20081001 GEORGE RICHARD
EP 1976217 A1 20081001 LEE DALSU
EP 2107492 A1 20091007 OE NAOYUKI
EP 2107492 A1 20091007 SHIMA TAKAHIRO
EP 2107492 A1 20091007 MATSUMOTO YOSHIYUKI
EP 2107492 A1 20091007 SHIMA HIROKI
EP 2107492 A1 20091007 MINAMII YUSUKE
EP 2107492 A1 20091007 TAKEDA TAKAHIRO
EP 2111865 A1 20091028 TOKUDA MASAAKI
EP 2111865 A1 20091028 IZUMORI KEN
EP 2111865 A1 20091028 TOYODA YUKIYASU
EP 2111865 A1 20091028 MIWA ICHITOMO

We will try to make tests with Power BI.

GPI User Support


aortega
Posts: 5
Joined: Fri Mar 12, 2021 10:57 am

Re: Excel XML

Post by aortega » Wed Mar 24, 2021 2:22 pm

Thank you for your quick response.
I would like to build a collaboration network diagram in Power BI, How would you have to enter the data to build the network?
Thank you
Alicia


EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Thu Mar 25, 2021 4:59 pm

Dear Alicia,

Unfortunately we don't have Power BI in our default software package - is it correct to assume that your result list download includes e.g. publication numbers + applicants ?

GPI user support


aortega
Posts: 5
Joined: Fri Mar 12, 2021 10:57 am

Re: Excel XML

Post by aortega » Tue Mar 30, 2021 11:43 am

Hello,
Yes, I'm including publication number + application.
How can I build a node collaboration? Is any tool?
Thank you


EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Tue Mar 30, 2021 8:04 pm

Dear Alicia,

Unfortunately our Patent Information tools do not offer such feature.

GPI user support


EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Wed Apr 07, 2021 3:48 pm

Dear Alicia,

You may want to have a look at the GPI cross reference charts where you can select Applicant on the X and Y axis - the bubble chart shows the top 20 applicants.

Would this help?

GPI user support


aortega
Posts: 5
Joined: Fri Mar 12, 2021 10:57 am

Re: Excel XML

Post by aortega » Mon Apr 12, 2021 10:20 am

Not at all, but thank you for your help.
Alicia


EPO / EPAL Team
Posts: 139
Joined: Mon Dec 22, 2014 8:30 am

Re: Excel XML

Post by EPO / EPAL Team » Mon Apr 12, 2021 11:46 am

Dear Alicia,

We managed to make a quick test last week with Power BI Desktop.

To exchange information on this topic more effectively, could you please send an email to support@epo.org (mentioning "GPI" in your email subject) ?

We would then explain which format to use when downloading a GPI result list

Thank you in advance,

GPI user support


Edward7422
Posts: 1
Joined: Fri Dec 10, 2021 11:47 am

Re: Excel XML

Post by Edward7422 » Tue Jan 11, 2022 5:10 am

I would like to build a collaboration network diagram in Power BI, How would you have to enter the data to build the network?
Last edited by Edward7422 on Thu Jan 13, 2022 5:47 am, edited 1 time in total.


Post Reply