Have you noticed the ETL (beta) option?

Though I’m sure many of you knew this already, I didn’t so I’ll add that ETL stands for “extract, transform, load” and the new feature seems to allow us to import tables, though I haven’t tried it yet:

The tab is located inside of “Manage”.

5 Likes

While I still don’t see it in my version of editor, this must be an upgrade that pending to reach all of users.

1 Like

That’s interesting. I wonder why you don’t see it. It is still in my editor. Did you tap on “Manage” and the look at the tabs?

Yups, maybe just take times to get update to all users. Here is my tabs, few second ago.

2 Likes

New features are not usually rolled out to everyone at once.

2 Likes

Yep, I notices the ETL tab a few days back but it was just a “placeholder” - no functionality inside. I figured something was coming soon!

1 Like

Perhaps that part of the explanation for new features not being announced.

ETL is not yet released… so you need to wait for a while.

2 Likes

But its in BETA right. It seems to be functional though I haven’t actually imported anything yet. Heck, I’ll try it right now!

I’m not able to confirm that because for me it’s working already :slight_smile:

I had to lookup “ETL”, too. I’d never seen that acronym before. I feel like “Import” is more suitable for no-code, though.

3 Likes

It worked!

There was a bug right out of the gate. I had a DateTime column where some rows were blank. The import reported that it couldn’t convert those to DateTime. Once I applied a DateTime to all rows, they were imported.

Now, I am left wondering where this will be useful? Is this just a step towards an automated feature we can utilize within our apps? Does the import run App Formulas as well?

It seems just as easy to copy paste between sheets. BUT, I can see the benefits if this is from a sheet to a database or the reverse!!

2 Likes

I tested it few days ago and it should calculate the app formula. Also… the initial value is calculated if the column is blank. And hope I’m remembering this correctly :slight_smile:

2 Likes

Hi @Steve! As I wrote, the ETL acronym was new to me. But, it seems that the term has come up in this community a few times in the past:

https://community.appsheet.com/search?q=etl

1 Like

I have requested a feature like this a while back as a way to integrate with another application. I was told i should write a google script to do that. The problem with that was that app formulas would not work on the imported data.

1 Like

So… what does this thing do?

I haven’t checked it since I last posted. If its the same, the feature allows you to quickly and easily move data from one app into another without the need of touching the sheet. The capability of transferring Slice data is an especially nice touch!

Wonder if this would help with archiving data instead of going with google sheet scripting?

Right now it seems the Import Data feature is a manual step. My hope is that in the future it can be accessed through a Workflow or Report to be automated.

Google scripting would allow this to be automated.

1 Like

If you want to automatically taking snapshot of data sitting on a table periodically, it is currently possible to run Appsheet API through report without involving Google App Script, for your guidance.
That should stands as “archiving” of data as of the time snapshot taken.

1 Like