[New Plugin] Introducing the Ultimate CSV Plugin for Bubble Apps: Get, Group, Extract, and Preview Any Delimiter-Separated File with Ease! Updated with CSV Extractor and Preview Features!

:card_file_box: Are you tired of spending endless hours wrangling data from CSV files in Bubble? :weary: Say goodbye to the headache and hello to our CSV plugin!

Suppose we have a csv file that contains data about company employees.

:one: Get CSV Data: :inbox_tray:

We require all values of the column to assess employee satisfaction.

To do this, use Get CSV Data element, and by entering the column’s name, you will have all its data in the form of a text or number list.
image

Read more about "Get CSV Data"

With this element, you can now retrieve data from delimiter-separated files including CSV, TSV, DSV, TXT, and XML. Our plugin can detect the delimiter, so you don’t need to worry about different delimiters. You can specify the starting point of the columns and get the data in separate lists. You can also get full CSV data as JSON and a list of column names, making organization and analysis a breeze. :clipboard:


:two: Group by CSV Data: :bar_chart:

In the next step, we want to have the average level of satisfaction for each educational field

With the Group by CSV Data element, we can group and aggregate file data

GroupBy-Editor


Is it possible to consider only employees who have been in the company for more than 5 years?

You can easily filter the rows of the csv file based on one of the columns.

Read more about "Group by CSV Data"

Need to group data based on multiple columns and return aggregated values? Our Group by CSV Data element has you covered! Use the data for charts, reports, or whatever your heart desires. :chart_with_upwards_trend: You can also filter the data before grouping to ensure the perfect outcome.


:three: CSV Extractor:

:outbox_tray: This new element provides you with all the data of 5 columns of the file in 5 separate lists. You can specify the starting point of the columns, and the plugin can detect the delimiter, so you don’t need to worry about different delimiters.


:four: CSV Preview:

:eyes: This new element is like the Extractor but for file data rows. You can get the data of 10 rows of the file and specify its starting row. The plugin can detect the delimiter, so you don’t need to worry about different delimiters.


:five: : CSV → Filter → CSV:

This is an action added to the extractor for when you want to import data into the bubble using a csv file, but some of them are duplicates.
With this action, you can easily filter the csv file and receive the filtered file from the state element.


plugin page:

:female_detective:
You can subscribe for few hours to make sure about this plugin functionality in your app.

Explore our CSV Data Manipulation plugin on our demo page to get a better sense of its functionality
:kite: Chek plugin playground

We’re constantly updating our plugin with new features and tools for data manipulation, so you can stay ahead of the curve.

Get started today with the ultimate CSV plugin for Bubble and start saving time on data extraction and manipulation. :alarm_clock::computer:

3 Likes

What is the link to the plugin page?

1 Like

I’m sorry about that, this is my first time introducing a plugin and I forgot to include the link to the plugin page. Thank you for bringing it to my attention. :pray:

Here’s the link:

Let me know if you have any other questions or concerns.

Hi @NoCodeDataArtisan Can you detect other csv format?

1 Like

Hi there!
Thank you for your interest in the plugin, I really appreciate it!

I used D3.js, which is an incredibly powerful tool for data visualization and manipulating.

I want to make sure the plugin works perfectly for you, so I’m curious - do you work with specific format, or do you use a variety of formats?

In response to your question, I’ll work on adding support for TSV and DSV formats to the plugin as soon as possible. TSV refers to tab-separated values, while DSV stands for delimiter-separated values which means you can set any delimiter.

Of course, if you need support for a different format, please don’t hesitate to let me know and I’ll do my best to make it happen!

Thank you again for reaching out with your question. I’m always here to help if you have any other questions or requests.

1 Like

Hello there! @JohnMark
Thank you so much for your suggestion. I deeply appreciate your interest in my plugin. :heart_eyes:

I am happy to let you know that I have taken your feedback into account and have updated the plugin accordingly. The updated version will be available to you as soon as it is approved by Bubble. @system :woman_judge:

