{"id":611,"date":"2020-06-22T09:57:18","date_gmt":"2020-06-22T07:57:18","guid":{"rendered":"https:\/\/blog.iese.edu\/newsletter-library\/?p=611"},"modified":"2020-06-22T12:47:11","modified_gmt":"2020-06-22T10:47:11","slug":"85-resources-tip","status":"publish","type":"post","link":"https:\/\/blog.iese.edu\/newsletter-library\/85-resources-tip\/","title":{"rendered":"Uploading Companies to SABI"},"content":{"rendered":"

>\u00a0<\/span>Return to the #85 Newsletter<\/span><\/span><\/a><\/em><\/strong><\/p>\n

\n

You can upload companies based on a list of ID numbers to SABI in order to retrieve data from a set of previously defined companies.<\/p>\n

To load companies from an external file based on company ID numbers, you must first prepare the external file to be uploaded, which can either be a text file or a spreadsheet.<\/p>\n

\u2022 Uploading data from a text file.<\/strong><\/p>\n

1. Open your favorite text editor (e.g. notepad).<\/p>\n

2. Type in the list of ID numbers corresponding to the companies you wish to upload.<\/p>\n

3. Each ID number entered must be separated from the others using a consistent separator (e.g. tab, comma, semi-column, etc). It does not matter which you use as long as they are all the same.<\/p>\n

4. Save the file using the file extension corresponding to the ID numbers contained in the file (e.g. for Bvd ID numbers use .bvd, for ISIN numbers use .ISI, etc). The file extension will tell SABI which ID numbers they correspond to when uploading.<\/p>\n

Go to SABI<\/span><\/a><\/strong>, click on \u201cIdentification numbers\u201d and then select the option you are going to use: NIF, BVD ID Numbers or Stock Securities Numbers (ISIN number or stock symbol). Then you have two options:<\/p>\n

1. Click on \u201cLoad from Disk\u201d to upload your file, or<\/p>\n

2. Copy and paste the ID numbers. Separate each entry with a comma or by pressing return. At the end, click on “Search” and \u201cView list of results\u201d.<\/p>\n

\u2022 To upload data from a spreadsheet.<\/strong><\/p>\n

If you have a spreadsheet with many columns of data, one corresponding to company ID numbers, you may directly use this spreadsheet without prior preparation.<\/p>\n

Go to SABI<\/span><\/a><\/strong>, click on \u201cSaved searches\u201d and then select \u201cLoad from disk\u201d and lastly click on \u201cSelect file\u201d. A new window appears where you have to specify the structure of your file (worksheet, field separator, tabulations, lines, variable). Click on the OK button to confirm your selection and upload the ID numbers. A confirmation screen is then brought up showing all the ID numbers that were found and not found.
\nRemember that each line can only contain one ID number.<\/p>\n

Warning: The maximum number of identifiers that can be loaded from a disk is 1 million.<\/p>\n","protected":false},"excerpt":{"rendered":"

>\u00a0Return to the #85 Newsletter You can upload companies based on a list of ID numbers to SABI in order to retrieve data from a set of previously defined companies. To load companies from an external file based on company ID numbers, you must first prepare the external file to be uploaded, which can either be a text file or a spreadsheet. \u2022 Uploading data from a text file. 1…. <\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":168,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94995,94970],"tags":[],"class_list":["post-611","post","type-post","status-publish","format-standard","hentry","category-85-june-2020","category-resources-tip"],"_links":{"self":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/users\/168"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/comments?post=611"}],"version-history":[{"count":7,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/611\/revisions"}],"predecessor-version":[{"id":624,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/posts\/611\/revisions\/624"}],"wp:attachment":[{"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/media?parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/categories?post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.iese.edu\/newsletter-library\/wp-json\/wp\/v2\/tags?post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}