JonathanRoberts
7 years agoQrew Cadet
How do I add records from an Excel file?
I am working on bringing in a tool list from Mastercam into QB. I have formatted a report template that mastercam uses to output the list. the list can be saved in various formats, excel being one.
How could I easily add records using the rows of data from the output? I thought the API importfromcsv would do it but I cant get my head around it. It looks like the value need to be in the call, not a file...? At anoth job we had a software team and a guy made me a program that i could drop the file on and it would prompt me for the parent record id and it would add the records. But I don't even know where to start something like that...?
How could I easily add records using the rows of data from the output? I thought the API importfromcsv would do it but I cant get my head around it. It looks like the value need to be in the call, not a file...? At anoth job we had a software team and a guy made me a program that i could drop the file on and it would prompt me for the parent record id and it would add the records. But I don't even know where to start something like that...?