bulk data adds

A place for users and developers of the Xataface to discuss and receive support.

Postby wreid » Tue Nov 14, 2006 2:08 pm

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
wreid
 
Posts: 27
Joined: Wed Dec 31, 1969 5:00 pm

Postby njw » Tue Nov 14, 2006 2:11 pm

Is it in a structured electronic format? Import it straight into MySQL?

Neil
njw
 
Posts: 280
Joined: Wed Dec 31, 1969 5:00 pm

Postby wreid » Tue Nov 14, 2006 2:18 pm

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
wreid
 
Posts: 27
Joined: Wed Dec 31, 1969 5:00 pm

Postby Aoirthoir » Tue Nov 14, 2006 5:19 pm

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.
Aoirthoir
 
Posts: 420
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Wed Nov 15, 2006 12:04 pm

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 15 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved