CarolH Posted August 23, 2021 Report Share Posted August 23, 2021 Getting ready to import HIPro 2011 into new HomeManage. Lots of commas in HIP Comments, etc. so, unless I find/replace all commas with something else (probably ";") to get a valid .csv, I'm looking at import from either [1] Excel tab-delimited, or [2] Access. [1] I'm okay on exporting from HIP to Excel, but to get tab-delimited file from Excel, do I select SaveAs > "Text (tab delimited)(*.txt)", then import into HM as Type= .txt and delimiter = tab? [2] If I open hip11.mdb in Access, can t_image, t_attachment and t_inventoryitem (and maybe t_inventoryitemattachment and t_inventoryitemfolder? - don't use insurance fields) be linked so import will include images and attachments for each inventory item? Am going to have to contract for this query to be done, but hoping for input from someone who has successfully done this. [3] Also wondering if better to export/import ALL fields, whether used or not, or keep only used fields? Thanks for any input! admin 1 Quote Link to comment Share on other sites More sharing options...
admin Posted August 25, 2021 Report Share Posted August 25, 2021 On 8/23/2021 at 5:14 PM, CarolH said: [1] I'm okay on exporting from HIP to Excel, but to get tab-delimited file from Excel, do I select SaveAs > "Text (tab delimited)(*.txt)", then import into HM as Type= .txt and delimiter = tab? Hi, that sounds correct to me. If you don't mind emailing your import file we can test and make sure it works ok. Please ZIP and email to techsupport@libertystreet.com On 8/23/2021 at 5:14 PM, CarolH said: 2] If I open hip11.mdb in Access, can t_image, t_attachment and t_inventoryitem (and maybe t_inventoryitemattachment and t_inventoryitemfolder? - don't use insurance fields) be linked so import will include images and attachments for each inventory item? Am going to have to contract for this query to be done, but hoping for input from someone who has successfully done this. You should be able to import images by selecting the destination field: Image 1 (URL or Path of Image) this would only work if t_image is set to the complete path of the image. The other fields can't be imported unfortunately. On 8/23/2021 at 5:14 PM, CarolH said: [3] Also wondering if better to export/import ALL fields, whether used or not, or keep only used fields? Only used fields sounds reasonable Quote Link to comment Share on other sites More sharing options...
CarolH Posted August 25, 2021 Author Report Share Posted August 25, 2021 2 hours ago, admin said: You should be able to import images by selecting the destination field: Image 1 (URL or Path of Image) this would only work if t_image is set to the complete path of the image. The other fields can't be imported unfortunately. Thanks for the input. Further clarification: - Does that mean that only one Image can be imported/attached? If not, how do I import multiple attached Images? - And that Attachments cannot be exported? - Any advantages using Access vs. tab-delimited Excel? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.