Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Ideas for downloading- updating- uploading data?  RSS feed

 
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I need to allow my (non-programming-savvy) user to update rows of a table in the following fashion:
- Download data in preferably Excel format. The data comprises of 2 fields: "SSN" and "Cost".
- Update few records over a period of 2-3 days (non-realtime)
- Once the update is completed, the user uploads the file back and all corresponding records are updated in the DB
Issues:
1. Considering that sometimes there might be 100's of records, the user would wish to do this over a course of 2-3 days before uploading the file.
2. Is there a way by which to "freeze" that SSN column so that typos don't cause the SSN to be changed by mistake.
3. The "Cost" field has some validation check to see that only rightly formatted data is fed back to the DB.
4. Because of #2 & #3, CSV download/modify/upload is not possible, and I am thinking if there is a way by which Excel could be used, where cells can be formatted & macros used so that chances of data purity are increased.
5. Because of non-familiarity of XML with the end-user, it can't be used for raw update. But could there be a template created which the user downloads along with the XML file. Via the template the user makes the changes, and then uploads the updated XML. Possible?
Has anyone got any ideas on this? Any comments would be appreciated.
Thanks.
 
PI day is 3.14 (march 14th) and is also einstein's birthday. And this is merely a tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!