I have multiple excels which are different from each other. One has columns like segment, country, product and the other one has application, environment, database and so on... I want to read them and insert them into different tables say t1 and t2 respectively. I am looking for something which can solve this issue. I have seen many tutorials/blogs etc which shows to read and write single excel into database or multiples files but the structure of excels are same ie columns are same.
Spring batch to read multiple csv files into different databases table
120 Views Asked by Adil At
1
There are 1 best solutions below
Related Questions in SPRING
- HTTPS configuration in Spring Boot, server returning timeout
- Multi Tenancy in Spring - Partitioned Data Approach
- How to create beans of the same class for multiple template parameters in Spring
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Springboot: How to get an entity optional property and check null?
- How do I propagate the current SecurityContext to my @RabbitListener in Spring Boot?
- Spring's XML based bean configuration for Object Mapper's Case Insensitive property
- Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. I'm using Postgresql
- springboot class org.hibernate.mapping.Bag cannot be cast to class org.hibernate.mapping.SimpleValue
- Issue while deploying JDK 17 and Spring 6 application in Tomcat 10.1.20
- Spring JPA Data Auditing - How to design it?
- Springframework test: Async not started
- Error: Cannot invoke "jakarta.servlet.http.HttpSession.getAttribute(String)" because "session" is null
- How does spring-retry determine which methods to retry when @Retryable is placed at the class level?
- problem with edge server registration in Eureka
Related Questions in SPRING-BOOT
- Multi Tenancy in Spring - Partitioned Data Approach
- I have created a spring boot application with spring data JPA, Rest ,oracle and i am getting this ORA-00933: SQL command not properly ended
- Springboot: How to get an entity optional property and check null?
- How to create jasper report in spring boot rest api with jpa
- JSON Body is Not Passing Certain Strings
- Unresolved reference error is showing up after adding the dgs codegen plugin successfully
- Transaction silently rolled back
- JPA buddy error when generating JPA Entities from DB
- Migrating Spring Boot 2 to 3 throws org.glassfish.jaxb.runtime.v2.runtime.IllegalAnnotationsException: 3 counts of IllegalAnnotationExceptions
- Hibernate SQL Error: Missing FROM-clause entry for table "th1_1"
- Appwrite and / or Spring Boot Backend
- Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. I'm using Postgresql
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- springboot class org.hibernate.mapping.Bag cannot be cast to class org.hibernate.mapping.SimpleValue
- Spring security causing 404 with message "No static resource login"
Related Questions in SPRING-BATCH
- How to customize the Spring Batch default configuration without breaking autoconfiguration
- Is there any catch in Reading and Updating to the same Oracle table in Single Threaded Spring batch job?
- Starting first job causes - Dispatcher has no subscribers for channel exception when declared multiple DirectChannels
- Looping Over a Group of Steps in Spring Batch
- Already value [datasource.ConnectionHolder@6b144bd8] for key [datasource.DriverManagerDataSource@56739ee9] bound to thread [main]
- How to Use ControllerAdvice for Exception Handling in Spring Batch Application?
- Writing in multiple related tables in spring batch
- Restarting a FAILED job is not processing the failed chunk data again : Continuation
- Spring Batch Not persisting Data Properly in MYSQL Database
- Strange Spring Batch exception, something I did wrong?
- Parameter 0 of method jobBean in com.nextuple.BatchProcessing.config.BatchConfig required a bean named 'dataSource' that could not be found
- is spring batch supports parquet file reading and writing
- Spring Batch 5 - Don't want it to automatically create tables in database
- Transaction flow for distributed transaction in Spring Batch
- How to solve JobBuilder deprecated in SpringBatch 5.1.1
Related Questions in SPRING-BATCH-EXCEL
- Spring Batch: Why do I get exceptions from nowhere in my Custom Item Excel Writer (Apache POI)?
- Spring Batch Excel Reader Workbook NullPointerException
- Spring batch to read multiple csv files into different databases table
- My job which is made up of a chunkBasedStep doesnt run properly in my spring batch application
- Date format in Spring Batch Excel
- Spring Batch Excel PoiItemReader
- How to read numeric value from excel file using spring batch excel
- Step freeze. PoiItemreader does not read excel file when the file is large. Any suggestion?
- Spring batch excel extension
- Inject properties into FlatFileItemWriter in Spring batch
- Spring Batch configuration Formatter Conversion change
- How to update huge data in database using Spring Boot Batch Job
- Reading XLSX data in SpringBatch
- How to read more than Text file in springbatch item reader
- org.springframework.batch.item.ItemStreamException: Failed to initialize the reader on second api call
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The input files are differents, so you would want to create different steps to process them. These steps can be executed in parallel since the read/write operations are independent.