How to load data through excel for an existing table in App Studio

Junyu · ‎09-13-2023

Dear all,

Now I have an empty table called "Inquiry Result", I want to load the data through spreadsheet(excel). But in App Studio I can't find such feature for me:

Also when I go into the Load Data module, I can't find my table

So I am confused, where can I load data for my table by uploading excel?

Siva Jyothi M · ‎09-13-2023

Hi @Junyu,

This is the process of importing data to an existing table.

Open the app in App Engine Studio, In the Data section click on 'Add'.

The select Import and map data -- get started -- Name the import and provide the description like below and click continue.

After this you will taken to the below page where you need to select source type and upload the excel

After that in the Map to target, you need to mention the table(existing) where the data needs to be imported.

After the you can either execute the schedule now or you can execute it at any specific time as well.

Please mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.

View solution in original post

RAMANA MURTHY G · ‎09-13-2023

Hello @Junyu , try this method,

Open the app in App Engine Studio, In the Data section click on Add

Select Create a data integration option and select Continue

Enter Name and Short description and click on Continue

This will create data import in your app

select source type as a file and select Excel then upload an excel file from your PC, select configuration (Sheet name and row header) and click on save

Select Map to target from setup steps

Select your target table, and choose checkboxes according to your requirement and click on Save

Click on mapping table

Mapp fields according to your requirements and click on save button

Click on Schedule imports from setup steps and click on Run Import (if you want you can create a schedule here)

Data import is successful now

Hope it will work, please mark my answer as helpful, if it works.

Thank you

Please mark my answer helpful  & correct ✅ if it helps you
Thank you

G Ramana Murthy
ServiceNow Developer

View solution in original post

Tony Chatfield1 · ‎09-13-2023

Hi, in ServiceNow the BAU data import process is via a temporary data table.

Import sets (servicenow.com)

Data Import Process | ServiceNow Developers
If you have not created your temp table and related transform mapping, you can create these by importing a file using the 'Load data' menu module.
When doing this you need to be aware of 2 possible issues.
Windows CSV files have a byte order mark (BOM), that will result in the first field in your data import table having unwanted\unexpected characters in the field name; so it is best not to use a windows csv file for import table creation.
The data size of fields created via file import may be set by system to 40 characters meaning import data (current or future) may be truncated, so if creating fields via file import, you may need to manually check\update field sizes for your import table fields via 'Tables & Columns' before you load valid data.

Siva Jyothi M · ‎09-13-2023

Hi @Junyu,

Open the app in App Engine Studio, In the Data section click on 'Add'.

The select Import and map data -- get started -- Name the import and provide the description.

Follow this docs. This has step by step process mentioned.

Please mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.

Junyu · ‎09-13-2023

Hi @Siva Jyothi M ,

Thanks for your answer, but this method looks like to create a new table. I already have an existing table so I want to upload the data for it. Since we have some varialbes referencing the table.

Siva Jyothi M · ‎09-13-2023

Hi @Junyu,

This is the process of importing data to an existing table.

Open the app in App Engine Studio, In the Data section click on 'Add'.

The select Import and map data -- get started -- Name the import and provide the description like below and click continue.

After this you will taken to the below page where you need to select source type and upload the excel

After that in the Map to target, you need to mention the table(existing) where the data needs to be imported.

After the you can either execute the schedule now or you can execute it at any specific time as well.

Please mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.