Converting imports between databases
Posted: Wed Jul 19, 2017 5:04 am
Im just putting my thought here if someone more skilled in coding would say "This is easy, give me a couple of days and ill fix it for you..." [:D]
I have been thinking about how a conversiontools for .inst files could be done at least for Facilities. Right now i manually edit the files to change between databases but this should from a logical perspective be easy to automate. The problem is dont code (except from peek and poke on a C64 a couple of hundred years ago.
The pseudocode for the operation would be:
I will try to achieve this, but as house, wife, kids, work take a lot of my time and i need to learn to code again my project plan expand in to 2030
Will update this post when (or rather if) any progress is made
I have been thinking about how a conversiontools for .inst files could be done at least for Facilities. Right now i manually edit the files to change between databases but this should from a logical perspective be easy to automate. The problem is dont code (except from peek and poke on a C64 a couple of hundred years ago.
The pseudocode for the operation would be:
Code: Select all
read .inst
check which "DB_ID" it uses
analyze what "Member_DBID" is present in the file
match "Member_DBID" to a "MemberName"
present the found "Member_DBID", "MemberName" and occurrences for all in a "left column"
present a drop-down list of which database it should be converted to (db3k/cwdb)
present a drop-down list in the right column for each instance
The drop-down list would include all facilites for the selected "convert-to database"
Then some sort och search and replace to edit the .inst
A Convert button to Save as a new .inst
I will try to achieve this, but as house, wife, kids, work take a lot of my time and i need to learn to code again my project plan expand in to 2030
Will update this post when (or rather if) any progress is made