CSV to SugarCRM / Datetime & Datetimecombo Formats

ATTENTION: This forum is no longer active. Please navigate to our new support site at https://support.starfishetl.com/
Viewing 1 posts (of 1 total)
visaolive
User - Author
Post count: 9
#1

During a test load of CSV data into SugarCRM, I'm receiving the following error message:

System.Exception: {"error":"invalid_parameter","error_message":"Did not recognize date_entered as a date/time, it looked like 8/24/2007 11:00:47 AM"}
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
at StarfishEngine.StarfishService.PostStageConnector(rowdat& RowData, Stage st)
at StarfishEngine.StarfishService.ExecStage(rowdat& RowData, Stage st)

Questions:

- How can I format this data through Starfish?
- Or, do I need to format this data within my Source first?

Thanks
- Emilio

Comments (1)

Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#2

Hello you can do this formatting in Starfish.. just use a scripted field and a line of code like this:

C#:
object ScriptedField()
{
return Starfish.FormatDate(Starfish.OriginData[DATEFIELD].ToString(),"yyyy-MM-dd HH:mm:ss");
}

VBScript:
Function ScriptedField
ScriptedField=FormatDate("@@ORG:DateField@@", "yyyy-MM-dd HH:mm:ss")
End Function

Log in to post comments
Viewing 1 posts (of 1 total)

Forum Login

Login or sign up for our forums to connect to the user community.

Reply

You must log in to post.

Not a Member? Register.