I just have a short question: Is it possible to dublicate a whole table?
The problem is, I use an app, with a table wich I create by myself in “Tulip Apps”. I fill up the table constantly with new dates.
Now I create a new app an I need the table from the other app, but doesn’t need all the dates of the table. So I want to copy the table and delete the unneeded dates out of here, to not have such an high ammount of dates I don’t need.
Is this possible? I don’t want to create a new table by filling up all the existing date I need by hand in a new table.
You can export the original table to CSV, remove whatever columns/values you don’t need for the new table, then use the CSV uploader to populate the new table.
Before uploading, you would need to configure whatever columns are required.
Also, your new app would need to be connected to the new table, and all the queries, aggregations, and placeholders configured.
I think i’m not seeing all the screenshots you mentioned, and I don’t see datetime data type columns in the screenshot I do see - but I have had the same experience with exported dates not being importableon an older LTS. Sometimes this can be remedied by “fixing” the date format in excel and saving the CSV file, then uploading.
Another option is to modify the datetime format in your Tulip instance settings. For example, in our DEV environment with the validation feature flag off, we can export and reimport datetime values without Excel intervention. But in QA and PROD environments with the validation feature flag enabled, Excel is required. I believe the CSV importer on more recent releases of Tulip are more forgiving with the datetime format.
Hi @JoelBGT, welcome to the community—this is a great question and I’m glad @jmlowden jumped in.
Just a heads up: all of the images should be visible now. The forum spam detector flagged the second screenshot with the CSV values, so anything after that didn’t come through. I manually approved everything so should be all set now.
So my German is a little rusty, but you shouldn’t need to load the two metadata columns.
Also just to clarify your original post, does “dates” mean datetime data, or is it a typo for “data”? All the other data in your example should be importable, I think, you just need to match up the header rows from your export file to your new table.
After I deleted the rows in the exported CSV file I don’t need and import this revised file into Tulip again, no data is transferred…
I’ve tried this three times, it didn’t work…
But if I import the CSV file unedited, it works perfectly. Why? I dfon’t get it
I don’t know if I got you right, but yes. I tried to clear data from a row and then there are blank cells. I deleted the blank cells so that there are no blank cells anymore and every row under a deleted row pulls up. And then I tried to upload the CSV again into Tulip and this doesn’t work, because no data comming through…
But it doesn’t matter anymore, I have an easy solution. I just upload the exported CSV unedited again and edit it just after the upload back into Tulip. So I just edit it, if the table is back in Tulip. This works
