Page 1 of 1
Posted:
Tue Nov 14, 2006 2:08 pm
by wreid
Hi All,
Any thoughts on whether there will be any form of "bulk adding" feature?
I have a lot of data I want someone to add though dataface and I don't want them to add the items one at a time if it can be avoided. Any thought on how this could be done through dataface? Has anyone else done something like this? I really want to be able to use this program for all my database needs and this would be a big plus.
Any thoughts?
Walter
Posted:
Tue Nov 14, 2006 2:11 pm
by njw
Is it in a structured electronic format? Import it straight into MySQL?
Neil
Posted:
Tue Nov 14, 2006 2:18 pm
by wreid
Hi Neil,
I could do it that way, but not the person who does the edits doesn't. This would be a problem if they need to load in bulk data, but I was not around. I'd like to use this as an all purpose data driven tool without having to use phpmyadmin or mysql command line for things like this any more then for extreme cases.
Any other thoughts on how it could be done through dataface or if there will be future support of such an idea?
Walter
Posted:
Tue Nov 14, 2006 5:19 pm
by Aoirthoir
Walter,
We brought this up as a project some time ago (for pay). Mr. Steve quoted us a very reasonable price. We were trying to get some data from some very old DBF and DBV files. However we ended up purchasing a Windows program in order to slam out the conversion real fast. Nevertheless, Mr. Steve has spoken of hoping to add imports in a future version of Dataface. I imagine a work for hire request would speed this along. Not sure where it is currently on the agenda in his time frame. But if it is still in the far-flung future, it is something you might want to consider.
We have commissioned several changes to Dataface (like the tree list) and have been very satisfied with the results.
Posted:
Wed Nov 15, 2006 12:04 pm
by shannah
Hi Walter,
There is a pseudo-framework built into dataface to allow you to write your own import routines and import records into Relationships currently... To import directly into tables without a relationship there is a small amount of work remaining (basically just need to add the action).
This framework still requires you to write a PHP routine to import data from either an uploaded file or a text area, but if you write the import rules - it will hook into the interface so that it is easy for your users to use.
I'm not sure when I'll have time to finish this off because this issue hasn't been requested by any current clients, but I'll do my best. If you're rushed for time, it also wouldn't be too difficult to define your own custom action to do the import. Then the user would get a tab called "import" or something, where you would have an HTML form for the user to either upload his data or paste it into a field - then parse it out...
Best regards
Steve