search

Sivapsg / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

Is it possible to to add a row of data ? #80

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

>>>>>> No where to add a row of data to a project once in Gridworks

What version of the product are you using? On what operating system?

>>>>>> Version 1.1-r878

Please provide any additional information below.

We are in the process of cleaning up some data base data. The data base in 
question is connected to a Live UI and is updated manually, so needs to be kept 
up to data with new data that comes in while we clean up the original data. We 
also need to add that new data to the corresponding Grid works project so that 
when we load the cleaned up data back into the data base, it's up to date. 

Our question is : Is it possible to add data to a Gridworks project or do we 
need to export the project to csv, add the new records, then import it back 
into the data base? 

Thank you

Original issue reported on code.google.com by premato...@gmail.com on 21 Jun 2010 at 12:50

GoogleCodeExporter commented 9 years ago 
prematouch: no, Gridworks doesn't support adding rows right now. For your case, 
is it the plan to manually export new data to a file and then append it to an 
existing Gridworks project? Or do you have some database trigger that can, say, 
do an HTTP POST to Gridworks?

But note that even if Gridworks lets you add more rows to an existing project, 
any operation you have applied to the project will not affect the newly 
appended data.

I'd recommend picking a low traffic period of time to take your UI offline "for 
maintenance". Re-export from the database, import into Gridworks, re-apply the 
same operations, export from Gridworks, import back to your database. It's not 
ideal but maybe the best solution for now.

Original comment by dfhu...@gmail.com on 21 Jun 2010 at 5:10

GoogleCodeExporter commented 9 years ago 
Thank you so much for your clarification and suggestions. In that case, there's 
not that much new data coming in so we'll probably just make sure it's added 
cleanly to the newly cleaned exported file from Gridworks before we add it back 
to the database.

BTW, Very happy with Gridworks and can only see that it will continue to 
improve.

Thanks again

Original comment by premato...@gmail.com on 22 Jun 2010 at 1:59

GoogleCodeExporter commented 9 years ago 
OK, I'll close this issue for now.

Original comment by dfhu...@gmail.com on 22 Jun 2010 at 8:43