Notice of Maintenance on October 9th. Click here for further details.

How do you import items into a database?

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but  I can not find out where you can import them.

I was trying to merge 2 databases with the database editor, but they have different phase suffixes, and sage support wants us to pay an external consultant in order to do this.

If there is a way to import the items, then I will not need to merge the databases.

Parents
  • 0

    You can copy/paste items from Excel into your database using Database Editor (DBE).  The Excel file has to be in the exact same layout as the layout in DBE.  The easiest way to get that layout is to copy one item line in DBE and paste it into Excel.  That gives the layout so you can move your data into that layout, and then copy the items and paste into an item line in DBE.  It will probably take some trial and error if you haven't done it before.  Note that you only get items (and phases, you can copy/paste phases also).  You don't get any assemblies, formulas, variables, item tables etc. 

Reply
  • 0

    You can copy/paste items from Excel into your database using Database Editor (DBE).  The Excel file has to be in the exact same layout as the layout in DBE.  The easiest way to get that layout is to copy one item line in DBE and paste it into Excel.  That gives the layout so you can move your data into that layout, and then copy the items and paste into an item line in DBE.  It will probably take some trial and error if you haven't done it before.  Note that you only get items (and phases, you can copy/paste phases also).  You don't get any assemblies, formulas, variables, item tables etc. 

Children
  • 0 in reply to Gary Simpson

    You'll also wanna make sure in DBE that you are showing <All Columns> in order to see all the potential/ available information/ and column headings on an item before populating your data into your Excel sheet.  This would include any database level WBS codes you'd like to assign.  This would be 96 columns before any WBS values you have in your system.  And for a sample item you can see the expected values for example TRUE/FALSE and what to do for the date columns.