> I planned on just exporting the data to a xls file and then import the > same xls after it's been > updated at a csv. I just get nervous when there's too much exporting and > importing. > > Does anyone have any other ideas that they themselves have successfully > implemented?
I guess you'd have to consider how you'd handle updating existing records. Would you expose the primary key ID (or UID if you're using that) in the xls file? I'd think you would have to. Then there'd be the possiblity that they'd change that ID data inadvertently, and so violate the data integrity. If you're talking about just dumping the table, and then on import clearing the table and just using the edited xls file as the new data, that could really be a nightmare. Also, if they add a column or something, and you were using a cfhttp call to turn the xls file into a query, the import would fail. Sounds like there are a lot of challenges involved. Maybe you could create a multi-row edit form for them instead, that would mimic what they want to do with the spreadsheet. I've done something like this in javascript using jQuery and a plugin called jEditable that creates an Excel-like environment. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
