{"id":121,"date":"2023-12-29T19:01:16","date_gmt":"2023-12-29T10:01:16","guid":{"rendered":"https:\/\/www.fideltech.com\/case-studies\/?p=121"},"modified":"2025-04-14T18:54:51","modified_gmt":"2025-04-14T09:54:51","slug":"importing-csv-file","status":"publish","type":"post","link":"https:\/\/www.fideltech.com\/case-studies\/importing-csv-file\/","title":{"rendered":"Importing CSV file which isn&#8217;t in standard tabular format"},"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-CSV-files-which-isnt-in-standard-tabular-fomrat.jpg&#8221; alt=&#8221;Importing CSV files which aren&#8217;t in standard tabular format&#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 column_structure=&#8221;1_2,1_2&#8243; module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#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;]<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/fCb1ZWWcnII?si=WOs1plSBWrfHiZqd\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#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; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]A leading multinational company uses various software\u2019s and systems which generate reports in different formats. The company needed to implement a ServiceNow &#8211; ITSM platform that could streamline methods for importing all the reports in a standard format.\n\nThey were was looking for a partner to implementation to customize and configure the system. Normally, ServiceNow uses a standard format including sentences while importing data in a table. But with our scheduled script imports data correctly in the same format. The scheduled script is used to import the report and convert them in a standard format.[\/et_pb_text][\/et_pb_column][\/et_pb_row][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;]<h3>Challenges :<\/h3>\n<p>ServiceNow needs standard tabular formatted CSV files to import the data in Service Now tables.<\/p>\n<ul>\n<li>We\u2019ve files from various software and systems that aren&#8217;t in a standard format. Like, first some rows contain the sentences then table data started.<\/li>\n<li>While importing such sort of data and entering it into the ServiceNow table data, it searches for the first header row and it fails to insert the table data.<\/li>\n<\/ul>\n<h3>Solution Provided :<\/h3>\n<ul>\n<li>We have skipped the quality transformation Map via Scheduled Data Import.<\/li>\n<li>We\u2019ve used Scheduled Script to read the particular file and imported the data via script within the Service Now tables.<\/li>\n<\/ul>\n<h3>Result<\/h3>\n<p>The data enter standard CSV format and having tabular data wherever within the file. The script reads it and imports the data correctly. Also, we&#8217;ve supported comma as tab delimitation. Therefore the expected results reflect within the reports.<\/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\/121#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-6ac3fd6f65803\" 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-6ac3fd6f659e3-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=\"MTc5MTIyOTI5NQ==.aec46c234a05b9d1f6b1f50147fa36135106c2990926b14a8d1d2ae3268f6bc8\"><label\r\n\t\t    for=\"wpcf7-6ac3fd6f659e3-field\"\r\n\t\t    class=\"hp-message\"\r\n        >Please leave this field empty.<\/label><input\r\n\t    id=\"wpcf7-6ac3fd6f659e3-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>A leading multinational company uses various software\u2019s and systems which generate reports in different formats. The company needed to implement a ServiceNow &#8211; ITSM platform that could streamline methods for importing all the reports in a standard format. They were was looking for a partner to implementation to customize and configure the system. Normally, ServiceNow [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":256,"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-121","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\/121","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=121"}],"version-history":[{"count":12,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":315,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/121\/revisions\/315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media\/256"}],"wp:attachment":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}