Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content. For example: Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday" Excel Cell Contains "Testing$", then in staging table contains "Testing". Is anything we missed. Can anyone help on this.

State Not Answered
Replies 1 reply
Subscribers 7 subscribers
Views 39 views
Users 0 members are here

Data Issue in Import Excel To DB.

Newton2021

Certified Associate Developer

2 days ago

Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content.

For example:

Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday"
Excel Cell Contains "Testing$", then in staging table contains "Testing".

Is anything we missed. Can anyone help on this.

Discussion posts and replies are publicly visible

Parents

0 Yogi Patel
Certified Associate Developer
2 days ago

Maybe some issue with file encoding or any other issue. If you are still facing the same issue, attach a sample Excel file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Yogi Patel
Certified Associate Developer
2 days ago

Maybe some issue with file encoding or any other issue. If you are still facing the same issue, attach a sample Excel file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data