Batch Macro to import multiple file having different schema
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
I am having a batch macro to import multiple excel files from a folder, having different schema. However, I am still not able to import all the files as they are being dropped even after using Batch Macro. Below is the screenshot of the same.
And below is the workflow which imports all the files and use it for further processing
Any help on this would be welcome, I am stuck in this place for a long time
Regards,
Deba
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you able to upload a copy of your batch macro and a few of the files you are trying to import? This will make it easier to pinpoint the exact issue.
For the macro, please ensure you have the following configuration in the interface designer settings (view > interface designer).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Make sure you have the macro settings as follows in the screenshot:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Thanks for the reply, I had made those changes in the beginning itself, however what I missed out was including the Sheet Name after the directory input. That was the reason why records were being dropped
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Thanks for the reply, I had made those changes in the beginning itself, however what I missed out was including the Sheet Name after the directory input. As I have mentioned above.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great, glad you figured it out!