:fountain_pen:
In the updated version, you will be able to use all types of formats, including csv, tsv, dsv, txt and xml.
:bulb:
Also, the plugin will automatically detect the delimiter and extract the data from the file.

I hope this new feature makes it easier and more convenient for you to use the plugin.

Once again, thank you for your suggestion, and please don’t hesitate to reach out to me if you have any further feedback or questions

3 Likes

An updated version is available. You can test new features in the demo app.

1 Like

New Feature
Now you can filter CSV file before uploading it to bubble.

CSV → Filter → CSV

image

2 Likes

:bell: UPDATE

New Feature: Workload Control (WU)

Greetings everyone,

We would like to inform you that we have updated the plugins to give you more control over the amount of workload used. You can now specify the execution time, disable the loading of the plugin on page load without any additional conditions to hide, and control it through actions.

We would love to hear your suggestions and any new features that you think should be added to the plugin.

Thank you.
@NoCodeDataArtisan

1 Like

Happy to try this out. I want to permanently get rid of the first 12 rows in a csv-file : does your plug-in support this usecase?

1 Like

Hello. Thank you for trusting us. :pray:t2:

If it is not available now, we will add it. šŸ§‘ā€šŸ”§

May I ask, after removing 12 rows, what format do you want the data to be in? You need csv again

Doesn’t really matter - I just want to import the remaining data to the DB.
Thanks - looking forward.

1 Like

Hello again @christina.sandberg

Great news, we did it!

Just wanted to give you a heads up to update the plugin and check out the new features we added.

You can now easily set the range of rows in the "Get data from CSV "and ā€œCSV Extractorā€ elements to make things even better.

:pray:
Thanks a lot for your practical and valuable suggestion, we really appreciate it.

Hope you find the updated plugin helpful

2 Likes

Awesome - that is some kind of service level! :heart_eyes:
I think this is excellent and really looking forward to using this new plug-in.

1 Like

We prioritize your satisfaction and are dedicated to assisting you in every possible way.

It is a great honor for us to have earned your trust. :star_struck:

If there are any queries or if you require additional features, please do not hesitate to inform us.

hi - another feature I think would be useful, not only for me, is the ability to filter out rows which are duplicates with already existing database rows.

1 Like

Certainly, I appreciate your assistance in enhancing the plugin. :heart_eyes:

Could you provide further clarification? Are you referring to the application’s database? Additionally, could you elaborate on the technique employed to store CSV data in the database?

hi,
I get an error from the plugin:
Bug in custom code Error: object thrown as error
at Object.m [as ensure_bubble_error] (https://skatekungsbacka.bubbleapps.io/package/run_debug_js/df99ba88dd83b70fd8a4f31ab6563dd7ae6df455cad319dbdd536aae1d3f72db/xfalse/x23/run_debug.js:17:3180864)
at window.onerror (https://skatekungsbacka.bubbleapps.io/package/run_debug_js/df99ba88dd83b70fd8a4f31ab6563dd7ae6df455cad319dbdd536aae1d3f72db/xfalse/x23/run_debug.js:17:2878701)
at root (PLUGIN_1675257840457x627131306423615500/CSV-Data-Manipulation–update–CSV-Extratctor-.js:22:24)

1 Like

Hello, @christina.sandberg

Thank you for bringing this to our attention. We sincerely apologize for the delay, It seems that the notification did not reach us as expected.

To assist you further, could you please provide additional details? Are you referring to a specific process that used to run smoothly but now encounters an error? Or did you encounter this error in a completely new situation or process?

We appreciate your effort in explaining the situation. However, it would be helpful if you could provide more information as the error text alone is not sufficient for us to understand the issue.

Thank you for your understanding, and we look forward to resolving this matter for you.

hi,
no I don’t think I have done anything new. The functionality works as intended.
What info do you need from me?

1 Like