search

carj / flask-csv2xml

Flask Webapp to convert CSV files to XML documents
GNU General Public License v3.0
2 stars 0 forks source link

Technical query re application https://pypreservica.pythonanywhere.com/ #1

Closed MICHAELHUNKIN closed 3 years ago

MICHAELHUNKIN commented 3 years ago

Hi James,

Just had a quick query about CSV/metadata convertor link you posted on Preservica User Group last week - the post mentioned to send any queries via the GitHub pages.

https://pypreservica.pythonanywhere.com/

I've set my spreadsheet to display the DC elements (i.e. title, creator) in columns, with each file running left to right, with what will be the files running in rows below the column heading. I put the spreadsheet through the application to convert it to DC .metadata files, but the files are coming out with all the elements placed together in one line, rather than in indented rows below the namespace The PUT tool will not allow me to move an ingest package into the system whilst the metadata files are in this format. If I move the elements into lines as per my metadata templates in Preservica it's fine, but its a bit time consuming to amend all the files this way.

Is the application supposed to order the elements in rows automatically, I'm assuming it does so think it's something I'm doing wrong. Sorry to bother you with this, I have very limited experience of coding and using XML schemas in the context of Preservica, and have not really got to grips with the API side of things either. Not sure if it's something I'm doing wrong with the web application or how I'm creating my CSV document. I have saved the spreadsheet as CSV in UTF-8.

Any guidance would be gratefully received!

Best wishes,

Mike

carj commented 3 years ago

Hi Mike I have updated the web app to format/indent the created XML documents in a nice human readable way. This should make it easier to check the resulting XML files are correct even though Preservica does not need the XML files to be formatted nicely.

MICHAELHUNKIN commented 3 years ago

Hi James,

Thanks for updating the web app, is a lot easier to check with the structured text option and spot mistakes.

I've played around with it a bit more and managed to get something ingested! I had to bring a modified schema that corresponded to the metadata files (also created in the web app) and activate it in the system, this seemed to make it work.

So, my metadata files have the long top line including just the xmlns:oai_dc and xmlns:dc bits. The DC XML templates already in the system (oai_dc:dc) have the extended line:

-

I'll keep playing around with it, see how it copes with bigger ingests. I'll also get in contact with a few colleagues in other places to see how they get bulk metadata together. We're still looking at CALM integration but would look at Dublin Core for uncatalogued material or digital content that we'd not normally document on the CALM system. For getting files together quickly this a very useful tool though, now I'm up to speed with it - thanks for putting it together and for your help with my questions!

Best wishes,

Michael

From: James Carr notifications@github.com Sent: 22 December 2020 20:11 To: carj/flask-csv2xml flask-csv2xml@noreply.github.com Cc: MICHAELHUNKIN michael.hunkin@hotmail.co.uk; Author author@noreply.github.com Subject: Re: [carj/flask-csv2xml] Technical query re application https://pypreservica.pythonanywhere.com/ (#1)

Hi Mike I updated the web app to format/indent the created XML documents in a nice human readable way. This should make it easier to check the resulting XML files are correct even though Preservica does not need the XML files to be formatted nicely.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/carj/flask-csv2xml/issues/1#issuecomment-749753323, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ASHGX4UY6JJ5AGL3P67HK5LSWD4N3ANCNFSM4VENBSTA.