Hello, I'm attempting to do an import into a new system. it needs to be in this order:
agent_custid, refnum*, last*, first*, address1*, address2, city*, state*, zip*, country, daytime, night, ship_last, ship_first, ship_address1, ship_address2, ship_city, ship_state, ship_zip, ship_country, payinfo, paycvv, paydate, invoicing_list, pkgpart, username, _password
Each field has to have a column, respectively, but only the ones with * need to be populated. The format needs to be either .xls or .csv
I have attempted taking the data from notepad and importing it to excel and saving in an .xls file.
I have attempted copying the data from notepad to excel.
I have attempted using tabs to separate the columns, spaces, commas etc. I can get it to line up in excel just fine;however, when i copy that back to notepad, it doesn't line up in that. I only do this, because the import is failing in the software system that uses the above format. I have attached several files to show you the issue that I'm seeing. you will see the alignment problem in notepad, and i have even made it so they are separated by only commas as well.