IMPORT Problem

If you think that something doesn't work in Aware IM post your message here
Post Reply
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

IMPORT Problem

Post by customaware »

I am trying to IMPORT some data from a CSV file into a BO named EmployeeRAWIMPORT.

I am getting this error....

This is the first column.... I have read the error many times and cannot understand why it would throw an error. Have tried with and without VALIDATION

Invalid description of data column EmployeeRAWIMPORT.EmployeeNumber. It must start with EmployeeRAWIMPORT.


Any ideas would be appreciated.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: IMPORT Problem

Post by Jaymer »

Post a screenshot of the top of the file
As well as copy paste of first few lines
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: IMPORT Problem

Post by Jaymer »

Screen Shot 2018-09-10 at 3.06.01 PM.png
Screen Shot 2018-09-10 at 3.06.01 PM.png (9.76 KiB) Viewed 7011 times
I make a BO with the 1st 5 fields (of the file u sent me) and they imported fine.
All I had checked was "Create record if not found"
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: IMPORT Problem

Post by tford »

Mark,

If you'd like to send the BO and import details to me, I'll be glad to take a look.
Tom - V8.8 build 3137 - MySql / PostGres
customaware
Posts: 2391
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: IMPORT Problem

Post by customaware »

Sorted.

Was a PEBKAC ;-)
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
Post Reply