PowerPoint to database

Hello,
I got a challenging question from a customer !
The domain is Heritage buildings protection.
An architect/historian evaluates the value of buildings and gives them a mark.
He then presents his proposal in a PowerPoint :

• Identification info
  
• Description
  
• Mark
  
• Label
  
• etc.
  
• Pictures

The proposal is reviewed in several sessions, with different people. The mark may be upgraded or downgraded, the label changed, etc.
Once validated, the data is to be captured in an SDE geodatabase. Presently, this is done in two different ways :

1. Manually
   
2. Manually copying the data to Excel and it is imported in GDB with FME

But in both cases, there is a non profit-adding step, which is to manually copy the data.
Does anyone out there have an idea how to skip this step ?
How to struction the presentation in such a way (with keywords for instance) that the content could be recognized and imported directly?

I have thought of different ways but I'd rather keep it open for your input !

Kind regards,
Tim

Hi Tim.

Welcome to the forum and thank you for the post.

The simplest option is to write a macro, save PowerPoint presentation as text and use Advanced ETL Processor Enterprise to load the data into the database

Here is the basic macro example
superuser.com/questions/1128966/how-can-...rpoint-to-plain-text

Add a guidance page to the presentation which explains to the user how to update the presentation in such a way that it will not create problems for importing the data.
(Constantly renaming labels and shifting data around will break the import process so it is important to follow the standard)

Another option is to get rig PowerPoint completely and replace it with something else.
That depends on how many presentations you process per year, if it is very small it may not be worth the effort

Or store data in the separate Excel file