{"id":211,"date":"2023-12-22T14:17:48","date_gmt":"2023-12-22T05:17:48","guid":{"rendered":"https:\/\/www.fideltech.com\/case-studies\/?p=211"},"modified":"2025-04-14T18:55:54","modified_gmt":"2025-04-14T09:55:54","slug":"importing-multiple-data-file","status":"publish","type":"post","link":"https:\/\/www.fideltech.com\/case-studies\/importing-multiple-data-file\/","title":{"rendered":"Importing multiple data file (XLS\/CSV) in ServiceNow Tables"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_image src=&#8221;https:\/\/www.fideltech.com\/case-studies\/wp-content\/uploads\/2023\/12\/Importing-Multiple-data-file-in-ServiceNow-Tables.jpg&#8221; alt=&#8221;Importing Multiple data file in ServiceNow Tables&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_image][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;2px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; title_text_align=&#8221;left&#8221; custom_margin=&#8221;0px||||false|false&#8221; custom_padding=&#8221;30px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_post_title][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;25px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<p>With our scheduled script each data Source have their Scheduled Import Set to import the data in file attachment to the targeted table.<\/p>\n<h3>Challenges<\/h3>\n<ul>\n<li>In ServiceNow, when multiple files attached to the Data Source and Scheduled Data Import executed the first attached file data is imported in the targeted table.<\/li>\n <li>Other files are not considered while doing the data transform.<\/li>\n<li>We have more than files coming from email and need to import in the tables.<\/li>\n<\/ul>\n<h3>Solution<\/h3>\n<ul>\n<li>In this case what we have done is, we have used the Parent Data Source and the number of child Data Sources that can actually hold the single attachment.<\/li>\n <li>Here, we have written as Scheduled Script that actually gets the attachments from Parent Data Source and attaches corresponding attachments to the Child Data Sources.<\/li>\n<li>Then, each Data Source have their Scheduled Import Set to import the data in the Service Now targeted tables.<\/li>\n<\/ul>\n<h3>Results<\/h3>\n<p>Client has more than a file in email attachment and corresponding data is imported in the tables, so as to correct reports values are populated from the tables.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Section&#8221; module_class=&#8221;footer-cnt&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#103e66&#8243; custom_margin=&#8221;||-27px||false|false&#8221; custom_padding=&#8221;||30px||false|false&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.19.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h2 style=\"color: #ffffff;\">Is this Case Study interests you?<\/h2>\n<p style=\"color: #ffffff;\">If you found this case study similar to your requirement OR interested to get our services, please connect with us using form. We will be happy to respond.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-phone\"><\/i>Call us<\/h3>\n<p><a href=\"tel:03-6261-3309\" onclick=\"gtag('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Phone Japan','value': '03-6261-3309'});\">03-6261-3309<\/a><\/p>\n<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-email\"><\/i> Email us<\/h3>\n<p><a href=\"mailto:infofidel@fideltech.com\" onclick=\"gtag(('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Email Japan','value': 'infofidel@fideltech.com'});\">infofidel@fideltech.com<\/a><\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<div class=\"cf7sg-container\"><div id=\"cf7sg-form-footer-contact-form\" class=\"cf7-smart-grid has-grid key_footer-contact-form\">\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f22-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"22\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/case-studies\/wp-json\/wp\/v2\/posts\/211#wpcf7-f22-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"22\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.7\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f22-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7_key\" value=\"footer-contact-form\" \/><input type=\"hidden\" name=\"_cf7sg_toggles\" value=\"\" \/><input type=\"hidden\" name=\"_cf7sg_version\" value=\"4.18.0\" \/><input type=\"hidden\" name=\"_wpnonce\" value=\"6ce1afdbc1\" \/>\n<\/fieldset>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns full\">\n      <div class=\"container cnt-mt\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your Name*\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field email required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"email-669\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Corporate Email*\" value=\"\" type=\"email\" name=\"email-669\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n      <div class=\"container\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"company-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Company Name*\" value=\"\" type=\"text\" name=\"company-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field tel required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-536\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone*\" value=\"\" type=\"tel\" name=\"tel-536\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field textarea required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"Message\"><textarea cols=\"40\" rows=\"2\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Message*\" name=\"Message\"><\/textarea><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><div id=\"cf7sr-6ac3fd7b5a039\" class=\"cf7sr-g-recaptcha\" data-theme=\"light\" data-type=\"image\" data-size=\"normal\" data-sitekey=\"6LcW5JAUAAAAAHRCNkfrX7zI14Oxgh2dP0KQg8Av\"><\/div><span class=\"wpcf7-form-control-wrap cf7sr-recaptcha\" data-name=\"cf7sr-recaptcha\"><input type=\"hidden\" name=\"cf7sr-recaptcha\" value=\"\" class=\"wpcf7-form-control\"><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><span id=\"wpcf7-6ac3fd7b5a203-wrapper\" class=\"wpcf7-form-control-wrap cf7apps-honeypot-wrap email-wrap\" data-cf7apps-honeypot=\"email\" style=\"position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);white-space:nowrap;border:0;\"><input type=\"hidden\" name=\"email-random-hash\" value=\"20261006\"><input type=\"hidden\" name=\"email-time-token\" value=\"MTc5MTIyOTMwNw==.021b5b79a9c8c8d939fdae07d361d64956cdaa2e1dcf84c575ff23d8f18acabb\"><label\r\n\t\t    for=\"wpcf7-6ac3fd7b5a203-field\"\r\n\t\t    class=\"hp-message\"\r\n        >Please leave this field empty.<\/label><input\r\n\t    id=\"wpcf7-6ac3fd7b5a203-field\"\r\n\t    \r\n\t    class=\"wpcf7-form-control wpcf7-text\"\r\n\t    type=\"text\"\r\n\t    name=\"87svgd39br7k\"\r\n\t    value=\"\"\r\n\t    autocomplete=\"new-password\"\r\n\t    tabindex=\"1000\"\r\n\t    data-cf7apps-tabindex=\"1000\"\r\n    \/><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns one-fourth\">\n      <div class=\"field\"><label><\/label><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send\" \/>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div><\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>With our scheduled script each data Source have their Scheduled Import Set to import the data in file attachment to the targeted table. Challenges In ServiceNow, when multiple files attached to the Data Source and Scheduled Data Import executed the first attached file data is imported in the targeted table. Other files are not considered [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":259,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[14],"tags":[],"class_list":["post-211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":10,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":316,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/211\/revisions\/316"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media\/259"}],"wp:attachment":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}